Data Science - In Excel, extracting & combining variables

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

This lesson covers how to create new variables in Excel, specifically,

• what and how to to extract data to create a new variable
• what and how to combine data to create a new variable

Lesson content,

A PowerPoint/PDF presentation, ‘Creating new variables by extracting & combining in Excel’
Excel Question workbook on ‘Creating new variables by extracting & combining in Excel’ (for learners)
Excel Answers workbook on ‘Creating new variables by extracting & combining 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.

© 2021. This work is licensed under a CC BY-NC-SA 4.0 license.