Tuesday 9 October 2012

Entry 009: Another Week of FYP

Mid-term review is getting closer as another week has passed.
During last monday, 1/10/12 we decided to try out more on IT stuffs (such as Excel, Access) for the ease of chemical inventory management. At the same time, we transferred the inventory which was taken down on hardcopy for labs T11B401, T11B410, W314 & W316 into a excel spread sheet. For the excel spread sheet, we re-designed the headers for the inventory forms in softcopy. This was due to a few redundant sections such as "chemical name","Hazard Class".

On Tuesday, 2/10/12, we continued our fyp by giving a kick start for the mid-term review presentation. We decided to use "Prezi" instead of "powerpoint" as it is a more innovative approach for presentation. We started by exploring the features of prezi that it can provide and decided on a theme to be used. Basically, we tried to focus on the mid-term review and include what should be included during the presentation for that day.

On Wednesday, 3/10/12, before meeting out supervisor, we went to prepare what we have done in a proper manner. During the meeting with out supervisor,we presented to her what we have done so far. First we showed her the chemical list of the various labs (T11B401,T11B410,W314 &W316) and the re-designed inventory form in soft copy. She reviewed it and gave us some advice and corrections/improvements to what we have done. Next, we presented to her the soft copy of inventory forms and the re-designed chemical inventor and finally the prezi presentation. We were told to look out for legislation under National Environment Agency(NEA) to see what are the requirements of an inventory list so that we can improve on our forms.

On Thursday, we printed out the questionnair survey forms and went to various lab to ask for the TSO's response. In addition to that, we also interviewed them on some of the problems/constraints they faced during recording. Through these response, we should be able to think of ways to ease those TSOs with the problems they are facing.

As for friday, we decided to brainstorm online and improve on our mid-term review presentation. Thats all for now~

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~