Updated over a week ago

The HiringBranch Reports page shows critical data relating to learner progress and performance. To get started with Reports, and to learn how to calculate CEFR ratings, follow the steps below.

Viewing and Downloading Results

Open the Reports page.

Choose the group that you would like to show results.

Click Show result.

To see each learner's progress in each of their courses, detail by Learners then Courses. To explore different results, change the order of the items.

In the Calculate field, choose Final Score. If needed, add other calculations.

Calculations are based on the selection in the Detail results field.

  • Score is the total number of points earned.

  • Final Score is the score divided by available points. Groups will show an average.

  • Completion is the number of completed activities divided by total activities. Groups will show an average.

  • First Access is the earliest access date for the selection.

Click Download results.

Calculating CEFR for HiringBranch Courses

All HiringBranch courses are CEFR-rated. To calculate the CEFR rating for a HiringBranch course:

Open the downloaded CSV in Excel.

To the right of the table, create a new column, titled "CEFR"

Copy the entire formula below:

=IF(ISNUMBER(MATCH("*Profession*",INDIRECT(ADDRESS(ROW(),1)&":"&ADDRESS(ROW(),COLUMN()-1)),0)), LOOKUP(HLOOKUP("*finalScore*", INDIRECT("A1:"&ADDRESS(ROW(),COLUMN())), ROW(), FALSE),{0,0.2,0.5,0.7,0.9},{"A2 or below","B1","B2","C1","C2"}), LOOKUP(HLOOKUP("*finalScore*", INDIRECT("A1:"&ADDRESS(ROW(),COLUMN())), ROW(), FALSE),{0,0.5,0.7,0.9},{"A1","A2","B1","B2"}))

Paste the formula into the new column:

The CEFR level will display for each learner, based on their final score, for both preparation and performance-level HiringBranch courses.

Note that CEFR level is valid only for complete and unmodified HiringBranch courses. CEFR level is not valid for orientation courses, partial HiringBranch courses or other custom courses.

Did this answer your question?