BUSAN 201 : Data Management
Business and Economics
2021 Semester Two (1215) (15 POINTS)
Course Prescription
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
Capabilities Developed in this Course
| Capability 1: | Disciplinary Knowledge and Practice |
| Capability 2: | Critical Thinking |
| Capability 3: | Solution Seeking |
| Capability 4: | Communication and Engagement |
Learning Outcomes
- Recognise, comprehend, and managed structured data in various formats such as XML, DSV, and JSON. (Capability 1)
- Recognise and work with common formats used to store and manage unstructured data. (Capability 1)
- Model structured data to be stored in relational databases. (Capability 2, 3 and 4.2)
- Write basic Structured Query Language (SQL) queries to create, retrieve, and manipulate data stored in relational databases. (Capability 1 and 3)
- Plan, design, and execute simple Extract-Transform-Load (ETL) data flows. (Capability 1 and 3)
Assessments
| Assessment Type | Percentage | Classification |
|---|---|---|
| Assignments | 35% | Individual Coursework |
| Test | 65% | Individual Test |
| 2 types | 100% |
| Assessment Type | Learning Outcome Addressed | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||||||
| Assignments | ||||||||||
| Test | ||||||||||
Workload Expectations
The learning and teaching philosophy behind this course is that proficiency in practical skills reflects sound understanding of the content.
You are expected to participate in two 2-hour classes each week. Classes are structured so that you are guided through practical exercises to develop data management skills.
The class content is then reinforced by self-study exercises, assignments, and practical tests.
In addition to the weekly classes, you are expected to spend approximately another six hours per week on activities related to this course. These activities include: reading, revising, and practising course material; completing assignments; and preparing for assessments
Delivery Mode
Campus Experience
Attendance is expected at scheduled activities including labs.
Lectures will be available as recordings.
Attendance on campus is required/for the tests.
The activities for the course are scheduled as a standard weekly timetable.
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.
Digital 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.
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 against online source material using computerised detection mechanisms.
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 your assessment is fair, and not compromised. Some adjustments may need to be made in emergencies. You will be kept fully informed by your course co-ordinator, 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 you may be asked to submit your 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. The final decision on the completion mode for a test or examination, and remote invigilation arrangements where applicable, will be advised to students at least 10 days prior to the scheduled date of the assessment, or in the case of an examination when the examination timetable is published.