Hero image

Warren Sparrow's Shop

Average Rating4.10
(based on 6 reviews)

Head of Department at an Outstanding School. I was nominated as one of the top 50 teachers in the Global Teachers Prize. I am a Microsoft Innovative Expert Educator, a Microsoft Fellow and a Microsoft Certified Trainer working in a Google School. I received the Microsoft Award for innovation in ICT, Education Department Provincial Award for Best ICT Practice and Eduweek’s Best Classroom Practice.

73Uploads

16k+Views

8k+Downloads

Head of Department at an Outstanding School. I was nominated as one of the top 50 teachers in the Global Teachers Prize. I am a Microsoft Innovative Expert Educator, a Microsoft Fellow and a Microsoft Certified Trainer working in a Google School. I received the Microsoft Award for innovation in ICT, Education Department Provincial Award for Best ICT Practice and Eduweek’s Best Classroom Practice.
Python Version 3 with instructional videos sample
wsparrowwsparrow

Python Version 3 with instructional videos sample

(0)
Computer Science new curriculum Python Version 3 with instructional videos sample 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 both the AQA and the OCR awarding bodies. GCSE (9-1) in Computer Science This is the sample lesson for each of the Python Version 3 units. Please look at the completed other lessons that I have created by clicking on my name! Each unit 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.), differentiated exercises, and the completed python files. (These are in a zip format) Download all the files into the same folder and run Python Input Output Power Point.
GCSE Encryption
wsparrowwsparrow

GCSE Encryption

(0)
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)
Input and Output devices
wsparrowwsparrow

Input and Output devices

(0)
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
Scratch 2.0 6 Lessons
wsparrowwsparrow

Scratch 2.0 6 Lessons

6 Resources
Scratch 2.0 6 Lessons All the resources you need to run scratch in your class. All six lessons have lesson plans, as well as the documents for the students to follow at their own pace.
Scratch 2.0 Lesson 6 – co-ordinates, subroutines, variables and user input
wsparrowwsparrow

Scratch 2.0 Lesson 6 – co-ordinates, subroutines, variables and user input

(0)
Scratch 2.0 Lesson 6 – co-ordinates, subroutines, variables and user input This is a 12 page booklet for the students to follow to create a game. It is easy to follow and has great screen shots for ease of use. Includes a lesson planning sheet. Learning Objectives You will understand how to: • Delete a sprite and import a new sprite • Draw using the pen feature of Scratch • Use the pen up and pen down feature • Change the colour of the pen • Set the position of the sprite using co-ordinates • Make a sprite appear and disappear using show and hide • Add variables to your program to change the direction of movement • Use the broadcast feature in Scratch to create subroutines • Use subroutines to make the program more efficient and easier to edit • Enable user input to set the number of sides of each shape
Scratch 2.0  Lesson 5 Creating Graphics
wsparrowwsparrow

Scratch 2.0 Lesson 5 Creating Graphics

(0)
Using Scratch 2.0 Lesson 5 Creating Graphics This is a 12 page booklet for the students to follow to create and use graphics. It is easy to follow and has great screen shots for ease of use. Includes a lesson planning sheet. Lesson 5 Creating Graphics Learning Objectives You will understand how to: • Delete a sprite and import a new sprite • Draw using the pen feature of scratch • Use the pen up and pen down feature • Change the colour of the pen • Set the position of the sprite using co-ordinates • Make a sprite appear and disappear using show and hide • Use the repeat function in Scratch • Use the broadcast feature in Scratch • Create simple subroutines You will understand about: • The use of co-ordinates • The advantages of using subroutines (efficiency and flexibility)
Scratch 2.0  Lesson 4 Programming and Control Monkey Game
wsparrowwsparrow

Scratch 2.0 Lesson 4 Programming and Control Monkey Game

(0)
Scratch 2.0 Lesson 4 Programming and Control Monkey Game Lesson 4 – Monkey Game This is a 8 page booklet for the students to follow to create a monkey game. It is easy to follow and has great screen shots for ease of use. Includes a lesson planning sheet. The objective of the game is to collect 10 bananas or more in 20 seconds A countdown goes from 20 seconds to 0.When the countdown reaches zero a message will come up saying whether the player has won (10 bananas or more) or lost (less than 10 bananas collected). Learning Objectives: You will understand: • The following key terms – variable, operator, IF..Else…repeat until • How to give the user instructions at the beginning of the game • How to use broadcast to start the game • GREATER THAN and LESS THAN symbols • BOOLEAN LOGIC as it applies to combining conditions necessary for game outcomes. • Combine different conditions using If…Else.. to govern the game outcome • How to animate a sprite using costumes • How to control the movement of a sprite using arrow keys • How to design a maze on the stage • How to make sprites interact with the background by using colours • The range of coordinates available on the stage in Scratch • How to make sprites start in a pre-set starting position using co-ordinates • How to make objects to disappear and reappear in a random position You will understand the objective of the game:
Scratch 2.0 Lesson 3 – Underwater Game
wsparrowwsparrow

Scratch 2.0 Lesson 3 – Underwater Game

(0)
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
Scratch 2.0 Lesson 2 Create Packman Style Game
wsparrowwsparrow

Scratch 2.0 Lesson 2 Create Packman Style Game

(0)
This is a 12 page booklet for the students to follow to create a Packman Style Game . It is easy to follow and has great screen shots for ease of use. Includes a lesson planning sheet. 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
Scratch 2.0 Lesson 1 Create a game
wsparrowwsparrow

Scratch 2.0 Lesson 1 Create a game

(0)
Create a game This is a 16 page booklet for the students to follow to create a game. It is easy to follow and has great screen shots for ease of use. Includes a lesson planning sheet. 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 You will understand: • What Scratch is and what it does • The main parts of Scratch interface • What decomposition and how it is used
Microbit lessons
wsparrowwsparrow

Microbit lessons

(0)
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
Mail Merge Office 2010  Book 5
wsparrowwsparrow

Mail Merge Office 2010 Book 5

(0)
Mail Merge Office 2010 Book 5 This is a 6 page booklet for the students to use to create a mail merge with instructions and screen shots for ease of use. Mail merge is an important business tool which allows specific potential customers to be targeted with specific mail. This is much more efficient and cheaper than sending the same letter to everyone. In this exercise you will learn how to: 1. Use an existing source to create mail merged labels 2. Select specific records for merging 3. Use rules to obtain further personalisation of a mail merge.
Mail Merge Office 2010  Book 4
wsparrowwsparrow

Mail Merge Office 2010 Book 4

(0)
Mail Merge Office 2010 Book 4 This is a 4 page booklet for the students to use to create a mail merge with instructions and screen shots for ease of use. When you use mail merge it is often easier to use an existing data source. Word can work with a range of data sources including Excel spreadsheets, Access databases, text files and comma separated value files In this exercise you will learn how to: 1. Use an Excel file as a data source outside of Word to create a mail merge
Mail Merge Office 2010  Book 3
wsparrowwsparrow

Mail Merge Office 2010 Book 3

(0)
Mail Merge Office 2010 Book 3 This is a 7 page booklet for the students to use to create a mail merge with instructions and screen shots for ease of use. Mail merge is used for tasks where many copies of a document must be made each one having slightly different personal details such as standard letters that need to be individually addressed. In this exercise you will learn how to: 1. Add new field names and change the standard ones given in WORD. 2. Insert your new field names into the text of a letter.
Mail Merge Office 2010  Book 2
wsparrowwsparrow

Mail Merge Office 2010 Book 2

(0)
Mail Merge Office 2010 Book 2 This is a 6 page booklet for the students to use to create a mail merge with instructions and screen shots for ease of use. In this exercise you will learn how to: 1. Use an existing database to set up a new mail merged letter 2. Select specific records for merging 3. Change other default settings when merging
Mail Merge Office 2010  Book 1
wsparrowwsparrow

Mail Merge Office 2010 Book 1

(0)
Mail Merge Office 2010 Book 1 This is a 7 page booklet for the students to use to create a mail merge with instructions and screen shots for ease of use. Mail merge is an important business tool allowing you to add personalised details into a standard message. Most posted letters and bills are created by using mail merge. Everything from utility bills to party invites can be personalised using mail merge. In this exercise you will learn how to: 1. Create a simple database within Word 2. Change the field names from the standard ones given in Word 3. Combine that database with a letter 4. Create a mail merge
Create an animation in Flash
wsparrowwsparrow

Create an animation in Flash

(0)
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 Productivity Week 2 - 3
wsparrowwsparrow

ECDL Productivity Week 2 - 3

(0)
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
ECDL Improving Productivity Week 1
wsparrowwsparrow

ECDL Improving Productivity Week 1

(0)
This is a 10 slide PowerPoint that goes through what improving productivity is all about. It has a video and a worksheet included. It has a task for the students to complete once they have completed the worksheet. Learning Objectives understand what is involved in a piece of work and the best way to get it done able to evaluate the strengths and weaknesses of the use of IT, including identifying improvements to inform future work.