Year 7

    Home / Year 7

Year 7

Year 7 – Overview

  • Term 1 – Spreadsheets
  • Term 2 – Programming with Smallbasic
  • Term 3 – Animation using Fireworks & Scratch
  • Term 4 – Using HTML to build web pages
  • Term 5 and 6 – Programming BBC Micro:bits

Year 7 Topics for Revision for End of Year Exams

The exam will take the format of an online multiple choice quiz with some short answer questions. The test should take around 45 minutes.

Introduction to Spreadsheets (Excel)

• Uses of spreadsheets
• Rows, columns and cells
• Formatting options
• How to reference cells (e.g A1, C2, D3:D6)
• Writing formulas (e.g .=A1 * 4)
• Using simple functions (e.g .SUM, MAX, MIN, AVERAGE)

More information on spreadsheets can be found here:

Animation Concepts

• Creating an animated gif in Fireworks
• Using a sequence of steps to create an animation
• Using Scratch to move sprites & switch backgrounds & costumes
• Using broadcasts in Scratch
Scratch homepage

Using Microsoft SmallBasic

Output text and numbers to the screen
Taking input from the user
• Using variables
• Using mathematical operators (eg +,-,* /)
• Using + to concatentate (add ) text together
Use if and else statements to perform selection
Use loops to perform repeated actions
• Use the simple turtle drawing interface
• Smallbasic can be downloaded here
Online tutorial

Introduction to HTML

• What HTML is used for
• Using HTML tags to build a simple web page
• Heading, paragraph, list, table, hyperlinks,  images, embedded videos
• Ability to write code accurately (e.g. matching brackets and open and closing tags)
• Ability to spot and fix errors
• Link to HTML cheat sheet
• Link to Mozilla Thimble   (all pupils will have usernames & passwords for this)

Programming the Microbit

• What is a Microbit?
• Features – Input & output devices and sensors
• List Languages that can be used
• Familiarity with simple block programming language
• Be able to output text & images
• Be able to take inputs (e.g. button press) and respond based  on the input
• Ability to design a simple algorithm
• Ability to spot & fix errors
Microbit programming interface

There may also be a few Computational Thinking puzzles from the BEBRAS Computational Thinking Challenge