To develop problem solving / computational thinking skills
To develop problem solving / computational thinking skills
Try these problems
Natural Selection
Parking
Pixel quest
Jigsaw
Boxed
Building demolisher
Island of creatures
_____________________________________________
How to make a video clip using
movie maker
movie maker
Click this link to download video and sound clips
use the story board to organize your assets
Share today's work with your test buddy say;
What went well
and get them to say how it could be;
Even better if
What went well
and get them to say how it could be;
Even better if
_____________________________________________________
Use the 'text to speech' program and
Audacity to create a short sound clip
Audacity to create a short sound clip
MORBIUS
It all
started a long time ago in a galaxy far, far away. We come from Blarg, a
planet in the vicinity of Sirius.
planet in the vicinity of Sirius.
KLAATU
You cannot be Sirius.
MORBIUS
I am. Deadly
Sirius.
KLAATU
That’s just our little joke.
MORBIUS
Anyway, my
people decided to send some scientists out around the universe to
find out about other life-forms. ‘The truth is out there’ – that’s what they used to say.
I was one of those scientists and I was sent here. My job is to learn about Earth and
your customs.
find out about other life-forms. ‘The truth is out there’ – that’s what they used to say.
I was one of those scientists and I was sent here. My job is to learn about Earth and
your customs.
KLAATU
And then – thanks to the professor here – we crashed. And
we haven’t got any fuel
to get home again.
to get home again.
Copy and paste the above script into the
text to speech program create an audio file
using 2 different voices then in Audacity
modify the voices to sound like aliens
text to speech program create an audio file
using 2 different voices then in Audacity
modify the voices to sound like aliens
Click on this link to download some sound effects
combine some of the sound clips to create a new sound
clip
Share today's work with your test buddy say;
What went well
and get them to say how it could be;
Even better if
What went well
and get them to say how it could be;
Even better if
Understand: How a sound project can be made up of many different part.
How: Using Audacity how to add sounds in appropriate places.
Be able to: Take appropriate sounds and make a comprehensive story to listen to.
List to the Beowulf clip . What are the different sound you can hear?
Create a folder in you ICT folder call Beowulf.
To import a sound into Audacity:
- Open Audacity.
- From the main menu, select File, Import, and then Audio.
The audio selection window is displayed.
- Choose the sound files from your computer, and then click on Open.
A new track is added to your project at the very bottom of the project window
Mute all the sound clips except the narrator clips.
Start by using the selection tool to copy and paste the narration parts together.
Listen to the Beowulf clip and Identify the first sound effect and unmute it.
Use the timeshift tool to slide the sound clip to the correct position on the time
line.
Continue to listen to the Beowulf clip and identify the next sound effect.
Unmute it. Use the timeshift tool to slide the sound clip to the correct position
on the time line.
Repeat this process till you have reconstructed the Beowulf clip.
Watch as I demonstrate how to
- Adding a sound clip to Audacity
- Adding a second sound clip
- Getting a sound track to repeat
- Deleting part of a sound track
- Adding silence before a sound track
- Fading sounds in or out
- Muting a sound track
- Changing voice pitches on a sound track
- Changing the volume of a sound track
- Adding a blank audio track
- Deleting a sound track
- Zooming in and zooming out of a sound track
- Exporting the audacity project as a .wav
You can look at this video, to see these techniques
How: Using Audacity how to add sounds in appropriate places.
Be able to: Take appropriate sounds and make a comprehensive story to listen to.
- Open Audacity.
- From the main menu, select File, Import, and then Audio.
The audio selection window is displayed. - Choose the sound files from your computer, and then click on Open.
A new track is added to your project at the very bottom of the project window
Mute all the sound clips except the narrator clips.
Start by using the selection tool to copy and paste the narration parts together.
Listen to the Beowulf clip and Identify the first sound effect and unmute it.
Use the timeshift tool to slide the sound clip to the correct position on the time
line.
Continue to listen to the Beowulf clip and identify the next sound effect.
Unmute it. Use the timeshift tool to slide the sound clip to the correct position
on the time line.
on the time line.
Repeat this process till you have reconstructed the Beowulf clip.
Watch as I demonstrate how to
- Adding a sound clip to Audacity
- Adding a second sound clip
- Getting a sound track to repeat
- Deleting part of a sound track
- Adding silence before a sound track
- Fading sounds in or out
- Muting a sound track
- Changing voice pitches on a sound track
- Changing the volume of a sound track
- Adding a blank audio track
- Deleting a sound track
- Zooming in and zooming out of a sound track
- Exporting the audacity project as a .wav
You can look at this video, to see these techniques
compare your audio file, with the original you heard at the
start of the lesson. How close do they match?
Share today's work with your test buddy say;
What went well
and get them to say how it could be;
Even better if
What went well
and get them to say how it could be;
Even better if
_________________________________________________
Developing skills in Adobe Photoshop
- To develop your confidence and new skills using Adobe Photoshop
- You will have learnt to use at least 1 new skill in Photoshop
Is it real or Photoshop ? Click here to try
What can you create?
Photoshop CS5 Tutorial - Basic tools
Basic Photoshop (CS5) Tutorials - Layers
How to use the Photoshop Free Transform mode
Photoshop Tutorial Using Layers in Photoshop CS5
Photoshop Cs5 Tip: Fill vs Opacity Explained
Test your understanding with this quiz
Share today's work with your test buddy say;
What went well
and get them to say how it could be;
Even better if
What went well
and get them to say how it could be;
Even better if
_________________________________
Try these Logic games
What is a form. query and report in a database
Click here and watch the presentation
from the point marked
from the point marked
Use these on line database to perform
the following searches
the following searches
Find for me an advanced drone
Find me the cheapest flight from Southampton
airport to Amsterdam departing on Oct 21st
airport to Amsterdam departing on Oct 21st
returning on Oct 25th for 1 adult
Find me a new
black ford Mondeo estate
black ford Mondeo estate
engine size 1.6 Litre diesel
within 50 miles of SO45 4RQ
Test your understanding with this quiz
Share today's work with your test buddy say;
What went well
and get them to say how it could be;
Even better if
What went well
and get them to say how it could be;
Even better if
____________________________________________________
Understand what validation and verification
means
means
Create validation rules in a spreadsheet
Challenge
Can you add a validation rule to make sure the name
is between 1 and 10 letters (hint look back at the video)
Star Challenge
Can you use a validation rule to create a presence check
for a name (hint text length needs to be bigger than zero)
for a name (hint text length needs to be bigger than zero)
Use the Drop down box work sheet to
create a pizza cost calculator
create a pizza cost calculator
Use this template to complete the final task on worksheet
Challenge
Can you alter the spreadsheet so you can choose
1,2 or 3 Toppings
1,2 or 3 Toppings
Share today's work with your test buddy say;
What went well
and get them to say how it could be;
Even better if
What went well
and get them to say how it could be;
Even better if
_____________________________________________________
-----------------------------------------------------------
LESSON 4
To understand what the terms Data validation and verification mean
To be able to create validation and verification rules for a database
Click here to see an animation about validation and verification
Validation and verification are two ways to check that the data entered into a computer is correct. Data entered incorrectly is of little use.
Validation
Validation is an automatic computer check to ensure that the data entered is sensible and reasonable. It does not check the accuracy of data.
For example, a secondary school student is likely to be aged between 11 and 16. The computer can be programmed only to accept numbers between 11 and 16. This is arange check.
However, this does not guarantee that the number typed in is correct. For example, a student's age might be 14, but if 11 is entered it will be valid but incorrect.
Types of validation
There are a number of validation types that can be used to check the data that is being entered.
| Validation type | How it works | Example usage |
|---|---|---|
| Check digit | the last one or two digits in a code are used to check the other digits are correct | bar code readers in supermarkets use check digits |
| Format check | checks the data is in the right format | a National Insurance number is in the form LL 99 99 99 L where L is any letter and 9 is any number |
| Length check | checks the data isn't too short or too long | a password which needs to be six letters long |
| Lookup table | looks up acceptable values in a table | there are only seven possible days of the week |
| Presence check | checks that data has been entered into a field | in most databases a key fieldcannot be left blank |
| Range check | checks that a value falls within the specified range | number of hours worked must be less than 50 and more than 0 |
| Spell check | looks up words in a dictionary | when word processing |
Verification
Verification is performed to ensure that the data entered exactly matches the original source.
There are two main methods of verification:
- Double entry - entering the data twice and comparing the two copies. This effectively doubles the workload, and as most people are paid by the hour, it costs more too.
- Proofreading data - this method involves someone checking the data entered against the original document. This is also time consuming and costly.
Now try a Test Bite.
Try to explain validation and verification to an adult
__________________________________________________________________
__________________________________________
Lesson3
The data types that be entered into
the field of a database.
the field of a database.
Entering data into a database
Open up the database you created
in the last lesson.
in the last lesson.
what will be the datatype for the fields
- First name
- Eye colour
- DOB
- Number of pets
Enter the data from the data collection sheet
Share today's work with your test buddy say;
What went well
and get them to say how it could be;
Even better if
What went well
and get them to say how it could be;
Even better if
___________________________________________
Lesson 2
To be able to create a database in Microsoft Access.
To be able to create a table within the database.
Learn more about databases here
Create a folder in your ICT folder called
DataBase. Setting up the database
DataBase. Setting up the database
Create a database called students and save it in the database folder you have created in your area.
Save the table as StudentDetails
Share today's work with your test buddy say;
What went well
and get them to say how it could be;
Even better if
What went well
and get them to say how it could be;
Even better if
___________________________________________________________________
Lesson 1
- A database is structured information
- A database is made up of records
- Records are made up of fields
- To get information out of a database we use queries
What is a database
Use the autotrader site to
Find me a blue Honda jazz that is
- Less than 12 years old
- Within 50 mile of SO45 4RQ
- Costing between £3500 and £4500
-
- Having done up to 45,000 mile
We are going to use a database to help
Sherlock Holmes to solve crimes
Click to go to the Whodunnit Website
Remember
> is greater / bigger than
>= is greater / bigger than or equals to
< is less than
<= is less than or equals to
Everyone should be able to do the practice case
Most people should be able to complete 5 cases
A few people may be able to do all 10 cases
Can you explain to a Granny or Grandpa what is a
A record , field and queries are
Find me a blue Honda jazz that is
- Less than 12 years old
- Within 50 mile of SO45 4RQ
- Costing between £3500 and £4500
- Having done up to 45,000 mile
Sherlock Holmes to solve crimes
