Scholarship Database Website

Live link to Deployment on Vercel: https://simply-scholars-mxvkxuce6-ian-mahers-projects.vercel.app/

I will be creating a website builder. I want to provide a templating solution for people to create and maintain their own webpages without needing to learn extensive code or spend hours troubleshooting. This is a scaleable project for schools to utilize in an open source framework. For right now, I am going to focus on tools I wish I had as a guidance counselor, since the other solutions are too simple (Google Sites) or far too restrictive (BlackBoard) or far too expensive (SquareSpace, Wix). This will also allow me to showcase how much tech I've been fortunate enough to learn over the course of this bootcamp.

Technologies

• Frontend: Next.js 13/14 Tailwind CSS
• Backend: Strapi ( SQLite )
• backup plan is going to be MongoDB Atlas because it's free and Django/maybe Flask

Dependencies:

• Next.js
• Tailwind CSS
• Strapi (or your own Headless CMS) - with Postgres SQL

Routes & Models :

scholarship

• id
• title: string, required
• description: string, required
• amount: int, required
• deadline: date (datetime for sql), required
• isActive: boollean (default: true)
• src: string [hopefully Strapi can handle this gracefully]

scholarship requirements

• id
• title: string
• description: string

user

• id
• email: string, required, unique
• nameFirst: string, required
• nameLast: string, required
• password: string, required, encrypted

A list of routes (e.g. POST /pins/ allows users to post a picture of a pin)
GET /home/ show user all scholarships

GET /scholarships/ show user all scholarships GET /scholarships/:id show user specific scholarship (modal) POST /scholarships/new create new scholarship PUT /scholarships/edit/:id edit scholarship details DELETE /scholarships/:id delete specific scholarship

GET /user/ show user profile GET /user/:id show user profile details

GET /scholarships/requirements/ show user explanation of the scholarship definitions GET /scholarships/requirements/:id show user specific scholarship requirements details POST /scholarships/requirements/new create new scholarship requirements details PUT /scholarships/requirements/:id edit scholarship requirement details DELETE /scholarships/requirements/:id delete specific scholarship requirement detaills

Wireframes

Wireframes with basic page layouts
Copy and paste or drag and drop your images here.

example site

User Stories

• As a guidance counselor, I want to be able to send out scholarship information with a digital interface.
• As a guidance counselor, I want to be able to personalize the scholarship information in a way beyond very basic things like Google Sites.
• As a guidance counselor, I want to be able to create a scholarship website without needing to pay lots of money for something like Squarespace or Wix.
• As a student, I want to have access to the most pertinent information about the scholarships, such as the award amount.
• As a student, I want to have be able to click on links to the scholarship applications all in one place.
• As a guidance counselor, I want to be able to maintain the scholarship information and update information efficiently.

MVP Goals

• Fully functional public/student facing website that will use Next.js for the frontend and Strapi as a backend.
• The user will be able to edit their website very easily, with room for creativity and styling.
• Mobile responsiveness.
• Graceful error handling.
• Full CRUD functionality in all data collections.

Stretch Goals

• If I have enough time, reconfigure the app to use TYPESCRIPT.
• Allow the user to move stuff around on their website, instead of locking them into a particular layout.
• Utilize Tailwind's Themes and such to allow user-defined themes to things.