![](https://d1e4pidl3fu268.cloudfront.net/e08c42a2-89e2-4f53-bf51-3ef4d6fbd8ec/FrontCover.crop_698x524_1,0.preview.png)
![zip, 58.76 KB](https://d1e4pidl3fu268.cloudfront.net/25243278-6adb-409b-b2c0-a8559c2d566e/2021090541.png)
![zip, 1.54 MB](https://d1e4pidl3fu268.cloudfront.net/50844690-b070-4833-aabe-6010e6703e32/2021090542.png)
![zip, 2.17 MB](https://d1e4pidl3fu268.cloudfront.net/07935679-89bb-48ff-a974-0c92734dcd38/2021090539.png)
![zip, 84.31 KB](https://d1e4pidl3fu268.cloudfront.net/b9dee95d-a993-47c9-a073-8df4b668e780/2021090540.png)
This Computer Science Scheme of Work is Lesson 8 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 8 of the 8 lesson course. The objectives for Lesson 8 are:
- Understand what the mail merge system is.
- Understand why it is beneficial when creating multiple documents of similar content.
- Understand how to complete a mail merge between Excel and Word.
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.
Get this resource as part of a bundle and save up to 24%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.