Excel Assignment
Create a spreadsheet that your instructor could use to calculate final averages and letter grades for this class (INFS 3100). Use the point values from the syllabus for discussion questions, Excel assignments and quizzes. The spreadsheet should use the design and all features of the spreadsheet created in your Excel tutorial for assignment 2. More specifically, the following requirements must met:
1. Each student record should be on one row and each grade item or calculated value should be in one column similar to the tutorial
2. A table that includes cutoff's for each grade level, i.e. 90 for A, 80 for B, etc.
3. Column Headings
4. A minimum of 5 fictitious student records with grades entered for each student.
5. Columns for total points in each category of grades (discussion, Excel and quiz).
6. A calculated final average.
7. A final letter grade. Use an IF statement and absolute cell referencing for grade cutoff's from the table created in 1.a. above (similar to what was done in assignment 2 tutorials).
8. A class average for each individual grade item, combined grade categories (discussion, Excel, and quiz), and final average.
9. The highest (max) grade for each individual grade item, combined grade categories, and final average.
10. The lowest (min) grade for each individual grade item, combined grade categories, and final average.
11. Center all column headings
12. Bold columns for total discussion points, total Excel assignment points, total quiz points, final average, and letter grade.
13. Format all calculated values (not individual scores) as number with one decimal point.
14. Put your name at the top of the spreadsheet.
15. Upload your completed assignment to the Dropbox for assignment 2 in D2L by the due date. Verify that you assignment is uploaded correctly. This can be accomplished by opening the uploaded file to verify the file opens properly.
This is an individual assignment and you should create this spreadsheet on your own. Keep in mind that the tutorial is a learning tool and completion of the tutorial is not the assignment. You should start with a blank spreadsheet and build the assignment from scratch.
Attachment:- student_grade_worksheet.rar