A comprehensive unit of work covering operating systems, interfaces, accessibility, and an introduction to utility software. Ideally suited to Year 8, but with enough stretch and challenge activities for Year 9. I have also taught this module to Year 7 with some work removed. The focus on operating systems feeds into J277 GCSE Computer Science; the interface aspects feed into BTEC Level 1/Level 2 Tech Award in Digital Information Technology. This unit of work comprises: Lesson 1: OS Functions PowerPoint: Introduction to different operating systems and their primary functions Worksheet and answer sheet Lesson 2: OS Types PowerPoint: More in-depth look at operating system functions and the difference between different operating systems. Worksheet and answer sheet Lesson 3: User Interfaces PowerPoint: Command Line Interfaces, Graphical User Interfaces (WIMP and Touch-based) Worksheet and answer sheet Lesson 4: Accessibility and Design PowerPoint: How users with different abilities can use computers and the evolution of the interface Worksheet and answer sheet Lesson 5: Utility Software PowerPoint: Introduction to utility software; introduction to compression and defragmentation Worksheet and answer sheet Online defragmentation activity Lesson 6: Recap and Quiz PowerPoint: Recap of unit and link to Quizizz activity This unit has been professionally designed (I’m an ex-graphic designer) and is suitable for delivery by subject and non-subject specialist teachers. Download the complete unit today for less than 60p per lesson!

Complete scheme of work for J277 OCR Computer Science 1.6 Ethical, Legal, Cultural and Environmental Impacts, including PowerPoint for each lesson, two homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following: 1.6.1a - Introduction to topic and Stakeholders 1.6.1b - Ethical issues 1.6.1c - Society 1.6.1d - Cultural issues 1.6.1e - Environmental issues 1.6.1f - Privacy Issues 1.6.1g - Legislation (includes courtroom class activity) 1.6.1h - Software Licenses 2 x Homework sheets (10 marks, plus answer sheet) End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet) All lessons are tried-and-tested. Save yourself hours of work by downloading now. Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!

Complete scheme of work for J277 OCR Computer Science 1.5 Systems Software, including PowerPoint for each lesson, programming activity, homework sheet, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following: 1.5.1a - The purpose of an operating system 1.5.1b - Interfaces, Users, Files 1.5.1c - Memory, Multitasking, Peripherals 1.5.2a - Utility Software 1.5.2b - Encryption, Defragmenting, Compression + Python encryption activity Homework sheet (10 marks, plus answer sheet) End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet) Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!

Complete scheme of work for J277 OCR Computer Science 1.4 Network Security, including PowerPoint for each lesson, homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following: 1.4.1a Forms of Attack Lesson 1.4.1b Social Engineering Lesson 1.4.1c Brute-force Attacks Lesson + Brute-force demo (Python) 1.4.1d Denial of Service Attack Lesson + Overview of AO3 DDoS attack, questions, and mark scheme 1.4.1e Data Interception and Theft Lesson 1.4.1f SQL Injection Lesson + Worksheet + Demo database to hack (Python) 1.4.2a Software Prevention Methods 1.4.2b Prevention Against Hacking 2 x Homework sheets (10 marks each, plus mark sheets) 1 x End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet) Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!

** For use with the end of module tests in my J808 LO1 - LO7 SoW Bundle ** If you do not have the bundle, download it from my TES Shop. Save hours of analysing test data with this complete question-by-question analysis pack. Easy to set up Enter student marks into the spreadsheet Percentages and approximate grade are automatically calculated Colour-coded columns allow at-a-glance analysis of which questions students performed well on A Word mail-merge generates a “What went well” and “Even better if” list for each student which can then be used to provide individual feedback and help to fill knowledge gaps Personalised reports can be printed or emailed directly to students Step-by-step instructions included. April 2021 update: Grade boundaries have been updated. Grades are now stored in a single table rather than multiple nested IF statements. This will make it easier for you to verify and edit grade boundaries and apply them to all test data.

Complete scheme of work for J277 OCR Computer Science 1.3 Networks, including PowerPoint for each lesson, homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following lesson PowerPoints: 1.3.1a Types of Networks 1.3.1b Performance Factors 1.3.1c Client-Server and Peer-to-Peer Models 1.3.1d Networking Hardware 1.3.1e The Internet, plus printable diagram 1.3.1f Star and mesh network Topologies 1.3.2a Wired and Wireless Connections 1.3.2b Encryption 1.3.2c IP and MAC Addressing 1.3.2d Standards and Protocols 1.3.2e The Concept of Layers 2 x Homework sheets (10 marks each, plus mark sheets) 1 x End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet) Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!

Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 7.2.1abc Tables, Text, Referencing, Contents, Indexes Lesson PLUS worksheet 7.2.1d Advanced Mail Merge Lesson PLUS worksheet and example files 7.2.1e Macros Lesson PLUS worksheet 7.2.1fghij More Word Features Lesson 7.2.2abcd Presentation Techniques Lesson PLUS WAGOLL for activity 7.2.2efg Presentation Techniques Lesson 7.2.3a Design Lesson 7.2.3b HTML (Double) Lesson PLUS worksheets and example files 7.2.3b HTML Cheat Sheet 7.2.3c CSS Lesson PLUS example files 7.2.3c WAGOLL Website 7.2.3d Responsive Design Lesson PLUS Responsive HTML and CSS example files 7.2.3e Security Measures Lesson 2 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students Update: a review stated that some tasks were missing. This omission has been fixed and all of the tasks are present. All lessons are tried-and-tested. Save yourself hours of work by downloading now.

Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 6.1.1 Spreadsheets Lesson PLUS supporting files 6.1.2 Databases Lesson 6.2.1 Presentation Software Lesson 6.2.2 Presentation Software Suitability Lesson 6.2.3 Presentation Pros and Cons Lesson 6.3.1 Hardware Requirements Lesson 6.3.2 Software Requirements Lesson 6.3.3 Connectivity Requirements Lesson 3 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.

Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. Database lessons use Microsoft Access. 5.1.1a Spreadsheet Functions Lesson PLUS worksheet and example files 5.1.1b VLOOKUP Lesson PLUS worksheet and example files 5.1.2 Cell Referencing and Importing Lesson PLUS example and solution files 5.1.3 Charts and Tables Lesson PLUS worksheet 5.1.4 What-If Analysis Lesson PLUS worksheet, answer and example files 5.1.5 Macros Lesson PLUS worksheet 5.2.1 Relational database Lesson 5.2.2 Import data from other sources Lesson PLUS worksheet, sample and example files 5.2.3 Data validation Lesson PLUS worksheet, sample and example files 5.2.4 Input Forms Lesson PLUS worksheet, sample and example files 5.2.5 Queries Lesson PLUS worksheet, sample and example files 5.2.6-8 Reports, Security, Exporting Data Lesson plus database file 5.2.x Bringing It All Together – recap lesson incorporating all database learning 5.2.x Mini-project – Mini project Lesson to consolidate learning. WAGOLL included. 2 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.

Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. Aspects of this scheme of work are also suitable for KS3 Computer Science. 4.1.2 Malware Lesson 4.1.3 Social Engineering Lesson 4.1.4 Hacking Lesson 4.1.5 4.1.1 Botnets and DDoS Lesson 4.1.6 Pharming Lesson 4.2.1 Vulnerabilities – Environmental Lesson 4.2.1 Vulnerabilities – Physical Lesson 4.2.1 Vulnerabilities – System Lesson 4.3.1 Impacts of an Attack Lesson 4.3.2 Consequences of an Attack Lesson 4.4.1 - 4.4.3 Prevention Measures Lesson 4.5.1 Legal Protection Lesson PLUS questions worksheet and marking scheme 4.5.2 Ethics and Morals Lesson PLUS “classroom courtroom” activity 4.6 Validity, Reliability and Bias Lesson 4 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.

Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 3.1.1 What is data? Lesson 3.1.2 Data types? Lesson 3.2.1 What is information? Lesson 3.2.2 How data and information are related Lesson 3.3.1-1 Data collection and storage Lesson 3.3.1-2 Data collection and storage Lesson 3.3.2 IT in data collection Lesson 3.4.1 Cloud Storage Lesson 3.4.2 Physical Storage Devices Lesson 3.5.1 Big Data Lesson 3.5.2 Data stores Lesson 3.5.3 Data benefits and drawbacks Lesson 3 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.

Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 2.1 Analysing Project Requirements Lesson and Sample Design Brief 2.2 Mitigating Risks Lesson 2.3.1a Gantt and PERT Charts Lesson PLUS ProjectLibre example file and activities 2.3.1b Spreadsheets Lesson PLUS worksheet and solution files 2.3.2 Critical Path Lesson PLUS Worksheet and solution files 2.3.3 Project Documentation Lesson 2.4.1 Testing (Functionality) Lesson 2.4.2 Testing (Useability) Lesson 2.4.3 Testing (Accessibility) Lesson 2.4.4 Testing (Test Plans) Lesson 4 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.

Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 1.1 Project Life Cycle Lesson 1.2 Iterative Reviews Lesson 1.3 Inputs and Outputs Lesson and Worksheet 1.4 Initial Project Considerations Lesson 1.5.1-2 Planning Tools Lesson 1.5.2-3 Planning Tools and software Lesson 2 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.

When starting Secondary School, Year 7 students suddenly find they have to navigate the school’s vast network. Where are their files? What is a network location? How do they print? How do they open a document? This resource is designed to teach students to navigate the network and print using a fun Digital Treasure Hunt. The provided web page directs them to a file which contains a challenge – solve the challenge, enter the code into the web page, and move on to the next challenge. When all five challenges are completed, they can print a certificate. This resource includes: Digital Treasure Hunt Map (HTML, will run locally on your network) Treasure Hunt Lesson PowerPoint Activity 1: Web research task Activity 2: ASCII table lookup Activity 3: Logic puzzles Activity 4: Binary image encoding Activity 5: Opening a Python file Printable certificate Answer sheet Set up instructions You will need to edit a JavaScript file to personalise the locations of the activity files, but this is a straightforward task and full instructions are provided.

Use SQL to return results of queries on the supplied James Bond movie database (e.g. What is the average IMDB rating of movies directed by John Glen?) The worksheet includes instructions for creating a new database, uploading the SQL file to it, then using SQL to obtain the answers to questions. Students can copy and paste their queries and results into the worksheet, then save or print for marking. SQL commands used: describe, select, count, from, where, group by, like, and, or; and wildcards. The database is a single-table flat database. This is an intermediate-level task, suitable for students who are already familiar with SQL commands and structure. It also assumes that users will be using phpMyAdmin and they have sufficient privileges to create and edit databases. My Year 12 and 13 Computer Science A-Level students enjoyed the lesson, which took around 1 hour for most to complete. Included: SQL file, student worksheet, teacher’s answer sheet.

Mouse Maze is a fun introduction to decomposition, algorithms and iteration (loops). It works well as an extended starter. Print out the simple maze, or distribute the PowerPoint file to students (the mouse icon can be dragged and rotated). They must list the steps required for Mousey to reach the cheese. Decomposition: breaking the problem into smaller steps (i.e. solving the maze) Algorithms: listing the steps to guide Mousey through the maze Iteration: making the algorithm more efficient by repeating parts of it (challenge / extension activity) The download includes: A full set of teacher’s instructions PowerPoint maze for students which can be used electronically or printed out PowerPoint 6 slides showing the task, solution, sections which are repeated, and a more efficient solution. The final slide has definitions of ‘algorithm’ and ‘decomposition’, plus a note to tell students that they have already achieved both during the lesson. Pupils enjoy the activity and it is a great way to introduce the concepts for the first time. I hope you and your pupils enjoy it :)

Add links to other web pages using the <a> tag. Links can be added to headline, paragraph, and list item tags. Please be aware that Weggo! is ‘beta’ software, and some bugs will be present. Weggo! is a free-to-use website with no adverts or logins. I hope you and your students enjoy using Weggo!

Use the IMG tag to add images to your Weggo! HTML page. Images can be hot linked from other online resources, or a small amount of clipart images are supplied. Support for ALT text is included to promote accessibility and search engine-friendly authoring. Please be aware that Weggo! is ‘beta’ software, and some bugs will be present. Weggo! is a free-to-use website with no adverts or logins. I hope you and your students enjoy using Weggo!

Create HTML ordered (numbered) and unordered (bullet-point) lists using Weggo’s unique drag-and-drop editor. The printable PDF shows step-by-step instructions of how to create simple lists. Please be aware that Weggo! is ‘beta’ software, and some bugs will be present. Weggo! is a free-to-use website with no adverts or logins. I hope you and your students enjoy using Weggo!