Spreadsheets - Graphs & Charts (ideal for ECDL)

A spreadsheet worksheet that can be easily marked (it self-marks for half of it). Students can mostly work through it independently - it introduces them to the concept of using charts and graphs in Excel. We use it as a lesson prior to the Excel ECDL exam.

There are four tabs at the bottom:
Starter: This follows on from my IF/COUNT/ROUND worksheet (available on TES) to see how much students remember. It self-marks.
Task 1: This checks that students can format a chart and understand the link between the data and what is visually represented.
Task 2: This gives students the opportunity to use modelling to put different values into a table to get the correct graph displayed. It self-marks.
Task 3: This asks students to represent data in specific ways and gives them examples of what the charts should look like so they can self or peer assess. The data is given to them in a table and they are told what should be output. If they can manage this successfully then they should be able to tackle the ECDL exam charts without any problems!

This should take most students 45-60 minutes to complete. It has been tested on a number of mixed-ability classes.