| Course Outline and Assessments Information |
 Course Outline - IT5507 |
|
|
 Assessment: How to upload a file to the dropbox |
|
|
Project Description |
|
|
 Your Provisional Results for the Course |
You can check your provisional results by visiting the following link:
https://results.whitireia.ac.nz/
Log in using your Moodle username and password to access your results.
|
|
| Day 1 - Introduction to Data Science, Information Systems (IS) Concepts |
Data Science - What is it all about |
|
|
Data Science Examples |
|
|
Day 1 - Introduction to Information Systems (IS) |
|
|
Lab 1 |
|
|
THE ADVANTAGES OF DATA-DRIVEN DECISION-MAKING |
|
|
What is information systems? Definition, uses, and examples |
|
|
Information Science vs Data Science: 5 Key Differences! |
|
|
What are information systems? (Definition and benefits) |
|
|
| Day 2 - Database Systems |
 Examples - Database Systems bank and university |
|
|
Business Process Modelling BPMN |
|
|
Day 2 - Database Systems |
|
|
Lab 2.0 |
|
|
Lab 2.1 |
|
|
Create BPMN diagrams in Visio |
|
|
Explore The Role of Data Processing in Research |
|
|
Importance of Database Design in DBMS |
|
|
Blockchain vs. Traditional Database: What Should Be a Startup’s Choice |
|
|
5 Common Data Management Mistakes and How to Avoid Them |
|
|
| Day 3 - Data Models |
Day 3 - Data Models |
|
|
Lab 3 |
|
|
Lecture notes (Much simplifed version) |
Based on the original presentation slides but use less words and sentences, and simplified descriptions of terminologies. |
|
IBM definition of What is data modeling? |
|
|
Why is Data Modeling Important for Your Business? |
|
|
NoSQL Databases: Advantages and Disadvantages |
|
|
| Day 4 - Relational Database Model |
Day4 - Relational Database Model |
|
|
Lab 4 |
|
|
Day4-Data and Process Modeling |
|
|
DFD Examples - Lemonade |
|
|
Lab 4.1 DFD |
|
|
Chapter 8 The Entity Relationship Data Model |
|
|
Chapter 9 Integrity Rules and Constraints |
|
|
Oracle Definition: What is a Relational Database (RDBMS)? |
|
|
| Day 5 - Revision, ER (Entity-Relationship) Modelling and Test 1 |
Day 5 - ERD Modeling |
|
|
Lab 5 |
|
|
ERD Modelling - Oreilly Activity |
|
|
Entity Relationship Diagrams (ERDs) with draw.io |
|
|
Chapter 10 ER Modelling |
|
|
ER Diagram: Entity Relationship Diagram Model | DBMS Example |
|
|
O'Reilly : Entity Relationship Modeling Examples |
|
|
Recursive Relationships |
|
|
Entity Relationship Modeling Database Examples Oreilly |
|
|
| Day 6 - Database Design |
Day 6 - Database Design |
|
|
6.1 - ERD review based on Day 5 |
|
|
6.2 - Data Design and ERD Component |
|
|
Lab 6 Data Design and ERD |
|
|
Lab 6.1 |
|
|
The Role of Database Management System in Information Systems |
|
|
Database Systems Development Life Cycle |
|
|
Centralized Database and Distributed Database |
|
|
How to Model Relational Database Design with ERD? |
|
|
| Day 7 - Business Intelligence and Data Warehouses |
Day 7 - Business Intelligence and Data Warehouses |
|
|
Lab 7 |
|
|
Lab 7.1 |
|
|
7 Key Benefits of Business Intelligence |
|
|
Data Analytics for Manufacturing: the Tesla’s Case Study |
|
|
Business Intelligence & Data Warehousing for Government |
|
|
Discover data analysis by Microsoft |
|
|
Much simplified lecture notes for Day 6 and 7 |
Complementary to formal lecture notes |
|
| Day 8 - Big Data and NoSQL |
Day 8 - Big Data and NoSQL |
|
|
Lab 8 |
|
|
Lab 8.1 Interactive Chart Analysis |
|
|
Revolutionizing Retail: Unleashing the Power of Predictive Analytics for Enhanced Customer Service |
|
|
How Analytics Make For A Smarter Retail Business |
|
|
Big Data and Social Media for Better Marketing |
|
|
Big Data, Big Impact: How Data Improves Your Social Media Marketing |
|
|
Exploring NoSQL Database Examples |
|
|
Describe the capabilities of Microsoft Power BI by Microsoft |
|
|
| Day 9 - Database Connectivity and Web Technologies |
Day 9 - Database Connectivity and Web Technologies |
|
|
Day 9 - Article Database Connectivity |
|
|
Lab 9 |
|
|
What is Cloud Migration? Strategy, Processes, Benefits & Risks |
|
|
How to Define Ethical Behavior & Why It’s Important in the Workplace |
|
|
| Day 10 - Revision, Database Administration and Security, Test 2 |
Day 10 - Database Administration and Security |
|
|
Lab 10 |
|
|
Day 10 - Article Database Administration and Security |
|
|
A Guide To Leadership and Conflict Management |
|
|
Article 1 - What is a database administrator (DBA) |
|
|
Article 2 - What is a database administrator? |
|
|
Article 3 - What is database security? |
|
|
| Day11 - Databases and MS Access |
Database and Ms Access |
|
|
Lab 11 |
|
|
Oracle definition of Database |
|
|
How MS Access differs from MS Excel? |
|
|
Benefits of using Microsoft Access |
|
|
| Day12 - Creating a Database, table, design |
Microsoft Access Basics |
|
|
Creating a Database |
|
|
Lab 12 |
|
|
 Exercise 1 - Xmas List Database (Template Answer) |
|
|
Exercise 2 - Shopping List Database (Template Answer) |
|
|
Exercise 3 - Movies Database (Template Answer) |
|
|
Create a database in Access |
|
|
Introduction to tables |
|
|
 Microsoft Access for Beginners: Creating a Database from Scratch |
|
|
Creating Tables - How To Create a New Table in Microsoft MS Design & Datasheet View |
|
|
| Day 13 - Creating Queries in Access |
Creating Queries in Access |
|
|
Lab 13 |
|
|
Exercise 1 - Films Database |
|
|
Exercise 1 - Films Database (Template Answer) |
|
|
Exercise 2 - Wealth |
|
|
Exercise 2 - Wealth Database (Template Answer) |
|
|
Exercise 3 - Films |
|
|
Exercise 3 - Films Database (Template Answer) |
|
|
MSAccess Tutorial 1 |
|
|
MSAccess Tutorial 2 |
|
|
MSAccess Tutorial 3 |
|
|
Create a simple select query |
|
|
Video Tutorial: Designing a Simple Query in MS Access |
|
|
Video Tutorial: Using Queries in an Access Database (Comprehensive) |
|
|
| Day 14 and 15 - Creating forms and reports in Access |
Creating and Modifying Forms |
|
|
Creating and Modifying Reports |
|
|
Lab 14 |
|
|
Pets Database |
|
|
Pets Database (Template Answer) |
|
|
Forms- Create a form in Access |
|
|
Reports- Create a simple report |
|
|
How to Insert a logo into a form or report |
|
|
Video Tutorial : Creating a form in Access simple steps |
|
|
Video Tutorial : Creating a report in Access simple steps |
|