Hero image

Warren Sparrow's Shop

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.

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.
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
Functional Skills ICT Level 1: All 7 lessons
wsparrowwsparrow

Functional Skills ICT Level 1: All 7 lessons

7 Resources
Functional Skills ICT Level 1: All 7 lessons This is a bundle that has all 7 of the practical lessons that you need to cover Functional Skills ICT. 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. These 7 hour lessons comprise 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.
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
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)
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 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.
Functional Skills ICT Level 1 Finding information from the internet
wsparrowwsparrow

Functional Skills ICT Level 1 Finding information from the internet

(1)
Functional Skills ICT Level 1 Finding information from the internet 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: To be able to find information from the internet and send an email 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.) and sample completed files.
Spreadsheets Basics Lesson 1
wsparrowwsparrow

Spreadsheets Basics Lesson 1

(0)
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.
Functional Skills ICT Level 1: Preparing a letter to a volunteer
wsparrowwsparrow

Functional Skills ICT Level 1: Preparing a letter to a volunteer

(0)
Functional Skills ICT Level 1: Preparing a letter to a volunteer 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: Prepare a letter to a volunteer. 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.) and sample completed files.
Functional Skills ICT Level 1: Data Handling
wsparrowwsparrow

Functional Skills ICT Level 1: Data Handling

(0)
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.
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.
ICT KS 2/3 Create a board game on how to become an entrepreneur
wsparrowwsparrow

ICT KS 2/3 Create a board game on how to become an entrepreneur

(0)
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.
Scratch 1.4 Lesson 2 – Pac Man Style Game
wsparrowwsparrow

Scratch 1.4 Lesson 2 – Pac Man Style Game

(0)
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
Scratch 1.4 Lesson 3 - Underwater Game
wsparrowwsparrow

Scratch 1.4 Lesson 3 - Underwater Game

(0)
Using Scratch 1.4 Lesson 3 - Underwater 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 16 page document. 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
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 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
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 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.