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

13k+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.
Python 3: Using if, AND, OR, NOT command Lesson 4 with instructional videos
wsparrowwsparrow

Python 3: Using if, AND, OR, NOT command Lesson 4 with instructional videos

(0)
Computer Science new curriculum Python 3: Using if, AND, OR, NOT command Lesson 4 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 write programs using selection statements to handle complex conditions Lesson outcome: By the end of this lesson, you will be able to write programs that handle complex conditions including the use of Boolean operators 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: conditional statement, true, false, AND, OR, NOT.) differentiated exercises, and the completed python files Download all the files into the same folder and run the PowerPoint fiile. 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 3: Using if command Lesson 1 with instructional videos
wsparrowwsparrow

Python 3: Using if command Lesson 1 with instructional videos

(0)
Computer Science new curriculum Python 3: Using if command 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 Programming in Python for GCSE (9-1) in Computer Science. Lesson Aim: To understand how to create choices and decisions in a program using the if command. Lesson outcome: By the end of this lesson, you will be able to write programs that create decisions and choices in a program using the if statement 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, selection, conditional statement, decision, true, false) differentiated exercises, and the completed python files Download all the files into the same folder and run If command 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
Python 3: Using if, elif, else command Lesson 2 with instructional videos
wsparrowwsparrow

Python 3: Using if, elif, else command Lesson 2 with instructional videos

(0)
Computer Science new curriculum Python 3: Using if command 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 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 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, 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
Python 3: String Handling Lesson 2 with instructional videos
wsparrowwsparrow

Python 3: String Handling Lesson 2 with instructional videos

(0)
Computer Science new curriculum Python 3: String Handling 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 Programming in Python for GCSE (9-1) in Computer Science. Lesson outcome: To produce examples of how string handling can be used in computer programs. Activity Lesson Aim: To identify and explain how string handling can be used in computer programs. 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: strings, concatenation, string comparison, substitution and measuring length.) differentiated exercises, and the completed python files Download all the files into the same folder and run String Handling Lesson 2 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
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 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.
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 Week 2 Video
wsparrowwsparrow

ECDL Week 2 Video

(0)
ECDL Week 2 Video Complete ECDL week 2 video on how to teach ECDL. The nice thing about this video is that your students can watch it and do the assignment. You as a teacher are not involved in the actual teaching. It gives you the freedom to assist other students if they need help!!
ECDL Week 4
wsparrowwsparrow

ECDL Week 4

(0)
ECDL Week 4 Complete ECDL week 4 video on how to teach ECDL. The nice thing about this video is that your students can watch it and do the assignment. You as a teacher are not involved in the actual teaching. It gives you the freedom to assist other students if they need help!!
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.
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
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 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
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 4 – Monkey Game
wsparrowwsparrow

Scratch 1.4 Lesson 4 – Monkey Game

(0)
Scratch 1.4 Lesson 4 – Monkey 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 8 page document. 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