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 Both Knowledge/ Performance/Both Item Types Selected Response, Performance Task Cognitive High Complexity Benchmark Students will sort data using various filters. Clarification 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. Students will manipulate an existing spreadsheet according to specific Response Attributes 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 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
computing_college_careers_item_specs_8209020.docx