Digital Information Technology Course Standards
Course Number: 8207310
06.0 Use spreadsheet applications to enhance communication skills.
The student will be able to:
- Manipulate the worksheet by using the ribbon tabs, group settings, importing data/database, manipulating properties, files and folders.
- Create cell data and apply auto fill.
- Format cells and worksheets (e.g., by applying and manipulating cell formats, styles, merging and splitting cells, create row and column titles, hide and unhide column titles, rows and columns, page setup options, and manipulating views/themes).
- Create and analyze formulas and functions (e.g., apply conditional formula logic, name and cell ranges).
- Create and modify charts and images. (e.g., pivot tables).
- Share worksheet data through various system (e.g., email, external media, cloud storage, mail merge).
- Analyze and organize data through filters, sorting and applying conditional formatting. (e.g., macros).
- Interpret data on line graphs, pie charts, diagrams, and tables.