Home > Tutorials > Excel Markbook
Since I wrote these notes I have learnt a few new things about using the Vlookup formula
1) You can place the vlookup table on a separate worksheet and reference it from within the formula using the name of the worksheet
2) If you place the vlookup table on a separate worksheet you don't have to state the upper left and lower right cell numbers in the formula
The result of this becomes a formula that looks like the following:
I saw your website about an Excel markbook, I'm starting to make my own and I have a query you might be able to help with.
I have attached the sheet.
I want to be able to enter "Abs" when students miss an assignment legitimately and have it not affect their term average or grade.
i.e. only average the five assignments that Fred has completed and ignore the missed one.
Do you have any idea how I can achieve this?
=ISNUMBER(A1) will return TRUE of FALSE
=IF(ISNUMBER(H5),(H5/$H$4)*100,0)+IF(ISNUMBER(I5),(I5/$I$4)*100,0) The trick is to use a sequence of if commands IF(ISNUMBER())
Markbook Excel 13 KB created 19 June 2014
Excel Markbook PDF File 855 KB
CorelDraw10 file 476 KB
Markbook Excel 41 KB
Markbook ACU gradings 14 KB xlsx file
updated 25 November 2014 thanks to Amber Van Dreven for poiniting out an issue with rounding of grades
Markbook Excel 9 KB
Russell, R. (2019, May 24, 11:17 pm). Excel markbook example.
Retrieved April 06, 2020, from http://www.rupert.id.au/tutorials\markbook/index.php
Last refreshed: April 06 2020. 02:57.59 pm
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License.
11616 visits since July 26, 2006