Spreadsheets and Databases in the Classroom

Spreadsheets have a wide variety of classroom uses. They may be more useful than many teachers realize. While many teachers may use spreadsheets for their own purposes (gradebooks, assessment tools, etc.), the reality is that spreadsheets and data bases can be just as useful for our students.  Teacher use of spreadsheets serves many purposes including sorting data, identifying trends, and saving time. Couldn’t our students use speadsheets for the very same purposes? Yes, it requires instructional time to teach students how to input data and how to create formulas, but it may be time well spent if, in the end, it saves time.

Last week, I observed a lesson in a primary grades classroom. Although I entered the classroom quite some time after the lesson had begun, I did instantly realize that students were students were using bar graphs and pie charts to record data about color preferences. In my nearly 30 minutes in the classroom, almost all of the time was spent coloring in the pie charts and graphs. How powerful it would have been to have seen the teacher use a chart in spreadsheet to show the students how the pie chart would change if the numbers were different!

Spreadsheets have many applications in a math classroom, but I have found that spreadsheets can be applied in the humanities as well. There is no doubt that trends and patterns in human behavior can be tracked numerically and sorted in meaningful ways. Some studies suggest that the use of spreadsheets in classrooms can improve critical thinking skills. It has been argued that building spreadsheets can improve abstract reasoning. When students build and create spreadsheets they are given more opportunities to explore open ended investigations, problem oriented activities, and active learning.

The more teachers can find ways to implement spreasheets into their instruction, the more students will be able to manipulate numbers, see powerful visuals, and explore trends and patterns among numbers.


Baker, John and Sugden, Stephen J. (2007) “Spreadsheets in Education –The First 25 Years,”Spreadsheets in Education (eJSiE): Vol. 1: Iss. 1, Article 2.
Available at: http://epublications.bond.edu.au/ejsie/vol1/iss1/2

2 thoughts on “Spreadsheets and Databases in the Classroom

  1. I agree that showing students how graphs can change with a spreadsheet it is also vital that students really understand what is happening, and they do that by making the graph themselves. What would be ideal is to bring the spreadsheet created graphs into the lessons a little further down the road when students really understand what a graph is all about. It is also great for comparing the different types of graphs. The same data can produce several different types of graphs.


  2. I really love how you included a classroom example in your blog post. It added both credibility and personalization to your blog post. Your experience in that classroom makes me wonder if we unintentionally convey upon our students our own baggage about what we do and don’t find intimidating (coloring vs. creating formulas). Thanks for a thought provoking post!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s