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.

Cognitive Tutor by Carnegie Learning

Once a week, NB brings the computers on wheels (COWS) into her classroom so her geometry students can use a program called Cognitive Tutor that’s designed to accompany the textbook being used in her class.  Both are produced by Carnegie Learning.  Although I have never encountered the textbooks before, this is the second time I’ve seen the Cognitive Tutor software in use.  The first was a middle school classroom in a suburban city.  Although my current setting differs in many ways, being a semi-urban high school, I have observed students responding to the program similarly in both situations.

Cognitive Tutor is a program designed to give immediate feedback while students practice their math skills.  Student progress is displayed in the upper right-hand corner of the screen at all times.  Students can see how they progress through the unit.  They are also told immediately whether each small step of a problem is correct or incorrect.  This appears to be very motivating to students, but also has some drawbacks.  While the students want to see their progress advance, I often hear them make comments about being frustrated when a series of mistakes causes the progress bars to move backwards.  The bar moves backwards because more practice problems have just been assigned to the student.  The nature of the comments leads me to believe that the students feel like they are being punished: “Oh no, now I’ve got to do more,” or “This is so stupid/frustrating!”

A second apparent problem is with the “hint” option.  If students are uncertain, they can click a Hint button that gives them a clue as to how they should proceed.  Using this button rarely does not impact their progress bar.  But regular use seems to be interpreted by the system as a lack of knowledge, and more practice problems are assigned.

Today I saw an example of how this particular feature created a major problem for a student.  He is working well ahead of most of his peers, and at the beginning of class started a unit on proofs.  Early on, he encountered a problem involved making a flowchart proof.  Although this material had already been covered in class, and he could articulate all the steps in the proof to me verbally, he spent the entire class period trying to understand how the program wanted him to communicate his knowledge.  He had to click on the Hint button many times, and read through several long help documents.  Both the teacher and I spend considerable time attempting to help him make sense of the program’s expectations.  He never managed to complete the first proof, and by the end of class was incredibly frustrated.  Because of the penalties incurred in using the Hint button and his trial-and-error attempts to communicate with the program, he had incurred so many additional practice problems that it appeared he had lost credit for all the work he had done at the beginning of class.  He was also facing a long set of similar flowchart proofs.  Fortunately, Cognitive Tutor allows the teacher to manually move a student to a new place in the unit sequence, so NB advanced the student beyond the flowchart proof section.  This seems like a major drawback to the software, but I am not sure how it might be designed differently.

One of the difficulties with this situation was that neither the teacher nor I had any experience trying to enter flowchart proofs into the system.  We were effectively useless to this student.  I was not aware that the teacher could allow him to skip ahead, and find myself wondering now why she allowed him to struggle for so long.  I am not sure this was a bad thing, as he clearly is very tenacious and never actually gave up on the problem.  I probably would have cut him off earlier, after perhaps 15 minutes.  Perhaps she felt like because he was so far ahead, she had the luxury of letting him put real effort into trying to make it work.

The lesson for me, though, was that even with a designed and tested program, it’s important for the instructor to be able to complete all the problems the students might encounter.  Had either the teacher or I spent time previously practicing making these flowcharts in Cognitive Tutor, we could have provided useful hints.

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!

Digital Story

Mary Takle and I worked together to make an awesome video for our digital story.  We focused on using a wiki though Google Sites, the TI-84 with a temperature probe, and Fathom to do some fancy stuff with the resulting data.  Because of the limitations of this free blog, I can’t embed the video here.  But you can download it from my digital portfolio.  We used both iMovie and Windows Movie Maker to put the video together.  Figuring out how to make those technologies work wasn’t part of the project, but we had fun with it anyway.

Applet Reviews

Fibonacci Sequence – http://nlvm.usu.edu/en/nav/frames_asid_315_g_4_t_1.html

The purpose of this manipulative is to allow students to explore the Fibonacci sequence, the golden ratio, and the relationship between these two things.

applet with parent/teacher info

The applet itself is very simple.  One can use it without entering any data, or can enter two starting digits to see how this changes the sequence.  It works very well.

applet with NCTM standards

Accompanying the applet are some instructions for use, information on the NCTM standards which the applet meets, and a brief article explaining some background and making some suggestions as to how to use the applet in a classroom setting.

Closer view of applet

Buttons on the applet allow you to scroll through numbers in the sequence.  Along with each number is the ratio of the quotient of the number and the one just higher to it.  This allows one to see that as you progress through the sequence, this quotient approaches the golden ratio, which is conveniently included.

Taken by itself, I think this applet is interesting, and might be a fun way to change pace in a class.  I could also see using this as part of a lesson in the history of math, and also as a way to augment lessons on functions.  Combining it with other applets, such as the Golden Rectangle that follows, could yield a more powerful lesson.

+++++

Golden Rectangle – http://nlvm.usu.edu/en/nav/frames_asid_133_g_4_t_1.html

When you run the Golden Rectangle applet, a spiral is drawn inside a rectangle in such a way that each time the spiral intersects the side of the rectangle, a perpendicular is drawn.

applet drawing spiral

This perpendicular creates a new rectangle of the same proportion as the original.  All the rectangles created a proportioned to the Golden Ratio.  Like the Fibonacci Sequence applet above, this tool includes instructions, information on NCTM standards, and some background and suggested uses.

The Golden Rectangle provides a visual representation of the Golden Ratio illustrated in the Fibonacci Sequence applet.  Using these two tools together could help students get a sense of the relationship between mathematics and the real world, especially if done in the context of a lesson on where the concepts of Golden Ratio and Fibonacci Sequence first came from, and how they’ve been significant over time.  I think one of the things that makes it difficult for some students to “get” math is that in addition to being abstract, it probably seems to be rather arbitrary.  Teaching more how these ideas came into being, what sort of problems gave rise to them, and how they’re used today might make the subject much more concrete for many.

+++++

Turtle Geometry – http://nlvm.usu.edu/en/nav/frames_asid_178_g_4_t_1.html?open=instructions&from=vlibrary.html

Turtle geometry is like a simplified game version of Geometer’s Sketchpad that uses only lines and angles.  By entering a series of commands, one can program the turtle (cursor) to move geometrically.

turtle drawing rectangle

With the right combination of moves, one could draw various shapes.  To do this successful requires some thought about which angles and lengths would be appropriate.

maze applet

In addition to a blank screen, one could choose to navigate a maze, follow a drawing, or walk through randomly placed rocks.  Each type of exercise requires students to think about angle and length/distance, which are important concepts for geometry.  This applet can also help students begin to think of some of the ways that mathematics might play a role in things like computer programming and building.  Making these connections would likely require some discussion.

I am not sure, though, that this manipulative would be worth using in the classroom.  I can think of more active ways of teaching the same concepts that might involve getting outside the classroom and building an actual maze or writing out instructions for a geometric treasure map.

+++++

Linear Function Machine – http://www.shodor.org/interactivate/activities/LinearFunctMachine/

One of the clearest metaphors I encountered as a student was to think of a function as a machine.  This function machine applet has students input x values, receive y values, and then work out the linear relationship between the two.

blank applet

The applet begins with blank input boxes.  One can enter multiple values, one at a time, in order to get a sense of the pattern the function follows.

applet tabs

The applet page includes four tabs: Learner, Activity, Help, and InstructorActivity is open by default and includes the applet.  Learner provides some basic definitions and background, and a list of links to related resources.  Help contains instructions for using the applet.  Instructor outlines some basic information useful to teachers, including how the applet aligns with various standards.

instructor tab

This is a very slick and useful tool.  The same group (shodor.org) has a simplified version that helps to introduce the concept of functions.  I could see using both applets in the classroom.  Last spring I observed a lesson where students were first being introduced to functions.  The idea seemed very foreign to them, almost like it was a major departure from the math that had come before.  This might have been because of the new notation.  Being able to have a tool that’s both fun and challenging and provides a concrete metaphor for what’s happening with the numbers would, I hope, make the transition easier.

Children and Technology: A Reflection

I observed a teen attempting to solve a problem having to do with his desktop computer.  He uses Ubuntu Linux, something that can sometimes require a bit of technical know-how.  He is very interested in computers and would like to make a career of programming.

In the situation where I observed him, he had recently uninstalled a piece of software that created a conflict on his computer.  He was trying to open a webpage to access an online textbook required for his class.  The webpage functioned as an interactive site, and do it required more than basic browser function.  The software he had uninstalled caused some kind of problem that prevented the webpage from functioning correctly.  The teen was attempting to solve this problem.

The teen’s general approach to solving the problem appeared on the surface to be to simply click on things randomly until something happened.  This was when I first noticed he was having a problem.  I asked him why he wasn’t doing his homework as he had been earlier.  He explained that the program had crashed, and gave me the brief background I explained above about having uninstalled a key piece of software.  As I continued to observe, it appeared that rather than clicking randomly, he was attempting to recreate the situation repeatedly so that he could observe the behavior.  I assume that he was doing this in order to better understand the behavior in greater detail in order to develop a good potential solution.

What was really interesting to me here was how he appeared to frame the problem in his mind.  He seemed to see it as a situation where because his computer was not functioning the way he expected it to, he had an opportunity to play around with it and better understand the interactions between various pieces of software.  I found myself viewing the problem as one where he needed to access his textbook, and so he ought to focus on finding a way around the problem, if getting the software to work correctly was not going to happen quickly.  I think in both our views the end goal was learning, but when I think about it his approach would have yielded longer-term benefits in terms of learning to investigate and diagnose problems, especially given his chosen career.  I don’t know why I felt such a need for him to hurry, and I believe this feeling was not appropriate.

If it is the case that technology is going to continue to expand it’s role in our lives, and thus that understanding and being comfortable with technology will be a valuable set of skills in the future, then I think it’s important for me to be conscious of opportunities to play and learn like the one that the teen encountered.  What he was really trying to do was learn how to learn on his own.  If I can help my students learn nothing but this, I think I can consider myself a success.  They should then, at least in theory, be able to go on and fill in anything else they might need to know to be successful in their lives.  Technology, because it can sometimes be both foreign and complicated, seems to provide a lot of opportunity for learning to diagnose and solve problems.  As a teacher I need to have more patience and allow my students more time, when I can, to experiment with problem solving, especially in situations involving technology.

Tech Encounters – Oct 13th

Today’s technology: Google Docs/NeoOffice

In honor of my ed tech class this quarter, I’ve decided to try something new: taking notes with a word processing program, rather than pencil and paper.  To date I have tried two programs: Google Docs and NeoOffice.  I find that I like both equally well so far, and prefer either one to pencil and paper, for three reasons:

  1. I can type faster than I can write, so I am able to keep up with the discussion more easily.
  2. When discussing a new concept, I can search online and then embed links and images to either revisit later or simply remind me of what I thought we were talking about.
  3. I can be much more flexible with formatting.  For example, if we revisit a topic, I can scroll back up and insert notes so that all of my thoughts on a single topic are in one place.  I can also hyperlink topics together if need be.

These are all very powerful advances.  The one drawback so far is that I cannot quickly sketch, but this is mostly because I have not tried to find or experiment with a drawing program.  As I haven’t really needed to sketch anything, this is only a theoretical issue.  This is definitely something I would encourage my students to use in the classroom, especially if I could help them get access to programs like Geometer’s Sketchpad or Fathom.

Tech Encounters – Oct 12th

Today’s technology: the cell phone.

Along the lines of yesterday’s post, I find myself questioning the usefulness of the cell phone.  I realize that some people think of their cell phones as indispensible.  For example, I have a brother who uses his Blackberry to connect his laptop to the internet when he goes camping. He belongs to that part of the population that agrees with many techie-gadget commercials that tell us we need to be Always On and Always Available.  I am not sure I believe this story.

I think it’s very important to a person’s health that they be able to relax and get real rest on a regular basis.  I think teenagers, whose lives are probably at least as stressful as we adults think our lives are, are especially in need of this.  Having a cell phone and being accessible by others 24/7 seems like it would only add to the level of stress that a teenager would have to deal with.  It would give immediacy to things that aren’t really urgent (as in a late night text,”did you hear what so-and-so-said?”).  It can be difficult to sort these two things out.  Being under constant stress can lead to anxiety and depression, both of which seem to be on the rise lately.

I am not trying to suggest that cell phones are evil.  But I do think that it is important to remember that they are just a tool.  Just because someone could call me at 2am because they are bored, doesn’t mean they should.  Or that I am required to answer the phone.  This speaks to the appropriate use of technology, something that I think with cell phones we as a population are still figuring out (note the issues surrounding texting-while-driving).

As an experiment, I have begun to make use of a new “feature” that my phone has developed: it likes to shut itself off at random intervals.  Rather than trade the phone in for a new model, I have been simply ignoring the phone until I want to make a call.  Often, the phone is off.  I never know how long it’s been off.  I will also leave my phone at home while running errands, or turn the ringer off for an entire weekend.  I have yet to find that I missed anything really important or pressing, but I do find that I feel more at peace.  This may not work for everyone, but I am finding that for me, appropriate use of technology means establishing clear boundaries as to when I will and will not be available to others.

Tech Encounters – Oct 11th

Today’s technology: the automobile.

This may seem to have little application to the classroom, but to me it stand as a good example for how a technology, when it becomes ubiquitous, can alter the structure of our lives.  One hundred years ago, before cars ruled the world, what people considered to be their “home area” was quite a bit smaller than today.  The idea of commuting 30 miles each way to work would have been impossible.  While people still got around quite a bit, it was much less frequent than today, when I might think nothing of hopping in the car to pop over for dinner at a friend’s house 100 miles away.  That cars (and things like buses and high speed trains) are available virtually anywhere means that people have access to a level of freedom they didn’t before.  But there are a couple of interesting things about this that I’ve been thinking about lately.

First, I would assume that the ease with which we can travel would mean that we would be more apt to do it.  As I didn’t live 100 years ago I can’t directly compare, but I noticed during our class discussion last week that it seemed many people had little idea of what their own country was like outside of the 40-50 or so mile radius that makes up the Pacific Northwest’s urban/suburban area.  Even places as close as Yakima and and Walla Walla could be visited in a day, and would help people understand that not even all Washingtonians share the usual Seattle area’s liberal views.  Go some place like Shell, WY or Louisville, KY, and you might as well be in another country.  The values are very different.

Second, owning a car requires a financial commitment, and so in some ways is actually limiting.  Perhaps this is why people travel so little.  Although it’s actually cheaper to drive most places than fly, it still takes time.  It also takes time to work to make enough money to pay for insurance and maintenance, and of course the gas used to drive to that job that enables you to make that money in the first place.  So it seems like owning a car can start you on a cycle that limits as much as it frees people.

I read about a similar cycle in a book called Better Off by Eric Brende.  He lived for a year in an Amish-like community.  Some of the farmers there used horses, some did not.  What he observed was that although the farmers using horses could produce more, they were required to produce more in order to be able to maintain the horses.  In the end, they didn’t really come out ahead.  They really just worked a lot harder to wind up with the same things he had.

I wonder the same thing about technology in general: yes, it sometimes seems like a magical, amazing thing.  But how often does the new technology (which requires at the least an investment of time to learn to use) really add to our lives?  Do we come out ahead?  Do I gain enough from using Twitter, for example, to justify the time I spend on it?  How about facebook or email?  Sometimes I think the answer is no.

« Older entries

Follow

Get every new post delivered to your Inbox.