BUSAN 201 : Data Management

Business and Economics

2024 Semester One (1243) (15 POINTS)

Course Prescription

Rapid advancements in computing power and data storage capacity has changed how digital data is created, stored, consumed, and managed. As a result, business data exists in many formats and representations. Students will be equipped with contemporary data management tools and exploratory techniques to realise the value of data as a business asset.

Course Overview

This course aims to expose you to knowledge, tools, and methods necessary to effectively manage data in today’s digital world by allowing you to work with real data in various formats, use industry-relevant software, practise and develop problem-solving techniques, and develop an appreciation of data as a valuable asset for any business in any industry.

Course Requirements

Prerequisite: 15 points from COMPSCI 101, 107, 130, INFOMGMT 192, INFOSYS 110 Restriction: INFOMGMT 292

Capabilities Developed in this Course

Capability 1: People and Place
Capability 3: Knowledge and Practice
Capability 4: Critical Thinking
Capability 5: Solution Seeking
Capability 6: Communication
Capability 8: Ethics and Professionalism
Graduate Profile: Bachelor of Commerce

Learning Outcomes

By the end of this course, students will be able to:
  1. Recognise, comprehend, and manage structured and unstructured data in various formats (Capability 3.1, 3.2, 4.1 and 5.1)
  2. Assess the changes and challenges of data ethics in society (Capability 1.1, 4.2, 8.1 and 8.2)
  3. Model structured data to be stored in relational databases (Capability 3.1, 3.2, 4.1, 5.1 and 6.2)
  4. Write basic Structured Query Language (SQL) queries to create, retrieve, and manipulate data stored in relational databases (Capability 3.1, 3.2, 4.1 and 5.1)
  5. Use Python to plan, design, and execute simple Extract-Transform-Load (ETL) data flows (Capability 3.1, 3.2, 4.1 and 5.1)

Assessments

Assessment Type Percentage Classification
Digital data and files assignment 10% Individual Coursework
Design assignment 15% Group Coursework
SQL assignment 10% Individual Coursework
Digital data and files test 20% Individual Test
SQL test 25% Individual Test
Design and ETL test 20% Individual Test
Assessment Type Learning Outcome Addressed
1 2 3 4 5
Digital data and files assignment
Design assignment
SQL assignment
Digital data and files test
SQL test
Design and ETL test
Pass requirements
To earn a passing grade in this course, you must:
• Attempt all tests; and
• Pass the tests, i.e. your combined score is at least 32.5 out of 65; and
• Pass the course overall, i.e. your combined score across all assessments is at least 50 out of 100.

Workload Expectations

The learning and teaching philosophy behind this course is that proficiency in practical skills reflects a sound understanding of the content. 
During a typical teaching week, there will be two 2-hour lectures and one 1-hour lab. For the 12 teaching weeks, this totals to 60 hours. Since the course as a whole represents approximately 150 hours of study, that leaves a total of 90 hours across the entire semester for independent study, e.g. reading, revising, and practising course material; completing assignments; and preparing for assessments, etc.

Delivery Mode

Campus Experience

Attendance is expected at scheduled activities including lectures and labs to complete components of the course.

Lectures will be available as recordings.

Test details will be available on Canvas.

The activities for the course are scheduled as a standard weekly timetable.

Learning Resources

Course materials are made available in a learning and collaboration tool called Canvas which also includes reading lists and lecture recordings (where available).

Please remember that the recording of any class on a personal device requires the permission of the instructor.

Student Feedback

At the end of every semester students will be invited to give feedback on the course and teaching through a tool called SET or Qualtrics. The lecturers and course co-ordinators will consider all feedback and respond with summaries and actions.

Your feedback helps teachers to improve the course and its delivery for future students.

Class Representatives in each class can take feedback to the department and faculty staff-student consultative committees.

Feedback from class reps is used to make any needed mid-course corrections. In addition, the course team welcomes informal feedback on the course at any time.

Academic Integrity

The University of Auckland will not tolerate cheating, or assisting others to cheat, and views cheating in coursework as a serious academic offence. The work that a student submits for grading must be the student's own work, reflecting their learning. Where work from other sources is used, it must be properly acknowledged and referenced. This requirement also applies to sources on the internet. A student's assessed work may be reviewed for potential plagiarism or other forms of academic misconduct, using computerised detection mechanisms.

Class Representatives

Class representatives are students tasked with representing student issues to departments, faculties, and the wider university. If you have a complaint about this course, please contact your class rep who will know how to raise it in the right channels. See your departmental noticeboard for contact details for your class reps.

Inclusive Learning

All students are asked to discuss any impairment related requirements privately, face to face and/or in written form with the course coordinator, lecturer or tutor.

Student Disability Services also provides support for students with a wide range of impairments, both visible and invisible, to succeed and excel at the University. For more information and contact details, please visit the Student Disability Services’ website http://disability.auckland.ac.nz

Special Circumstances

If your ability to complete assessed coursework is affected by illness or other personal circumstances outside of your control, contact a member of teaching staff as soon as possible before the assessment is due.

If your personal circumstances significantly affect your performance, or preparation, for an exam or eligible written test, refer to the University’s aegrotat or compassionate consideration page https://www.auckland.ac.nz/en/students/academic-information/exams-and-final-results/during-exams/aegrotat-and-compassionate-consideration.html.

This should be done as soon as possible and no later than seven days after the affected test or exam date.

Learning Continuity

In the event of an unexpected disruption, we undertake to maintain the continuity and standard of teaching and learning in all your courses throughout the year. If there are unexpected disruptions the University has contingency plans to ensure that access to your course continues and course assessment continues to meet the principles of the University’s assessment policy. Some adjustments may need to be made in emergencies. You will be kept fully informed by your course co-ordinator/director, and if disruption occurs you should refer to the university website for information about how to proceed.

Student Charter and Responsibilities

The Student Charter assumes and acknowledges that students are active participants in the learning process and that they have responsibilities to the institution and the international community of scholars. The University expects that students will act at all times in a way that demonstrates respect for the rights of other students and staff so that the learning environment is both safe and productive. For further information visit Student Charter https://www.auckland.ac.nz/en/students/forms-policies-and-guidelines/student-policies-and-guidelines/student-charter.html.

Disclaimer

Elements of this outline may be subject to change. The latest information about the course will be available for enrolled students in Canvas.

In this course students may be asked to submit coursework assessments digitally. The University reserves the right to conduct scheduled tests and examinations for this course online or through the use of computers or other electronic devices. Where tests or examinations are conducted online remote invigilation arrangements may be used. In exceptional circumstances changes to elements of this course may be necessary at short notice. Students enrolled in this course will be informed of any such changes and the reasons for them, as soon as possible, through Canvas.

Published on 16/11/2023 04:30 p.m.