# CTE Resource Center - Verso - Computer Information Systems, Advanced Task/Competency List

CTE Resource Center - Verso

Virginia’s CTE Resource Center

2019/2020 Competency-Based Task/Competency List for Computer Information Systems, Advanced (6613/36 weeks)

Tasks/competencies bordered in blue are considered optional when marked as such; they and/or additional tasks/competencies may be taught at the discretion of the school division. All other tasks are considered essential statewide and are required of all students.

Expand all

Ajax loader

Demonstrating Personal Qualities and Abilities

  1. Demonstrate creativity and innovation.
  2. Demonstrate critical thinking and problem solving.
  3. Demonstrate initiative and self-direction.
  4. Demonstrate integrity.
  5. Demonstrate work ethic.

Demonstrating Interpersonal Skills

  1. Demonstrate conflict-resolution skills.
  2. Demonstrate listening and speaking skills.
  3. Demonstrate respect for diversity.
  4. Demonstrate customer service skills.
  5. Collaborate with team members.

Demonstrating Professional Competencies

  1. Demonstrate big-picture thinking.
  2. Demonstrate career- and life-management skills.
  3. Demonstrate continuous learning and adaptability.
  4. Manage time and resources.
  5. Demonstrate information-literacy skills.
  6. Demonstrate an understanding of information security.
  7. Maintain working knowledge of current information-technology (IT) systems.
  8. Demonstrate proficiency with technologies, tools, and machines common to a specific occupation.
  9. Apply mathematical skills to job-specific tasks.
  10. Demonstrate professionalism.
  11. Demonstrate reading and writing skills.
  12. Demonstrate workplace safety.

Examining All Aspects of an Industry

  1. Examine aspects of planning within an industry/organization.
  2. Examine aspects of management within an industry/organization.
  3. Examine aspects of financial responsibility within an industry/organization.
  4. Examine technical and production skills required of workers within an industry/organization.
  5. Examine principles of technology that underlie an industry/organization.
  6. Examine labor issues related to an industry/organization.
  7. Examine community issues related to an industry/organization.
  8. Examine health, safety, and environmental issues related to an industry/organization.

Addressing Elements of Student Life

  1. Identify the purposes and goals of the student organization.
  2. Explain the benefits and responsibilities of membership in the student organization as a student and in professional/civic organizations as an adult.
  3. Demonstrate leadership skills through participation in student organization activities, such as meetings, programs, and projects.
  4. Identify Internet safety issues and procedures for complying with acceptable use standards.

Exploring Work-Based Learning

  1. Identify the types of work-based learning (WBL) opportunities.
  2. Reflect on lessons learned during the WBL experience.
  3. Explore career opportunities related to the WBL experience.
  4. Participate in a WBL experience, when appropriate.

Using Advanced Word Processing Functions

  1. Compare advanced features of a word processing program to determine the best tools to use for a given task.
  2. Create documents using advanced merge functions.
  3. Produce documents incorporating tables, templates, autocorrect, styles, smart art graphics, and other advanced features.
  4. Create a professional document (e.g., brochure, annual report, newsletter, catalog) demonstrating established principles of design in desktop publishing.
  5. Import text and graphics from other sources (e.g., Internet, CD, DVD, scanner, digital camera, other files).
  6. Integrate a variety of software applications into a word processing document.
  7. Create an online form with a word processing program.

Using Advanced Spreadsheet Functions

  1. Compare features and functions of various spreadsheet programs to determine the best software for an individual’s or organization's needs.
  2. Create a spreadsheet using advanced formatting features and graphics.
  3. Use advanced formulas and functions (e.g., @PMT, @PV, @VLOOKUP, @HLOOKUP, @FV, @COUNT, @COUNTIF, @IF/THEN, relative and absolute referencing).
  4. Use advanced tools (e.g., macros, scenarios, auditing, pivot tables and reports, object linking and embedding).
  5. Create and reformat complex graphs.
  6. Analyze, interpret, and present data.
  7. Sort and filter spreadsheet data.
  8. Import and export data to and from a spreadsheet.
  9. Create templates.
  10. Organize a large workbook with multiple worksheets.
  11. Apply linear programming to optimize spreadsheet results.

Using Advanced Database Functions

  1. Evaluate features of various database programs to determine the best software for an individual’s or organization's needs.
  2. Plan, design, and create a database file with advanced features.
  3. Generate customized reports and forms, using advanced formatting features and graphics.
  4. Create and conduct advanced queries to access information.
  5. Import and export data to and from a database.

Enhancing Multimedia Presentations

  1. Research and organize information to build a multimedia presentation with advanced features.
  2. Plan and build multimedia presentations, using advanced features.
  3. Utilize templates and master slides in the design of presentations.
  4. Enhance multimedia presentation layout, according to principles of effective design.
  5. Enhance a multimedia presentation with advanced features (e.g., color, transitions, animations, timing, backgrounds, graphics, charts, graphs).
  6. Incorporate visual elements (e.g., scanned images, digital photography, video images, streaming, downloadable images from the Internet).
  7. Incorporate audio elements (e.g. music and voice recordings, digital audio [.wav] files, streaming, MIDI interface files).
  8. Integrate a variety of software applications into a multimedia presentation.
  9. Proofread and edit multimedia presentations.
  10. Create handouts and other visuals (e.g., transparencies, speaker's notes, outline, CD/DVD, memory key).
  11. Deliver a multimedia presentation, according to the principles of effective communication.
  12. Critique the clarity and effectiveness of advanced multimedia presentations.

Producing Desktop Published Documents for Print and Electronic Distribution

  1. Gather or create documents and graphics for use in various advanced desktop publishing products, such as flyers, brochures, and newsletters.
  2. Determine appropriate desktop publishing products based upon the purpose of the publication, intended audience, output format, and time and cost constraints.
  3. Apply principles of design, layout, and typography.
  4. Design a layout for ease of readability and attractiveness (e.g., white space, column position and spacing, page margins, graphic text placements).
  5. Enhance appearance of document using desktop features (e.g., graphic boxes, lines, illustrations, images).
  6. Create templates or master pages.
  7. Create a variety of multi-page and multi-column documents in a format appropriate for electronic distribution.
  8. Demonstrate use of keyboard shortcuts.
  9. Incorporate original/imported text, graphics, tables, charts, and audio/visual elements from a variety of sources.
  10. Convert a document to electronic format (e.g., PDF files, XPS format, professional layout).

Designing and Producing Web Pages

  1. Evaluate the various methods of Web page creation (e.g., integrated software packages, Web design software, Internet browsers, programming languages).
  2. Research and organize information for a Web site.
  3. Compare the features and functions associated with the Internet, intranets, and extranets.
  4. Plan and create a Web site, applying design features (e.g., ruled lines, lists, headings, backgrounds, frames, tables).
  5. Apply Web page design features (e.g., ruled lines, lists, headings, background, frames, tables).
  6. Create hypertext links to other pages or sites.
  7. Proofread, edit, and test a Web site for functionality.
  8. Critique a Web site, according to accepted Web design principles.
  9. Develop a plan for posting, updating, and maintaining a Web site.
  10. Describe various methods of publicizing and promoting a new Web site.

Maintaining, Managing, and Troubleshooting Systems

  1. Evaluate workstations, equipment, software, and supplies for design, layout, and purchase.
  2. Maintain and upgrade workstations, equipment, software, and supplies.
  3. Analyze software problems to obtain assistance via electronic and hard-copy references and documentation.
  4. Troubleshoot hardware problems (e.g., proper connections, scanner, printer, speakers, auxiliary drives).
  5. Explore tools (e.g., defragmenter, file compression, scan disk, diagnostic) to manage the operating system.
  6. Demonstrate (or explain) how to install software and customize defaults.
  7. Back up/restore programs and data files.
  8. Investigate advanced desktop configuration techniques (e.g., control panel).
  9. Scan storage devices and equipment for viruses and spyware, and disinfect as needed.
  10. Install peripherals (e.g., scanner, digital camera, fax machine, modem).
  11. Comply with safety and ergonomic precautions associated with computer use.
  12. Compare operating systems (e.g., Windows, Macintosh, Unix, Linux).
  13. Investigate security issues related to Internet technology (e.g., viruses, firewalls, spam, system backup, passwords, wireless devices, data encryption).

Executing Networking Activities

  1. Identify network types and topologies (e.g., LAN, WAN, bus, ring, star).
  2. Identify components of a local area network.
  3. Identify file structures on networks (e.g., folders, directories, subfolders).
  4. Explain the steps to download software/files to a specific workstation.
  5. Identify basic network protocols (e.g., TCP/IP, FTP, Voice over IP).
  6. Explain the importance of network security (e.g., ethics, rights).
  7. Troubleshoot network problems (e.g., understanding network diagnostic tools).

Implementing Programming Activities

  1. Enter, run, and debug a program.
  2. Code an application program using arithmetic functions.
  3. Code an application program using embedded data.
  4. Improve appearance of printed reports.
  5. Design interactive programs.
  6. Write programs to summarize data.
  7. Write programs to subtotal and group print.
  8. Write modular programs.
  9. Write programs using controlled loops.
  10. Implement tables.
  11. Code an application program using sort routine.
  12. Code an application program to display a graphic scene.
  13. Explore the characteristics and uses of artificial intelligence and expert systems.

Exploring Legal and Ethical Issues

  1. Comply with copyright and patent laws pertaining to scanned images and documents, electronic clip art, recorded sounds, recorded and scanned photography, trademarks, and other elements adapted for use in desktop publishing, multimedia, and Web documents.
  2. Analyze situations where scanned/digitized audiovisual elements, documents, and electronic graphs may be used legally but are ethically questionable.
  3. Comply with policies regarding acceptable use of technology.
  4. Investigate computer crime and privacy issues related to Internet technology.
  5. Apply concepts of security, integrity, courtesy, and confidentiality related to information and communication systems and intellectual property.
  6. Investigate the design of Web sites for accessibility and accommodation of special needs (i.e., Americans with Disabilities Act, multilingual).

Preparing for Industry Certification

  1. Describe the process and requirements for obtaining industry certifications related to the Advanced Computer Information Systems course.
  2. Identify testing skills/strategies for a certification examination.
  3. Demonstrate ability to successfully complete selected practice examinations (e.g., practice questions similar to those on certification exams).
  4. Successfully complete an industry certification examination representative of skills learned in this course (e.g., MOS, IC3, NOCTI).

Developing Employability Skills

  1. Explore domestic and international job opportunities (using the Internet, newspapers, and other sources).
  2. Update résumé.
  3. Add representative work samples to portfolio, including résumé format suitable for online posting.
  4. Use electronic sources to research a company in preparation for a job interview.
  5. Participate in a mock interview.
  6. Compose an interview follow-up letter.
  7. Identify criteria for evaluating self-performance.
  8. Prepare a letter of resignation.
  9. Explore career and college options for lifelong learning.
  10. Investigate new and emerging technological trends in the workplace (e.g., video/teleconferencing, workgroup computing, telecommuting, virtual office, voice recognition, electronic calendars and task lists).
  11. Identify potential employment barriers for nontraditional groups and ways to overcome the barriers.