Explore the Curriculum

7 Chapters · 97 Lessons

  1. 1

    Introduction to Data Science

    1. (Included in full purchase)

      Introduction to Data Science

    2. (Included in full purchase)

      Data Science 1 Glossary: Collecting, Storing & Analysing Data

    3. (Included in full purchase)

      Data Science 2 Glossary: Data Quality

    4. (Included in full purchase)

      Data Science 3 Glossary: Processing & Presenting Data

  2. 2

    Section 1: Collecting, Storing & Analysing Data

    1. (Included in full purchase)

      1.1. Quantitative & Qualitative Data

    2. 1.2. Levels Of Measurement Applied To Data Free preview
    3. (Included in full purchase)

      1.3. Data Types

    4. (Included in full purchase)

      1.4. Data Sampling

    5. (Included in full purchase)

      1.5. Primary & Secondary Data

    6. 1.6. Informatics Free preview
    7. (Included in full purchase)

      1.7. Interpret & Present Data

    8. (Included in full purchase)

      1.8. Structured & Unstructured Datasets

    9. (Included in full purchase)

      1.9. Methods For Obtaining Feedback

    10. (Included in full purchase)

      1.10. Errors, Uncertainty & Limitations Part 1

    11. (Included in full purchase)

      1.11. Errors, Uncertainty & Limitations Part 2

    12. 1.12. Blockchain Technology Free preview
    13. (Included in full purchase)

      1.13. Blockchain Examples

    14. (Included in full purchase)

      1.14. Software Features That Affect The Privacy & Security Of Data

    15. (Included in full purchase)

      1.15. Big Data & Data Warehousing

    16. (Included in full purchase)

      1.16. Data Mining

    17. (Included in full purchase)

      1.17. The Impact of Data Scale

    18. (Included in full purchase)

      1.18. Methods of Data Storage

    19. Multiple Choice Quiz 1: Collecting, Storing & Analysing Data Free preview
    20. Short Answer Question Set 1: Collecting, Storing & Analysing Data Free preview
    21. Case Study Question 1: Collecting, Storing & Analysing Data Free preview
  3. 3

    Section 2: Data Quality

    1. (Included in full purchase)

      2.1. The Ethical Use Of Data

    2. (Included in full purchase)

      2.2. Social, Legal & Ethical Issues

    3. (Included in full purchase)

      2.3. Bias

    4. 2.4. Metadata Free preview
    5. (Included in full purchase)

      2.5. Accuracy of Collected Data

    6. (Included in full purchase)

      2.6. Copyright & Acknowledgement Of Data Sources

    7. 2.7. Intellectual Property (IP) Free preview
    8. (Included in full purchase)

      2.8. Intellectual Property & ICIP

    9. (Included in full purchase)

      2.9. Data Security

    10. (Included in full purchase)

      2.10. Legal Issues Related To Data Science

    11. (Included in full purchase)

      2.11. Privacy Act 1988

    12. (Included in full purchase)

      2.12. Notifiable Data Breaches (NDB's) & The Role Of The OAIC

    13. (Included in full purchase)

      2.13. The Influence Of Curated & Communicated Data

    14. (Included in full purchase)

      Multiple Choice Quiz 2: Data Quality

    15. (Included in full purchase)

      Short Answer Question Set 2: Data Quality

    16. (Included in full purchase)

      Case Study Question 2: Data Quality

  4. 4

    Section 3: Processing & Presenting Data

    1. 3.1. Summarise Data Using A Spreadsheet Free preview
    2. (Included in full purchase)

      3.2. Collating Information Using A Spreadsheet

    3. (Included in full purchase)

      3.3. Filtering, Grouping & Sorting Data in a Spreadsheet

    4. (Included in full purchase)

      3.4. Basic Spreadsheet Functions

    5. (Included in full purchase)

      3.7. Statistically Analysing Data

    6. 3.8. Conditional Formatting Free preview
    7. 3.9. Making Data Comparisons Free preview
    8. (Included in full purchase)

      3.10. Charts & Graphs

    9. 3.11. Tables, Filters & Slicers Free preview
    10. 3.12. Pivot Tables Free preview
    11. (Included in full purchase)

      3.13. Pivot Charts

    12. (Included in full purchase)

      3.14. Spreadsheet Forms

    13. (Included in full purchase)

      3.15. Spreadsheet Reports

    14. (Included in full purchase)

      3.16. The Logical Organisation of Flat-File Databases

    15. (Included in full purchase)

      3.17. Introduction to Data Dictionaries - Student Details

    16. (Included in full purchase)

      3.18. Data Dictionary Example: Driver's License Details

    17. (Included in full purchase)

      3.19. Data Dictionary Example: Vehicle Details

    18. (Included in full purchase)

      3.20. The Logical Organisation of Relational Databases

    19. (Included in full purchase)

      3.21. Schematic Diagrams (Schema's) & Database Relationships

    20. (Included in full purchase)

      3.22. Online Movie Stores

    21. 3.23. School Databases Free preview
    22. (Included in full purchase)

      3.24. The Roads & Maritime Services (RMS)

    23. (Included in full purchase)

      3.25. Normalisation

    24. (Included in full purchase)

      3.26. Create A Relational Database By Linking Key Fields

    25. (Included in full purchase)

      3.27. Introduction to Structured Query Language (SQL)

    26. (Included in full purchase)

      3.28. Database Forms

    27. (Included in full purchase)

      3.29. Database Reports

    28. (Included in full purchase)

      3.30. Machine Learning & Statistical Modelling

    29. (Included in full purchase)

      Multiple Choice Quiz 3: Processing & Presenting Data

    30. (Included in full purchase)

      Short Answer Question Set 3: Processing & Presenting Data

    31. (Included in full purchase)

      Case Study Question 3: Processing & Presenting Data

  5. 5

    Section 4: Structured Query Language (SQL)

    1. (Included in full purchase)

      4.1. Introduction To Structured Query Language (SQL)

    2. (Included in full purchase)

      4.2. Introduction To Relational Operators

    3. (Included in full purchase)

      4.3. EQUALS / NOT EQUAL TO

    4. (Included in full purchase)

      4.4. CONTAINS / DOES NOT CONTAIN

    5. (Included in full purchase)

      4.5. Wildcard Symbols

    6. (Included in full purchase)

      4.5.a. Alternative Wildcard Symbols

    7. 4.6. Introduction To Logical Operators Free preview
    8. (Included in full purchase)

      4.7. Searching Using Multiple Criteria

    9. 4.8. Querying A Relational Database Free preview
    10. (Included in full purchase)

      4.8.a. Querying A Relational Database Example 2 [3 Tables]

    11. (Included in full purchase)

      4.9. Sort Data Using Multiple Fields To Specify Sequence

    12. (Included in full purchase)

      4.10. SQL in Action - Basic SQL Keywords

    13. (Included in full purchase)

      4.11. SQL in Action - Relational Operators

    14. (Included in full purchase)

      4.12. SQL in Action - Logical Operators

    15. (Included in full purchase)

      4.13. SQL in Action - Querying A Relational Database

    16. (Included in full purchase)

      4.14. SQL in Action - Querying A Relational Database 2 [3 Entities]

  6. 6

    Data Science Activity Sample Answers

    1. (Included in full purchase)

      Short Answer Questions 1: Collecting, Storing & Analysing Data Answers

    2. Case Study Question 1: Collecting, Storing & Analysing Data Answers Free preview
    3. (Included in full purchase)

      Short Answer Question Set 2: Data Quality Answers

    4. (Included in full purchase)

      Case Study Question 2: Data Quality Answers

    5. (Included in full purchase)

      Short Answer Question Set 3: Processing & Presenting Data Answers

    6. (Included in full purchase)

      Case Study Question 3: Processing & Presenting Data Answers

  7. 7

    Data Science Adminintive Resources

    1. (Included in full purchase)

      TEMPLATE: Data Science Notes Document

    2. (Included in full purchase)

      SYLLABUS DOCUMENT: Data Science

    3. (Included in full purchase)

      COURSE SPECIFICATIONS: Enterprise Computing