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
Economic Debate- Progressive Income Tax For this Economic Debate, we are going to discuss the…
TOPIC: Going Global Discussion Thread 1 (initial post due Wednesday for full credit) Please note:…
Assignment Topic This week will culminate in the creation of a narrated PowerPoint to create…
The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted…
you need to post your 2-page information flier to share with your Final Project Group.…
discussion: Discuss the methods used at your company to measure and ensure quality products and…