Sample Project

The Problem:

The Strategic Academic Research and Analysis office needs 3rd week course data every term for making workload report. However, the data extracted from from Student Information System is still premature and unverified.

Since college and department’s staff know their overseeing course data very well (e.g. MATH, PHYSICS, ENGLISH, PHILOSOPHY…), they need an application system so they can verify and update the course data on precisely and timely fashion.

The Solution:

Design and Develop an enterprise web application with integration of student data, facility data, and instructor data for course overseeing staff to use in verifying and updating such data.

The Requirements:

The application must be web application with dynamic database driven back-end. The system must have authentication feature. It must also have the search and update, add, and delete certain data as based on per credential. In addition, It must have a special admin page for admin users to update data in lookup tables, and to add users… The previous term data must be locked as soon as the current term data is loaded in the system. Users can only update the data as it is assigned to them, but they can view and read others’ data only. The application must be able to raise any error flag based on predefined business rules.

The Implementation:

Developed mock-up screens as visual aid for users to see how the new application works. Setup development, test, and production environments so the developers, testers, and users will not be impacted as the project is going through its phases. Designed and Developed database tables to store the data. Developed stored procedures to populate course, student, facility, and instructor data into Oracle database tables.

When completing a certain part in development environment, copy it into test environment for testers to test it. Repeat this process for different part of the project until all parts are complete. Make a final walk through all parts of the project. If no action items are requested, it is ready to deploy for production use.

It sounds simple but it took a lot of effort in coordinating all parties, in testing, in fulfilling last minute modification request, and in resolving unforeseen problems…

The Final Product:

It is named Course and Instruction Reporting System (CIRS). It is an intranet website application. Only UCR’s faculty and staff can access the system through http://cirs.ucr.edu via Central Authentication Services dialog window

Central Authentication Services
Central Authentication Services

After successfully passing the authentication, it should take to the next page

CIRS Main Menu
CIRS Main Menu

Click on “Edit Current Quarter Course”, will lead to the next screen

CIRS Course Listing
CIRS Course Listing

Click on any course link will take to the next page where the data can be updated.

CIRS Course Edit
CIRS Course Edit

Now back to the main menu, then click on the “Query CIRS” will lead to the next screen

CIRS Query
CIRS Query

with few criteria selections and desired column outputs, the result screen should looks like:

CIRS Search Result
CIRS Search Result

… There are a lot more features and tools that this enterprise web application can provide. It has been in a production since it was deployed. I just want to demo a few feature screens for illustration.