Monday, May 13, 2013

Educational Technology Week 2...

Spreadsheets and Databases in the Classroom

The article linked below "The Need for Spreadsheet Math in K-12," was written as a response to an article in the New York Times (N-Ways to Apply Algebra with The New York Times) and makes a pretty good case for using spreadsheets in the classroom.

Article link: 
http://blogs.edweek.org/edweek/reimagining/2012/10/spreadsheets_in_k12.html

The gist of Art Bardige's argument in favor of spreadsheet use is that adults are using them for business, science, and other technology uses, and that it makes no sense that we are not allowing students to use them for those same purposes. We get caught up in thinking of them as fancy calculators (which they are in some ways), and that using them amounts to cheating.  "How can I tell if they really understand, if they are just using Excel?" is a fair question.  It can be answered in several different ways...if the student had to set up the spreadsheet, they probably do understand the math needed to do so.  If the spreadsheet is the culmination of a whole unit on a specific kind of problem solving, if the student understood the concept on formative assessments on the way to the end, then using the spreadsheet should not take away the understanding the student already had.

I am actually quite surprised at all the furor surrounding this... although I guess I should not be.  I guess it all depends on whether you view mathematics education in K-12 as problem solving or as the mastery of algorithms.  Algorithms really are tools for use in problem solving in my opinion, and it makes sense to me to give students lots of different tools to use.  If I've done my job well, students will know how to use many methods to solve mathematical problems and will be able to select the right one(s) for the problem at hand.  I see no reason why spreadsheets should be omitted from the possible tools. I will admit to not having used them in math education before... but I certainly will now.

==============================================================
In researching the use of spreadsheets and databases in education, the big surprise for me was that there are teachers using databases in class instruction-- this had not occurred to me before.  Again, these would be good for analyzing information, particularly looking at statistics over time.

WIKIS :-)

"The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn.” – Alvin Toffler an American futurist. 

This quote from one page of the wiki 21stcenturyteched (http://21centuryedtech.wikispaces.com/) really struck me… and it is so true. We have to help our students really understand that they will be continually learning… and that critical thinking will be part of that learning (perhaps the most important part). Wikis are an incredible way to give students opportunities to collaborate and be creative-- and put to use the skills and information they've gained to work.  This quote is a good reminder of what is at stake and how very important it is that we use technology well in our schools and model that for our students.

I also want to use this space to say that I have found some great rubrics for scoring wiki work via the Educational Wiki discussion...this is really helpful! While I plan to tweak them to fit the way my classes work, it will be great to have a starting point.


This week's Tech Explorations are noted below:


Concept Mapping Programs
1.
Describe what you learned from exploring this resource.  

I already thought that concept mapping was cool—I did not know how many good mapping resources were free. Wisemapping.com has a great intro video that really does give you all you need to know to get started in five minutes!
Both WiseMap and Bubbl.us give great options for creating colorful, engaging concept maps. Couple that with SMART Board or other touchscreen options and it can be a great group and/or collaborative tool.


2.
How could you use this resource in a school setting?  

Any concept mapping program would be great for brainstorming or keeping track of key points in a classroom discussion.  Students could use them as a pre-planning tool for writing or for organizing their understanding of a concept for studying or even as an actual assessment.  This could also be used as a way to “blow up” concepts for students with vision issues—both programs allow for zooming in on a map and printing.




3.
Would you recommend this resource to other educators? Like/Dislike; Ease of use, fee or not, and so forth.  Why or Why not?

I definitely think that concept maps are a great resource for all levels of teachers!

For FreeMind, I really like the ease of moving around sections of the map as you are creating it—that gives great flexibility when you are brainstorming “live” in class.

Bubbl.usdoes not run well on Firefox, so this is a consideration if that is your browser of choice. The free version will only allow for saving three maps, so if a teacher wanted to keep folders of more than that an upgrade would have to be purchased.




 Animoto
1.
Describe what you learned from exploring this resource.  

I already had a “lite” Animoto account… I used it to compile photographs to make a short “film” about how fast time flies using pictures of my children over just three years.  What I learned from further exploring is that if I want to make movies over 30 seconds (and I do!) I will need to upgrade.

2.
How could you use this resource in a school setting?  It does not matter if it is in your field or level, you need to understand how the resource might be used in educational settings.

This would be great to use with any science unit where the point is to look at changes over time.  Students could take pictures at each stage for comparison, and then put them together to see the full effect.

It could be used by teachers and students to make movies for any subject—teachers putting together movies for classroom use and students as projects to demonstrate their learning about a topic.

3.
Would you recommend this resource to other educators? Like/Dislike; Ease of use, fee or not, and so forth.  Why or Why not?

I definitely think that Animoto is worth a look… and I believe that it is worth the $30 a year to upgrade to a Plus account.  For that money you get the ability to create an unlimited number of ~ 10 minute movies and access to lots of soundtrack options.



 Google Docs (now Drive)
1.
Describe what you learned from exploring this resource.  

I am already an avid user of Google Drive, and have explored most of its capabilities.  It was one of the explorations I do with students in our program so that they have it as one their "tools" for going through the education program and for use in their field experiences.

2.
How could you use this resource in a school setting?  It does not matter if it is in your field or level, you need to understand how the resource might be used in educational settings.

Google docs are a GREAT tool for having students collaborate on a group project… and the best part is that you can tell who contributed what and what edits were made along the way. 

Free presentation slides—this is great to use in place of Power Point, which not everyone has on their computers.

I gave the mid-term exam for my science methods course via Google Docs this past semester because I was at a conference during our mid-term week.  I set up a form and emailed the link to the students with instructions on the timeframe for completion.  Once students finished the form and submitted, their answers were automatically loaded into a spreadsheet that made scoring easy.


3.
Would you recommend this resource to other educators? Like/Dislike; Ease of use, fee or not, and so forth.  Why or Why not?

I recommend it highly… and have found for my use that the free level works fine.  If an entire department or school were using it, one of the subscription levels would probably be in order.  It’s just enough different from Microsoft Word that you have to play with it a little bit… but it is pretty intuitive.  It also saves automatically—which has proven to be a lifesaver on more than one occasion!




PhotoPeach
1.
Describe what you learned from exploring this resource.  

PhotoPeach is a resource for creating slideshows with pictures. You can drag pictures and change the order simply by clicking and dragging them to place them where you want. You can then add background music if desired.

What I find the most useful about PhotoPeach is that viewers can make comments on the slideshow

2.
How could you use this resource in a school setting?  It does not matter if it is in your field or level, you need to understand how the resource might be used in educational settings.

This would be great for assessments that involve identification of visuals… art, geometric figures, vocabulary in ANY language.

Students or teachers could write short stories with pictures (Teachers could put together a few pictures and ask students to write a narrative, OR give students text and have them find pictures to illustrate—each one of these I looking for different demonstration of understanding the text.

Teachers and students could use this for class presentations.

3.
Would you recommend this resource to other educators? Like/Dislike; Ease of use, fee or not, and so forth.  Why or Why not?

I would definitely recommend this as a resource.  This is one that is fairly useful at the free level, but if a teacher planned to make lots of slideshows, it would only be $3 a month to upgrade.



No comments:

Post a Comment