Spreadsheets Lesson Ideas

Worksheet 1

A paper based exercise which could be given to students to check their understanding of spreadsheets during a lesson or as a piece of homework.

Students are given a fill-in-the gaps exercise and then asked to answer some basic questions about spreadsheets.

Worksheet 2

A paper based exercise which could be given to students to check their understanding of spreadsheets during a lesson or as a piece of homework.

Students are asked to design a simple spreadsheet for a school fete.

Worksheet 3

A paper based exercise which could be given to students to check their understanding of spreadsheets during a lesson or as a piece of homework.

Students are asked to design a simple spreadsheet to hold teacher's marks.

Worksheet 4

What am I?

Students are given descriptions related to this topic and asked to identify what is being referred to.

Burgers

This exercise gives students a pre-created spreadsheet and asks they to use it to calculate the nutritional values of a range of foods from a leading burger manufacturer.

This could be used as part of a lesson about spreadsheets or could be left for a cover lesson.

The Disco

This exercise asks students to use Excel to calcualate the cost of setting up a disco.

It starts with simple formulas and then leads them to absolute cell references and IF..Then functions.

This could be used as part of a lesson about spreadsheets or could be left for a cover lesson if your students are reasonably confident with using Excel.

Supermarket Comparisons

This exercise gives students a small list of groceries from four large supermarkets.

They are asked to use Excel to calculate total costs, average, minimum and maximum.

They are also asked to perform simple formatting on the spreadsheet.

This could be used as part of a lesson about spreadsheets or could be left for a cover lesson.

Skiing

Another chance for students to practice their spreadsheet skills

Ringtones

This exercise gives students a chance to practice further Excel skills.