Spreadsheets - Lesson 2 Charts/Graphs

Lesson Objectives

 - use spreadsheet software to create graphs
 - understand the different types of graph used

Starter

Spreadsheet Wordsearch

Spreadsheet Review - Can you remember all the parts of a spreadsheet?

Main
Working in pairs.... (only one pupil needs to save the file)

Download and Save the following file to your SITES - Spreadsheets folder:

Chart Challenge Spreadsheet



Red Task:
Add the following data to your Chart Challenge file to create a COLUMN ChoGRAPH that compares chocolate bar prices 

Orange Task
Add the following data to your Chart Challenge file to create a LINE GRAPH that compares High and Low temperatures over the year

Green Task
Add the following data to your Chart Challenge file to create a PIE CHART that compares High and Low temperatures over the year

Extension
Try some of the other tasks HERE


Plenary
Play a spreadsheet game - HERE