Data Science - In Excel, practice dataset understanding

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

This lesson follows on from ‘Dataset understanding in Excel’ lesson which is available from the effini TES shop.

This lesson allows learners to practice the skills covered in the Dataset Understanding in Excel, specifically,
• Using data dictionaries/metadata
• Identifying size and shape
• Identifying missing values and outliers

Lesson content,

A PowerPoint/PDF presentation, ‘Practise Dataset Understanding in Excel’
Question worksheet (for learners) on ‘Practise Dataset understanding in Excel’ in Excel
Answers worksheet (for teachers) on ‘Practise Dataset understanding in Excel’ in Excel
Planning document with learning intentions and success criteria
For more information on the Data Science NPA, please see teachdata.science

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.