Session 5: 1pm - 4pm

Session #5 (3 hrs)
  • (1 min) Update attendance
  • (3 min) No face-to-face Session #6 --- it will be virtual.

  • (2 min) Addressing Technology Hurdles, Roadblocks & Barriers:  MY STOCK ANSWER.

  • (15 min) Smartboard Presentation  (Aimee, Andrew, & Zach) ... if they're setup and ready to go.

  • (10 min) STUDENT (Group Google Sheet Presentation) 
    • Include demo of how to EMBED sheet into Blog.
  • (10 min) Reflection on spreadsheet (analyze/discuss chart) & post in blog.
    • Eyes Closed:  Question: with a little practice, how long would it take to complete this last project (manipulate data, chart, analyze)? 
      (my formative assessment) -> How many of you can:

      • Create formulas, copy/paste data from the Internet, manipulate data by filtering and inserting/deleting rows & columns 
      • Format (re-size columns, use of color, decimal accuracy, merging cells). 
      • Discuss the impact of using '0' vs a blank cell on overall statistics.
      • Freeze/unfreeze rows and columns, sorting, average vs median vs mode, generating meaningful charts.
      • Question: Is your embedded sheet DYNAMIC? ____  What does this mean?
      • Were the 3 tutorials helpful, or how might they be improved? _________
    • Student Demos:   Jay  |  Jennifer  |  Aimee  |  Tom     
    • Student quotes 
      • (AR): I haven't spent a lot of time working with Excel or other spreadsheets ...  but when working with Google spreadsheets, I learned just how easy they are to use ...  it's great for collecting, organizing, calculating and displaying data. In the end, you can display your data in a variety of easy to read graphs.

      • (MB):  I have had previous experience working with spreadsheets .... This was my first time using Google Spreadsheets, and I was very impressed on how user friendly it is! Neither program I used in the past (Excel and SPSS) was as user friendly as Google Spreadsheets, which is also FREE.  
        • Creating charts was one of the most complex parts of using excel and SPSS because there were not previews to help you visualize how all the information you were entering would change your chart.  Google Spreadsheets has a preview that changes as you input/change information.  
        • I was also pleased with how easy it was to share, link and embed my spreadsheet.  If I made changes to my data and chart, my links and embed changed.  How convenient!

      • (BN): "I am an EXCEL guy through and through. However, I am leaning more towards using Google Spread sheets more than before due to the ease of navigation through the program, easier tabs, and most importantly being able to access my work at any work station.  And the Google Gadgets allow me to creatively use spread sheets for engaging kids in the classroom in ways that Excel is not able to do."   
-----  BREAK ? -----

  • (3 min) Discuss grades  (course completion)
  • (10 min) Demo -> Google's Gadgets and BJ: don't forget -> cool student applications.

  • (15 min) STUDENT Presentation -> Google FORMS.  Jeremy, Corey, Jay
    • Scenario: You are the technology committee rep for your dept/pod and tasked with creating a tech literacy survey.
    • Screenr Tutorial on Google Forms, by Fran (Cohort A)

  • (20 minutes) Blooms Revised Taxonomy ... the '90's taxonomy meets with cloud computing. A beautiful marriage?       

           Blooms creatively using cloud computing 

  • This is a fun little lesson; and one I think you'll remember for some time to come. 
    Reflect on how we are applying Blooms Taxonomy during this activity and varied teaching strategies
    • Were there appropriate uses of technology? ____  How? ____   
-----  BREAK -----

  • (20 - 25 min) Presentation: Educational Technology Standards in Oregon
    • Did you know there is a specific set of technology standards for both students and teachers (and administrators coming soon)
      • 2010 Aspire student reflection of the presentation:  "The standards are designed to help both teachers and students deal with and take advantage of the rapid development in technology in the past few years. At their core they are preparing students for the 21st century workplace and a virtual society many are already stepping into." by M.G.
    • My role in 2008-9: assess all District Ed Tech Plans for Dept. Ed.
    • One-stop-shop document for Ed Tech Standards
    • Brief Slide Show includes:
      • CIP (Continuous Improvement Plan)
      • new Oregon Diploma
      • OETS (new Oregon Ed Tech Standards)
        • NETS*S and NETS*T (for students & teachers)
        1. Creativity and Innovation
        2. Communication and Collaboration
        3. Research and Information Fluency
        4. Critical Thinking, Prob. Solving and Decision Making
        5. Digital Citizenship
        6. Technology Operations and Concepts
                • NETP (Obama, National Ed Tech Plan).

            The following assignment on the Ed Tech Standards will not be required. 
            Assignment: Educational Technology Standards
                • The new Oregon Technology Standards and Requirements
                • Take a few minutes to scan through the technology standards and requirements for students, which is a single document that addresses the NETS*S (students), the new Oregon Diploma, and new Oregon Educational  Technology Standards (OETS).
                • Also take some time to peruse through the ed tech standards for teachers: NETS*T (teachers),
                • The essential question is:  how might one explain the big picture of what these standards are trying to accomplish?
                  • Select at least 2 of the 6 student standards that are most significant to you, and describe some specific strategies you could implement at your grade level(s) and/or subject areas in order to accomplish this huge task. 
                  • Include a paragraph on some of the challenges we face, and how you might pursue overcoming these hurdles.
                  • Demo:  Brianna's  |   Stacey's  |  Andy's (video + OETS) and Chad (challenges we face)
                • Post your strategies in your course blog. Title:  'New Tech Standards & Requirements
              • NOTE: There is no face to face Session #6. The above assignment, and completion of the following Taskstream will be used. 
            • Video yourself teaching a mini-lesson or topic.
            • Taskstream
            Barry Jahn,
            Oct 22, 2009, 7:44 PM