2020 Winter Semester Projects

Here are the projects that were submitted this semester:

Section 1

Spreadsheet Link Demo Video Description
term project - group 1 link - group 1 Dog Diagnosis Tool - This tool allows for us to view the current state of the dog and assess its issues. Includes print option.
term project - group 2 link - group 2 Quarantine Quizzes - This project contains five different quizzes to take while in quarantine. Some are for your entertainment, while others help you make important life decisions.
term project - group 3 link - group 3 QUARANTIME - Three activities to help you pass the time during quarantine. Your favorites: Jokes/Riddles, Sudoku, and Mad Libs.
term project - group 4 link - group 4 5 Language Word Translator - This translator translates words in five different languages, pulling words from a database. Words not in the database can easily be added.
term project - group 5 link - group 5 Robodoc - This video is about RoboDoc, a revolutionary medical tool. It was created through Excel and VBA Primer code. RoboDoc currently only has 8 possible diagnosis, however, with more medical expertise, it could help people who feel ill know a possible diagnosis and treatments. There are many checkboxes that are possible symptoms, when checked the VBA “if” statements and with all the possible symptoms loop through and result in possible causes. There are buttons that have treatments for all the inputted illnesses.
term project - group 6 link - group 6 The Unhelpful Secretary - Use this spreadsheet to create useful (or hilariously useless) correspondence pieces, from friendly resignation letters to classic puritan sermons.
term project - group 7 link - group 7 Bridge Analyzer for Civil Engineering: Statics - Needing to do a truss analysis for statics? This spreadsheet does the math for you! Just input some dimensions and your life will be simplified!
term project - group 8 link - group 8 Date Activity Generator - This project makes a list of activities based on criteria. Ideas are given with materials needed and descriptions, and new ones can be added.
term project - group 9 link - group 9 Costume Organization System - This spreadsheet is designed for a small theater group or theme park that have actors coming and going that need a way to organize the way they manage their costumes.
term project - group 10 link - group 10 COVID-19 Activity Picker - This spreadsheet gives you different ideas for activities you can do while in quarantine, based on age, pre-existing health concerns, and interests.
term project - group 11 link - group 11 Shopping List Generator - Select the stores you shop at, create a list of items, and set the quantity for each. The program makes lists by store to find the cheapest items.
term project - group 12 link - group 12 Battle Monsters - 1) Choose your monster’s characteristics. Each characteristic has a point value. 2) Whoever has the highest point value at the face-off wins!
term project - group 13 link - group 13 Battleship - This is the classic game of Battleship but only on an Excel spreadsheet! Guess where the opponent's ships are placed at sea by selecting a coordinate. First person to sink all 5 of the opponent's ships wins!
term project - group 14 link - group 14 Healthy Living - The purpose of Healthy Living is to help you become a healthier, happier version of yourself. Based on your height, weight, age, and gender.
term project - group 15 link - group 15 COVID-19 Tracker – U.S.A. - This Tool is used for tracking the COVID-19 virus in the United States of America using postal zip codes.

 

Section 2

Spreadsheet Link Demo Video Description
term project - group 1 link - group 1 Thee Hang Lord - Enjoy this medieval take on the classic game of Hang Man! Select the difficulty, and try to guess the word before the Olde Lorde hangs!
term project - group 3 link - group 3 Marvel Avengers Personality Quiz - Have you ever wondered which Marvel Avenger you are most like? You can take our short quiz to determine just that! Complete with step by step instructions and a results page you will find that it is one of the rare quizzes that you will enjoy!
term project - group 4 link - group 4 An EXCELlent mission - Step into the role of a secrete agent by encoding a message (similar to mad libs) and then delivering it (a maze).
term project - group 5 link - group 5 Survival Quiz - Find out your chances of survival by answering the following questions.
term project - group 6 link - group 6 Guess Who?! - Try to guess the right celebrity in Guess Who?! Use the answers to questions in order to narrow down the celebrities to the right one to win the game.
term project - group 7 link - group 7 Quarantine Boredom Solver - This quiz provides a few suggestions on what to do while you are bored in quarantine.
term project - group 8 link - group 8 Customized Exercise Activity Plan - Customize your very own workout plan based on your interests and commitment level with this worksheet from our many fun and unique activities.
term project - group 9 link - group 9 Are YOU Smarter Than a 5th Grader?  - We created a test so you can see if you’re smarter than a 5th grader! We included 20 elementary school level questions in our spreadsheet. Good luck!
term project - group 10 link - group 10 Graduation Planner - This workbook is designed to help the user plan his/her college classes and calculate other useful information such as graduation dates, credits earned, and GPA.
term project - group 11 link - group 11 Book Suggester - The user can get a book recommended according to genre, age and popularity, or simply get a random suggestion from our list of books.
term project - group 12 link - group 12 BYU Favorites Tournament - Create a prediction bracket featuring your BYU Favorite Picks then view your accuracy, score, compare to a perfect bracket, and watch video results of the championship round!
term project - group 13 link - group 13 Guess Who - A Mario themed single player guess who game where you play against the computer trying to guess the computer’s card before it guesses yours.
term project - group 14 link - group 14 COVID-2X Self Evaluation Test - The purpose of this excel is to allow students of the next CE EN 170 class to take a survey and then send the excel to their professors. The professor would save all the students files to one folder where he can extract all the data onto the other sheet “instructor.” This will organize all the student’s info onto there so that the professor and administrators will know how to best help and keep the students safe.
term project - group 15 link - group 15 Extreme Gardening - This tool is intended to help both seasoned and novice gardeners. It will assist in keeping track of important dates, monitor the growth of plants, view profits and expenses, and gain new insights.