Chapter 9 - Projects 9A and 9B
-
Due
Nov 12, 2018 by
11:59pm
-
Points
15
-
Submitting
a file upload
-
File Types
xls, xlsx, and xlsm
-
Available
Oct 29, 2018 at 12am - Nov 19, 2018 at 11:59pm
This assignment was locked Nov 19, 2018 at 11:59pm.
Using Macros and Visual Basic for Applications
Project 9A
Outcomes
Record a macro to automate complex and repetitive tasks.
Objectives
- Record a Macro
- Assign a Macro to a Button on the Quick Access Toolbar
- Modify a Macro
Project 9B
Outcomes
Ensure accuracy and automate instructions using VBA commands and ActiveX Controls.
Objectives
- Write a VBA Procedure to Use an ActiveX Control
- Restore Initial Settings
Assignment
- Complete Project 9A on pages 548 thru 559
- Submit the Project 9A Travel Macro workbook
- Complete Project 9B on pages 560 thru 574
- Submit the Project 9B Travel VBA workbook
How do I submit my assignment files?
1542095940
11/12/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
