OVERVIEW

Students will learn to model data with a spreadsheet. The unit progress learners from using basic formulas to writing their own COUNTIF statements.

ACADEMIC LITERACY

• Cell references

• Autofill tool

• Format data

• Create formulas for add, subtract, divide, and multiply

• Create functions for SUM, COUNTA, AVERAGE, MIN, MAX, and COUNTIF

• Sort and filter data

• Create graphs

• Use conditional formatting

CAREERS

Accountancy, Finance, Administration

SAFEGUARDING

Spreadsheets used to store data. Sensitive data must be kept secure. 

PERSONAL DEVELOPMENT

Students look at how technology can bring rapid benefits to real life problems and situations Modeling data (eg/Shopping list) Reflection on how computers can sometimes perform better in certain activities than people.

DIVERSITY

• How can this impact on the people in the country and form larger skills gaps.

CULTURAL CAPITAL

• IT literacy life skills.

KNOWLEDGE TRANSFER

• Mathematics. Formulas, Functions, Equations. Common symbols operators.