bus5dwr data wrangling and r
DATA WRANGLING AND R
BUS5DWR
2020
Credit points: 15
Subject outline
This subject introduces you to the various techniques of data wrangling with a strong focus on hands-on experience in R and Structured Query Language (SQL) programming. It will cover the basic concepts in relational database design including Entity Relationship (ER) modelling and SQL as a tool for basic data wrangling. You will also learn various types of data sources and common data formats. The subject teaches you R programming language for you to perform data wrangling tasks, including data import and export, basic data integration and data assessment. Upon completion, you will be able to perform a variety of data wrangling tasks using SQL and R for different kinds of data types.
SchoolLa Trobe Business School
Credit points15
Subject Co-ordinatorBinh Tran
Available to Study Abroad/Exchange StudentsNo
Subject year levelYear Level 5 - Masters
Available as ElectiveNo
Learning ActivitiesN/A
Capstone subjectNo
Subject particulars
Subject rules
Prerequisites Enrolled in LMBAN or LCBAN or LGBAN
Co-requisitesN/A
Incompatible subjectsN/A
Equivalent subjectsN/A
Quota Management StrategyMerit based quota management
Quota-conditions or rulesBy the order of application to subject coordinator.
Special conditionsN/A
Minimum credit point requirementN/A
Assumed knowledgeN/A
Learning resources
The Essentials of Data Science
Resource TypeBook
Resource RequirementRecommended
AuthorWilliams, G.
Year2017
Edition/VolumeN/A
PublisherCRC Press
ISBNN/A
Chapter/article titleN/A
Chapter/issueN/A
URLN/A
Other descriptionN/A
Source locationN/A
Microsoft SQL Server 2016: A Beginner's Guide
Resource TypeBook
Resource RequirementRecommended
AuthorPetkovic, D.
Year2016
Edition/VolumeN/A
PublisherMcGraw-Hill Education
ISBNN/A
Chapter/article titleN/A
Chapter/issueN/A
URLN/A
Other descriptionN/A
Source locationN/A
Data Wrangling with R (Use R!)
Resource TypeBook
Resource RequirementRecommended
AuthorBoehmke, B.
Year2016
Edition/VolumeN/A
PublisherSpringer International Publishing
ISBNN/A
Chapter/article titleN/A
Chapter/issueN/A
URLN/A
Other descriptionN/A
Source locationN/A
Career Ready
Career-focusedNo
Work-based learningNo
Self sourced or Uni sourcedN/A
Entire subject or partial subjectN/A
Total hours/days requiredN/A
Location of WBL activity (region)N/A
WBL addtional requirementsN/A
Graduate capabilities & intended learning outcomes
Graduate Capabilities
Intended Learning Outcomes
Subject options
Select to view your study options…
City Campus, 2020, Semester 1, Night
Overview
Online enrolmentYes
Maximum enrolment size120
Subject Instance Co-ordinatorBinh Tran
Class requirements
Lecture/WorkshopWeek: 10 - 22
One 3.00 hours lecture/workshop per week on weekdays at night from week 10 to week 22 and delivered via face-to-face.
Assessments
| Assessment element | Category | Contribution | Hurdle | % | ILO* |
|---|---|---|---|---|---|
| Individual Assignment (2000 words), SQL design Demonstrate knowledge in database design and proficiency in data wrangling using SQL. | N/A | N/A | No | 40 | SILO1 |
| Individual Assignment (1000 words), Report on recent data wrangling topic Demonstrate knowledge on various data sources, data format and motivation for data wrangling and its implications to business analytics. | N/A | N/A | No | 20 | SILO2 |
| Individual Assignment (2000 words), R and SQL coding Demonstrate proficiency in data wrangling using R and SQL. | N/A | N/A | No | 40 | SILO3, SILO4 |
City Campus, 2020, Semester 2, Night
Overview
Online enrolmentYes
Maximum enrolment size120
Subject Instance Co-ordinatorBinh Tran
Class requirements
Lecture/WorkshopWeek: 31 - 43
One 3.00 hours lecture/workshop per week on weekdays at night from week 31 to week 43 and delivered via face-to-face.
Assessments
| Assessment element | Category | Contribution | Hurdle | % | ILO* |
|---|---|---|---|---|---|
| Individual Assignment (2000 words), SQL design Demonstrate knowledge in database design and proficiency in data wrangling using SQL. | N/A | N/A | No | 40 | SILO1 |
| Individual Assignment (1000 words), Report on recent data wrangling topic Demonstrate knowledge on various data sources, data format and motivation for data wrangling and its implications to business analytics. | N/A | N/A | No | 20 | SILO2 |
| Individual Assignment (2000 words), R and SQL coding Demonstrate proficiency in data wrangling using R and SQL. | N/A | N/A | No | 40 | SILO3, SILO4 |