Uses for Google spreadsheets
- Google apps for educators gives students names to validate responses
- Some Uses
- Lesson plans - whole year in one doc
- Can publish as a web page, or just one sheet, for parents to see
- Click duplicate so that it looks the same, then click share
- Then click publish, only shared pages
- Then delete what is on that shared page, copy what is on the Main sheet and paste them in.
- URL will stay the same
- Will republish every two weeks or so, or click republish now
- Can share this with other teachers so they can edit too.
- Freeze rows -click tools and freeze them
- Create a Google Document or Spreadsheet for a particular lesson plan
- Teachers can edit at the same time
- No sign in necessarily required, but can be
- Just change the permissions
- Copy address to tiny URL and give that one out
- But this can get crazy, because you can delete things... So...
- Go to Google Forms to gather data into a spreadsheet
- If you make the last question required, prevents from submitting before they are done filling it out
- Then can calculate info... Average, etc
- Help text: help them answer the question the way you want. Ex. ask students to only enter numbers
- Questions automatically become headers in a speed sheet, and data is then automatically entered
- Calculating data you have collected
- Highlight column, click Form Menu, Summary of Responses
- Assessments
- If in the library, could give a quiz (don't do spelling tests...they can then spell check)
- Create a form with just two questions:
- Name
- Answer
- Then just have students click the back button and they can answer the oral question. (give the quiz question orally)
- Can keep or delete answers in spread sheet.
- If you just delete the text, it will still put the answers in the cell following where the last answer was, so delete the rows
- Always go back to the same quiz... EASY
- List view allows you to filter information by answer
- As you have students go back to the form to take a new quiz, no data is deleted, just added to the spreadsheet
- Journals - every day fill out a form and give a text response, and their responses are now in your spreadsheet
- Self check quiz-ready at http://www.tammyworcester.com/
- Click use this template 5, 10,15,20 question quizzes all set up
- Automatically scores
- Done through if-then statements
- As you have students go back to the form to take a new quiz, no data is deleted, just added to the spreadsheet
- Other uses for Google Forms
- If collecting emails - say at the beginning of the year, this might be a great way to collect data and emails of students and parents and then copy and paste into email or grade book, etc.
- Pixel pictures – like coloring in a picture on graph paper
- Change colors with rules
- Cells change with the rules you set
- Can do this by column, row, cell, or select the entire spreadsheet
- Create a form and set rules of the spreadsheet automatically created
- See templates provided on www.tammyworcester.com under CUE 2011 Google spread sheet class
- Make your links shorter! Tired of giving students and colleagues that long web address to get to your page? Use one of the sites below to create a shorter link that will take you to the same place. Simplify.
No comments:
Post a Comment