# BIS155 Lab 3 Devry Condos at Summit Ridge Mountain data analysis

Complete Lab 3: Summit Ridge Mountain Resort: Luxury Condo Sales. Basic instructions are in the Lab Overview page. You will be required to use your skills from the text and tutorials to complete the lab. Be sure to watch and work through the hands-on exercise videos in the lesson for guidance on completing this assignment.

COURSE: BIS155 Lab 3

Criteria Ratings Pts

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

 3.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

3.0 pts

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

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

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

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

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

 4.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

3.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

2.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

2.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

2.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

2.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

4.0 pts

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

 2.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

3.0 pts

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

 3.0 pts Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

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 Full Marks 0.0 pts No Marks

3.0 pts

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

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

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

 4.0 pts Full Marks 0.0 pts No Marks

4.0 pts

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

 5.0 pts Full Marks 0.0 pts No Marks

5.0 pts