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 Lesson 1 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 1 of the 8 lesson course. The objectives for Lesson 1 are: Understand what Microsoft Excel is. Understand the difference between columns and rows. Understand what a cell is. Understand how to alter (edit) the appearance of cells. 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 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 7 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 7 of the 8 lesson course. The objectives for Lesson 7 are: Understand what a computerised chart is and how to create them. Understand why it is beneficial to display data in a graphical format. Understand how to program macros and use them to automate actions. 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.