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?

Transcript

3. Technology Upgrade Build a Foundation for Enhanced Teaching with a Customized Grade Book
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