Weighted Average Marks from data exported from Moodle

From Mick Chesterman

views

Policy

Video Retention Policy

Weighted Average Marks from data exported from Moodle

Mathematical formula gubbins follow.

=SUMPRODUCT(G2:H2, G$45:H$45)/SUM(G$45:H$45)

If you want to know how to export a spreadsheet from moodle in this format then see this video.
https://mmutube.mmu.ac.uk/media/Calculate%20and%20average%20mark%20from%20exported%20moodle%20grades...

Tags