#Course Grade Analyzer
A Userform that connects to a database is shown to the user. It lists available courses in a database following a schema identical to studentGrades.mdb.
From here you can select a course to gather information about and use SQL queries to find information about a course using the coursecode, Coursename, Student information (first name, last name, ID), and Student grades for that course (assignments, midterm, exam).
The program calculates:
- student final grades
- class average
- class minimum
- class maximum
- standard deviation
From here a histogram representing the statistics above is generated on the spreadsheet.
Finally, a report is generated using student final grades, including everything listed above but in a generated MS Word document.
I used VBA, XML, and SQL to create this project.
- clone the repository
- open script.xlsm
- navigate to assignment 5 in the ribbon and click `connect to database`
Great experience overall, I really enjoyed making this project. Happy coding!