Running Head THE USES OF EXCEL IN CLASSROOMS 1
TheUses of Excel in Classrooms
MicrosoftExcel worksheets offer flexibility with its formula, graphs,functions, charts, and tables especially in the classroom. In theprocess of education, teachers and students are increasingly usingMicrosoft Excel. In the process of teaching and learning, studentsand educators both benefit from the utilization of Excel worksheetsin the classroom (Wyels, n.d.). The focus of this essay is to findout ways in which Microsoft Excel can be adopted in today’sclassroom.
Whenexplaining Mathematical related material to students, I would employExcel worksheets in the making of calculations. With many graphs andcharts available in a spreadsheet program, I can use to explain thecreation of graphs. In the use of various functions and theorems, Ican employ Excel because it is adaptive to arithmetic problems andalgebraic equations. Spreadsheets are well suited for statisticalanalysis therefore with the requirements of a course, I can choose atailored worksheet or template so as to teach students effectively inan efficient way (Wyels, n.d.).
Theuse of Excel enhances understanding with a graphic presentation andtherefore I would use it to provide a visual representation of datamaking it easier to interpret. To enhance a student’s understandingof the analysis of data, I would provide the students with a completechart and give them an opportunity to reconstruct the underlyingworksheet. This will go a long way to ensuring students grasp therelationship between data and tables (Wyels, n.d.).
Iwould use Excel as a grading book it would help me to find out theaverages, medians and other analytical formulas for student’sgrades. Excel can assist me to weight different assignmentdifferently. For example, how I want the home assignment to affectthe final grade. I may also weight individual assignments so that atough assignment will count for more than a cheap one. With the helpof Microsoft Excel, I can spot individual student grade trends andtherefore be able to single out students that need extra help. I willbe able to evaluate whether a coursework assigned was too easy or toohard (Wyels, n.d.).
MicrosoftExcel has a non-mathematical side to it, and this I can use to teachthe concepts that a class finds it difficult to understand. If it isa historical lesson, instead of listing events and their timelines, Ican use the Excel`s grid format to create schedules that students canvisualize. This can be turned into a game where students will be ableto match events to timelines presented and sort them in order (SouthEastern Regional College [SERC], n.d.). With the ability to convertExcel into a web page, I would use it to share information withstudents in different classrooms. With this being a fun applicationit would be easier to impart knowledge on students (Wyels, n.d.).
Withexcel, I would be able to create flashcards that students can use fortest practice and as a revision tool. Excel will also enable me tocreate a virtual timetable that students will be able to accesselectronically and be aware of upcoming events. Duringextracurricular activities, I would use Microsoft Excel to recordentries for events like Scrabble scores and create music sheets wherestudents can compose their songs. I would also use Excel to ensurethe health of my students by teaching them healthy eating habits. Iwould accomplish this by creating a worksheet where individualstudents will keep track of what they drink and eat every day andmake changes accordingly (Wyels, n.d.).
Inconclusion, Excel spreadsheets are important in that they enablestudents to learn in different ways. Unlike paper, spreadsheets canbe changed so as to see the response of charts with a change in datamaking learning fun. With its interactive interface excel enhancesunderstanding, it has applications past the scientific field, makingit a perfect tool for teaching and learning (SERC, n.d.).
SouthEastern Regional College. (n.d.). Why Teach with Spreadsheets?Retrieved fromhttp://serc.carleton.edu/sp/library/spreadsheets/why.html
Wyels, C.(n.d.). Engaging Students via In-Class Worksheets | MathematicalAssociation of America. Retrieved fromhttp://www.maa.org/programs/faculty-and-departments/curriculum-department-guidelines-recommendations/innovative-teaching-exchange/in-class-worksheets