Excel Mark Sheet with Custom Grade Allocation
Budget: $15 – $25 USD
I'm looking for an Excel expert to create a mark sheet for me. This mark sheet will be used to record student test scores and will automatically assign grades based on a custom scale I've provided.
The sheet should have:
- A column for Student Name
- A column for Test Score
- A column for Grade (to be calculated based on the score and the custom scale)
The grade allocation should be as follows:
- Score of 1: Grade E
- Score of 2: Grade D
- Score of 3: Grade C
- Score of 4: Grade B
- Score of 5: Grade A
I do not require any additional calculations to be performed beyond the grade allocation based on the score.
Ideal Skills:
- Proficiency in Excel
- Experience in creating automated grading systems
- Background in academic assessment would be a plus
Please let me know if you have any questions or need further clarification.
The sheet should have:
- A column for Student Name
- A column for Test Score
- A column for Grade (to be calculated based on the score and the custom scale)
The grade allocation should be as follows:
- Score of 1: Grade E
- Score of 2: Grade D
- Score of 3: Grade C
- Score of 4: Grade B
- Score of 5: Grade A
I do not require any additional calculations to be performed beyond the grade allocation based on the score.
Ideal Skills:
- Proficiency in Excel
- Experience in creating automated grading systems
- Background in academic assessment would be a plus
Please let me know if you have any questions or need further clarification.