OCR Creative iMedia: R081 Pre-Production Skills Lesson 1 This ICT Scheme of Work is a 5 week project for KS4 students (who have 2 lessons a week). This Scheme of Work was created to introduce students to the OCR Creative iMedia course, focusing on the module R081; Pre-Production skills. It focuses on introducing students to this mandatory module, to give them a good overview on many of the principles of R081 while creating engaging and enjoyable lessons, with many practical tasks that need to be completed. It includes a 4 lesson project at the end of the scheme of work, where students can put their understanding to practice, creating various pre-production elements. This is lesson 1 of the 10 lesson course. Lesson 1 covers an introduction to mood boards. The lesson includes examples, an explanation and then a task that the students must complete. 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: Understanding moodboards Looking at mind maps (spider diagrams) Creating and understanding storyboards Focusing on camera angles Looking at different camera shots and focus Learning about scripts Four lesson project 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 Word. 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 individual lessons or purchase a bundle. Thank you for reading.

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 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 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 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 3 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 3 of the 8 lesson course. The objectives for Lesson 3 are: Understand how to use cell references in formulas. Understand how to quickly and efficiently copy formulas. Understand what the if statement is. Understand how to complete mini-tasks to demonstrate understanding. 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 10 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 10 of the 10 lesson course. The objectives for Lesson 10 are: Understand how to use teacher feedback to improve understanding. Analyse teacher resources to add further detail to your work. Examine a poster design and assess how to improve it, without loosing the important message. This lesson focuses on providing feedback to the student regarding their recent Staying Safe Online assessment. All answers are provided in this PowerPoint. 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 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 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 8 of the 10 lesson course. The objectives for Lesson 8 are: Analyse what is meant be social engineering. Explain the terms blagging, phishing and pharming. Be able to identify phishing emails. Understand how to write your own social engineering emails. 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 7 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 7 of the 10 lesson course. The objectives for Lesson 7 are: To revise with a partner and quiz each other about Staying Safe Online. To answer multiple choice questions about Staying Safe Online. To write short answer questions on the dangers of Malware. The lessons includes the Staying Safe Online assessment. 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 6 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 6 of the 10 lesson course. The objectives for Lesson 6 are: Understand what a Flash card is, and the benefits of creating them. State what revision is and why we do it. Describe the many categories and topics of learning from the previous lessons. The purpose of this lesson is to prepare students for the Staying Safe Online Assessment, by teaching them revision techniques and giving them time to hone their skills and improve their knowledge. 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 4 and 5 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 4 and 5 of the 10 lesson course. The objectives for Lesson 4 and 5 are: Understand some of the main dangers to computers. Explain how they can affect computers and the damage they can cause. Discuss ways to prevent these dangers affecting you and your computing device. 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 3 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 3 of the 10 lesson course. The objectives for Lesson 3 are: Explain how people may be cyber bullied. Discuss physical and verbal bullying. Explain the difference between cyber bullying and other forms of bullying and what to do if you are a victim of bullying or see other people being bullied. 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 2 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 2 of the 10 lesson course. The objectives for Lesson 2 are: Identify what is meant by the term “personal data”. Understand how to keep safe whilst using social networking websites. Analyse the risks of posting personal data online. Lesson 2 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: 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 1 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 1 of the 7 lesson course. The objectives for Lesson 1 are: Understand what E-safety means and how it’s important. Understand about the dangers of the internet. Understand about cyberbullying and how to keep yourself safe. 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: 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.