Data Science - Advanced data cleansing in Excel

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

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

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

• how to convert between different data types
• how to fix strings
• understand the reasons why there may be missing or outlying values, and how these reasons affect the ways in which we handle them

Lesson content,

A PowerPoint/PDF presentation, ‘Advanced dataset cleansing in Excel’
Excel Question workbook on ‘Advanced dataset cleansing in Excel’ (for learners)
Excel/PDF Answers workbook on ‘Advanced dataset cleansing 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.