KS3 ICT and Computing Workbooks for Remote Learning These workbooks are used with my Year 8 Computing Unit of work (also on Tes). We can’t use a computer room at the moment so these booklets go with the lessons (booklet 2). They can also be used for remote learning as well. **Booklet 1: **ESafety and ICT Legal Framework Cyberbullying, Online Grooming, Social Media, Sexting, Misinformation, Disinfomation, Hoaxes and Fake News. ICT Legal Framework covers Copyright, Computer Misuse, GDPR, DPA etc. **Booklet 2: **Computing Inside the computer, hardware, software, binary and denary, networking.

GDPR Lesson (General Data Protection Regulation) Lesson Objectives Learn about the General Data Protection Regulations Understand the consequences of breaking the GDPR This lesson takes students through the new GDPR rules, risk areas and explains how companies can comply with the new regulations. This is more of an introduction lesson for Key Stage 3 (could be used for Key Stage 4). Consequences are also briefly covered. Students then answer questions using a test paper to check their learning.

Students will understand the term ‘programming’ whilst using Kodu. Students will use Kodu to create a world and program Kodu to move. Students will then design and create their own game whilst providing evidence. Lesson One-Six Kodu Lesson Seven Revision Lesson Eight Assessment Lesson Nine Feedback and Improvements This unit has a lesson presentation for every lesson that includes a starter activity, main activity and plenary. Resources also include homework, worksheets, helpsheets and an overall assessment sheet that can be used for self, peer and teacher assessment. A full Scheme of Work is also provided. This unit of work is suitable from Years 6-8 depending on ability.

This lesson is split into 2 parts where students look at both health and safety risks when using a computer. Understand the Health and Safety at Work Act 1974 Understand health and safety issues when using a computer whilst suggesting solutions Learn the importance of health and safety when using a computer

KS3 ICT and Computing Workbooks for Remote Learning These workbooks are used with my Year 7 Computing Unit of work (also on Tes). We can’t use a computer room at the moment so these booklets go with the lessons (booklet 2). They can also be used for remote learning as well. Booklet 1: Information Technology and ESafety Cyberbullying, Online Grooming, Social Media, Using Mobile Phones, How to keep you and your computer safe etc Also include a few lessons on the basics of Spreadsheets. **Booklet 2: **Computing Inside the computer, hardware, software, algorithms, flowcharts, pseudocode etc.

Understanding and Using Databases This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7-8). This unit introduces the students to Microsoft Access. It includes 9 lessons that involves students exploring the software whilst understanding the basics. For example students are asked to: Explain what a database is and its uses (give examples) Understand both paper based and electronic databases Design and create a Superhero Database from scratch Add and edit records in the database Ask the database questions in order to search Create different types of queries to search (basic, multiple and Boolean) Produce a report to show evidence of understanding Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.

This unit is a great start to the basics of Computing. Once students have learnt the basics listed in the lessons below they then take two test papers for assessment throughout the unit (test papers and answers provided). An overall assessment checklist is provided for both student and teacher feedback. Please also view my ‘Year 7 Computing’ resources, this Year 8 program is a great follow on. Lesson 1 Computer Systems: how a computer system works, input and output devices Lesson 2 Computer Systems: Hardware (internal and external), Software (applications, systems and utility) Lesson 3 Storage devices and capacity Lesson 4 Binary Code 1 (binary to denary, using the ASCII table) Lesson 5 Binary Code 2 (decoding and problem solving) Lesson 6 Databases (introduction and data entry) Lesson 7 Revision - (produce a revision guide on the above) Lesson 8 Test Paper 1 Assessment Lesson 9 Databases (2) Queries e.g. Boolean Operators Lesson 10 Networks (types of networks and topologies) Lesson 11 Feedback and Improvement Lesson (answers provided to students on PowerPoint). Lesson 12 Revision Lesson 13 Final Cycle Assessment Test Paper 2

This is a 1-2 hour lesson that could be delivered to KS3 or KS4. Students discuss, watch a video and go through the 4 main clauses and penalaties. They are then asked to research further and answer questions relating to the Act.

Using Spreadsheets This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7). This unit introduces the students to Microsoft Excel. It includes 8 lessons that involves students exploring the software whilst understanding the basics. For example students are asked to: Explain what a spreadsheet is and its uses Edit and format an existing spreadsheet Understand and use basic formula and functions Create and label graphs and charts correctly Produce a report to show evidence of understanding Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.

Use the following lessons to get students to plan and design a video first using a storyboard template. Students can then practise using Open Shot through teacher demonstration or using a video tutorial on You Tube. Student then create a video using Open Shot and evaluate for homework.

Using Microsoft Publisher This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7 or 8). This unit introduces the students to Microsoft Publisher. It includes 9 lessons that involves students exploring the software whilst creating different documents. For example students are asked to: Create a poster to advertise their school Create a birthday card using a template Produce a letter to their new pen pal Create a 4 paged leaflet to advertise a Zoo They are also asked to review their learning and can independently produce their own document using templates provided. Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.

Students are asked to follow the Systems Life Cycle to analyse, plan, design, create, test and evaluate a website for The Theme Park. Each lesson as a presentation (left plain so you can add your own background). Students can use the Systems Life Cycle document to carry out all tasks, stretch tasks, homework tasks are also included. I have provided a SOW, overall assessment sheet/checklist and step by step guides for both how to create a website using Serif Web Plus 6. Students are also given a test paper (lesson nine) to check their learning for the unit. Lesson Structure Lesson One Website Evaluation Lesson Two Identify and Analyse Lesson Three Design Lesson Four Design and Prepare Lesson Five Implementation 1 Lesson Six Implementation 2 Lesson Seven Implementation 3 Lesson Eight Testing and Evaluating Lesson Nine Cycle Test Assessment

This KS3 ESafety unit contains 8 lessons with lesson presentations, worksheets, homework, assessment for learning checklist (student, peer and teacher assessment), SOW, keywords sheet with meanings etc. Most lessons have a video that needs to be played for students to watch and then discuss as a class. This unit allows students to identify the dangers of using technology online and through the use of a mobile phone. Students are given up to date facts and statistics. They are also asked to create a leaflet to make the audience aware of the risks whilst suggesting solutions/preventions for each E-Safety area. Lesson Outline: Lesson 1: Cyberbullying Lesson 2: Online Grooming Lesson 3:Social Media Lesson 4: Mobile Phones and Sexting Lesson 5: Keeping you and your computer safe (passwords, fraud, phishing, viruses, spam etc Lesson 6: Revision e.g flash cards, knowledge organiser Lesson 7: Assessment - test paper out of 50 Lesson 8: Feedback and improvements - answers to questions Note: New videos have been added to this unit, please see link in the speaker notes section of the lessons/powerpoints.

**Contains: **8 lessons, overall assessment for learning sheet, Scheme of Work, homework booklet, test and answers etc THIS UNIT CAN BE USED FOR KS3 OR AS AN INTRODUCTION FOR KS4. The aim of this unit is for learners to understand the basics of programming and be able to code using Python. Learners will be taken through a series of 8 lessons that will enhance their knowledge of programming. This will give them a feel for programming and allow them to possibly choose this as an option for their GCSEs. Learners will use Turtle commands to draw basic shapes, use IF statements and loops to create a simple program. Create a computer program which will include an IF and ELSE statement as well as loops. Create a simple test table which carries out three tests and explain and justify good and bad features of my solution.

This Unit is an introduction to Safety Smart (E-Safety). Students also use and practise skills in PowerPoint to evidence their learning. Unit contains lesson presentations, starter tasks and videos for students to watch and discuss the dangers of E-Safety and how to prevent any risks. OVERVIEW OF THE UNIT: Lesson One: Introduction to Safety Smart and general rules Lesson Two: Basic features and tools of Microsoft PowerPoint, continue with safety smart risks and solutions using videos and keywords. Lesson Three: Basic and advanced features and tools of Microsoft PowerPoint, continue with safety smart risks and solutions using videos and keywords. Lesson Four: Understand the risks and solutions of cyber bullying Lesson Five: Understand the risks and solutions predators online Lesson Six: Understand the risks and solutions of social networking Lesson Seven: Understand what malware means and understand what a virus and worm is Lesson Eight: Understand what spam and phishing is

Information Technology Unit includes E-Safety lessons where students have to produce a leaflet to warn the audience of the risks and solutions of cyber bullying, predators, social media etc. Lessons also cover searching on the internet and spreadsheets. Every lesson includes a PowerPoint with resources and some contain videos for discussion. You also will get an overview with the lesson objectives and and overall student/teacher assessment checklist. Two cycle papers with questions and answers are also available. This unit covers lessons for a full term - Cycle One: Information Technology, the lessons are: Lesson 1 Welcome to ICT Lesson 2 ESafety and Cyberbullying Lesson 3 ESafety and Predators Lesson 4 ESafety and Social Networking Lesson 5 ESafety Mobile Phones Lesson 6 Spam and Viruses Lesson 7 Revision Lesson Lesson 8 Cycle One Test Lesson 9 Searching the Internet Lesson 10 Spreadsheets Lesson 11 Cycle Test One (1) Feedback and Revision Lesson Lesson 12 Spreadsheets Lesson 13 Final Revision Lesson 14 Cycle Test Final Assessment

FULL UNIT: Includes lessons for all topics and each task (1-4), revision questions, assessment test papers, homework tasks, Schemes of Work for each task, worksheets - everything you need to deliver the unit. This unit will enable learners to understand pre-production skills used in the creative and digital media sector. It will develop their understanding of the client brief, time frames, deadlines and preparation techniques that form part of the planning and creation process. Planning is an essential part of working in the creative and digital media sector. This unit will enable learners to acquire the underpinning knowledge and skills needed to create digital media products and gain an understanding of their application. On completion of this unit, learners will understand the purpose and uses of a range of pre-production techniques. They will be able to plan pre-production of a creative digital media product to a client brief, and will understand how to review preproduction documents. Learners studying the optional units will be able to apply knowledge and understanding gained in this unit to help develop their skills further during the completion of those units. LO1: Understand the purpose and content of pre-production LO2: Be able to plan pre-production LO3: Be able to produce pre-production documents LO4: Be able to review pre-production documents

Students use ICT to help out the Theme Park Director.

3 lessons for Searching the Internet (can deliver over 4-5 lessons).