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 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 7 of a 7 week project for KS3 students (who have 1 lesson a week). It focuses on an introduction to Computer Science, so is ideally suited for Year 7 students. It is a great introductory resource into Computer Science for Year 7 students. This is lesson 7 of the 7 lesson course. Lesson 7 covers: The CPU The Fetch, Decode, Execute cycle Information, at KS3 level, of the functions of the FDE cycle A practical task showing students the concept of the FDE cycle Lesson 7 is being sold at a low price. To grab a bargain, select the bundle package for the entire SOW! The skills this entire Scheme of Work covers include: Hardware and Software Input, Output and Storage Devices Secondary Storage (Magnetic, Optical and Solid State) Primary Storage (RAM and ROM) Internal Components of a PC (PSU, CPU, Motherboard, Heat Sink, RAM, ROM and the Hard drive) Fetch, Decode and Execute cycle 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. 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. 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.

This Computer Science Scheme of Work is a 5 week project for KS3 students (who have 1 lesson a week). It focuses on introducing computing communications, such as the internet, the world wide web, computer networks, etc, so is ideally suited for Year 8 students. This is lesson 2 of the 5 lesson course. Lesson 2 covers: Understand Wired and Wireless devices Looking at computer hardware that is required to create a network Analysing how devices communicate in a home Lesson 2 is being sold at a low price. To grab a bargain, select the bundle package for the entire SOW! The skills this Scheme of Work covers include: What the internet is Introducing the World Wide Web (www) Looking at Computer Networks Discussing advantages and disadvantages of computer networks Understand Wired and Wireless devices Looking at computer hardware that is required to create a network Analysing how devices communicate in a home Looking at the cabling system that spans the world Understanding the term bandwidth Comparing upload and download speeds Looking at how fibre optic replaced copper cabling Analysing what buffering is, why it happens and why it is so annoying Understanding the term topology Comparing standalone to networked computers Looking at LAN and WAN Studying Bus, Ring and Star topologies Analysing a client server and peer-to-peer network Looking at the advantages and disadvantages of each system Understanding about cloud computing 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. 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.

This Computer Science Scheme of Work is Lesson 5 and 6 of a 7 week project for KS3 students (who have 1 lesson a week). It focuses on basic ICT skills, so is ideally suited for Year 7 students. It is a great introductory resource for new Year 7 students. This is lesson 5 and 6 of the 7 lesson course. Lesson 5 and 6 covers: What E-Safety is Understanding how to stay safe on the Internet Looking at recognising Stranger Danger and Cyberbullying Lesson 5 and 6 is being sold at a low price. To grab a bargain, select the bundle package for the entire SOW! The skills this entire Scheme of Work covers include: Logging into the School Network Deciding class rules Creating folders Staying safe in the ICT Classroom Keyboard Shortcuts Skills using Microsoft Word Skills using Microsoft PowerPoint Staying Safe Online Cyber Bullying Skills using Microsoft Publisher Using Technology securely (Passwords, Emails, Viruses) 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. 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 5 and 6 of a 6 week project for KS3 students (who have 1 lesson a week). It focuses on basic programming skills using Scratch, so is ideally suited for Year 7 students. It is a great introductory resource into Computer Programming for Year 7 students. This is lesson 5 and 6 of the 6 lesson course. Lesson 5 and 6 covers: Creating a unique game Providing ideas and inspiration to students Including guides for sprite and stage design A PLC for students to refer to for game complexity Lesson 5 and 6 are being sold at a low price. To grab a bargain, select the bundle package for the entire SOW! The skills this entire Scheme of Work covers include: Understanding the Command Blocks Using Sprites (importing, editing and creating) Using Stages (importing, editing and creating) Programming movement algorithms Programming automatic costume change Using Forever loops Using Repeat Until loops Programming variables Using operators with variables Programming Random movement Broadcasting instructions 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. The linked worksheets are provided in Microsoft PowerPoint, Publisher and Word. In addition, ALL Scratch games that are used in teacher demonstrations and student tasks are included for your information. 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.

This Computer Science Scheme of Work is a 6 week project for KS3 students (who have 1 lesson a week). It focuses on basic programming skills using Flowol, so is ideally suited for Year 8 students. This is lesson 6 of the 6 lesson course. Lesson 6 covers: Understanding Variables and Subroutines Adapting the pelican crossing to use a subroutine to simplify the program Programming a Car park using Subroutines and Variables Analysing how variables can be used to “count” and the advantages this could have in many scenarios Lesson 6 is being sold at a low price. To grab a bargain, select the bundle package for the entire SOW! The skills this Scheme of Work covers include: Understanding what instructions and sequences are Understanding the basic flowchart symbols (Start/Stop, Delay, Output, directional arrows) Creating basic flowcharts in Flowol Programming a Zebra Crossing and Crossing Patrol Understanding the correct sequence of traffic lights Programming Traffic Lights Understanding the Decision Symbol Using the Decision symbol in the Pelican Crossing Learning about Sensors and how they’re linked to decision Programming an Automatic Greenhouse (based on sensors) Understanding Variables and Subroutines Programming a Car park using Subroutines and Variables 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 Flowol programs that are part of the varying challenges 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.

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 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 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 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 5 week project for KS3 students (who have 1 lesson a week). It focuses on basic website development using HTML, so is ideally suited for Year 7 students. This is lesson 1 of the 5 lesson course. Lesson 1 covers: What is HTML Writing and understanding the Basic Structure Opening the website in editable form Understanding the Body section Using the P tag (paragraphs) Lesson 1 is free! The other lessons are available at a low price, and to grab a bargain, select the bundle package. The skills and learning this Scheme of Work covers include: What is HTML Writing and understanding the Basic Structure Opening the website in editable form Understanding the Body section Using the P tag (paragraphs) Using the H1, H2 etc tags (headers) Using the UL and LI tags (bullet points) Using the OL and LI tags (numbered list) Using the IMG SRC tags to import images Editing images by changing their width Using the style tag in the head section (colours, fonts, etc) Inserting scrolling marquees Creating website hyperlinks 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 Publisher. Step-by-step instructions are included for the students (and teacher) which detail exactly how to create websites in HTML. This SOW can be used by students (and teachers) who have little or no experience of programming. In addition, the HTML websites that are used in the step-by-step guides 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.

This ICT Scheme of Work is a 6 week project for KS3 students (who have 1 lesson a week). It focuses on graphical manipulation and animation using Adobe Photoshop and Flash so is ideally suited for Year 8 students, although no prior knowledge is required as this SOW provides detailed step-by-step instructions on all the tasks. This is lesson ? of the 6 lesson course. Lesson ? covers: Creating a unique image using the skills and understanding from this lesson 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 pixels, resolution and pixilation Looking at aspect ratio and the importance of maintaining it Learning about Photoshop layers and how they are used to create complex images Looking at the Magic wand tool Understanding brightness, contrast, hue, saturation and colour balance Mini project: Creating a unique image using all the skills from the previous lessons Understanding what animation is Looking at Flash layers and how locking and hidng them helps Understanding how to create basic shapes in Flash Analysing the different tweening techniques and understanding what they are Understanding what backdrops are Each lesson begins with objectives and outcomes being introduced to the students. All tasks, whether in Photoshop or Flash, include detailed step-by-step instructions. Teachers can demonstrate the process themselves and then allow the students to use the step-by-step guides to complete the challenges themselves. Extension resources are available throughout the lessons to support the more capable student. Worksheets (including differentiated tasks) are included, along with two homework’s 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 Photoshop and Flash files that are part of the varying challenges and tasks (as well as the demonstrations) 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 individual lessons or purchase a bundle. Thank you for reading.

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.