Data Science - Creating graphs in Excel

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6.

This lessons covers how to create graphs in Excel, specifically,

• how creating graphs fits into the analysis steps
• process of creating bar charts and histograms
• process of creating line graphs and scatterplots

Lesson content,

A PowerPoint/PDF presentation, ‘Creating graphs in Excel’
Excel Question workbook on ‘Creating graphs in Excel’ (for learners)
Excel Answers workbook on ‘Creating graphs in Excel’’ (for teachers)
Planning document with learning intentions and success criteria

For more information on the Data Science NPA, please see teachdata.science

If you have any questions or feedback on this lesson, please email lessons@effini.com

This lesson has been created by effini in partnership with Data Education in Schools, The Data Lab and Data Skills for Work, with funding from the Scottish Government.

© 2021. This work is licensed under a CC BY-NC-SA 4.0 license.