1 / 10

Starter

Starter. What do you think this represents?. Starter - Answer. Internet users as percentage of population. Lesson Objectives. Be able to create graphs using spreadsheet software Be able to label graphs and charts appropriately. Be able to select an appropriate chart for a specific data set.

ahanu
Download Presentation

Starter

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. Starter • What do you think this represents?

  2. Starter - Answer Internet users as percentage of population

  3. Lesson Objectives • Be able to create graphs using spreadsheet software • Be able to label graphs and charts appropriately. • Be able to select an appropriate chart for a specific data set

  4. Graphs • This is the same data you saw on the first slide for the UK. • Why is this less useful?

  5. What are they good for? Pie Charts • Displaying the proportion that each ‘group’ is of the whole. Bar/Column Charts • Comparing values across different categories.

  6. Task 1 – Which Graph? Scatter Graphs • To see how closely one quantity depends on another (correlation). Line Graphs • Showing trends. Usually over time.

  7. Task 1 – Which Graph? • Put the following 4 subheadings in your book leaving 3 lines between each one. Scatter Graph Line Graph Pie Chart Bar/Column Chart • Write the following scenarios under the correct sub-heading: Finding the most popular type of chocolate bar from the pupils in your class. Comparing sales figures across departments Comparing a pupils attendance with their average GCSE score. Tracking the value of a car over 10 years.

  8. Answers Finding the most popular type of chocolate bar from the pupils in your class. Comparing sales figures across departments Tracking the value of a car over 10 years. Comparing a pupils attendance with their average GCSE score.

  9. Task 2 • You will need the files saved in the following folder: >Dept Share > ICT…etc… > Practical Skills > 14 – Spreadsheets > Lesson 5 - Graphs > Task 2 Files • Complete the following activities: • 14.18 – Pages 194-196 • 14.19 – Pages 197-202 • 14.20 – Pages 203-204 • 14.21 – Pages 204-206 • 14.22 – Pages 206-209 • Extension – Enter some data of your own into Excel and use this to create a suitable graph When asked to print, choose ‘Adobe PDF’ as the printer. Save the PDFs to your Practical Skills folder.

  10. Plenary • Describe what the following graphs are used for. • Line Graph • Bar Chart • Pie Chart • Scatter Graph

More Related