,
Message sent from:

Year 6 - Autumn 1 - Learning log - Spreadsheet creators

Header

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

Header

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

Lesson 1 - E-Safety - Key Question: What is fake news?

Discussion on that some content online is purposefully there to trick you, e.g. fake news.

Children create a ‘fake news’ social media campaign to attract more children to our schools instead of other schools in the area.

Lesson 2 - Key Question: How could we collect data?

Learners will collect and organise data in a format of their choice. They will then explore how data can be structured in a table. Finally they will input data into a spreadsheet.

Lesson 3 - Key Question: What is an item of data?

Learners will develop their understanding of the structure of a spreadsheet. They will be introduced to cell references, data items and the concept of formatting cells. Learners will see data items formatted in different ways, they will then choose formats for data items before applying formats in their own spreadsheet. The children collected data by searching how far the school was from a range of attractions around the country. They then formated these columns and added forumlas to work out the total cost.

Lesson 4 - Key Question: How can formulas help in the real world?

Learners 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). Learners will create formulas to use in a spreadsheet using cell references and identify that changing inputs will change the output of the calculation.

Lesson 5 - Key Question: How can formulas help in the real world?

Learners will calculate data using the operations of multiplication, subtraction, division, and addition. They will use these operations to create formulas in a spreadsheet. Learners will then begin to understand the importance of creating formulas that include a range of cells and the advantage of duplicating in order to apply formulas to multiple cells.

X
Hit enter to search