Fall 2023
- The user can jump to sections of the application without eroding website functionality
- Several pages have been removed/renamed
- Identify old buttons that have broken functionality and rewire them per specifications on previous semester’s project report
- Certain pages break on refresh
- Test and ensure pages maintained their intended functionality
- Any bugs the user reported from summer-testing are patched
- The document provided during the first week of the semester entails several bugs currently in the application
- Issues are fixed and tested by developers for scrutiny
- Additionally continue to fix any issues that arise from partner’s continued testing
- There is a documented, sustainable testing method to check for bugs
- Method is comprehensive of all interactions the user encounters
- Ensure method is easy to adjust to accommodate new features/changes that future developers add
- Documentation and files are overhauled for clear readability for future developers
- Revise README and documents to contain more detail on how to setup developers on database, as well as update the modules that are being used
- Mark/remove files that are no longer in use
- The user can generate filtered readable reports that indicate which grants’ deadlines are soon
- Generate a more user-friendly spreadsheet of grants
- Drop several unnecessary columns to reduce clutter
- Sort grants by date rather than name for readability
- Indicate which grants are be available given the current date
- The user can view an analytic estimate of annual/monthly grant influx
- Current Home page displays meaningless values that do not indicate any estimate
- Pull information from database to provide useful analytics about grant cycles and deadlines
- Indicate annual/monthly income, overall earnings, and comparisons with previous cycle/year
- (Stretch goal) The user receives notifications, which indicate whether certain grants are due soon
- (Stretch goal) The user can display reports as tables directly on the website, rather than downloading an excel sheet to view
Spring 2023
Our overarching goal this semester is to prepare the database for deployment.
This will involve completing the following goals:
● Create a homepage dashboard
○ Display notifications and alerts
○ Quick View dashboard showing upcoming grant deadlines
● Implement internal way to add users to be able to edit the database
● Implement filtering method for grant information in the report generator
○ Add a Report All method
○ If no data returned, do not create a file report
● Implement sorting method for grant information in the report generator
○ Display donors even if they do not have grants
● Rework grant form validation
○ Prevent form data from resetting after invalid submission
● Add a user manual tab that stores basic user manual for users
● Cleanup
○ Remove logs to ensure no data leaks into devtools
○ Remove unused pages and their routes
○ Change references of organizations to donors
● Fixes
○ Fix editing feature for grants and donors
● Automate deployment to Azure
Fall 2022
Our semester goals for Fall 2022 is:
- New grants and organizations can be successfully:
- Added
- Edited
- Displayed
- Filtered
- Deleted
Completed
- Report builder can generate reports with accurate, user-readable data
In – Progress
- User interface has been redesigned to match partner’s specifications – “More ‘Kellermann feel’”
Completed
- Project partner is satisfied with the progress that has been made and feels that the database and related programs have been improved
In – Progress
Spring 2022
For the Spring 2022 semester, our goal is to create a database that will allow our client, The Kellermann Foundation, to easily collect data about their customers. This ranges from adding new customers to generating a yearly report, to deadline reminds. This will enable our client to further enhance their operation and reach higher goals.
