Here are the projects that were submitted this semester:
Spreadsheet Link | Demo Video | Description |
term project - group 1 | link - group 1 | OneStop Spreadsheet for Dating - This workbook helps keep track of the people you are interested in and and compose a post-date text based on how the date went. |
term project - group 2 | link - group 2 | Tic Tac Tank Attack - Our project is a Tank game in which the player tries to destroy enemy tanks in as few shots as possible. The player does this by changing the power level and angle of launch in order to reach his target. |
term project - group 3 | link - group 3 | Cost-Benefit Analysis: Reservoir Sedimentation Management - This spreadsheet was created to help estimate the costs of dams in order to assess their profitability and value. |
term project - group 4 | link - group 4 | Budget Tracker - This is a budget tracker that is easy to use and update. This program allows users to track accounts as well as categories for their spending uses. |
term project - group 5 | link - group 5 | SUPER MARIOXL - This spread sheet has a Mario figure that moves around the spread sheet via the arrow keys and four items on the sheet that if Mario runs into he will use their powers. |
term project - group 6 | link - group 6 | The Final Review - The Final Review tests one’s knowledge of the semester’s material in the form of Jeopardy, with a breakdown of their score, to help them improve. |
term project - group 7 | link - group 7 | Vacation Planner - Take a quiz to decide where you should go on vacation! It also calculates the approximate cost of your trip, shows the weather at your vacation destination, and lets you look at possible activities to do while you’re enjoying your break. |
term project - group 8 | link - group 8 | Weekly Meal Planner - For our project we made an excel sheet that will allow users to plan their weekly dinner schedule. Users will cycle though each day of the week and choose what meal they want to eat. A grocery list will then automatically be compiled for them from the food index. Users will also be able to add a new food with new ingredients at any time. |
term project - group 9a | link - group 9a | Mission Guess Distance Calculator - The program that we have created enables a fun way to compete with friends in determining someone's mission call. |
term project - group 9b | link - group 9b | Hogwarts Sorting Hat Quiz - The sorting hat quiz will help you find out where your journey at Hogwarts will take you! Embark on a wizzarding journey! |
term project - group 10 | link - group 10 | Battleship! -The Age-old game by Hasbro’s now comes to your very own Excel Spread sheet. The object of Battleship is to try and sink all of the other player's hips before they sink all of your ships. All of the other player's ships are somewhere on his/her board. You try and hit them by calling out the coordinates of one of the squares on the board. |
term project - group 11 | link - group 11 | Animal Adoption Service - The purpose of this spreadsheet is to serve as an informational database for employees of a given animal shelter. Employees can add new cats and dogs into the system as well as search for pets in the system. In the event that an employee wants to see a pet resulting from the search, it directs them to the correct page. |
term project - group 12 | link - group 12 | Epic Meal Planner - This program is a cookbook that allows you to add recipes and search through them based on the ingredients you have as well as create a shopping list. |
term project - group 13 | link - group 13 | Choose Your Own Adventure - Our Choose your adventure workbook. Choose from over 30 endings! |
term project - group 14 | link - group 14 | The Dating Game - The purpose of the game is to provide ideas to create a perfect date. It will give options to choose an activity you would like and give some things to do in the date. |
term project - group 15 | link - group 15 | Hold On, We’re Going Home - The purpose of this spreadsheet is to take the information from sheets 2-3 and condense it into a summarized version on sheet 1. |
Spreadsheet Link | Demo Video | Description |
term project - group 1 | link - group 1 | Tic Tac Toe Game - Our term project is a Tic Tac Toe game on Microsoft Excel. To start playing, you simply click on the blue control “Play Tic Tac Toe”. The game will show and count the result for the winner. |
term project - group 2 | link - group 2 | VBA Keyboard - A virtual piano with varying levels and sheet music options. You can also use the F1-F12 keys to play on your keyboard and listen to samples of the sheet music. |
term project - group 3 | link - group 3 | Cycling Race Planner - This spreadsheet assists cyclists to determine whether they are able to compete in famous cycling races locally, nationally, and worldwide. |
term project - group 4 | link - group 4 | Budget Tracker - A comprehensive budget tracker that records transactions for an entire year, and includes categories and sorting functions. |
term project - group 5 | link - group 5 | Astrology Report - The purpose of this project is to create a personalized astrological report, taking into account your sun and rising signs based on your birthdate and time. |
term project - group 6 | link - group 6 | Which Disney Princess Are You? - We created a fun quiz to help you find out which Disney princess you are! |
term project - group 7 | link - group 7 | My Budget - So we created a spread sheet where you can manually input your income or paychecks and it adds a row and puts into the correct Month. Which automatically updates a certain part of the chart where it can tell you totals and calculates some other useful things. Then we also used another user form to be able to input what you have spent. There is also another certain section of the sheet that calculates the total of each month. We spent a long time on this more then 14 hours using a lot of do until and do while loops. It was a lot of fun |
term project - group 9 | link - group 9 | Ultimate Tic-Tac-Toe - Grab a friend and enjoy the ultimate Tic-Tac-Toe experience. This is the classic childhood game with an exciting twist! |
term project - group 10 | link - group 10 | DJ Central -DJ Central is a program designed to help DJs create playlists based on the events they are working. In this program, you can generate playlists based on the type of event (prom, wedding, etc.), the age group, and the style (formal, relaxed, energetic). The program will pull songs from a song bank and filter them based on the criteria chosen. You can then manually add or remove songs from the generated playlist using buttons, save the playlist to a new sheet, and add a transition style between songs. The total duration of the playlist is also calculated. |
term project - group 13 | link - group 13 | Personal Well-Being Calculator - Our project lets a user set well being goals, helps them track their progress and reports their progress. |
term project - group 14 | link - group 14 | Golf Handicap Scorecard - The purpose of this spreadsheet is to compute a player’s handicap over many rounds of golf! It will load the information from all past rounds and compute a new handicap after every round you input. We programmed the handicap equation to automatically input the new values of each round. We are going to continually add courses near here and other places we play often. |
term project - group 15 | link - group 15 | Whack-A-Mole - This is a game where the player’s goal is to click as many moles as possible. There are three difficulties. Have fun! |