You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Good day all! I like the formatting of the gradebook template in Numbers (that report sure does look slick, as well). But is there a way to change it from inputing percentages into inputing points. It's easier for me to calculate grades that way, I think. That way I can just find one massive percentage at the end of the unit.
Thanks a bunch!
-Ryan
If every point has the same value in terms of the final result, you might try changing the format of the data cells in the assignment columns from percentage to number.
Replace the weight value with the number of available points for each assignment, and the percentage values earned by individuals to the points earned on each assignment.
The Total cell (G3) then reports the total points available (using the existing formula), and the cells below can use the total of 'this row' divided by the total in G3 (and formatted as a percentage) to display the overall percentage.
Regards,
Barry
If every point has the same value in terms of the final result, you might try changing the format of the data cells in the assignment columns from percentage to number.
Replace the weight value with the number of available points for each assignment, and the percentage values earned by individuals to the points earned on each assignment.
The Total cell (G3) then reports the total points available (using the existing formula), and the cells below can use the total of 'this row' divided by the total in G3 (and formatted as a percentage) to display the overall percentage.
Regards,
Barry
Apple Numbers Gradebook Template
