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

This lesson follows on from 鈥楥ombining 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, 鈥楶ractise combining datasets in Excel鈥�
Excel Question workbook on 鈥楶ractise combining datasets in Excel鈥� (for learners)
Excel Answers workbook on 鈥楶ractise 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.