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.
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.
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
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.
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
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.
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
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
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: 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
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: 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: 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 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.
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)
GCSE Computing Hardware components
Backup and storage media
This is a PowerPoint file that goes through the different backup and storage media necessary for computing.
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
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
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
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.