eMarkbook Excel Template

 

 
mail
The Tuition Centre
PO Box 445
CLAREMONT
WA 6910
AUSTRALIA
 
phone
+61 8 9284 3004
 
fax
+61 8 9284 3005
 
email

 

Preview

This page has a few screen shots taken from eMarkbook for Microsoft Excel. (Click on images to view enlarged version.) You can see much more in the Help file (a Word document) and experiment with sample data included in the free download.

The screen below shows the main sheet - Class Marks - which is used for data entry. Percentages, averages and grades are all automatically updated as you type. Users enter data in the yellow and white cells only. All other cells update automatically and are locked to prevent accidental deletion of the formulae they contain.

Click to view full size

The Options button on Class Marks opens up a window with many choices: Rank/Print (rank by whole group or individual class and create printer friendly summary of marks), Estimates, Class Marks (tools for sorting and deleting), Scale (to scale entire groups of marks up or down), Indiv (for printing and emailing individual student summaries) and About. The choice illustrated below is for ranking or printing a selected class from the whole group.

Click to view full size

This last screen shows the result of choosing to show a grade distribution when the whole group is ranked. This helps identify grade boundaries for the whole cohort.

Click to view full size

Pricing  Download  Register  eMarkbook  Home

Shortcuts

Numerical type assessment

Grade type assessment