| | |
| | 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 |
| | 3 = Class Analysis | 15 | In this final part of the assignment, you'll prepare an analysis of the student grades. |
| | | | Please create a new worksheet, called "Grading Rubric".
This "Grading Rubric" sheet will be used to lookup student numeric grades to calculate applicable alpha grades (e.g., a "91" numerical grade equates to an "A-" alpha grade). | | 5% | |
| | | | In the "Grading Rubric" worksheet, please create a table of grade ranges, using our class syllabus as an example. | | 10% |
| | | | In the "Student Grades" worksheet, add another column to reflect the alpha final grade per student. | | 5% |
| | | | Calculate the alpha final grade per student based on the student numerical grade. To do this, you may wish to use a Lookup Excel function (please research if you are unfamiliar with this) based on the grade ranges in the "Grading Rubric" worksheet. Please note that some students have decided to use a series of If statements. | | 20% | |
| | | | For each student's final grade, use conditional formatting in the new alpha grade column to reflect the following cell colors.
You may wish to research "conditional formatting" if you are not familiar with it.
Hard-coding colors will not be accepted. | | 20% | |
| | | | - A grades should be in green |
| | | | -B grades should be in blue |
| | | | -C grades should be in yellow |
| | | | - D grades should be in orange |
| | | | - F grades should be in red |
| | | | Given all student information and graded assignments, create a third worksheet, called "Analysis". | | 5% | |
| | | | In the "Analysis" worksheet, kindly use applicable formulas and references to reflect the: |
| | | | - maximum class grade | | 5% | |
| | | | - minimum class grade | | 5% | |
| | | | - average class grade | | 5% | |
| | | | Hard-coded entries for the maximum, minimum, and average class grades will not be accepted. |
| | | | Lastly, in the "Analysis" worksheet, use an applicable formula to count and show the number of grades in each of the grade ranges (e.g., number of As, number of A-s, number of B+s, etc., even if the frequencies are 0).
Hard-coded entries for the frequencies will not be accepted. | | 20% | |
| | | | Total: | | 100% |
| | | | When complete, please submit through Canvas:
(1) Your Project 3 Excel file and
(2) This file with the checkboxes completed, showing me that you understood and completed each part of this assignment. |
slobdylan
ExcelAssignments-Part3.xlsx
