Introduction

This document describes requirements related to "Monitor Contribution Status" of Textbooks in a Program. Following diagram depicts L1 and L2 flows of the overall program driven content sourcing flow.

https://miro.com/app/board/o9J_ky31DBw=/?moveToWidget=3074457347134589331

JTBD

• Jobs To Be Done: As a Program Admin, I want to monitor the status of content contribution to the textbooks in the scope of the Program

• User Personas: The logged-in users who have State Admin role, Report Viewer role, Book Creator role, Book Reviewer role can access this report.

• System or Environment: Works on for desktops with Chrome browser only.

Requirement Specifications

Two reports defined below will help tracking the progress of content contribution for a specific Program scope.

Key Points applicable to all reports:

• Reports will include the latest information about all the Textbooks in the current scope of the Program.

• Provide the ‘As On’ status with aggregated information on specific attributes.

• The reports need to show only the version of that Textbook that is in the Program.

• All Reports detailed in following sections are extensions to the existing ETB Creation Reports that are showing up in portal dashboards page. All columns from existing ETB Creation Report should have the same functionality.

• Additional Columns are related to the number of contents categorized across the Content Types. These are the Content Types configured in the Program

• Each of the Report is downloaded as a CSV file with the given columns.

• This report should be updated on a real-time basis.

• This report is available only in the program dashboard.  

Reports Page

All the Reports and Graphs are accessed from "Reports" page of a Program. It is accessible by Program Admin, Report Viewer, Textbook Creators and Textbook Reviewers.

Reports Page displays Graphs and following options: "Download Summary Report" and "Download Detailed Reports".

Clicking on "Download Summary Report", downloads Summary Report as CSV

Clicking on "Download Detailed Report", downloads Detailed Report as CSV

Wire-frames

Open

Program Summery Report

Summary Report

• The report will include all the Textbooks which are in the specific Program scope

• Each Row of this report will be one Textbook

• Textbooks are sorted by Medium, Grade, Subject, Textbook Name (in that order).

• Name of the downloaded CSV file is <<uniqueid>>_<<program name>>_Summary

• Total QR Codes with content linked - These are the number of QR Codes in the Textbook with one or more content linked to the corresponding unit or its children

• Total QR Codes with no content linked - These are the number of QR Codes in the Textbook with no content linked to the corresponding unit or its children

• Total number of leaf nodes - Total number of units in the textbook without any unit under it

• Number of leaf nodes with no content - Total number of units in the textbook without any unit under it and with no content linked to it

Detailed Report

• The report will include all the Textbooks which are in the specific Program scope

• Each Row of this report will be one Node in the Textbook. This will be same as in current detailed report of ETB Creation Status Report

• All the Textbooks are sorted by Medium, Grade, Subject, Textbook name, Textbook chapter index level (in that order).

• Name of the downloaded CSV file is <<uniqueid>>_<<program name>>_Report

• Level 1, Level 2, Level 3, Level 4 Names - Names of the Textbook Units at level 1, 2, 3 and 4

Sample Report

Open

Open

Localization Requirements

NA

Telemetry Requirements

Non-Functional Requirements

Jira Ticket

https://project-sunbird.atlassian.net/browse/SB-16762

Impact on other Products/Solutions

ETB Creation Reports will continue as it is for all configured Tenants.

Impact on Existing Users/Data 

NA

Key Metrics