Year 7

1
Year 7

• ICT Course

2
Introduction

• During year 7 you will develop your existing ICT
  skills through this ICT course as part of your
  Technology lessons and in your other subjects.
  Some of the tasks will also involve you in
  producing work that is worth keeping in your
  Citizenship file in your tutor group room.
•  
• Think about what you have done involving ICT in
  another subject area. This can be something you
  have done at Claverham or at your primary school.
• Subject
•  
• What did you use it to do?
•  
• Was it better using ICT than doing the task by
  hand? Why?
•  
• What was the Type of software?
•  
• What was the Name of the software?
• (One of your homework tasks will be to complete
  this)
•  

3
Types of Software
4
Names of Software
Can you think of an example for each of the below
types of software. For example Web Brower
Internet Explorer (there others though!)
Word Processor
MS Word
Desk Top Publishing
MS Publisher
If you are not sure click the text box for an
example!
Spreadsheet
MS Excel
Database
MS Access
Presentation Package
MS PowerPoint
Web Browser
MS Internet Explorer
5
Claverham Computer Network

• All of the computer work you do at Claverham will
  involve you using our computer network. You
  will find out more about how the network works as
  the course progresses and how to use it by
  discussing these questions with your teacher and
  giving written answers to these questions as part
  of your homeworks
• SECTION A PASSWORDS
• Why dont you see your password on the screen
  when you type it in?
• Why should you change your password regularly?
• Jason is trying to decide on a new password. How
  good are each of the following passwords?
• pq18b34WK walesiswonderful
  01425874356 arsenal
• password jason
• Does it matter if two users choose the same
  password?

6
SECTION B NETWORKS

• Where is all the work you save stored?
• What are the advantages of using a network of
  computers?
• What are the disadvantages of using a network of
  computers?
• How many computers are attached to the College
  network?
• Why are you not usually allowed to use floppy
  disks with computers on the network?
• Why are you not allowed to install other software
  on school computer systems?

7
SECTION C USE OF NETWORK

• What is the purpose of the printer credits
  system?
• How do you get more credits?
• Why is it important that you only click print
  once when printing your work.
• What is an acceptable use policy?
• Why do businesses, schools and colleges have
  acceptable use policies?
• What is a URL? What id the URL of Claverhams
  web-site?
• What is an intranet? What will you find on
  Claverhams intranet?

8
Task 1 Setting up your ICT Profile - Network
Skills

• You will keep a record of your progress and
  achievement in ICT in your own personal ICT work
  folder. You should put all the best copies of
  your work into this folder. We will create
  folders for use in years 7, 8 and 9. You can add
  extra folders as the year progresses for
  different tasks and work from other subjects.
• Create a new folder in your My Documents folder
  and call it ICT Inside this folder, create 3 more
  folders Year 7, Year 8 and Year 9
• Find the Shared Documents gt ICT gt ICT Profiles
  folder.
• Copy the y7ictprofile document that is in this
  folder into your
• Year 7 folder
• Load your copy of the y7ictprofile document and
  enter your personal details.
• Which skills can you already tick? Save your
  updated YR7ICTprofile.
•  

9
End of Task 1 Summary

• Complete the following questions
• How did you create a new folder?
• How did you rename the folder?
• What folders have you created?
• What file have you copied?
• Where did you copy the files from?
• What are the advantages of storing your best work
  and your profile in this network folder, rather
  than in a cardboard folder?
• Other Notes

10
YEAR 7 ICT SKILLS

• By the end of this unit you should be able to..
• NW1 Change password ?
• NW2 Create folders ?
• NW3 Use shared folders ?
• NW4 Copy files ?
• NW5 Use appropriate filenames ?

11
Task 2 Information Leaflet - Using Desktop
Publishing Software

• You are going to use a desktop publishing package
  (DTP) to produce two leaflets containing a
  mixture of text and graphics.
• The leaflets that you produce needs to be
  presented as attractively as possible and show
  the relevant information needed for the audience
  that it is aimed at.
• The purpose of the leaflet is to Inform primary
  school aged pupils about Internet Safety

12
Quick Questions!

• Is it ok to give your home address to your online
  friends?
• Is it ok to give your username to your online
  friends?
• Should you tell you online friends your real
  name?
• Should you tell your online friends which school
  you go to or the town where you live?

13
Leaflet Contents

• You must include some if not all of the below
  information
• Talking to people online
• What information can you give out online
• Downloading from the internet
• Bullying online
• Dangers of the internet
• But think carefully, your audience are only 10
  or 11 years old you need to present your
  information with care be informative but not
  scary.

14
Identify Range of Presentation Tools

• Lets look at an example already
• Available for our target-age

Compare the pupil leaflet with this leaflet
aimed at parents

• Identify different ways that information has been
  presented (eg images, text)

15
Key Words
Bold text
logo
Font colour
Clip art
Font size
Screen shots
Large font
images
Heading/title
Small font
Word Art
cartoon
Website addresses
photo
16
Using MS Publisher
Example of Poster

• We can create a similar leaflet using publisher
• Insert text boxes (where do we get the
  information from?
• Make font bigger/smaller
• Insert clip art
• Insert Word Art
• Border

Example of Text
17
YEAR 7 ICT SKILLS

• By the end of this Desktop Publishing unit you
• should be able to..
• DTP1 Use fonts ?
• DTP2 Use appropriate fonts ?
• DTP3 Use clip art ?
• DTP4 Use appropriate clip art ?
• DTP5 Check accuracy ?
• DTP6 Use images from scanner/digital camera ?
• DTP7 Edit images from scanner/digital camera ?
• DTP8 Use colour printing appropriately ?

18
Task 3 Promoting a Charity - Presentation
Software

• Your task is to produce a slideshow presentation
  that could be used by a charity to promote itself
  in schools, raising funds for a Underdeveloped
  country. You need to select one of the countries
  that you stored in your database in task 3.
• You will need to find out as much as you can
  about the country and a charity that does work in
  3rd World countries before starting to plan your
  slideshow.
• Possible sources of information about the
  charity/country
• _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
•  
• How might your presentation differ for primary
  and secondary school pupils?
•  
• _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
•  
• _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
  _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
•  

19
How to search the Internet

• Finding stuff on the Internet
• The World Wide Web has become so huge that is
  has been necessary to provide a Search Engine
  to make it easier to find what you want.
• Search engines are indexes which work by
  keywords.
• Usually you type in a keyword and the search
  engine lists a load of websites containing that
  keyword
• 2. You can do a complex search using more than
  one keyword and linking them together with AND
  and OR.
• How many search engines can you name?

20
Reliability and Bias on the Web

• Anyone can put information on the Internet, which
  means a lot of stuff thats there is untrue. And
  if its exactly untrue theres change it might be
  biased!
• What is reliability?
• What is fact?
• What is opinion?
• What is bias?

I think every pupil should have three hours of
homework every night
Chelsea are the best team in the world!
Christmas day is on the 25th December
Claverham is the best!
Spurs are the best team in the world!
21
(No Transcript)
22
How much do you know about Microsoft PowerPoint?
1) What does a slide presentation do?
a) Understand how something works
b) Transfer information from one PC to another
c) Understand how something works
d) Present information to a group of people
e) All of the above
23
DOH!

• Try Again

Back
24
Excellent!
Next
25
How much do you know about Microsoft PowerPoint?
2) A presentation tool lets you..
a) Create a database of information
b) Create a series of slides which include text,
graphics and information
c) Create pages on the World Wide Web
d) Create a newspaper
26
DOH!

• Try Again

Back
27
Excellent!
Next
28
Presentation Idea

• We are going to create a presentation for a
  chosen charity
• You job is to inform the audience (Secondary
  school aged pupils) all about the charity
• What information must be included
• Lets see what has been included in a presentation
  for a children's charity - jeansforjeans
• Watching it for the second time use a piece of
  paper and a pen, write down any headings which
  were used

29
Create a Plan

• Using your notes from the Jeans for Jeans
  PowerPoint presentation, create your own plan
  saying what you want to include in each page
• Write your plan on page 6 (but before you start
  you may want to look at the next slide!)

30
What important questions should you ask yourself
when preparing a presentation?

• Who is your target audience? (age, gender)
• What is the purpose of the presentation?
• Have I made sure the information is correct?
  (Have I used a reliable source to collect the
  information?)
• Have I used custom animation appropriately?
• Click here to see a presentation which definitely
  needs some improving, what can you suggest?

31
Planning your presentation

• 1. Use one of the suggested web sites or one of
  your choosing to collect information about the
  charity. (stuck for websites, click here for
  links)
• Web site used http//
• 2. Use MS Word to put together one or two pages
  containing all of the information (text and
  graphics) that needs to be included in your
  slideshow. The layout of these pages does not
  matter, they are simply storing the information
  you will use in your slideshow.
•  
• Plan for presentation
• Slide 1 Slide 2
•    
•  
• Slide 3 Slide 4
•    
•  
• Slide 5 Slide 6 

32
How to use PowerPoint

• Using the handout help sheet we are going to
  show how to use PowerPoint
• Try to do this really well as it will be a good
  point of reference if you forget how to do
  something

Screen Shot
33
Creating your presentation

• Use MS Powerpoint to create your slideshow
• Copy and paste information from your word
  processing document into your slideshow.
• Produce a printout showing miniature versions of
  the slides you designed.
• Include at least one draft version and on the
  final version annotate all the changes with
  reasons
• 4. Label your printout to show all of the
  presentation package skills you have
• demonstrated
• Extension
• Consider how the user will navigate your
  presentation. Will the use just be
• watching the presentation, or would you like them
  to be a participant, if so add
• action buttons . Ask your teacher more about
  this! click here to see example!

34
Evaluating and Improving

• Evaluate this Charity presentation
• What suggestions could you make for this pupil to
  improve their Charity presentation?
• The criteria is what we discussed on the previous
  slide!

Now evaluation your presentation click here for
the evaluation sheet
35
YEAR 7 ICT SKILLS

• By the end of this Presentation unit you
• should be able to..
• PP1 Create series of slides ?
• PP2 Use appropriate text size ?
• PP3 Use appropriate clip art/graphics ?
• PP4 Check accuracy ?
• PP5 Use transition effects ?
• PP6 Use appropriate transition effects ?
• PP7 Use sound ?
• PP8 Use sound appropriately ?

36
Handling Information.
37
Who wants to be a millionaire?
Put the below girls names in alphabetical order
A) Ashlee
B) Alicia
C) Abigail
D) Anna
A B C D
D C B A
C B D A
B D C A
38
DOH!

• Try Again

Back
39
Excellent!
Next
40
But what happens if you have lots of records to
sort?
41
Manual How long does it take?
42
Sorting How long does it take?
Open Access How to sort
43
Benefits What advantages are there of using
Access to sort data?
44
Data Handling Database software

• You are going to find out more about the United
  Nations and a number of countries around the
  world and then set up a database that can be used
  to store some of the information you find. The
  database will let you compare the lives of people
  living in the different countries.
• Use the Internet to find out the following
  information
• What year was the United Nations formed?
• Why was it formed?
• Which 5 Countries have permanent seats on the
  Security Council?
• What are Under Developed Countries?

45
Collecting Data (www.cyberbus.com)
Why use a code for the continent? What is a
disadvantage of using a code like this?
46
Database Structure

• 3a. Use MS Access to set up a database that has
  the following structure

3b Explain what the information being collected
in the following fields means Population
Density . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . .
Unemployment Rate . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . .
. . Infant Mortality . . . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . Which types of countries do you
think will have the highest rate for infant
mortality? . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . Why? . . . . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . 
47
Your Printouts

• Type in the details about each of the countries
  you wrote in your data collection table
• (i) Produce a printout showing all the countries
  in your database.
• (ii) Sort the records in your database into
  alphabetical order of country and print out all
  the records in your database in the new order.
• (iii) Search your database to find all of the
  countries that have an infant mortality rate
  greater than ?? and print out their details.
• (iv) Sort the records in your database into
  Infant Mortality order and printout only
• the Infant Mortality, Unemployment,
  country and Continent only.
• What does the printout for question 4 tell you?
• Extension Work Produce printouts showing other
  sorts and searches of your database. Use your
  database to produce graphs showing some of this
  information.

48
YEAR 7 ICT SKILLS

• By the end of this Database unit you should be
  able to..
• DB1 Set up database ?
• DB2 Edit database ?
• DB3 Sort database ?
• DB4 Use simple database searches ?
• DB5 Use complex database searches ?

49
Task 5a Spreadsheet software
50
Using Excel to calculate the points for the
Tennis Club

• Using the on the previous slide, construct a
  spreadsheet that will calculate the current
  number of points for each team in the top part of
  the league. Spreadsheet formulae need to be used
  to work out the numbers in the table indicated by
  a question mark (?).
• 2. Print out a copy of your spreadsheet and
  annotate it to show the spreadsheet formulae you
  used.
•  
• In the next round of matches
• - Canterbury beat Medway
• - Folkestone beat Sheppey
• - The match between Dover and Thanet is
  drawn.
•  
• 3. Update your spreadsheet to include these
  results and print out the table sorted into
  points order
• i.e. with the team that has the most points at
  the top of the table.

51
Questions - Spreadsheets

• 1. Underline the spreadsheet formulae shown below
  that you think are incorrect and write the
  correct versions next to them.
• A4B12 SUM(B4B12) A4B12 SUM(B4-B12)
• B12/A4 B1235 SUM(B4D12) SUM(B3B5B7)
• B5-D17 D12/2

52
Task 5b Spreadsheet Model Tuck Shop

• You are going to use a spreadsheet to check how
  well a school tuck shop is doing
• Look at the below screen shot below, what maths
  questions do you think are needed for the columns
  which are highlighted blue?

?
?
?
?
Start your spreadsheet by typing or opening the
spreadsheet (standard or advanced) in the above
information
53
Tuck Shop Tasks

• There are different task for the two different
  spreadsheet model for the Tuck shop

54
Standard Tasks
55
Advanced Tasks
56
YEAR 7 ICT SKILLS

• By the end of this Spreadsheet unit you should
  be able to..
• SS1 Adjust cell format ?
• SS2 Use spreadsheet formulae ?
• SS3 Adjust data in spreadsheet ?
• SS4 Find answer using spreadsheet ?

57
Task 6 - Robots