Nguyen Phuong Thanh Week 2-1-1 PDF

Preview

Summary

Week 2 practical ...

Description

INF10003 Active Learning Worksheet – Week 1 Name: Nguyen Phuong Thanh

Stu Id: 103567935

---------------------------------------------------------------------------------------------------------------------------

Converting Raw Data to Information (Excel Basics) Data is not useful until it becomes information. Turning raw numbers into a visual representation can help us understand meaning and connections much more quickly. The ability to use and analyse data supports the move towards evidence based decision making. The problem a lot of businesses (large and small) face is having too much data because we know that’s a good thing, yet very little of it enables effective decisions. Often, the data isn’t going to help you. Either it’s not the right kind of data or it isn’t compiled and analyzed properly. In other words, it isn’t Information — it’s just data. You need information for decision making. The data itself is usually not very helpful as is. Swinny’s Car Sales. 1. View the following randomised data set (car sales for 1 week). While the information on its own has some value, the collective whole of the information would have much more value. (each row below is a unique data entry for 1 vehicle. i.e. a record) 2015

Falcon

$21,000

Petrol

Sedan

James B

Ford

Diesel

SUV

Captiva

Holden

2009

$11,000

Shaun H

James B

$35,980

SUV

Diesel

2016

Mazda

CX9

$19,500

Bob C

Diesel

Ford

2012

Territory

SUV

Commodor e HyBrid

Sedan

Holden

2016

Petrol

Shaun H

$29,000

Camry

2013

James B

Sedan

$27,800

Toyota

Every record contains individual data points that make up the sum of that record. The columns contain a range of data, but the data shown above is not specific it’s randomised. Challenge A: (Using Excel and Word) 

Open Excel and identify clear column names (Fields) that best describe the characteristic of each kind of data visible in each row. (see example 1.1)

INF10003 Active Learning Worksheet – Week 1

Example 1.1: 7 Columns, common attribute “Year” identified as a possible field name. *the order of the columns (fields), not important. 

Once the column field names have been identified (checked by tutor), copy and paste (or type in) the data into their appropriate cells. Make sure that the row integrity remains (i.e. don’t mix up the data from row 2 with row 3)

Based on the completed spreadsheet with appropriate Field names, provide an analysis of the data. Use the Excel Autosum, Custom Sort and Filter functions to achieve these results. 

Which salesperson sold the most amount of cars? _______James B_______



Total Sales for the week. $144,280____________________

INF10003 Active Learning Worksheet – Week 1



Most sold vehicle type. ___________SUV__________



Most popular vehicle fuel type sold. ___________Diesel___________

INF10003 Active Learning Worksheet – Week 1



What other trends or patterns can be extrapolated from this data? We can know clearly more about the companies, profit, sale person, class and year of the most sale is 2016 depends on excel and provided information.

Additional Resources: 

Autosum overview: https://support.office.com/en-us/article/Use-AutoSum-to-sumnumbers-543941e7-e783-44ef-8317-7d1bb85fe706



Custom Sort overview: https://support.office.com/en-us/article/Sort-data-using-a-customlist-def8ff2b-681a-4fc3-9bd2-a06455c379e1

Challenge B: Download the “Raw_data_tutorial 2018 S2.xlsx” Choose 1 only from the 3 available data sets (each are partly completed with some field names already identified) and complete the follow.  

Using the methods used in the previous exercise, re-organise the data into appropriate columns with clear field names. Using the same methods as used in the previous challenge, answer the questions at the bottom of each data set. 1. Q 1 Who are ACME Toy Supplies best customer by total sales

INF10003 Active Learning Worksheet – Week 1 Kmart

2. Q2 Who is ACME Toy Supplies best sales rep by quantities sold Helen?

INF10003 Active Learning Worksheet – Week 1

3. What is the overall profit from each sale. (may require additional columns to be added)

INF10003 Active Learning Worksheet – Week 1

4. . Based on the sales data, identify a pattern or trend Christmas is right time to improve the number of products. Especially, Nano Drone was trendy product in December....