51ºÚÁÏ

Introducing Cambridge Advanced Nationals (AAQs) in IT F200 Fundamentals of Data Analysis EXAM UNIT Topic 2 Legal Considerations FULL TOPIC All the lessons you will need to cover: 4.1 Legislation and the role of the ICO when using data Computer Misuse Act 1990 Freedom of Information Act 2000 Privacy and Electronic Communications Regulations Data Protection Act 2018 General Data Protection Regulations 2018 Independent Bodies ICO Resources include lessons worksheets, quizzes with questions and answers, flashcards, tasks. There is also a student checklist.

AAQ IT Unit F200 Fundamentals of Data Analytics AFL Checklists Topic 1-5 Checklists for all 5 topics: Topic Area 1: Understanding data Topic Area 2: Managing data Topic Area 3: How data can be accessed and managed across platforms Topic Area 4: Legal considerations Topic Area 5: Job roles, skills and attributes in data analytics

AAQs IT Unit F201 Big Data and Machine Learning AFL Checklists Topics 1-5 Checklists for all 5 topics: Topic Area 1: The scope of managing big data Topic Area 2: The infrastructure challenges of big data Topic Area 3: Big data, machine learning and artificial intelligence Topic Area 4: Legal and ethical issues in data management Topic Area 5: Environment and society

Introducing Cambridge Advanced Nationals (AAQs) in IT F200 Fundamentals of Data Analysis EXAM UNIT Topic 1 Understanding Data FULL TOPIC All the lessons you will need to cover: 1.1 Data, information and knowledge 1.2 Big data 1.3 Data and file formats 1.4 Data types and classifications Resources include lessons (between 2 and 4 lesson PowerPoints per section), worksheets with questions and answers. There is also a student checklist.

This resource includes 1 lesson and worksheet that includes 3 ciphertext tasks.

Resources include: Introduction to programming lesson 5 Python lessons, code provided, students can follow each task step by step using lesson slides/worksheets. Assessment sheet Knowledge organiser

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.

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 51ºÚÁÏ, Computer Misuse, GDPR, DPA etc. **Booklet 2: **Computing Inside the computer, hardware, software, binary and denary, networking.

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.

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

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.

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.

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

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

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.

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.

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

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.

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