Monday 1 October 2012

Entry 008: Our progress during semester break so far

We are doing good so far. We meet up with our supervisor on Monday 24/9/2012. Before the meeting, we did our work first. We were transferring the data from the current chemical inventory form to an excel form and tried to create a sample template using an excel spreadsheet (which includes the name of the chemical, date of inventory check and initial quantity) where a user can just type in the quantity of a specific chemical taken out and it will automatically calculate the quantity left. To find out more about the use of Microsoft Excel, we did borrow a couple of books to assist us in our findings. On the other hand, we did explore using Microsoft Access; trying to create a database of our own. We also came up with a questionnaire for the TSOs. With their response, we hope that it can help us further with our FYP. With all that being done, we proceed on with our meeting with our supervisor.

We updated her about our progress and discussed more about our FYP. We first showed her the excel part and questionnaire that we have done. There is a need to improve on the excel and for the questionnaire, we have to arrange the questions in such a way that the first question is an introductory question and it will slowly build up from the beginning. Initially our questions were not in order. We then talked about our mid term review. Examples, what to include in our mid term review, the format, etc. Before we end off, we told our supervisor that we had arranged date to visit to W318 with the TSO in-charge which is on Tuesday 25/9/2012.
The next day, on Tuesday 25//9/2012, we went to W318 to continue with our FYP and we were shocked to see that the lab was closed. So we went to W314 and asked the TSO in-charge about W318. We were informed that there are only two chemicals available in W318. The only two chemicals available are kerosene and ethanol. Since we were already in W314, we conducted a survey on the chemical inventory. We also did for W316 since these two labs have the most chemicals used. At the same time, we interviewed the TSOs on what are the problems arised while updating the inventory and what can be improved, and any other suggestions from them.

On Thursday 27/9/2012, we went back to school again. Instead of going to T11A313 to conduct another survey, we went to T11B401 as we still have some unfinished business. We presented our excel template that we have designed to Ms Florence, TSO for T11B401 and she was quite impressed with our work but there was still room for improvement. She also provided us with some suggestions on what we can do to improve on the excel template.

The following day, Friday 28/9/2012, we decided to visit T11A313, which was arranged by our supervisor earlier that week in order to compare different labs with different response from the TSOs.
During the inventory taking, we managed to find a tab classified as "Poison chemicals" which was new to us as the other labs we visited so far does not consists of poisons. In addition, we interviewed Ms Cheryl regarding the current inventory form and asked for improvements that could be done.
Thats all for now~

No comments:

Post a Comment