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

15k+Views

7k+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.
Spreadsheets Basics Lesson 1
wsparrowwsparrow

Spreadsheets Basics Lesson 1

(1)
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.
Python 3: Variables 3 x 1 hour lessons with instructional videos
wsparrowwsparrow

Python 3: Variables 3 x 1 hour lessons with instructional videos

3 Resources
Computer Science new curriculum Python 3:Variables 3 x 1 hour lessons 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 GCSE (9-1) in Computer Science. Each 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.), differentiated exercises, and the completed python files. Download all the files into the same folder and run Python Variables Power Point. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit
Python 3: Variables Lesson 3 with instructional videos
wsparrowwsparrow

Python 3: Variables Lesson 3 with instructional videos

(0)
Computer Science new curriculum Python 3: Variables 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 outcome: Students will understand how variables are stored and how their value can be set through initialisation and assignment. Lesson Aim: To understand how the value of a variable is stored and the difference between variables and constants. 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 videos covers: variable, constant, initialise, assignment token, memory address location, assign and python identifier) differentiated exercises, and the completed python files Download all the files into the same folder and run Python 3 Power Point variables 3 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
Python Version 3: Variables and Memory
wsparrowwsparrow

Python Version 3: Variables and Memory

(0)
Python Version 3: Variables and Memory This is a high resolution poster that shows Variables and Memory. This is ideal as a poster on the wall or as a quick reference for the students. It covers variables, initialise, assign, identifier and memory address locations. The zip files contains the poster in both high resolution for a poster on the wall and a lower resolution to print in the students books or to place on the students drive. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.
Computing / ICT KS 2/3 Create a PowerPoint time capsule
wsparrowwsparrow

Computing / ICT KS 2/3 Create a PowerPoint time capsule

(0)
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.
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.
Python 3: Variables Lesson 2 with instructional videos
wsparrowwsparrow

Python 3: Variables Lesson 2 with instructional videos

(0)
Computer Science new curriculum Python 3: Variables Lesson 2 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 GCSE (9-1) in Computer Science. Lesson outcome: To be able to create a number guessing game using variables, input and import random Lesson Aim: To introduce and use variables to create a number guessing game. 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 videos covers: variables, data types, constants, random and import.) differentiated exercises, and the completed python files Download all the files into the same folder and run Python 3 Power Point 3.variables Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit
Python 3: Variables with instructional videos
wsparrowwsparrow

Python 3: Variables with instructional videos

(0)
Computer Science new curriculum Python 3: Variables 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 GCSE (9-1) in Computer Science. Lesson outcome: To be able to use different data type variables, create a flowchart and pseudocode for creating a number guessing game. Lesson Aim: To introduce and use variables. 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 videos covers: variables, data types, flowcharts and pseudocode.) differentiated exercises, and the completed flowchart and pseudocode Download all the files into the same folder and run Python 3 Power Point 3.variables Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit
ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets unit of work
wsparrowwsparrow

ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets unit of work

(0)
ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets This is a 26 page unit of work on playing the London Stock Exchange using Microsoft Excel or Google Sheets. (8 hours of lesson plans with formal assessment at the end) It includes extensive lesson plans, completed samples and everything you need to run this module.
Python Version 3: Data Types
wsparrowwsparrow

Python Version 3: Data Types

(0)
Python Version 3: Data Types This is a high resolution poster that shows the different data types in Python Version 3. This is ideal as a poster on the wall or as a quick reference for the students. The zip files contains the poster in both high resolution for a wall poster and a lower resolution to print in the students books or to place on the students drive. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.
ICT KS 2/3 Start a company unit of work
wsparrowwsparrow

ICT KS 2/3 Start a company unit of work

(0)
ICT KS 2/3 Start a company unit of work This is a 19 page unit of work on how to start a company using Word, Paint / Paint dot Net (11 hours of lesson plans with formal assessment at the end) This includes the lesson plan, all templates and completed samples for this unit. It includes creating your own logo, business card, letterhead, advertising and creating a brochure.
Python Version 3: Variable, value and statements
wsparrowwsparrow

Python Version 3: Variable, value and statements

(0)
**Python Version 3: Variable, value and statements ** This is a high resolution poster that shows the Variable, value and statements in Python Version 3. This is ideal as a poster on the wall or as a quick reference for the students. The zip files contains the poster in both high resolution for a poster and a lower resolution to print in the students books or to place on the students drive. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.
Python Version 3: Reserved words
wsparrowwsparrow

Python Version 3: Reserved words

(0)
Python Version 3: Reserved words This is a high resolution poster that shows the various reserved words in Python Version 3. This is ideal as a poster on the wall or as a quick reference for the students. The zip files contains the poster in both high resolution for a poster and a lower resolution to print in the students books or to place on the students drive. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.
Python Version 3: Variable rules
wsparrowwsparrow

Python Version 3: Variable rules

(0)
Python Version 3: Variable rules This is a high resolution poster that shows the various variable rules in Python Version 3. This is ideal as a poster on the wall or as an A4 quick reference for the students. The zip files contains the poster in both high resolution for a poster and a lower resolution to print in the students books. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.
Python Version 3: Colour Coding
wsparrowwsparrow

Python Version 3: Colour Coding

(0)
Python Version 3: Colour Coding This is a high resolution poster that shows the various colours and what they mean in Python Version 3. This is ideal as a poster on the wall or as an A4 quick reference for the students. The zip files contains the poster in both high resolution for a poster and a lower resolution to print in the students books. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python resources.
Python 3: Number guessing game with instructional videos
wsparrowwsparrow

Python 3: Number guessing game with instructional videos

(0)
Computer Science new curriculum Python 3: Number guessing game 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 GCSE (9-1) in Computer Science. Lesson outcome: To be able create a game where the user has to guess a number. 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 videos covers: Import, variable, constant, print, while loop, if.) differentiated exercises, and the completed python files. Download all the files into the same folder and run Number game PowerPoint. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit
Python 3: Input and Output 3 x 1 hour lessons with instructional videos
wsparrowwsparrow

Python 3: Input and Output 3 x 1 hour lessons with instructional videos

3 Resources
Computer Science new curriculum Python 3: Input and Output 3 x 1 hour lessons 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 GCSE (9-1) in Computer Science. Each 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.), differentiated exercises, and the completed python files. Download all the files into the same folder and run Python Input Output Power Point. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit
Python 3: Input and Output Lesson 3 with instructional videos
wsparrowwsparrow

Python 3: Input and Output Lesson 3 with instructional videos

(0)
Computer Science new curriculum Python 3: Input and Output 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 GCSE (9-1) in Computer Science. Lesson outcome: To be able to format the output produced by the print function Lesson Aim: To understand how to format output using the print function. 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 videos covers: input, output, print, function, format, concatenation.) differentiated exercises, and the completed python files. Download all the files into the same folder and run Python Input Output Power Point 3. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit
Python 3: Input and Output Lesson 2 with instructional videos
wsparrowwsparrow

Python 3: Input and Output Lesson 2 with instructional videos

(0)
Computer Science new curriculum Python 3: Input and Output Lesson 2 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 GCSE (9-1) in Computer Science. Lesson outcome: To be able to change input data from one data type to another. Lesson Aim: To be able to cast data types entered using the input function. 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 videos cover data types, string, integer, float, boolean, casting.) differentiated exercises, and the completed python files. Download all the files into the same folder and run Python Input Output Power Point 2. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit
Python 3:  Input and Output Lesson 1 with instructional videos
wsparrowwsparrow

Python 3: Input and Output Lesson 1 with instructional videos

(0)
Computer Science new curriculum Python 3: Input and Output Lesson 1 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 GCSE (9-1) in Computer Science. Lesson outcome: To be able to write a program that uses simple input and output functions. Lesson Aim: To use the input function asking the user for information, print this and output to the python shell 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 videos cover IDLE, input, output, print, comments, functions) differentiated exercises, and the completed python files. Download all the files into the same folder and run Python Input Output Power Point. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit