About


About Me Cat icon

Hi, I’m Megan. I enjoy building apps and exploring data. I learn new skills quickly and love working as a member of a diverse team. I am ready to contribute to your projects with my application development skills!

About This App

UCI Medical School Stats Application is an ASP.NET MVC (VB / .NET Framework 4.8), responsive web application that downloads an AAMC data file, parses California medical schools, and loads the results into SQL Server using Entity Framework Code-First Migrations. It then visualizes the data with interactive JSCharts.

UCI App Mobile View

Building the UCI Medical School Stats Application

  • Created a new ASP.NET MVC app in Visual Studio 2019 (VB, .NET Framework 4.8). MVC VB Template is not supported in VS 2022.
  • Added a service to download and read the AAMC file (CSV/XLSX) and import California rows.
  • Modeled three tables with EF6: CaMedSchool, Applications, and Matriculants.
  • Used EF6 Code-First Migrations to create/update a SQL Server database.
  • Added controllers for necessary CRUD operations.
  • Built charts with Chart.js: counts and in-state vs out-of-state comparisons (stacked bars).
  • Added click actions on % charts to show per-school pie charts.
  • Added Feature Request functionality with a FeatureRequest table in SQL database, model, controller, and views.
  • Updated the styling with CSS/Bootstrap to improve visual appeal. *Updated from v3.x to v5.x
  • Deployed the application with Azure through Visual Studio.

Resources I used

  • Entity Framework 6 (Code-First & Migrations)
  • ExcelDataReader / ExcelDataReader.DataSet (for reading .xlsx)
  • Chart.js (client-side charting library)
  • SQL Server LocalDB with SSMS for verification
  • ASP.NET MVC 5 (VB) project template in Visual Studio 2019
  • AAMC data file (Applications & Matriculants)

Resource Links