xls Correct Answer: B Reporting Category Internet Searches Benchmark Number 4.04 Standard 04.0 Demonstrate knowledge, and application of information systems to accomplish job objectives and enhance workplace performance. Benchmark Use reference materials such as on-line help, vendor bulletin boards, tutorials, and manuals available for application software. Also Assesses Not Applicable Knowledge/ Performance/Both Both Item Types Performance Task Cognitive Complexity Low Benchmark Clarification Students will use the online tutorials and/or manuals to use and learn new skills. Content Limits Students will use one on-line tutorial, the help window for the program, and a hard copy manual for Microsoft Office 2010. Stimulus Attributes Access to online manuals and tutorials. Response Attributes None Specified Content Focus Software Help Functionality Sample Item To access the Help Function in Microsoft Office, which function key should be tapped? F1 F3 F5 F8 Correct Answer: A
Reporting Category Computer Hardware Benchmark Number 4.06 Standard 04.0 Demonstrate knowledge, skill, and application of information systems to accomplish job objectives and enhance workplace performance. Benchmark Discuss the process of troubleshooting problems with computer hardware peripherals, including input and output devices in the workplace environment. Also Assesses Not Applicable Knowledge/ Performance/Both Both Item Types Selected Response, Performance Task Cognitive Complexity Moderate Benchmark Clarification Students will repair minor computer problems (i.e. virus removal, slow system, hardware replacement, startup problems, and upgrades). Content Limits Limits are for software and external computer issues only. Stimulus Attributes Stimulus attributes should be limited to software and external hardware. Response Attributes None Specified Content parts of the computer Sample Item What is an auxiliary device called that connects to the computer to provide extra capabilities? accessory computer virus CPU peripheral Correct Answer: D Reporting Category Computer Ethics, Copyright and Software Usage Benchmark Number 4.07
Content Focus note-taking, paraphrasing Sample Item Here is a sample of Cornell Notes: Students will research job interview tips. In the summaries area, students should list the ideas for each paragraph. In the notes area, students should list some points to support their summaries. In the conclusion area, students should conclude findings. Rubric: 4 points – all areas have been completed correctly 3 points – two areas have been completed including the conclusion written in student’s own words 2 points – the conclusion is not written in student’s own words 1 point – notes are not organized 0 points – one area completed either summaries or notes Reporting Category Word Processing Software Benchmark Number 6.01
Reporting Category Database and Spreadsheet Applications Benchmark Number 8.08 Standard 08.0 Use database and spreadsheet applications. Benchmark Analyze and organize data through filters, sorting and applying conditional formatting. Also Assesses Not Applicable Knowledge/ Performance/Both Both Item Types Selected Response, Performance Task Cognitive Complexity High Benchmark Clarification Students will sort data using various filters. Students will remove duplicates. Students will group/ungroup data. Content Limits Microsoft Office 2010 Stimulus Attributes Stimulus should include existing data in a spreadsheet to apply conditional formatting and/or data filters. Response Attributes Students will manipulate an existing spreadsheet according to specific criteria. Content Focus Database and spreadsheet specific terminology. Sample Item How can conditional formatting be used in a spreadsheet? to add a chart to add a number format to highlight important information
Reporting Category E-mail Protocol Benchmark Number 14.02 Standard 14.0 Perform e-mail activities. Benchmark Use the Internet to perform e-mail activities, including attaching external files, saving e-mail attachments, viewing mailbox details, establishing appointments, creating contact groups, and sending a meeting to a contact group to communicate in the workplace. Also Assesses Not Applicable Knowledge/ Performance/Both Both Item Selected Response, Performance Task Cognitive Complexity Low Benchmark Clarification Students will be able to use the Internet to perform a variety of including emailing, attaching external files, and saving email attachments.