| | |
| | This assignment includes three cumulative projects which build upon each other to create a student gradebook for college instructors. |
| | You should have already been exposed to MS Office, including MS Excel, in a pre-requisite course.
As each project gets a bit more difficult, if there are topics with which you are not that familiar, you can "google" or do a little internet research.
These projects are not meant to be easy but serve as a challenge, using a real-life application of an instructor/teacher building a grade book for his/her students. |
| | You may wish to read all project requirements below before working on and submitting each to fully understand the overall assignment. |
| | Once you complete each project, please remember to submit through Canvas both the Excel project and this file with the applicable checkboxes marked.
This will serve as both a step-by-step guide for you in completing the requirements and for me to ensure that you've covered all applicable requirements. |
| | I hold a strict literal interpretation of the requirements (e.g., at least 20 students, at least five gradeable items, explicit names for worksheets, etc.) for two reasons:
- (1) I want to ensure that students are able to read, understand, and follow directions;
- (2) real-life clients for IT projects, like web and other software applications, will have strict requirements on what they want.
Consider these projects as good life lessons. |
| | If you are unsure about a requirement in a project, please ask well before the project is due. I won't re-grade after a submission:
(1) out of fairness to other students who don't ask for a re-grade on a re-submission and
(2) since I assume you understood all requirements by virtue of your submission. |
| | Part | Points Toward the Final Grade | Instructions | Checkbox | Grading Rubric |
| | 1 = Entering the Framework | 5 | In this initial part of the assignment, you'll create the framework for the gradebook.
As you complete each of the requirements below, kindly indicate in the "Checkbox" column to the right for that requirement if you have met it by simply selecting "Yes" from the dropdown. |
| | | | Please create a worksheet called "Student Grades" in preparation for a minimum of 20 students' information for a given class.
Please note that a worksheet ("sheet") is not the same as the name of the Excel file ("workbook"): http://www.differencebetween.net/technology/difference-between-excel-workbook-and-worksheet/ . | | 10% |
| | | | Kindly ensure that this assignment includes at least the following fields as separate columns for each of the 20 students.
You do not need to provide values for these fields yet; I just want to ensure that you add the correct column headers for them. |
| | | | - Student ID | | 10% |
| | | | - Student First Name | | 10% |
| | | | - Student Last Name | | 10% |
| | | | You are free to determine at least five gradeable items for each student.
For example, you may wish to include a mid-term exam, a final exam, etc. |
| | | | - First gradeable item (please give it a name such as "Mid-Term Exam", "Final Exam", etc.) | | 5% |
| | | | - Second gradeable item (please give it a name such as "Mid-Term Exam", "Final Exam", etc.) | | 5% |
| | | | - Third gradeable item (please give it a name such as "Mid-Term Exam", "Final Exam", etc.) | | 5% |
| | | | - Fourth gradeable item (please give it a name such as "Mid-Term Exam", "Final Exam", etc.) | | 5% |
| | | | - Fifth gradeable item (please give it a name such as "Mid-Term Exam", "Final Exam", etc.) | | 5% |
| | | | Ensure that you add the applicable point value or weight for each gradeable item (e.g., 20% for the mid-term exam, 30% for the final exam, etc.) in the spreadsheet, preparing it for student entry.
Ensure that each weight per item is in a separate Excel cell and that all weights total 100% exactly.
These will be used in a future project to calculate final grades. |
| | | | - First gradeable item's weight in a separate cell (e.g., "Mid-Term Exam Weight") | | 5% |
| | | | - Second gradeable item's weight in a separate cell | | 5% |
| | | | - Third gradeable item's weight in a separate cell | | 5% |
| | | | - Fourth gradeable item's weight in a separate cell | | 5% |
| | | | - Fifth gradeable item's weight in a separate cell | | 5% |
| | | | - All gradeable items total 100%. | | 10% |
| | | | Total: | | 100% |
| | | | When complete, please submit through Canvas:
(1) Your Project 1 Excel file and
(2) This file with the checkboxes completed, showing me that you understood and completed each part of this assignment. |
slobdylan
ExcelAssignments-Part1.xlsx
