Monitoring the progression of learners is paramount. Tracking individual and group achievements, journeys and programme completion rates allows admins to gain insights, refine courses, and personalise learning experiences.

This article focuses on exporting progression reports. Visit the help article for getting information on the data visualisations on this progression reporting page.

Start by navigating to the new Progression Export page with a 'beta' tag in Control.

Step 1: Select the content type. On what level do you want to report: activities, journeys, or programmes?

Step 2: Filter for specific data—the filters are dynamic depending on the type of export you selected.

Step 3: Select your template

Step 4: View the summary and export
Before exporting, review a summary that outlines the number of users and activities in your chosen export. If all seems in order, click the 'Export' button.

Step 5: Retrieve your export
Navigate to the 'Export' page (xxx.platform.co.nl/control/#/insights/exports), where your freshly minted export awaits download. Refresh the page if the export is not yet ready.

The export package will include three, four or five data sheets depending on your selection:

The direct filter options might seem limited when dealing with exports where all groups are listed in a single column. However, you can still leverage Excel's text filters to refine your data efficiently. For instance, using the "contains" text filter allows you to isolate and analyse data for users belonging to specific groups, enhancing your ability to draw insights from the raw data.

Excel allows you to perform custom sorts beyond the basic alphabetical or numerical order. For example, you can sort data based on specific criteria such as progress status (e.g., Not Started, In Progress, Completed) or by custom group priorities. This can help you quickly identify trends or areas that require immediate attention.

When you’re working with information in different sheets, sometimes you need to bring data from one sheet into another to see everything together. This can sound tricky, but there’s a simple tool in Excel and Google Sheets called VLOOKUP that helps you do just this. Let’s break it down into easy steps, using an example where we want to see a person’s "Status" next to their name on a main list.

Step 1. Go to the main sheet: This is the sheet where you want to see the combined data. Let’s say it’s the "Progress per user" template.

Step 2. Click where you want the data: Find the column where you want the new data to appear. Suppose you want to see "Status" from #Users next to each person’s name. Click on the top empty cell in that column.

Step 3. Type in the magic formula: Here’s a simple formula you can use. Don’t worry; just follow the pattern:

Step 4. Drag down to fill: After typing the formula in the first cell, there’s a little square at the bottom right corner of the cell. Click on this square and drag it down to fill in the rest of the cells in the column. This copies the formula to other rows.