Slide 1

Rachel ShanklesAR Alpha EpsilonGoogle Your DocsGo to http://www.google.comand sign in or sign upWe will talk about using: Google SpreadsheetsGoogle FormsFor our chapter needs

Spreadsheets to Collect InfoTo collect accurate phone numbers and addresses of membersTo be able to print the memb ership info or share it on the web when filled outSet up a computer at a meeting, make a shareable google spreadsheetHave each person fill in the blanks as she entersSaves automatically every few secondsShare the info via a link back to them and they have right to change it at any time

Spreadsheet Sample http://goo.gl/ppWLV

Go to your browser on your phone or ipad and go to this urlTry to enter your last name, first then state then chapteranywhere between 2 and 89Every cant hit 2nd box at onceMy list of Google Docs

To make a form go to your google driveGo to more in the menu/ to Drive if you have ChromeGo to documents in the menuSelect the red box Create from the pageClick on Form from the list of types of documents (Document, Presentation, Spreadsheet, Form, Drawing, or Table)Select a backgroundSet privacy and share options(share with anyone with the link is always a wise choice or list the google acct. names of persons to share it with). You are owner and they dont need rights to edit a form or survey but would a spreadsheet or collaborative doc.Decide if you want the first question to be What is your name? or if you want the answers anonymous.Start using the pull down menus to select what types of questions

Small edit icons show up when you hover your mouse over the top right area

EditDuplicateTrash

Text type answerExample:Question titleWhat is your last name?

Answer box is small for one or two wordsParagraph Text Type Questions

Example:What is your address?

This type of box allows for a two or three sentence answer.Mutliple Choice type questions

Example:What shape is a chromozone?Help Text=put a dot by one answer

RoundSquareOvalCheckboxes for answers

Example: Why do you check out library books?Help text- you may check as many as applyPleasure readingBook reportsPhoto browsingresearchPick from a list

Do you agree with this statement: All pit bull dogs are dangerous.Choose from the pull down menu list one answer.TotallySomewhatNot at allScale

Rate your satisfaction with the cafeteria food.Help text: 1 is highest --5 is lowest; choose only one answerLabels:Great food every dayGreat food most of the time.Average food all the time.Average food half the time.Terrible food most of the time.

Grid

RememberCopy the url link on the form and email that to those you want to take the survey or fill out the formYou can make it shorter by using http://goo.gl but save the shortened link somewhereUnder Form put checkmark by accepting responses til your deadline then uncheck itNext time you open it you will see the spreadsheet view of respondents answers and if you need the live form again that is in the Form menu and select go to live formUsing the ResultsUnder Form you can go to summary of responses after your deadline and you have charts and graphs showing percentages on those that were scales and grids or multiple choice questions

Rachel ShanklesMy business card has my wiki address and that is where you can print out this slide show or teach with ithttp://aaimlibrarywiki.wikispaces.comEmailshankles@cablelynx.comArkansas Alpha EpsilonFormer AR Pres, SCReg Sec, SC Reg Ex in Ed ChairRetired Library Media Specialist after 42 years Works as tech consultant to schools and educational coops