Data Lessons

NPA Data Science Lessons Overview (zip)

Excel Lessons

  1. Qualitative and Quantitative Data (zip)
  2. Scales of Measurement (zip)
  3. The Structure and Format of Data (zip)
  4. Data Types and Storage (zip)
  5. Manipulating Columns in a Dataset in Excel (zip)
  6. Manipulating Rows in a Dataset in Excel (zip)
  7. Creating New Variables by Calculation in Excel (zip)
  8. Creating New Variables by Extracting and Combining in Excel (zip)
  9. Summarising Data in Excel (zip)
  10. Reshaping Datasets (zip)
  11. Practise Reshaping Datasets in Excel (zip)
  12. Understanding Datasets in Excel (zip)
  13. Practise Understanding Datasets in Excel (zip)
  14. The Analysis Process (zip)
  15. Data Cleansing in Excel (zip)
  16. Practise Data Cleansing in Excel (zip)
  17. Advanced Data Cleansing in Excel (zip)
  18. Creating Graphs in Excel (zip)
  19. Practise Creating Graphs in Excel Part 1 (zip)
  20. Practise Creating Graphs in Excel Part 2 (zip)
  21. Keeping Personal Data Secure (zip)
  22. Keeping Organisational Data Secure (zip)
  23. Data Misuse (zip)
  24. Ethical Use of Data (zip)
  25. Causes and Impacts of Bias (zip)
  26. Importance of Data Quality (zip)
  27. Caring for Data (zip)
  28. Data Management (zip)
  29. Combining Datasets (zip)
  30. Practise Combining Datasets in Excel (zip)
  31. Advanced Practise Combining Datasets in Excel (zip)

Python Lessons

  1. Qualitative and Quantitative Data (zip)
  2. Scales of Measurement (zip)
  3. The Structure and Format of Data (zip)
  4. Data Types and Storage (zip)
  5. Introduction to Jupyter Notebooks (zip)
  6. Introduction to Python for Data Science Part 1 (zip)
  7. Introduction to Python for Data Science Part 2 (zip)
  8. Manipulating Columns in a Dataset in Python (zip)
  9. Manipulating Rows in a Dataset in Python (zip)
  10. Creating New Variables By Calculation in Python Part 1 (zip)
  11. Creating New Variables By Calculation in Python Part 2 (zip)
  12. Creating New Variables By Extracting and Combining in Python (zip)
  13. Summarising Datasets in Python Part 1 (zip)
  14. Summarising Datasets in Python Part 2 (zip)
  15. Reshaping Datasets (zip)
  16. Practise Reshaping Datasets in Python (zip)
  17. Understanding Datasets in Python Part 1 (zip)
  18. Understanding Datasets in Python Part 2 (zip)
  19. Practise Understanding Datasets in Python (zip)
  20. The Analysis Process (zip)
  21. Data Cleansing in Python Part 1 (zip)
  22. Data Cleansing in Python Part 2 (zip)
  23. Advanced Data Cleansing in Python Part 1 (zip)
  24. Advanced Data Cleansing in Python Part 2 (zip)
  25. Practise Data Cleansing in Python (zip)
  26. Creating Bar Charts in Python (zip)
  27. Creating Other Graphs in Python (zip)
  28. Practise Creating Bar Charts in Python (zip)
  29. Keeping Personal Data Secure (zip)
  30. Keeping Organisational Data Secure (zip)
  31. Data Misuse (zip)
  32. Ethical Use of Data (zip)
  33. Causes and Impacts of Bias (zip)
  34. Importance of Data Quality (zip)
  35. Caring for Data (zip)
  36. Data Management (zip)
  37. Combining Datasets (zip)
  38. Practise Combining Datasets in Python (zip)