7+Office+Productivity+Tools

Module 7: Office Productivity Tools

PowerPoint Results Presentation:Use & Purpose of Facebook Data Excel Spreadsheet

PowerPoint Results Presentation: Use & Purpose of Cell Phones Data Excel Spreadsheet


 * Awareness-**I knew about surveys through my involvement in teaching. We use surveys to record student satisfaction and class data. I also was familiar with Excel and PowerPoint. I use Excel to record and track grades in the classes I teach. Additionally, I use Excel in tracking rosters for student-athletes. I was not aware of the graphing capabilities in Excel. Sure, I had seen the graphs, but had never had reason to think I needed them.


 * Exploration & Filtration-** Based on the requirements for the exercise, Excel was the most logical choice for accumulating, recording, and processing data.


 * Learning-** It didn’t take me long to become comfortable using the tables and graphs in Excel. The most difficult was the transition between the surveys themselves and the synthesis of the data. In order to effectively use Excel, I first synthesized the data into manageable bits. I recorded the data into cells, which was used to create the graphs. In exploring the additional personal data collected on the surveys, other trends were seen, and graphs were established leading to other interesting divisions in the data.


 * Application-** This was an interesting exercise. I’m not sure how it would be used in my classroom, but I am now interested in graphing student grades for a visual representation of their progress in my class. Perhaps a trend will emerge on particular lessons across different semesters. This may indicate a need to revamp a lesson, or provide additional instruction or time for the writing.