Year 7 – Spreadsheet Modelling

The spreadsheet and the word processor are two of the most popular and useful applications. The popularity of spreadsheets comes from their ability to carry out mathematical calculations with ease.  Spreadsheets are also widely used in business, science and other areas to create models. A spreadsheet model helps you answer a question, such as ‘How much will it cost me to go to university?’, or predict a likely future outcome, such as, I want to start my own business ‘How much profit could I make?’

In this unit students will engage with a range of hands on activities which cover:

  • Working with cells
  • Cell referencing
  • Font style, size and characteristics
  • Inserting images
  • Formula
  • Functions
  • Goal seek
  • Charts and graphs
  • Sheets
  • Macros