Building on the learning from Information Technology 1, this module will provide students with a deeper understanding of the capabilities and functionalities of spreadsheets for data analysis.
*Curricular information is subject to change
Visual analysis without calculations
Conditional formatting Charts Pivot Tables
Calculations with Formulas and Functions
Use Basic Formulas and FunctionsUse Basic FormulasUse Absolute and Mixed ReferencesUsing Formulas Across WorksheetsCalculate with the SUM FunctionUse the MIN and MAX FunctionsUse the COUNT FunctionsUse the AVERAGE Functions
Use Conditional Functions
Use the IF FunctionUse the SUMIF Function Use the AVERAGEIF Function Use the COUNTIF Function
What IF analysis
Scenario managerGoal SeekSolver
Module Content & Assessment | |
---|---|
Assessment Breakdown | % |
Formal Examination | 100 |