In this article we show an example of how you can use the Event hub to collect data and create charts that highlight various statistics and trends.
Note: In order to start collecting these events we must first capture these events and feed them into a data store (in this instance we will be using a spreadsheet). You cannot create these type of reports retrospectively so the sooner you start capturing event data, the sooner you will be able to start analysing it.
Learn more: This article shows you what's possible, but for the "how-to" please use these detailed instructions on how to use the Event Hub with Zapier.
Example charts you can create with the Marked an assessed task event
The Marked an assessed task event is fired each time a facilitator or coach marks a learner’s assessed task. Once a suitable period of time has elapsed you will be able to interrogate your data. The following examples show the variety of reports that can be generated from this one event.
Throughout this article we will referring to an example spreadsheet that contains a template, example data and charts.
Example 1: Distribution of marks
Here we are interested in the results of our learners and the spread of marks. In order to visualise this we want to create a histogram that charts the frequency of marks in selected ranges (or ‘buckets’).
Note: This example assumes your mark is based on numbers. If your marking method uses "Incomplete/Complete" or similar you would need to convert your marks into numbers first.
Select the column containing your marks.
Go to Insert > Chart.
Change the chart type to Histogram.
Change the bucket size to something that suits your marking scheme. For example, if your marks are from 0-100 then you could use a bucket size of 10 to create 10 different ranges.
Tidy up the names of the chart and axes as desired.
Your chart should be similar to this:
This is taken from the example spreadsheet linked above and can be found in the sheet Chart: Distribution of marks. In this example, it shows that the highest frequency of marks could be found under the 60-70 range.
You could also filter your data to include only specific assessments such that you could compare marks across different assessments.
Example 2: Facilitator workload
You may also be interested in how many assessments facilitators have been marking in order to judge workload.
Select the column containing the last name of your facilitators.
Go to Insert > Chart.
Change the chart type to Column.
Tidy up the names of the chart and axises as desired.
Your chart should be similar to this:
This is taken from the example spreadsheet linked above and can be found in the sheet Chart: Facilitator workload. In this example, it shows that the facilitator with the last name Singh had marked the largest volume of assessments.
Example 3: Marking activity by month
You may want to know what the distribution of marking work was completed over a fixed period of months.
Although we do not have the data in the direct form of a month, we can create it easily enough using Timestamp.
Create a new column in your sheet called Month. (In our example spreadsheet we have used a separate sheet for this column called Calculated data.)
Utilise the formula =TEXT(timestamp, ”MMM”) in your new column where timestamp is the relevant cell containing the timestamp of the event.
Select the Month column.
Go to Insert > Chart.
Change the chart type to Column.
Tidy up the names of the chart and axises as desired.
Your chart should be similar to this:
This is taken from the example spreadsheet linked above and can be found in the sheet Chart: Marking activity by month. In this example, we can see that the largest volume of assessments was marked in February.
The use of months is just an example in this instance, you could use whatever time categories fit your level of analysis e.g. weeks, quarters or years.