Chapter 1 - The Story Begins
Every story has a beginning. This post represents the beginning of this story. In this introductory post, I will give you an overview of my upcoming project. Without further ado, let me begin my tale.
Last week, I briefly met with my project sponsor, Pam Doffek, who is an Associate Librarian and the Director of the Goldstein Library here at the College of Information. At this meeting, we discussed what the project was about. A few years back, the library apparently had problems with mold. In an attempt to monitor the situation, the College of Information purchased an HVAC monitoring system. This system included small devices called HOBOs (click the link to see the exact model). These HOBOs were stationed throughout the library in an effort to collect both temperature and relative humidity data.
With the devices in place, the library needed a method for getting the data off the devices. I was told by Pam, and by my instructor Melissa Raulston, that a previous group, in a previous semester, had begun work on this project. This project has come to be known as “The HOBO Project.” The previous group had developed procedures to pull the data off the devices. By using the software that came with the system, Boxcar Pro 4.3, the group was able to get the data off the devices and into an Excel spreadsheet. However, from there, the group was unable to do anything with that data. There is where the project currently is at this time. The library has plenty of this data collected, but they have been unable to do anything with it. After having the chance to review this data, I became very excited. I was excited because I knew I was going to be able to help Pam and the Goldstein Library. I was confident that I could take this data and make it useful. I was confident that I could succeed where others have failed.
The first thing I noticed was that this project consists of some of the same tasks that I commonly complete at my current job. I work at a local real estate marketing company (there is more about this in my About Me section) where on a daily basis, I handle large amounts of data dealing with sold and listed homes. I work with data from thirteen Florida counties where I clean it up, organize it, and then put it into a printable format. Having done this job for over two and half years now, I have learned not only how to use Excel, I have learned how to take what seems like raw data and put it to use. So when I saw the data for the HOBO project for the first time, a variety of ideas instantly popped into my head. Having come up with so many similar procedures at work, I knew that I was going to be able to help out.
This project actually combines many of things that I enjoy working with. I enjoy being given a problem which requires me to create an answer that will not only solve the problem, but will allow others the opportunity to solve the problem as well. This project allows me to work on my problem solving skills. It also gives me the opportunity to work with unfamiliar technology. On top of that, it gives me the chance to improve my Excel skills by allowing me to create custom macros. Finally, this project gives me a chance to get more experience writing documentation. With that said, it should be noted that I am working alone on this project. As such, I am responsible for all work included. I will also be graded on the same level as my classmates who are working in a group. I had hoped to be able to work with a small group of people for my project as this would have given me an opportunity to showcase my leadership and management skills in a real world project. However, working alone has its advantages. It allows me to work on my communication skills as well as my time management skills. I will also be able to see how well I can handle working on a project alone. There may be an occasion down the line where I may have to work on a project alone and the skills I learn from doing this project alone could be very useful. In the end, I am very excited to begin my work on this project.
With that said, let me give you a little more detail about the project and its requirements. Most of the following information is coming from the project plan write-up that Pam gave me (you can read the entire document by clicking here). The main goal of this project is to develop a comprehensive system of data collection, organization, and problem development determination for the Goldstein Library’s HVAC monitoring system. An objective is to provide the Goldstein Library Director and her staff a means to easily download, convert, and determine out of range HVAC system occurrences on a monthly basis. These occurrences must be collected on one page for easy viewing. An out of range occurrence includes any data point in which relative humidity (RH) is greater than 55%, the temperature is greater than 70 degrees Fahrenheit, or a combination of both. All data and conversions need to be saved into a new folder organization system that is more logical than the one currently in place. For example, previous and new data could be stored in a folder system that is organized by academic year.
The completed project will include existing data and data collected during the Spring 2008 semester. The completed project also includes detailed documentation of all processes, including capturing data and downloading it to a designated computer, as well as conversion of the native data from the Boxcar software to other standard formats as necessary, such as .txt, .xls, or .pdf. All documentation will be provided in electronic format, preferably in Word 2007 or Word 97/2003 format and given to Pam by the end of the project period. Occasional coordination meetings will be arranged during the semester as needed. Finally, if time permits, a secondary objective is to fix the two non-functioning data collection devices or to provide the cost inherited in replacing them.
That wraps up the introduction of the project. As mentioned, I am looking forward to working on this project and I am excited to be able to help out wherever I can. I have begun jotting down ideas on how to start this project. I feel a good place to start is by first reorganizing the already collected data into a more organized folder scheme. This way, with the new scheme in place, any data that is downloaded in the future will follow this new scheme. I will also take a look at fixing those two non-functioning devices. Fixing these ahead of time will allow me to develop any procedures with these devices in mind. I will also make sure to document all ideas, tasks and completed work for later review. My next post will cover the work I have done on the folder scheme and any progress I make with the non working devices. Until then, thanks for reading.