Week 7: Lab Assignment InformationData Visualization

• Due Sunday by 5:30 pm Points 70 Submitting a file upload Available after Feb 14 at 11:59pm

Scenario

Your CEO is curious about how data visualization works. The CEO has a file of customer loans and he wants to be able to visualize the information. It is your task to discover the best way to visualize the data you have been given.

The following is the necessary information to complete this lab assignment.

Lab Components and Instructions

The deliverable for this lab is a Microsoft Excel file, including information from your reading in Lesson 7.1: Telling a Story With Data.

This lab will use the following Lab Resources.

• Access Microsoft Excel from the DeVry Desktop (course navigation on the left side).
• You can also use Microsoft Excel, if its installed on your personal computer.

Resources for this lab are located in the Lesson 7.1: Telling a Story With Data and the following Excel file to download. Please download and open this file:

Watch this video which goes into the lab steps.

• Click back to the Chart2 worksheet tab.
• Open the file provided in Step 1 via the download link. It may be beneficial to follow the professor’s live meeting (or recording available on Tuesday of the week).
• Click the plus (+) sign to add another worksheet and name it Visualization1.
• Save your file with your name included in the file name.
• Click back to the Chart1 tab.
• Create the three trend lines for the sales for each product.
• Format the Chart in a professional manner.
• Copy or move the chart to the Visualization1 worksheet tab.
• Below the chart, write two to three sentences in the same Visualization worksheet that explains what this data is saying. Please be specific about what the data in the chart is saying — do not simply comment on what a line chart tells you in general. Instead, indicate what the data is saying. Do not say “the data fluctuates” as most data fluctuates in business situations. Instead, look for broad patterns in the data, such as what the trend lines say about whether sales are increasing, flat, or declining for each of the three products in this chart.
• Save your Excel file.
• Move to Step 3.

• Click back to the Chart2 worksheet tab.
• Click the plus (+) sign to add another worksheet and name it Visualization2.
• Click back to the Chart2 worksheet tab.
• Create a pie chart. Format the chart to be professional looking. Include Percentages.
• Create a bar chart. Format the chart to be professional looking. Include the Values.
• Create a column chart. Format the chart to be professional looking. Include the Values.
• Copy or move the charts to the Visualization2 worksheet tab.
• Below the charts, write three to five sentences in the same Visualization worksheet that explains what this data is saying for each chart. Again, look for for broad patterns such as which region is the highest, and which is the lowest. Also, indicate whether you think a pie chart, or a bar-oriented chart is better for this particular data set, and why you think so.
• Save your Excel file.
• Move to Step 4.

• Click back to the Chart3 worksheet tab.
• Click the plus (+) sign to add another worksheet and name it Visualization3.
• Click back to the Chart3 worksheet tab.
• Create a column chart. Format the chart to be professional looking.
• Copy or move the chart to the Visualization3 worksheet tab.
• Below the chart, write two to three sentences in the same Visualization worksheet that explains what this data is saying for this type of chart. When given a lot of detail in a a clustered column chart like this, it’s best to focus on big-picture analysis. For example, in this case, you could mention which subject has the most A’s, and which subject has the most F’s.
• Save your Excel file.
• Move to Step 5.

• Click back to the Chart1 worksheet tab.
• Click the plus (+) sign to add another worksheet and name it Visualization4.
• Click back to the Chart1 worksheet tab.
• Add a column to include the average sales for each product line in dollars.
• Create a pie chart reflecting averages of each product line. Format the chart to be professional looking. Include percentages.
• Copy or move the chart to the Visualization4 worksheet tab.
• Below the chart, write two to three sentences in the same Visualization worksheet that explains what this data is saying for this type of chart.
• Save your Excel file.
• Move to Step 6.

Submit a Microsoft Excel file that includes lab Steps 2, 3, 4, and 5.

Action

Select the Start Assignment button to begin.

Once you have uploaded your files, select Submit Assignment.

Rubric

BIAM110 Week 7 Lab – SEP25

BIAM110 Week 7 Lab – SEP25

CriteriaRatingsPtsThis criterion is linked to a Learning Outcome

Visualization 1: Triple Line Chart

There is a triple line chart showing each product line chart and a trendline. There is a title to the chart and axis titles. The analysis focuses on broad conclusions rather than small patterns within the data.

15 pts

Full Marks

12 pts

Most elements are present

9 pts

Some elements are present

5 pts

Fewelements are present

0 pts

Chart and analysis is missing

15 pts

This criterion is linked to a Learning Outcome

Visualization 2: Pie, Bar, and Column Charts

There is a pie, bar, and column chart. There is a chart title and axis titles on each chart. The bar and column charts has the dollar value of each region on top of the bars. Analysis focuses on the big picture drawing high level conclusions from the data.

30 pts

Full Marks

24 pts

Most elements are present

18 pts

Some elements are present

12 pts

A few elements are present.

6 pts

Very few elements are present

0 pts

The charts and the analysis are missing.

30 pts

This criterion is linked to a Learning Outcome

Visualization 3: Clustered Column Chart

There is a clustered column chart showing the grades clustered by subject. There is a suitable title for the chart and the axes. Analysis focuses on broad conclusions that can be drawn from the chart.

15 pts

Full Marks

12 pts

Most elements are present

9 pts

Some elements are present

5 pts

Few elements are present

0 pts

The chart and analysis are not present.

15 pts

This criterion is linked to a Learning Outcome

Visualization 4: Average Sales by Product Pie Chart

There is a pie chart with an appropriate title. The legend to the pie chart contains the technology, furniture, and office supplies elements. The analysis provides a big picture, broad conclusion that can be drawn from the pie chart.

10 pts

Full Marks

8 pts

Most elements are present

6 pts

Some elements are present

4 pts

Few elements are present

0 pts

The chart and analysis are missing

10 pts

Total Points: 70