Spreadsheets for GCSE Business (cashflow, break-even, etc)

6 spreadsheet activities to help student understand basic GCSE Business concepts:

1. Skills checker to ensure that students can complete a range of formulae.
2. A simple break-even table that student complete with formulae and then illustrate using a chart.
3. A simple cash flow forecase that students complete with a range of formulae.
4. A more complex spreadsheet where students calculate piece and hourly rate pay to generate a total Gross Pay. Deductions are then removed to give Net Pay.
5. A more complex spreadsheet which enables students to compare different business ideas.
6. A spreadsheet containing market research data that students interpret and analyse using formulae. They then write up a report on their findings.

There’s plenty of work here - probably enough for 3-4 lessons.

Thanks for your interest!