Wednesday, September 29, 2010

Excel Activity

Activity Reflection #2

Part of integrating technology in the classroom involves utilizing software properly.  There are many different types of software available including open sourced software like OpenOffice and web-based alternatives like GoogleDocs.  I am less familiar with these types of software as most of my experience is with Microsoft Office, but after reading about software in Integrating Technology and Digital Media in the Classroom and this week’s module for my class, I intend to learn more and try some out.

For this week’s activity, I used a very common program that most are familiar with called, “Excel.”  I used an Excel spreadsheet to modify and manipulate a mock grade book.  The activity required tasks such as changing colors in columns, adding grades, creating formulas to average homework grades, test grades, and final grades, and organizing the grades from least to greatest.  I have some experience working with Excel so most of these tasks were not difficult for me. 

One thing I learned from this activity is that I should not be afraid to try different options to achieve a task.  Some of the items for the activity I had not done since high school.  Since I am pretty good at figuring out technology, I just kept trying different things and clicking in different places until I got it right. I was not nervous that anything I was doing was going to ruin my grade book because if I clicked on something that was not correct, I just clicked “undo” and the spreadsheet would return to how I had it.  I also kept saving the page between steps.  I think that it is very important not to be afraid to try new things.  Often times, that is how you learn best.  If we don’t try new things, how can we encourage our students to do so?

Another aspect I learned from this activity is to always try the “help” feature if you do not know how to do something.  I experienced this when the activity asked me to make the student names on the first worksheet transfer over to the other worksheets and modify it so that if a change is made, it will change on all the worksheets.  I did not know that this was a feature of Excel so I was not sure how to do it.  After trying a few options that were not correct, I decided to Google the answer.  I sequestered the junk sites from the valid sites, but after about 5 minutes of searching through Google pages without finding anything close, I determined that this was not a good strategy.   I returned to my Excel spreadsheet and clicked on the “help” feature.  I typed in what I needed and the feature gave me step by step instructions on the side of the screen on how to do the task.

In conclusion, I enjoyed completing this activity.  Although my county has its own grade book program that we are required to use, I do see some practical uses for software such as Excel.  Since Excel is such a basic tool, I know that I could probably benefit even more from other productivity software that is available.  Upon reflection, the main thing that I learned from this activity is not to be afraid.  From now on, I will not be scared to try new technologies, and I will not fear asking for help or using the help features when needed.

4 comments:

  1. I love the help button. In addition to 10 other hats that I wear at work, one is help desk support. I always send people to help button. I think microsoft has done a great job providing tutorials and advice on their products. (something that you won't find as well done in the free products). Microsoft has provided videos even on many of them. I'm not getting paid to say any of this but people think I'm an expert at work because I have learned alot from these help documents. I was just as clueless as a beginning user for a long time.

    Google is always my plan B and between those 2 I think someone can find anything depending on how well they can construct search strings.

    Aaron Huestis

    ReplyDelete
  2. "If we don’t try new things, how can we encourage our students to do so?" This line is what really struck me about your reflection. I teach first grade, and so there are a lot of new things that we are learning. I think about this when I am trying to get my students to do spell words on their own. I always say "sound it out and TRY." Yet, when I got this assignment, I pretty much got mad and gave up. So you writing that really clicked with me. I sit there everyday and tell my students to "try" and yet I found I was the one not wanting to try.
    Then I think about what would happen if I didn't try. I would be missing out on so many of things that could really made a better learning experience for my kids. If I didn't try the smartboard program, they wouldn't have that. If I didn't try to find videos and online books, I think my students would really miss out on some great opportunities. So I guess, practice what you preach!

    And, the help button totally got me through this project as well. I found that microsoft does a pretty good job of making resources available if you have a question. Once again.. you just have to try!

    Megan H

    ReplyDelete
  3. You said that "Since Excel is such a basic tool, I know that I could probably benefit even more from other productivity software that is available." I encourage you to get to know Excel's many features -- it's so much more than a basic tool. That's easiest by simply using it as often as you can. It's much more than a simple spreadsheet. It just may be the productivity software you're looking for.

    There are many sites with free training videos that teach you something new in just a few minutes. And keep hittin' that F1 key for help. We should ask ourselves, "I wonder if there's an easier way to do...". Just today, a co-workder was so frustrated with trying to keep her Excel list in alphabetical order but never looked in Help. I overheard her exasperated moans and was able to show her that with just one click (on the Data>Sort tool), she could be happy again.

    ReplyDelete
  4. There are a lot of practical uses for excel in the classroom that goes beyond just the grade book. One thing to consider is showing students data from a test so they can make their own comparative analysis. After each test I pull out a set of data and display a graph in excel (boys vs. girls, period 1 vs. period 2) so they can see how their results compare to the other classes. It’s a great motivation for the students to visualize.

    I also agree about the help buttons. Microsoft has done an excellent job of creating help sections that guide the user. Now with 3 versions of office circulating around, it’s becoming tricky in navigating from one version to the other. The help section provides that transition, as it still catches me off guard that in 2007 & 2010 you can’t use the Alt keys as frequently as in 2003.

    ReplyDelete