Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6.
This lesson follows on from ‘The 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, ‘Dataset understanding in Excel’
Excel Question workbook on ‘Dataset understanding in Excel’ (for learners)
Excel/PDF Answers workbook on ‘Dataset 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.
Something went wrong, please try again later.
This is a brilliant introduction to the art of data understanding. It can easily be used as a jumping off point for further investigation in data science and practical excel skills. Also, the lessons are easily modified to fit your students current level and eventual end-points. Bravo Effini!
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£0.00