Development of Paperless Load Allocation Tool for Hod Using Linked Google Spreadsheets

In any academic institute teaching load allotment for the next academic session is a tedious job of the Head of Department (HOD).The process involves steps from database creation, faculty preferences, and allotment by HOD till fulfilling of complete departmental load without overloading any faculty. During the process of actual allotment HOD needs to constantly update the load of each faculty in all the related documents so that final tally is made and time table can be prepared based on the allotted load. As number of faculty and teaching load increases handling of paper documents becomes cumbersome.

The paper presents case study of use of linked Google spreadsheets as a useful tool to HOD in an Autonomous institute in University of Mumbai. HOD can manage the entries in all sheets to complete the process without worrying about missed or wrong entries. Use of this ICT tool reduces time, errors in entries and usage of paper.