Exam Reports

Rachel.T.9262

Hey everyone! I am very new to D2L and our previous administrator recently left so I am trying to fill in. Our organization would like to create reports to see which of the exams in our programs are the most to least failed over a period of the last few years. With my limited understanding I am not able to find a way to make this happen.

Have any of you created a report that shows similar information?

Jon.K.955

I haven't, but depending on what you have access to - there's a couple of ways off the top of my head. The first is if you have Performance+, there's likely a report that exists there that the previous admin was running. If you don't have Performance+, you can use Data Hub to gather this information - there's a number of ways to gather grades information - if you're certain that all Quizzes/Exams run within Brightspace and have an associated grade item, then the Grades Results will be the first stop (and likely Org Units to get the course name rather than the OU code). If you don't know, then Quiz Attempts, Users and Org Units to make full sense of the Quiz Attempts CSV. From there it's mostly Excel magic and VLOOKUP to make a spreadsheet.

Justin.B.253

Rachel,

Are you just using the data from Data Hub or are you wanting to build a custom report using Analytic Builder?

Rachel.T.9262

It sounds like Data Hub is what was being used before, but I am open to using Analytic Builder if it is more likely to do what we need.

Justin.B.253

Rachel,

I did a sample using the Quiz Attempts data set in Data Hub. For my sample, I ran the Differential Data Set because it's a much smaller data file. I then used my friend, ChatGPT, since I'm not using student data and asked it to group by QuizId and then count all the UserIds that attempted that QuizId and then calculate the average score based on the Score vs PossibleScore. Below is a sample result. You would then need to match this report to other reports that could change the OrgUnitId to a Course Code or Course Name and a QuizId to a Quiz Name.

You could do this same thing in Analytic Builder, a custom app to run in Brightspace that pulls API calls or build a Python script to do the same thing with a few Data Hub reports.

But it's possible, I think, to do what you are asking. For us, I would not be able to do the full report and manage this through Excel since we have data that is 10 years old sitting in our system. I would need to do this in Analytic Builder or a custom-built app.

Rachel.T.9262

Thank you for all the information! I will give all of these a try!