Sunday, December 6, 2009

Excel Spreadsheets and Other Technology

During EDU 580, Tech Module IV, there were several different technology components that were integrated into EDU 584. One of the most comprehensive pieces was the use of Microsoft Excel and Microsoft Word. Through this course I learned how to create and use a set of spreadsheets and how to use them to effectively collect data. I was able to discover that the use of spreadsheets can save a lot of time and effort when calculating grades and sorting data. Before this module I had used spreadsheets, but never effectively. I now understand how to input data and create formulas to assist with data analysis. I have also learned how to create chart and graphs with the data and then to integrate it into Microsoft Word Documents. These skills will be useful as I begin my research project next year.

During this module I also had the opportunity to explore using Google Docs to conduct an online perception survey. It was a really useful tool because answers to the questions were automatically saved to a spread sheet. This sheet could be directly turned into charts and graphs or added to an exiting Excel document. This technology once again demonstrated a convenient way to save time.

I expanded my use and knowledge of imovie during the course as well! As part of my integrated unit my students created imovies demonstrating their knowledge of how life was different in the 1800's as compared with today. The process took a lot of time to complete, but the students were excited to make their own movies. The products showed that the students had mastered the essential learning components of the unit.

The combination of EDU 580, Tech Module IV, and EDU 584, also helped me to continue to strengthen my skills using a wikispace. I was required to create a resource wiki including technology links for a particular unit of study. I created a math resource wiki with some colleagues. It was a lot of work, but a good experience. The end result is pretty spectacular! Check it out at MallettMathResources.wikispaces.com!

No comments:

Post a Comment