Google Confidential and Proprietary

1. Google Sites, Spreadsheets and Importing Google Confidential and Proprietary

3. What is it? Link to new google docs video Link to Google Docs in Plain English video

4. What are Google tools? • The implementation of Google tools in meaningful ways in your classrooms will increase efficiency, collaboration and engagement

5. Google Apps For Education

6. (GAFE)

7. +

8. Advantages of Using GAFE • Documents accessible anywhere, anytime (live in the cloud, but be secure) • Promotes collaboration (sharing) • Supports data gathering (forms) • Safe and secure for student information Link to video

9. Landing Page: https://hcpss.me/

10. Revised AUP There is a draft letter for parents as well.

11. Vs.

12. You have 2 GAFE Accounts Private Public

13. Public vs. Private • Your Public GAFE account is appropriate for: • Parent or community calendars • Class calendars • It may be shared with anyone within the HCPSS or outside the HCPSS Your Private GAFE account is appropriate for: • School calendars • Class calendars It may be shared with anyone within the HCPSS, but NOT outside of the HCPSS.

14. Private or Public? Private: Anything shared with students or staff is on Private side. Students do not have access to Public side. Indicated by .org url (https://drive.google.com/a/hcpss.org) Public: Websites to be viewed by public or documents to be shared by people not in HCPSS either as a student or staff member should be created in Public side. Indicated by .me url (https://drive.google.com/a/hcpss.me)

15. Can only share items with other HCPSS staff and students • ONLY Forms can be shared outside

16. Appropriate For… • Administrative documents • Teacher planning • Student work

17. Can be shared outside HCPSS • If created in Public side, CANNOT be shared to Private side

18. Appropriate For… • Community calendars • Team or school websites

19. Benefits for Teachers • Share files with staff and students. • Access files from any Internet based computer. • Track student work. • Create public websites for community. • Create private websites for students only. • Create online surveys. • Create contact lists. • Work anytime, anyplace with Internet access.

20. Benefits for Students • Create documents, spreadsheets, and presentations. • Create websites. • Keep student work Private. • Share files with teachers and other students. • Work anytime, anyplace with Internet access. • Eliminate the excuse, "The dog ate my homework!"

21. You have 2 GAFE Accounts You can only be signed in to 1 account at 1 time

22. Best Practices

23. If you ever use your personal account at school, use 2 web browsers (1 for each account)

24. ……….....Firefox ………......Safari ………….Chrome

25. GAFE Resources • GAFE Resource Site • https://sites.google.com/a/hcpss.me/gafe/about-google-apps • CLC GAFE Conference • Technology Systems>Google Apps for Education > Add to Desktop • School-Based PD • BBMS Tech Wiki • Google Help

26. Logging In • BE SURE TO SIGN OUT OF ALL OTHER GOOGLE ACCOUNTS FIRST!! • Go to https://hcpss.me • Choose Private for use with students and staff. • Choose Public if you are sharing out with the community (such as a website for parents, etc.) • Enter your Active Directory username and password.

27. https://hcpss.me

28. Landing Page: https://hcpss.me/

29. Active Directory • Call 7004 for account issues • Active Directory Accounts must be current; expired passwords will not work

30. GAFE Resources • GAFE Resource Site • https://sites.google.com/a/hcpss.me/gafe/about-google-apps • CLC GAFE Conference • Technology Systems>Google Apps for Education > Add to Desktop • School-Based PD • BBMS Tech Wiki • Google Help

31. Sites

32. Google Sites • link • Overview

33. Create a site for your class.  Embed a class calendar, videos, and presentations. #27: Classroom and School Websites  Examples: 5th Grade Class Site US History Class Site School Website Intermediate Application  

34. Use sties to create student ePortfolios.  Showcase student work and pass it on from year to year.  Example: Clemson University ePortfolios #28: Student ePortfolios Advanced Application  

35. Have students do projects or create reports using sites.  You could also have them do their submission for the Global Google Science Fair! More info on that here. #29: Student Projects and Reports Intermediate Application  

36. Create and share curriculum at your  school or district.  #30: Curriculum Sharing Advanced Application  

37. Want more?  Google Apps for Education Training Center: http://edutraining.googleapps.com/Training-Home/module-5-sites

38. GAFE Resources • GAFE Resource Site • https://sites.google.com/a/hcpss.me/gafe/about-google-apps • CLC GAFE Conference • Technology Systems>Google Apps for Education > Add to Desktop • School-Based PD • BBMS Tech Wiki • Google Help

39. Spreadsheets

40. Make comments 9/5 • Lock down cells/protect ranges 8/7 • Create, format and customize a site

41. #7. Track Student Homework (and Share with Parents) Example: http://bit.ly/geNsQx Use spreadsheets to track student homework.  Give each student a anonymous number and share the sheet with parents Intermediate Application

42. #8: Sign-up Sheets  Example: http://bit.ly/hvxANq Use spreadsheets to make scheduling parent-teacher conferences really easy.   Intermediate Application

43. Use Google forms and spreadsheet to: • Collect data • Share data • Analyze data • Graph data • Graph data across 5 variables using the motion chart #9: Science Experiments Example: http://bit.ly/dQLtt6 Advanced Application

44. #10: Flash Card Center  Example: http://bit.ly/hsdpyj Use the flash card gadget in spreadsheets to set up a flash card center for your class. Intermediate Application

45. Beginner: Share a document with a colleague  Intermediate: Analyze the revision history of a document Advanced: Create a motion chart   Try it!   Demo Account Information:  URL: www.google.com/a/g1usd.org/ Name:demo1@g1usd.org Password: googleapps

46. Google Apps for Education Online Training Center, Module 4: Docs: http://edutraining.googleapps.com/Training-Home/module-4-docs Want to learn more?