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 – What is the Internet? Lesson 3 – What is HTML? Lesson…

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 Inside the internet Lesson 1 – What is a network? Lesson 2 – What is…

Remixing the web

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 Inside the internet Lesson 1 – What is a network? Lesson…

What is HTML?

Inside the internet – Lesson 3 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…

What is the Internet?

Inside the internet – Lesson 2 Objectives To understand how data travels around the Internet To know how internet servers are connected To know and explain the job that routers do in the Internet Lesson Resources Lesson slides Internet Use Homework Sheet Large sheets of paper/card Sticky tape Ball of string Inside the internet Lesson…