The perfect formula (Google)

Spreadsheet masters – Lesson 2 Objectives Recall features of a spreadsheet Use cell references to complete formulae Use spreadsheets to complete formulae quickly and easily Lesson Resources Teacher’s presentation Student activity sheet  Lesson 2 Student worksheet –  1 per child on paper or share via Google Classroom so they have their own digital copy Demonstration…

Read More

What is a spreadsheet? (Google)

Spreadsheet masters – Lesson 1 Objectives Explain what a spreadsheet is; Describe how a spreadsheet could be used by someone at work; Label the different areas of a spreadsheet using the correct vocabulary; Create simple formulae in a spreadsheet. Lesson Resources Teacher’s presentation Student activity sheet (Share this link with your class – please see…

Read More

Analysing your findings and writing up your report

Making the news, part 1 – Lessons 5 & 6 Objectives undertake creative projects that involve selecting, using, and combining multiple applications to achieve challenging goals, including collecting and analysing data and meeting the needs of known users.   Analyses and evaluates data and information, and recognises that poor quality data leads to unreliable results, and…

Read More

Carrying out your investigation

Making the news, part 1 – Lessons 3 & 4 Objectives undertake creative projects that involve selecting, using, and combining multiple applications to achieve challenging goals, including collecting and analysing data and meeting the needs of known users   understand a range of ways to use technology safely, respectfully, responsibly and securely, including protecting their online…

Read More

Planning a news investigation

Making the news, part 1 – Lesson 2 Objectives Work collaboratively to effectively plan a research project Understand the ethics or safe practises of data collection and storage To understand how and why to give credit to external sources used in work Lesson Resources Lesson Slides Making the news – Part 1   Lesson 1…

Read More

Our news sources

Making the news, part 1 – Lesson 1 Objectives Create, re-use, revise and re-purpose digital artefacts for a given audience, with attention to trustworthiness, design and usability Make judgements about digital content for credibility when evaluating and repurposing it for a given audience. Lesson Resources Lesson Slides Ofcom news consumption infographic Making the news -…

Read More

Making the news – Part 1

About this unit: This unit is split into two parts. This first part requires students to examine the sources we use for our news, critique what they find online for credibility, and then plan, research and carry out their own investigative report linked to their school or local community. National Curriculum Links – Computing KS3 The…

Read More

Technology in the world around us

Keeping Safe and Exploring Technology – Lesson 4 Objectives Know when and why to take breaks from device time. Consider the feelings of people around them, even when engaged in fun online activities. Lesson Resources Keeping Safe and Exploring Technology – Lesson slides Technology in the supermarket – sort and stick activity – Version 1  …

Read More