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 lesson covers how to summarise datasets in Excel, specifically, calculate the total, count, min/max and average of rows data group rows of data based on logical criteria perform calculations on grouped data Lesson content, A PowerPoint/PDF presentation, ‘Summarising datasets in Excel’ Excel Question workbook on ‘Summarising datasets in Excel’ (for learners) Excel Answers workbook on ‘Summarising 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 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 to create new variables in Excel, specifically, • what and how to to extract data to create a new variable • what and how to combine data to create a new variable Lesson content, A PowerPoint/PDF presentation, ‘Creating new variables by extracting & combining in Excel’ Excel Question workbook on ‘Creating new variables by extracting & combining in Excel’ (for learners) Excel Answers workbook on ‘Creating new variables by extracting & combining in Excel’ (for teachers) 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 lesson covers how data can be misused, specifically, What is data misuse Malicious data misuse and how it can happen Accidental data misuse and how it can happen Lesson content, A PowerPoint/PDF presentation, ‘Data misuse’ Excel Question workbook on ‘Data misuse’ (for learners) Excel Answers workbook on ‘Data misuse’ (for teachers) Planning document with learning intentions and sucess 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 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 lesson covers how to create new variables by calculations in Excel, specifically, Creating variables by performing calculations Using Excel to create new calculated variables Introduction to conditional formulas Using conditional formulas in Excel Lesson content, A PowerPoint/PDF presentation, ‘Creating new variables by calculation in Excel’ Excel Question workbook on ‘Creating new variables by calculation in Excel’’ (for learners) Excel Answers workbook on ‘Creating new variables by calculation 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 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 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, 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, 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, How to keep your personal data and online accounts secure by using strong passwords, password managers and Multi-Factor Authentication. How to protect your devices with anti-virus software, firewalls, and VPNs. Lesson content, A PowerPoint/PDF presentation, ‘Keeping personal data secure’ Excel/PDF Question workbook on ‘Keeping personal data secure’ (for learners) Excel/PDF Answers workbook on ‘Keeping personal 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 on this lesson, 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 lesson covers, the difference between qualitative and quantitative data the difference between discrete and continuous data. Lesson content, A PowerPoint/PDF presentation, ‘Qualitative & Quantitative’ Excel/PDF Question workbook on ‘Qualitative & Quantitative’ (for learners) Excel/PDF Answers workbook on ‘Qualitative & Quantitative’ (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.