Class ≥ 2013
Beginning in 2010, the names of the courses in the Johns Hopkins School of Medicine changed. They went from a flat list to a hierarchy:
- Core Clerkship Shelf Exam Performance
- Neurology
- Psychiatry
- Gynecology/Obsetrics
- Surgery
- Medicine
- Pediatrics
- Pre-Clinical Course Performance
- Scientific Foundations of Medicine — Human Anatomy
- Scientific Foundations of Medicine
- Macromolecules
- Cell Physiology
- Metabolism
- Genetics
- Pharmacology
- Genes to Society I
- Immunology I
- Microbiology/Infectious Disease
- Immunology II
- Hematology/Oncology
- Genes to Society II
- Nervous System and Special Senses
- Neuroanatomy
- NSS: Exam 2
- Neuroscience
- Genes to Society III
- Cardiovascular
- Respiratory
- Renal
- Genes to Society IV
- GI Liver
- Endocrine
- Reproductive
- Musculoskeletal
The data arrives as an Excel spreadsheet with columns for the student name and their scores for each of the sections. This is processed into SSIS using an integration services workflow largely driven by VB.
Information is retrieved using SSIS reporting services. The report form, however, is simply displaying elements of a precomputed set of statistics.