World Cup Database with Validation Rules

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

Learning Objective : Create a database table with fields of different data types.

Use the database to enter records

Use data validation rules so that the user enters sensible data

Key Words : Table, records, fields

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

Data and Testing : The Big Picture.

Current 3.2.2. Validation and verification

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

Data Collection Methods

Do Now!

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

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

The Big Picture

We have been looking at topic area 3 : Data and Testing.

Previous Lessons : Validation and verification

Current topic : Data collection methods

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

Learn Python using Parson’s Problems

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 Quiz – Google Slides Version

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

The big picture

What have we done? : This is our 3rd lesson on this topic. We know how to create new slides, add shapes and hyperlink

What are we doing? : We are going to complete at least one question in this lesson, some will create more than one

Where are we going? : We have learned so much about PowerPoint. We could now transfer those skills tio make a maze game,

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.

Success Criteria

1. I can open PowerPoint

2. I can create slide 1 (Splash Screen)

3. I can create a question slide

4. I can create an “incorrect” slide

5. I can create a “correct” slide

6. I can create at least one link

7. I can create 2 or more links

8. My Quiz has a nice design

9. I have tested the quiz

10. I can make a second question

More examples

Spreadsheets World Cup Tables

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.

Learning Objective : Create a set of World Cup based on current standings

Use borders and shading to format the table

Use formula to work out goal difference, games played and points won

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

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

You should use formula to work out;

  • Games played (Won+Drawn+Lost)
  • Goal difference (Goals Scored – Goals Against)
  • Points ((Games Won * 3) + (Games Drawn + 1)) Remember to use the correct brackets

Do not work them out manually. Use the formula as shown above.

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

Data Validation

Do Now! Recap on the previous lesson about data types

Knowledge Intention

In this lesson, you will learn about:

  • validation and verification
  • the purpose of validation and verification
  • validation and verification tools
  • how validation and verification tools can reduce errors. 

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

Data Validation

  • checks that the data being entered into a digital system is sensible and reasonable 
  • does not check that the data is correct
  • checks the data against pre-set rules
  • is usually carried out by the digital system at the point at which the data is being entered
  • is usually set as part of the creation of a solution.

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.

Data Verification

  • makes sure that the data entered exactly matches the original source
  • but, as with validation, verification does not check the data is correct.

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?
  1. Length check is one validation tool. Identify two other validation tools.
  1. How can the length check validation tool reduce errors?
  1. Which validation tool should be used with a telephone number?
  1. Describe one disadvantage of manual verification.

Using Stop Motion

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

The Big Picture

What have we done? This is our introduction to animation, but we would have used some drawing software

What are we doing now? We will be using FlipAnim to learn how Stop Motion animation is made

Where are we going? We will learn to create moving sprites using Piskel

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.

Success criteria

Some success, I can use FlipAnim to make a dot move around the screen

Better success, my dot moves around fluently.

Extra success, I can experiment and make some original animations

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

https://www.piskelapp.com/

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

Investigating AR

Do Now!

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

https://monkeytype.com/

Lesson Objectives / Knowledge Intention

In today’s lesson you need to explore some examples of how AR is being used in each of the following areas of society.

  • Entertainment
  • Medicine
  • Education
  • Design and Manufacturing
  • Law enforcement

Lesson Outcomes / Knowledge Gained

Investigate examples of existing AR and show your results (e.g. worksheet)

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/

Introduction to Spreadsheets

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

The Big Picture

What have we done? This is our first spreadsheet lesson

What are we doing? We are going to use a spreadsheet and enter cell references and formula

What are we going? We will use spreadsheets to make lots of calculations

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

My Media Choices

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.

Key Vocabulary: media, media balance, media choices

media: all of the ways that large groups of people get and share information (TV, books, internet, newspapers, phones, etc.)

media balance: using media in a way that feels healthy and in balance with other life activities (family, friends, school, hobbies, etc.)

media choices: time spent watching, listening to, reading, or creating media

Try this quiz from Be Strong Online

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

Success Criteria

I am aware of the media that I use and how my choices affect my life

I can use media sensibly

Now watch some videos about Augmented Reality

Blog at WordPress.com.

Up ↑