-- School of Information Technology --
Fundamentals of Data Science
|
-
Welcome to the Fundamentals of Data Science Course!
We hope you enjoy your learning journey!
IT5507 - Fundamentals of Data Science - 2025 - XKU
Course: IT5507 - Fundamentals of Data Science - 2025 - XKU | Whitireia&WelTec Moodle
-
-
Open all
Close all
-
Instructions: Clicking on the section name will show / hide the section.
-
Course Outline and Assessments Information
-
Assessment Notes
- Question flag - you can flag a question. This puts a red mark on a question that you might want to return to later.
- This test is marked out of 100 and it is worth 40% of the total course mark.
- At the end of the test, press FINISH ATTEMPT. You can select an option to return to the test and revise your answers OR
- To finish the test, select SUBMIT ALL AND FINISH.
- If you are still working on the test when the timer stops, your attempt will be automatically saved.
-
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.
-
Week 1
-
Day 1 - Introduction to Data Science, Information Systems (IS) Concepts
In our very first session, we delve into embarking on a comprehensive exploration of Information Systems (IS) Concepts, uncovering the fundamental principles that underpin the dynamic integration of technology, data, and decision-making processes in today's digital landscape.
-
Day 2 - Database Systems
In this session, we explore Database Systems, where we navigate the essentials of information management, exploring data distinctions, database evolution, design intricacies, and the crucial role of Database Management Systems (DBMS) in shaping effective decision-making and information organization.
-
Day 3 - Data Models
This topic on data models can be introduced next to emphasize the significance of comprehending and adjusting to various data representation techniques in the IT industry. In this field, working with diverse data models is crucial, as it involves understanding and implementing various structures to effectively manage and utilize information within different systems.
-
Day 4 - Relational Database Model
We dive into the heart of data organization with the Relational Database Model, where we unravel the principles governing the structured storage, retrieval, and relationships within databases, providing a foundation for effective information management.
-
Day 5 - Revision, ER (Entity-Relationship) Modelling and Test 1
In this session, we delve into the essentials of Revision, ER (Entity-Relationship) Modeling, and Test 1, examining the key concepts and methodologies crucial for reinforcing knowledge and assessing proficiency in database systems.
-
Week 2
-
Day 6 - Database Design
In this session, we will explore the fundamentals of database design, focusing on essential concepts and methodologies.
-
Day 7 - Business Intelligence and Data Warehouses
We'll explore Business Intelligence (BI) and Data Warehouses, pivotal in modern data-driven operations. We'll understand how BI extracts insights and how Data Warehouses store and analyze data for informed decision-making and business success.
-
Day 8 - Big Data and NoSQL
In this session, we'll delve into the realm of Big Data and NoSQL databases. We'll examine how organizations handle large volumes of diverse data and explore the role of NoSQL databases in managing unstructured data efficiently.
-
Day 9 - Database Connectivity and Web Technologiess
We'll explore the intersection of database connectivity and web technologies. We'll examine how databases interact with web applications, covering topics such as database integration, web APIs, and the use of server-side scripting languages to access and manipulate database data on the web.
-
Day 10 - Revision, Database Administration and Security, Test 2
At the end of week 2, we will review key concepts in database administration and security, focusing on ensuring data integrity, managing user access, and protecting against security threats. Finally, we will then assess your understanding of covered topics through Test 2 for the week.
-
Week 3
-
Day11 - Databases and MS Access
Today, we are going to explore and recall what is the notion of the database with the real-world examples getting our hands on MS Access.
-
Day12 - Creating a Database, table, design
We explore how can we creat a simple database with collection of tables in it that is easy to follow for the database administrator and designer.
-
Day 13 - Creating Queries in Access
Once we created our database and tables in our database, now it's time to retrieve the data and information using Queries in MS Access!
-
Day 14 and 15 - Creating forms and reports in Access
We are going to explore how we can creat forms and reports in MS Access
-
Day15 - Revision of the week and project, Final Test
We review the key takeaways from the later sessions and you will attempt the Final Test today along with the project by the end of this week to assess your overall understanding of the topics we have covered.