Your task, create a World Cup database and make sure there are validation rules

Validation Tools Include

Data Type Check

Format Check / Input Mask

Length Check

Limited Choice

• drop down list
• radio buttons
• tick list
• lookup
• presence check
• range check

I have created this database planning table to start you along, but you can add fields

Task

1. Open Microsoft Access and open. Choose blank database

2. Call the database, Smurfs, then choose create

3. You will then be in the Table view. Change to Design view to create your table.

4. You will be asked to save the table. Call this Teams.

5. Create the database as shown below. Add the Field Names and Data Type. You must also write something for the description.

6. Go to the Data Type of Continent and Select Lookup Wizard.

7. Select , I willl type the values that I want and press Next

…and enter the values, as below

8. Go back to the Datasheet view

9. Enter a record for England. Use the information from this website to help you.

https://en.wikipedia.org/wiki/England_national_football_team

Extra Tasks :

1. In Design view, for each field, go to Field Properties and add some validation rules

2. Add your own field to the database

3. Create a new table called footballers. Design and create a database of football players. What fields would you use?

4. Instead of a drop down list, create a new table called continents. Then you can link the tables (relational database).

Success Criteria

1. I have created a database table
2. I have added fields so that I can enter records of footballers
3. I have changed the data types, auto number, number, text, Boolean and date
4. I have used a lookup field for one of my fields
5. I have entered some data validation rules in the description for all fields
6. I have entered 3 or more records
7. I can create my own database

Do Now!

Go to streetcheck.co.uk and find out about information about your area

https://www.streetcheck.co.uk/

Lesson Objective / Knowledge Intention :

In this lesson, you will learn about:

• primary and secondary data collection methods
• the advantages and disadvantages of each data collection method.

Task

Create a questionnaire or survey to ask your classmates about their screen time, including what they access, when and for how long. You should use a range of different question types.

Find a free online survey tool and create an online questionnaire/survey from your questions

To complete the task

Think of some open and closed questions that you will ask your classmates about their online habits.

You can use an online form like Google Forms

How would watching a 20 minute video about cats going to affect your day?

Task : Researching Secondary Data Collextion

https://www.streetcheck.co.uk/

https://www.metoffice.gov.uk/

Primary Sources Task

Scenario

You want to find out about students and their online habits

Create an online form to collect information about students

Everybody loves Python.

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

Choose 5 of the programs and then code them into Trinket

Learning Objective / Knowledge Intention

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

• Sequencing
• Selection
• Looping with ror
• Looping with while
• Using strings
• Using lists
• Writing subprograms
• Passing in parameters
• Using mod and div

Lesson Outcome / Knowledge Gained

Parson’s Problems

Access the following link: https://www.pythonsponge.com/pages.html?book=.%2Fparsons.json&chid=pseqc01

Example

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

Trinket

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

Interactive : allowing a two-way flow of information between a computer and a computer-user; responding to a user’s input.

We are going to make a presentation, but this time, it will require user input for it to work. We’ll make a quiz.

Lesson Objective : Make a quiz using presentation software (e.g. PowerPoint, Google Slides)

Add shapes and link them

Create questions for the user to answer

Task

1. Open a new presentation and create an introduction slide

2. Add a new slide and add a question

3. Add 2 more slides, for incorrect and correct answers

“Correct” slide

“Incorrect slide”

5. Now link your slides. Go back to the question slide and select the correct shapes (right click and choose link). Link the shape to the correct slide.

6. Go back to the question slide and select an icorrect shape (right click and choose link). Link it to the incorrect slide. Do this with all the other 3 incorrect shapes.

7. Test that it works. Fix any issues that you may have.

8. Change text colours, fonts and size. Format your shapes, change colours, etc.

More examples

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 open a blank spreadsheet and create the football league table as shown below

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.

Current World Cup Standings

Open a blank spreadsheet and create the football league table as shown below.

You will need to use borders and shading

Using borders

Using Shading

Change the games won, drawn and lost and see what happens to the points total

Change the goals scored and goals against and see what happens to the goal difference.

If you have finished, you can do another table. This one includes England.

You can add the table to the same sheet

If you have finished, you can add more tables

Current World Cup Standings

Do Now! Recap on the previous lesson about data types

Data validation means checking the accuracy and quality of source data before using, importing or otherwise processing data. Different types of validation can be performed depending on destination constraints or objectives. Data validation is a form of data cleansing.

Validation Tools Include

Data Type Check

Format Check / Input Mask

Length Check

Limited Choice

• drop down list
• radio buttons
• tick list
• lookup
• presence check
• range check

Example of a range check. Someone born in 1872 would be 150 years old.

Practical Starter Task

Find an online form and try and put some silly data, for example, say you were born in 1563.

Also, watch out for data types

Example, buy a train ticket

https://www.thetrainline.com/

Register for BBC (don’t press submit)

Sign up for BBC

Validation Tools Task

Look at the table below for validation tools and their purpose. Look at the examples for each one.

Radio button

Drop down list, the user has to choose one of the options

Postcode field uses an input mask to check that the format is correct

Task

Create or download a worksheet and write the purpose of each validation tool.

Double Entry

• The data is entered twice
• The data is then checked by comparing the two sets of data to make sure they are the same.
• The comparison can be done manually by a person or through a check by the digital system. 
• Manual double entry can be done by the same person or different people. 
• An example of digital system double entry verification is entering a new password twice. 

Manual Checking

• This is basically proofreading.
• The source data is compared with the data entered into the digital system. 
• Manual verification checks can be time consuming and expensive in terms of workload.

Question Time

1. What is the purpose of validation?

2. Length check is one validation tool. Identify two other validation tools.

3. How can the length check validation tool reduce errors?

4. Which validation tool should be used with a telephone number?

5. Describe one disadvantage of manual verification.

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

Lesson Objective / Knowledge Intention: What is Stop Motion animation?

How is it made?

What does frame by frame mean?

Task / Knowledge (Skills) gained : Use an online tool, FlipAnim, to make an animation

Example of Stop Motion. Wallace and Gromit.

How was Wallace and Gromit made?

How long do you think it took to make?

Practical Task

Click here to go to FlipAnim

https://flipanim.com/

Extra tutorial, watch this video to find out more.

If you enjoy Stop Motion, please have a look at this video

You can view more here : Stop Motion Animation – Health, Safety & E-Safety

Extra resource: Piskel

Make your own Stop Motion

Stop Motion Studio App

Use your mobile device to make Stop Motion animation. Download Stop Motion Studio.

Apple Store

Google Play Store

Do Now!

Before you get going, have a little bit of typing practice to settle yourself

https://monkeytype.com/

Watch some of these examples of AR technology, including Star Wars, Ikea and Cricket

AR Gameplay : Star Wars Jedi Challenge

Hope shopping : Ikea

Sports Analysis : Virtual Eye

Investigating AR and VR

Have a look at this website

https://datastudio.google.com/u/0/reporting/06d19701-75a2-4184-ad40-e2d6576c3f32/page/czbgC

Task : You will need to research a variety of existing applications of AR from at least three different areas of society looking at good and bad features and writing if it has any real value to society.

Record your findings. You could use a worksheet as shown below.

Extra task / question

What features you would have / avoid when you design your own AR application?

Google Arts and Culture

https://artsandculture.google.com/

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

Let’s start spreadsheets

Lesson Objective : Understand that a spreadsheet is made up of cells with cell references

Use formula to add cell references together. Also subtract, multiply and divide

Use the correct operators, +, -, * and /

Extra, create your own spreadsheet and make a shopping list

Learning Outcome : Download and open a spreadsheet files. Enter cell references

Create a simple shopping list spreadsheet

A spreadsheet program is made up of a large table, called a sheet.

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 below is B3.

Task 1 : The Wizard’s Challenge

Note : You may need to select Enable Editing

Enter the correct cell references into the appropriate cells in the table.

You can simply click on any cell to start typing into it.

You can also use the arrow keys on the keyboard to move from cell to cell.

Press the ENTER key once finished.

If the cell reference is correct, the cell will turn green.

Task 2 : The Formula Challenge

This week’s task

MS Excel Version : 2. The Gold MineDownload

Note : You may need to select Enable Editing

Instructions

Work out the answers to various calculations and if they are right, the cells will automatically turn gold.

You can enter formulae into cells to help work out the answers.

All formulae must begin with an = (equals) sign

See example in D7;

=B7+C7 will add the numbers of the 2 cells together

If you finish, you can go to level 2

Task 3 : The Shopping List

Task : Create a shopping list like the one shown below.

Open a blank Google Sheet or MS Excel file.

You can create your own shopping list, it could be clothes items, sports gear, electronics or anything else

Use 3 columns, shop, item and price

Use borders and shading to format your spreadsheet

Write a SUM formula so that adds up all of the shopping

Extension : Add 2 more columns to the spreadsheet, Quantity and Total Price.

Use a formula to work out the total price of each item.

For example : Total Price = Price * Quantity

Do Now!

Warm up with a little bit of typing practice

Dance Mat Typing Level 2

My Media Choices

Learning Objectives:

• Learn the “What? When? How Much?” framework for describing their media choices.
• Use this framework and their emotional responses to evaluate how healthy different types of media choices are.
• Begin to develop their own definition of a healthy media balance.

Try this quiz from Be Strong Online

Quiz – My Digital Life

Media Choice : think about how this media choice would make you feel, if it were a choice you had made.

Source : My Media Choices presentation

Discussion : How is watching a 20 minute video about cats going to affect your day?

My Media Balance Video

Task : Make a your own chart to track the media choices that you make. See this example.

Use pen and paper, or make your own on Microsoft Word (Create a Table)

Link to the above handout

Now watch some videos about Augmented Reality

Investigating AR