Hello everyone, I am new to using Aspect analytics and I want to create a chart that shows me course learners’ progress. Could anyone help me?
@HeliaEnayati - Thank you for your question! First, I’m curious about exactly what progress information you are interested in seeing for your learners? Is it where they are in the course? What percentage of graded content they’ve submitted? Something else?
Do you need to see this for all learners in the course or a specific learner at a time? How will this chart help you in your work/how do you plan to use this information? (This will help me understand how users like yourself might need to consume this data).
And finally, are you a member of a course delivery team? Or are you a developer at your organization?
@HeliaEnayati forum mod here! Just letting you know, I’ve moved your question to the Data WG topic. When posting it can be helpful to choose an appropriate topic, so people watching only certain forums sections see it.
Thank you for your response. I am aware that I can view the progress of individual course users through the instructor dashboard, but as far as I know, it is primarily on a one-by-one basis.
What I need is a comprehensive chart that displays the progress percentages of all
the learners in my courses.(The same percentages displayed for each user in their progress tab) While I understand that I can obtain a .csv file and view grades from the Instructor dashboard, my goal is to have a chart from Aspect, that illustrates each learner’s progress percentage
and the grades they have received.
I am a QA at one of the Open edX partner organizations.
Thank you
@HeliaEnayati - Excellent - thank you for your detailed response. I am not 100% certain if this is entirely possible to date as I think there may be some backend work needed to make what you need possible to do. I’m curious if you have a sense of how this data might be used and by whom (if you can share - I’m a product manager newer to the Open edX platform, so any data community members are willing to share can be helpful).@BrianMesick - Am I right in assuming this?
Hi @HeliaEnayati, I think the short answer is that it is possible to do this but with some caveats. We started down this path for Aspects and decided not to do it for our version 1 because there is a lot of confusion and dislike of the way the completions are handled for the green checks within the community. They are generally considered to be an inaccurate measure of course completion since they don’t capture all blocks and some of the measures of completion are weird (like HTML block completion being triggered by just having the block loaded for a few seconds).
That said, I do know it’s the best we have right now and part of what I am working on with @jill for the conference is related to getting this data in a better format. To get what I think you’re looking for you would need to take the data from the xapi.completion_events
table and map the most recent progress_percent
for each user to the blocks in the event_sink.course_blocks
table for the course which are marked as completion_mode: completable
or completion_mode: ""
in the xblock_data_json
field.
I think that to find total course completion you would take the number of completable blocks from above * 100 and divide it by the sum of the user’s most recent completion percentages for those blocks. You should be able to do the same thing at the section and subsection level since the blocks have that as part of their data.
Since we aren’t currently using the data in completion_events
I can’t guarantee that this is entirely correct, but I’m happy to help you work through any issues. In the future we’re hoping to integrate Aspects with this tool to simplify all of this: GitHub - open-craft/openedx-completion-aggregator: An Open edX Django app that aggregates block-level completion data to report on different block types.
@Chelsea_Rathbun I’ll be glad to share the details with you. This is a requirement from one of our potential customers. They didn’t specify why they need this or how they will benefit from it but I can ask around and clarify it.
@BrianMesick Thank you for the detailed response. I will try to make it work and update you on the results.
@HeliaEnayati - Excellent - if you are able to gather any details on how this client envisions using this info, I’d be happy to have the input. Feel free to reach out to me either here or in our #aspects channel in slack.