Introduction to 'What If' Scenarios
Students use spreadsheets to create simple 'what if' scenarios, changing variables to see potential outcomes.
Key Questions
- Analyze how changing one variable in a spreadsheet can impact other calculated values.
- Predict the financial impact of a price increase using a simple 'what if' model.
- Design a basic model to explore different scenarios for a school fundraising event.
National Curriculum Attainment Targets
Suggested Methodologies
Ready to teach this topic?
Generate a complete, classroom-ready active learning mission in seconds.
More in Big Data and Spreadsheet Modeling
Organizing Data in Spreadsheets
Students learn best practices for structuring and organizing data within a spreadsheet for clarity and efficiency.
2 methodologies
Basic Formulae and Cell References
Students use mathematical operators and cell references to perform basic calculations and create dynamic spreadsheets.
2 methodologies
Introduction to Functions: SUM, AVERAGE
Students learn to use common built-in spreadsheet functions like SUM and AVERAGE to automate calculations on ranges of data.
2 methodologies
Data Visualization: Choosing the Right Chart
Students learn to select appropriate chart types (bar, pie, line) to effectively represent different kinds of data.
2 methodologies
Interpreting Data Visualizations
Students practice interpreting information presented in various charts and graphs, identifying trends and drawing conclusions.
2 methodologies