Tuesday, December 4, 2007

Session 4 Reflection

We had a hands-on session with handling survey results using MS Excel and SPSS. When Dr Quek showed us the whole process from data entry to data analysis, I was daunted by the laborious task awaiting me. Thankfully, we devised efficient and time-saving strategies to tackle the task. We updated our individual responses of WIHIC using Google Doc simultaneously from our terminals rather than using one terminal to enter the data. After all the data from other groups were compiled with ours, we proceeded to copy it in SPSS for data analysis. And instead of updating the variables' names one-by-one, we ingeniously use 'Transpose' function in Excel to copy the name of variables from our Excel sheet to SPSS with a few clicks of the mouse. How it works? This 'Transpose' function will convert data in horizontal rows to vertical rows as the variables in SPSS are arranged in vertical columns in contrast to Excel.

After today's session, I gained a better understanding of school learning environment and was introduced to an instrument SLCEQ that is quite similar to school climate survey.

No comments: