Chapter 8 - Projects 8A and 8B
-
Due
Nov 5, 2018 by
11:59pm
-
Points
15
-
Submitting
a file upload
-
File Types
xls and xlsx
-
Available
Oct 29, 2018 at 12am - Nov 12, 2018 at 11:59pm
This assignment was locked Nov 12, 2018 at 11:59pm.
Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas
Project 8A
Outcomes
Analyze sales data to evaluate business solutions and compare data with a line chart.
Objectives
- Calculate a Moving Average
- Project Income and Expenses
- Determine a Break-Even Point
Project 8B
Outcomes
Use Solver and Scenario Tools, and create complex formulas.
Objectives
- Use Solver
- Create Scenarios
- Use Logical Functions
- Create Complex Formulas
Assignment
- Complete Project 8A on pages 490 thru 503
- Submit the Project 8A Charlotte Sales workbook
- Complete Project 8B on pages 504 thru 524
- Submit the Project 8B Staffing Analysis workbook
How do I submit my assignment files?
1541491140
11/05/2018
11:59pm
Rubric
Can't change a rubric once you've started using it.
Projects
You've already rated students with this rubric. Any major changes could affect their assessment results.
Projects
| Criteria |
Ratings |
Pts
|
This criterion is linked to a Learning Outcome
Objectives
_8154
threshold:
pts
|
5
to >3.0 pts
Excellent
The student met all objectives in the creation of the project.
blank
|
3
to >1.0 pts
Proficient
One or two project objectives were not met. See comment section for missed objectives.
894_1501
|
1
to >0.0 pts
Developing
More than two project objectives were not met. See comment section for missed objectives.
894_713
|
0
to >0 pts
Needs Improvement
None of the objectives were met or the project was not submitted.
blank_2
|
This area will be used by the assessor to leave comments related to this criterion.
|
pts
/
5 pts
--
|
This criterion is linked to a Learning Outcome
Completion
894_4038
threshold:
pts
|
5
to >3.0 pts
Excellent
All step-by-step instructions were completed.
894_1594
|
3
to >1.0 pts
Proficient
One or two project instructions were not completed. See comment section for more information.
894_9445
|
1
to >0.0 pts
Developing
More than two instructions were not completed. See comment section for more information.
894_828
|
0
to >0 pts
Needs Improvement
The project was incomplete or was not submitted.
894_3000
|
This area will be used by the assessor to leave comments related to this criterion.
|
pts
/
5 pts
--
|
This criterion is linked to a Learning Outcome
Accuracy
898_5382
threshold:
pts
|
5
to >3.0 pts
Excellent
The step-by-step instructions were followed accuratly.
898_1763
|
3
to >1.0 pts
Proficient
One or two steps were not completed accurately. See comment section for more information.
898_1874
|
1
to >0.0 pts
Developing
More than two steps were not completed accurately. See comment section for more information.
898_1286
|
0
to >0 pts
Needs Improvement
The project was incomplete or was not submitted.
898_6257
|
This area will be used by the assessor to leave comments related to this criterion.
|
pts
/
5 pts
--
|
This criterion is linked to a Learning Outcome
Description of criterion
threshold:
5 pts
|
5
to >0 pts
Full Marks
blank
|
0
to >0 pts
No Marks
blank_2
|
This area will be used by the assessor to leave comments related to this criterion.
|
pts
/
5 pts
--
|
|
Total Points:
15
out of 15
|
Rubric
Can't change a rubric once you've started using it.
Title
You've already rated students with this rubric. Any major changes could affect their assessment results.
Title
| Criteria |
Ratings |
Pts
|
This criterion is linked to a Learning Outcome
Description of criterion
threshold:
5 pts
|
5
to >0 pts
Full Marks
blank
|
0
to >0 pts
No Marks
blank_2
|
This area will be used by the assessor to leave comments related to this criterion.
|
pts
/
5 pts
--
|
This criterion is linked to a Learning Outcome
Description of criterion
threshold:
5 pts
|
5
to >0 pts
Full Marks
blank
|
0
to >0 pts
No Marks
blank_2
|
This area will be used by the assessor to leave comments related to this criterion.
|
pts
/
5 pts
--
|
|
Total Points:
5
out of 5
|
Find Rubric
