Interactive Google Sheet for Grading
Budget: $10 – $30 USD
I need a Google Sheets template for interactive grading.
- Structure: The sheet will cover 8 weeks with discussion points and project grades. there will also be a capstone project in week eight,s o week eight is a capstone and needs to count for more of the grade
- Scoring: Each discussion point is worth up to 20 points, and each project grade up to 100 points.
- Final Grade: The sheet will automatically calculate a final grade at the bottom based on entered scores.
- Grading Scale: The grading will be weighted and graded on the American college grading scale.
- Display: Final grade should be displayed as both a percentage and a letter grade.
- Input: Discussion and project points should be entered via a dropdown menu.
Ideal skills for this project include advanced Google Sheets expertise, experience in creating interactive spreadsheets, and understanding of the American college grading system.
- Structure: The sheet will cover 8 weeks with discussion points and project grades. there will also be a capstone project in week eight,s o week eight is a capstone and needs to count for more of the grade
- Scoring: Each discussion point is worth up to 20 points, and each project grade up to 100 points.
- Final Grade: The sheet will automatically calculate a final grade at the bottom based on entered scores.
- Grading Scale: The grading will be weighted and graded on the American college grading scale.
- Display: Final grade should be displayed as both a percentage and a letter grade.
- Input: Discussion and project points should be entered via a dropdown menu.
Ideal skills for this project include advanced Google Sheets expertise, experience in creating interactive spreadsheets, and understanding of the American college grading system.