Geogebra spreadsheets

Last spring I did a short presentation to some teachers on GeoGebra, one of my favorite math technology tools.  I am still learning the software myself, and am no expert, so it was no surprise when someone asked me a question I could not answer: What is the spreadsheet for?

Spreadsheet stuff, obviously.  But how to use it?  I had no idea.  It has taken me months to finally find the time to sit down and figure it out.  The first step I took was to do a search for tutorials on the internet.  I didn’t find one on GeoGebra’s website, but I did find this: GeoGebra Tutorial 19 – Basic Spreadsheet Recording by Guillermo Bautista of Mathematics and Multimedia.  Guillermo appears to be as enamored with GeoGebra as I am, only he a) knows what he’s doing, and b) writes about it in a series of easy-to-follow posts.

Yay!

Today I tackled the first of five posts on using spreadsheets – I used a tool that allowed me to record data generated by moving a slider along a function to a spreadsheet, and then do some basic manipulations of that data.  In other words, I made a graph, then was able to dynamically generate a table of values tied to it.  It took about two minutes.  Look:

I am so excited about this… I’ll be working through the rest of the spreadsheet tutorials and (most likely) several others over the next few weeks.  If you have time, I highly recommend checking out both GeoGebra (it’s free!) and the Mathematics and Multimedia blog.

More GeoGebra!

Aside from being a dynamic play-around-with-mathy-stuff kind of tool, GeoGebra also has an export feature that allows you to create images.  These exported images can be pasted into another program, such as Word (for inclusion in a test, perhaps), or one of my favorites: GIMP.  Today I created a basic graph of a cubic function, exported the image, pasted it into GIMP, saved it as a JPEG, and viola:

Instant art.

Can you believe this is all free?

Ed tech continues

Although my class is now long over, I’ve continued to run into questions relating to the use of technology in teaching mathematics.  I wasn’t sure that I wanted to continue using this blog, but now I think I will.  At least for the time being (I may, down the road, merge this with my personal blog, just for simplicity’s sake).

One of the main reasons I decided to continue this work is that I feel a little bit lost when it comes to educational technology.  This is an odd feeling for me, because although I am not exactly a digital native, I am very comfortable with techy stuff, and am usually able to simply sit down with something and figure out what it’s all about.

Not so with some of this ed tech stuff.  Take GeoGebra, for example.  This is a free geometry tool, similar to Geometer’s Sketchpad (with the major exception of price).  Now, I am not that old (34), but when I was in school we did all our geometry by hand.  Learning this process was a lot of fun to me, because compared to some of the other things I’d done in math classes (quadratic equations), geometry seemed artful.  But then, I am an exacting sort of person, so the precision involved in geometric constructions is something that would naturally appeal to me.  For those who aren’t quite my flavor of perfectionism, geometry can be a bit of a struggle.

Enter GeoGebra: free geometry software that is, by its very nature, precise.  If you draw a line in GeoGebra, it’s straight.  Circles are perfect.  Polygons can be regular with the click of a button.  This may seem a bit like cheating, but it’s not.  One could always begin with hand construction, then move to GeoGebra, where students can then “play” with the shapes, investigating things like the relationships between angles and sides, etc.  GeoGebra does a whole lot more than this, but that’s all the further I’ve gotten in the nifty online tutorial.

If you haven’t tried this software, I recommend it.  If nothing else, it’s fun!

Follow

Get every new post delivered to your Inbox.