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

This lesson follows on from 鈥楾he Analysis Process鈥� which is available from the effini TES shop.

This lesson covers the data understanding part of the analysis process in Excel, specifically,

鈥� what is metadata and the importance of a data dictionary
鈥� how to identify the shape and size of a dataset in Excel and data types of variables
鈥� how to identify missing values and outliers in Excel

Lesson content,

A PowerPoint/PDF presentation, 鈥楧ataset understanding in Excel鈥�
Excel Question workbook on 鈥楧ataset understanding in Excel鈥� (for learners)
Excel/PDF Answers workbook on 鈥楧ataset understanding in Excel鈥� (for teachers)
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.