Advanced Spreadsheets in Excel (6 weeks)

This Computer Science Scheme of Work is a 6 week project for KS3 students (who have 1 lesson a week). It focuses on basic, intermediate and advanced skills using Microsoft Excel, so is ideally suited for Year 8 students. The skills this Scheme of Work covers include:

  • Columns, rows and cells
  • Formulas
  • Operators
  • If Statement
  • Copying formulas
  • Conditional formatting
  • Validation
  • Charts and Macros
  • Mail Merge

Each lesson begins with objectives and outcomes being introduced to the students.

Worksheets (including differentiated tasks) are included, along with two homeworks which are linked to the SOW.

There is room for two assessments during the SOW. However these assessments are NOT included (only blank slides are left), due to different schools assessing student work in varying ways. However if you want the assessments linked to this SOW I am more than happy to provide them for free if required, when this SOW is purchased.

The main SOW is generated using Microsoft PowerPoint, and the information appears using basic animations, so students can experience the information one part at a time.

The Excel spreadsheets that are used in the scheme of work are included, reducing teacher time as the resources don’t need to be created.

The linked worksheets are provided in Microsoft Excel and Word.

All resources are FULLY editable, so they can be adapted to suit the needs of your students.

Save for later

About this resource


Created: Jul 20, 2019

Unit of work

zip, 10 MB


Report a problem

Tes Paid Licence

How can I re-use this?