report

AssessmentInformation

COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act’). The

material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of

copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty

Ltd ABN 86 098 181 947 is a registered higher education provider CRICOS Provider Code 02426B.

Assessment 3 Information

Subject Code: BUS105

Subject Name: Business Information systems

Assessment Title: Data Management Project: Winter Olympics 1992 - 2014

Weighting: 30% Total Marks: 30

Submission mode: Turnitin

Word Count: 600 words

Due Dates: Final report submitted via Turnitin on Monday of week 9, 15:55pm AEST. Software Required: Microsoft office and Excel. The assignment is to be completed in Word and converted to a PDF file (see assignment submission section for more details). The report should be written in 12-point font with 1.5 line spacing.

Business Scenario: You have been hired by a committee to perform data management of a subset of Winter Olympics data from 1992 to 2014. Project Data: Download file “Data_for_BUS105_Assessment3.xlsx” Original Source: https://data.world/rodyzakovich/winter-olympics-medals-by-year-country-event-and- gender

Your Instructions: Task 1: General Data management (150 words, 5 + 2 + 2 + 1 = 10 marks) A. Refer to Workshop 3. B. Write a simple data dictionary for this data file. Explain the benefit of data dictionaries and

documentation in your own words. [4 + 1 = 5 marks] C. Under the file menu, chose info and note the metadata (file size, date saved, author, etc.)

[2 marks] D. Write a few lines on the type of database this is, the type of query language you could use to search

the data and where you could store the data. [2 marks] E. Refer to workshop 4. What sort of analyst could you get to help you with the analysis of this data?

[1 mark] Task 2: Analysis & Interpretation (200 words, 2 + 2 + 2 = 6 marks)

A. Recall the work you did in week 7. B. Find the maximum and minimum age of all of the athletes listed in the database. [2 marks] C. Put a filter on the country of origin.

AssessmentInformation

COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act’). The

material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of

copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty

Ltd ABN 86 098 181 947 is a registered higher education provider CRICOS Provider Code 02426B.

D. Illustrate some of the events in which Canada won Gold medals by a. Filter out countries so you are left with Canada, b. Cut and paste the data to another spreadsheet, c. Then place a filter on Medal Rank and filter out the rankings so that you are left with 1s. d. Write an extensive paragraph on the sports involved, e.g. Ice hockey, etc., events and age

of the athletes involved. [2 marks] E. Repeat the exercise in Part D for Austria. [2 marks]

Task 3: Transforming Data (word limit not relevant, 4 marks)

A. Recall workshop 8 B. Consider the first three lines of the data set “Data_for_BUS105_Assessment3.xlsx” C. Rewrite the first three line in column-oriented format

Task 4: Unstructured data (100 words, 3 + 3 = 6 marks)

A. Describe the challenges and benefits of unstructured data. [3 marks] B. Suppose that you are required to collect unstructured data about the athletes. C. Provide three different examples of the data that would be collected. For example, an mp4 file of

the German slalom team chatting. [3 marks] Task 5: Generation and recommendations (150 words, 4 marks)

A. Provide practical recommendations regarding other structured data which could be collected, i.e. time sports event started and ended.

____________________________________________________________________________________

Rubric appears on next page

AssessmentInformation

COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act’). The

material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of

copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty

Ltd ABN 86 098 181 947 is a registered higher education provider CRICOS Provider Code 02426B.

Data Management Project

Criteria Requirement Marks Available

General data management & storage

Discuss data management and make a data dictionary, and discuss the benefit of data documentation and dictionaries

10 marks

150 words

Analysis & interpretation

Perform a basic analysis & Interpret the results

6 marks

200 words

Data transformation

Create columnar storage format

4 marks

Blocks of data (word limit not relevant)

Unstructured data

Illustrate the benefits and challenges of unstructured data and provide examples 6 marks

100 words

Generation and recommendations

Provide practical recommendations regarding other structured data that could be collected and analysed 4 marks

150 words

AssessmentInformation

COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act’). The

material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of

copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty

Ltd ABN 86 098 181 947 is a registered higher education provider CRICOS Provider Code 02426B.

Important Study Information Academic Integrity Policy KBS values academic integrity. All students must understand the meaning and consequences of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct Policy. For details on academic integrity policies and penalties, the reassessment process, and the appeals process, please refer to http://www.kbs.edu.au/current-students/student-policies/.

Word Limits for Written Assessments

Submissions that exceed the word count by more than 10% will cease to be marked from the point at which that limit is exceeded.

Study Assistance

Students may seek study assistance from their local Academic Success Centre representative or refer to the study help on the MyKBS Academic Success Centre page. You can find this by clicking on the top page toolbar: My Services>Academic Success Centre>Study Support Resources

COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969 This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act’). The material in this communication may be subject to copyright under the Act. Any further

reproduction or communication of this material by you may be the subject of copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty Ltd ABN 86 098

181 947 is a registered higher education provider CRICOS Provider Code 02426B.

Assessment Marking Rubric