Skip to content

Provide for a UI interface to generate Excels similar to project templates for creators #30

@aks30

Description

@aks30

Project Details

Project/ Programs is a mobile application that enables one to take up micro-improvements in a planned manner.

With Projects/Programs, any person can define and schedule improvement tasks and work towards achieving it in a planned trackable way. One can create a program and include

  1. Observations/ Surveys which help one to identify the improvement areas
  2. Learning resources
  3. Projects - To plan the journey of improvements with scheduled, trackable tasks.

This feature is widely used on Diksha at the Centre/State/District Level for improving the Leadership of the Education Leaders of the Country.

As of today references or templates of such Programs/Projects are created on the platform happens using Excel spreadsheets. Program Managers use templates(Excel spreadsheets) to create the data and it’s uploaded to the platform by the Implementation team. As the usage of this feature is increasing, a user interface that is user-friendly, less error-prone, and minimizes the intervention of the Implementation team is a dire necessity.

This project is about creating a user interface that would be used for generating solutions as per the Excel templates of programs and projects. These Excel files are validated with the rules engine of the current validation portal and the output from this interface will be a validated spreadsheet, ready for upload as a solution.

Features to be implemented

  1. Develop a configurable user interface on the lines of PWA (ionic), the output of which would be Excel files in compliance with the templates.
  2. The Web application will have the following capabilities/features
  • Integration with the existing rules engine to validate the user inputs
  • Display the error messages and allow the user to correct and resubmit the correct template.
  • Upload the validated template to the platform.

What exists

  1. Templates ( Excel Spreadsheet with built-in validations ) - https://docs.google.com/spreadsheets/d/1YnWTcHrmvDYVedGktKr2V25G7qBNUmYjwk1huHwGwNc/edit#gid=65026616
  2. Rules Engine Service- https://github.com/ELEVATE-Project/template-validation-portal-service

What needs to be built

  1. The User Interface for the capturing all the data required for creating Programs/Projects

Learning Path

Complexity
Medium

Skills Required
MongoDB, NodeJS, Angular, Ionic, HTML, CSS.

Name of Mentors:
@Adithya

Project size
8 Weeks

**Product Set Up Guide - **
Service setup and Portal setup

Acceptance Criteria
A portal that helps users generate Excel files same as here - https://docs.google.com/spreadsheets/d/1YnWTcHrmvDYVedGktKr2V25G7qBNUmYjwk1huHwGwNc/edit#gid=65026616

Out of Scope

Milestones

  • Understand the program and project template.
  • Program Template
  1. Create an interactive UI for Resource Details with validations.
  2. Create an interactive UI for Program Manager Details with validations.
  3. Create an interactive UI for Program Manager Details with validations.
  4. Generate Excel templates with the data captured.
  • Project Template.
  1. Create an interactive UI for Project upload with validations.
  2. Create an interactive UI for Tasks upload with validations.
  3. Create an interactive UI for Certificate details with validations.
  4. Generate Excel templates with the data captured.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions