Tag Archives: mindtool

Filling the Mindtool-Box: Google Spreadsheets

25 Mar

The robust and diverse features of Google Docs (and now Drive) have been increasingly entering our K-12 classrooms.  By working in the cloud, students have lost less homework, used less paper and been more engaged in learning.  Yet, the greatest benefits of Google Docs may not  be so much in what can be done in to construct knowledge independently by our students, but in what can be done to construct knowledge collaboratively.

In particular, collaborative use of the Google Spreadsheet has great potential for creating impactful and thought-provoking learning experiences with our students.  These types of activities go a long way to meet the requirements set by the Common Core State Standards (CCSS) and the National Educational Technology Standards for Students (NETS-S).  Through collaborative work and discussion, students work on several of the standards and goals pertaining to problem solving, speaking and listening, presenting ideas, recognizing patterns and developing communication skills.  Plus, they develop creative and critical thinking through technology by using “models and simulations to explore complex systems and issues” (NETS 1c), “identify trends and forecast possibilities” (1d), “identify authentic problems for investigation” (4a), and to “collect and analyze data to identify solutions and/or make informed decisions” (4c).

Here’s an example of how this can work:

– The teacher creates a Google Spreadsheet, formats and labels a table/chart, and shares it to the students in the class.  (As students become more comfortable with this tool, having them decide how to organize their information or data themselves can be a great part of the thinking/learning process!)

– The students research and collect data on a topic independently or in small groups and enter it into the spreadsheet.  For example, in PE, students could record the rate at which they can perform jumping jacks in order to set a goal for an upcoming fundraiser.  In science, the students might record weather data over time, comparing and observing weather patterns.  In social studies, students might collect population data, the cost of various goods, or information about elections.  In math, students can survey students about their favorite video games and tally results.  The possibilities are endless… and can easily be used in all grade levels and curriculum areas!


– Next, students use the spreadsheet tools to work with the data.  In the Google Spreadsheet, students can create graphs to model and compare the shared data, use formulas to find averages, and make predictions based on patterns recognized in the collected data.  Students can even sort and categorize lists and information as well.  As the teacher, you can monitor the students’ progress in real time by viewing the document and use your observations as formative assessment.  This catalyzes an opportunity to provide just-in-time support for struggling learners and enrichment for those achieving mastery.

– Finally… well, there is no final instruction. Why?  The collection and modeling of data is a great jumping off point for further learning, research and inquiry on any topic!  Use this collaborative knowledge base in your students’ spreadsheet to prompt class discussions, presentations, group work or even digital media creation.  In my third grade classes, students used the data they collected to inform persuasive data-driven writing and animated commercials like the one featured on this page.  In fact, cross-curricular integration possibilities abound when working with visual representations of data and information.

Best of all?  The kids love it!  The interaction between students, the camaraderie of building a knowledge base together (even in younger grades!), promotes a desire to learn and a love of the inquiry process.  It’s time to bring some excitement to the use of data in the classroom… and Google Spreadsheets are a great way to do it!

Filling the Mindtool-Box: Bubbl.us

18 Feb

Bright, independent, critical thinkers.  Of course, that’s what every teacher wants  to have filling their classrooms.  As it turns out, there are strategic ways that we can use technologies to encourage the development of these thoughtful learners.

According to David Jonassen (2006), Mindtools allow students to create models of their cognitive connections. In Meaningful Learning with Technology, Jonassen and others elaborate on the Mindtool concept, stating, “When using computers as Mindtools to model phenomena, students are teaching the computer, rather than the computer teaching the student… learning with Mindtools requires learners to think harder about the subject-matter” (p. 193).  As a Mindtool, concept maps specifically provoke, and then aid in modeling, the cognitive connections that students are making.  Used effectively, concept maps provide an adaptive framework for students to use to identify and model connections and relationships between knowledge and ideas.

Jeff Hawkins

In the interesting TED Talk, How Brain Science Will Change Computing, Jeff Hawkins (starting around minute 10) talks about intelligence as the ability to recognize patterns and connections, then using that recognition to make predictions about novel situations.  In my experience, I have seen that concept maps help develop such intelligence by giving our students frameworks for developing and organizing their thought patterns.

Want an easy way to give this a try?  Bubbl.us allows students to have a free account where they can create and save up to 3 concept maps at any given time.  The application is incredibly easy and intuitive to use.

bubbl.us | brainstorm and mind map onlinePlus, it gets better! Bubbl allows students to work collaboratively on the same concept map (sheet).  Students can “share” their concept maps with the other students to cooperatively work on brainstorming and research activities, provoking the type of reflective and deliberative thinking perfect for meeting Common Core standards!

Here are a few ideas for getting started!

  • Collect research with source links on a social studies topic.
  • Brainstorm ideas for writing a narrative story.
  • Analyze a text and organize observations.
  • Model the relationships between key concepts/vocabulary in a science unit.
  • Identify the cause and effect relationships of various variables on a public policy.
  • Compare and contrast the styles of a set of artists or authors.

And if you are a current Bubbl user or you decide to give it a try, I would love for you to share your ideas, success stories, or an example in the comments below! Happy mapping!

Howland, J., Jonassen, D.H. & Marra, R.M. (2011). Meaningful learning with technology (4th Ed.). Columbus, OH: Merrill/Prentice-Hall.
Jonassen, D. H. (2006). Modeling with technology: Mindtools for conceptual change. Columbus, OH: Merrill/Prentice Hall.