To be completed
Be Aware Of What You Share
Source: https://www.commonsense.org/education/uk/digital-citizenship/lesson/being-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 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
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 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

Success Criteria
- You have have created a table in a spreadsheet using borders
- You have coloured some of the cells
- You have researched entered the records for 5 cities
- 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
and
have fun!

https://www.ozaria.com/play/chapter-1-sky-mountain?hour_of_code
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.

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
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

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

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
More Examples


Relational Databases
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
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
- Customer
- Lend
- 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
- Add more relevant fields to the records in your database
- Create more tables (e,g, gender) and find a way to relate it to your existing database
- Create a new database for a DVD shop, e.g CEX
Code.org Flappy Game + Express Course
Do Now!

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

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

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.

Suggested follow up tasks
- Create a presentation (using Google Slides) about Python. Use some print screens of your solutions
- Go to trinket and try typing some of the code
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