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.

ECDL Week 3 Word

ECDL Week 2 Word

ECDL Week 3 Word

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.

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:  Create a simple script that animates the sprite automatically  Create a script that allows the user to control the movement of the sprite using the arrow keys  Combine the different scripts to work together on the same sprite  Make the sprite reverse direction  Edit the stage using the Paint Editor facility within Scratch  Make the sprite react to the background  Import a new sprite from the ones available within scratch  Create and edit new costumes for an existing sprite  Create a simple script that move the sprite automatically  Create variables to set the score and the countdown  Set a sprite to start in a certain position  Save your work

ECDL Week 4

Scratch 1.4 Lesson 6 – co-ordinates, subroutines, variables and user input 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 12 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  Add variables to your program to change the direction of movement  Use the broadcast feature in Scratch to create subroutines  Use subroutines to saves code and make the program more efficient and easier to edit  Enable user input to set the number of sides of each shape

Lesson 2 – Pac Man Style 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 12 page document. Learning Objectives You will understand how to: • Delete, resize and draw new sprites • Draw new costumes and use them to animate a sprite • Control the movement of a sprite using arrow keys • Design a maze on the stage • Make sprites interact with the background by using colours • Make sprites start in a pre-set starting position using co-ordinates • Make objects disappear and reappear in a random position • Create variables to set up scoring in the game • Make an autonomous sprite chase the sprite controlled by the player

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

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.

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

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

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 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.

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: 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.