/Academic_Request_System

Open Source Database System for Academic Institutions for handling student requests. This is the first iteration of Academic Request System developed at Indian Institute of Technology Gandhinagar.

Primary LanguageJavaScriptMIT LicenseMIT

Academic Request System v1.0

An open source database system

Overview

The Academic Request System is a web-based application designed for college academic offices. It streamlines the process of handling and managing various academic requests, such as transcript requests, grade reports, and more.

Features

  • User Authentication: Secure login system.
  • Dynamic Forms: Customizable forms for different academic requests.
  • Email Notifications: Automated emails for request updates.
  • Data Management: Requests are processed and stored efficiently.
  • Responsive Design: Compatible with various devices.

Technology Stack

  • Backend: Node.js, Express.js
  • Frontend: EJS, JavaScript, CSS
  • Database: Google Sheets
  • Other Tools: Google APIs, Nodemailer

Installation

  1. Clone the repository.
  2. Install Node.js and npm.
  3. Run npm install to install dependencies.
  4. Set up Google API credentials and update the credentials.json file.
  5. Start the server with node index.js.

Usage

For Students and Academic Members

  • Run the System: Initial screen upon starting the application. Run System

  • Login with Institute Credentials: Securely access the system using your institute credentials. Login

  • Select an Academic Request: Choose and search for the type of academic request you need. Select Request

  • Submit the Request: Fill out and submit the necessary forms for your request. Submit Request

  • Receive the Request Token: A ticket is generated once the form is submitted. Request Token

  • Tracking the Request Status: Stay updated with email notifications and online status tracking. Track Status

For Admin Users

  • Admin Login: Admins can log in to access comprehensive data and management tools. Admin Login

  • View and Manage Database: Admins have full access to the academic member database. Email Update

  • Closing Requests: Process the requests by updating their status. Automated notifications are sent upon status changes. Close Request

  • Email Updates to Students: Students receive email updates on the status of their requests. Status Changed

Contributing

Contributions to the project are welcome. Please follow the standard GitHub pull request process.