To be completed

Source: https://www.commonsense.org/education/uk/digital-citizenship/lesson/being-aware-of-what-you-share

Key Vocabulary: 

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

In progress : To be completed

Do Now! go to timeanddate.com

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

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 timeanddate.com 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.

Extension

Add some more fields to your table

You could also include;

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

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

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

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

and

have fun!

https://www.ozaria.com/play/chapter-1-sky-mountain?hour_of_code

Some Codes

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.

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

Formula

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

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

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

Task

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

Change Slide Size in Google Slides! [Complete Guide!]

More Examples

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

BBC Bitesize

https://www.bbc.co.uk/bitesize/guides/zvnny4j/revision/1

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

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

code.org 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

How is your progress?

Go to the Course Overview to see how you are progressing

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

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

Or

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

Example

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.

Can you choose any 5 of those programs and then code them onto Trinket – https://trinket.io/features/python3

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