Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Markbook

VIEWS: 2 PAGES: 2

									This is an example markbook by Rupert Russell
based on an example created by:
Ross Loseli Ma'ukie Hafoka
 Author of Teaching Visual Basic Programming a Classroom Approach
 Hafoka & Partners
 4 Sophia Court
 CARRUM DOWNS VIC 3201
 Phone: (03) 9776 9235
 Mobile: 0405 846 211
 e-mail: hafr@jpc.vic.edu.au


This markbook demonstrates the following functions and features of Excel:

 Autofill
 AutoFilters
 Conditional formatting
 Customising toolbars
 The VLOOKUP function

 For a PDF file detailing the steps involved in creating this markbook see:
   http://velorum.ballarat.edu.au/~rrussell/tutorials/markbook/index.html
                                                                                                                                           / 50 Task 2 Total
                                                Student Number




                                                                                                                                                                                                          Final Grade
                                                                 / 30 Task 1




                                                                                                                                                                        / 20 Task 3
                                   First Name
                       Last Name




                                                                                                                             / 20 Part C
                                                                                                 / 10 Part A

                                                                                                               / 20 Part B
     Tutorial




                                                                                                                                                                                       Grades
                                                                                        Task 2
                                                                                Grade




                                                                                                                                                                Grade




                                                                                                                                                                                                 Total
 1   A          AAA     AAA                     1234567          30            HD                10            20            20            50                  HD       20            HD        100      HD             Mark   Grade
 2   A          HARVEY Danielle                                   0            XN                 0             0             0             0                  XN        0            XN          0      XN               0     XN
 3   B          BARHAM Mharni                   2454354           1            NN                 2             4            15            21                  MN       10            P          32      NN               1     NN
 4   C          BATEMAN Paul                    2467890          14            MN                 6            11            18            35                  D        14            D          63      C               40    MN
 5   A          BAUER   Donna                   2464533          15            P                  7            10             9            26                  P        17            HD         58      P               50      P
 6   B          BEHAN   Melissa                 2461176          16            P                  4            16            19            39                  D        18            HD         73      D               60      C
 7   C          BENBOW Claire                   2457819          17            P                  9            17            19            45                  HD       16            HD         78      D               70      D
 8   A                  Rebecca
                BERLINGERI                      2403954          18            C                  9            15            11            35                  D        15            D          68      C               80     HD
 9   B          BIRCH   Lauren                  2412345          19            C                  7            17            15            39                  D        14            D          72      D                0      20      0   XN
10   C          BLAKE   Vikki                   2420736          20            C                  7            18            19            44                  HD       19            HD         83      HD               1      20    0.2   NN
11   A                  E
                BROWNLEErin                     2429127          21            D                  6            15            15            36                  D        14            D          71      D               40      20      8   MN
12   B          CARR    Georgie                 2437518           9            NN                 4            14             8            26                  P        12            C          47      MN              50      20     10    P
13   C          CASSIDY Sarah                   2445909          23            D                  7            10            10            27                  P        13            C          63      C               60      20     12    C
14   C          CHAFFEY Aimée                   2454300          24            HD                 9             9             9            27                  P        14            D          65      C               70      20     14    D
15   C          COGHILL Laura                   2462691          25            HD                 5            15            11            31                  C        16            HD         72      D               80      20     16   HD
16   A          COLLINS Claire                  2471082          26            HD                 6            16            19            41                  HD       16            HD         83      HD               0      30      0   XN
17   A          DESIRA Hugh                     2479473          27            HD                 7            17            20            44                  HD       15            D          86      HD               1      30    0.3   NN
18   B          DODD    Michelle                2487864          28            HD                 8            16            17            41                  HD       17            HD         86      HD              40      30     12   MN
19   C          EDWARDSMichelle                 2496255          29            HD                 4            15            14            33                  C        14            D          76      D               50      30     15    P
20   C          FINCHER Camilla                 2414678          30            HD                 9            14            18            41                  HD       15            D          86      HD              60      30     18    C
21   A          FOOTT   Lisa                    2333101          23            D                  6            15            13            34                  C        14            D          71      D               70      30     21    D
22   B                  Danielle
                GALLAGHER                       2251524           7            NN                 4            13             7            24                  MN       11            P          42      MN              80      30     24   HD
23   B          GAMBLE Eleanor                  2169947          16            P                  8             9             9            26                  P        12            C          54      P                0      50      0   XN
24   C          GOURLEY Blythe                  2088370          14            MN                 9             8             8            25                  P        14            D          53      P                1      50    0.5   NN
25   C          HANDRECKLauren                  2006793          15            P                  9             9             9            27                  P        15            D          57      P               40      50     20   MN
                                                                                                                                                                                                                         50      50     25    P
                Note: Test student to make sure the formulas add up to 100%                                                                                                                                              60      50     30    C
                Note: Conditional formating highlights blank cells                                                                                                                                                       70      50     35    D
                "=VLOOKUP(Q2,$T$3:$U$9,2,TRUE)"                                                                                                                                                                          80      50     40   HD

								
To top