please follow the rubric and instructions carefully
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.
Criteria | Ratings | Pts | ||
---|---|---|---|---|
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 |