University Student VBA Projects

Wednesday, April 15, 2015

Social Media Auto Grader

My project is designed to automate the grading process for a MBA 693R class for which I was enrolled in this semester. Currently there are weekly assignments for each student to do the following:

· Tweet 15 times

· Follow 10 new people

· Write a blog post

· Comment on 3 class members blog posts

Each week the TA must examine each of the students’ social media sites to determine if they met the requirements for the assignments. With one button click, my program executes web queries using the Twitter API and html scraping to find the relevant information and makes a report sheet summarizing the fulfillment of the assignments per student.

What's In My Kitchen?

PROBLEM AND PURPOSE

I often forget which food I have in my refrigerator and pantry. I sometimes will forget for long enough that some foods will expire and spoil. Other times, I will run out of something and forget about it. Then I return home, only to discover that I need that one item that I ran out of a couple of weeks ago and had since forgotten about it. This problem extends to food storage. As a student, I don’t have much food storage. However, my parents do have a food storage and while I was growing up I was able to see the pain point of not remembering everything that is in food storage, or if it may expire soon. What’s In My Kitchen will track all food items, including their quantity and expiration date, so that food is not wasted, and shopping trips are efficient. There is another feature included within this program that will allow the management of recipes. I can create a recipe, complete with the instructions and the foods required. The foods required can be selected from a list of foods that have been added to the Inventory spreadsheet database. Both the recipe and items lists can be printed out with the click of a button. This is a program that can eventually be ported to a mobile application, and it is targeted towards anyone with a kitchen with a stronger focus on stay-at-home moms.

University Writing Email Generator

Executive Summary

I currently work on campus as a research assistant for the BYU Writing Department. As an extension of the English department, our focus is to help teachers across all curriculums learn how to improve their students’ writing, and how to be a better writing teacher. Our department hosts several luncheons and clinics that various professors across campus choose to participate in. Over the years, University Writing has composed a matrix of teacher names, department information, and email addresses of those teachers who have previously expressed interested in being a part of the University Writing curriculum. As a department, we send out multiple emails every week to different departments about different events that we are hosting. There are often errors produced in these emails with incorrect dates and times of events, or they are sent to the wrong people. I created a system that takes the list and cleans up the data, and then I also created a form that the department can use to send mass emails to people in different departments to ensure that all of the event information is entered correctly.

*Note: The code only works for Outlook, and all email address have been changed for confidentiality.

Automating Technology Transfer Processes

The Technology Transfer office focuses on taking professors’ disclosed inventions and patenting them in the U.S. and other countries. Furthermore, once the process has begun to patent these technologies, the Technology Transfer Office seeks out companies who would be interested in licensing the technology, and enters into license agreements with these companies.

Because of the nature of the work (patenting), the Technology Transfer does a lot of work with law firms outside of BYU. Currently, the process to approve and pay the law firms’ invoices, as well as subsequently billing the licensees to reimburse for the invoices paid is an arduous, manual task. This VBA project eliminates most of the manual effort (excluding data entry) involved in this accounts payable/receivable process by downloading the necessary tables of information from an access database, creating approval summaries for the director and his associates, creating summaries pages for each law firm that is getting paid, and finally creating an invoice for each licensee that has licensed a technology that was paid on.

Portfolio Tracker

This project allows you to track your exchange traded securities. Allows buying and selling, and will update with current prices, character and amount of gain / loss, and portfolio allocation percentages.

http://files.gove.net/shares/files/15w/aaron2/PalmerStockPortfolio.xlsm
http://files.gove.net/shares/files/15w/aaron2/Palmer_MBA614_WriteUp.pdf

Battle Ship

Executive Summary

This is a fully functioning human vs computer version of the popular game battleship. The computer has been programmed to guess intelligently based on previous successful hits. The program recognizes when ships are sunk and declares a winner win a player has sunk all of the opponent’s ships.

Files

Tuesday, April 14, 2015

Ethan Kitzmiller VBA Project

Executive summary:

Bluehost is an internets hosting business that specializes in helping customers have their own website. As a data analyst for Blue Host, I have to pull various amounts of employee performance data, on a daily basis. This often takes about an hour to pull data for any given project. The task was to automate the data collection process in order to reduce time and eliminate human errors. This project will save an estimate 1 hour of time every business day.

Richins Insurance

Removed at the resuest of the student who posted

Lacey Woodfield's Grocery Manager

Executive Summary

The Grocery Manager is a system that helps to organize the general consumer’s shopping list. Not only does this tool allow shoppers to put together shopping lists with their recipes, but it also provides a compiled record of their recipes by allowing them to input and save recipes in the system. Then, when they wish to create a grocery list, they can chose from this list of recipes to put together a shopping list. Further, before printing the list, the user can add other items he or she might need in an “Other Items” section, and these other items will also be added to his or her grocery list. Finally, when the user has all the recipes and other ingredients that he or she wishes to shop for, he or she can “print” the list and the tool will add together like ingredients, organize them into categories, and prepare the list to be printed out. This way the user can remove items that he or she already has by looking through each category. The categories are also useful when shopping at the Grocery Store as items in the store are generally grouped by these same categories.

By using this shopping tool, the user can expect to be able to shop with convenience and not miss ingredients they need for the recipes they wish to make in any given week.

Complete Final Report
http://files.gove.net/shares/files/15w/laceyk2/Lacey_Woodfields_Final_Project_Write-up.pdf

Excel file that contains the Grocery Manager
http://files.gove.net/shares/files/15w/laceyk2/Final_Project.xlsm

Wednesday, April 15, 2015

Tuesday, April 14, 2015

Blog Archive