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.

This Computer Science Scheme of Work is Lesson 6 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 6 of the 8 lesson course. The objectives for Lesson 6 are: Understand how to use teacher feedback to improve understanding. Analyse teacher resources to add further detail to your work. 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.

This Computer Science Scheme of Work is Lesson 4 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 4 of the 8 lesson course. The objectives for Lesson 4 are: Understand the term conditional formatting. Understand what data validation is and why we use them. Understand what a VLOOKUP is and the benefits of using them. 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.

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.

This Computer Science Scheme of Work is Lesson 2 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 2 of the 8 lesson course. The objectives for Lesson 2 are: Understand what cell referencing is. Understand what a formula is. Understand what operators are. Understand how create mathematical calculations using formulas and operators. 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.

This Computer Science Scheme of Work is a 6 week project for KS3 students (who have 1 lesson a week). It focuses on text-based programming skills using Python, so is ideally suited for Year 8 students who have completed basic programming in Scratch, Kodu or Flowol. This is lesson 1 of the 6 lesson course. Lesson 1 covers: Learning what Python Programming is Understanding what interactive mode and script mode are Using both modes to create simple programs Looking at syntax errors and being able to interpret error messages Correcting programming errors Lesson 1 is free! The other lessons are available at a low price, and to grab a bargain, select the bundle package. The skills this Scheme of Work covers include: Using Interactive and Script Mode Understanding what a Syntax Errors Using the print Function to output text Being able to create and use variables Using the input Function with user input Understanding about the different data types Using Mathematical Operators Using the int Function Understanding what Selection Statements are Using Comparison Operators with code Understanding what Python Modules are 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. In addition, the Python programs that are part of the varying challenges and tasks are included, reducing teacher time as the resources don’t need to be created. The linked worksheets are provided in Microsoft Publisher. All resources are FULLY editable, so they can be adapted to suit the needs of your students. I would really appreciate your feedback on my work, whether you download the free resource, pay for individually lessons or purchase a bundle. Thank you for reading.