02 Spreadsheets


 

Lesson 1

Lesson 2

Lesson 3 & 4

Lesson 5

Lesson 6

Objectives/key skills

To begin to consider why we use spreadsheets.  To consider what functions a spreadsheet programme may have.  To know why and when we may use a spreadsheet in real life. To be produce a fully labelled bar chart.

To be able to successfully input data to a spreadsheet. To be able to produce a fully labelled bar chart. To be able to make amendments to a bar chart to improve the colour of bars, title etc.

To begin to look at other uses for Excel.  To understand how to use formulas on Excel.

To be able to input information on to Excel.

To use the ‘SUM’ function to calculate the total of a set of numbers in a range of cells.

To understand how to extend formulas for a range of sums. To understand budgeting.

To be able to create a column chart using Excel.

To enter the correct formula into Excel.

To calculate the total cost.

To budget to $65.00