Project Summary
To Develop an Integrated University or Educational Management and Decision Support System as an Enterprise Resource Planning Suite. We have an aim and that is to have a Single Database and a single Application to access the same from any where as far as possible to manage all our activities. For a more detailed explanation please refer to the Product Features List.
Key Words
ERP, Education, University, College, School, Tutorials, Software
Introduction
Setup a centralised Database that is robust enough to encompass the different activities of an Educational Institution of any Size in any Vertical. Have a simple and a robust Application that shall allow us to access this Database from any part of the World with Security measures incorporated and Access to the Specified Persons with functions specific to their activities. Related reports and information will be shared between Different Departments that are customised and are of a practical utility.
Origin Of Proposal
By Our Experience and Observation we have found that not many Applications are available that try to provide an End to End Solution for an Educational Organisation at least in India and even if they are available at present they are not a common feature in Government Schools, Remote Areas and all Private Institutions.
Problem Definition
To have a Common Standard for Database Architecture so that it can be Shared across many different Levels in the Organisation and the External Environment like Government, Funding Agencies, Tax Authorities etc for Decision making and a General Harmonious and Higher Progress.
Work plan
We will be starting with MS SQL Server as a Database, C# as Code Behind language and MVC.net with HTML as the Front End to start with and Development on other Databases and other Languages at a later stage depending on the Demand and need of the Technology.
Project Information
Review and Status of Research and Development in the Subject
Project Features / Product Catalog
Accounts
- Account Group
- Account Section
- Bank Account
- Course Acedamic Duration Fee
- Expense
- Expense Type
- Fee Income Split
- Fee
- Fee Type
- Income Head
- Income Head Type
- Tax Duty
- Tax Type
- Payment Issu Parent
- Payment Mode
- Payment Rcpt Parent
- Asset Block
- Asset
- Asset Type Tax Config
Acedamic Section
- Course Content Type
- Emp Subject Config
- Chapter
- Class Period
- Class Room Student Alloc
- Contact Projects
- Content Subject
- Course Class Room
- Course Duration Subject Config
- Course
- Course Time Table
- Course Type
- Education Vertical Type
- Graduation Level Type
- Qualification
- Short List
- Study Field
- Subject
- Subject Type
- Syllabus
- Unit
Administration
- Affiliated Institutes
- Dept Facility
- Dept
- Document Type
- Duration
- Facility
- Facility Type
Applications Related
- Application Doc Rcpt
- Application Exam Config
- Application Issu
- Application Issu Rcpt Dates
- Application
- Application Type
- Appllication Doc Reqt
Admissions
- Admn Eligblty Crit Chk Parent
- Admn Eligblty Crit Parent
- Admn Eligblty Reject
- Course Admission
- Course Admn Short List Details
Attendance
- Attendance Register
Calendar
- Calendar Events Det
- Holiday
- Holiday Type
- Yearly List Of Holidays
Contacts Management
- Caste
- Contact Addr
- Contact Category
- Contact Group
- Contact Hobbies
- Contact Languages
- Contact
- Contact Multiple Roles Det
- Contact Qualifications
- Contact Skills
- Contact Type
- Hobby
- Quota Caste Allocation
- Quota
- Skill
- Skill Type
Elections
- Election
- Election Parent
- Election Type
Maintenance
- Priority Type
- Repair Maint
- Repair Maint Type
- Std Repair Maint Item Service Config
- Asset Repair Maint
Notification
- Meetings
- Meeting Type
- Notification Reminder Config
- Notification Reminder
- Notification Reminder Type
Event Management
- Event
- Event Role
- Event Type
- Sub Event
Language
- Language
- Language Type
Feedback
- Survey Answer Bank
- Survey Opinion
- Survey Opinion Parent
- Survey Opinion Type
- Survey Question Bank
Library & Archives
- Publication
- Publication Type
Location
- City
- Country
- District
- State
Exams Section
- Answer Bank
- Exam
- Exam Paper Re Valun Subject Det
- Exam Paper Valuation
- Exam Paper Valuation Plan Det
- Exam Paper Valun Plan
- Exam Paper Valun Remun
- Exam Time Parent
- Exam Time Table
- Exam Type
- Online Obj Exam Parent
- Question Exam Paper
- Ques Ans Paper Issu Rcpt
- Question Bank
- Question Paper Model
- Question Paper Rcpt Parent
- Question Paper Set Req
- Question Paper Type
- Question Type
- Model Answer
- External Answer Paper Rcpt Parent
Human Resource Dept
- Employee Benefit
- Employee Benefit Type
- Employee Cur Sal Comp
- Employee Cur Sal Deduct
- Employee Deduct
- Employee Deduct Type
- Employee Group Benefit
- Employee Group Deduct
- Employee Group Leave Type
- Employee Group Sal Comp
- Employee Leave
- Employee Leave Open Bal
- Employee Leave Register
- Employee Leave Type
- Employee Loan Apply
- Employee Loan Disburs
- Employee Loan Purpose
- Employee Log Details
- Employee Config
- Employee Contribute
- Employee Sal Advance
- Employee Sal Comp
- Employee Sal Comp Type
- Employee Sal
- Employee Sal Parent
Inventory Management
- Asset Block Alloc Det
- Asset Block Type
- Asset Class
- Asset Type
- Issu Parent
- Item Category
- Item Group
- Item
- Item Property Fixed Sub Type
- Item Property
- Item Property Sub Type
- Item Property Sub Type Values
- Item Property Type
- Item Store Shelf Stock
- Item Sub Type
- Item Type
- Shelf
- U O M
Purchase
- P O Parent
- Pur Parent
- Quote Parent
- Terms
Security
- User Type
- User Type Report Privilages
- User Type Privilages
Reports
- Report Builder
- Report
- Report Type
Research
- Journal
- Observation Type
- Project
- Project Type
- Researchers Det Guide
- Research
- Research Record
- Research Type
Scolarships
- Scolarship Aggr Eligblty Det
- Scolarship Doc Reqt
- Scolarship Eligblty Crit Det
- Scolarship
- Scolarship Type
Sports
- Sports Property Sub Type Values
- Game Type
- Sports
- Sports Property Sub Type
- Sports Property Type
- Sports Property Type Values
- Sports Type
- Team Sports Record Det
System Admin
- Data Entry Mode
- Menu
- Menu Type
- Module
- Module Table Details
- Org Education Vertical Config
- Owner Addr
- Trans Type
- Table Rec Year Serial No
- Table
- Team
Sample Entity Relationship Diagram
Sample Entity Relationship Diagram
Time Schedule of Work Plan
| Sl No | Broad Work Element | Time Estimates In Months |
| 1 | Developing a Core Team who can type in all Languages that are used in India, These people will be developing the Resources Files that will be necessary so that users are comfortable in using the Education ERP. | 2 |
| 2 | Developing a Simple Call Center that can explain the process that is to be employed for running and using the ERP, the same team will train other Startups to make sure that they will lend support for Teachers and other users who will be given adequate support as and when necessary. | 3 |
| 3 | We will be further Developing and Implementing an application that is nearly ready along with Design Rights to modify the Database and Front End so that new Versions can be developed for different Verticals of Education in the near future. | 2 |
| 4 | We will need Data Entry Operators who can completely segregate the Data initially for the States or may be for the Central Syllabus so that we can ensure that all Content will be mapped to the Sections and the Chapters, this is a massive work and may need more resources. | 3 |
| 5 | In short the Application software must support all the Core Functionalities that are necessary to Run an Educational Organisation. | 2 |
| 6 | For a more detailed Explanation please refer to the Product Features. | 1 |
| 7 | Prime Importance will be to Develop an Implementation Methodology for Each one of the Educational Institutes, for Ex. One possiblity will be first to have a common Software with All Data Support and Language Support for all State Government Run Schools so that Quality of Education imparted is uniform irrespective of their location. | 1 |
| 8 | Next Step once the First version is built successfully Implemented at least in One School in each one of the States in the whole of our Country. | Need to Workout Details |
Minimum Group Organisation
| Sl No | Group Code | Position Description | No Of Posts |
| 1 | 1 | Testing Administrator | 1 |
| 2 | 2 | Assistant DB Architect | 4 |
| 3 | 3 | Internal User Interface Administrator | 1 |
| 4 | 4 | Data Mapper Administrator | 2 |
| 5 | 5 | Process Experts | 2 |
| 6 | 6 | Programmers | 10 |
| 7 | 7 | Accountants | 1 |
| 8 | 8 | Process Designers | 2 |
| 9 | 9 | Internal Marketing Administrator | 1 |
| 10 | 10 | Internal Project Manager | 1 |
Suggested plan of action for utilization of Research Outcome Expected from the project
We are planning to Tie Up with Ramakrishna Mission Vivekananda Educational and Research Institute http://rkmvu.ac.in/ so that they can maintain the Entire Design, Source Code and Related Documentation necessary for it to Survive and Grow or Tie up with Microsoft Corporation / Microsoft Foundation so that A Team can be formed to Ensure that these Services and Upgrades are available to All Organisations in India freely to Develop and Enhance but not to Voilate the Set Statuatory and Predefined Standards.
Budget Estimates: Summary
| Item | BUDGET | (in Rupees) | |||
| 1st Year | 2nd Year | 3rd Year | Total | ||
| A. | Recurring | ||||
| Salary Expenses | 67500000 | 74250000 | 81675000 | 223425000 | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 | |
| Travelling Expenses | 2400000 | 2640000 | 2904000 | 7944000 | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 | |
| B. | Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
| Grand Total (A+B) | 72600000 | 79860000 | 87846000 | 240306000 |
Budget for Salaries/Wages
| Position Description | No Of Posts | Monthly Emoluments | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |||
| Testing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Assistant DB Architect | 4 | 250000 | 12000000 | 13200000 | 14520000 | 39720000 |
| Internal User Interface Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Data Mapper Administrator | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Process Experts | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Programmers | 10 | 200000 | 24000000 | 26400000 | 29040000 | 79440000 |
| Accountants | 1 | 125000 | 1500000 | 1650000 | 1815000 | 4965000 |
| Process Designers | 2 | 250000 | 6000000 | 6600000 | 7260000 | 19860000 |
| Internal Marketing Administrator | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Internal Project Manager | 1 | 250000 | 3000000 | 3300000 | 3630000 | 9930000 |
| Totals | 67500000 | 74250000 | 81675000 | 223425000 |
Budget for Consumable Materials
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Printing and Stationery | 300000 | 330000 | 363000 | 993000 |
Budget for Travelling Expences
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Travelling Expenses | 2400000 | 2640000 | 3630000 | 8670000 |
Budget for Other Expenditures
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Others | 2400000 | 2640000 | 2904000 | 7944000 |
Budget for Equipment If Applicable
| Item | BUDGET | (in Rupees) | ||
| 1st Year | 2nd Year | 3rd Year | Total | |
| Equipment To be Built If Applicable | 0 | 0 | 0 | 0 |
Infrastructural Facilities
| SrNo | Infrastructural Facility | Status |
| 1 | Workshop Facility | Yes – Sharing basis |
| 2 | Water & Electricity | Yes - Sharing basis |
| 3 | Laboratory Space/ Furniture | Yes - Sharing basis |
| 4 | Power Generator | No |
| 5 | AC Room or AC | No |
| 6 | Air Cooler If Tempratures are too High | Yes |
| 7 | Telecommunication including e-mail & fax | Yes |
| 8 | Transportation | Yes |
| 9 | Administrative/ Secretarial support | Yes – Sharing Basis |
| 10 | Information facilities like Internet/ Library | Yes – Sharing Basis |
| 11 | Computational facilities | Yes – Sharing Basis |
| 12 | Animal/ Glass House | No |
| 13 | Any other special facility being provided | Not Required |
Equipment available with the Institute/ Group/ Department/ Other Institutes for the project
| Sl No | Equipment Available | Generic Name Of Equipment | Qty Available | Model Make And Year Of Purchase | Remarks Including Accessories Available And Current Usage Of Equipment |
| 1 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 2 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
| 3 | With Group | Laptops | 1 | 2016-2016 | 60% capacity utilisation |
