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 1 of the 6 lesson course. Lesson 1 covers: Understanding what instructions and sequences are Understanding how to order a sequence of instructions in a particular way Looking at how some sequences can be programmed in one way only, and others can be solved in different ways Understanding the basic flowchart symbols (Start/Stop, Delay, Output, directional arrows) Creating basic flowcharts in Flowol Programming a Zebra Crossing and Crossing Patrol 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 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 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.

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.

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 Computer Science Scheme of Work is Lesson 1 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 1 of the 7 lesson course. Lesson 1 covers: Hardware and Software Understanding the differences Recognising devices Creating a poster about Hardware and Software 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: 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 Lesson 1 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 1 of the 7 lesson course. Lesson 1 covers: Understanding how to login to the School Network Creating a structured folder management system Learning to stay safe in the ICT classroom 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: 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 1 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 1 of the 6 lesson course. Lesson 1 covers: Introduction to Scratch Understanding Sprites and Stages Creating your first Sprite Creating your first Stage 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: 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 7 week project for KS3 students (who have 1 lesson a week). It focuses on basic programming skills using Kodu, a 3D games maker which is free to download from Microsoft, so is ideally suited for Year 8 students. This is lesson 1 of the 7 lesson course. Lesson 1 covers: An introduction to Kodu Looking at the user interface and understanding the various control buttons Creating a unique “world” using the UI 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: An introduction to Kodu Looking at the user interface and understanding the various control buttons Creating a unique “world” using the UI Understanding how to program “Kodu” to move in the “world” Creating a sequence of intructions to allow Kodu to move, eat and win Looking at the importance of creating code for automated movement Following instructions to create three automated movement techniques; randomly wander, when see and follow path Adding more advanced features, such as countdown timer, bonus coin and game levels Understanding how to create a unique game using all previous learning and understanding Following a PLC to guide the students with adding as many different game features as possible with their unique game Each lesson begins with objectives and outcomes being introduced to the students. Many of the tasks 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. 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. The linked worksheets are also 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 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 1 of the 5 lesson course. Lesson 1 covers: What the internet is Introducing the World Wide Web (www) Looking at Computer Networks Discussing advantages and disadvantages of computer networks 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: 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 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.

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 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.

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 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 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 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.