advanced apps to complete

April-May

Advanced computer apps to complete

6) Gather relevant information from multiple authoritative print and digital sources, assessing the strengths and limitations of each source, and integrate the source accurately into the document using citations, references, and footnotes. Select appropriate notation formatting for a given style, such as Modern Language Association (MLA), American Psychological Association (APA), or the Chicago Manual of Style. a. Integrate information into the text selectively to maintain the flow of ideas, avoid plagiarism, and over-reliance on any one source

b. Insert, manage the locations, and auto-update endnotes, footnotes, citations, and bibliographies following a standard format

c. Add and modify the font, format, location, and position of captions

Spreadsheet Applications

8) Building on standards from Computer Applications, use a spreadsheet application to create and manage worksheets and workbooks for business functions such as invoices, financial statements, data review and summarization, and statistical analysis.

9) Given a specific document purpose, accurately create cells and ranges to effectively manage data, draw conclusions from analysis, and structure for ease of readability. a. Insert, review, and append data in cells and ranges using find and replace, copy and paste, AutoFill, expanding data across cells, and inserting and deleting cells

b. Format cells and ranges for a given purpose, including merging cells, modifying alignment, font, wrap-text, and indentation and employing WordArt and number formatting when appropriate

c. Order and group cells and ranges by applying conditional formatting, inserting sparklines, transposing columns and rows, creating named ranges, inserting subtotals, and collapsing groups of data

10) Translate quantitative or technical information between text, visuals, data, and equations by accurately creating and using tables. a. Effectively navigate between tables and ranges, adding or removing cells and defining titles

b. Modify styles and format of a table to convey meaning, including applying styles, banding rows and columns, and inserting totals or averages

c. Filter and sort information effectively, including filtering records, sorting data on multiple columns, changing sort order to highlight specific information, and removing duplicates to enhance analysis

11) Accurately determine appropriate calculations (formulas and functions) for analysis to draw conclusions about sets of data, including: a. Utilize cell range and references (relative, mixed, absolute) to complete functions accurately based on specific question sought to address, including accurate understanding of order of operations

b. Summarize data with functions such as sum, average, minimum, maximum, and count

c. Utilize conditional logic in functions (if-then statements) to accurately discriminate data for analysis

d. Format and modify text with functions

12) Analyze needed structure and objects (such as charts and graphs) to convey particular meaning or draw conclusions from a dataset.

a. Create charts and graphs that summarize appropriate data series, including differentiating between rows and columns in source data

b. Format charts and graphs by modifying legends, sizes, parameters, layouts and styles and positioning

c. Insert and format an object (such as a textbox, SmartArt or image) and format its border, positioning, properties, styles and effects and colors

Presentation Software

15) Create slide content that is clear and coherent, in which the development, organization, and style are appropriate to a given task, purpose, and audience, including: a. Insert and format text such as WordArt, columns, hyperlinks, and bulleted and numbered lists

b. Insert and format tables and charts, including modifying rows, columns, and legends, applying styles, modifying parameters and importing from external sources

c. Insert and format SmartArt and images, including adding shapes, changing colors, adding and moving text, resize, crop, and apply styles

d. Insert and format appropriate media, including video and audio clips, by adjusting window size, setting start/stop times, setting options, and linking to external sources

16) Effectively employ transitions and animations to convey meaning without distracting from slide content. a. Insert transitions between slides, manage multiple transitions, and modify transition effect options

b. Animate slide content including applying animations to shapes and paths and modifying animation properties

c. Set timings for transitions and animations to ensure appropriate duration, order, and start/stop times for effects

17) Develop, manage, and strengthen content by planning, revising, and editing presentations, including: a. Merge content from multiple presentations and reuse appropriate slides with separate or similar formatting

b. Track changes and resolve differences (such as discarding changes or managing comments) to focus on what is most significant for a specific purpose and audience

c. Protect and share presentations using encryption, passwords, media compression, and permissions, while ensuring accessibility and compatibility are maintained for a given situation or scenario

Information Management & Integration

18) Throughout the course, conduct a sustained research project to answer a question or solve a problem. Synthesize research into an argument that is established, developed, and supported with multiple sources of data and evidence. Demonstrate authentic technical skills in word processing, presentations, and spreadsheet applications, effectively combining functionality of multiple software applications to present a coherent final project, including a report (with imported data, appendixes, etc.) and presentation with appropriate citations from text. Use selected technology to produce, publish, and update final projects.

19) Select a historical event, scientific procedure, or technical process to narrate in a comprehensive report and presentation, practicing effective word processing, spreadsheet, and presentation skills. Develop and strengthen writing and data organization through planning, revising, peer-review, editing, and rewriting throughout the course.

a. Create new workbooks from blank worksheets, templates, imported and non-native files

b. Navigate through existing workbooks by searching for specific data, inserting hyperlinks, changing worksheet order and using “Go To” and “Name Box” functions

c. Format worksheets and workbooks using colors, page setup options, columns and rows, themes, watermarks, headers and footers, and setting data validation

d. Customize options and views for workbooks, including hiding columns, rows, and worksheets, editing toolbars, ribbons, and macros, freezing panes and utilizing short cut keys

e. Configure worksheets and workbooks for effective printing and saving, including setting print area, changing file formats, setting print scaling, and maintaining backwards compatibility if needed

Page 5

a. Create charts and graphs that summarize appropriate data series, including differentiating between rows and columns in source data

b. Format charts and graphs by modifying legends, sizes, parameters, layouts and styles and positioning

c. Insert and format an object (such as a textbox, SmartArt or image) and format its border, positioning, properties, styles and effects and colors

15) Create slide content that is clear and coherent, in which the development, organization, and style are appropriate to a given task, purpose, and audience, including: a. Insert and format text such as WordArt, columns, hyperlinks, and bulleted and numbered lists

b. Insert and format tables and charts, including modifying rows, columns, and legends, applying styles, modifying parameters and importing from external sources

c. Insert and format SmartArt and images, including adding shapes, changing colors, adding and moving text, resize, crop, and apply styles

d. Insert and format appropriate media, including video and audio clips, by adjusting window size, setting start/stop times, setting options, and linking to external sources

Page 6

16) Effectively employ transitions and animations to convey meaning without distracting from slide content. a. Insert transitions between slides, manage multiple transitions, and modify transition effect options

b. Animate slide content including applying animations to shapes and paths and modifying animation properties

c. Set timings for transitions and animations to ensure appropriate duration, order, and start/stop times for effects

17) Develop, manage, and strengthen content by planning, revising, and editing presentations, including: a. Merge content from multiple presentations and reuse appropriate slides with separate or similar formatting

b. Track changes and resolve differences (such as discarding changes or managing comments) to focus on what is most significant for a specific purpose and audience

c. Protect and share presentations using encryption, passwords, media compression, and permissions, while ensuring accessibility and compatibility are maintained for a given situation or scenario

Information Management & Integration

18) Throughout the course, conduct a sustained research project to answer a question or solve a problem. Synthesize research into an argument that is established, developed, and supported with multiple sources of data and evidence. Demonstrate authentic technical skills in word processing, presentations, and spreadsheet applications, effectively combining functionality of multiple software applications to present a coherent final project, including a report (with imported data, appendixes, etc.) and presentation with appropriate citations from text. Use selected technology to produce, publish, and update final projects.

19) Select a historical event, scientific procedure, or technical process to narrate in a comprehensive report and presentation, practicing effective word processing, spreadsheet, and presentation skills. Develop and strengthen writing and data organization through planning, revising, peer-review, editing, and rewriting throughout the course.

Page 6

16) Effectively employ transitions and animations to convey meaning without distracting from slide content. a. Insert transitions between slides, manage multiple transitions, and modify transition effect options

b. Animate slide content including applying animations to shapes and paths and modifying animation properties

c. Set timings for transitions and animations to ensure appropriate duration, order, and start/stop times for effects

17) Develop, manage, and strengthen content by planning, revising, and editing presentations, including: a. Merge content from multiple presentations and reuse appropriate slides with separate or similar formatting

b. Track changes and resolve differences (such as discarding changes or managing comments) to focus on what is most significant for a specific purpose and audience

c. Protect and share presentations using encryption, passwords, media compression, and permissions, while ensuring accessibility and compatibility are maintained for a given situation or scenario

Information Management & Integration

18) Throughout the course, conduct a sustained research project to answer a question or solve a problem. Synthesize research into an argument that is established, developed, and supported with multiple sources of data and evidence. Demonstrate authentic technical skills in word processing, presentations, and spreadsheet applications, effectively combining functionality of multiple software applications to present a coherent final project, including a report (with imported data, appendixes, etc.) and presentation with appropriate citations from text. Use selected technology to produce, publish, and update final projects.

19) Select a historical event, scientific procedure, or technical process to narrate in a comprehensive report and presentation, practicing effective word processing, spreadsheet, and presentation skills. Develop and strengthen writing and data organization through planning, revising, peer-review, editing, and rewriting throughout the course.

Note: Teachers who want to provide additional training in database operations and/or additional software applications (such as email platforms), may add to these standards to create an honors or two-credit course. For additional recommendations on this option, please reach out to the cluster consultant.

Standards Alignment Notes

References to other standards include:

• P21: Partnership for 21st Century Skills Framework for 21st Century Learning o Note: While not all standards are specifically aligned, teachers will find the framework helpful for setting expectations for student behavior in their classroom and practicing specific career readiness skills.