BIS155 Lab 3 Devry Condos at Summit Ridge Mountain data analysis

This criterion is linked to a Learning OutcomeSTEP 1a: Calculate % of asking price on Condo Sales Wkst

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 1b, c: Format Condo Sales worksheet (column width, headings, colors, data types)

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: VLOOKUP for Interest Rate

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: VLOOKUP for Down Payment

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: Calculate Amount Financed

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: PMT function for Monthly Payment

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 2a: Loan Data Worksheet: COUNT, MIN, MAX & SUM to complete loan statistics

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 2b, c, d: Format data types (percents, currency, etc.)

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 2b, c, d: Format page headings with font, color, size

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 2b, c, d: Format Loan Term Data and statistics with borders, color, etc. to separate it from the rest of the worksheet

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 3: a,b: Create Sorted Data worksheet

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 3c: Sort data by selling agent and then asking price

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 3d, e: Create a summary report using subtotals and outline levels

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 3d, e: Create a column chart to compare asking price vs selling price by agent

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 4a: Create new worksheet with Sales Data and name Filtered Data

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 4b: Convert filtered data into table

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 4d,e: Filter data to show only sales by Langston in Pagosa

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 5a,b: Create Conditional Format worksheet and Insert a table

2.0 pts

This criterion is linked to a Learning OutcomeSTEP 5c: Set up conditional formatting rules for the % of Asking Price column

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 5d: Sort data smallest to largest

2.0 pts

This criterion is linked to a Learning OutcomeSTEP6a: Pivot Table: Select Data and Name Range of Cells (A3 through J33)

3.0 pts

This criterion is linked to a Learning OutcomeSTEP6b: Pivot Table: Insert Pivot table using Named Range

3.0 pts

This criterion is linked to a Learning OutcomeSTEP6c: Pivot Table: Create the Pivot Table with selling agent (row), City (column), and Percent asking price as values

3.0 pts

This criterion is linked to a Learning OutcomeSTEP6d: Pivot Table: Change values to AVERAGE and apply formatting to cells and all labels

4.0 pts

This criterion is linked to a Learning OutcomeSTEP6e: Pivot Table: Apply data bars, hide field headers, rename and move sheet

3.0 pts

This criterion is linked to a Learning OutcomeSTEP 7: Documentation sheet completed

4.0 pts

This criterion is linked to a Learning OutcomeSTEP 7: Is the slogan a true statement?

4.0 pts

This criterion is linked to a Learning OutcomeCOMMENT: What you learned from completing this Lab

5.0 pts