Data Science - In Excel, practise combining datasets

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

This lesson follows on from ‘Combining datasets’ lesson, which is available from the effini TES shop.

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

• how to use Power Query Editor to append rows to a dataset
• how to use Power Query Editor to join columns to a dataset

Lesson content,

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

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