The AVERAGE Function is handy to know and one that I, as a teacher, use frequently.
However, when it comes to student marks, rather than finding the average I often want to find a weighted average.
As the name suggests, a weighted average places more weight or value on certain elements - such as exams - than on other elements being averaged.
In addition to marking, the weighted average can be used anywhere where you need to find the average for data of unequal value.
To find out all the details, read this short tutorial on Calculating the Weighted Average in Excel.