Excel Spreadsheet Unit Lessons for KS3/KS4Quick View
hp1001

Excel Spreadsheet Unit Lessons for KS3/KS4

(2)
<p>10 Lessons on Microsoft Excel skills.<br /> Lesson 1 - Intro to Excel, Simple Formula &amp; Formatting Techniques<br /> Lesson 2 - Simple Functions (SUM, MAX, MIN, AVERAGE) &amp; Data Types<br /> Lesson 3 - Functions (Count, CountA, Countblank, Round, IF) &amp; Graph Types<br /> Lesson 4 - Functions (IF, SUMIF, COUNTIF) &amp; Intro to Conditional Formatting<br /> Lesson 5 - Recap Functions (IF, SUMIF, COUNTIF) &amp; Using Conditional Formatting<br /> Lesson 6 - Functions (Concatenate, Now, Today, Vlookup)<br /> Lesson 7 - Data Validation Techniques, Sorting Data &amp; Filtering Data<br /> Lesson 8 - Recap Sorting &amp; Filtering Data, Functions (LEFT &amp; RIGHT)<br /> Lesson 9 - Protecting a Sheet, Protecting a Workbook, Encrypt a Workbook with Password, Protect a Workbook using Read Only<br /> Lesson 10 - Creating Macros to link sheets &amp; Creating Pivot Charts</p> <p>Each lesson includes:<br /> Teacher Slides Powerpoint<br /> Starter/Do Now Tasks (Word Documents or Excel Spreadsheets)<br /> 3 - 5 Student Lesson Tasks (Excel Spreadsheets)<br /> Extension Tasks (Excel Spreadsheets, Word Documents or PDF Documents)<br /> Plenary/Exit Tasks (Included in the Teacher Slides Powerpoint)</p>
IT Microsoft Office Skills Project for KS3/KS4Quick View
hp1001

IT Microsoft Office Skills Project for KS3/KS4

(2)
<p>IT Microsoft Office Skills Project for KS3/KS4. Students will learn Word, PowerPoint, Excel &amp; Publisher skills by creating a mini project.</p> <p>7 Lessons covering:<br /> Lesson 1 - Introduction of Project (Student Music Festival Brief), Logo creation PowerPoint &amp; Word Skills)<br /> Lesson 2 - Promotional Material (Word &amp; Publisher Skills)<br /> Lesson 3 - Ticket creation (Word &amp; Publisher Skills) and QR codes<br /> Lesson 4 - Formula (+ - * /), Functions (SUM, MIN, MAX, AVERAGE), Data Types &amp; Conditional Formatting (Excel Spreadsheet Skills)<br /> Lesson 5 - Excel Formatting Techniques, Apply skills from Lesson 4 to create Project Spreadsheet (Excel Skills)<br /> Lesson 6 - Mail Merge, Personalised ticket creation (Word, Publisher &amp; Excel Skills)<br /> Lesson 7 - Evaluation of project &amp; skills (Deciding what level you have worked at), Project presentation (demonstrating all work produced) (Word &amp; PowerPoint Skills)</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Activity Worksheets (Word Documents, PowerPoints, Excel Spreadsheets)<br /> Starter &amp; Plenary Activities (Word Documents)<br /> Help Sheets (Word Documents &amp; PDF)</p>
KS3 Scratch Programming Unit LessonsQuick View
hp1001

KS3 Scratch Programming Unit Lessons

(1)
<p>A set of 7 full lessons for KS3 (Year 7/Year 8) on Scratch Programming.</p> <p>Lessons cover:<br /> Lesson 1 &amp; 2 - Introduction into Scratch, What are Sprites, How do we add a background, How do we add a sprite, How do we control sprites, What is looping/loops, Creating Variables in Scratch, Creating loops in Scratch, Creating a simple game of cat and mouse in Scratch.<br /> Lesson 3 - Understand what a costume is and how to create one, Understand what broadcast means and where we find this code block, Finishing off the cat &amp; mouse game in Scratch off.<br /> Lesson 4 - Understand how to sense events and where to find this in Scratch, Understand what a variable is and where to find one in Scratch, Creating a game of shark attack in Scratch.<br /> Lesson 5 - Understand what sensing is and how it is used in Scratch, Understand what a variable is and where to find them, Understand how to draw our own sprite using the paint feature, Apply our new knowledge to start creating a Flappy Bird game.<br /> Lesson 6 - Understand what coordinates are, Understand how coordinates affect the movement of characters, Understand how to use the coordinates code blocks to move our character, Continue creating our Flappy Bird game.<br /> Lesson 7 - Understand how to add pipes to our Flappy Bird game, Understand how to use operators to compare variables, Understand how to add a high score feature to our Flappy Bird game, Understand how to add instructions to our Flappy Bird game. Add to our game using the extension/challenge tasks.</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Worksheets (Word Documents)<br /> Starter &amp; Plenary Activities (Word Documents or in Teacher Slides PowerPoint)<br /> Extension Tasks (Word Documents)<br /> Extra Class Work - Scratch Booklet (Word Document)</p>
OCR ALevel 2.1 Thinking Abstractly & Thinking Ahead LessonsQuick View
hp1001

OCR ALevel 2.1 Thinking Abstractly & Thinking Ahead Lessons

(0)
<p><strong>OCR ALevel/AS Level Computer Science (KS5)</strong></p> <p>6 Lessons that cover the beginning of Unit 2.1 Elements of Computational Thinking:<br /> 2.1.1 Thinking Abstractly<br /> 2.1.2 Thinking Ahead</p> <p><strong>2.1.1 Thinking Abstractly Lessons:</strong><br /> Lesson 1 - The nature of abstraction &amp; The need for abstraction<br /> Lesson 2 - The difference between an abstraction and reality &amp; Devise an abstract model for a variety of situations</p> <p><strong>2.1.2 Thinking Ahead Lessons:</strong><br /> Lesson 1 - Identify the inputs and outputs for a given situation (including those in descriptive, diagrammatical and pseudocode contexts)<br /> Lesson 2 - The need for reusable program components<br /> Lesson 3 - Determine the preconditions for devising a solution to a problem &amp; The nature, benefits and drawbacks of caching<br /> Lesson 4 - Create an abstract model for a text-based game, Use your abstract model to produce success criteria, Develop your game using a range of programming techniques, Test &amp; Evaluate the success of your program against your success criteria</p> <p><strong>Lessons include:</strong><br /> Teacher Slides Powerpoint<br /> Student Worksheets (Word Documents or Powerpoint)<br /> Student Exam Questions (Word Documents or Powerpoint)<br /> Starter Activities &amp; Plenary Questions (Powerpoint or Word Documents)</p>
OCR ALevel Computer Science Comp 1 Unit 1.2.2 System Application GenerationQuick View
hp1001

OCR ALevel Computer Science Comp 1 Unit 1.2.2 System Application Generation

(1)
<p>OCR ALevel/AS Level Computer Science Comp 1<br /> Unit 1.2.2 Applications Generation</p> <p>A set of 2 full lessons covering the Applications Generation Unit of Comp 1.</p> <p>Lessons cover:</p> <p>Lesson 18 - Application Software vs Utility Software. What is an application &amp; utility. Examples of application software and utility software. Understand the function of applications &amp; utilities. Open &amp; Closed Source. Advantages &amp; Disadvantages (Comparison between Open &amp; Closed Source). Practice exam questions relating to applications &amp; utilities.</p> <p>Lesson 19 - Translators, Compliers, Interpreters and Assemblers. What is a translator. Understand the function of translators. Machine Code. Assembler. Compilers &amp; Interpreters. Object Code. Practice exam questions relating to translators.</p> <p>(Lesson Numbers continue from Unit 1.2.1)</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Worksheets (Word Document)<br /> Starter Activities &amp; Plenary Tasks (Word Document)</p>
OCR ALevel CS Software Development LessonsQuick View
hp1001

OCR ALevel CS Software Development Lessons

(1)
<p>OCR ALevel/AS Level Computer Science 2.2.2 Software Development Unit Lessons (KS5)</p> <p>6 Lessons covering:<br /> Lesson 1 - Software Development Life Cycle (SDLC), Stages of SDLC &amp; purpose, Popular models (Waterfall, Agile, Incremental etc).<br /> Lesson 2 - SDLC models, Pros and cons of each model, what projects are best for each model, Using a model to complete a task.<br /> Lesson 3 - Testing Strategies (Black Box, White Box, Dry Run, Alpha, Beta), Key characteristics, pros &amp; cons of each strategy, Trace Tables intro.<br /> Lesson 4 - Trace tables &amp; how to use them, Test Data (Valid, Erroneous, Boundary), How to use test data to test programs.<br /> Lesson 5 - Trace table recap, Properties of a good algorithm, Pseudocode, Exam Questions<br /> Lesson 6 - Checking understanding of software development unit, Exam Question booklet</p> <p>Lessons include:<br /> Teacher Slides Powerpoint - contains starters/do now tasks, explanations of topics, tasks, exam questions and independent study tasks.<br /> Student Worksheets for tasks (Powerpoint or Word Documents)</p>
KS3 ICT Skill Building Excel LessonsQuick View
hp1001

KS3 ICT Skill Building Excel Lessons

(0)
<p>5 Lessons for KS3 (Year 7/8) that focus on developing ICT skills using Excel Spreadsheets.</p> <p>Lesson 1 - How to add, subtract, divide and multiply in Excel<br /> Lesson 2 - How to use multiplication formulas to create a multiplication square in Excel<br /> Lesson 3 - How to collate data using Microsoft Excel<br /> Lesson 4 - How to create graphs using Microsoft Excel<br /> Lesson 5 - How to use the SUM, MIN and MAX functions in Excel</p> <p>Lessons include:<br /> Teacher Slides Powerpoint<br /> Student Tasks (Excel Spreadsheets or PDF files)<br /> Some lessons include Helpsheets (Word Documents) &amp; Extension Tasks (Excel Spreadsheets or PDF files)</p>
HTML Web Design Unit Lessons for KS3/KS4Quick View
hp1001

HTML Web Design Unit Lessons for KS3/KS4

(0)
<p>10 Lessons covering web design using HTML programming:<br /> Lesson 1 - Web Browsers &amp; Web Pages, Intro to HTML (Head tag, Body tag, Heading tag &amp; paragraph tag)<br /> Lesson 2 - Client &amp; Server Side Scripts, Cookies, HTML tags (Hyperlink &amp; Image tags)<br /> Lesson 3 - Cloud Computing, HTML tags (Links, Images, Ordered List, Unordered List tags)<br /> Lesson 4 - Recap HTML tags, Introduce Notepad, Create a simple website in Notepad using the previous lessons HTML tags<br /> Lesson 5 - Analyse HTML code to identify the purpose of different tags, Continue creating Notepad website from last lesson<br /> Lesson 6 - Software Development Lifecycle, Client Requirements, Target Audience, SMART Goals, Analyse a given brief &amp; Create designs that meet a client’s specification<br /> Lesson 7 - Create designs that meet a client’s specification, Implement/Create a website that meets a client’s specification, Test Data, Test Plans<br /> Lesson 8 - Continue creating the website, Students create a test plan that tests all the links for the website<br /> Lesson 9 - Recap Testing, Evaluate project, Create a user guide/info guide for HTML tags<br /> Lesson 10 - CSS, Javascript, Comments &amp; Emojis in HTML</p> <p>Lessons includes:<br /> Teacher Slides (Powerpoint)<br /> 3 - 5 Student Tasks (Word documents or PowerPoints)<br /> Extension/Challenge Task (Word documents)</p> <p>Lessons will introduce students to HTML using the w3schools website before moving to use Notepad for coding.</p>
KS3 Micro:bit Programming Unit LessonsQuick View
hp1001

KS3 Micro:bit Programming Unit Lessons

(0)
<p>A set of 6 full lessons for KS3 (Year 8 /Year 9) on Microbit Programming.</p> <p>Lessons include:<br /> Lesson 1 - Introduction into Microbit. Introduction to the different code blocks you can use in the BBC Microbit Make Code. Creating a board game using Microbits.<br /> Lesson 2 &amp; 3 - Algorithms &amp; Flowcharts, Understand how to program pins on a Micro:bit, Be able to create a fully functional traffic light program using a Micro:bit, crocodile cables and LED’s. Programming Challenges - Traffic Light (Easy), Traffic Light (Intermediate), Lighthouse Light (Hard), Formula One Start Lights (Expert).<br /> Lesson 4 - Car Technology &amp; Self Driving Cars, Understand how to program pins on a Micro: bit, Create a fully functional circuit for car indicators.<br /> Lesson 5 - Wearable Technology, Understand how to program the accelerometer and use variables on the Micro: bit, Create a fully functional step counter. Programming Challenges - Thermometer, Stepometer, Stop Watch.<br /> Lesson 6 - Digital Clocks, Understand how to use variables on the Micro: bit, Create a fully functional digital clock, Understand what level we have worked at for this unit, Complete an evaluation on this unit.</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Activities &amp; Worksheets (Word Documents)<br /> Starter &amp; Plenary Tasks (Word Documents or in Teacher Slides Powerpoint)<br /> Extension Tasks (Word Documents)</p>
OCR ALevel Computer Science Unit 1.2.1 Operating SystemsQuick View
hp1001

OCR ALevel Computer Science Unit 1.2.1 Operating Systems

(0)
<p>OCR ALevel/AS Level Computer Science Comp 1<br /> Unit 1.2.1 Operating Systems</p> <p>A set of 7 full lessons covering the Operating Systems Unit of Comp 1.</p> <p>Lesson 11 - Purpose of an OS. Understand what an OS is, Understand the purpose of an OS, OS you might recognize, What is the kernel of an OS and what does it do, Be able to answer practice exam questions relating to Operating Systems</p> <p>Lesson 12 - Memory Management. What is memory management, Understand the purpose of memory management, What is paging and segmentation, Be able to answer practice exam questions relating to memory management</p> <p>Lesson 13 - Interrupts. What is an interrupt, Understand the purpose of interrupts, What is polling, Be able to answer practice exam questions relating to interrupts</p> <p>Lesson 14 - Scheduling. Understand what scheduling is, Understand the purpose of scheduling, Understand the different algorithms a scheduler can use (Round Robin, Shortest Job First, Multi Level Feedback Queue), Be able to answer practice exam questions relating to scheduling</p> <p>Lesson 15 - Types of OS. Understand the different types of OS, Understand the function of different OS types, Be able to answer practice exam questions relating to types of OS</p> <p>Lesson 16 - BIOS. What is the BIOS, Understand the function of the BIOS, What is the Power-on self-test (POST), Where is the BIOS stored, Be able to answer practice exam questions relating to the BIOS</p> <p>Lesson 17 - Virtual Machine. What is a virtual machine, Understand the function of virtual machines, What are the advantages of using virtual machines, Examples of virtual machines that can be used for interpreting intermediate code (Java Virtual Machine), Be able to answer practice exam questions relating to virtual machines</p> <p>(Lesson Numbers continue from Unit 1.1.3)</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Worksheets (Word Document)<br /> Starter Activities &amp; Plenary Tasks (Word Document)</p>
KS3/KS4 Computer Science Raspberry Pi LessonsQuick View
hp1001

KS3/KS4 Computer Science Raspberry Pi Lessons

(0)
<p>A set of 9 full lessons for KS3/KS4 (Year 9 - Year 10) on using the Raspberry Pi and Raspbian operating system.</p> <p>Lessons cover:</p> <p>Lesson 1 - Introduction to Raspberry Pi, What is the Raspberry Pi, How do we set up the Raspberry Pi, What are the key components of a Raspberry Pi, How do we safely disconnect and log out of the Raspberry Pi.</p> <p>Lesson 2 - Understand the key components of a Raspberry Pi Compute, Learn how to access software, Understand how to open Minecraft Pi, Understand how to use the Python Programming Interface, Learn how to code Python to hack Minecraft.</p> <p>Lesson 3 - Understand how software can be manipulated or changed through the writing of code, Understand what a function is and how to write functions in Python, Understand the import function allows me to import pre-written code to my programs, Understand the function of X, Y and Z co-ordinates in a 3D environment. This lesson has Intermediate and Advanced versions of the Student Worksheet.</p> <p>Lesson 4 - What is an operating systems, What is the purpose of an operating system, Understand the main functions of an operating system including User Interface, Memory Management, Multitasking &amp; Security, Understand that different operating systems exist (Windows, Linux, Unix, DOS, Mac OSX)</p> <p>Lesson 5 - Understand what the terminal (command line) does and what a terminal command is, Understand how to access the terminal on the Raspberry Pi and what the default terminal is called (LXTerminal), Explore different terminal commands and explore their function (e.g. pwd, ls, cd, clear), Explain the purpose of different terminal commands.</p> <p>Lesson 6 - Recap of what a terminal command is, Continue to explore different terminal commands and explore their function, Understand what a user account is and why they are used, Understand what levels of access are and why they are used.</p> <p>Lesson 7 - Understand what factors that affect the performance of a CPU, Understand clock speed, cores, cache size, RAM and the function of a GPU, Be able to clearly explain the purpose of different factors in the performance of a CPU, Understand the term overclocking and the benefits and problems it can cause.</p> <p>Lesson 8 - What is a network, Understand the difference between a wired and wireless network connection, Understand the advantages and disadvantages of each, Explore different terminal commands and their function relating to network scanning tools, Explain the purpose of different terminal commands in relation to network scanning tools.</p> <p>Lesson 9 - Compare the different models of Raspberry Pi to understand the differences, Understand what you have done well and how to improve your progress in this project, Be able to evaluate your performance in this project.</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Worksheets (Word Document or PowerPoint)<br /> Starter Activities &amp; Plenary Tasks (Word Document)<br /> Extension Tasks (Word Document)<br /> Set Up Guide (PDF)<br /> Help Sheets (Word Document)<br /> Screenshots (JPG)</p>
OCR ALevel Computer Science Comp 1 Unit 1.3.2 NetworksQuick View
hp1001

OCR ALevel Computer Science Comp 1 Unit 1.3.2 Networks

(0)
<p>OCR ALevel/AS Level Computer Science Comp 1<br /> Unit 1.3.2 Networks</p> <p>A set of 7 full lessons covering the Networks Unit of Comp 1.</p> <p>Lessons cover:</p> <p>Lesson 1 - Characteristics of a network. Know what a network is, Understand the reasons for having a network, Be able to answer practice exam questions relating to networks.</p> <p>Lesson 2 - The Internet structure - Layers. Know what the internet structure is, Understand how the internet works, Be able to answer practice exam questions relating to the internet structure.</p> <p>Lesson 3 - The Internet structure - Protocols. Know what the internet structure is, Understand how the internet works, Be able to answer practice exam questions relating to the internet structure.</p> <p>Lesson 4 - The Internet structure - Packets &amp; Circuit Switching. Know what the internet structure is, Understand how the internet works, Be able to answer practice exam questions relating to the internet structure.</p> <p>Lesson 5 - Network security and threats. Know what network security is, Understand threats to network security, Be able to answer practice exam questions relating to network security &amp; threats.</p> <p>Lesson 6 - Network hardware. Know what network hardware is, Understand the function of different network hardware, Be able to answer practice exam questions relating to network hardware.</p> <p>Lesson 7 - Client server and peer to peer networks. Know what network types there are, Understand the uses of different network types, Be able to answer practice exam questions relating to network types.</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Worksheets (Word Document)<br /> Starter Activities &amp; Plenary Tasks (Word Document)</p>
OCR ALevel Computer Science Comp 1 Unit 1.1.3 Input, Output & StorageQuick View
hp1001

OCR ALevel Computer Science Comp 1 Unit 1.1.3 Input, Output & Storage

(0)
<p>OCR ALevel/AS Level Computer Science Comp 1<br /> Unit 1.1.3 Input Output Storage</p> <p>A set of 3 full lessons covering the Input, Output, Storage unit of Comp 1.</p> <p>Lessons cover:</p> <p>Lesson 8 - Secondary Storage. 3 main types of secondary storage. Understand why secondary storage is needed. Storage devices (Magnetic, Flash &amp; Optical). Hybrid Hard Drives. Virtual Storage. Advantages &amp; Disadvantages. Practice exam questions relating to secondary storage.</p> <p>Lesson 9 - Input, Output, Storage. What is an input &amp; output device - Give examples. Understand how different input &amp; output devices can be used. Practice exam questions relating to Input &amp; Output devices.</p> <p>Lesson 10 - RAM &amp; ROM. What is RAM &amp; ROM. Understand the different uses for RAM &amp; ROM. Volatile vs non-volatile. Page File. Virtual Memory. Disk Thrashing. Practice exam questions relating to RAM &amp; ROM.</p> <p>(Lesson Numbers continue from Unit 1.1.2)</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Worksheets (Word Document)<br /> Starter Activities &amp; Plenary Tasks (Word Document)</p>
Kodu Games Design Lesson WorksheetsQuick View
hp1001

Kodu Games Design Lesson Worksheets

(0)
<p>Lesson worksheets for Kodu Crossy Road, FIFA Football, Pacman, Kodu Kart (Mario Kart) &amp; Apples Game</p> <p>Each game/activity contains the programming code/instructions for the game and the worksheet for the students to complete.</p> <p>The programming worksheets are based on the PRIMM model broken down into sections to support students in gaining confidence and understanding of programming concepts.</p> <p>Also included are a couple of starter activities for lessons based on Kodu keywords and tools.</p> <p>File type for resources included: Microsoft Word</p>
OCR ALevel 2.1 Thinking Procedurally, Thinking Logically & Thinking Concurrently LessonsQuick View
hp1001

OCR ALevel 2.1 Thinking Procedurally, Thinking Logically & Thinking Concurrently Lessons

(0)
<p><strong>OCR ALevel/AS Level Computer Science (KS5)</strong></p> <p>Lessons covering the second half of Unit 2.1 Elements of Computational Thinking:<br /> 2.1.3 Thinking Procedurally<br /> 2.1.4 Thinking Logically<br /> 2.1.5 Thinking Concurrently</p> <p><strong>2.1.3 Thinking Procedurally Lessons:</strong><br /> Lesson 1 - Identify the components of a problem<br /> Lesson 2 - Identify the components of a solution to a problem &amp; Identify sub-procedures necessary to solve a problem<br /> Lesson 3 - Identify sub-procedures necessary to solve a problem<br /> Lesson 4 - Determine the order of the steps needed to solve a problem (Psuedocode, Flowcharts) &amp; How can we solve a problem with a procedural programming language such as Python?<br /> Lesson 5 - How can we solve a problem with a procedural programming language such as Python? Coding the problem, Exam Questions</p> <p><strong>2.1.4 Thinking Logically Lessons:</strong><br /> Lesson 1 - Identify the points in a solution where a decision has to be taken, Determine the logical conditions that affect the outcome of a decision &amp; Determine how decisions affect flow through a program.<br /> Lesson 2 - Decompose the brief to create a success criteria, Identify where and what decisions need to be made, Develop a flow chart for your solution, Develop your program in Python &amp; Test &amp; Evaluate the success of your program against your success criteria</p> <p><strong>2.1.5 Thinking Concurrently Lessons:</strong><br /> Lesson 1 - Determine the parts of a problem that can be tackled at the same time, What is concurrent processing, how does it differ to parallel processing and how do I apply the concept to thinking?<br /> Lesson 2 - Determine the parts of a problem that can be tackled at the same time (Unplugged Activity), Deadlock, Starvation &amp; Race Conditions<br /> Lesson 3 - Outline the benefits and trade-offs that might result from concurrent processing in a particular situation<br /> Lesson 4 - How can I use my knowledge of concurrent processing to design and develop a program that makes use of threading?</p> <p>Lessons include:<br /> Teacher Slides Powerpoint<br /> Student Worksheets (Word Documents, Powerpoint or PDF)<br /> Student Exam Questions (Word Documents, Powerpoint or PDF)<br /> Starter Activities &amp; Plenary Questions (Powerpoint or Word Documents)</p>
OCR ALevel Computer Science Comp 1 (Unit 1.1.1 The CPU)Quick View
hp1001

OCR ALevel Computer Science Comp 1 (Unit 1.1.1 The CPU)

(0)
<p>OCR ALevel/AS Level Computer Science Comp 1:<br /> Unit 1.1.1 The Structure &amp; Function of the CPU</p> <p>A set of 5 full lessons covering the structure and functions of the CPU</p> <p><strong>Lessons cover:</strong></p> <p>Lesson 1 - What is a Processor, Moore’s Law, What are the different parts of a processor, Arithmetic Logic Unit, Control Unit, Register, Program Counter, How do we apply this knowledge to answer practice exam questions.</p> <p>Lesson 2 - What is a register, What are the different registers of the processor, Accumulator, Memory Address Register, Memory Data Register, Current Instruction Register, Busses, How do we apply this knowledge to answer practice exam questions.</p> <p>Lesson 3 - What is the fetch, decode, execute cycle, What are the different stages involved in this process, Fetch Instruction, Decode Instruction, Execute Instruction, How do we apply this knowledge to answer practice exam questions.</p> <p>Lesson 4 - How do we improve the CPU performance, What are the factors that affect CPU performance, Clock Speed, RAM, Cache, Core, GPU, How do we apply this knowledge to answer practice exam questions.</p> <p>Lesson 5 - What is the Von Neumann architecture, How does the Von Neumann Architecture work, How does the Harvard Architecture work, How do we apply this knowledge to answer practice exam questions.</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Worksheets (Word Documents)<br /> Starter Activities &amp; Plenary Activities included in the Teacher Slides or in separate Word Doc</p>
OCR ALevel Computer Science 2.2.1 LessonsQuick View
hp1001

OCR ALevel Computer Science 2.2.1 Lessons

(0)
<p>6 Lessons covering 2.2.1 Programming Techniques topics:<br /> Programming constructs: sequence, iteration, branching.<br /> Recursion, how it can be used and compares to an iterative approach.<br /> Global and local variables.<br /> Modularity, functions and procedures, parameter passing by value and by reference.<br /> Use of an IDE to develop/debug a program.<br /> Use of object-oriented techniques.</p> <p>Each lesson contains:<br /> Teacher Slide Powerpoint<br /> Student Activity Worksheet</p> <p>Lessons include Do Now Task/Starters, Explanations of topic, Tasks for students, Exam questions, and Independent study activities.</p>
Microsoft Office Knowledge Organisers for KS3/KS4Quick View
hp1001

Microsoft Office Knowledge Organisers for KS3/KS4

(0)
<p>4 Knowledge Organisers for IT Microsoft Office (Word, PowerPoint, Excel &amp; Publisher).</p> <p>Word KO contains Font Colour, Background, Margins, Tables, Page Break, Indentation &amp; more</p> <p>PowerPoint KO contains Alignment, Background, House Style, Master Page, Animations, Grouping &amp; more</p> <p>Excel KO contains Column &amp; Row, Conditional Formatting, Cell Reference, Basic formula, Data Validation &amp; more</p> <p>Publisher KO contains Background, Word Art, Page Size, Borders &amp; Accents, Header &amp; Footer, Guides, Master Page &amp; more</p> <p>All knowledge organisers/revision sheets are single PowerPoint Slides</p>
KS3 Computer Science Python Programming Unit LessonsQuick View
hp1001

KS3 Computer Science Python Programming Unit Lessons

(0)
<p>11 full lessons covering Python Programming for KS3 (Year 8 / Year 9).</p> <p>Lesson 1 - Python Basics - Variables, Assigning a value to a variable, Printing to the screen, Input<br /> Lesson 2 - What is a python number, Int, Float, How to cast strings to numbers<br /> Lesson 3 - What is a python loop, How to use loops in code, if, else, elif, While, For<br /> Lesson 4 - Sequence, Selection, Iteration, Count-controlled loops, Condition-controlled loops, Create a number guessing game<br /> Lesson 5 - What is an algorithm, Different symbols used in flowcharts, Create an algorithm for a specific purpose<br /> Lesson 6 - Random module in Python, Creating a dice game, Analyse a specific problem, Testing, Test Plans, Types of Data, Creating a test plan for a problem<br /> Lesson 7 - Rock Paper Scissors game, Flowchart Recap, Pseudocode, How to use a flowchart to create pseudocode, Create a flowchart and pseudocode for a specific problem<br /> Lesson 8 - Recap of Pseudocode &amp; guide, Create a flowchart and pseudocode for a specific problem<br /> Lesson 9 - Recap of variables, loops, random etc, Create a joke generator program, Create code for unit assessment<br /> Lesson 10 - Finish coding solution, Comments in Python, Comment coding solution, Write a detailed document explaining solution &amp; complete Test Plan document<br /> Lesson 11 - Evaluation Section - How to evaluate a program you have wrote, Understand what level you have been working at, Keyword definitions</p> <p>Lessons include:<br /> Teacher Slides Powerpoint<br /> Starter Activities (Word Documents)<br /> Student Worksheets (Word Documents)<br /> Extension Tasks (Word Documents)<br /> Plenary Activities (Word Documents)</p> <p>End of unit assessment is introduced in lesson 6 onwards. End of Unit Evaulation documents and Pupil Grading documents included.</p>
KS3 Computer Science - Computer Basics LessonsQuick View
hp1001

KS3 Computer Science - Computer Basics Lessons

(0)
<p>A set of 8 full lessons for KS3 (Year 7/Year 8) covering computer basics unit.</p> <p>Lessons cover:</p> <p>Lesson 1 - Input &amp; Output. Understand the difference between input and output. Know what an input and output device is. Give examples of different types of input devices. Give examples of different types of output devices. Understand the function of different input and output devices.</p> <p>Lesson 2 - Internal Components. Understand what is meant by internal. Know what an internal component is. Understand the function of different internal components. Identify the main internal parts of a computer system.</p> <p>Lesson 3 - Health Issues. What health issues can a computer cause? (Look at: Back Problems, Repetitive Strain Injury (RSI), Eye Strain) How might we prevent these issues?</p> <p>Lesson 4 - Binary. What is binary? How does a computer use binary? How do we represent a “normal” number as a binary number?</p> <p>Lesson 5 - Binary. Continue looking at how do we represent a “normal” number as a binary number? Then how do we represent larger “normal” numbers as a binary number? Why do computers use binary? Why is it important? How do we convert binary to ASCII to create messages?</p> <p>Lesson 6 - Network Components. Know what equipment is required to create a network. Look at: ISP (Internet Service Provider), Modem, Wireless Router, Hubs etc. Undertand the term WiFi. Understand how WiFi and hard wired networks work. Create a user guide to explain how to set up a network.</p> <p>Lesson 7 - Networks. What does LAN stand for? What does WAN stand for? What is the difference between LAN and WAN? What are network topologies? Bus, ring, star, mesh topologies.</p> <p>Lesson 8 - End of Unit Evaluation. Know what an evaluation is. Understand what level students have been working at. Evaluate student work - What has gone well, and what needs improving.</p> <p>Lessons include:<br /> Teacher Slides Powerpoints<br /> Student Activities/Worksheets (Word Documents, Excel, Publisher)<br /> Starter &amp; Plenary Activities (Word Documents or in Teacher Slides Powerpoint)<br /> Extension Tasks (Word Documents)<br /> Helpsheets (Word Documents)</p>
OCR ALevel Computer Science Comp 1 (Unit 1.1.2 Types of Processor)Quick View
hp1001

OCR ALevel Computer Science Comp 1 (Unit 1.1.2 Types of Processor)

(0)
<p>OCR ALevel/AS Level Computer Science Comp 1<br /> Unit 1.1.2 Types of Processor</p> <p>A set of 2 full lessons covering the Types of Processor for Unit 1.1.2</p> <p><strong>Lessons cover:</strong></p> <p>Lesson 6 - CISC &amp; RISC. What is the difference between RISC &amp; CISC? What are the benefits of RISC &amp; CISC? Apply knowledge of RISC &amp; CISC to answer exam questions.</p> <p>Lesson 7 - Multicore &amp; Parallel Processing. What are multicore and parallel systems? What is pipelining and why is it important? What are the limitations of pipelining? Apply knowledge of pipelining and multicore systems to answer exam questions.</p> <p>(Lesson numbers continue from Unit 1.1.1 (Lessons 1 - 5 can be found in 1.1.1))</p> <p>Lessons include:<br /> Teacher Slides PowerPoint<br /> Student Worksheets (Word Document)<br /> Starter Activities &amp; Plenary Tasks (Word Document)</p>