header

 

More links

Adobe Connect | Adobe Conect Custom Pods | AutoHotkey | Android | Arduino | Blog | COMM140Fractals | Grammar Checkers | Knots | a Million Dots |  Processing | RedBubble | Tutorials | Weather | World Time Meeting Planner |

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:

=VLOOKUP(G2,Table!$A:$B,2,TRUE)

 

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

Makrbook 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. (2016, September 26, 10:02 pm). Excel markbook example.
     Retrieved May 23, 2017, from http://www.rupert.id.au/tutorials\markbook/index.php

Last refreshed: May 23 2017. 04:53.06 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.


8759 visits since July 26, 2006