Computer Applications
STANDARD	SKILLS and CONCEPTS	VOCABULARY
CA 1.1 Content Standard: Students demonstrate a comprehensive understanding of the interactivity and operation of technology systems.	CA 1.1.1 Select and demonstrate use of industry-standard hardware and emerging technology to complete any given task including academic work, i.e. scanners, digital cameras, digital camcorders, CD/DVDs, keyboard, touch screen, stylus, speech, and handhelds.	PDA
	CA 1.1.2 Select appropriate software for the support of content area learning such as sound, graphic, video, current industry-standard applications and suites/operating systems.
	CA 1.1.3 Use the operating system to save files to a hard drive, other drives, and/or a server.
	CA 1.1.4 Demonstrate the ability to follow instructions (instructor, text, manuals, help/on-line help, and/or screen).
	CA 1.1.5 Compare and contrast the functional relationship between basic hardware and software systems and their components.
	CA 1.1.6 Apply the organizational concept behind using files and folders for storing information and organizing files into folders.
	CA 1.1.7 Demonstrate saving, opening, and finding files using a variety of different formats.
	CA 1.1.8 Compare and contrast the use of and the difference between temporary memory (RAM), permanent memory (ROM), and storage (e.g., digital storage on hard, floppy, and zip disks; flash drives; and optical storage—CD/DVD).	RAM; ROM; Flash/Jump Drives; Optical Storage
	CA 1.1.9 Compare and contrast the many types of technologies used in society.
	CA 1.1.10 Use the operating system with application software i.e. database, spreadsheet, word processing, presentation, desktop publishing software to import images, text, and video/sound.
CA 2.1 Content Standard: Students understand and apply the social, legal, and ethical issues related to technology use in personal and professional endeavors.	CA 2.1.1 Practice respectful and responsible use of technology through abiding by the school technology and Internet use policy.	AUP; Licensing Agreements
	CA 2.1.2 Demonstrate the ability to work independently and as a team member (includes efficient use of time, organization of work, etc.).	Time Management
	CA 2.1.3 Demonstrate an understanding of plagiarism and fair use; respect copyright laws of information producers such as authors and artists, including website developers.
	CA 2.1.4 Demonstrate an understanding of the interaction and interdependence between humans and technology.	Robotics
	CA 2.1.5 Explain how changes in technology affect the workplace and society.
CA 3.1 Content Standard: Students use technology as a tool to increase productivity in completing projects, publications, and other creative works.	CA 3.1.1 Apply a variety of input technology tools, i.e., speech recognition, hand-writing recognition, and keying.
	CA 3.1.2 Demonstrate appropriate handling and use of supplies and equipment.
	CA 3.1.3 Apply appropriate use of editing tools, i.e., spell check, thesaurus, find and replace, grammar, and hyphenation.
	CA 3.1.4 Identify and demonstrate the use, movement, and display of a variety of icons, toolbars, and the task pane.
	CA 3.1.5 Apply and use hyperlinking, i.e. files, sections, and the web.
	CA 3.1.6 Demonstrate time-management to complete tasks in allotted time.
	CA 3.1.7 Preview and print using print options.
CA 3.2 Content Standard: Students use word processing software through a variety of input technologies to create, edit, and publish industry appropriate documents.	CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
	CA 3.2.2 Apply word-processing formatting skills, i.e., fonts, paragraphing, text flow options (widow/orphan), margins, indentations, page orientation, tabulation, breaks, enumeration, bulleting, borders/shading, columns.
	CA 3.2.3 Apply word-processing skills by accessing and editing documents, including the effective use of editing commands, i.e., delete, cut/copy/paste, format painter, undo/redo, repeat, and paste special.
	CA 3.2.4 Apply advanced word-processing skills in the creation of tables, including calculations and special features.
	CA 3.2.5 Apply word-processing skills and style manual usage to cite reference documentation, i.e. bibliography, works cited, footnotes, and endnotes.
	CA 3.2.6 Apply word-processing graphic object skills such as scale, insert, crop, borders, wrap text, autoshapes, fill and line options, shading, text boxes, WordArt.	Crop
	CA 3.2.7 Apply the ability to format a variety of documents that meet employability standards.
CA 3.3 Content Standard: Students use spreadsheet software to create, edit, and publish industry appropriate files.	CA 3.3.1 Identify components of the spreadsheet window using industry terminology and efficiently navigate throughout the worksheets and workbook.	Cell; Macros;Workbook; Worksheet
	CA 3.3.2 Demonstrate creating, opening, saving, renaming, inserting, deleting, retrieving, and closing a worksheets and workbooks.
	CA 3.3.3 Differentiate among and enter text, numbers, formulas, and functions.	Function; If Statements
	CA 3.3.4 Apply editing and enhancement features to cell contents, i.e., edit, fill, rotate, move, merge, size, number formats, 3-D references, alignment, auto formats, sorting, row/column setting and formats, styles, borders and colors.	Merge
	CA 3.3.5 Apply page setup features, i.e., margins, headers/footers, page order, grid lines, repeating row/column titles, comments, shrink-to-fit, page orientation, and center horizontally/vertically.
	CA 3.3.6 Create, insert, modify, position appropriate graphics.
	CA 3.3.7 Create, view, and edit comments.
	CA 3.3.8 Apply freeze rows and columns and window tile.
	CA 3.3.9 Create, enter, and edit formulas using arithmetic expressions and math order of operations.
	CA 3.3.10 Apply and edit functions, i.e. SUM, MIN, MAX, AVE, COUNT, IF, PMT, NOW, FV, PV.
	CA 3.3.11 Apply relative, absolute, and mixed cell references in formulas.	Relative; Absolute
	CA 3.3.12 Copy, move, and verify accuracy of formulas.
	CA 3.3.13 Create effective charts or graphs which represent relevant data most effectively.
	CA 3.3.14 Edit and label chart components such as axis, legends, titles, etc.	Legends; Defining X & Y Axis
	CA 3.3.15 Print charts and graphs in industry standard format on separate sheet or embedded with data.	Embedded
	CA3.3.L1Critical Thinking Activity demonstrating use of functions, absolute addressing, formulas, and formatting
CA 3.4 Content Standard: Students use database software to create, edit, and publish industry appropriate files.	CA 3.4.1 Define and apply basic terminology associated with database design, creation, and use.	Flat vs. Relative Database
	CA 3.4.2 Plan, create, and modify a database table structure using design view.
	CA 3.4.3 Input, edit, and delete data in table.
	CA 3.4.4 Differentiate between and use multiple views.
	CA 3.4.5 Demonstrate database skills by planning/creating a table that includes field properties with or without a primary key; accessing/retrieving; saving; and printing.
	CA 3.4.6 Create a database using multiple tables to establish relationships between tables.
	CA 3.4.7 Demonstrate report creation that involves:  group, sort, wizards, labels, calculated fields, aggregate functions, conditional formatting, concatenation, and format to industry standards.
	CA 3.4.8 Organize and analyze data, i.e., sorting, identifying, finding, filtering, and viewing.
	CA 3.4.9 Create and use queries to specify criteria such as wildcards, comparison operators (Boolean logic), numeric criteria, compound criteria.	Boolean Logic
	CA 3.4.10 Automate database functions using wizards.	Wizards
	CA 3.4.11 Create a database using multiple tables.
	CA3.4.L.1 Critical Thinking Database Application Project
CA 3.5 Content Standard: Students use presentation software to create, edit, and publish industry appropriate files.	CA 3.5.1 Apply industry standards in creating and presenting all presentations.
	CA 3.5.2 Apply presentation software skills by creating, accessing/retrieving, saving, and printing files.
	CA 3.5.3 Use views appropriately to create and manipulate presentations—normal, outline, notes, slide sorter view.
	CA 3.5.4 Use appropriate slide layouts and design templates to create presentations.	Template
	CA 3.5.5 Analyze situations and select the appropriate printing output: handouts, slides, notes page, or outline.
	CA 3.5.6 Use basic design guidelines to enhance visual presentations.
	CA 3.5.7 Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
	CA 3.5.8 Import relevant data from word processing, spreadsheet, database, presentation files.
	CA 3.5.9 Create a summary slide.
	CA 3.5.10 Create a stand-alone version for a CD/DVD (package for CD/DVD).
	CA 3.5.11 Modify and design templates—master slide, master title slide, master notes, header/footer.
	CA 3.5.12 Utilize grids and guides to create logos, placement of objects, etc., for more exact placement.
	CA 3.5.13 Create an autorun looping presentation with message and proper timing.
	CA 3.5.14 Demonstrate presentation skills by creating well-organized, audience-appropriate presentations such as informative, entertaining, instructional, etc., using proper public speaking techniques.
	CA 3.5.15 Navigate an on-screen presentation using keyboard, mouse, pointer options, and other navigational tools.
	CA 3.5.L1 Critical Thinking Application on Internet Ethics	Ethics
CA 3.6 Content Standard: Students integrate software suite products and files to complete business, industry, and professional tasks.	CA 3.6.1 Demonstrate the ability to select appropriate software for completing a variety of projects.
	CA 3.6.2 Demonstrate the ability to integrate files within an industry-standard software suite.
CA 4.1 Content Standard: Students use telecommunications to collaborate, publish, and interact with peers, teachers, experts, and other audiences.	CA 4.1.1 Demonstrate telecommunications skills by collaborating and communicating effectively with peers, experts, teachers, and other audiences, i.e. using e-mail, e-learning, video conferencing, instant messaging, chat, blogs, newsgroups, net meetings,.	Blogs; ISP; Browsers, Search Engines; Metasearches
	CA 4.1.2 Use appropriate technology to plan, develop, edit and present material to different types of audiences, i.e., paper, web page, multimedia presentation, publications, speech, hypermedia.	Hypermedia
CA 5.1 Content Standard: Students use technology to access, review, evaluate, and select information from multiple resources for reporting purposes.	CA 5.1.1  Evaluate and select appropriate sources of information (i.e., print, video, electronic, and human) for a specific research problem or question.
	CA 5.1.2 Demonstrate the ability to use bookmarks and Internet search engines to access information by identifying and conducting basic and advanced searches using Internet/intranet search engines, directories, biographical dictionaries and thesaurus.	Bookmark
	CA 5.1.3 Evaluate and select several resources from a variety of information sources by reviewing each author’s credentials, perspective, or bias; validate the accuracy of information based on multiple audiences.
	CA 5.1.4 Use portable document software to read and create .pdf files for the web.
CA 6.1 Content Standard: Students use technology to develop strategies for solving problems.	CA 6.1.1 Integrate technology to solve problems and make informed decisions.
	CA 6.1.2 Analyze a problem from different perspectives using appropriate tools (e.g., spreadsheets, databases).
	CA 6.1.3 Integrate information and communication technology to analyze a real-world problem, design and implement procedures to monitor information, set timelines, and evaluate progress toward the solution.
CA 7.1 Content Standard: Students use technology to take developmentally appropriate tests utilizing audio and/or visual feedback when necessary.	CA 7.1.1 Take computer-adaptive timed multiple-choice or true/false tests.
	CA 7.1.2 Take computer-based narrative tests.
	CA 7.1.3 Take computer-based tests for topic remediation and support, and use feedback appropriately for self-assessment.