Hour of Code – Virtual SPIKE Prime Coding

Do Now!

Click on this link and read the instructions

Once you have read the instructions, you can launch the first activity on the bottom of the page

That is your chance to have a play before you access the rest of the course (Hour of Code)

When you want to move on, press Close Activity and continue with the rest of the course

Continue through the rest of the course using the side menu

The next set of activities will be on the option Lesson: Moving Forward

Again, when you see launch activity, you can try the task

….and when you have finished, choose Close Activity and move down to the next one

There will also be some questions for you to answer

Have fun and go though all of the side menu

Most important, have some fun and enjoy this hour of code

Extra : Vice Bot

Iris Rover Challenge with VICE Virtual Robot

Do Now!

Find a definition of aerodynamic

What shape has the most aerodynamic drag?

Learning Objective

By the end of the lesson I will be able to apply my knowledge of aerodynamics to a rocket design.

Successful Learning Focus:

Understand that making mistakes is part of learning.

Challenge yourself

Key words:

Aerodynamics – the study of moving air and the interaction between the air and solids moving through it.

Drag – a type of friction that acts in the opposite direction of air.

Challenge: What might the most aerodynamic shape ever look like?

Why is it aerodynamic?

In a pair decide which you think would be the most aerodynamic and model this as a pair in plasticine.

Review : What is the difference between these two swimmers?

How does this relate to what we have learnt today?

A bit of fun

Rocket Builder

Do Now!

Watch this video about how Augmented Reality is used in cricket. No sound required.

Think : What are the benefits to using Augmented Reality in cricket.

Lesson Objective / Knowledge Intention :

Using presentation software (Google Slides) to make an interactive quiz.

The quiz questions must relate to Augmented Reality.

Adding shapes to the presentation and linking to other slides

This will also help to improve our own knowledge and understanding of Augmented Reality

Lesson Outcome / Knowledge Gained

Improved understanding of Augmented Reality

Learn how to make presentation software (e.g. Google Slides) interactive

Task

Open a new Google Slides or MS PowerPoint and create a multiple choice quiz about Augmented Reality

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.

On Google Slides

On MS PowerPoint

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

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

8. Now you can add more questions

What other questions could you use?

Note : it is possible to duplicate / copy your slides and change the questions

What does AR stand for?

What does VR stand for?

Which famous game used Augmented Reality to capture virtual creatures?

True or False : Augmented Reality is a technology that superimposes a computer-generated image on a user’s view of the real world, thus providing a composite view.

Do Now!

Open (or create) this document What is a Spreadsheet?

This can be made on Google Slides or MS PowerPoint

Look for a definition of a spreadsheet. Go to page 2 of your presentation and write down your answer.

Write this down in your own words

PowerPoint Version

If you finish this bit, then move on to complete the other slides (more details 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.

What does a spreadsheet look like? What can you see on this spreadsheet?

Benefits of Spreadsheets

A spreadsheet set up correctly saves time, saves effort, can be very accurate, works brilliantly for repetitive calculations, makes calculations much much faster than a human, can look at different scenarios i.e what happens if I apply VAT to the costs

What else?

Task

Continue with the rest of your presentation

Here are all the slides.

Practical Spreadsheet Task

The Shopping List – Extended Version

Open a new spreadsheet and create this shopping list as shown below

The yellow cells require a formula, which will be the Price multiplied by the Quatity

Use Borders and Shading and fill cells

Using borders

Using Shading

In cell E4, you need to put the formula to work out the Total Price of Crisps.

This will be Price multiplied by Quantity

See the suggeation below

Write a formula to work out the price of all of the other items.

Another Extension Task : Football table revisited

Create a Premier League football table like the one shown below. Add more teams and change some of the results.

Add more teams and change some of the results

Click here to play AI for Oceans

Level 1 : What is Machine Learning?

Level 2 : Training Artificial Intelligence

Is this a fish?

Level 3 and 4 : Does this belong in the water?

Level 5 : Training Data and Bias

Level 6 : Detecting types of fish

Level 7 : Social Impact of AI

Level 8

More Tasks on Code.org

If you have finished

Code Your Own Flappy Game

Do Now! Internet Research

Find a definition of Human Computer Interface

Open your workbook (Google Slides Presentation) and write down 3 things about HCI

Further Research : What is a CLI and what is a GUI?

Before we had Windows : Command Line Interface (CLI)

What is the point of this CLI?

What would an advantage of a computer interface like this be?

Can you think of any disadvantages?

Next……..

The first GUI (Graphical User Interface)

This is a graphical user interface, we’ve gone from typing commands in, to clicking on icons, this was a big leap forward

……..and then…..

Windows 95

Really starting to think about a user interface now

Which do people prefer and why?

The GUI is more user friendly and intuitive, this is where HCI comes in, a whole science has been built up around building user interfaces, and it’s called Human Computer Interaction or HCI

Can you think of a disadvantage of GUI?

Much more processing power and memory is needed in the device, and more expensive to make and buy

Some questions

1. Write down (in your own words) three things you found out about Human Computer Interaction.

2. State an advantage of the Command Line Interface

3. What is a GUI?

Following the principles of HCI should mean

You end up with a well designed computer interface, (tablet, PC, laptop, smart phone) which;

• is attractive and pleasing to the eye
• allows the user to try out different options easily
• be easy to use
• use suitable colours for key areas
• use words that are easy to understand aimed at the type of user
• have help documentation
• It should also consider the needs of the users.  For example, young children are likely to prefer pictures to words and people with disabilities may benefit from particular input or output devices.

What does the future hold for for HCI?

Do some research, what is the future of how humans interact with computers?  

I.e. will they still be hand held devices in the future?  What will happen to desktop computers?

Practical Task

Continue with the Google Slides presentation (template example of all slides shown below)

You will eventually be asked to create your own vision of the future. Have fun and use your imagination.

Slide 1

Slide 2

Slide 3

Slide 4

Slide 5

Slide 6

Slide 7

Slide 8

Slide 9

Slide 10

In this interactive short course, the learner joins Sakura and Nikau to learn about data, digital footprints, the Internet of things, Big Data, and the implications these have for us as people, and our future.

Do Now!

Go straight to Lesson 1 of Code Avengers, Big Data and Digital Footprints

Go through the tasks, making sure you understand the importance of Digital Footprint

Lesson 2 : The Internet of Everything

Go through to the other lessons contained on the side menu

Lesson 3 : The Internet of Things

Then go through the rest of the activities

More from Code Avengers

New Kids of the Blockchain

Today’s Task : Create a new product brand. Use presentation software to show how you would market it?

Choose a new product never been seen before, from either:

1. A brand new, very powerful smart phone
2. A luxury, extra special box of chocolates
3. Wearable technology to give the user medical statistics when they are exercising

….or it can be anything else that you have an interest in

Do Now Warm Up! Have a go at this Logo game

https://www.jetpunk.com/user-quizzes/139806/brand-logos-quiz-1

If you finish, press Next to go to the next quiz

If you are deciding on your GCSEs for next year, you may want to consider Business or Enterprise

Expect the course to look something like this

GCSE Business

100% Examination:

Paper 1 Exam 90 minutes – 50%

Paper 2 Exam 90 minutes – 50%

This course is Business theory based with one set of exams at the end of Year 11

Enterprise & Marketing

40/60 Examination and Coursework

Exam 90 minutes – 40%

Coursework 1 – 30%

Coursework 2 – 30% 

This course is a combination of practical and theory based learning with one examination opportunity

Main Task

Task : Create a new product brand. Use presentation software to (e.g. Google Slides or MS PowerPoint) to show how you would market it?

Choose a new product never been seen before, from either:

1. A brand new, very powerful smart phone
2. A luxury, extra special box of chocolates
3. Wearable technology to give the user medical statistics when they are exercising

Task in pairs or a group (maximum 4)

Consider designating roles for each member, e.g. project manager, graphics designer, quality controller, timekeeper, etc

Your designs should innovative. Have a look at this video.

You have to decide on the product

How you will promote the product?

What price you will sell it for?

Where will you sell the product?

You could create a logo using some free online tools

Hatchful

Link : https://www.shopify.com/tools/logo-maker

Or…….

……..you could use Sketchpad to draw your logo.

Link to Sketchpad : https://sketch.io/sketchpad/

There is a good choice of online logo makers featured here.

https://www.oberlo.com/blog/online-logo-maker-free

Your final product could look something like this……

Links to Logo Makers

Extra Tasks

If you have finished, you can start to make some of the products, i.s., the website and YouTube channel

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

Links to Digital Citizenship / Online Safety

Do Now Starter Task! Researching secondary data collection methods

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

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

Type in your postcode and find out what is happening in your area. Look at the following categories.

• Housing
• People
• Culture
• Employment
• Crime
• What is nearby

Lesson Objective / Knowledge Intention :

In this lesson, you will learn about:

• primary and secondary data collection methods
• how to collect primary data
• consider questions using a range of open and closed questions

Lesson Outcome / Knowledge Gained

• You will be able to use Google Forms or a free online tool for data collection
• You will be able to use different types of questions
• You can also use some data validation method

Task : Primary Data Collection

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.

What questions would you use?

Here are some suggestions

• Name
• Age
• Year group
• How many hours do you watch TV a day?
• What is your favourite TV program?
• How many hours do you play computer games each day?
• How often do you go online each day?
• How do you get to school?
• How would you feel if your phone was lost?
• Do you think you are addicted to your phone?
• Do you consider any risks when you go online?
• Do you believe everything you see online?
• Would you meet up with someone you are chatting online?
• Have you ever been bullied online?
• Do you have social media accounts?

There are many more questions that you could ask.

Think : Which of these questions are open or closed questions? Could I use age brackets?

How can I use data validation? Could I use an age range?

When you have finished, ask other students in your class to complete the form.