Please follow the instructions carefully
Programming
Complete Lab 1: Summit Ridge Mountain Resort: Village Shops.
Be sure to review the tutorials at the end of this week’s lesson, in combination with the content of your assigned readings. These will provide you with the necessary tools to customize the Week 1 Summit Ridge Mountain Resort Student file located in the Lab Overview page.
Submit your lab Excel file. Be sure to follow the proper file naming conventions included in your Syllabus (i.e., Doe_J Week1 Lab.xlsx).
COURSE: BIS155 Lab 1
| Criteria | Ratings | Pts | ||
|---|---|---|---|---|
|
This criterion is linked to a Learning OutcomeSTEP 1a: Insert new worksheet |
|
2.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 1b: Rename worksheet tab (Documentation) |
|
2.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 1b: Move documentation sheet to first sheet in workbook |
|
2.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 1c: Enter identifying information: Name, Date, Purpose, Sheet documentation |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 1d: Format with appropriate title, borders, color, and column widths |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 2a: Use relative and absolute references appropriately |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeStep 2a: Calculate Net Selling Price for each item |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeStep 2a: Calculate the Total Sales for each item |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 2a: Calculate the Total Profit per item |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 2a: Calculate the Average Profit % for each item |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 2b: Calculate Total Profit to Date (B21) |
|
3.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 2c: Calculate the Remaining Profit Need to meet the Goal (B22) |
|
3.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 3a: Center the spreadsheet title rows across the selection A – R |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 3b: Apply text wrapping to column headings |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 3c: Change Font size and color of page heading |
|
3.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 3d: Change shading and borders |
|
3.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 3e: Format currency, percentages, and numbers appropriately |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 4a: Apply color to sheet tabs |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 4b: Hide columns D-M |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 4c: Create a custom header: Professor Names and Student Name |
|
5.0 pts |
||
|
This criterion is linked to a Learning OutcomeSTEP 4d: Change the page orientation to landscape |
|
4.0 pts |
||
|
This criterion is linked to a Learning OutcomeCOMMENT: Provide a comment about what you learned from completing this lab. |
|
5.0 pts |
||
|
Total Points: 80.0 |
||||
