Course Enrollment Report
Background
Purpose of this report is to show the course wise enrollment numbers.
Users from any tenant can enrol into an open course batch. In this report only include teachers who belong to the same tenant ID as the report viewer’s tenant id.
Proposed Solution:
Report title: Enrollment Report by Course
X-axis: No. of enrollments
Y-axis: to have individual course names organised alphabetically
Type of Graph :will be horizontal bar graph.
Course Enrollment Report: Sample Config JSON
{
"id": "api.report",
"ver": "1.0",
"ts": "2019-04-25 13:54:53:905+0530",
"params": {
"resmsgid": "9a2b9010-6733-11e9-a5f9-a9ba66dcacb1",
"msgid": null,
"status": "success",
"err": null,
"errmsg": null
},
"responseCode": "OK",
"result": [
{
"id": "course_enrollment_report",
"label": "Course Enrollment Report",
"title": "Course Enrollment Report",
"description": "Reports related to show the course wise enrollment numbers,to show the enrollments by course as a timeline graph, to show the enrollments by district.",
"dataSource": "/reports/sunbird/daily_metrics.json",
"charts": [
{
"datasets": [
{
"data": [
"54814",
"51356",
"67348",
"176538",
"214892"
],
"label": "Enrollment Report by Course"
}
],
"colors": [
{
"borderColor": "rgb(1, 184, 170)",
"backgroundColor": "rgba(2, 79, 157, 1)"
}
],
"labels": [
"English Training Program",
"Physical Science Training Program",
"Maths Training Program"
],
"chartType": "horizontalBar",
"options": {
"scales": {
"yAxes": [
{
"scaleLabel": {
"display": true,
"labelString": "Course Name"
}
}
],
"xAxes": [
{
"scaleLabel": {
"display": true,
"labelString": "No of enrollments"
}
}
]
},
"tooltips": {
"intersect": false,
"mode": "x-axis",
"titleSpacing": 5,
"bodySpacing": 5
},
"title": {
"fontSize": 16,
"display": true,
"text": "Course Enrollment Report"
},
"legend": {
"display": false
},
"responsive": true
}
}
],
"table": {
"columnsExpr": "keys",
"valuesExpr": "tableData"
},
"downloadUrl": "/reports/sunbird/course_enrollment.csv"
}
]
}
Course Timespent Report
Background
Purpose of this report is to show average time spent on the courses at district level.
Proposed Solution:
Report title: Time Spent Report by District
X-axis: Avg time spent (mins)
Y-axis to have individual district names organised alphabetically
Type of Graph :will be horizontal bar graph with legend .
Course Timespent Report : Sample config.json
[
{
"id": "Time Spent Report By District",
"label": "Time Spent Report By District",
"title": "Time Spent Report By District",
"description": "Reports related to show the course wise enrollment numbers,to show the enrollments by course as a timeline graph, to show the enrollments by district.",
"dataSource": "/reports/sunbird/course_enrollment.json",
"charts": [
{
"datasets": [
{
"dataExpr": "data['Avergae Time spent']",
"label": "English Training program"
},
{
"dataExpr": "data['Avergae Time spent']",
"label": "Physical Science Training Program"
},
{
"dataExpr": "data['Avergae Time spent']",
"label": "Maths Training Program"
}
],
"colors": [
{
"borderColor": "rgb(242, 203, 28)",
"backgroundColor": "rgba(2, 79, 157, 1)"
},
{
"borderColor": "rgb(55, 70, 73)",
"backgroundColor": "rgba(255, 0, 0, 1)"
},
{
"borderColor": "rgb(55, 70, 73)",
"backgroundColor": "rgba(242, 203, 28, 0.2)"
}
],
"labelsExpr": "data.District",
"chartType": "horizontalBar",
"options": {
"scales": {
"yAxes": [
{
"scaleLabel": {
"display": true,
"labelString": "Name Of District"
}
}
],
"xAxes": [
{
"scaleLabel": {
"display": true,
"labelString": "Avg time spent(mins)"
}
}
]
},
"tooltips": {
"intersect": false,
"mode": "x-axis",
"titleSpacing": 5,
"bodySpacing": 5
},
"title": {
"fontSize": 16,
"display": true,
"text": "Time Spent Report By District"
},
"responsive": true
}
}
],
"table": {
"columnsExpr": "keys",
"valuesExpr": "tableData"
},
"downloadUrl": "/reports/sunbird/avg_time_spent_report.csv"
}
]
Sample: course_enrollment.json
{"id":"api.report","ver":"1.0","ts":"2019-04-26 13:42:33:912+0530","params":{"resmsgid":"0b835780-67fb-11e9-a849-43872b42b8e5","msgid":null,"status":"success","err":null,"errmsg":null},"responseCode":"OK","result":{"data":{"District":["East Godavari","West Godavari","Krishna"],"Avergae Time spent":["0","500","1000","1500"]}}}
ScreenShot: