Get Scientific With Your Data!

Introduction to Data Science

Data Science 1 Glossary: Collecting, Storing & Analysing Data

Data Science 2 Glossary: Data Quality

Data Science 3 Glossary: Processing & Presenting Data

1.1. Quantitative & Qualitative Data

1.3. Data Types

1.4. Data Sampling

1.5. Primary & Secondary Data

1.7. Interpret & Present Data

1.8. Structured & Unstructured Datasets

1.9. Methods For Obtaining Feedback

1.10. Errors, Uncertainty & Limitations Part 1

1.11. Errors, Uncertainty & Limitations Part 2

1.13. Blockchain Examples

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

1.15. Big Data & Data Warehousing

1.16. Data Mining

1.17. The Impact of Data Scale

1.18. Methods of Data Storage

2.1. The Ethical Use Of Data

2.2. Social, Legal & Ethical Issues

2.3. Bias

2.5. Accuracy of Collected Data

2.6. Copyright & Acknowledgement Of Data Sources

2.8. Intellectual Property & ICIP

2.9. Data Security

2.10. Legal Issues Related To Data Science

2.11. Privacy Act 1988

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

2.13. The Influence Of Curated & Communicated Data

Multiple Choice Quiz 2: Data Quality

Short Answer Question Set 2: Data Quality

Case Study Question 2: Data Quality

3.2. Collating Information Using A Spreadsheet

3.3. Filtering, Grouping & Sorting Data in a Spreadsheet

3.4. Basic Spreadsheet Functions

3.7. Statistically Analysing Data

3.10. Charts & Graphs

3.13. Pivot Charts

3.14. Spreadsheet Forms

3.15. Spreadsheet Reports

3.16. The Logical Organisation of Flat-File Databases

3.17. Introduction to Data Dictionaries - Student Details

3.18. Data Dictionary Example: Driver's License Details

3.19. Data Dictionary Example: Vehicle Details

3.20. The Logical Organisation of Relational Databases

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

3.22. Online Movie Stores

3.24. The Roads & Maritime Services (RMS)

3.25. Normalisation

3.26. Create A Relational Database By Linking Key Fields

3.27. Introduction to Structured Query Language (SQL)

3.28. Database Forms

3.29. Database Reports

3.30. Machine Learning & Statistical Modelling

Multiple Choice Quiz 3: Processing & Presenting Data

Short Answer Question Set 3: Processing & Presenting Data

Case Study Question 3: Processing & Presenting Data

4.1. Introduction To Structured Query Language (SQL)

4.2. Introduction To Relational Operators

4.3. EQUALS / NOT EQUAL TO

4.4. CONTAINS / DOES NOT CONTAIN

4.5. Wildcard Symbols

4.5.a. Alternative Wildcard Symbols

4.7. Searching Using Multiple Criteria

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

4.9. Sort Data Using Multiple Fields To Specify Sequence

4.11. SQL GROUP BY Keyword Explained

4.12. SQL Aggregate Function: AVG

4.13. SQL Aggregate Function: SUM

4.14. SQL Aggregate Functions: MAX & MIN

4.15. SQL in Action - Basic SQL Keywords

4.16. SQL in Action - Relational Operators

4.17. SQL in Action - Logical Operators

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

4.20. SQL in Action - Aggregate Functions

4.21. SQL in Action - GROUP BY

4.22. Import Data From a Spreadsheet File to a Database File

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

Short Answer Question Set 2: Data Quality Answers

Case Study Question 2: Data Quality Answers

Short Answer Question Set 3: Processing & Presenting Data Answers

Case Study Question 3: Processing & Presenting Data Answers

TEMPLATE: Data Science Notes Document

SYLLABUS DOCUMENT: Data Science

COURSE SPECIFICATIONS: Enterprise Computing