Teaching students how to effectively use spreadsheets and databases is an integral part of using technology in the classroom. Students, who are as young as 4-5, are capable of learning early word processing skills. In order for students to be successful in using spreadsheets, they must exhibit keyboarding skills. Without being able to keyboard efficiently, the experience will be less than positive or productive. “Some educators feel that students will never become really productive on the computer until they learn 10-finger keyboarding” (Robyler & Doering, 2013). Not only do educators need students to be proficient at keyboarding, they must also be able to use it as an authentic writing tool. “The research encourages us to understand how well children adapt to the keyboard as a writing tool. Ideally, the control this tool might offer over the mechanics of writing could permit cognitive resources to be redirected into the creative work of constructing content” according to Crook and Bennett, 2007.
The relative advantage of using spreadsheets and databases in the classroom is widespread. Spreadsheets provide teachers and students alike with an outstanding organizational tool. “A spreadsheet saves valuable time by allowing teachers and students to complete essential calculations quickly” (Robyler & Doering, 2013). Besides increased productivity, spreadsheets “offer an efficient way of demonstrating numerical concepts such as multiplication and percentages and numerical applications (Robyler & Doering, 2013). Worksheets can take statistical data and quickly convert it to a graphic illustration. Students of all grade levels are capable of creating spreadsheets. The advantage of using spreadsheets and databases in the classrooms is that the students will be learning skills applicable in the workforce.
Although spreadsheets are typically used for mathematical applications, language arts skills can also be taught using this approach. With a little time and patience, interactive worksheets, reading lists, Cornell notes, and flashcards can be created. Some other ideas include:
- Compose reading lists for summer reading or for weekly reading activities.
- Create spelling tests for students who are absent.
- Daily journal writing activities can be provided to the students to practice writing skills.
- MadLib templates can be created so that students can express their creative side.
Databases are yet another highly useful tool in the classroom. “Perhaps no other technology resource has had as great an impact on education as word processing” (Robyler & Doering, 2013). Word processing software has streamlined the administrative side of teaching to the point of near seamless integration. Educators are able to draft professional looking documents and save the file for future use. Documents be shared easily either electronically or if necessary, printed copies. Students benefit from word processing software also. Whether it is drafting and publishing a research paper, working collaboratively, or completing a reading exercise, the experience gained from word processing software is a skill necessary in the 21st century.
Regardless of how spreadsheets and databases are integrated into the classroom, the productivity associated with this software is difficult to explain. Gone are the days balance books and adding machines. The only barrier standing in the way for teachers to integrate spreadsheets in the classroom is the willingness to step outside of ones comfort zone and try something new. The learning curve may be steep but the rewards are endless.
Crook, C., & Bennett, L. (2007). Does using a computer disturb the organization of children’s writing?. British Journal Of Developmental Psychology, 25(2), 313-321.
Roblyer, M.D. and Doering, A.H. (2013). Integrating Educational Technology Into Teaching, (6th ed.). Upper Saddle River: Pearson Education, Inc.
AECT Standards: 1.1 Instructional Systems Design (ISD); 1.2 Message Design; 1.3 Instructional Strategies; 1.4 Learner Characteristics; 2.3 Computer-Based Technologies; 2.4 Integrated Technologies; 3.1 Media Utlization