Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Build a Foundation for Enhanced Teaching with a Customized Grade Book

Build a Foundation for Enhanced Teaching with a Customized Grade Book

https://aaron.kr/content/talks/technology-upgrade-customized-grade-book/

Presented: Jeonju North-Jeolla KOTESOL Regional Conference 2012

Technology Upgrade: Customized Grade Book

Practically, enhanced teaching begins when teachers themselves are comfortable using technology and applying it to real-world problems. Before there can be a “technology upgrade” in the classroom, teachers must understand the benefits and uses of a particular piece of technology so they can share those with their students. And what better place for teachers to begin getting comfortable with technology than with their own personal productivity?

Ff7c53d1086a3f7eded27ab4d4f816c5?s=128

Aaron Snowberger

April 21, 2012
Tweet

More Decks by Aaron Snowberger

Other Decks in Education

Transcript

  1. None
  2. None
  3. Technology Upgrade Build a Foundation for Enhanced Teaching with a

    Customized Grade Book
  4. None
  5. Observation Technology Revolution (Part 1)

  6. Medicine

  7. Security

  8. Business

  9. Industry

  10. Education? 200 190

  11. We want tech in schools “Not a passing fad”

  12. Who? Why?

  13. Who?

  14. Not a “Silver Bullet”

  15. Besides, Technology requires: Time Energy Patience Practice

  16. What do you think: Is personal investment in tech and

    the hours it takes to learn it worthwhile?
  17. Why?

  18. Automate Informate Term coined by Shoshana Zuboff in her book

    "In the Age of the Smart Machine" (1988)
  19. Automate Gmarket Lightshot

  20. Informate!

  21. Simplest illustration: Gradebook

  22. Further illustration: Website & tutorials http://wp.me/2jJdY

  23. Student illustration: Computers / Devices

  24. How? 2012 1906

  25. “Attitude plays a major part in any change effort.”

  26. Survival tips for your own tech use 1. Invest time

    in learning computing basics. 2. Use what technologies personally empower you with your students. 3. Become a colearner with your students in regard to technology. 4. Be skeptical, but open-minded. Be sure your “tech toys” have a purpose. 5. Expect reliable, secure, and adequate resources from your school. (You shouldn’t have to make two sets of lesson plans).
  27. What’s the “big picture”?

  28. Maslow’s Hierarchy of Needs Peak experiences / Fulfillment Ego, self-esteem

    needs Social/Psych Needs Safety/Security needs Basic survival needs
  29. Johnson’s Hierarchy of Edu Tech Needs Empowered Students Enhanced Teaching

    Extensive Resources Effective Administration Est. Infrastructure The Five 9’s Rule Trained, Parent access For class For pro. dev. 1. Personally productive 2. Transformative Solving Real World Probs.
  30. Johnson’s Hierarchy of Student Tech Use Genuine Problem Solving Academic

    Use Non-Applied Use Operational Skills Use Simple Use Point & click Save, print, Adjust settings Word, Excel, PPT 1. Tech Upgrade in class 2. Supp. Assignments Real World Situations
  31. Survival tips for your own tech use 1. Invest time

    in learning computing basics. 2. Use what technologies personally empower you with your students. 3. Become a colearner with your students in regard to technology. 4. Be skeptical, but open-minded. Be sure your “tech toys” have a purpose. 5. Expect reliable, secure, and adequate resources from your school. (You shouldn’t have to make two sets of lesson plans).
  32. Enhanced Teaching Personal Productivity (Part 2)

  33. MS Excel Grade Book

  34. From this

  35. To This

  36. Even to this

  37. What will you record? Names (“atomize it”) Attendance (number of

    absences?) Participation (points / letters?) Tests (with/out a rubric?) Assignments (drop/keep low/high scores?)
  38. How will you structure it? Names & numbers first? Final

    grades at the end? Letter grades? Percentages? Allow only certain values? Need a bell curve?***
  39. Know your keyboard buttons ALT (ALT + ⌘) CTRL /

    SHIFT
  40. Know your software buttons Merge / Divide Cells Text Rotation

    Decimal Places
  41. Know your Functions 💧 IF 💧 SUM 💧 AVERAGE 💧

    COUNT 💧 MAX 💧 MIN 💧 SMALL 💧 VLOOKUP 💧 SUMIF 💧 SUMPRODUCT Most-used Common Specialty
  42. =SUM (A7:G7) Most Common =SUM(

  43. =IF(SUM (A7:G7)=0,””,SUM(A7:G7)) Most Common =IF(

  44. =IF(true, then, else) =IF(SUM(A7:G7)=0,””,SUM(A7:G7)) The IF function

  45. =IF(A7>=0.9,”A”, (IF(A7>=0.8,”B”, (IF(A7>=0.7,”C”, (IF(A7>=0.6,”D”, ”F” )) )) ))) Nested IFs

  46. =VLOOKUP(B10,$A$2:$B$7,2,1) Replace Nested IF with VLOOKUP

  47. =VLOOKUP(where, table,col.,T/F) =VLOOKUP(B10,$A$2:$B$7,2,1) The VLOOKUP function

  48. Data Menu, Validation… (ALT + D + L) Amazing Data

    Validation!
  49. See an Example Build Our Own (Finally)

  50. http://wp.me/2jJdY

  51. None