Introduction

Currently, there is an existing dashboard to monitor the course progress. This dashboard has to be enhanced to include the Assessment score details of users per batch within a Course. Also there are couple of enhancements to be done to the existing course dashboard for a more user intuitive and seamless experience

When Courses are launched in a state, there should be a mechanism for the state to monitor the quality of content at question level. State would want to gauge the chapters that were easy for users to consume versus contents that were difficult. Each unit/chapter in every course in general has an Assessment associated with it Hence, one way of understanding the content quality would be to see the Assessment scores of users in each course. This would give some insights on whether the chapter was interesting/complicated/easy so that additional help/guidance may be provided to those users who are stuck in one or more chapter/unit to complete the same. Also, State would want to update the contents to make it more easy when it is launched next time

 JTBD

Use Case - Overview

To enable State to monitor the Assessment scores of users with in a batch for a Course

To include "External ID" to the existing grid view

To rename "Download" to "Progress Report"

Epic JIRA Ticket ID:

SB-13497 - Getting issue details... STATUS

User Story 1- Assessment Score Report

As a State Admin, I would want to be able to download "Score Report" for a batch within a Course, So that I can identify the pain points through the Assessment score and help/guide the teachers with course completion

Pre-conditions: 

1. The logged in user has access to view course dashboard
2. Batch is not expired
3. Logged in user has clicked "View Course Dashboard" from the course TOC

Acceptance criteria:

Verify that the user is able to

Main work flow

1. View a new link called "Score Report"
2. Download "Score Report" as a CSV
3. View the below details in the CSV 
   1. External ID 
   2. User ID
   3. User Name
   4. Email ID
   5. Mobile Number
   6. Organisation Name
   7. District Name
   8. School name
   9. Assessment Name (This refers to the Worksheet/Question set which in turn could have multiple questions)
      1. Display all the Assessment names in the course. Also, show the maximum possible score for each Assessment to the user on the UI. If the Course has "x" Assessments in total, "x" columns should be displayed
      2. Display individual score for each Assessment under the corresponding Assessment name. Formula - (Number of correct answers*max score per question)/Total number of Questions (attempted + un attempted)*max score for each question
      3. Score for a an Assessment is always the latest score 
      4. Score for a question is also, always the latest score
      5. The score for any question within the Assessment, that is not attempted is considered as zero
   10. Total Score - Sum of all individual Assessment scores (Eg: 2/3+3/4+2/3=7/10) 
   11. Rename the existing "Download" link to "Progress Report". All the other functionalities related to this report remains the same 

Alternate work flow

None

Exceptional Workflow

If any of these fields do not have a value leave it as blank in the CSV file

Refer the below sheet for score calculation for different scenarios ("New" sheet)

https://docs.google.com/spreadsheets/d/14pzsIdnVo0pk1HaRX5TX2WQaPGpAjmVwGg5f0J1x1-0/edit#gid=0

UI Reference:

JIRA Ticket ID

SB-13498 - Getting issue details... STATUS

User Story 2 - Include "External ID" to the existing Course dashboard grid view

As a State Admin, I would want to add "External ID" to the existing course dashboard grid view, So that i can get more targeted information to drive completions

Pre-conditions:

1. The logged in user has access to view course dashboard
2. Logged in user has clicked "View Course Dashboard" from the course TOC

Acceptance criteria:

Main work flow

Verify that 

1. "External ID" is added to the current grid view. External ID is the state ID provided by state for a teacher. This will be available if a user is on boarded through SSO or API. For a self signed up user, this field would be blank  
2. "External ID" is the first column in the grid view 

Alternate Workflow

None

Exceptional Workflow

       If this field do not have a value, leave it as blank in the CSV file.

JIRA Ticket ID

SB-13530 - Getting issue details... STATUS

User Story 4 - Assessment Score to show in % in the CSV

JIRA Ticket ID

SB-16674 - Getting issue details... STATUS

Context
The current Score report when downloaded converts the text/score into date format. Also, we have the actual score and the maximum score displayed one below the other (eg: 4/10), which is not a very good user experience. The State would want to do various computations with the scores to make timely and meaningful decisions. Hence this score information needs to be displayed in %, so that the State Admin can interpret the score easily

As a State Admin, I would want the score to be displayed in %, So that it is easier for me to interpret easily and make meaningful decisions

Pre-conditions

1. Logged in user has access to view Dashboard
2. Batch is selected
3. User has clicked "Score Report"

Acceptance criteria

Verify that

Main workflow

1. The user's individual Assessment score is displayed in percentage

   1. Formula - (Assessment score/Max Score)*100

2. The user's total score is displayed in percentage

   1. Formula - (Sum of all Assessment scores/Sum of all Max scores)*100

Exceptional workflow

1. The earlier score reports generated in x/y format should also get converted and rounded off

Localization Requirements

Telemetry Requirements

Non-Functional Requirements

Impact on other Products/Solutions

Impact on Existing Users/Data 

Key Metrics