Publication Date

Spring 2016

Document Type

Project Summary

Degree Name

Master of Science


Computer Science

First Advisor

Soon-Ok Park, Ph.D.

Second Advisor

(Clare) Xueqing Tang, Ph.D.

Third Advisor

Neng-Shin Chen, M.S.


GSU class schedule can be printed or saved as a text file. This file is not very user friendly to analyze the data and take effective decisions. This text file has section details spanned across multiple pages with headers repeating in each page. This text file also has some additional details in between sections that are not necessarily used. This project “GSU Schedule File Transformation Tools” focuses on creating an online application that provides workable spreadsheet from GSU section schedule text file. This will be done by extracting data from text file, transform the data and load it into excel. Transformed data will also be stored in database for future reference, in case of excel or text files are lost. This project works like online ETL tool for GSU members and provides business intelligent data. Transformed data will help professors, student advisors and students in many ways by simply using the filters in a single glance. Some of the benefits include

  1. Current availability across multiple sections
  2. To see which sections are filling up fast
  3. Waiting list details of different sections
  4. Planning sections for any student by days of the week.


Authors listed in alphabetical order by OPUS staff.

Dharmala_Presentation.pptx (1720 kB)
Presentation Slides