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.

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)

9Y – Period 5: Friday 18th May

Starter: Pictionary

Task 1 – Designing your questionnaire

Open the word document that you saved last lesson.  You are now going to use the questions your wrote last lesson as the basis for a questionnaire.

The first two questions should be; 1) What is your first name? 2) Which form are you in? and you can only have ten questions altogether.

Now develop your questions by adding relevant response methods.  These could be text boxes, drop down lists, check boxes or radio buttons.

To add checkboxes and radio buttons you can choose Insert > Symbol, Wingdings 2 and find relevant symbols.

Task 2 – Creating an online survey

You are going to create a survey on surveymonkey.  Follow the link and then set up a new free account using your school login as your username and your school email address.  It makes sense to use your school password as well.

Once you have set up your account then see if you can use your questionnaire which you have prepared in word to create an online survey.

Once you have finished your survey, you can complete it yourself.

9X Period 1 Monday 18th June 2012

STARTER

Look at this online survey: http://www.smartgirl.org/speakout/archives/smartgirls-on-videogames/smartgirls-on-videogames.html you can complete it if you want to but see if you can spot all the different ways that you can respond to a question.

TASK 1 Questions and Response Types

Last lesson you decided what questions you would use to obtain information you needed to test your hypotheses.  We are now going to look at responce methods which would be suitable for your questions.  This will cut down on the amount of redundant or erroneous data that you collect.

Open Question and Response Types worksheet (Reso3a) LESSON 3.  Save this into your 9.2 UK Citizen folder.  Add your name to the name dialogue box.  Read through page 1 very carefully.  Use this information to complete page 2 by suggesting appropriate response methods for each question.  The first has been done for you.

Open your MY HYPOTHESES document.  Under each question decide which responce method would be most suitable.  Check that your name is in the header.

Print your MY HYPOTHESES document to the KC2mono printer.

TEST YOURSELF

Open the following questionnaire – http://consults.camden.gov.uk/surveys/respond?survey_id=25643

Work in your groups.  Try to work out what response method is used for each question.  Why is that method used?  Why is the “Data Protection and Information Sharing Notice” placed at the end of this questionnaire?

EXTENSION – The System Lifecycle. 

The System Lifecycle is a useful planning tool.  It will help you to plan your project by getting you to think carefully about how each task is linked to the cycle.

Open the System Lifecycle worksheet (Reso2c) LESSON 2.  Save this into your 9.2 UK Citizen folder.  Add your NAME to the name dialogue box.

Complete the diagram of the System Lifecycle shown with the stages placed in the correct order.

Take a look at System Lifecycle presentation (Reso2b) LESSON 2.  Make sure that you have the stages in the right order.

If you have completed everything else then click on this LINK to try any of these MS Word quizzes.

9W Period 2 Tuesday 22nd May 2012

STARTER

Look at this online survey: http://www.smartgirl.org/speakout/archives/smartgirls-on-videogames/smartgirls-on-videogames.html you can complete it if you want to but see if you can spot all the different ways that you can respond to a question.

TASK 1 Questions and Response Types

Last lesson you decided what questions you would use to obtain information you needed to test your hypotheses.  We are now going to look at responce methods which would be suitable for your questions.  This will cut down on the amount of redundant or erroneous data that you collect.

Open Question and Response Types worksheet (Reso3a) LESSON 3.  Save this into your 9.2 UK Citizen folder.  Add your name to the name dialogue box.  Read through page 1 very carefully.  Use this information to complete page 2 by suggesting appropriate response methods for each question.  The first has been done for you.

Open your MY HYPOTHESES document.  Under each question decide which responce method would be most suitable.  Check that your name is in the header.

Print your MY HYPOTHESES document to the KC2mono printer.

TEST YOURSELF

Open the following questionnaire – http://consults.camden.gov.uk/surveys/respond?survey_id=25643

Work in your groups.  Try to work out what response method is used for each question.  Why is that method used?  Why is the “Data Protection and Information Sharing Notice” placed at the end of this questionnaire?

EXTENSION – The System Lifecycle. 

The System Lifecycle is a useful planning tool.  It will help you to plan your project by getting you to think carefully about how each task is linked to the cycle.

Open the System Lifecycle worksheet (Reso2c) LESSON 2.  Save this into your 9.2 UK Citizen folder.  Add your NAME to the name dialogue box.

Complete the diagram of the System Lifecycle shown with the stages placed in the correct order.

Take a look at System Lifecycle presentation (Reso2b) LESSON 2.  Make sure that you have the stages in the right order.

If you have completed everything else then click on this LINK to try any of these MS Word quizzes.

9X Period 1 Wednesday 16th May 2012

9.2 Lesson 1 & 2 World Citizens: Project Outline

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Understand how data can be collected online. 
• Understand the importance of sample size. 
• Write hypotheses. 

 

STARTER: Things we take for granted. 

Work in your groups. Grab a white board, pen and cloth.  Jot down on your white boards a list of 5 things you take for granted in your lives.  It might be things you own, sports / activities you are involved in, food you like, etc. 

• I wear a clean school uniform each day
• I get to eat fresh fruit and veg (if I want!)
• I use face book, bebo (social networking sites)
• I get pocket money

 

TASK 1 Setting up a New Folder

Within your ICT folder create a new folder called Unit 9.2 UK Citizens. 

 

INTRODUCTION

This unit is about developing your understanding of the world and the people with whom you share it.  Computers and the Internet have made it easier than ever before to find out about different communities – whether they are 60 miles away or 6000 miles away. 

Over the course of this unit you will become a “UK citizen”, communicating and sharing information with another school.  As a U Kcitizen, you will act as an ambassador for your school, so you will need to show respect and consideration to your fellow world citizens at all times. 

 

TASK 2 Write Hypotheses

You are going to be collecting information about young people who may live very differently from you, and have different views, likes and dislikes. 

Some things you take for granted may not be true for the community you are going to research.  E.g. Do all teenagers study the same subjects at school?  Do all teenage girls play hockey?  Look at the list you created in the starter – what things do you and your friends take for granted? 

 

One way of testing whether facts are true or not is to create a hypothesis.  This is a statement that needs to be tested in order to find out whether it is true or false.  I have rewritten the sentences I wrote down in the starter to create the following hypotheses: 

• Most teenagers (80%) in the UK wear a school uniform. 
• Most teenagers (80%) in the UK eat “5-a-day”. 
• Most teenagers (80%) in the UK use social networking sites e.g. face book, bebo. 
• Most teenagers (80%) in the UK get £5 or more pocket money each week. 

Do the same for your sentences. 

TIP: a hypothesis is NOT the same as a fact – it needs to be tested in order to decide whether it is true or not. 

Do you think all the hypotheses I created could be tested? 

 

TASK 3 Testing Hypotheses

You have to be able to test a hypothesis to see if whether it is true or not.  How would you test your hypothesis? 

How many people would you need to ask before you could prove your hypothesis was true?  Would 10 be enough?  When you are collecting information, you need to think about the sample size – that is, the number of people you going to ask. 

 

Extension

If you finish all of the above then have a look at this online survey: http://www.smartgirl.org/speakout/archives/smartgirls-on-videogames/smartgirls-on-videogames.html you can complete it if you want to but see if you can spot all the different ways that you can respond to a question.

Make a list of these different ways at the bottom of your word document under a heading “Response Types”

What are the pros and cons of an online questionnaire? 

 

Pros	Cons
Cheap to produce	Data might be lost
Reach more people	People put in false information

 

Would increasing the sample size improve or make worse the quality of the results.  What sample size would you use for each of my hypotheses? 

If you have completed everything else then click on this LINK to try any of these MS Word quizzes. 

 

 

 

9W Period 2 Wednesday 16th May 2012

9.2 Lesson 1 & 2 World Citizens: Project Outline

LEARNING OBJECTIVES

In today’s lesson you will learn how to;

• Understand how data can be collected online. 
• Understand the importance of sample size. 
• Write hypotheses. 

 

STARTER: Things we take for granted. 

Work in your groups. Grab a white board, pen and cloth.  Jot down on your white boards a list of 5 things you take for granted in your lives.  It might be things you own, sports / activities you are involved in, food you like, etc. 

• I wear a clean school uniform each day
• I get to eat fresh fruit and veg (if I want!)
• I use face book, bebo (social networking sites)
• I get pocket money

 

TASK 1 Setting up a New Folder

Within your ICT folder create a new folder called Unit 9.2 UK Citizens. 

 

INTRODUCTION

This unit is about developing your understanding of the world and the people with whom you share it.  Computers and the Internet have made it easier than ever before to find out about different communities – whether they are 60 miles away or 6000 miles away. 

Over the course of this unit you will become a “UK citizen”, communicating and sharing information with another school.  As a U Kcitizen, you will act as an ambassador for your school, so you will need to show respect and consideration to your fellow world citizens at all times. 

 

TASK 2 Write Hypotheses

You are going to be collecting information about young people who may live very differently from you, and have different views, likes and dislikes. 

Some things you take for granted may not be true for the community you are going to research.  E.g. Do all teenagers study the same subjects at school?  Do all teenage girls play hockey?  Look at the list you created in the starter – what things do you and your friends take for granted? 

 

One way of testing whether facts are true or not is to create a hypothesis.  This is a statement that needs to be tested in order to find out whether it is true or false.  I have rewritten the sentences I wrote down in the starter to create the following hypotheses: 

• Most teenagers (80%) in the UK wear a school uniform. 
• Most teenagers (80%) in the UK eat “5-a-day”. 
• Most teenagers (80%) in the UK use social networking sites e.g. face book, bebo. 
• Most teenagers (80%) in the UK get £5 or more pocket money each week. 

Do the same for your sentences. 

TIP: a hypothesis is NOT the same as a fact – it needs to be tested in order to decide whether it is true or not. 

Do you think all the hypotheses I created could be tested? 

 

TASK 3 Testing Hypotheses

You have to be able to test a hypothesis to see if whether it is true or not.  How would you test your hypothesis? 

How many people would you need to ask before you could prove your hypothesis was true?  Would 10 be enough?  When you are collecting information, you need to think about the sample size – that is, the number of people you going to ask. 

 

 

Extension

 

If you finish all of the above then have a look at this online survey: http://www.smartgirl.org/speakout/archives/smartgirls-on-videogames/smartgirls-on-videogames.html you can complete it if you want to but see if you can spot all the different ways that you can respond to a question.

 

Make a list of these different ways at the bottom of your word document under a heading “Response Types”

 

What are the pros and cons of an online questionnaire? 

 

Pros	Cons
Cheap to produce	Data might be lost
Reach more people	People put in false information

 

Would increasing the sample size improve or make worse the quality of the results.  What sample size would you use for each of my hypotheses? 

If you have completed everything else then click on this LINK to try any of these MS Word quizzes. 

 

 

 

9Y – Period 3: Tuesday 8th May

Starter: Backwards

UK Citizens Project

This project is about devleoping your understanding of what makes teenagers in the UK tick.  Computers and the Internet have made it easier than ever before to find out about different communities – whether they are 60 miles away or 6000 miles away, on the other side of the world.

For your project, you are going to carry out research into the lives of young people in a different part of the country.  You will find out their likes and dislikes, and whether they are similar to or different from your own.

Task 1

Create a new folder called “Unit 9.2 – UK Citizens”.  Then, in groups of two or three, decide how you would collect the information you need to carry out the research outlined above?  Would you use a computer?  What software would you use?  How could you ask people the questions?

Task 2

Open a new word document and save this in your new 9.2 folder – call it “Hypotheses and Questions”.  Put this as a title on the document as well.

Now put a sub-heading – “5 Things I take for granted”.  Once you have written 5 things you take for granted, copy them and paste them as a reply to the discussion item “List five things that you take for granted in your lives.  These could be things you own, sports/activities you take part in, food you like etc. by clicking here.

Task 3 – creating hypotheses

Have a look at everybody else’s answers to the task 2 question.  Can you write 5 hypotheses based on some of the things that people take for granted?

A Hypothesis is a statement which can be tested to determine whether it is true or not.  Add another sub-heading in your word document – “Hypotheses” and add your hypotheses.  Start with “I predict that…” and be specific “I predict 50% of teenagers in the UK have mobile phones”.

And your hypotheses  by copying and pasting as a reply to this discussion

Task 4 – Questions to help you test your hypotheses

You need to collect information to help you test your hypotheses.  For example, if I write the hypothesis “all boys in 7X like football”  I would have to ask three questions of people in order to test the hypothesis;

1. What is your gender? (to find out if they are a boy)
2. Which class are you in? (to find out if they are in 7X)
3. Do you like football?

For the 5 hypotheses you wrote earlier, decide on the questions you need to ask in order collect the information you need to test your hypotheses.  Add these to your word document under the sub-heading “Questions”.

Add you questions as a reply to this discussion by copying and pasting.

Extension

If you finish all of the above then have a look at this online survey: http://www.smartgirl.org/speakout/archives/smartgirls-on-videogames/smartgirls-on-videogames.html you can complete it if you want to but see if you can spot all the different ways that you can respond to a question.

Make a list of these different ways at the bottom of your word document under a heading “Response Types”

9Y – Period 5: Friday 4th May

Starter: Pictionary

Task 1 – Parameter Queries

Find you query design sheets fom last lesson and open your Time Machine Database.  You need to make sure that you have completed the queries on your sheet and also completed them in your database.

Check the queries to make sure they work.

Task 2 – Reports

Queries are great for finding information but there are not many presentation options.

Creating a report based on a query or a table means that;

• logos can be added
• font styles, sizes and colours can be changed
• other formatting such as lines and shading can be added

after the demonstration create reports for the queries you have created today – make sure they look similar in terms of layout, colours and they include the time machine logo.  Experiment by changing background colours etc.

Challenge Corner: Can you make the title of the report change based on what you type in the pop up box?

Extension Work

If you finish all of the above, have a look at this video which is about adding command buttons to your form.  After watching it, try adding some appropriate buttons to the form you created earlier in the lesson.

9X Period 1 Monday 14th May 2012

Mail Merge lesson continued…

Task 1 Formal Letter

Open the formal letter that you created in the last lesson.

Task 2 Create a Mail Merge. 

Click HERE to watch a video about mail merge.

Open the customer details database that you created in Lesson 6.

You are now going to merge the database table Customer Details with the standard letter you have just written.  The  table has fields like ID, customer name, Company name, Address 1 (Street), Address 2 (Town), Postcode, Telephone number, email address, Organisation type, Activity offered.

Open the table, and then choose Tools / Office Links / Merge it with Microsoft Office Word.

Task 3 Merge your letter with a table. 

Make sure the first radio button is selected (Link your data to an existing Microsoft Office document).  Then click OK.

Find the letter you have just saved and choose Open.

The Mail Merge Wizard will open.

Click on Next: Write your letter.

Task 4 Add address fields to your letter. 

Now you can start adding fields to your letter.  The best way to do this is to add each field one at a time.

First, click at the top of the letter where you want to put the address of the company.

Click on More items.  This will open the Insert Merge Field box.

Add all the fields from Contact name to Postcode by selecting them and clicking Insert.  When you have added all the address fields, close the box.

Put each address field on a new line by clicking between them and pressing Enter.  The fields are shown by << >> symbols around them.

Task 5 Personalise your letters. 

You can personalise the letter to address each person by their name.

Click to place the cursor after the word “Dear”.  Then choose More items again, and select Contact name.

You can even refer to the specific event that the company attended.  Type a line which reads “Thank you for attending the XXX event” or similar.

Select XXX so it is highlighted, and choose More items.  Select the field that refers to the event booked and click Close.

Task 6 Preview and merge your letter. 

Click Next: Preview your letters.  The first letter on the list will be shown, with the merged fields showing.  Check that the information shown is correct.  You can go back to the previous step to change anything if you need to.

Then click Next: Complete the merge.  This will create letters for all the companies in the database.

To view all the letters, choose Edit individual letters.  This will put all the letters into one document.

Save this document into your Unit 9.3 Time Machine folder.  You have successfully completed the mail merge.

If you are finished try any of the MS WORD games HERE.