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.
E Safety Unit Lesson 1 KS 2 - 3
wsparrowwsparrow

E Safety Unit Lesson 1 KS 2 - 3

(0)
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.
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.
Functional Skills ICT Level 1: Set Wallpaper and send e-mail with attachment
wsparrowwsparrow

Functional Skills ICT Level 1: Set Wallpaper and send e-mail with attachment

(0)
Functional Skills ICT Level 1: Set Wallpaper and send e-mail with attachment 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: Set Wallpaper and send e-mail with attachment 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: 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: Preparing a notice for a noticeboard
wsparrowwsparrow

Functional Skills ICT Level 1: Preparing a notice for a noticeboard

(1)
Functional Skills ICT Level 1: Preparing a notice for a noticeboard 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 notice for a noticeboard 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: Preparing a poster with a password protected file
wsparrowwsparrow

Functional Skills ICT Level 1: Preparing a poster with a password protected file

(0)
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.
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.
Functional Skills ICT Level 1: Processing numerical data with graphs
wsparrowwsparrow

Functional Skills ICT Level 1: Processing numerical data with graphs

(0)
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 Finding information from the internet
wsparrowwsparrow

Functional Skills ICT Level 1 Finding information from the internet

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

Python 3: Iteration Lesson 1 with instructional videos

(0)
Computer Science new curriculum Python 3: Iteration 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 introduce count-controlled loops and create a dice game using a while loop Lesson outcome: By the end of this lesson you will understand the typical uses of count-controlled loops. You will be able to write Python code that uses count-controlled loops. This 1 hour lesson comprises of: (although this could be a 2 hour lesson) 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: Iteration, count-controlled, for loop 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: Selection 4 x 1 hour lessons with instructional videos
wsparrowwsparrow

Python 3: Selection 4 x 1 hour lessons with instructional videos

4 Resources
Computer Science new curriculum Python 3: Selection 4 x 1 hour lessons with instructional videos **if, elif, else, selection, conditional statement, decision, true, false, AND OR, NOT 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: String Handling  2 x 1 hour lessons with instructional videos
wsparrowwsparrow

Python 3: String Handling 2 x 1 hour lessons with instructional videos

2 Resources
Python 3: String Handling 2 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 the PowerPoint file. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit
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, elif, else command Lesson 3 with instructional videos
wsparrowwsparrow

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

(0)
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
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: 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: 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
Python 3: String Handling Lesson 1 with instructional videos
wsparrowwsparrow

Python 3: String Handling Lesson 1 with instructional videos

(0)
Computer Science new curriculum Python 3: String Handling 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 outcome: To produce examples of how string handling can be used in algorithms. Lesson Aim: To produce examples of how string handling can be used in algorithms. 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: array, string, string comparison,substitution, join, split and measuring length) 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
Spreadsheets Basics Lesson 3
wsparrowwsparrow

Spreadsheets Basics Lesson 3

(0)
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.
Spreadsheets Basics Lesson 2
wsparrowwsparrow

Spreadsheets Basics Lesson 2

(0)
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.