Chapter 5 - Projects 5A and 5B
-
Due
Oct 8, 2018 by
11:59pm
-
Points
15
-
Submitting
a file upload
-
File Types
xls, xlsx, pdf, and csv
-
Available
Sep 24, 2018 at 12am - Oct 15, 2018 at 11:59pm
This assignment was locked Oct 15, 2018 at 11:59pm.
Managing Large Workbooks and Using Advanced Sorting and Filtering
Project 5A
Outcomes
Manage and format large workbooks and save workbooks to share with others.
Objectives
- Navigate and Manage Large Worksheets
- Enhance Worksheets with Themes and Styles
- Format a Worksheet to Share with Others
- Save Excel Data in Other File Formats
Project 5B
Outcomes
Analyze information in a database format using advanced sort, filter, subtotaling, and outlining.
Objectives
- Use Advanced Sort Techniques
- Use Custom and Advanced Filters
- Subtotal, Outline, and Group a List of Data
Assignment
- Complete Project 5A on pages 316 thru 337
- Submit only three Project 5A files: Class Schedule workbook, Schedule_PDF, and Schedule_CSV
- Complete Project 5B on pages 338 thru 354
- Submit the Project 5B Fall Sections workbook
How do I submit my assignment files?
1539068340
10/08/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
