Formula. Find the average of each student's homework scores.
Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
Formula.
Find the maximum homework score for each student.
Cell range E7:E29
Use Function MAX
Number 1: maximum homework score for each student on "Section 3" worksheet.
Create a chart.
To the right of the data
Chart 3-D Clustered Column
Exclude all filtered rows
Horizontal Axis Labels: "IDs" column in table
Series 1: "Zero Scores" column in table.
Formula.
Count the number of 0 homework scores for each student.
Cell range F7:F29
Use function COUNTIF
Range: all possible homework scores for each student on "Section 3" worksheet.
Criteria: 0