BUSA90520 2020 SM1 Subject Guide PDF

Preview

Summary

Subject guide for those who may be interested in taking the subject....

Description

BUSA90520 Data Wrangling & Visualization SUBJECT GUIDE Semester 1, 2020

Prepared by Derick Lyle [email protected]

Department of Accounting Faculty of Business and Economics

Subject Outline Introduction Welcome to BUSA90520, Data Wrangling and Visualization. This subject introduces the essential skills to manage business data to enable the application of analytics and evidence-based decision-making in business. It entails the study of the principles and tools for business data management and communication. The focus of the subject is enabling business decision-making and includes consideration of effective presentation and reporting of business data.

Subject Overview and Aims The overall aim of this subject is to enable students to: • • • • • • •

• •

Explain what evidence-based decision-making entails, and the role that information plays in supporting this. Understand how information (data) is typically stored in most organizations. Be able to extract, transform and aggregate information from storage systems for analysis and reporting purposes. Assess the quality of information and its fitness to inform a decision. Be able to construct a variety of visual representations of data to assist in understanding information and informing decisions. Use data visualizations to present an analysis and make recommendations, both oral (live presentation) and written (prepared and distributed reports). Explain the importance of business communication standards and community best practices, and be able to critically analyse data visualizations, presentations and reports for their compliance with standards and overall effectiveness. Explain the role of scripting languages such as Python in the automation, standardization and audit of organization reporting. Be able to write simple Python scripts to automate common tasks in data aggregation, transformation and report generation.

Learning Outcomes Learning Outcomes and Generic Skills To view the subject objectives and the generic skills you will develop through successful completion of this subject, please see the University Handbook: https://handbook.unimelb.edu.au/2020/subjects/busa90520

2

Eligibility and Requirements To view the eligibility and requirements, including prerequisites, corequisites, recommended background knowledge and core participation requirements for this subject, please see the University Handbook: https://handbook.unimelb.edu.au/2020/subjects/busa90520/eligibility-and-requirements

Academic Staff Contact Details Please see the subject LMS site for full contact details of the teaching staff in this subject.

Subject Coordinator Contact Details Derick Lyle e-Mail: [email protected] Phone: 03 8344 8563 Office: Spot Lvl 7, 7.049 (to the right as you come out the elevator, use the intercom system) Zoom: 423-254-1494 (https://unimelb.zoom.us/j/4232541494) Consultation hours by appointment, please use the Canvas calendar to check for available times and make a reservation, and indicate whether you intend to meet in my office or virtually via Zoom.

Email Protocol Please note that we are only able to respond to student communications coming from a University email address, or via the Canvas LMS. Please do not use personal email addresses such as Yahoo, Hotmail or even business email addresses. Emails from non-University email addresses may be filtered by the University’s spam filter, which means that we may not receive your email. All correspondence relating to this subject will only be sent to your University email address. Note that you must first activate your University email address before you can send or receive emails at that address. You can activate your email account at this link: http://accounts.unimelb.edu.au/. While academic staff endeavour to address queries received via email, it is more appropriate to resolve substantive questions during seminars and normal consultation hours. With this in mind, we encourage students to attend all seminars and to familiarise themselves with the consultation hours offered by the lecturers and tutors in this subject.

3

Seminars Slides and other relevant course materials will generally be available in the LMS subject prior to the first scheduled seminar each week. Additional materials, such as in-class exercises and solutions, may be made available in the LMS after the last scheduled seminar each week. To prepare for each week, you will be required to complete exercises, watch videos or read instructional tutorials from a variety of online resources. Please refer to the LMS for specific details for each week. In general, I will aim to make the bulk of updates to the LMS on Fridays.

Seminar Times https://sws.unimelb.edu.au/2020/Reports/List.aspx?objects=BUSA90520&weeks=1022&days=1-7&periods=1-56&template=module_by_group_list Wednesday

17h30 to 20h30

PAR-The Spot-6015

Thursday

15h15 to 18h15

PAR-The Spot-5013

These sessions are repeats and interchangeable. An enrolment cap was put in place to balance student numbers to improve the quality of teaching. The rooms are large enough to accommodate more, however. You may attend either session (or both) each week, as suits your schedule. However, if the number of students becomes too uneven and the quality of teaching declines, I reserve the right to enforce attendance based on official enrolments.

Participation Requirements You are encouraged to attend all seminars in person. This is a highly practical subject, and most of the time will be spent hands on with technology, working through exercises. You stand to benefit a lot from interaction with your other students and having someone to look over your shoulder to troubleshoot the error on your screen. You should bring your own portable computer (full Windows or Mac operating system required – Android/iOS tablets/phones are insufficient) each week or use one of the university computers provided. Please note that there are only a few computers provided in the room; there is not enough available for all students. Priority will be given on a first-comefirst-served basis.

4

Schedule NOTE: This schedule is indicative only and may evolve as the semester unfolds. Week

Topic 1 Introduction 2 Introduction to databases and SQL 3 Relational databases and models (Entity-Relationship Diagrams) 4 Intermediate SQL 5 Principles of data visualization (with Tableau™) 6 Designing and testing interactive dashboards (with Tableau™) Introduction to python BREAK 7 Scraping web data and saving it to a database (with Python) 8 Data transformation and augmentation (Tableau and Python) 9 Short- and long-term strategies to dealing with poor quality data

10 Data narratives (tell stories with data) 11 Improving communication effectiveness - reporting standards 12 “Big Data”, recent and emerging trends and technologies

Using Lecture Capture Audio and video recordings of lectures delivered in this subject will be made available for review following each seminar. These recordings allow you to revise lectures during the semester, or to review them in preparation for the end of semester exam. You can access recorded lectures by clicking on the Lecture Recordings (or similar) menu item on the LMS page for this subject. Please note that recordings are not a substitute for attendance, and you should attend class if you are able to; primarily they are designed for revision and for those with unusual circumstances preventing them from attending. In such cases, the recording will not be made available. In lecture theatres with multiple screens only one screen will be captured, any information projected onto the other screen will not be recorded. The University has recently moved to a new Lecture Capture platform with additional features. Please review the Lecture Capture Student Guides page for more information: https://lms.unimelb.edu.au/support/guides/students/lecture-capture-student-guide

5

Private Tutoring Services The Faculty has become increasingly concerned about the existence of a number of private tutoring services operating in Melbourne that heavily target University of Melbourne students enrolled in FBE subjects. Students are urged to show caution and exercise their judgement if they are considering using any of these services, and to please take note of the following: Any claim by any of these businesses that they have a “special” or “collaborative” or “partnership” style relationship with the University or Faculty is false and misleading. Any claim by a private tutoring service that they are in possession of, or can supply you with, forthcoming University exam or assignment questions or “insider” or “exclusive” information is also false and misleading. The University has no relationship whatsoever with any of these services and takes these claims very seriously as they threaten to damage the University’s reputation and undermine its independence. It is also not appropriate for students to provide course materials (including University curricula, reading materials, exam and assignment questions and answers) to operators of these businesses for the purposes of allowing them to conduct commercial tutoring activities. Doing so may amount to misconduct and will be taken seriously. Those materials contain intellectual property owned or controlled by the University. We encourage you to bring to the attention of Faculty staff any behaviour or activity that is not aligned with University expectations or policy as outlined above.

6

Assessment Assessment Overview There is a significant amount of group work with a high weighting towards your final mark. These projects must be completed in teams of 3 to 4 students (preferable 4). The projectbased nature of the assignments does not facilitate simple division of work with last minute copy/paste prior to submission. Allow more time for working together and assembly of final project pieces. On the other hand, projects can be notoriously time consuming as you troubleshoot errors and work your way towards a fully working solution. Use all the people on the team to support each other and tackle particularly troublesome parts separately or in pairs, rather than consuming the whole group’s time. I will be making myself available for several hours each week to guide and advise you. Take advantage of this. The projects are designed with this expectation in mind. Seek clarification and assurance early – there is only so much I can do to help at the last minute. Your assessment for this subject comprises the following: Assessment Task

Individual or Group

Due

Project 1 Project 2 Project 3 Take home examination (3 hrs) HURDLE REQUIREMENT:

Group (3-4) Group (3-4) Group (3-4) Individual

6 April 9h00 4 May 9h00 25 May 9h00 During exam period

Weighting 20% 20% 20% 40%

You must pass the exam to pass the subject.

Late submissions will not be accepted.

Assessment Details and Submission Please refer to the LMS for the details, requirements and submission instructions for each of the assessments. Assignment submission is via the Canvas LMS Assignment link found on the ‘Subject Navigation Menu’ on the left-hand side of your canvas page. Select the assignment you are submitting from there. Please refer to LMS student support for help with Canvas. Please note that you are required to keep a copy of your assignment after it has been submitted as you must be able to produce a copy of your assignment at the request of teaching staff at any time after the submission due date.

Penalties for Late Submission Late submissions will not be accepted. Students with a genuine and acceptable reason for not completing an assignment (or other assessment task), such as illness, can apply for special consideration (see policy below). 7

Subject Resources Prescribed References http://datacamp.com http://data.world.com https://www.tableau.com/academic/students https://www.tableau.com/learn/training

Supplementary Readings & References http://www.w3schools.com With more to be posted to the LMS as the course unfolds…

Academic Integrity Academic Honesty The University maintains high academic standards in its courses and subjects and expects students to conduct themselves in a manner which is fair, honest and consistent with the principles of academic integrity, particularly when undertaking assessment and research. http://academicintegrity.unimelb.edu.au/

Referencing All sources used for a written piece of assessment must be referenced. This is to acknowledge that your material is not based entirely on your own ideas, but is based, in part, on the ideas, information, and evidence of others. This is desirable as you are attending University in order to learn from others. You will be required to use the APA system or Harvard System of referencing. The library has prepared a website to help students correctly reference: http://www.lib.unimelb.edu.au/recite/citations/harvard/generalNotes.html It is important that all material you present for assessment is referenced correctly. Material that has not been referenced correctly may be considered to be plagiarised, and as such may be penalised. We will also look for evidence that material included in the bibliography has been used in the assignment. Including references that have not been used may also result in your assignment being penalised The Academic Skills Unit has produced resources to assist students with referencing https://services.unimelb.edu.au/academicskills/undergrads/top_resources The Library also provides advice on referencing: http://library.unimelb.edu.au/cite

8

University Services Timetable MyTimetable is a class timetabling system that creates individual timetables for students based on submitted class preferences, ensuring everyone has an equitable opportunity of getting their preferred class timetable. You will use this system to create your class timetable prior to each study period. By following a preference-based model, students who have other commitments, such as employment or carer responsibilities, or who are returning or living overseas during the timetabling period, aren’t disadvantaged by their limited availability. When allocating class timetables, MyTimetable also takes into consideration factors such as class size limits and potential clashes to ensure all students are equally accommodated. Further information is available on the web at https://students.unimelb.edu.au/admin/class-timetable

Stop 1: Connecting Students and Services Stop 1 is here to provide you with a range of support services throughout your university degree, from help with enrolment, administration and wellbeing to advice on building your skills and experiences. https://students.unimelb.edu.au/stop1

Academic Skills Academic Skills offers a range of workshops and resources to help you with study skills including researching, writing and referencing, presentation skills and preparing for exams. Visit their website via http://services.unimelb.edu.au/academicskills.

Service Finder The University of Melbourne offers one of the most comprehensive student support networks in Australia. Use this site to locate a wide range of services http://services.unimelb.edu.au/finder

Student Counselling Students attend counselling to talk about personal, emotional, or mental health issues which might be affecting their study and life. The University’s Counselling and Psychological Services (CAPS) provides free, confidential, short-term professional counselling to currently enrolled students and staff. https://services.unimelb.edu.au/counsel/individual

Student Equity and Disability Support Student Equity and Disability Support provides services for students who need ongoing support with their studies. They understand that adjustments to learning and assessment are sometimes required to allow all students to reach their full potential. Learn more about the services provided, how to find support and how to register for assistance. http://services.unimelb.edu.au/student-equity

9

University of Melbourne Library Services As well as holding an extensive collection of books, ebooks, digital media and periodicals, library staff provide research guidance and support for students. http://library.unimelb.edu.au/ These Business and Economics Library Guides have been designed specifically for Faculty of Business and Economics staff and students. http://unimelb.libguides.com/sb.php?subject_id=80310

Policy Alternative Exam Arrangements (AEA) The definition of and eligibility requirements for alternative exam arrangements (AEA) can be found via http://students.unimelb.edu.au/admin/alternate .

Assessment and Results Policy The University’s assessment policy provides a framework for the design, delivery and implementation of assessment of students in award and non-award courses and subjects. Assessment is designed to contribute to high quality learning by students, and to allow for quality assurance and the maintenance of high academic standards. https://policy.unimelb.edu.au/MPF1326

Assignment Extension Requests for an assignment extension should be submitted here: http://go.unimelb.edu.au/yh9n. Before completing this form, please read the Assignment Extension Policy, which can be found at: http://policy.unimelb.edu.au/MPF1326#section-4.37

Exam Policy The University requires that you are available for the entire examination period. Please see the University's Principal Dates via http://www.unimelb.edu.au/dates#2018 for the full annual calendar. Supplementary exams will not be provided in cases of absence during the examination period unless the absence is due to serious illness or other serious circumstances and a Special Consideration application is submitted and approved.

Information on Calculators in Examinations Effective from 1 January 2017, the approved calculator for all subjects is the Casio FX82 (any suffix). No equivalent models of calculators will be permitted in exams. You are required to purchase your own calculator and are responsible for ensuring your calculator is in good working order with fresh batteries.

10

Plagiarism and Collusion Plagiarism (failure to cite your sources correctly and completely) and collusion (unauthorised collaboration with another person to prepare an assessment task) are considered academic misconduct and attract severe penalties. More information is available on the University’s Academic Integrity website via http://go.unimelb.edu.au/rha6.

Special Consideration As a student, you may experience extraordinary or unusual circumstances, or ongoing circumstances that adversely affect your academic performance. The University has policies in place to support students who are experiencing academic disadvantage. For more information, visit http://students.unimelb.edu.au/admin/special.

11...