KEY SKILLS LEVEL 3 - Spreadsheets

Spreadsheet workbook 1

This workbook introduces students to setting up a new spreadsheet using Excel. The following skills are covered:

• Basic Formulae - Addition, Subtraction, Multiplication, Division
• Basic Functions - SUM, AVG, MIN, MAX, COUNT
• How to display formulae
• Importance of resizing columns and rows to display data
  

The workbook should be printed out as a class set, given to students during the lesson and collected back at the end to use with other students.

Spreadsheet workbook 2

This workbook introduces students to setting up a new spreadsheet using Excel. The following skills are covered:

• Printing to one sheet only
• Displaying grid lines on printouts
• Displaying column letters and row numbers on printouts
• Inserting name onto printouts
• How to use custom headers/footers
• Changing margins/page orientation
• How to print a certain area of the sheet
• How to hide/unhide columns
• Changing formats e.g. decimal places, currency
• Adding borders
• Sorting data
  

Students should download the ski.xls file to their area. They should then complete workbook 2 before being given a copy of 'ski holiday budget task' to complete.

The workbook should be printed out as a class set, given to students during the lesson and collected back at the end to use with other students.

Spreadsheet workbook 3

This workbook introduces students to setting up a new spreadsheet using Excel. The following skills are covered:

• absolute cell references
• if then formula
  

The workbook should be printed out as a class set, given to students during the lesson and collected back at the end to use with other students.

Spreadsheet workbook 4

This workbook introduces students to setting up a new spreadsheet using Excel. The following skills are covered:

• nested IF formula
• If (OR) formula
• If (AND) formula
  

The workbook should be printed out as a class set, given to students during the lesson and collected back at the end to use with other students.

Spreadsheet workbook 5

This workbook introduces students to setting up a new spreadsheet using Excel. The following skills are covered:

• naming cells
• vlookup
• hlookup
  

The workbook should be printed out as a class set, given to students during the lesson and collected back at the end to use with other students.

Further practice - General Practice - supermarkets

Use this task sheet to give your students further practice at using spreadsheets

Further practice - Absolute Cell References 1

Use this task sheet to give your students further practice at writing an absolute cell reference

Further practice - Absolute Cell References 2

Use this task sheet to give your students further practice at writing an absolute cell reference

Further practice - Absolute Cell References 3

Use this task sheet to give your students further practice at writing an absolute cell reference

Further practice - Conditional Formatting 1

Use this task sheet to give your students an introduction to conditional formatting

Further practice - Conditional Formatting 2

Use this task sheet to give your students further practice at using conditional formatting

Further practice - IF..Then - Budget

Use this task sheet to give your students further practice at writing if...then formulae

Further practice - IF..Then - Discounts

Use this task sheet to give your students further practice at writing if...then formulae

Further practice - IF..Then - Tests

Use this task sheet to give your students further practice at writing if...then formulae

Further practice - IF..Then - If..then, IF(OR), IF(AND)

This task will really challenge your students and give them plenty of practice at writing the different IF..Then statements that might come up on the exam paper.

Answers have been included - unless you are a whizz with nested IFs, you will probably need them.

Further practice - VLookups

Use this task sheet to give your students further practice at using Vlookups

Further practice - VLookups - Class XX

Use this task sheet to give your students further practice at using Vlookups

Further practice - VLookups - Jobs

Use this task sheet to give your students further practice at using Vlookups

Further practice - VLookups - magazines

Use this task sheet to give your students further practice at using Vlookups

Further practice - VLookups - fuel

Use this task sheet to give your students further practice at using Vlookups

Further practice - VLookups - cats

Use this task sheet to give your students further practice at using Vlookups