7X Period 5 Wednesday 13th June 2012

STARTER

What do you know about databases?  Click HERE to find out.

TASK 1 Printing your database table.

Open your CRIME INVESTIGATION NAME database.  Open your tblsuspects table.  Ensure that you have added your data / information as RECORD 1.  Print your table to the KC2mono printer.

TASK 2 Saving your database to the General area.

Ensure that your CRIME INVESTIGATION NAME database is closed.  Navigate to your network area and find your CRIME INVESTIGATION NAME database.  Right click and choose COPY.  Navigate to the folder 7X CRIME INVESTIGATION DATABASE.  Right click and choose PASTE.  Here is the path to teh 7X CRIME INVESTIGATION DATABASE folder - S:\General\ICT\year 7\7X 2011 – 2012. 

Task 3 – Creating queries in MS Access

1. Navigate to Shared:\Pupils\Senior Pupils\ICT\Y07\Unit 7.5 Murder Most Horrid\Lesson_1 and copy the file called SHR Pupils 2011-2012
2. When the database has opened, click on the ENABLE CONTENT buttton at the top in the middle and then save the database in your Unit 7.5 – Murder Most Horrid folder.
3. Then click on the table called All Girls 2011-2012 on the left hand side and see if you can find your name…(you might have to explore and experiment)

Watch this VIDEO to see how to build a simple query.

After the demonstration, try to produce the following queries. Save each query with a sensible name;

1. Find all the girls in your form and sort the list by Surname (a) also show firstname
2. Find all the girls in your house and sort the list by Year (a) also show firstname and surname
3. Find all the girls in the school called Eleanor and sort the list by Form Group (a) and then Age (a) show all fields
4. Find all the girls in your science group and sort the list by Form Group (a) and then House (a) also show surname and firstname
5. Find all the girls in the school who were born before 01/01/1994 also show surname and firstname
6. Find all the girls who have a surname which begins with D also show firstname and form (follow this link for help on this query – scroll down and find the Using Wildcards link)
7. Further queries – can you find all the girls in your form who have a “T” in their surname, can you find all the girls in your house whose firstname ends in an “R”?
8. Make up some queries of your own – what do you want to find out?

Task 3 – Reports

Queries help you find information but reports allow you to have more control over the presentation.  You can add logos, change the font style and size as well as adding colour.

Watch this VIDEO to see how to create a report.

After you have been shown how create a report, produce the following reports;

1. A list of girls in your form with the heading “Form List” and the Form at the top of the page.  The list should also show Surname, Firstname and DOB
2. A list of girls in your science group which has a heading “Science Group List” and the Science group at the top of the page.  The list should only show Surname, Forename, Form Group and House.  It should be ordered by  Form Group and then House.

EXTENSION

If you are completely finished try any of the ACCESS quizzez HERE.

8W Period 4 Wednesday 13th June 2012

STARTER

What do you know about PowerPoint? Click HERE to find out.

TASK 1 Digital Poster check list

Open your reality TV show digital poster.  Use the list below to check the content of your poster.

The digital poster must:

• consist of at least three screens that scroll automatically. 
• loop automatically, with sensible timings.
• attract the attention of busy people passing by.
• introduce the Reality TV Show and its slogan / strapline (if you have one)
• give details of the Reality TV Show.
• display the show name, logo and contact details on every screen.

TASK 2 Setting your Digital Poster up as a Kiosk Presentation.

From the Slide Show menu choose Set Up Slide Show.  Tick the “Loop continuously until Esc” option and then click OK.

TASK 3 Rehearse your timings.

Click HERE to watch a video to show you how to add timings to your slide show.

Make sure that you rehearse your timings!!!  From the Slide Show menu, choose Rehearse Timings.  Read quietly and slowly through the text on each slide, manually using the mouse to move forward through your presentation.  Click on the X to stop recording.  A dialogu box will appear .  If you are happy with your recording click on YES, otherwise click on NO and rerecord your show.

TASK 4 Adding Slide transition to your slides.

Click HERE to watch a video to show you how to add slide transition to your digital poster.

TASK 5 Adding Text and Image animation to you slides.

Click HERE to watch a video to show you how to add text and image animation to your slides.

EXTENSION WORK – Add music

Watch this VIDEO to see how to add sound to your presentation.

Please enhance your poster by adding some appropriate background music

(look in Shared:\Media Library\Audio\General Access (Read Only)

and appropriate sound effects

(look in Shared:\Media Library\Audio\General Access (Read Only)\Audacity\Sound Effects) – USE SPARINGLY!!!

TASK 6 – 2 STARS and 1 Wish

Watch your buddy’s digital poster.  Can you suggest TWO things that work well in their digital poster?  Now be a critical friend – Can you suggest ONE improvement that they could make to their work?

TASK 7 Print Handouts of your Digital Poster.

Ensure that your NAME is in the FOOTER of Notes and Handouts.  From the Insert menu choose Header and Footer.  Click on Notes and Handouts.  Tick the Footer and type in your NAME.

From the File menu choose Print.  Make sure that you print Handouts to the KC2mono printer.  CHANGE from Full Page Slides to Handouts – 3 Slides or 4 Slides.

TASK 8 Saving your Digital Poster for marking.

From the File menu choose Save As… and navigate to the General area.  Here is the path – S:\General\ICT\Year 8\8X 2011 2012\11 8X Reality TV Show digital poster.   Save your work into the Reality TV show  Digital Poster YOUR NAME folder.

If you are completely finished….

….then try any of the following PowerPoint games.

8Y – Period 4: Friday 24th May

Yacapaca test

Please log on to yacapaca and take the SHR Unit 8.4 test

Marked work

Your marked spreadsheets from last lesson can be found in Shared:\General\ICT\Year 8\8Y 2011 2112

The test was out of 40 and you can find your mark in cell I1

If you finish…

Please have a go at any of the activities on this page;

http://www.reviseict.co.uk/games/index.shtml?searchQuery=excel

Year 10 ICT Functional Skills Exam – May 2012

Exam Instructions

You have 2 hours to complete this exam

You are advised to spend 15 minutes on Section A and 1 hour and 45 minutes on Section B

You can use the internet for the first 15 minutes only

All the files you need for the exam can be found in: Shared:\Pupils\Senior Pupils\ICT\Functional Skills Level 2\June 2012 Exam Files

Save your work in your documents

Please make sure that you include your name and your science set (S1, S2, S3 or D1) on every print out.

You do not need to add your centre number or candidate number

Hand in your printouts at the end in question order.  You do not need a cover sheet, to hole punch your printouts or attach them together with a treasury tag.

7Y – Period 1: Wednesday 23rd May

Database Assessment

Please see the sheet you have been given for the assessment instructions.

If you finish before the end of the lesson then try any of the activities on this page: http://www.reviseict.co.uk/games/index.shtml?searchQuery=access

9W Period 3 Tuesday 12th June 2012

STARTER

What do you know about MS Word.  Click HERE to find out.

TASK 1 – Create an online survey using survey monkey .com

Open your My Hypotheses document.

Watch the following screencast to create your survey. Or follow the instructions below:

1. Go to www.surveymonkey.com
2. You will need to sign up so click on Signup Now
3. Use your school email address e.g. l.munro@shr.gdst.net
4. Choose a password, use the same one as your school password to make life easier.
5. Click on Submit.
6. Click on the New Survey button at the top, select From Scratch and click Next
7. Edit the title of your survey, call it “9W NAME School Life Survey” for example.  Click on Update.
8. Edit the page title, call it “Page 1″.  Click on Update.
9. Now click Add Question at the bottom.
10. To see examples of the various question types available, click on the type of question link.  E.g.  One answer (drop down), multiple answer (checkboxes), free (open ended, one line.)
11. Add the questions that you need to ask (maximum of 10 about your topic)

TASK 2 – Sharing your survey. 

1. Click on MY SURVEYS.
2. Open your survey.  You do this by clicking on the box on the left hand side.
3. Click on the Collect icon.
4. Click on Create Link For An Email Message.  This displays a web address – highlight and copy this address, then click on DONE.
5. Open your email.
6. Create a new email.
7.  In the Subject Box type in 9WNAME School Life Survey. 
8. Write a line of text asking the person to complete your survey.  “Please click on the link below and complete my School Life survey.
9. Click on the To button.  Add the address of each person who you want to complete your survey – the other people in your class.  Remember to send your survey to me as well – l.munro@shr.gdst.net
10. Paste in the link to your survey (remember to press Return at the end of the link to make it active!) and press Send.

TASK 3 – Respond to your classmates’ surveys. 

1. Open your email.
2. Check you Inbox for new mail with 9W NAME School Life Survey in the Subject line.
3. Click on the link embedded in the mail document and respond to their surveys.

EXTENSION TASK

Go to My Surveys and click on the Analyse button next to the name of the survey you want to analyse.

Take a look at the responses you are getting so far.

7W Period 3 Friday 12th June 2012

7.5 Lesson 3 Murder Most Horrid – Creating a Database. 

 

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Make a database and check data for errors. 

 

Detective Turner and his team of detectives have been interviewing people.  They have now interviewed everyone using your questionnaire.  This information is taking a long time to sort through, and the team are having difficulties finding the information they need. 

Starter:

Read all about data types by clicking HERE.  Then a short quiz.

Task 1 Design a Table and create Field Name. 

Open the word document Field Names and Data Types (Reso3c).  Save this into your Unit 7.5 Murder Most Horrid folder. Add your name to the dialogue box.  Call it Field Names and Data Types. 

First you need to design a table for the database into which you will enter all of the information. 

Remember that each question needs to be converted into a Field Name so that we can store this information in the database.  Using your questionnaire and the worksheet Field Names and Data Types, create a list of Field Names and Data Types for the database.  For example: for the question What is your surname? the best field name is simply Surname.  The data types you can use are listed in the box to the right of the table.  Any field that contains letters should be made into a text field.

 

Task 2 Setting up a database

Now you need to set up a database.  This means you need to open a blank database, so that you can create your own table. 

Open MS Access and set up a blank database.  Save this into your Unit 7.5 Murder Most Horrid folder.  Name your database Crime Investigation Database. 

Watch this VIDEO to help you with this task. 

 

Task 3 Create your Table. 

Once the database has been set up and saved, you can begin to create the table. 

Watch this VIDEO to help you with this task. 

Choose Create table in design view. 

Using the list of field names and data types you can created in Task 1, enter these into your table.  You can choose the Data Type you want by selecting from the drop-down menu. 

Importantly, the first Field Name you should enter is ID.  Give it the data type AutoNumber. 

Watch this VIDEO to help you with this task. 

Watch this VIDEO to help you with this task. 

 

Task 4 Create the Primary Key field. 

The ID field needs to be made into the Primary Key.  This will make sure that each person has a unique number (like a sort of membership number). 

To create the Primary Key: 

• Place your cursor in the field ID by clicking in the row. 
• Then click on the Primary Key icon on the toolbar. 

This field is now the Primary Key. 

Watch this VIDEO to help you with this task

 

Task 5 Save your database table. 

When you have entered all your Field Names and Data Types, you need to save the table. 

Choose File / Save. 

You will be asked to type in the name of your table. 

Type the name tblsuspects and click OK. 

 

Task 6 Enter your Information. 

Now you can enter the information from your buddies.   

To enter data you need to change the view from Design View to Datasheet View. 

To do this, click on the icon on the top toolbar.  When you have entered all the information, save the table again. 

Watch this VIDEO to help you with this task. 

 

Task 7 Check for Errors. 

It is easy to make a mistake when entering data.  One way to make sure that the information you enter is correct is to get someone else to look at it. 

Print your table by choosing File / Print.  Then swap printouts with your buddy, and: 

1. Circle any errors that have been made. 
2. Once you have checked the printout, give it back to the person to whom it belongs. 
3. Using the corrected printout of your table, correct your mistakes in the database. 

If you have finished try any of these ACCESS quizzes by clicking HERE.  

 

Extension Work – Database Bingo. 

I am going to read out one statement at a time and you are going to cross out the correct answer on the bingo cards I have given you. 

 

10D1 Period 4 Monday 11th June 2012

Working with numbers and charts – Functional Skills Module 5 – Lesson 11

In this lesson students are learning how to:

• display numerical data in graphical form

STARTER 

Look at the image L11-1-Bar-Chart-no-info.

What is it?  What does it tell you?  What is missing?

Look at the bar chart below.  What makes this chart more meaningful?  What is still missing?  For example: Sales – of what?

TASK 1 – Which type of chart should you use? 

Bar charts 

Column and bar charts are useful if you want to compare different values, such as sales each month or different answers to a survey question.  The graph above is a bar chart showing income from sales for the four quarters of the year.  The sales value for a quarter can be found by ‘reading’ the height of the bar off the y-axis (Sales).  The line shows that sales in the autumn quarter were about £57,000.

Pie charts

Pie charts are good for showing proportions or percentages, but they do not work well if there are too many items.  Here is the same information shown now in a pie chart.  A pie chart is used when you want to show each data value as a percentage of the total.  This chart shows that the autumn quarter sales were £56,800 and that the quarter’s sales are 28% of the total.

Line graphs 

Line graphs are used to show values that are always changing.  For example, you could use a line graph to show the temperature over a year.  There is a graph of petrol costs for car journeys of different distances below. This is known as a ‘straight line graph’.  The two red lines that have been added show that a journey of 200 miles costs about £31.  Approximately how much would a journey of 120 miles cost?

What other charts and graphs do you know or have you seen?

TASK 2 – Creating a Bar Chart 

When creating a chart, you need to ask yourself the following questions:

• Is the type of chart suitable?
• Is the scale sensible?
• Is it easy to read the values from the chart?
• Are the headings and labels clear?  Do they give enough information to the reader?
• Are the colours clear?

Meaningful title 

The title is the most important item.  It should clearly say what the chart shows or what questions the chart answers.

Sensible axis labels 

Make sure you label what each axis shows.  Labels help the audience to understand the chart.

Gridlines and values 

You should be able to read off the exact values of each part of the chart.  You can insert gridlines and values to make this easier.

Legend and data labels 

Your chart will include the row and column headings from your spreadsheet.  These may be too long to use as horizontal data labels.  Sometimes you can change the angle.  Alternatively, you can use a legend.

Complete the Skills Builder (5.7) exercise.

Here are the results of a survey of 335 people who were asked about their favourite type of film.

Favourite type of film	Number of responses
Comedy	92
Action	63
Romance	48
Drama	50
Horror	37
Foreign	27
Sci-fi	29

• Plot this information as a vertical bar chart and set the titles as follows:
• • Chart title – ‘Favourite film categories’
  • X-axis title – ‘Film category’
  • Y-axis title – ‘Percentage’
• Make sure the x-axis labels are all shown.  You may need to set them at an angle.
• Do NOT show a chart legend.
• Plot the same data as a pie chart.
• Make sure a chart legend is shown that clearly identifies each ‘slice’ of the pie.
• Show the percentage value with two decimal places against each slice.
• Explain why this data is NOT suitable for plotting as a line graph. TASK 3 – Creating a Line Graph  Open SB5.8.1 – Weather Records.  What features add meaning to this spreadsheet?   e.g. two titles, tab with meaningful name rather than Sheet1 or 2.  Can you describe the layout of the spreadsheet?  Is the block of numerical data where you expected it?  Key points  Structured data – e.g. records, fieldnames, appropriate formatting (text wrap in row 6), and Finding and selecting informationYou need to acknowledge your sources and so it is useful to paste addresses of sources into a document.
  1. If you knew that you had to use AutoFilter, would you use a layout such as this for digital asset SB5.8.1?  If not – why not?
  2. Do you think you can use AutoFilter with digital asset SB5.8.1?

  Create a line graph – use HIGHEST and LOWEST temperatures, ready for printing out.  REMEMBER layout matters – a good layout for a spreadsheet is as important as meaningful labelling to a chart.  If you know that you need to print your spreadsheet, make sure your layout fits well onto standard sheets of paper (normally A4, portrait or landscape).  Identify your work by entering your name in the footer (especially useful if others on a network are working on the same task as you).

  EXTENSION – Create a line graph – use AVERAGE DAILY MAXIMUM and LOWEST temperatures. 

  

  NOTE: Temperatures below 0 will appear below the x-axis.

  TEST YOURSELF 

  You should be able to:

  • select and create appropriate charts and graphs
  • label graphs / charts to aid understanding
  • produce print-outs to meet requirements

  Skills Checker  Make sure you know how to:

  • enter formulas
  • use the SUM and AVERAGE functions
  • use an IF function
  • use ‘search’ and ‘replace’
  • use absolute cell references
  • use conditional formatting
  • display and print a spreadsheet showing the data
  • display and print a spreadsheet showing the formulas
  • set the print area
  • insert your name and other information in a footer
  • adjust column width and row heights
  • use colours, borders and shading
  • insert comments
  • select data in adjacent columns
  • select data in non-adjacent columns
  • choose a suitable chart or graph to display the data
  • add a suitable title and axis labels
  • add and remove a legend
  • save a chart

Click HERE to watch teaching videos about CHARTS, the SUM, AVERAGE and IF Functions, Absolute Cell Referencing and Conditional Formatting.

EXTENSION WORK 

• Produce three more fully annotated charts based on SB5.8.1, two for printing out on A4 portrait, one on A4 landscape.  Place each chart as a new sheet (not as an object with the data)  Use Print Preview to check that the charts are fully labelled and that additional information is formatted and placed appropriately on the page, e.g. header/footer with own name, name given to the spreadsheet and Tab with chart, date, etc.

• Write a statement saying which type of chart is most appropriate and why.

10S2 Period 3 Monday 11th June 2012

Working with numbers and charts – Functional Skills Module 5 – Lesson 11

In this lesson students are learning how to:

• display numerical data in graphical form

STARTER 

Look at the image L11-1-Bar-Chart-no-info.

What is it?  What does it tell you?  What is missing?

Look at the bar chart below.  What makes this chart more meaningful?  What is still missing?  For example: Sales – of what?

TASK 1 – Which type of chart should you use? 

Bar charts 

Column and bar charts are useful if you want to compare different values, such as sales each month or different answers to a survey question.  The graph above is a bar chart showing income from sales for the four quarters of the year.  The sales value for a quarter can be found by ‘reading’ the height of the bar off the y-axis (Sales).  The line shows that sales in the autumn quarter were about £57,000.

Pie charts

Pie charts are good for showing proportions or percentages, but they do not work well if there are too many items.  Here is the same information shown now in a pie chart.  A pie chart is used when you want to show each data value as a percentage of the total.  This chart shows that the autumn quarter sales were £56,800 and that the quarter’s sales are 28% of the total.

Line graphs 

Line graphs are used to show values that are always changing.  For example, you could use a line graph to show the temperature over a year.  There is a graph of petrol costs for car journeys of different distances below. This is known as a ‘straight line graph’.  The two red lines that have been added show that a journey of 200 miles costs about £31.  Approximately how much would a journey of 120 miles cost?

What other charts and graphs do you know or have you seen?

TASK 2 – Creating a Bar Chart 

When creating a chart, you need to ask yourself the following questions:

• Is the type of chart suitable?
• Is the scale sensible?
• Is it easy to read the values from the chart?
• Are the headings and labels clear?  Do they give enough information to the reader?
• Are the colours clear?

Meaningful title 

The title is the most important item.  It should clearly say what the chart shows or what questions the chart answers.

Sensible axis labels 

Make sure you label what each axis shows.  Labels help the audience to understand the chart.

Gridlines and values 

You should be able to read off the exact values of each part of the chart.  You can insert gridlines and values to make this easier.

Legend and data labels 

Your chart will include the row and column headings from your spreadsheet.  These may be too long to use as horizontal data labels.  Sometimes you can change the angle.  Alternatively, you can use a legend.

Complete the Skills Builder (5.7) exercise.

Here are the results of a survey of 335 people who were asked about their favourite type of film.

Favourite type of film	Number of responses
Comedy	92
Action	63
Romance	48
Drama	50
Horror	37
Foreign	27
Sci-fi	29

• Plot this information as a vertical bar chart and set the titles as follows:
• • Chart title – ‘Favourite film categories’
  • X-axis title – ‘Film category’
  • Y-axis title – ‘Percentage’
• Make sure the x-axis labels are all shown.  You may need to set them at an angle.
• Do NOT show a chart legend.
• Plot the same data as a pie chart.
• Make sure a chart legend is shown that clearly identifies each ‘slice’ of the pie.
• Show the percentage value with two decimal places against each slice.
• Explain why this data is NOT suitable for plotting as a line graph. TASK 3 – Creating a Line Graph  Open SB5.8.1 – Weather Records.  What features add meaning to this spreadsheet?   e.g. two titles, tab with meaningful name rather than Sheet1 or 2.  Can you describe the layout of the spreadsheet?  Is the block of numerical data where you expected it?  Key points  Structured data – e.g. records, fieldnames, appropriate formatting (text wrap in row 6), and Finding and selecting informationYou need to acknowledge your sources and so it is useful to paste addresses of sources into a document.
  1. If you knew that you had to use AutoFilter, would you use a layout such as this for digital asset SB5.8.1?  If not – why not?
  2. Do you think you can use AutoFilter with digital asset SB5.8.1?

  Create a line graph – use HIGHEST and LOWEST temperatures, ready for printing out.  REMEMBER layout matters – a good layout for a spreadsheet is as important as meaningful labelling to a chart.  If you know that you need to print your spreadsheet, make sure your layout fits well onto standard sheets of paper (normally A4, portrait or landscape).  Identify your work by entering your name in the footer (especially useful if others on a network are working on the same task as you).

  EXTENSION – Create a line graph – use AVERAGE DAILY MAXIMUM and LOWEST temperatures. 

  

  NOTE: Temperatures below 0 will appear below the x-axis.

  TEST YOURSELF 

  You should be able to:

  • select and create appropriate charts and graphs
  • label graphs / charts to aid understanding
  • produce print-outs to meet requirements

  Skills Checker  Make sure you know how to:

  • enter formulas
  • use the SUM and AVERAGE functions
  • use an IF function
  • use ‘search’ and ‘replace’
  • use absolute cell references
  • use conditional formatting
  • display and print a spreadsheet showing the data
  • display and print a spreadsheet showing the formulas
  • set the print area
  • insert your name and other information in a footer
  • adjust column width and row heights
  • use colours, borders and shading
  • insert comments
  • select data in adjacent columns
  • select data in non-adjacent columns
  • choose a suitable chart or graph to display the data
  • add a suitable title and axis labels
  • add and remove a legend
  • save a chart

Click HERE to watch teaching videos about CHARTS, the SUM, AVERAGE and IF Functions, Absolute Cell Referencing and Conditional Formatting.

EXTENSION WORK 

• Produce three more fully annotated charts based on SB5.8.1, two for printing out on A4 portrait, one on A4 landscape.  Place each chart as a new sheet (not as an object with the data)  Use Print Preview to check that the charts are fully labelled and that additional information is formatted and placed appropriately on the page, e.g. header/footer with own name, name given to the spreadsheet and Tab with chart, date, etc.

• Write a statement saying which type of chart is most appropriate and why.

9Y – Period 3: Tuesday 22nd May

Starter: Please click here to take a survey – click on “Respond to this Survey”

Surveymonkey surveys

Check your emails for surveymonkey surveys you have been sent by others and you still need to complete.

Task 1 – Choosing 5 suitable hypotheses to test

From the list of hypotheses which you and other’s created, you will need to choose 5 which you will test using the survey data.  You can find the hypotheses here.  You need to check that the hypotheses you choose have been covered in the survey – have a look at the questions again to make sure the answers will enabe you to test your hypotheses.  A copy of the questions can be found in – pupils/Senior Pupils/ICT/Y09/Unit 9.2 World Citizens/survey questions.pdf

Make your hypotheses as specific as possible – use percentages and age groups where appropriate.  For example – “I predict that at least 95% of all girls aged between 14-16 have a facebook account”

Task 2

You are going to use PowerPoint to present your findings.  Although the data isn’t ready for you to analyse, you can still set up your presentation which should have the following 8 slides.

• title
• introduction (you should list your hypotheses on this slide)
• a slide for each hypothesis which will contain the hypothesis, some results data (maybe a chart or a table) and a conclusion for the hypothesis (5 slides in total)
• summary (you might list each of your conclusions on this slide)