Seven Quizzes -marks given out of 5 Five Assignments -marks given out of 5 One Term Report - marks given of 10 Two Tests - marks given out of 15 One Final Exam - marks given out of 30 Grade should be calculated as per following policies: Quizzes: Total weight 15%, N-2, Average of remaining quizzes x 3, Rounded to single decimal place {2.00} Assignments: Total weight 15%, (Average of Top and Bottom) x 3, Rounded to single decimal place {1.50} Total Semester: Quizzes + Assignments + Term Report +Both Tests {0.50} Total Score: Total Semester + Final Exam {0.50} Insert a line at the bottom and calculate average score for each item i.e. Quizzes, Assignments, , Final Exam, Rounded to single decimal place TIP