Chapter 10 - Projects 10A and 10B
-
Due
Nov 26, 2018 by
11:59pm
-
Points
15
-
Submitting
a file upload
-
File Types
xls and xlsx
-
Available
Nov 12, 2018 at 12am - Dec 3, 2018 at 11:59pm
This assignment was locked Dec 3, 2018 at 11:59pm.
External Data,Database Functions, and Side-by-Side Tables
Project 10A
Outcomes
Import and manage external data and use database functions in Excel.
Objectives
- Get External Data into Excel
- Clean Up and Manage Imported Data
- Use Database Functions
Project 10B
Outcomes
Create a side-by-side table with conditional formatting and customize headers and footers.
Objectives
- Insert a Second Table into a Worksheet
- Apply Conditional Formatting to Side-by-Side Tables
- Create Custom Headers and Footers
Assignment
- Complete Project 10A on pages 596 thru 613
- Submit the Project 10A Medical Center workbook
- Complete Project 10B on pages 616 thru 626
- Submit the Project 10B Equipment Inventory workbook
How do I submit my assignment files?
1543305540
11/26/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
