Project Summaries
Show All 
Professional Web Applications
Time Card Tracker using Text Messaging
Phos Painting
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
Online Store
Veterans of Modern Warfare
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
Veterans of Modern Warfare
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
Professional Databases
Timecards Database w/ MS Access Training
Motley Motley, Inc
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
USDA
USDA-ARS
In Development
Description
Technologies Used
MS Access, MS SQL
Initial Contract Began: 11/2/2010
Project is currently in progress.
Laboratory Administration Database
WSU - Veterinary Clinical Pharmacology Laboratory
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
Bacterial Culture Log
WSU - Plant Pathology
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
Financial Tracking and Budgeting System
WSU - CAHNRS and WSU Extension
In Development
Description
Technologies Used
MS Access, MS SQL
Initial Contract Began: 11/16/2009
Project is currently in progress.
Customers, Sales, and Marketing Program
Andy Sewell Water Colors
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
Income and Expenses Program
Woodland Heights Mobile Home Park
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
Administrative Database
WSU - Psychology Department
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
Media Library Tracking System
WSU - Biomedical Communications Unit
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
Investigations Documentation Program
WSU - Field Disease Investigative Unit
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
Payroll Program
Airway Hills Miniature Golf and Driving Range
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
Professional Websites
Education Tools Website
WSU - ASSESS
In Development
Description
Technologies Used
HTML, CSS, jQuery, Python, Django
Initial Contract Began: 3/9/2011
Project is currently in progress.
Marketing Website (Maintenance)
Airway Hills Miniature Golf and Driving Range
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
Marketing Website (Creation, Maintenance)
Ski Dogs
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
Project is currently in progress.
Marketing Website (Creation, Maintenance)
Vet-Span
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
Project is currently in progress.
Marketing Website (Creation, Maintenance)
Summit Anesthesiology, Inc.
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
Marketing Website (Design, Creation, Maintenance)
Woodland Heights Mobile Home Park
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
Informative Website and Newsletter (Design, Creation, Maintenance)
In Prayer for Washington State
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
Marketing Website (Creation, Maintenance)
SumTech Business Solutions
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
Professional - Other
Market and Technology Research
Summation Data
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
Volunteer Projects
Progress Reporting Program
Pullman Christian School
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
Worship List Documentation Program
Living Faith Fellowship
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
Personal Projects
Budgeting and Personal Finance Program
SumTech Business Solutions
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
SumTech Business Solutions
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
SumTech Business Solutions
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
