Mail Merge Office 2010 Book 3 This is a 7 page booklet for the students to use to create a mail merge with instructions and screen shots for ease of use. Mail merge is used for tasks where many copies of a document must be made each one having slightly different personal details such as standard letters that need to be individually addressed. In this exercise you will learn how to: 1. Add new field names and change the standard ones given in WORD. 2. Insert your new field names into the text of a letter.

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

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

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)

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.

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.

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.

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

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

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

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