wB - Progressive Assessment

webBook will be discontinued from the January 2025 release (version 60.01.200).

Please switch over to Staff Kiosk Assessment > Markbook or Assessment > Enter Results and Comments if you haven't already.

Progressive Assessment Overview

For Class Teachers

webBook Progressive Assessment allows class teachers to create and assign Activities to their subject class (accessed by clicking on the 'Activity Setup' links in the 'Assessment Options' screen).

It also includes a markbook that enables Final Result and Overall Subject Grade calculations based on Activity results from both the current reporting period and past reporting periods.  It facilitates a yearlong markbook. (The markbook is accessed by clicking on the 'Activity Assessment' links in the 'Assessment Options' screen.)

Functionality available for the class teacher includes the ability to:

• Create and assign Activities to their subject class in the current academic reporting period. These Activities become available to students through Student Café and can optionally be made available to parents through Parent Lounge.  Activities are saved in the Teacher Kiosk Learning Objects Repository.
  

  Click here for more on the Learning Objects Repository.

  This is best described as a filing cabinet for Activities and Resources.

  Every Activity that you create by using webBook Progressive Assessment or Teacher Kiosk program Assessment will be filed in this repository.

  The repository is divided into:

  • My Learning Objects: This is where you store your own Learning Objects that you do not want to be available to other teachers.

  • Central Repository: This repository is available to all teachers. Learning Objects that you elect to store here will be available to all teachers to use.

• Attach digital Resources to Activities.
  

  Click here for more on Resources.

  Resources can be digital files such as PDF documents, Microsoft Powerpoint® presentations, Microsoft Word® documents etc.

  An example of a Resource that is attached to an Activity could be a rubric that outlines to the students what they need to do to achieve a certain mark.

• For each class, determine the Objectives (criteria) that will be used to mark each Activity (based on a selection of Objectives set up by the academic reporting administrator).
• For each class, determine the weightings for each Activity/Objective.
• For each class, enter raw scores for each Activity/Objective in the markbook.
• For each class, enter Activity comments for students.

• For each class, calculate Final Results based on Activity/Objective raw scores and their weightings. There is also an option to include Activity raw sores from previous reporting periods in calculations (in the current year and/or previous year).

  Click here for an Administrator Note.

  How to set up for a year-long Markbook.

  • How to Setup Year-Long Marking in webBook (one Reporting Period at a time) (wB)

  • How to Setup Year-Long Marking in webBook (more than one Reporting Period at a time) (wB)

   

• For each class, calculate the Overall Subject Grade(s) based on either:

1. Final Results for each Objective (with equal or differential weightings).   This documentation will refer to this as Calculation Method 1.
   

   Click here for more on Calculation Method 1.

   'Final Results' are calculated based on Activity/Objective raw scores and their weightings. These 'Final Results' are then used to calculate an 'Overall Subject Grade'.

   This calculation method supports equal or differential weightings on the 'Final Results' that are used to calculate 'Overall Subject Grade'.

2. Activity/Objectives  raw scores and their weightings (ignoring Final Results in the calculation).   This documentation will refer to this as Calculation Method 2. There is also an option to include Activity raw sores from previous reporting periods (in the current year and/or previous year).
   

   Click here for more on Calculation Method 2.

   The calculation of the 'Overall Subject Grade' is based on Activity/Objective raw scores and weightings only. 'Final Results' are ignored and do not contribute to the calculated 'Overall Subject Grade'.

3. Exporting raw scores to an existing Microsoft Excel® template to allow calculation using certain Excel formulas . This documentation will refer to this as Calculation Method 3. Calculated results can then be uploaded back into the markbook.
   

   Click here for more on Calculation Method 3.

   Exporting raw scores to an existing Microsoft Excel® template to allow calculation using certain Excel formulas.

   

   Supported Excel Formulas

   This is a list of the Excel formulas that are currently supported by the webBook Progressive Assessment Markbook 'Upload' function.

   The tool that is used to facilitate an upload is based on the API/libraries provided by Apache POI V3.9, and which comes bundled as part of your CF11 Server. Therefore the availability and successful operation of these formulas during upload are entirely reliant on this function.

   

   Important!

   Before you use any of these formulas extensively in your Excel templates, we strongly recommend that you test a limited upload to check that they function correctly.

   Further information about Apache POI is available at http://poi.apache.org/index.html

   ABS ACOS ACOSH AND ASIN ASINH ATAN ATAN2 ATANH AVEDEV AVERAGE CEILING CHOOSE COLUMN COLUMNS COMBIN CONCATENATE COS COSH COUNT COUNTA COUNTIF

   DATE DAY DAYS360 DEGREES DEVSQ DOLLAR ERROR.TYPE EVEN EXACT EXP FACT FALSE FIND FLOOR FV HLOOKUP HOUR HYPERLINK IF INDEX INDIRECT INT

   ISBLANK ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT LARGE LEFT LEN LN LOG LOG10 LOOKUP LOWER MATCH MAX MAXA MEDIAN

   MID MIN MINA MINUTE MOD MODE MONTH NA NETWORKDAYS NOT NOW NPER NPV ODD OFFSET OR PI PMT POWER PRODUCT PV RADIANS

   RAND RATE REPLACE RIGHT ROUND ROUNDDOWN ROUNDUP ROW ROWS SEARCH SECOND SIGN SIN SINH SMALL SQRT STDEV SUBSTITUTE SUM SUMIF SUMPRODUCT SUMSQ

   SUMX2MY2 SUMX2PY2 SUMXMY2 T TAN TANH TIME TODAY TRIM TRUE UPPER VALUE VLOOKUP WORKDAY YEAR YEARFRAC

   
   
   
   

• Print out the class markbook with detail including:
  • Weightings.
  • Adjusted weightings.
  • Raw scores and calculated Final Results and Overall Subject Grade.
  • Forecasts.
  • Standard deviation and mean.

For HOD's or Department Administrators

The 'Progressive' columns within webBook allow HOD's or Department Administrators to:

• Create and assign Activities to multiple subject classes (that belong to your department(s)) in the current academic reporting period, e.g. all Year 11 English Classes. 
  These Activities become available in the respective class teachers' markbooks.   They also are available to students through Student Café and can optionally be made available to parents through Parent Lounge.
• Attach digital Resources to Activities.
• For multiple subject classes (that belong to your department(s)), determine the Objectives (criteria) that will be used to mark each Activity (based on a selection of Objectives set up by the academic reporting administrator).

• Export raw scores for multiple subject classes (that belong to your department(s)) to an existing Microsoft Excel® template to allow calculation using certain Excel formulas.
  

  Click here for a list of the formulas supported.

  Supported Excel Formulas

  This is a list of the Excel formulas that are currently supported by the webBook Progressive Assessment Markbook 'Upload' function.

  The tool that is used to facilitate an upload is based on the API/libraries provided by Apache POI V3.9, and which comes bundled as part of your CF11 Server. Therefore the availability and successful operation of these formulas during upload are entirely reliant on this function.

  

  Important!

  Before you use any of these formulas extensively in your Excel templates, we strongly recommend that you test a limited upload to check that they function correctly.

  Further information about Apache POI is available at http://poi.apache.org/index.html

  ABS ACOS ACOSH AND ASIN ASINH ATAN ATAN2 ATANH AVEDEV AVERAGE CEILING CHOOSE COLUMN COLUMNS COMBIN CONCATENATE COS COSH COUNT COUNTA COUNTIF

  DATE DAY DAYS360 DEGREES DEVSQ DOLLAR ERROR.TYPE EVEN EXACT EXP FACT FALSE FIND FLOOR FV HLOOKUP HOUR HYPERLINK IF INDEX INDIRECT INT

  ISBLANK ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT LARGE LEFT LEN LN LOG LOG10 LOOKUP LOWER MATCH MAX MAXA MEDIAN

  MID MIN MINA MINUTE MOD MODE MONTH NA NETWORKDAYS NOT NOW NPER NPV ODD OFFSET OR PI PMT POWER PRODUCT PV RADIANS

  RAND RATE REPLACE RIGHT ROUND ROUNDDOWN ROUNDUP ROW ROWS SEARCH SECOND SIGN SIN SINH SMALL SQRT STDEV SUBSTITUTE SUM SUMIF SUMPRODUCT SUMSQ

  SUMX2MY2 SUMX2PY2 SUMXMY2 T TAN TANH TIME TODAY TRIM TRUE UPPER VALUE VLOOKUP WORKDAY YEAR YEARFRAC

  
  
  
  

• Calculated results can then be uploaded back into the markbook.

Staff Kiosk Assessment

The Activities that are created in webbook Progressive Assessment can also be accessed in Staff Kiosk > Assessment . This area can be used for more comprehensive Activity functionality including:

• Tracking student completion.
• Providing feedback to students.
• Notifying Parent and Students via email when an Activity has not been submitted.
• Changing due dates.
• Granting extensions.