Data Science - Practise reshaping in Excel

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

This lesson covers,

• Practise switching between wide and long datasets in Excel.

This lesson follows on from the Data Science - Reshaping Datasets lesson, which is available through the effini TES shop.

Lesson content,

A PowerPoint/PDF presentation, ‘Practise reshaping datasets in Excel’
Excel Question workbook on ‘Practise reshaping datasets in Excel’ (for learners)
Excel Answers workbook on ‘Practise reshaping datasets in Excel’ (for teachers)
Planning document with learning intentions and success criteria

The lesson has been designed for learners using Microsoft Excel on a Windows based machine.

This lesson uses Power Query to reshape datasets. Power Query is currently only supported on Microsoft Excel when it is run on a Windows based machine.

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

If you have any questions or feedback on this lesson, please email lessons@effini.com

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