Inspiration

Going to college costs a lot of money, and many students cannot afford to pay the whole sum themselves. In 2019, the average college debt a student faced after graduating was $32000. As a team that is also entering college this fall, we often struggled with stress around the same issue. We discovered that working part-time while studying was possible and lucrative, but less information existed for specific universities online or was hard to find. These jobs are also suitable for entry-level students without the added necessity of years of experience.

Therefore, we created CampusWorks, a tool that enables a user to search campus jobs for any university they please. It streamlines the process for both students and the recruiters, making it very student-centric focused.

What it does

CampusWorks enables students to search through a database of on-campus and around the university jobs specific to their university, filter them according to their needs, and allows employers to post jobs specifically for students. This provides both the students and employers an opportunity to interact directly with the specific community.

How we built it

We used ReactJS to make the frontend website along with its various libraries like bootstrap, material-UI, and styled components. For the database, we used Google Cloud SQL, and Flask was used for the API to facilitate the connection between the database and the frontend. Having trouble with this method, we tried a simpler process of using SQLAlchemy and Marshmallow in Flask to get data from an SQLite database.

Challenges we ran into

The .gcloudignore wasn’t working properly while deploying the app to Google Cloud along with file clutter and our Flask API was getting problems with the request.json leading to no data being returned from the FETCH request. Apart from that, we had to study up how to merge the two branches of our GitHub repository leading to issues in the node_modules folder and we had to create the react app again.

Accomplishments that we're proud of

We managed to finally get the website running with a proper database-backend process online and we had to learn about technologies like Google Cloud and REST APIs which we facilitated in our work.

What we learned

We learned a lot about the process of how to set up an online workable website with the entire infrastructure independent. We also learned much about Google Cloud and we made our Flask API much more sophisticated than before.

What's next for CampusWorks

We would like to partner with colleges and make more data accessible on our site. We would also like to make an exclusive admin access page where the posted job ads will get a “Trusted” tag helping verification. We would also want to create personalized user accounts which leads to better job suggestions related to their specific skill set and a portal through which we can verify their university using auth0 and thus process the data accordingly. Employers can search for recruits using the specialized process, specific to the university and get outreach to hundreds of suitable candidates. Just post an advertisement using the form given below!

+ 4 more
Share this project:

Updates