Data Science - Practise creating Excel graphs (part 2)

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

This lessons covers how to create line graphs and scatterplots in Excel, specifically,

• how to make standard changes to line graphs and scatterplots
• how to plot a line graph without date value variables
• how to add data labels
• how to amend data points

Lesson content,

A PowerPoint/PDF presentation, ‘Practise creating graphs in Excel (part 2)’
Excel Question workbook on ‘Practise creating graphs in Excel (part 2)’ (for learners)
Excel Answers workbook on ‘Practise creating graphs in Excel (part 2)’ (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.

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