Microsoft Excel Worksheet Exercise 1 These basic spreadsheet units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to use Excel / spreadsheets. These worksheets cover the basics and are ideal for KS2 /3 This worksheet is designed for independent study by students. There are instructions for the students, a Microsoft Excel template for the students to work on, as well as a completed Excel document so that the teacher can show / compare what they have done. **Learning Objectives ** Understand how to enter text, numbers and formula Understand how to use the fill handle to replicate formula Understand the AutoSum feature Understand how to use currency formatting Understand how to include your name and the date in the footer Understand how to use page setup to properly format your work Understand how to copy the spread sheet Understand how to show the formulas in formula view Please have a look at https://www.tes.com/teaching-resources/shop/wsparrow to see other resources.

GCSE Encryption This covers encryption for GCSE. There are 2 PowerPoint files fore the teacher to go through the lessons There is also a worksheet for the students to complete Objectives: • Basic Encryption terminology • How to encrypt a simple message • How to decrypt a simple message • What a Public Key is (D) • How a Private Key works (C) • Evaluate the security of this system (A)

This is a 13 slide PowerPoint presentation that allows the students to create 2 different campaigns. There is a worksheet included Learning Objectives Use the best software for a specific task. Evaluate if the IT tools selected were appropriate for the task Describe ways to make further improvements to work

Functional Skills ICT Level 1: Processing numerical data with graphs These Functional Skills ICT units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to use ICT effectively. Each of these modules covers a topic required for Functional Skills ICT, but they can also be used as stand alone lessons to deliver a specific topic. These lessons are also great for cover as they do not require any knowledge and the students can watch the videos and follow at the same time. Lesson outcome: Processing numerical data with graphs This 1 hour lesson comprises of: a complete Power Point with all teaching videos embedded , (This means that you do not need to know anything about ICT, the students can watch the videos on their own or you can watch it as a class.), templates and sample completed files. Have a look at http://bit.ly/2YGZlpH for a free 1 hour lesson from this series.

Functional Skills ICT Level 1: Data Handling and sending e-mail These Functional Skills ICT units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to use ICT effectively. Each of these modules covers a topic required for Functional Skills ICT, but they can also be used as stand alone lessons to deliver a specific topic. These lessons are also great for cover as they do not require any knowledge and the students can watch the videos and follow at the same time. Lesson outcome: Data Handling and sending e-mail This 1 hour lesson comprises of: a complete Power Point with all teaching videos embedded , (This means that you do not need to know anything about ICT, the students can watch the videos on their own or you can watch it as a class.), templates and sample completed files. Have a look at http://bit.ly/2YGZlpH for a free 1 hour lesson from this series.

This is a complete module for Microbit. It includes 4 PowerPoint files, one for each lesson. It covers: Lesson 1: What is a Micro:bit How to use it Rules and regulations Lesson 2: Create a basic program Applying code to show a picture Insert a program into micro:bit Also includes a help sheet for students Lesson 3: Understand the purpose of an input Applying inputs to a program Lesson 4: Revise the purpose of an input Understand the use of the compass Apply the compass in a program Also includes a help sheet for students

Computing / ICT KS 2/3 Create a board game on how to become an entrepreneur This is an award winning entire unit of work using Publisher to create a board game on how to become an entrepreneur. (10 hours of lesson plans) This includes the lesson plan, all templates and completed samples for this unit, as well as all learner support material. This can be easily adapted to suit just about any topic. Unzip the file, keeping the format. Run the file in the project plan folder and everything is linked to this.

Computing / ICT KS 2/3 Create a PowerPoint time capsule This is a 22 page pdf unt of work with 9 hours of lesson plans. This includes the lesson plan, all templates and completed samples for this unit, as well as all learner support material. This can be easily adapted to suit just about any topic. This is a 22 page unit of work on how to create a time capsule using Microsoft PowerPoint, but can be used in Google Slides as well. (9 hours of lesson plans ) This includes the lesson plan and completed samples for this unit.

This is a 16 page booklet for the students to follow to create a underwater game. It is easy to follow and has great screen shots for ease of use. Includes a lesson planning sheet. Lesson 3 – Underwater Game Learning Objectives You will understand how to: • Import sprites • Edit costumes of sprites given in Scratch • Animate sprites using scripts • Control the movement of sprites using the arrow keys • Create scripts that move sprites around automatically • Create interaction between sprites • Use co-ordinates and random numbers to set start position of sprites • Use variables and scripts to allow scoring and countdown • Use backgrounds built into Scratch • Making autonomous sprites

Microsoft Excel Worksheet Exercise 2 These basic spreadsheet units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to use Excel / spreadsheets. These worksheets cover the basics and are ideal for KS2 /3 This worksheet is designed for independent study by students. There are instructions for the students, a Microsoft Excel template for the students to work on, as well as a completed Excel document so that the teacher can show / compare what they have done. **Learning Objectives ** Understand how to enter text, numbers and formula Understand using an absolute cell reference Understand how to use the fill handle to replicate formula Understand the AutoSum feature Understand how to use currency formatting Understand how to put name and date in the footer Understand how to use page setup to properly format your work Understand how to show formulas in formula view Understand how to make a copy of a spread sheet Understand the term variable Understand how to model different outcomes by changing a variable in the spreadsheet Please have a look at https://www.tes.com/teaching-resources/shop/wsparrow to see other resources.

Microsoft Excel Worksheet Exercise 3 These basic spreadsheet units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to use Excel / spreadsheets. These worksheets cover the basics and are ideal for KS2 /3 This worksheet is designed for independent study by students. There are instructions for the students, a Microsoft Excel template for the students to work on, as well as a completed Excel document so that the teacher can show / compare what they have done. **Learning Objectives ** Enter text, numbers and formula Use several absolute cell references Use the fill handle to replicate formula Use the AutoSum feature Use currency formatting Include your name and date in the footer Use page setup to properly format your work Copy the spread sheet Show formulas in formula view Model different outcomes by changing several different variables in the spreadsheet Please have a look at https://www.tes.com/teaching-resources/shop/wsparrow to see other resources.

Use Adobe Flash Player to create an animation in flash This lesson comes with a Word document for the students to follow, the required image, as well as the completed Flash animation. Lesson objectives: Understand How to make a simple animation The purpose of Flash software

ECDL Week 6 Mail Merge This is a great resource that allows your students to work at their own pace.

Computer Science new curriculum Python 3: Using if command Lesson 3 with instructional videos These python version 3 units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to program using Python. This course covers everything for Programming in Python for GCSE (9-1) in Computer Science. Lesson Aim: To be able to understand how to construct programs that present multiple options. Lesson outcome: By the end of this lesson, you will be able to write programs that handle multiple conditions using if, elif and else and while statements. This 1 hour lesson comprises of: the lesson plan, a complete Power Point with all teaching videos embedded , (This means that you do not need to know anything about Python, the students can watch the videos on their own or you can watch it as a class.), (The lesson covers:if, elif, else, while, selection, conditional statement, decision, true, false.) differentiated exercises, and the completed python files Download all the files into the same folder and run if elif and else PowerPoint Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of what is included in each unit Read less

Functional Skills ICT Level 1: Preparing a poster with a password protected file These Functional Skills ICT units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to use ICT effectively. Each of these modules covers a topic required for Functional Skills ICT, but they can also be used as stand alone lessons to deliver a specific topic. These lessons are also great for cover as they do not require any knowledge and the students can watch the videos and follow at the same time. Lesson outcome: Preparing a poster with a password protected file This 1 hour lesson comprises of: a complete Power Point with all teaching videos embedded , (This means that you do not need to know anything about ICT, the students can watch the videos on their own or you can watch it as a class.), templates and sample completed files. Have a look at http://bit.ly/2YGZlpH for a free 1 hour lesson from this series.

Lesson 2 – Pac Man Style Game This is a manual for the students to follow. Very little input required from the teacher, as all instructions with pictures for assistance are included in this 12 page document. Learning Objectives You will understand how to: • Delete, resize and draw new sprites • Draw new costumes and use them to animate a sprite • Control the movement of a sprite using arrow keys • Design a maze on the stage • Make sprites interact with the background by using colours • Make sprites start in a pre-set starting position using co-ordinates • Make objects disappear and reappear in a random position • Create variables to set up scoring in the game • Make an autonomous sprite chase the sprite controlled by the player

This is a manual for the students to follow. Very little input required from the teacher, as all instructions with pictures for assistance are included in this 16 page document. Learning Objectives You will understand how to:  Create a simple script that animates the sprite automatically  Create a script that allows the user to control the movement of the sprite using the arrow keys  Combine the different scripts to work together on the same sprite  Make the sprite reverse direction  Edit the stage using the Paint Editor facility within Scratch  Make the sprite react to the background  Import a new sprite from the ones available within scratch  Create and edit new costumes for an existing sprite  Create a simple script that move the sprite automatically  Create variables to set the score and the countdown  Set a sprite to start in a certain position  Save your work

E Safety Unit Lesson 1 These Functional Skills ICT units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to use ICT effectively. Each of these lessons cover a specific topic for E safety for KS 2 / KS 3, but they can also be used as stand alone lessons to deliver a specific topic. These lessons are also great for cover and distance learning as the learners can do research and complete at their own pace. Lesson outcome: Create an online e safety poster in a software of the learners choice. This 1 hour lesson comprises of: a teacher Power Point, keywords, a worksheet, and sample completed files.

Input and Output devices This is a 36 page PowerPoint about input and output devices. The students can go through this at their own pace. Objectives: • Be able to explain what input and output devices are: • Be able to identify input and output devices • Consider the uses of input and output devices