Be Aware Of What You Share


Learning Objectives:

  • Reflect on the concept of privacy, including what they feel comfortable sharing and with which people.
  • Analyse different ways that advertisers collect information about users to send them targeted ads.
  • Identify strategies for protecting their privacy, including opting out of specific features and analysing app or website privacy policies.

Key Vocabulary: 

  • cookies
  • privacy
  • privacy settings
  • privacy policy
  • terms of service
  • opt out

In progress : To be completed

What’s the Weather? (Spreadsheets + Internet Research)

Do Now! go to

Go to your home town and explore the weather and find out other facts

Explore famous cities around the world and compare the weather forecasts

Learning Objective / Knowledge Intention: To log data taken from online sources within a spreadsheet.

Unit Objectives: Researching and storing data in a spreadsheet; designing a weather station which gathers and records data; learning how weather forecasts are made and using green screen technology to present a weather forecast.

Learning Outcome / Knowledge Gained : Create a table in a spreadsheet. Search the Internet for information about the weather. Record findings in the spreadsheet

Task :

Open a new spreadsheet

Google slides or MS Excel are examples of a spreadsheet

1. Create a table, enter the information as shown below

2. Use the border tool to format the table

3. On search for your home town

Record the information that you find on your spreadsheet

Find information about more places around the world. Add this information to the spreadsheet.


Add some more fields to your table

You could also include;

  • Currency
  • Language
  • Country Dialling Code
  • Time Zone
  • Population
  • Flag
  • + more

Success Criteria

  1. You have have created a table in a spreadsheet using borders
  2. You have coloured some of the cells
  3. You have researched entered the records for 5 cities
  4. You have added 2 or more fields and entered those records too

IT Design Tools – Wireframes

There are a different design tools that can be used to design a solution.

  • flow charts
  • mind maps
  • visualisation diagrams
  • wireframes

Here is a Knowledge Organiser for Wireframes

In this lesson, we will focus on Wireframes. These can be used as a tool to design a website

For examples, this is the BBC Bitesize website

The design for this website can look something like this.

This would be a low fidelity wireframe, as it does not show any pictures or logos. We could add more exact details to make a hi-fidelity wireframe

Here is another example of a Wireframe, for a YouTube channel

Your task

1. Create a low-fidelity wireframe for the home page for the BBC website

or you can choose a business, such as Domino’s

2. Make a copy of your wireframe and convert it to a high-fidelity wireframe

A high-fidelity wireframe will include some pictures or a logo or any other graphics that may be used.

High-fidelity wireframe for Domino’s

Learn Python with Ozaria

Everybody loves coding using Python. We were born for this.

Ozaria is a fantastic online games which is challenging and fun. At the same time, we are using Python code to solve problems.

Do Now!

Open Ozaria

Click here to start coding with Ozaria

Either use the class code given to you by your teacher, or you can play now.

You can then start the puzzles. You will be able to;

  • Customise your hero
  • Watch the introduction video (subtitled if no sound)
  • See the progress map

Learning Objective / Knowledge Intention

Script Python code, to solve a range of puzzles.

Coding skills used

  • Sequencing
  • Selection
  • Loops

Lesson Outcome / Knowledge Gained

Go to Ozaria online and successfully complete the puzzles.

Here is the secomd puzzle. You have to move the hero to the red flag, by using Python Code

Here is the solution

Remember, it will get progressively harder, so you go through the levels

Here is the solution

Which does work; however, there is lots of code being repeated. There is a solution for that, which I found at the code bank.

Go through the map and check your progress

Remember to follow the instructions


have fun!

Some Codes

Suki’s Skate Shop Spreadsheet

Do Now!

Before we start the lesson, typing practice is a nice way to settle ourselves down. Have a 10 minute practice.

Click here to play Monkeytype

In this lesson, you will be creating s spreadsheet model for Suki’s Skate Shop

What is a spreadsheet?

I like to this of a spreadsheet, as a very large piece of paper, where we can make lots of calculations.

There appears to be lots of boxes. These boxes are known as cells.

Each cell has a cell reference.

The cell reference is the column letter followed by the row number. The cell reference for the green cell above is B3.

Knowledge Intention / Learning Objective : Create a spreadsheet based on a Skate Shop

Use borders and shading to format the table

Use formula to work out the price of Skating Equipment

Apply a 20 % Discount

Open a blank spreadsheet (MS Excel or Google Sheets) and create a spreadsheet table based on the one below

Task : Create the spreadsheet as shown below (the teacher may give you a template)

Add the following items to your spreadsheet

You can also add some extra items of your own


You need formula to calculate the total price.

This will be Unit Sales – Price Per Unit

The Discount per item, which is the Price Per Unit * 20%

The actual Price per Unit, which is the Price per Unit – Discount

The Revenue, which is the Discounted Price Per Unit * Unit Sales

Extension : Working out a discount

Add 2 more columns

Notice that you have to use the dollar sign on the cells to work out the discounted price

Using borders

Using Shading

Knowledge Organiser

Making a Knowledge Organiser

Below is part of a eBook which focuses on Flow Charts

We can also organise this information to make our own Knowledge Organiser

Notice that in the above organiser, the user has included;

  • Components of a flowchart (with an example)
  • Advantages and disadvantages
  • Purpose / What they are used for
  • Quiz
  • Key Vocabulary

Lesson Objective / Knowledge Intention

Create a knowledge organiser about Flowcharts

Lesson Outcome / Knowledge Gained

Go to presentation software (such as MS PowerPoint or Google Slides)

Develop a knowledge organiser with relevant information

Keep consistent colour schemes

You could take any topic and create a Knowledge Organiser

Here is one about Wire Frame Diagrams

Notice the colour schemes that have been used

Here is another example of a FlowCharts Knowledge Organiser


Now create your own Knowledge Organiser. Use a text book for information and design it in your way.

Open Google Slides

Set the paper size to A3, the best ones can be printed an put on display

Use the above examples to help you

Have fun

If you finish one, get some feedback from a teacher or class friend

Create another Knowledge Organiser about a topic of your choice

How to change your document to A3

More Examples

Relational Databases

Do Now! Go ro BBC Bitesize. Read all the information about Databases and then do the quiz

BBC Bitesize

Learning Objective : Create a relational database with at least 3 tables

Use the database to enter records

Choose appropriate field name

Use the Lookup wizard to link data from each table

Use data validation rules so that the user enters sensible data

Key Words : Table, records, fields

Data Types, Text, Number, Alphnumeric, Boolean and Date

How to create a simple relational database in MS Access

Open a new MS Access Database and call it Library

You need to create 3 tables

  1. Customer
  2. Lend
  3. Book

Table 1 : Customer

Go to Design View and add 3 fields

  • CustomerID
  • FirstName
  • Secondname

Make sure CustomerID is the primary key and has the Data Type, Autonumber

Go to the Datasheet View and enter a record.

Table 2 : Book

To create a new table in the same database, go to Create > Table

Call the new table, Book

Go to Design View and add 2 fields

  • BookID
  • Title

Make sure BookID is the primary key and has the Data Type, Autonumber

Go to the Datasheet view and enter a record

Table 3 : Lend

Call the new table Lend

Go to Design View and add 3 records

  • LendID
  • CustomerID
  • BookID

Make sure BookID is the primary key and has the Data Type, Autonumber

Making relationships using the LookUp Wizard

Go to the Data Type for Customer ID, and choose LookUp Wizard (later, do the same for BookID)

Choose the first option

Choose which table you want to relate it to

Then follow as shown below

Repeat the process for BookID

Let’s check your database

Go the Datasheet view and enter a record.

Go to Table and Relationships

You should see relationships that look like this

Extension tasks

  1. Add more relevant fields to the records in your database
  2. Create more tables (e,g, gender) and find a way to relate it to your existing database
  3. Create a new database for a DVD shop, e.g CEX Flappy Game + Express Course

Do Now!

Flappy Code

Code your own Flappy Game

Follow the instructions to complete the Flappy Game.

Click here to code using Flappy Code

You can watch the following video to help you

Lesson Objective / Knowledge Intention

Learn computer science by trying the lessons below at your own pace!

Learn to create computer programs, develop problem-solving skills, and work through fun challenges!

Make games and creative projects to share with friends, family, and teachers. Express Course

Task : Learn block coding by taking the Express Course

Click here to access the Express Course

Attempt all of the puzzles.

Watch this video to help you

Success Criteria

I have completed Flappy Birds

I have completed Lesson 1 of the Express Course, i.e. Programming with Flappy Birds

I have completed Lesson 2 of the Express Course i.e. Debugging in Maze

I am able to go through the course independently to complete the tasks

How is your progress?

Go to the Course Overview to see how you are progressing

Learn Python using Parson’s Problems

Do Now!

Before we start the lesson, typing practice is a nice way to settle ourselves down. Have a 10 minute practice.

Click here to play Monkeytype

Everybody loves Python.

In this lesson, you will learn Python by using a website called Parson’s Problems.

You may have a question like this….

Which you can rearrange to something like this

Learning Objective / Knowledge Intention

Arrange blocks of Python code, using an online tool called Parson’s Problems. Topics covered;

  • Sequencing
  • Selection
  • Loops

Lesson Outcome / Knowledge Gained

Learning basic concepts of Python, by arranging blocks of code to solve a problems

Success Criteria

  • Complete 8 exercises
    • 1-4 Sequencing
    • 1-4 Selection

  • Complete 12 exercises as above +
    • 1-4 Looping with For

Extra Success

  • As above +
    • 1-4 Looping with While

Click here to access Parson’s Problems

Task : Go through the puzzles

If your solution is correct, the blocks will go green. If it is incorrect, it will be red.

You can try to Debug

If you complete the task, you can use the arrow keys to go to the next or previous puzzle


you can select the list and see how many tasks you have completed


You may have a question like this

Which can be rearranged to something like this

….and let’s not forget Old MacDonald

You will need to rearrange the code to get the code to work and be complete.

Suggested follow up tasks

  1. Create a presentation (using Google Slides) about Python. Use some print screens of your solutions
  2. Go to trinket and try typing some of the code

Can you choose any 5 of those programs and then code them onto Trinket –

This lesson is progressive, the tasks will become more challenging, if they are too easy, jump ahead. You do not need your books, if you do need help use this Python cheat sheet to help

Blog at

Up ↑