SENIOR DESIGN GROUP PROJECTS
- Patient Database Manager (PDM)
- QBank
- Administrative Patient Database Manager (APDM)
- Neurosurgery Lecture Repository Website
- QBank and Neurosurgery Question Bank Testing Solution
- Neurosurgery Boards Review Course Enrollee Website
- Transfer Patient Provider Portal
- Neurosurgery Outside Hospital Imaging Database
- JALFoundation Website
- Profit and loss statement automation and operational statistics dashboard development project
- PDA portal for Emory Neurosurgery Patient List Manager
Patient Database Manager (PDM)
Summer 2009
- Kyle Brett
- David Wick
- Christopher Milett
- Eugene Simonds
Create a web-based database driven Patient Manager and Database application that will assist medical professionals with following their patients and collecting meaningful clinically relevant information in an electronic format that is searchable / queryable. The application’s goal is to revolutionize patient care and accelerate research and discovery.
Return to the Top of the Page
QBank
Summer 2009
- Michael Tanner
- Adi Hidayat
- Andrew Crowe
Create a web-based database driven question bank (q-bank) application for Neurosurgeons in training preparing for the National Board Examination administered by the American Board of Neurological Surgeons. The application will offer sophisticated analytics that help test candidates identify content areas of weakness and allow the user to create custom tests based on specific criteria including number of questions, difficulty and content. The Neurosurgery Question Bank testing solution will bring exam preparation in Neurosurgery into the information technology age, a change long overdue.
Return to the Top of the Page
Administrative Patient Database Manager (APDM)
Summer 2009
- Nayan Jain
- Michael Cantrell
- Nate Barish
This proposed project would involve creating a multi-hospital web-based database driven solution that would replace the current Access Database. This would not only streamline the current clinical administrative processes but it would also provide needed ‘on-the-fly’ data about Neurosurgery operations across all hospitals providing insight that presently is not readily available.
Return to the Top of the Page
Neurosurgery Lecture Repository Website
Fall 2009
- Jason Faulk
- Corey Mayo
- Robert Billinghurst
- Corey Mayo
- Johnny Mai
Create a restricted enrolled participant area on the website for a major Neurosurgery Boards Preparation Live Course.
Return to the Top of the Page
QBank and Neurosurgery Question Bank Testing Solution
Fall 2009
- Jack Kinney
- Clanton Tatum
- Lisa White
- Andrew Guyton
Create a web-based database driven question bank (q-bank) application for Neurosurgeons in training preparing for the National Board Examination administered by the American Board of Neurological Surgeons. The application will offer sophisticated analytics that help test candidates identify content areas of weakness and allow the user to create custom tests based on specific criteria including number of questions, difficulty and content. The Neurosurgery Question Bank testing solution will bring exam preparation in Neurosurgery into the information technology age, a change long overdue.
Return to the Top of the Page
Neurosurgery Boards Review Course Enrollee Website
Spring 2010
- Derek Tatum
- Mikhail Lovell
- Matthew Remmele
- Kimberly Wong
- Jared Caldwell
Create a restricted enrolled participant area on the website for a major Neurosurgery Boards Preparation Live Course.
Return to the Top of the Page
Transfer Patient Provider Portal
Spring 2010
- Andy Jones
- Andrew Liu
- Chris Sladky
- Lander Basterra
This project involves developing a prototype portal that would provide an HIE between Emory University Hospital and outside hospital facilities desiring to transfer patients to Emory for further management of complex medical problems requiring specialists at Emory. The ultimate goal is to selectively establish HIE between the top outside hospital facilities sending transfer patients to Emory and Emory. The working hypothesis is that costs to the nation’s health care system could be decreased if HIEs were established for transfer patients (selectively and thoughtfully between centers where there are high volumes of transfer patients) broadly across the nation. An HIE could potentially reduce the frequency with which tests done at the sending facility are duplicated at the receiving facility and thereby lower costs. The amount by which costs could potentially be lowered would serve to estimate the potential value that could be created by establishing an HIE.
Return to the Top of the Page
Neurosurgery Outside Hospital Imaging Database
Spring 2011
- Arthur Oysgelt
- Ahmed Abdalla
- Baishali Bandyopadhyay
- John Clerici III
- James McCarty
This project would be to create a prototype for a central web-based repository of outside hospital imaging studies to which providers could upload studies from CD Roms for future access and viewing from anywhere there is a web browser provided the providers have appropriate password access.
Return to the Top of the Page
JALFoundation Website
Spring 2011
- Candis Pham
- JoAnne Ofoli
- Kyle Thomas
- Kaliyana Finney
Informal means for students interested in becoming involved in neurosurgery related clinical research have been in place for years. Recently this program has become more formalized at Emory in the department of neurosurgery. The first class of participants in the formalized program has been selected and have embarked on their individual research efforts. Students have come from Georgia Tech and Emory among other institutions. In an effort to continue the momentum for formalizing this program with a desire to take it to the next level, we would like to develop an online presence for the program. This project would entail working with the program leadership to develop a website providing the desired functionality.
Return to the Top of the Page
Profit and loss statement automation and operational statistics dashboard development project
Spring 2011
- Meet Patel
- Nitya Malhotra
- Chris Borja
- Puneet Sabharwal
This project entails the following aims to automating the queries so that they run at a regular specified interval independent of any human interaction (timed macros), creating a MySQL backend with database tables into which this data will be written, automating the writing of the data returned from the queries to the MySQL database, creating a web-based (Java or PHP) front end with canned P & L reports mirroring those previously created in excel that can be generated with the push of a button after specific criteria are established (i.e. time period of interest), and creating a dashboard home view with operational statistics generated from data in the MySQL database used for the P&L statement’s generation that will raise visibility into the operations and facilitate the business manager’s daily management of the department’s financial operations
Return to the Top of the Page
PDA portal for Emory Neurosurgery Patient List Manager
Spring 2011
- Megan Koleff
- Josiah Mangiameli
- Matt Lee
- Charlie Shilling
- Aaron Schooley
The PDA would provide the physician access to the current patient list in real time interfacing with a backend database already in place which currently interacts with and is updated via a web client. A typical practice in the current paradigm is physicians go to the web client, print out a list of their patients early in the day, and then they use this list to go on rounds. The list tells the physician who their patients are, what their medical records number is, what the patient’s diagnosis is, what surgeries the patient had when, and where the patient is located in the hospital, among other things.
Return to the Top of the Page