To Do:
- Visual Benchmark 1, 2
- Performance Assessment 1 (The file RSRHelpDesk.xlsx is in the folder EL2U1)
CMR 282 Module 5 textbook assignments
Submit the following files:
(1) 2-BillableHrsOct4to8.xlsx
(2) 2-WPMCCardioCosts.xlsx
(3) U1-RSRHelpDesk.xlsx
(4) Add a chart to one of the worksheet
Pick one of the homework assignments and add a chart to it. Be sure that the chart fits the kind of data being reported. Be sure your chart is complete with a title, a legend, and axis labels.
required excel files are attached in zip folder
Module 5, Chapter 2
| Module 5, Chapter 2 | ||||
| Criteria | Ratings | Pts | ||
| This criterion is linked to a Learning OutcomeVB1: Range names created |
|
2.0 pts | ||
| This criterion is linked to a Learning OutcomeVB1: VLOOKUP correct |
|
2.0 pts | ||
| This criterion is linked to a Learning OutcomeVB1: Total and Average fees correct |
|
2.0 pts | ||
| This criterion is linked to a Learning OutcomeVB2: Surgery fee formula |
|
3.0 pts | ||
| This criterion is linked to a Learning OutcomeVB2: Total cost formulas |
|
2.0 pts | ||
| This criterion is linked to a Learning OutcomeVB2: Conditional Lookup formula |
|
2.0 pts | ||
| This criterion is linked to a Learning OutcomeA1: Conditional formatting |
|
2.0 pts | ||
| This criterion is linked to a Learning OutcomeA1: Custom format |
|
2.0 pts | ||
| This criterion is linked to a Learning OutcomeAdd a chart to a spreadsheet |
|
3.0 pts | ||
| Total Points: 20.0 |
