The ICT Spreadsheet Essentials course focuses on fundamentals of creating and using spreadsheets. Students will learn about the purpose of spreadsheets, and they will identify spreadsheet elements. They will learn how to insert, format, copy, and move cell data, and format columns and rows. They will also create tables and charts, and modify chart elements according to the spreadsheet data. Finally, they will be introduced to functions, formulas, and conditional formatting.
After completing the ICT Spreadsheet Essentials course, students will be able to:
- Develop and apply fundamental spreadsheet skills, including identifying spreadsheet elements, navigating spreadsheets, inserting various data types, copying and moving data, formatting cells, sorting and filtering data, inserting and resizing columns and rows, merging cells, and applying shading and borders.
- Demonstrate proficiency in using moderately complex spreadsheet tools such as tables and charts, including table ranges, creating tables, identifying chart types and components, creating charts, and modifying chart types to represent base data.
- Demonstrate proficiency in using complex spreadsheet tools such as formulas and functions, including using spreadsheet functions, inserting common spreadsheet formulas, absolute vs. relative cell references, and conditional formatting.