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

Bit:bots are go!

Delving deeper with BBC micro:bits – Project 4 Objectives Understand looping as a form of iteration Understand and use variables in a program Understand and use conditional statements Combine inputs, loops, conditional statements and variables to create a micro:bit game Lesson Resources Lesson Slides Delving Deeper with BBC micro:bits Project 1 – Bit:bopping music Project…

Read More

Inputs, loops, conditionals, variables… games!

Delving deeper with BBC micro:bits – Project 2 Objectives Understand looping as a form of iteration Understand and use variables in a program Understand and use conditional statements Combine inputs, loops, conditional statements and variables to create a micro:bit game Lesson Resources Lesson Slides Delving Deeper with BBC micro:bits Project 1 – Bit:bopping music Project…

Read More

Delving deeper with BBC micro:bits

About this unit: These lessons builds upon the foundations of our first micro:bit unit by providing a selection of exciting projects to extend your students and deepen their knowledge and understanding of physical computing with a BBC micro:bit. They will learn how to program music, create games, send secret coded messages between devices, and even…

Read More

Inputs, loops, conditionals, variables… games!

Taking micro:bits further – Lesson 5 Objectives Understand looping as a form of iteration Understand and use variables in a program Understand and use conditional statements Combine inputs, loops, conditional statements and variables to create a micro:bit game Lesson Resources Lesson Slides 3D Design Lesson 1 –  Lesson 2 –  Lessons 3 & 4  Lessons…

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