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.

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.

9Y – Period 3: Tuesday 24th April

Starter – Creating Forms

Please open your time machine database which you created at the end of last term.

Now watch this video which will show you how to create a form to help you enter data into a database.  If you finish quickly you could also watch any of these videos to customise your form.  In your Time Machine Database, create a form to help you enter data about your customers (the first video will help you with this).  If you finish quickly then go on to customise your form (the 2nd video above will help you with this one).

Task 1 – Adding new data using your form

Once you have set up your form, use it to enter the extra data below into your database (you can copy and paste if that is easier).

1. Sue Daly
2. Tripp Paving Ltd.
3. col@tripppaving.co.uk
4. Phone 01745 123123
5. Address: Parkers Crescent, Westvale, WV7 2RT
6. Type – Company
7. Event – The London Ghostwalk
8. Notes: This is a new event.

1. Todd Sweeney
2. Choice Cuts Hair Salon
3. tsweeney@choicecuts.com
4. Phone 01675 936574
5. Address: Severance Street, Mudchester MD54 8UT
6. Type – Company
7. Event – Medieval banquet

1. Onya Marks
2. Vale Hill Sports and Community College
3. justincase@valehill.sch.uk
4. Phone – no number
5. Address: Vale Hill, Portborough PH2 9NE
6. Type – School
7. Event – French Revolution

Task 2 – Parameter Queries

After the demonstration, please use the query design sheet to design the queries required.  You can then create your queries in the database and test them to see if they work correctly.

Task 3 – Creating 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 a logo.

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.

9Y – Period 3: Tuesday 20th March

Starter: Read all about data types by clicking here.  Then a short quiz

Time Machine – Information storage

Currently, there is no system for the storage and retrieval of information about Time Machine’s customers and you are going to be required to set up a database system to help them with this.  Here is the database brief from Time Machine;

We need the database to store information on all our customers, including future customers. It is really important that we can put in new customer information really easily, preferably using some kind of form to fill out details.

We need to have fields for contact name, company name, address, postcode and phone number. We also need to be able to email customers with special offer deals and new events.

We want to be able to search for companies by the type of organisation they are (for example, a school) and also by which event we organised for them. Please also include on each record a space for making notes.

Task 1 – identifying fields

With the person or people next to you, use a whiteboard to identify the fields that you will need in your database and what data types they should be.  Try and stick to the correct naming conventions for the field names.

Task 2 – create a database

You need to create a new blank database called “Time Machine” and save it in your Time Machine folder.  Once you have set up the database create a new table in design view and set up the fields and data types.

Task 3 – preparing the data

Open the file called Customer Data – Res6b.xls which can be found in; Pupils:\Senior Pupils\ICT\Y09\Unit 9.3 Time Machine\Lesson_6.  This is the data that you will need to import into your database.  Are there any changes you will need to make to your database fields?  When everything is OK, type in the field names for each column in the first row of the spreadsheet and save a copy in your Unit 9.3 folder.  Your field names in your spreadsheet must match the field names in your database exactly!

Task 4 – importing the data

The next job is to import the spreadsheet into your database.  Follow these steps;

1. In Access, click on the External Data tab
2. Then find the excel icon with the green arrow and click on this
3. Choose the second option in the list which says “Append a copy of the records to the table” – your customer table should be in the box next to it.
4. Click on the browse button next to the file name box and find the copy of the customer data file which you saved in your 9.3 folder.  Now click OK
5. You should now see a list of names and addresses – click next,
6. Under import to table it should say the name of your customers table – click finish and your data should be imported (you don’t need to save the import steps – just click close).
7. Double click on your customers table to see if the data has been imported.

If you get an error message then this means your field names in your excel data and your database do not match exactly.  Make sure they are exactly the same and in the right order before trying again.

Extension – Creating Forms

Please watch this video which will show you how to create a form to help you enter data into a database.  If you finish quickly you could also watch any of these videos to customise your form.  In your Time Machine Database, create a form to help you enter data about your customers (the first video will help you with this).  If you finish quickly then go on to customise your form (the 2nd video above will help you with this one).

9Y – Period 5: Friday 16th March

Trench Warfare – Leaflet Assessment

Today I would like you to complete a leaflet in under one hour.  You may run out of time but you need to complete as much of the leaflet as possible.

You will be given a sheet which details everything you need to do and the information you need to include on the leaflet.  The instruction sheet can also be found in: Shared:\Pupils\Senior Pupils\ICT\Y09\Unit 9.3 Time Machine\Lesson_13\9.3 Assessment -  A Trench Warfare weekend

You can use the internet to find information and images for your leaflet might you might find some suitable images in: Shared:\Pupils\Senior Pupils\ICT\Y09\Unit 9.3 Time Machine\Unit_9_3_ImageLibrary

A successful leaflet will;

• Meet all the requirements detailed on the leaflet
• Have a good balance of text and images
• Be neatly aligned and laid out (guidelines might help you here)
• Avoid lots of empty space
• Avoid images overlapping or obscuring text
• Avoid any obvious spelling or grammar mistakes

If you can’t remember how to get started, watch the two videos from this post: http://ictatshr.wordpress.com/2012/02/20/9y-period-3-tuesday-21st-february/

Printing your leaflets

CHECK PRINT PREVIEW to make sure nothing is cut off and then print your leaflets double sided on the colour printer by doing the following;

1. Choose File – Print
2. Select the ICT-Room-Colour Printer
3. Click on properties
4. In the 2-sided printing box choose 2-Sided Print, Flip on Short Edge

If you finish…

Explore the new windows 7 and see what it can do.

9Y – Period 3: Tuesday 6th March

Starter: More quick brains… letters, numbers, colours…

Task 1: Finishing and printing your leaflets

You need to complete and print out your leaflet today.  You can print them double sided on the colour printer by doing the following;

1. Choose File – Print
2. Select the ICT-Room-Colour Printer
3. Click on properties
4. In the 2-sided printing box choose 2-Sided Print, Flip on Short Edge

Task 2: Upload your leaflet to voicethread

Follow these steps to upload your leaflet;

1. Save your leaflet as a .pdf (try file – publish as pdf, make sure you tick the “impose pages” box)
2. upload the .pdf to the “9Y Time Macine leaflets” voicethread – remember to put your name in the title (you will have two slides – one for each page)
3. give your leaflet two stars and a wish as well as any other others you find on there

Task 3: Creating graphics in PagePlus

Please watch this video about creating graphics in PagePlus – there are some good tricks to learn: http://www.serif.com/appresources/PPX5/Tutorials/en-gb/pageplus.htm

Now have a go at creating the same graphic – you can watch and pause the video as you go.  Use Time Machine as the company name.

Can you create your own graphic using the same skills and techniques?

9Y – Period 5: Friday 2nd March

Starter: Quick Brains

Task 1: Researching and designing a leaflet for your experience.

Please continue to work on your leaflets from last lesson – scroll down to last lesson’s post for more details and help videos.

Extension

Have a look at this presentation which is about AS Level coursework.  Slides 22-36 cover some advanced techniques.  Can you incorporate any of these in your leaflet and make it an AS standard piece of work?

Voicethread

Save your leaflet as a .pdf and upload it the “9Y Time Macine leaflets” voicethread

9Y – Period 3: Tuesday 21st February

Starter: You have 10 minutes to comment further on each other’s videos on voicethread.  Please upload your movie if you haven’t already done so – refer to last lesson’s post to help you if need be.

Task 1: Researching and designing a leaflet for your experience.

You now need to create a leaflet for your experience.  Most professional leaflets and magazine covers use an image to fill the first page and then text is placed on  top of this image.  See if you can find an image to fill the front cover of your leaflet.

Your leaflet should;

• be neatly laid out with little whitespace (see the second video)
• include your logo
• give details of your experience – no spelling or grammar errors!
• include relevant images – ensure they are not distorted or pixelated
• include contact details for Time Machine
• have a QR (quick response) code for the time machine website (you can make this up) or a special message (could be a discount code) – try http://qrcode.kaywa.com/

Your leaflet could;

• include a map with “how to find us” directions
• display quotes from previously satisfied customers

These videos will help you to get started;

getting started with pageplus

►

How_to_layout_the_inside_pages_of_your_leaflet_in_PagePlus

►

Extension

Have a look at this presentation which is about AS Level coursework.  Slides 22-36 cover some advanced techniques.  Can you incorporate any of these in your leaflet and make it an AS standard piece of work?