More links

AutoHotkey | Android | Arduino | COMM140Fractals | Grammar Checkers | Knots | A Million Dots Activity |  Processing | Processing for Scratch Users | RedBubble | Tutorials | Weather | World Time Meeting Planner | Favicon Generator.

Home > Tutorials > Excel Markbook

Excel Markbook


Page 1

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:





Hello Rupert,

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 PDF File 855 KB

CorelDraw10 CorelDRAWfile 476 KB Ziped with Winzip

Markbook Excel 41 KB

Markbook ACU gradings Excel14 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 Ziped with Winzip




APA citation:
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

rupert dot russell at acu dot edu dot au Support Wikipedia

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License.

11616 visits since July 26, 2006