Monday, September 27, 2010

How to Excel at Excel....



Excel is a wonderful and often overlooked tool in the classroom.  This program not only helps to organize information, but can be used to better facilitate the classroom.  Several examples of Excel applications are stated below.


1) Excel can be used to create matching sections on quizzes and test.  Especially as a foreign language teacher, the ability to organize vocabulary words in a meaningful and easy manner would be greatly appreciated.  By using Excel, there is no need to worry about lining up the tab function or bothering with indentations.  


2) In addition to using the cells for vocabulary matching, the same cells could be expanded and enlarged in order to create flashcards for the students.  Whether they are to review the concept or as pieces in a game, by having organized electronic information, they could simply be reprinted for the following year (should the students lose or mangle pieces).


3) Excel can be used to organize the pieces of a large assignment that the students need to complete.  By inserting the information as it comes, grading the final project will be much easier as there will be a natural progression. For example, my students are working on two month long project discussing the intricacies of a Francophone country.  The information needed could be inserted into a spreadsheet in order to chart the progress so the students could see the amount of work still needed to be completed.  It helps the teacher stay organized as well.


4) The graphing tool in Excel will be useful for the parents to see how well their student performed in the various evaluation areas. A pie chart for each student divided into sections of homework, classroom participation, projects, and tests/quizzes could easily show inquiring parents how their children perform in the multiple facets of the classroom.  The charts could also be used as part of the testing to see if children have learning or behavioral disabilities.  


5) A spreadsheet tool such as Excel would be very helpful in course scheduling.  As a school, trying to coordinate where everyone is at any given point in time is a difficult task.  Using the spreadsheet would enable the administrators and educators to recognize the location of each teacher and student.  It is easy to move around rows and columns to ensure that people are in the right place and not scheduled for two different places at the same time. 


There are multiple ways that Excel can be used in the classroom and with the administration.  These are only a couple of options.

No comments:

Post a Comment