Performing maintenance on a sheets course can be a little tricky - read on for helpful hints.
How to Look for issues in a Sheets Course
Similar to any other course, you can start by logging in to the Content Dashboard and viewing your course metrics.
After reviewing the overall course rating and chapter metrics, move down to the Exercise ratings. Sort the exercises by ‘%Asked Hint’ or ‘%Asked Solution’ to isolate the exercises that need immediate attention.
Remember, a hint should generally get the learner halfway to the solution - so if an exercise has a high asked hint and asked solution rate,, there is likely an issue. Generally, we recommend that the ‘% Asked Hint’ be under 35%, and the ‘%Asked Solution’ should be under 20%.
See here for more information on expected course metrics, including chapter and exercise metrics.
How to Think about Resolving Issues
Unlike courses in Python, SQL, R, etc; there are no code diffs in the dashboard (meaning you cannot see what the user submitted. This means you will largely have to rely on learner feedback through the Issues messages, and your own exploration to locate the source of the problem.
Steps to take:
After selecting an exercise, start by reading through the Issues/Feedback provided. This will hopefully provide a clue as to whether the issue is technical (related to SCTs) or pedagogical (the learner did not understand the material or instructions.)
Whether feedback is provided or not, your next step should be to actually run the exercise to try to replicate the error.
If the solution runs correctly, try to walk through the steps the learner is taking. Are the instructions unclear in any way? Could more information be provided? Use the CHECK method to guide your analysis.
Other things to keep in mind:
You can also view the “Incorrect Attempts” tab for each exercise in the Dashboard. Although this will not show what the learner actually submitted, it can help isolate the most common SCT feedback message being given, and what percentage of learners are getting each type. This can help isolate the specific step that learners may be having trouble with.
Creating Changes in a Spreadsheets Course:
Spreadsheet courses work a little differently and require different steps to make edits.
After reviewing your course and determining what fixes need to be made, open an issue on Github and detail the changes you want made.
Assign the issue to @datacamp-contentquality for review.
Done! The Content team will contact you if any clarification is needed, and will implement the requested changes.
If you would like assistance in evaluating what maintenance needs to be done for your course, please create a Github issue describing the exercise and what you think might need to be done, and tag @datacamp-contentquality.