Computer Science: Introduction to Excel [L5]

This Computer Science Scheme of Work is Lesson 5 of a 8 week project for KS3 students (who have 1 lesson a week). It focuses on spreadsheet skills, using Microsoft Excel. It is is ideally suited for Year 8/9 students, although would be a good resource for higher level Year 7 students.

This is lesson 5 of the 8 lesson course. The objectives for Lesson 5 are:

• Understand what images represent various spreadsheet terms.
• Examine an Excel assessment and judge how to complete it.
• Analyse spreadsheet vocabulary and identify how to use the many key terms.

The skills this entire Scheme of Work covers include:

• Excel Basics
• Columns
• Rows
• Cells
• Printing
• Excel formulas
• Creating formulas
• Using operators
• Excel if statement
• Using drag and drop
• Understanding selection
• Conditional Formatting
• Data Validation
• Drop down boxes
• VLOOKUPS
• Advanced Financial Model
• Mail Merge

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

There is an assessment during the SOW. The assessment includes a mark scheme, feedback lesson and a printable feedback sheet.

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 linked worksheets are provided in Microsoft PowerPoint, Publisher and Word and of coruse Microsoft Excel.

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