Big Data and Spreadsheet Modeling · Data & Analysis

Formulae and Functions

Using mathematical operators and built in functions to automate calculations in large tables.

Key Questions

  1. 1How do cell references allow us to create dynamic and flexible models?
  2. 2What are the risks of relying on automated calculations without manual verification?
  3. 3How would you structure a spreadsheet to handle data from a school wide survey?

National Curriculum Attainment Targets

KS2: Computing - Data HandlingKS2: Computing - Information Technology
Year: Year 6
Subject: Computing
Unit: Big Data and Spreadsheet Modeling
Period: Data & Analysis

Suggested Methodologies

Ready to teach this topic?

Generate a complete, classroom-ready active learning mission in seconds.

Generate a Custom MissionBrowse Lesson Plan Templates

More in Big Data and Spreadsheet Modeling

Data Visualization and Interpretation

Selecting and creating appropriate charts to identify trends and tell stories with data.

2 methodologies

Predictive Modeling

Using data to create 'what if' scenarios and predict future outcomes.

2 methodologies

Browse curriculum by country

AmericasUSCAMXCLCOBR
EuropeUKIEFRDEESITNLPTSE
Asia & PacificINSGAU