Chapter 7 - Projects 7A and 7B
-
Due
Oct 29, 2018 by
11:59pm
-
Points
15
-
Submitting
a file upload
-
File Types
xls and xlsx
-
Available
Oct 15, 2018 at 12am - Nov 5, 2018 at 11:59pm
This assignment was locked Nov 5, 2018 at 11:59pm.

Creating Charts, Diagrams, and Templates
Project 7A
Outcomes
Query large amounts of data, subtotal and aggregate numeric data, and filter and group data to analyze for relationships and trends.
Objectives
- Create a PivotTable Report
- Use Slicers and Search Filters
- Modify a PivotTable
- Create a PivotChart
Project 7B
Outcomes
Use a Data Model to analyze data from multiple sources.
Objectives
- Create a PivotTable from a Data Model
- Create and Format a 3-D Pie PivotChart
Assignment
- Complete Project 7A on pages 436 thru 459
- Submit the Project 7A Fire Police workbook
- Complete Project 7B on pages 460 thru 468
- Submit the Project 7B First Aid workbook
How do I submit my assignment files?
1540882740
10/29/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
|