dunsinger field tech data entry_1

dunsinger field tech data entry_1 - Edward Dunsinger IST...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Edward Dunsinger IST 440W Assignment 1 – Potential Applications Instructor comments: a great idea, team should attempt to automate the data entry, and provide standard descriptions of work. 4- 5 team members. Problem Description: I currently work as a Field Technician Supervisor for a casino systems/equipment manufacturer. During the course of a week, each technician is required to keep an electronic log of all support calls responded to. This log consists of the following information: Facility Name Tech ID Device Location Problem Type Device Serial Number Problem Description Device Number Problem Resolution Cabinet Part Style Date Part Description Time In/Out Part Number Total Time Down Tech ID Currently all information is collected via an Excel Spreadsheet. This method of data collection is clumsy at best, and is solely dependant on how accurately a technician inputs data. To combat errors, dynamic drop down lists and the use of VLOOKUP formulas are used to automate some columns of the log. A new method of data collection is needed.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

dunsinger field tech data entry_1 - Edward Dunsinger IST...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online