Hero image

effini's Shop

Average Rating5.00
(based on 2 reviews)

effini is a data solutions company based in Edinburgh. We have partnered with Data Education in Schools, The Data Lab, Data Skills in Work, Skills Development Scotland, and the Scottish Government to provide free to use lesson resources for high school teachers of Data Science. The resources are aligned to the Data Science National Progression Award (NPA) Levels 4,5 and 6. https://www.sqa.org.uk If you have any feedback or questions about the resources, please email lessons@effini.com

53Uploads

5k+Views

11k+Downloads

effini is a data solutions company based in Edinburgh. We have partnered with Data Education in Schools, The Data Lab, Data Skills in Work, Skills Development Scotland, and the Scottish Government to provide free to use lesson resources for high school teachers of Data Science. The resources are aligned to the Data Science National Progression Award (NPA) Levels 4,5 and 6. https://www.sqa.org.uk If you have any feedback or questions about the resources, please email lessons@effini.com
Data Science - Practise reshaping in Python
effinieffini

Data Science - Practise reshaping in Python

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 5 and 6. This lesson covers, how pandas indexes work practise reshaping from long to wide and wide to long Lesson content, A PowerPoint/PDF presentation, ‘Practise reshaping datasets in Python’ 2 Jupyter notebooks: ‘practise_reshaping_data.ipynb’ (for learners) ‘practise_reshaping_data_with_answers.ipynb’ (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
Data Science - Practise reshaping in Excel
effinieffini

Data Science - Practise reshaping in Excel

(0)
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
Data Science - Summarising data in Python (part 1)
effinieffini

Data Science - Summarising data in Python (part 1)

(0)
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 1 of 2), specifically, summarise complete datasets perform summary calculations for single variables, such as the total, count, min/max and average values perform summary calculations for multiple variables Lesson content, A PowerPoint/PDF presentation, ‘Summarising datasets in Python (part 1)’ Jupyter notebooks: ‘summarising_datasets_with_answers_part_1.ipynb’ (for teachers) ‘summarising_datasets_part_1.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.
Data Science - In Python, extracting & combining variables
effinieffini

Data Science - In Python, extracting & combining variables

(0)
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 Python, 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 Python’ Jupyter notebooks: ‘creating_variables_by_extracting_or_combining_with_answers.ipynb’ (for teachers), ‘creating_variables_by_extracting_or_combining.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.
Data Science - Data Management
effinieffini

Data Science - Data Management

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Level 6. This lesson covers how to manage data, specifically, The areas of data management and the activities organisations undertake. Why it’s important to manage data, and what happens when data is not managed well. Lesson content, A PowerPoint/PDF presentation, ‘Data Management’ Excel Question workbook on ‘Data Management’ (for learners) Excel Answers workbook on ‘Data Management’ (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.
Data Science - Using Python to create new variables by calculation (part 1)
effinieffini

Data Science - Using Python to create new variables by calculation (part 1)

(0)
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 Python (part 1 or 2), specifically, Creating new calculated variables, where the calculation that is used is the same for each row in the dataset. Lesson content, • A Powerpoint presentation, ‘Creating new variables by calculation in Python part 1’ • Jupyter notebooks: o ‘creating_variables_by_calculation_with_answers_part_1.ipynb’ (for teachers), and o ‘creating_variables_by_calculation_part_1.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 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.
Data Science - Manipulating rows in Python
effinieffini

Data Science - Manipulating rows in Python

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lesson covers how to manipulate rows in Python, specifically, Subsetting Filtering Sorting Deduplicating Lesson content, Powerpoint presentation, 'Manipulating dataset rows in Python’ Jupyter notebooks: ‘data_manipulation_of_rows_with_answers.ipynb’ (for teachers), and ‘data_manipulation_of_rows.ipynb’ (for learners) 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 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
Data Science - Practise creating Excel graphs (part 2)
effinieffini

Data Science - Practise creating Excel graphs (part 2)

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lessons covers how to create line graphs and scatterplots in Excel, specifically, how to make standard changes to line graphs and scatterplots how to plot a line graph without date value variables how to add data labels how to amend data points Lesson content, A PowerPoint/PDF presentation, ‘Practise creating graphs in Excel (part 2)’ Excel Question workbook on ‘Practise creating graphs in Excel (part 2)’ (for learners) Excel Answers workbook on ‘Practise creating graphs in Excel (part 2)’ (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. © 2022. This work is licensed under a CC BY-NC-SA 4.0 license.
Data Science - Creating other graphs in Python
effinieffini

Data Science - Creating other graphs in Python

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lessons covers how to create histograms, line graphs and scatter plots in Python using the seaborn package. Lesson content, Powerpoint presentation: ‘Creating other Charts in Python’ Jupyter notebooks: ‘creating_other_charts.ipynb’ (for learners) ‘creating_other_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.
Data Science - Creating Bar Charts in Python
effinieffini

Data Science - Creating Bar Charts in Python

(0)
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.
Data Science - Manipulating columns in Python
effinieffini

Data Science - Manipulating columns in Python

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lesson covers how to manipulate columns in Python, specifically, Selecting columns Reordering columns Reformatting columns Lesson content, Powerpoint presentation, 'Manipulating dataset columns in Python’’ Jupyter notebooks: ‘data_manipulation_of_columns_with_answers.ipynb’ (for teachers), and ‘data_manipulation_of_columns.ipynb’ (for learners) 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 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
Data Science - Caring for your data
effinieffini

Data Science - Caring for your data

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Level 6. This lesson covers how to care for your data, specifically, What are the different data types that need to be cared for How to create a data dictionary Lesson content, A PowerPoint/PDF presentation, ‘Caring for your data’ Excel Question workbook on ‘Caring for your data’ (for learners) Excel Answers workbook on ‘Caring for your data’ (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.
Data Science - Importance of data quality
effinieffini

Data Science - Importance of data quality

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Level 6. This lesson covers the importance of data quality, specifically, What is high quality data and why its important How to assess and improve the quality of a dataset Lesson content, A PowerPoint/PDF presentation, ‘Importance of data quality’ Excel Question workbook on ‘Importance of data quality’ (for learners) Excel Answers workbook on ‘Importance of data quality’ (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.
Data Science - Causes & impacts of bias
effinieffini

Data Science - Causes & impacts of bias

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Level 6. This lesson covers how to use data ethically, specifically, What is bias and the causes of bias How to mitigate against data bias. Lesson content, A PowerPoint/PDF presentation, ‘Causes & impacts of bias’ Excel Question workbook on ‘Causes & impacts of bias’ (for learners) Excel Answers workbook on ‘Causes & impacts of bias’ (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.
Data Science - Intro to Jupyter notebooks
effinieffini

Data Science - Intro to Jupyter notebooks

(0)
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.
Data Science - Intro to Python (part 2)
effinieffini

Data Science - Intro to Python (part 2)

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lessons is an Intro to Python for Data Science (part 2 of 2) ,covering, understand Python data types and data structures that are important for data science manipulate strings create and call Python functions call a Python object’s methods and access its properties perform a sequence of operations using method chaining Lesson content, Powerpoint presentation: ‘Introduction to Python for Data Science (Part 2)’ Jupyter notebooks: ‘intro_to_python_for_data_science_part_2.ipynb’ (for learners) ‘intro_to_python_for_data_science_with_answers_part_2.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. © 2021. This work is licensed under a CC BY-NC-SA 4.0 license.
Data Science - Intro to Python (part 1)
effinieffini

Data Science - Intro to Python (part 1)

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lessons is an Intro to Python for Data Science (part 1 of 2) ,covering, why Python is widely used in data science install, import and use Python packages understand how to get help when using Python name variables clearly and consistently Lesson content, Powerpoint presentation, ‘Introduction to Python for Data Science (Part 1)’ Jupyter notebooks: ‘intro_to_python_for_data_science_part_1.ipynb’ (for learners) ‘intro_to_python_for_data_science_with_answers_part_1.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. © 2021. This work is licensed under a CC BY-NC-SA 4.0 license.
Data Science - Practise creating Excel graphs (part 1)
effinieffini

Data Science - Practise creating Excel graphs (part 1)

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6. This lessons covers how to creating bar charts and histograms in Excel, specifically, • how to amend the font, colour and display format of graph elements • how to amend gridlines on a graph • how to change the order and gaps of the bars in a bar chart • how to change the size of the bins in a histogram Lesson content, A PowerPoint/PDF presentation, ‘Practise creating graphs in Excel (part 1)’ Excel Question workbook on ‘Practise creating graphs in Excel (part 1)’ (for learners) Excel Answers workbook on ‘Practise creating graphs in Excel (part 1)’ (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. © 2022. This work is licensed under a CC BY-NC-SA 4.0 license.
Data Science - Ethical use of data
effinieffini

Data Science - Ethical use of data

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Level 6. This lesson covers how to use data ethically, specifically, What are ethical data risks How to identify ethical risks What are data ethics frameworks and how they can be used to prevent ethical risks Lesson content, A PowerPoint/PDF presentation, ‘Ethical use of data’ Excel Question workbook on ‘Ethical use of data’ (for learners) Excel Answers workbook on ‘Ethical use of data’ (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.
Data Science - Reshaping datasets
effinieffini

Data Science - Reshaping datasets

(0)
Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 5 and 6. This lesson covers, Definitions of wide and long data Reasons for reshaping data Examples where data will need to be wide or long Lesson content, A PowerPoint/PDF presentation, ‘Reshaping datasets’ Excel/PDF Question workbook on ‘Reshaping datasets’ (for learners) Excel/PDF Answers workbook on ‘Reshaping datasets’ (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