Ward Student Portal

This was a group project. I contributed a large ammount of the work to when it came to the SQL commands, video editing, and coding.

Google Drive with reports, presentations, and final build Ward Parent/Staff Portal.
Warning: Application does not run as database is no longer accessable.

Data use

This application uses data grid views to display data however it does not edit data.
To edit data the Data Grid view binds the data of a row to the ui in things like text boxes which can then confirm the edits to the data.
sql command that loads a grade point average using weighted grades sql command that binds data from the data grid view to the ui textboxes preview of student edit view

Major Commands

I had a single sql command that I believe made this project feel more natural due to it adding random values to every single students grades.

sql command that iterates through each student and applies random grades general passing

Student Population Command

To save on time durring this project I decided to write a sql command that would fill the grades data with random numbers within a certain range which made the program feel fuller.

sql commands that only retrive the first cell or column of data

Custom Sql Query

When I workd on this project I created 2 functions that would be passed a SQL Query and return only the first result Cell/Column of data to cut down on repetition.