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.
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