Data Science - Practise creating Excel graphs (part 1)

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

This lessons covers how to creating bar charts and histograms in Excel, specifically,
• how to amend the font, colour and display format of graph elements
• how to amend gridlines on a graph
• how to change the order and gaps of the bars in a bar chart
• how to change the size of the bins in a histogram

Lesson content,

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