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 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.
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.
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 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: 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, 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.
Use Adobe Flash Player to create an animation in flash
This lesson comes with a Word document for the students to follow, the required image, as well as the completed Flash animation.
Lesson objectives:
Understand
How to make a simple animation
The purpose of Flash software
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.
Scratch 1.4 Lesson 5 - Creating Graphics
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 14 page document.
Learning Objectives
You will understand how to:
Delete a sprite and import a new sprite
Draw using the pen feature of scratch
Use the pen up and pen down feature
Change the colour of the pen
Set the position of the sprite using co-ordinates
Make a sprite appear and disappear using show and hide
Use the repeat function in Scratch
Use the broadcast feature in Scratch
Create simple subroutines
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
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.