| | |
| | 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 |
| | 2 = Entering Data | 5 | In this subsequent part of the assignment, please add all applicable student information for the 20 students identified in Part 1. |
| | | | This information includes adding the student information (ID, First Name, and Last Name) as well as numeric grades for all gradeable items for all 20 students. |
| | | | Please ensure that you vary the students' graded assignments (e.g., some get 90s, others 80s, etc.). |
| | | | - Student ID for all students | | 10% |
| | | | - Student First Name for all students | | 10% |
| | | | - Student Last Name for all students | | 10% |
| | | | - First gradeable item for all students | | 10% |
| | | | - Second gradeable item for all students | | 10% |
| | | | - Third gradeable item for all students | | 10% |
| | | | - Fourth gradeable item for all students | | 10% |
| | | | - Fifth gradeable item for all students | | 10% |
| | | | After entering all information for all students, please calculate a final numerical grade for each student.
For this final numerical grade, kindly ensure that you use proper calculations (cell references) to derive these final numerical grades.
Ensure you make proper use of the separate cells that contain the gradeable weights when calculating the final numerical grades.
Hard-coded final numerical (for example, "93" as opposed to calculating the grade) will not be accepted. | | 20% |
| | | | Total: | | 100% |
| | | | When complete, please submit through Canvas:
(1) Your Project 2 Excel file and
(2) This file with the checkboxes completed, showing me that you understood and completed each part of this assignment. |
slobdylan
ExcelAssignments-Part21.xlsx
