|
Advanced Computer Applications |
| STANDARD |
SKILLS and CONCEPTS |
VOCABULARY |
| CAA 1.1 Content Standard: Students demonstrate a comprehensive
understanding of the interactivity and operation of technology systems. |
CAA 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. |
|
| CAA
1.1.2 Select appropriate software for the support of content area learning
such as, sound, graphic, video, current industry-standard applications
suites/operating system, etc. |
|
| CAA
1.1.3 Use the operating system to save, compress, zip/unzip, and backup files
to a hard drive, other drives, or a server. |
compress, zip/unzip |
| CAA
1.1.4 Demonstrate the ability to follow instructions (instructor, text,
manuals, help/on-line help, and/or screen). |
|
| CAA
1.1.5 Compare and contrast the functional relationship between basic hardware
and software systems and their components. |
hardware, software |
| CAA
1.1.6 Apply the organizational concept behind using files and folders for
storing information and organizing files into folders. |
|
| CAA
1.1.7 Demonstrate saving, opening, and finding files using a variety of
different formats. |
|
| CAA
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). |
ROM/RAM |
| CAA
1.1.9 Compare and contrast the many types of technologies used in society. |
|
| CAA 2.1 Content Standard:
Students understand and apply the social, legal, and ethical issues
related to technology use in personal and professional endeavors. |
CAA 2.1.1 Practice
respectful and responsible use of technology through abiding by the
professional practices. |
|
| CAA
2.1.2 Apply the ability to work independently and as a team member (includes
efficient use of time, organization of work, etc.). |
time management |
| CAA
2.1.3 Apply an understanding of plagiarism and fair use; respect copyright
laws of information producers such as authors and artists, including website
developers. Apply an understanding of the interaction and interdependence
between humans and technology. |
plagerism, copyright |
| CAA
2.1.4 Apply an understanding of the interaction and interdependence between
humans and technology. |
|
| CAA
2.1.5 Analyze how changes in technology affect the workplace and society. |
|
| CAA 3.1 Content Standard:
Students apply technology as a means to create business, industry, and
professional tasks |
CAA 3.1.1 Apply a variety of
input technology tools, i.e., speech recognition, hand-writing recognition,
and keying. |
|
| CAA
3.1.2 Apply appropriate handling and use of supplies and equipment. |
|
| CAA
3.1.3 Apply appropriate use of editing tools to meet industry standards. |
|
| CAA
3.1.4 Design hyperlinks between files, sections, programs, and web pages. |
hyperlinks |
| CAA
3.1.5 Plan time lines to complete tasks in allotted time. |
|
| CAA
3.1.6 Save different tasks as a Web Page. |
|
| CAA
3.1.7 Integrate different file types. |
|
| CAA
3.1.8 Attach digital signatures to documents. |
|
| CAA 3.2 Content Standard:
Students use word processing software to create, edit, and publish
industry appropriate documents. |
CAA
3.2.1 Apply advanced word-processing skills by creating a variety of business
and technical documents, i.e., newsletters with mast heads, multi-column
brochures, multi-page books, forms, using wizards, templates, or composition. |
|
| CAA
3.2.2 Apply word-processing formatting skills, i.e., styles, table of
contents. |
|
| CAA
3.2.3 Apply word-processing skills by accessing and editing documents,
including the effective use of editing commands, i.e. dividing page, making
sections. |
editing techniques |
| CAA
3.2.4 Apply advanced word-processing skills in the creation of drawing tables, outlines, mail merge,
creating styles and using go to. |
|
| CAA 3.2.5
Apply table of contents and indexes to reports. |
|
| CAA
3.2.6 Apply word-processing graphic object skills such watermarks, editing
clipart, 3-D, grouping/ungrouping. |
|
| CAA
3.2.7 Apply special features and tools such as protect document, tracking changes, templates, auto text,
auto correct. |
templates |
| CAA
3.2.8 Apply the ability to format a variety of documents that meet
employability standards. |
format |
| CAA
3.2.9 Create, Modify, and distribute forms using various form controls. |
|
| CAA
3.2.10 Create, edit and run macros |
macros |
| CAA
3.2.11 Create and manage master documents and subdocuments. |
|
| CAA
3.2.12 Create cross references. |
|
| CAA 3.3 Content Standard:
Students use spreadsheet software to create, edit, analyze, and
publish industry appropriate files. |
CAA 3.3.1 Use industry
terminology when using spreadsheet software. |
|
| CAA
3.3.2 Create and evaluate formulas, and functions. |
|
| CAA
3.3.3 Create customize formats. |
|
| CAA 3.3.4 Create, edit
and apply templates. |
templates |
| CAA
3.3.5 Link and consolidate data using 3-D references (create workspaces). |
|
| CAA
3.3.6 Create, name, copy, clear, and move ranges. |
|
| CAA
3.3.7 Add group and outline criteria to ranges. |
|
| CAA
3.3.8 Analyze and select spreadsheet advanced formatting features such as
conditional formatting, filtering, and protection. |
|
| CAA
3.3.9 Apply relative, absolute, and mixed cell references in formulas. |
relative, absolute |
| CAA
3.3.10 Copy, move, and verify accuracy of formulas. |
|
| CAA
3.3.11 Create effective charts or graphs which represent relevant data most
effectively. |
|
| CAA
3.3.12 Edit and label chart components such as axis, legends, titles,
datatables. |
x and y axis, legends |
| CAA
3.3.13 Apply advanced features such as naming ranges and using range names in
formulas and printing. |
range of cells |
| CAA
3.3.14 Utilize goal seek and auditing tools, i.e. track, accept, and reject
changes. |
|
| CAA
3.3.15 Create pivot tables and charts. |
pivot |
| CAA
3.3.16 Create, edit, and run command buttons, macros, and macros with buttons |
macos |
| CAA
3.3.17 Utilize database functions i.e. filtering and extracting. |
filtering |
| CAA
3.3.18 Create Extensible Markup Language (XML) Web queries. |
XML |
| CAA
3.3.19 Import and export data to and from spreadsheet. |
|
| CAA
3.3.20 Link and merge worksheets/workbooks. |
|
| CAA
3.3.21 Embed numbers. |
|
| CAA 3.4 Content Standard:
Students use database software to create, edit, analyze, and publish
industry appropriate files. |
CAA 3.4.1 Use
terminology associated with database. |
|
| CAA
3.4.2 Plan, create, and modify multiple database tables in different views. |
|
| CAA
3.4.3 Utilize advanced property features such as input mask and lookup. |
|
| CAA
3.4.4 Import/export data to a new table or database or other software. |
|
| CAA 3.4.5
Compact, repair and encrypt/decrypt database. |
encrypt/decrypt |
| CAA
3.4.6 Design, create, and modify data forms utilizing advanced features i.e.
subforms. |
|
| CAA
3.4.7 Create Combo boxes. |
|
| CAA
3.4.8 Create and use macros and switchboards. |
|
| CAA
3.4.9 Use and understand database splitter. |
|
| CAA
3.4.10 Demonstrate report creation that involves: summary options, calculated controls, and
sub reports. |
|
| CAA
3.4.11 Create and use queries to specify criteria such as calculated fields,
group data, action queries (update and delete data), parameter query, Pivot
tables, pivot charts, aggregate functions and concatenation. |
pivot |
| CAA
3.4.12 Create a database using multiple tables to establish relationship(s)
between tables, referential integrity. |
|
| CAA 3.5 Content
Standard: Students use presentation
software to create, edit, analyze, and publish industry appropriate files. |
CAA 3.5.1 Apply industry
standards in creating and presenting all presentations. |
|
| CAA
3.5.2 Apply advanced presentation software skills by creating,
accessing/retrieving, saving, and printing files. |
|
| CAA
3.5.3 Use views appropriately to create and manipulate presentations—normal,
outline, notes, slide sorter view. |
|
| CAA
3.5.4 Analyze situations and create a customized handout. |
|
| CAA
3.5.5 Use Industry design guidelines to enhance visual presentations. |
|
| CAA
3.5.6 Create a presentation with video, embedded objects, specialized
features i.e. action buttons, links, hyperlinks, record narration, on-line
broadcast, and create a design template. |
|
| CAA
3.5.7 Import relevant data from word processing, spreadsheet, database, and
other presentation files. |
|
| CAA
3.5.8 Create a summary slide. |
|
| CAA
3.5.9 Create a stand-alone version for a CD/DVD (package for CD/DVD). |
|
| CAA
3.5.10 Modify and design templates—master slide, master title slide, master
notes, with customized header/footer. |
|
| CAA
3.5.11 Embed logos or objects for exact placement. |
|
| CAA 3.5.12 Create
an autorun looping presentation. |
|
| CAA
3.5.13 Demonstrate presentation skills by creating well-organized,
audience-appropriate presentations such as informative, entertaining,
instructional, using proper public speaking techniques. |
|
| CAA
3.6 Content Standard: Students will
integrate files within an industry-standard software suite. |
CAA 3.6.1 Demonstrate the
ability to select appropriate software for completing a variety of projects. |
|
| CAA 4.1 Content
Standard: Students use
telecommunications to collaborate, publish, and interact with peers,
teachers, experts, and other audiences. |
CAA
4.1.1 Use telecommunications skills by collaborating and communicating
effectively (using e-mail, e-learning, video conferencing, instant messaging,
chat, blogs, newsgroups, net meetings, etc.) with peers, experts, teachers,
and other audiences. |
blogs |
| CAA
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, etc.). |
hypermedia |
| CAA 5.1 Content
Standard: Students use technology to
access, review, evaluate, and select information from multiple resources for
reporting purposes. |
CAA
5.1.1 Evaluate and select appropriate sources of information (i.e., print,
video, electronic, and human) for a specific research problem or
question. |
|
| CAA
5.1.2 Use advanced searching Technique using Internet/intranet search
engines, directories, biographical dictionaries and thesaurus. |
|
| CAA
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. |
|
| CAA
5.1.4 Use portable document software to read and create pdf files for the
web. |
pdf files |
| CAA 6.1 Content
Standard: Students use technology to
develop strategies for solving problems. |
CAA 6.1.1 Integrate
technology to solve problems and make informed decisions. |
|
| CAA
6.1.2 Analyze a problem from different perspectives using appropriate tools
(e.g., spreadsheets, databases). |
|
| CAA
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. |
|
CAA 7.1 Content
Standard: Students use technology to
take developmentally appropriate tests utilizing audio and/or visual feedback
when necessary.
|
CAA
7.1.1 Take computer-adaptive timed multiple-choice or true/false tests. |
|
| CAA 7.1.2 Take
computer-based narrative tests. |
|
| CAA
7.1.3 Take computer-based tests for topic remediation and support, and use
feedback appropriately for self-assessment. |
|
|
|
|
|
|
|
|
|
|