Session 5 for Cohort-A

Session #5 (3 hrs)
  • (1 min) Update attendance sheet
  • (1 min) Congrats: Morgan, Meg B, Laura, Selene. 
  • (1 min) Smart board (MLE & friends check out from Steve Rhine)? Session #6?
  • (3 min) Technology in Education: Sample of up-to-date Lesson Plans
    • Ways to teach about Occupy Wallstreet. Who are the 99%?
    • Matching quiz  :   Pay close attention to #'s 2, 4, 5, 8 and 10.  Hmmm.

  • (20 minutes) Blooms Revised Taxonomy ...
    Original Blooms (1990's) 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? ____   

  • (20 min) Reflection on spreadsheet (analyze/discuss chart) & post in blog. 
    • Reactions ranged from 'stressful to way too cool'.  
    • Question: with a little practice, how long would it take to complete this last project (manipulate data, chart, analyze)? 
    • Eyes Closed: 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 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 a FREE program.  
        • 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. DYNAMIC --- How convenient!
      • (AN) It took me a few tries before I had the graph labeled correctly and to come out just right. I love how you can go back if you do not like how it turned out and try again. This is definitely user friendly. I can see using this for my classroom’s grades. It will be easy for me to see which of my students need more assistance and which of my students need extensions to help challenge them. I think this will make my teaching life much easier.
      • (BN): "I am an EXCEL guy through and through. However, I am leaning more towards using Google Spread sheets more then 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."

    • Student Demos (Cohort A):  Megan  |   Amanda  |  Andrew  |   Anna (bar/line)   
    • Questions:  Why switch rows and columns? ____   How does one SORT quickly? ____       

  • (15 - 20 min) Google FORMS student group presentation.  
    • Fran (Screenr Tutorial) and Blog Post with embedded survey
    • Scenario: You are the technology committee representative for your dept/pod and tasked with creating a tech literacy survey for staff. What type of questions might exist in this type of survey?

  • (30 min) Presentation: Educational Technology Standards in Oregon (and the Nation)
    • 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 virtual society many are already stepping into." by M.G.

    • My role in 2008-9: assess District Educational Technology Plans for the Oregon Dept. of Education
      • Over 150 Districts; all required to be updated and approved every 3 years (currently in the 4th phase).
      • Training and implementation plan.

    • 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).
            Assignment #7: 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).

                • Essential question:  how might one explain the big picture of what these standards are trying to accomplish?
                  • Select at least three (3) of the student ed tech standards that are most significant to you, and describe several specific strategies one could implement at your grade level(s) and/or subject areas in order to accomplish this huge task. 
                  • Include a paragraph on 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

            Assignment #8: Video (record) a mini-lesson
                • Screenr Tutorial on 'Vimeo' (sharing videos up to 500mb. FERPA and Copyright options)
                • Time permitting ... set up account and upload video?