This Computer Science Scheme of Work is Lesson 9 of a 10 week project for KS3 students (who have 1 lesson a week). It focuses on staying safe online, online dangers and viruses, social engineering, etc, so is ideally suited for Year 7 students. It is a great introductory resource for new Year 7 students. This is lesson 9 of the 10 lesson course. The objectives for Lesson 9 are: Understand how to write your own quiz questions, including multiple choice and short answer. Understand how to write a mark scheme, that includes the answers to your quiz. Feedback a friend on the quality of their quiz, offering them www and ebi comments. The skills this entire Scheme of Work covers include: Online Stranger Danger Cyberbullying Personal Data Social Networking Malware Viruses, Worms Trojan Horses, Spyware Social Engineering Blagging, Phishing Pharming, Shouldering Worksheets (including differentiated tasks) are included, along with three homeworks which are linked to the SOW. There are two assessments during the SOW. The assessments include 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. 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 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 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 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.

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.