Jared Spickard

  • Home
  • Experience
  • Portfolio (current)
  • Education

Portfolio


Connect 4 AI logo

COVID 19 Testing Tracker

Connect 4 AI logo

Connect4AI

S.O.I.S. logo

S.O.I.S.

Image of a Neural Network

Machine Learning Implementations

Screenshot of Mauricio game

Mauricio

The letters J and S

Personal Website



Copyright ©2022 All rights reserved

COVID 19 Testing Tracker
In September of 2020, UC Berkeley announced that they would be providing biweekly COVID surveillance testing to students living in group housing such as fraternities, sororities, and co-ops. In an effort to ensure that members of my chapter participated in this biweekly testing, I developed a service that simplified the management of tracking individual testing activity.
This service is a full-stack flask web app (HTML, CSS, JavaScript, Python, PostgreSQL) that relies on user accounts to upload information related to their scheduled tests, and it sends weekly reports to an admin detailing the testing activity of an organization. The service also sends email reminders to members that have yet to sign up for tests by a certain point in the week (currently Wednesday afternoon). Along with this functionality, I have included features such as links to COVID 19 resources and step-by-step guides detailing how to sign up for testing. This source code has been shared with a few other organizations on campus as well.
Connect4AI
In August 2020, I decided that I wanted to gain more experience working with full stack applications, so I began working on a project called Connect4AI. Connect4AI is a flask web app that I built entirely from scratch, learning flask throughout the process. This web app allows users to play the popular game Connect4 against another user on the same device, or against an AI.
The AI relies on the minimax algorithm with alpha-beta pruning in order to decide its moves, with various search depths resulting in various difficulties. The evaluation function that it uses examines the board and increments or decrements the score depending on the number of blank spaces that, if filled, would result in a winning game state.
S.O.I.S. (Support Our International Students)
On July 6th, 2020, the Trump Administration announced a policy that would force international students that were not enrolled in in-person classes for the upcoming Fall Semester to leave the country. The following day, my friend McClain and I began working on a website that provided resources to international students and connected them with domestic students in order to potentially swap into their in-person classes.
I worked on the backend of this site, using my experience with Google Apps Script to turn a popular Google Sheet into a more secure, accessible, and readable site. This site was up and running in less than 60 hours of its inception, and it had over 5000 hits within just 12 hours of its launch.
Mauricio - The Sicilian Electrician
Originating as a class project in my Data Structures class (Spring 2018), I expanded upon this pseudorandom, world-generating game to include features such as an improved UI, randomly-moving guards, and a "boss battle" complete with graphics. This project is written entirely in Java, and all code in the byog folder is my own. The TileRender folder (and subsequent code) was created by the staff of my class, though I edited it slightly to alter the view of the game. Feel free to check out a video I made showcasing this project at this link.
Machine Learning Implementations
In the Spring of 2020, I took Introduction to Machine Learning (CS189) at UC Berkeley. In this class, we had 7 homework assignments that involved implementing various classification and regression models in python, often completely from scratch. With models ranging from Decision Trees, to Gaussian Discriminant Analysis, to a variety of Neural Networks, this class provided me with a near-weekly challenge to translate complicated algorithms from paper to code. Feel free to explore these implementations on my Github linked below.
Personal Website
Up until the summer of 2020, I had very minimal experience with front-end development. However, during my internship at Adibi IP Group, I was developing the full stack of a web app, where I received a ton of experience on the front-end. In an effort to display this newly acquired skill, I decided to create a personal website completely from scratch, with only Bootstrap documentation/components to aid in my efforts. Feel free to explore the site and see what I've learned!