2019 Winter Semester Projects

Here are the projects that were submitted this semester:

Spreadsheet Link Demo Video Description
term project - group 1 link - group 1 BYU CE EN Scheduling Tool - This tool offers a personalized approach towards planning for graduation around the department’s provided program flowchart.
term project - group 2 link - group 2 NPV Estimator Description - This is a tool to estimate the Net Present Value of a project. It is designed with a set of forms to add the details about the different costs and revenues from an engineering project. The idea is that in a simple and easy set of operations we can determine whether a project as profitable or not.
term project - group 3 link - group 3 What Should Your Major Be Quiz - Take a fun quiz to see if you are currently in the correct major, and if not it will suggest which major you should change to.
term project - group 4 link - group 4 March Madness Bracket - This Excel sheet is designed to allow users to easily input their own brackets with self generating cells, that cross reference the games as they occur showing up as green or red.
term project - group 5 link - group 5 USAF Fitness Tracker - In the Air Force Reserve Officer Training Corp (AFROTC) program there is a physical fitness standard all cadets are required to meet. To ensure all cadets meet this standard, a Physical Fitness Assessment (PFA) is administered every semester. The USAF Fitness Tracker is targeted towards the cadets in the Air force program to help them keep track of their fitness scores and progress.
term project - group 6 link - group 6 Connect Four - The nostalgic childhood game of connecting four game pieces in a row is now brought to you in Excel!! Simply drop your pieces in the board and “Connect Four” to win!
term project - group 8 link - group 8 BYU Budgeter - A series of Spreadsheets and User Forms to help students to budget well with the future in mind
term project - group 9 link - group 9 Hangwoman - We created a spin-off of hangman. Choose between one-player or two-player, and don’t let the shark eat you.
term project - group 10 link - group 10 Connect 4 -By creating Connect 4 in Excel, you can take the game anywhere without having to carry around a bulky box or worrying about losing any of the pieces.
term project - group 11 link - group 11 Weekly Meal Planner & Shopping List - This handy spreadsheet tool uses VBA and Excel built-in functions to generate a shopping list and estimate the cost of groceries for one week’s worth of dinners.
term project - group 12 link - group 12 Diabetes Insulin Calculator - We made a calculator which determines how much insulin a person needs depending on carbohydrate intake and glucose levels.
term project - group 13 link - group 13 Chutes & Ladders - This term project was a remake of chutes & ladders for two players or less. In this game, the player uses command buttons to try and make it to the finish.
term project - group 14 link - group 14 European Interactive Map-book: Italy, France, and the Netherlands - When traveling abroad as a student, teacher, or even your average tourist, one thing that can greatly enrich your experience is knowledge about your destination. From practical things such as what language will be predominately spoken to what year the country was founded, this quick and easy to navigate Map-book was created to help get you informed in a fun and interactive way. Looking for a way to test your knowledge and skills? Check out our quiz that can be found on sheet 2 to see how you stack up against family and friends!
term project - group 15 link - group 15 A Gearhead’s Guide to Camping - For our CE EN 170 project we created a way for people to organize their gear. You can add new gear with the Enter New Gear button and adjust the units so you can see how much your gear weighs. Additionally, you can create Trips so that you can have a packing list organized by catagory to reference while you're preparing for your adventures.