Listing all results (12216)

Lesson 6 - Presenting data

During this lesson, pupils will acquire the skills to create charts in Google Sheets. They will evaluate results based on questions asked using the chart that they have created. Finally, pupils will outline their understanding that there are different software tools available within spreadsheet applications to...

Lesson 5 - Event planning

During this lesson, pupils will plan and calculate the cost of an event using a spreadsheet. They will use a predefined list to choose what they would like to include in their event, and use their spreadsheet to answer questions on the data they have selected. Pupils will be reminded of the importance of organising...

Lesson 4 - Calculate and duplicate

During this lesson, pupils will recognise that data can be calculated using different operations: multiplication, subtraction, division, and addition. They will use these operations to create formulas in a spreadsheet. Pupils will then begin to understand the importance of creating formulas that include a range of...

Lesson 3 - What's the formula?

During this lesson, pupils will begin to use formulas to produce calculated data. They will understand that the type of data in a cell is important (e.g. numbers can be used in calculations whereas words cannot). Pupils will create formulas to use in their spreadsheet using cell references and identify that...

Lesson 2 - Modifying spreadsheets

During this lesson, pupils will be taught that objects can be described using data. They will build a data set (a collection of related data that can be manipulated using a computer) within a spreadsheet application, and apply appropriate number formats to cells.

Learning objectives

  • To...

Lesson 1 - What is a spreadsheet?

During this lesson, pupils will understand that a spreadsheet is a computer application which allows users to organise, analyse, and store data in a table. They will begin to realise the importance of data headings. Pupils will answer questions about a spreadsheet, and then create their own questions that can be...

Data and information – Spreadsheets Overview

In this unit, Year 6 pupils will build on their understanding of Data and Information, by using and manipulating spreadsheets. Teach Computing have provided a detailed Unit Overview and Learning Graph which explain each theme and how they link...

Lesson 6 - Think before you link!

In this lesson, pupils will consider the implications of linking to content owned by other people and create hyperlinks on their own websites that link to other people’s work. They will then evaluate the user experience when using their own website and that of another pupil.

Learning objectives

...

Lesson 5 - Follow the breadcrumbs

During this lesson, pupils will begin to appreciate the need to plan the structure of a website carefully. They will plan their website, paying attention to the navigation paths (the way that pages are linked together). They will then create multiple web pages for their site and use hyperlinks to link them together...

Lesson 4 - How does it look?

In this lesson, pupils will revise how to create their own web page in Google Sites. Using their plan from previous lessons, pupils will create their own web page/home page. They will preview their web page as it will appear on different devices and suggest or make edits to improve the user experience on each...

Pages

View all publishers