Data Science - in Excel, advanced practise combining datasets

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

This lessons follows on from the ‘Practise combining datasets’ lesson which is available from the effini shop.

This lesson covers how to combine datasets in Excel, specifically:

• how to join datasets when the key columns have different names
• how to join datasets with multiple key columns
• how to solve problems by selecting the appropriate join type

Lesson content:

• A lesson plan (this document)
• a PowerPoint presentation, ‘Advanced practise combining datasets in Excel’
• a question worksheet (for learners) on ‘Advanced practise combining datasets in Excel’ in Excel
• an answers worksheet (for teachers) on ‘Advanced practise combining datasets in Excel’ in Excel

• a planning document with learning intentions and success criteria

For more information on the Data Science NPA, please see teachdata.science.

If you have any questions or feedback please email lessons@effini.com

This lesson has been created by effini in partnership with The Data Lab.

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