Scribd
Upload
4 views2 pages

Assignment3 (RANADIP)

The document outlines the design of a grade book spreadsheet that calculates final grades based on weighted assignments, exams, and participation. It includes instructions for creating a table, calculating averages, and applying conditional formatting to visualize student performance. The final grades and class averages for five students are provided as examples.

Uploaded by

ranadipbanerjee1
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

Assignment3 (RANADIP)

The document outlines the design of a grade book spreadsheet that calculates final grades based on weighted assignments, exams, and participation. It includes instructions for creating a table, calculating averages, and applying conditional formatting to visualize student performance. The final grades and class averages for five students are provided as examples.

Uploaded by

ranadipbanerjee1
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Assignment 3

Design a grade book spreadsheet that calculates


students' final grades based on assignments, exams,
and participation. Incorporate weighted grading
systems, formulas for calculating averages, and
conditional formatting to indicate performance levels.
Generate reports to track individual student progress.

Student Assignment(40 Exam(50 Participation(10 Final


Name %) %) %) Grade
Arjun 85 90 100 89
Rahul 78 82 85 80.7
Rohan 92 85 80 87.3
Romesh 88 95 90 91.7
Sumit 70 75 60 71.5
Class
Average 82.6 85.4 83 84.04

Steps
 Create a table with five headings-Student Name ,
Assignment(40%), Exam(50%), Participation(10%)
and Final Grade .
 Create the final grade using this formula: Final
Grade= Participation(10%)*10%+ Exam(50%)*50%
+Assignment(40%)*40%
 To calculate the class average, he apply the
formula =AVERAGE(B2:B6) in cell B7 and then drag
it up to cell E7.

Student Assignment(40 Exam(50 Participation(10 Final


Name %) %) %) Grade
Arjun 85 90 100 89
Rahul 78 82 85 80.7
Rohan 92 85 80 87.3
Romesh 88 95 90 91.7
Sumit 70 75 60 71.5
Class
Average 82.6 85.4 83 84.04
 Select the 1st row(A1:E1), go to the Home
option, and then click on the yellow colour in
the Fill Color option.

Student Assignment(40 Exam(50 Participation(10 Final


Name %) %) %) Grade
Arjun 85 90 100 89
Rahul 78 82 85 80.7
Rohan 92 85 80 87.3
Romesh 88 95 90 91.7
Sumit 70 75 60 71.5
Class
Average 82.6 85.4 83 84.04

 Select E2:E7 range


 Then click home and go option conditional
formatting
 Then select color Scales
 Then select one of these

Student Assignment(40 Exam(50 Participation(10 Final


Name %) %) %) Grade
Arjun 85 90 100 89
Rahul 78 82 85 80.7
Rohan 92 85 80 87.3
Romesh 88 95 90 91.7
Sumit 70 75 60 71.5
Class
Average 82.6 85.4 83 84.04

You might also like