Thursday 27 September 2012

Yr8 EXCEL chart task: key points

For this task you need to  (1) design a survey; collect responses; tally up the totals for each possible answer you gave; (2) enter the data into an Excel spreadsheet; (3) display your results as a pie chart or graph (using the instruction sheet provided); and (4) finally assess someone else's work while they assess yours!

You need to follow these steps for a successful outcome:
You can create a pie chart or a bar chart/graph
DESIGN A CLASS SURVEY
  1. Create a question that most of your class have a reasonable chance of answering!
  2. Provide 4 or 5 possible answers, plus 'other' so that anybody who wouldn't choose any of your possible answers still has something to select
  3. Examples would be 'which of these is the best film/TV show/pop band/football team/country/city/food' or 'who will win the premier league/championship/formula one title/next football world cup'. These are just a couple of examples.
INPUT SURVEY RESULTS AS DATA INTO SPREADSHEET
  1. For your spreadsheet, put the title into cell 1A, eg '8AHF's favourite pop bands'
  2. You can change the font and size so that this stands out
  3. Skip a row: go to row 3 next
  4. In cell 3A write the category (eg film, country, team; whatever your question asked) - one word will probably be enough
  5. In cell 3B write 'total'
  6. From cell 4A and working down column A type in the choices you gave on your survey form
  7. If any of your choices is a number (eg the film 300 was used in a list of best films) then put single quote marks '' around the name so that software recognises this as a word and not a number
  8. You may need to expand the border of column A so that the full word/title can be seen: if so, click off from any individual cell; hover the mouse between the border line separating columns A and B until you see the icon change and then simply drag the column A border over to the right
  9. From cell 4B and working down column B type in the totals
CHECK AND SAVE YOUR WORK; ADD A BORDER IF YOU WISH
  1. Save your work! Either hold in the Ctrl button and press S or File/Save As.
  2. BEFORE you start generating a graph/chart, check you've not left a blank column, have missed out row 2, have put category + total in 3A and 3B, and have created a spreadsheet precisely like the example shown earlier!
  3. If you really want to add a border, hold in the Ctrl button and click on this link to read this post with instructions.
CREATING A PIE CHART OR GRAPH
  1. Now follow the instructions in the Publisher document Differentiated help sheet which you can find in the Y:\ICT\KS3\Year 8\Charts folder (the Y drive is the curriculum share folder you see when you open My Computer)
  2. When you reach stage 5 on this helpsheet make sure you also check the box for category name.
  3. In the final step change the setting in 'As object in' to Sheet 2 (it is set to sheet 1 automatically).
  4. If you think you've gotten everything right you're ready to have the person beside you go through the checklist to note which parts you've successfully completed! When they're ready you can check theirs. Put their full name on the sheet you're writing on (I'll collect all of these in before you go).
  5. You can put your data collection sheet into the recycling bin.
  6. If you've done all of this you could spend a little time on yout Independent Learning assignment, which must be handed in by Friday 26th October - you can see some instructions in this post.

No comments:

Post a Comment

Please note that all comments are moderated before publication