This page provides an initial set of resources covering the first half of the NPA across levels 4, 5 and 6.
Materials are provided for use with Excel and Python. All links below point to zip files containing Powerpoint lessons along with the relevant additional resources.
Excel Lessons
- Quantitative and Qualitative Data
- Scales of Measurement
- The Structure and Format of Data
- Data Types and Storage
- Manipulating Columns in a Dataset
- Manipulating Rows in a Dataset
- Creating New Variables by Calculation
- Creating New Variables by Extracting and Combining
- Summarising Data
- Reshaping Data Sets
- Practice reshaping Datasets
- Understanding Datasets
- Practice Understanding Datasets
- The Analysis Process
- Data Cleansing
- Practice Data Cleansing
- Advanced Data Cleansing
- Creating Graphs
- Practice Creating Graphs
Python Lessons
- Quantitative and Qualitative Data
- Scales of Measurement
- The Structure and Format of Data
- Data Types and Storage
- Introduction to Jupyter Notebooks
- Introduction to Python for Data Science Part 1
- Introduction to Python for Data Science Part 2
- Mainipulating Columns in a Dataset
- Mainipulating Rows in a Dataset
- Creating new Variables by Calculation in Python Part 1
- Creating new Variables by Calculation in Python Part 2
- Creating New Variables By Extracting and Combining in Python
- Summarising Datasets in Python Part 1
- Summarising Datasets in Python Part 2
- Reshaping Datasets
- Practice Reshaping Datasets in Python
- Understanding Datasets in Python Part 1
- Understanding Datasets in Python Part 2
- Practise Understanding Datasets in Python
- The Analysis Process
- Data Cleansing in Python Part 1
- Data Cleansing in Python Part 2
- Advanced Data Cleansing in Python Part 1
- Advanced Data Cleansing in Python Part 2
- Practise Data Cleansing in Python
- Creating Bar Charts in Python
- Creating Other Graphs in Python