Technology Upgrade

3. Technology Upgrade Build a Foundation for Enhanced Teaching with a Customized Grade Book

5. Observation (Part 1) Technology Revolution

6. Medicine

7. Security

8. Business

9. Industry

10. Education? 1906 2006

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 techand the hours it takes to learnit worthwhile?

17. Why?

18. AutomateInformate Term coined by Shoshana Zuboff in her book "In the Age of the Smart Machine" (1988)

19. Automate Lightshot Gmarket

20. Informate!

21. Simplest illustration: Gradebook

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

23. Student illustration: Computers / Devices

24. How? 1906 2012

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

26. Survival tips for your own tech use Invest time in learning computing basics. Use what technologies personally empower you with your students. Become a colearner with your students in regard to technology. Be skeptical, but open-minded. Be sure your “tech toys” have a purpose. 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 EmpoweredStudents Solving Real World Probs. 1. Personally productive2. Transformative EnhancedTeaching For classFor pro. dev. Extensive Resources Trained,Parent access Effective Administration Est. Infrastructure The Five9’s Rule

30. Johnson’s Hierarchy of Student Tech Use GenuineProblem Solving Real World Situations 1. Tech Upgrade in class2. Supp. Assignments Academic Use Word, Excel, PPT Non-Applied Use Save, print, Adjust settings Operational Skills Use Simple Use Point & click

31. Survival tips for your own tech use Invest time in learning computing basics. Use what technologies personally empower you with your students. Become a colearner with your students in regard to technology. Be skeptical, but open-minded. Be sure your “tech toys” have a purpose. Expect reliable, secure, and adequate resources from your school.(You shouldn’t have to make two sets of lesson plans).

32. Enhanced TeachingPersonal 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 CTRL / SHIFT ALT (ALT + ⌘)

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

41. Know your Functions Most-used Common Specialty • IF • SUM • AVERAGE • COUNT • MAX • MIN • SMALL • VLOOKUP • SUMIF • SUMPRODUCT

42. =SUM (A7:G7) Most Common =SUM(

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

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

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

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

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

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

49. See an ExampleBuild Our Own (Finally)

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