Project Summaries
Show All 
Airway Hills Miniature Golf and Driving Range
Small Business -- Pullman, WA
Marketing Website (Maintenance)
Description
This is a marketing website for a miniature golf and driving range with golf pro shop.
Initial design by Adam Ratliff
Technologies Used
HTML, CSS, ASP.NET
Initial Contract Began: 10/25/2010
Most Recent Contract Ended: 10/25/2010
Payroll Program
Description
A simple payroll program was created to help track information needed for quarterly and year-end taxes.
Technologies Used
MS Access
Initial Contract Began: 1/1/2008
Most Recent Contract Ended: 6/24/2008
Andy Sewell Water Colors
Small Business -- Viola, ID
Customers, Sales, and Marketing Program
Description
In sales, knowing your customers is vital. SumTech developed a MS Access database to manage information about customers, sales, paintings, and art shows. This information can then be used to send mailings to specific regions before future art shows, find customers who are interested in certain types of paintings, and track how well sales were at different art shows. Also, custom forms were created to allow quick entry of receipt information to the database.
Technologies Used
MS Access
Initial Contract Began: 1/1/2009
Most Recent Contract Ended: 2/2/2009
In Prayer for Washington State
Non-Profit -- Pullman, WA
Informative Website and Newsletter (Design, Creation, Maintenance)
Description
People wanting to know how to specifically pray for Washington State have a place to go. This site is designed to be updated weekly and have newsletters e-mailed to members with the site's new information. Persons may subscribe and unsubscribe to the newsletter on a weekly basis. The facilitators of In Prayer send a MS Word document to SumTech, who then converts the information to published on the web. Each newsletter is stored in a database for archiving so members may review past newsletters.
Technologies Used
HTML, CSS, ASP.NET (VB, C#), MS SQL
Initial Contract Began: 10/1/2008
Most Recent Contract Ended: 1/1/2009
Living Faith Fellowship
Non-Profit -- Pullman, WA
Worship List Documentation Program
Description
LFF keeps commonly sung hymns and songs stored in a box for the worship team to reuse each week they are needed. SumTech created a database list of all the songs available in the box, their various keys, and their composers. Now reports of what songs are available can be printed sorted by their first line, title, or key of composition. Volunteers can update the database when new songs are added to or removed from the box.
Technologies Used
MS Access
Initial Contract Began: 1/29/2007
Most Recent Contract Ended: 6/23/2007
Motley Motley, Inc
Small Business -- Pullman, WA
Timecards Database w/ MS Access Training
Description
This project had a two-fold purpose. The main goal was to create a timecard application so they can review how money is being spent on different construction projects. This project was also used as a training tutorial for one of their employees who will now do simple maintenance and updates for the application.
Technologies Used
MS Access
Initial Contract Began: 1/13/2011
Most Recent Contract Ended: 1/27/2011
Phos Painting
Small Business -- Pullman, WA
Time Card Tracker using Text Messaging
Description
Time cards are difficult to manage for their mobile painting crews. This application allows employees to send text messages to clock in and clock out. Employees check that their hours are correct through a web interface, and there they may request changes where necessary. The bookkeepers can make updates and see the total hours worked for each employee. Total hours are calculated for regular and OT pay, as well as hours for different insurance conditions.
Technologies Used
ASP.NET (C#), MS SQL, HTML, CSS
Initial Contract Began: 3/27/2010
Most Recent Contract Ended: 7/1/2010
Pullman Christian School
Non-Profit -- Pullman, WA
Progress Reporting Program
Description
SumTech converted a system of Word documents and Excel spreadsheets to an Access database used for tracking students, courses, and grades, as well as printing report cards.
Technologies Used
MS Access
Initial Contract Began: 9/30/2008
Most Recent Contract Ended: 1/1/2009
Ski Dogs
Small Business -- Pullman, WA
Marketing Website (Creation, Maintenance)
Under Construction
Description
This is a marketing website for a restaurant and catering business.
Initial Design by Alicia Baker
Technologies Used
HTML, CSS, WordPress
Initial Contract Began: 8/25/2010
This project is currently in progress
Summation Data
Small Business -- Pullman, WA
Market and Technology Research
Description
Did initial market research for idea potential. Also research new technologies to support building the idea.
Technologies Used
ASP.NET MVC, Entity Framework
Initial Contract Began: 11/1/2010
Most Recent Contract Ended: 2/1/2011
Summit Anesthesiology, Inc.
Medium Business -- Apopka, FL
Marketing Website (Creation, Maintenance)
www.summitanesthesiologyinc.com
Description
This is a marketing website for an anesthesiology clinic.
Initial Design by Alicia Baker
Technologies Used
HTML, CSS, ASP.NET
Initial Contract Began: 5/11/2009
SumTech Business Solutions
Small Business -- Pullman, WA
Marketing Website (Creation, Maintenance)
Description
Informative website to allow businesses to see SumTech's work and learn about their services.
Logo designed by Alicia Baker
Technologies Used
HTML, CSS, ASP.NET (C#), JavaScript, jQuery
Initial Contract Began: 6/1/2008
Most Recent Contract Ended: 7/1/2008
Budgeting and Personal Finance Program
Description
What used to be an Excel spreadsheet for assessing our budget and how we spend our money was converted to an Access database as a more efficient and powerful tool. Receipts can be entered into the database, and a checkbook type display shows the current state of the finances.
Technologies Used
MS Access, ASP.NET (C#), MS SQL
Contacts Program
Description
SumTech is creating a program to track contacts with other pertinent information using the Google API system. This will eventually be merged with other web applications that are being developed.
Technologies Used
MS Access
Time Management and Scheduling Spreadsheets
Description
24-hour schedules and weekly schedules are commonly used by those who want to use their time effectively and not forget their priorities. SumTech has created an Excel 24hr x 7day calendar broken up into 15min increments (or 5min for the super ambitious) that fits on one page. Highlighted colors are used to differentiate types of activities like work, meetings, school, travel, social, sleep, free time, etc. that are programatically added together. This is a useful tool to prioritize what a general week should look like or to examine what you really do in a week.
Technologies Used
MS Excel
USDA-ARS
Federal -- Pullman, WA
USDA
In Development
Description
Technologies Used
MS Access, MS SQL
Initial Contract Began: 11/2/2010
This project is currently in progress
Vet-Span
Small Business -- Greenville, NC
Marketing Website (Creation, Maintenance)
Under Construction
Description
This is a marketing website for a veterans consultant firm.
Initial Design by Alicia Baker
Technologies Used
HTML, CSS, WordPress
Initial Contract Began: 2/9/2010
This project is currently in progress
Veterans of Modern Warfare
Non-Profit -- National
Online Store
Description
This online store was placed inside the existing website for VMW. PayPal is used to manage payments. Emails are sent to bookkeepers and suppliers so that payments and orders are handled in a timely manner.
Technologies Used
PayPal, HTML, PHP, MySQL, Joomla!, MS Access
Initial Contract Began: 12/14/2009
Membership Form, Database and Administration Application
Description
As a growing national organization, VMW needs an efficient way of tracking membership, chapters, dues, etc. SumTech created an online membership application that submits information to a database for storage. Several validations are used to test that valid information is being entered. Administrators can review, update, add, and delete membership information through an MS Access program. Also, the users can use the power of MS Access queries to find useful statistics about their organization.
Technologies Used
HTML, JavaScript, PHP, MySQL, Joomla!, MS Access
Initial Contract Began: 2/6/2009
Most Recent Contract Ended: 7/23/2009
Woodland Heights Mobile Home Park
Small Business -- Moscow, ID
Marketing Website (Design, Creation, Maintenance)
Description
This website is a portal for potential and current tenants of Woodland Heights Mobile Park in Moscow, ID. Persons looking for an affordable place to live can see which units are available or will be available soon, monthly rent, and other descriptions of the units. Current units have access to documents and frequently used forms. Anyone wanting to contact Woodland Heights may do so through a contact form directly on the website for their convenience.
Technologies Used
HTML, CSS, PHP
Initial Contract Began: 11/21/2008
Most Recent Contract Ended: 1/1/2009
Income and Expenses Program
Description
This bookkeeping application tracks rental unit income and expenses. Information about tenants is also stored.
Technologies Used
MS Access
Initial Contract Began: 11/1/2008
Most Recent Contract Ended: 2/6/2009
WSU - ASSESS
University -- Pullman, WA
Education Tools Website
In Development
Description
Technologies Used
HTML, CSS, jQuery, Python, Django
Initial Contract Began: 3/9/2011
This project is currently in progress
WSU - Biomedical Communications Unit
University -- Pullman, WA
Media Library Tracking System
Description
Instead of tracking their media library resources with tiny slips of paper, SumTech converted their process to an electronic management system. A simple user interface was created to allow users to track when media resouces where checked in and out, allow administrators to edit and correct data, and allow infrequent users to intuitively understand how to work with the software.
Technologies Used
MS Access
Initial Contract Began: 4/7/2008
Most Recent Contract Ended: 5/2/2008
WSU - CAHNRS and WSU Extension
University -- Pullman, WA
Financial Tracking and Budgeting System
In Development
Description
Technologies Used
MS Access, MS SQL
Initial Contract Began: 11/16/2009
This project is currently in progress
WSU - Field Disease Investigative Unit
University -- Pullman, WA
Investigations Documentation Program
Description
SumTech developed a MS Access database to log and search critical field investigation data as well as generate reports. The program code was documented to show how different sections of code work so future additions to the database could be easily made by other persons.
Technologies Used
MS Access
Initial Contract Began: 2/5/2008
Most Recent Contract Ended: 4/14/2008
WSU - Plant Pathology
University -- Pullman, WA
Bacterial Culture Log
Description
Over a decade of research data from several researchers was compiled into a single large spreadsheet, and this information was inserted into a database. The application is used to log specimen test results as well as where the specimens are stored.
Technologies Used
MS Access
Initial Contract Began: 4/27/2010
Most Recent Contract Ended: 10/22/2010
WSU - Psychology Department
University -- Pullman, WA
Administrative Database
Description
Use of Word documents, Excel files, and paper trails can be time consuming to manage. For this department, Brian Dorgan created an administrative database to maintain confidential information about people, courses, keys, committees, rooms, money, and research projects. This process involved combining a collection of spreadsheets and documents into one robust database to accomplish several necessary tasks done by staff. Now their workload is stream-lined and more effective for occomplishing their goals.
Technologies Used
MS Access
Initial Contract Began: 5/6/2008
Most Recent Contract Ended: 8/15/2008
WSU - Veterinary Clinical Pharmacology Laboratory
University -- Pullman, WA
Laboratory Administration Database
Description
A work flow management system was created to stream-line several processes for this laboratory. Spreadsheets and Word documents were converted to a database application in which redundant data only needs to be entered once. Lab sample information (including owners and results) are easily searchable, financial information is track-able, and laboratory statistics and reportable.
Technologies Used
MS Access, MS SQL
Initial Contract Began: 5/14/2010
Most Recent Contract Ended: 7/15/2010
