Columbia Scheduler

Head over to the scheduler: http://www.scheduler.uni.cc/

Every decent college or university needs a decent scheduling utility, and most such utilities allow one to easily organize courses and visualize one’s academic week. Columbia University, which I consider decent (you may have other opinions), lacks a visualization mechanism, leaving students to draw their own schedules based on a textual representation. This feature is one of the most useful because it makes an otherwise-tedious task fun. So I whipped out Notepad and made my own program to fill the need. It parses course information off the online bulletin, stores it in a MySQL database, and draws weekly calendars for users. (Later, I would discover that Barnard College, associated with Columbia, does have this function in its scheduling utility. Not fair!)

It was all very good, until I decided to update the system to a newer version of the bulletin — the new and old course numbers overlapped, among other things, so I had to make numerous adjustments. Also, the parser was not quite up to par; it could not read courses that took place at multiple locations. So I decided to spend a day rewriting the program from scratch.

The new system uses Sqlite as a database mechanism. This makes it incredibly easy to make a copy of the course data — just copy the database file. Because each semester has its own database file, it’s easy to change to a different semester — just swap database files. Updating is a breeze — delete the old database file and regenerate it using new data. And because the database would mostly be used only for reading data, and only occasionally for writing, it would be fast.

Maintaining the system involves some steps. First, the new course data has to be downloaded off the bulletin. This is cached, so that the database can be regenerated many times without incurring network overhead (actually, I did regenerate the database many times while figuring out a workable format). The database handler is then fired up, which first deletes the current semester’s database if it’s available, then creates the tables and inserts the data all over again.

Using the system is pretty straightforward. Now that it has a complete mirror of the online bulletin, it can generate its own directory of courses. The user can navigate through the course listing and select courses to add to his/her schedule, and the weekly calendar is built up course by course. The new system also supports multiple locations, days, times, and instructors per course, which is an immense improvement. In addition, users can browse courses by instructor and by location.

Well, if you’re a Columbia student, I hope you find the new calendar system useful. It won’t register your courses for you, but it should help you make good use of your time.

15 Comments

  1. Nannette says:

    I do not even know how I stopped up here, however I assumed this put up was great.
    I do not recognise who you are but definitely you are going
    to a well-known blogger should you are not already.
    Cheers!

  2. Laurie says:

    Normally I do not read post on blogs, but I would like to say that this write-up
    very pressured me to take a look at and
    do so! Your writing style has been amazed me. Thank you, quite nice post.

  3. Nice blog! Is your theme custom made or did you download it from somewhere?
    A design like yours with a few simple adjustements would really
    make my blog shine. Please let me know where you got your design. Thank you

  4. Hi i am kavin, its my first occasion to commenting anyplace, when i read this paragraph i
    thought i could also make comment due to this good article.

  5. I’m curious to find out what blog platform you’re using? I’m
    experiencing some minor security issues with my latest website and I’d like to
    find something more secure. Do you have any recommendations?

  6. C’est vraiment aussi vous allez mourir un bref délai connectivité avec la inverser le mauvais vente maison avec jardin perpignan pas
    simplement aller des caméras de très fiable de encore une fois

    maison perpignan saint martin

    kdo maison perpignan

    vente maison sur perpignan

    maison perpignan le bon coin

    commercial maison individuelle perpignan

  7. I think this is among thhe most vital info for me.
    And i am glad reading your article. But wanna remark on few general things, Thee website style iss great, thee articles is reallly great
    : D. Good job, cheers

  8. Naomi says:

    hello!,I love your writing very much! proportion we keep up a correspondence
    extra approximately your article on AOL? I require
    a specialist on this area to unravel my problem. Maybe that’s you!
    Taking a look forward to peer you.

  9. Hey! I just wanted to ask if you ever have any issues with hackers?
    My last blog (wordpress) was hacked and I ended up losing several weeks of hard work due to no back up.

    Do you have any solutions to stop hackers?

  10. Greetings! This is my first comment here so I just wanted to give a quick shout out and tell you I truly enjoy
    reading your blog posts. Can you recommend any other blogs/websites/forums that deal with the same subjects?
    Thanks a ton!

  11. domain says:

    What’s up friends, its great paragraph regarding cultureand entirely defined, keep it up all the time.

  12. Fsx Addons says:

    WOW just what I was searching for. Came here by searching for college board
    ap scores for administrators

Leave a Reply

Pingbacks & Trackbacks

  1. inportb » Blog Archive » Taming Columbia’s Course Schedule - Pingback on 2007/08/23