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

  1. Quantitative and Qualitative Data
  2. Scales of Measurement
  3. The Structure and Format of Data
  4. Data Types and Storage
  5. Manipulating Columns in a Dataset
  6. Manipulating Rows in a Dataset
  7. Creating New Variables by Calculation
  8. Creating New Variables by Extracting and Combining
  9. Summarising Data
  10. Reshaping Data Sets
  11. Practice reshaping Datasets
  12. Understanding Datasets
  13. Practice Understanding Datasets
  14. The Analysis Process
  15. Data Cleansing
  16. Practice Data Cleansing
  17. Advanced Data Cleansing
  18. Creating Graphs
  19. Practice Creating Graphs 

Python Lessons

  1. Quantitative and Qualitative Data
  2. Scales of Measurement
  3. The Structure and Format of Data
  4. Data Types and Storage
  5. Introduction to Jupyter Notebooks
  6. Introduction to Python for Data Science Part 1
  7. Introduction to Python for Data Science Part 2
  8. Mainipulating Columns in a Dataset
  9. Mainipulating Rows in a Dataset
  10. Creating new Variables by Calculation in Python Part 1
  11. Creating new Variables by Calculation in Python Part 2
  12. Creating New Variables By Extracting and Combining in Python
  13. Summarising Datasets in Python Part 1
  14. Summarising Datasets in Python Part 2
  15. Reshaping Datasets
  16. Practice Reshaping Datasets in Python
  17. Understanding Datasets in Python Part 1
  18. Understanding Datasets in Python Part 2
  19. Practise Understanding Datasets in Python
  20. The Analysis Process
  21. Data Cleansing in Python Part 1
  22. Data Cleansing in Python Part 2
  23. Advanced Data Cleansing in Python Part 1
  24. Advanced Data Cleansing in Python Part 2
  25. Practise Data Cleansing in Python
  26. Creating Bar Charts in Python
  27. Creating Other Graphs in Python