Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lesson covers, Different structures for holding data. Difference between stored and display formats Lesson content, A PowerPoint/PDF presentation, ‘Data types and storage’ Excel/PDF Question workbook on ‘Data types and storage’ (for learners) Excel/PDF Answers workbook on ‘Data types and storage’ (for teachers) Planning document with learning intentions and sucess 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.

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lesson covers, Different structures for holding data. Difference between stored and display formats Lesson content, A PowerPoint/PDF presentation, ‘The structure and format of data’ Excel/PDF Question workbook on ‘The structure and format of data’ (for learners) Excel/PDF Answers workbook on ‘The structure and format of data’ (for teachers) Planning document with learning intentions and sucess 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

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lesson covers, Understanding the scales of measurement. Qualitative data - nominal and ordinal. Quantitative data - interval and ratio Lesson content, A PowerPoint/PDF presentation, ‘Scales of measurement’ Excel/PDF Question workbook on ‘Scales of measurement’ (for learners) Excel/PDF Answers workbook on ‘Scales of measurement’ (for teachers) Planning document with learning intentions and sucess 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

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lesson covers how to manipulate columns in Excel, specifically, Selecting columns Reordering columns Reformatting columns Lesson content, A PowerPoint/PDF presentation, ‘Manipulating dataset columns in Excel’ Excel Question workbook on ‘Manipulating dataset columns in Excel’ (for learners) Excel Answers workbook on ‘Manipulating dataset columns in Excel’ (for teachers) Planning document with learning intentions and sucess 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

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lesson covers how to manipulate rows in Excel, specifically, Subsetting Filtering Sorting Deduplicating Lesson content, A PowerPoint/PDF presentation, ‘Manipulating datasets rows in Excel’’ Excel Question workbook on ‘Manipulating datasets rows in Excel’’ (for learners) Excel Answers workbook on ‘Manipulating datasets rows in Excel’’ (for teachers) Planning document with learning intentions and sucess 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.

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lesson covers how organisations keep data secure and what data rights and responsibilities individuals and organisations have under the law. Lesson content, A PowerPoint/PDF presentation, ‘Keeping organisational data secure’ Excel Question workbook on ‘Keeping organisational data secure’ (for learners) Excel Answers workbook on ‘Keeping organisational data secure’ (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 Data Education in Schools and Skills Development Scotland. © 2022. This work is licensed under a CC BY-NC-SA 4.0 license.

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lessons is an Introduction to Jupyter notebooks ,covering, an introduction to Jupyter notebooks as a tool for writing code for Data Science projects. Lesson content, Powerpoint presentation: ‘Jupyter notebooks’ Jupyter notebooks: ‘intro_to_jupyter.ipynb’ 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 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. © 2021. This work is licensed under a CC BY-NC-SA 4.0 license.

This document is a guide to the educational resources developed by effini, in collaboration with Data Education in Schools and The Data Lab, to support educators delivering the National Progression Award (NPA) in Data Science or Professional Development Award (PDA) in Data Science. It provides an overview of these resources and is intended to be used by educators. It provides educators with information on: • What the NPA and PDA in Data Science are • Options for delivering the NPA • What the resources are • What can be done with them, and • How to access them. If you have any questions, please contact us at lessons@effini.com

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lesson covers how to summarise datasets in Python (part 2 of 2), specifically, group rows of data based on logical criteria perform summary calculations on grouped data Lesson content, A PowerPoint/PDF presentation, ‘Summarising datasets in Python (part 2)’ Jupyter notebooks: ‘summarising_datasets_with_answers_part_2.ipynb’ (for teachers) ‘summarising_datasets_part_2.ipynb’ (for learners) Datasets used in the Jupyter notebooks: the datasets are stored online and imported by the Jupyter notebooks. 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.

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lessons covers how to create graphs in Excel, specifically, how creating graphs fits into the analysis steps process of creating bar charts and histograms process of creating line graphs and scatterplots Lesson content, A PowerPoint/PDF presentation, ‘Creating graphs in Excel’ Excel Question workbook on ‘Creating graphs in Excel’ (for learners) Excel Answers workbook on ‘Creating graphs 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 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. © 2021. This work is licensed under a CC BY-NC-SA 4.0 license.

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lessons covers how to create bar charts in Python, specifically, Creation and modification of bar charts in Python using the seaborn package. Lesson content, Powerpoint presentation: ‘Creating Bar Charts in Python’ Jupyter notebooks: ‘creating_bar_charts.ipynb’ (for learners) ‘creating_bar_charts_answers.ipynb’ (for teachers) The Jupyter notebook for teachers contains answers to the tasks set for learners. 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 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. © 2022. This work is licensed under a CC BY-NC-SA 4.0 license.

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.

Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lessons follows on from ‘The Analysis Process’ lesson which is available from the effini TES shop. This lesson covers the data understanding step of the analysis step, specifically, • metadata and data dictionaries • the size, shape and format of a dataset • the data types of variables in a dataset Lesson content, A PowerPoint/PDF presentation, ‘Dataset Understanding in Python (Part 1)’ Jupyter notebooks: ‘understanding_datasets_with_answers_part_1.ipynb’ (for teachers), and ‘understanding_datasets_part_1.ipynb’ (for learners) Datasets used in the Jupyter notebook: the datasets are stored online and imported by the Jupyter notebook. 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. © 2022. This work is licensed under a CC BY-NC-SA 4.0 license.