Information and Technology Archives

Self-marking quizzes (Microsoft)

Spreadsheet masters – Lesson 6 Objectives Create a spreadsheet to test maths facts Use Conditional formatting to mark the questions Lesson Resources Lesson slides (Microsoft Excel version) Student activity sheet (Microsoft Excel version) Demonstration Spreadsheet activities Spreadsheet masters Microsoft Excel version Lesson 1 – What is a spreadsheet? Lesson 2 – The perfect formula Lesson 3 – Sort…

Sort it out (Microsoft)

Spreadsheet masters – Lesson 3 Objectives Use a spreadsheet to sort data quickly Recall features of a spreadsheet Lesson Resources Lesson slides (Microsoft Excel version) Student activity sheet (Microsoft Excel version) Demonstration Spreadsheet activities Students ‘LESSON 3’ spreadsheet to download as Excel Sheet Spreadsheet masters Microsoft Excel version Lesson 1 – What is a spreadsheet? Lesson…

Self-marking quizzes (Google)

Spreadsheet masters – Lesson 6 Objectives Create a spreadsheet to test maths facts Use Conditional formatting to mark the questions Lesson Resources Teacher’s presentation Student activity sheet Demonstration Spreadsheet activities Google Sheets General spreadsheet guidance How to use Google Sheets Excel Quick Start Guide Basic tasks in Excel Spreadsheet masters Lesson 1 – What is…

Sort it out (Google)

Spreadsheet masters – Lesson 3 Objectives Use a spreadsheet to sort data quickly Recall features of a spreadsheet Lesson Resources Teacher’s presentation Student activity sheet Lesson 3 Student worksheet – 1 per child on paper or share via Google Classroom so they have their own digital copy Demonstration Spreadsheet activities Google Sheets Data sort video guide…

Spreadsheet Masters

About this unit: Hone your spreadsheet skills to become a spreadsheet master! Learn about the basics of spreadsheets with a range of fun tasks. Investigate sorting, using formulas and conditional formatting as you build towards making self-marking quiz games for your classmates. National Curriculum Links – Computing KS2 The content of this plan cover the…

More HTML and CSS tinkering

Inside the internet – Lesson 6 Objectives To independently edit HTML code and remix a web page To independently edit CSS code to change the style of a web page Lesson Resources Lesson slides Inside the internet Lesson 1 – What is a network? Lesson 2 – The data of The Internet Lesson 3 – Packets, routing…

HTML and CSS

Inside the internet – Lesson 5 Objectives To edit HTML code and remix a web page To edit CSS code to change the style of a web page To know that colours can be written as hexadecimal codes Lesson Resources Lesson slides HTML Activity website – A shortened URL to this has been created, so…

Packets, routing and reliability

Inside the internet – Lesson 3 Objectives To explain what an IP address is To understand how and why data travels around the internet in packets. Lesson Resources Lesson slides Sending data in packets The Internet – A network of networks worksheet Scissors Pencil crayons or other colours Inside the internet Lesson 1 – What…

What is HTML?

Inside the internet – Lesson 4 Objectives To understand that web pages are written in HTML To recognise simple HTML formatting language To view the HTML page in a browser To make simple edits to HTML and ‘remix’ a web page. Lesson Resources Lesson slides HTML Student help sheet Inside the internet Lesson 1 – What…

The data of The Internet

Inside the internet – Lesson 2 Objectives To understand how everything on the internet can be converted into binary data To understand how binary data travels around the Internet Lesson Resources Lesson slides Text to binary code card. Creating images with code Inside the internet Lesson 1 – What is a network? Lesson 2 – The…