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.

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

Computing / ICT KS 2/3 Create a PowerPoint time capsule This is a 22 page pdf unt of work with 9 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. This is a 22 page unit of work on how to create a time capsule using Microsoft PowerPoint, but can be used in Google Slides as well. (9 hours of lesson plans ) This includes the lesson plan and completed samples for this unit.

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.

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

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

ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets This is a 26 page unit of work on playing the London Stock Exchange using Microsoft Excel or Google Sheets. (8 hours of lesson plans with formal assessment at the end) It includes extensive lesson plans, completed samples and everything you need to run this module.

Python Version 3: Data Types This is a high resolution poster that shows the different data types 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 wall 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.

ICT KS 2/3 Start a company unit of work This is a 19 page unit of work on how to start a company using Word, Paint / Paint dot Net (11 hours of lesson plans with formal assessment at the end) This includes the lesson plan, all templates and completed samples for this unit. It includes creating your own logo, business card, letterhead, advertising and creating a brochure.

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

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

Computer Science new curriculum Python 3: Number guessing game 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 create a game where the user has to guess a number. 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: Import, variable, constant, print, while loop, if.) differentiated exercises, and the completed python files. Download all the files into the same folder and run Number game PowerPoint. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit

Computer Science new curriculum Python 3: Input and Output 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 GCSE (9-1) in Computer Science. Lesson outcome: To be able to format the output produced by the print function Lesson Aim: To understand how to format output using the print function. 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: input, output, print, function, format, concatenation.) differentiated exercises, and the completed python files. Download all the files into the same folder and run Python Input Output Power Point 3. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit

Computer Science new curriculum Python 3: Input and Output 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 change input data from one data type to another. Lesson Aim: To be able to cast data types entered using the input function. 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 cover data types, string, integer, float, boolean, casting.) differentiated exercises, and the completed python files. Download all the files into the same folder and run Python Input Output Power Point 2. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit

Computer Science new curriculum Python 3: Input and Output 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 GCSE (9-1) in Computer Science. Lesson outcome: To be able to write a program that uses simple input and output functions. Lesson Aim: To use the input function asking the user for information, print this and output to the python shell 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 cover IDLE, input, output, print, comments, functions) differentiated exercises, and the completed python files. Download all the files into the same folder and run Python Input Output Power Point. Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit