1 / 7

Collating Data in Excel

Collating Data in Excel. Learning Objective. “Learn how to collate data using Microsoft Excel”. Write this Learning Objective onto your Self Assessment Sheet. Thursday, 19 February 2009. Results of a Survey.

vivek
Download Presentation

Collating Data in Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Collating Data in Excel

  2. Learning Objective • “Learn how to collate data using Microsoft Excel”. • Write this Learning Objective onto your Self Assessment Sheet. Thursday, 19 February 2009

  3. Results of a Survey • Your job will be to put the results of a survey into an Excel spreadsheet and create graphs from the data. Learn how to collate data using Microsoft Excel

  4. Laying out the Spreadsheet Summary of each question. Answers to go in columns under male and female headings. Learn how to collate data using Microsoft Excel

  5. Task • Create a spreadsheet laid out like the one below to record all of the results from the survey: Learn how to collate data using Microsoft Excel

  6. Extension Task • Customise your spreadsheet by adding borders and colours to make it look more appealing. Learn how to collate data using Microsoft Excel

  7. Learning Objective • “Learn how to collate data using Microsoft Excel”. • Put  or  onto your Self Assessment sheet to show whether or not you have achieved today’s learning objective. Thursday, 19 February 2009

More Related