pptx, 15.62 MB
pptx, 15.62 MB
docx, 160.9 KB
docx, 160.9 KB
pdf, 310.56 KB
pdf, 310.56 KB
pdf, 806.99 KB
pdf, 806.99 KB
xlsx, 212.25 KB
xlsx, 212.25 KB
pdf, 804.76 KB
pdf, 804.76 KB
xlsx, 211.34 KB
xlsx, 211.34 KB
pdf, 1.37 MB
pdf, 1.37 MB

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 cleansing part of the analysis process in Excel, specifically,

• how to drop unrequired rows and columns
• what naming conventions are commonly used for variables and how to rename variables
• how to remove duplicates
• how to fix missing and outlying values that have already been identified
• how to remove metadata

Lesson content,

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

Creative Commons "Sharealike"

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have downloaded this resource can review it

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.