This is not the document you are looking for? Use the search form below to find more!
Using Google Docs For School Sign Ups
0.00 (0 votes)
Document Description
Using Google Docs for School SignupsWhy Use Google Docs For Sign Ups?It’s efficient. Organizers avoid sending and receiving multiple emails. Everyone can see what everyone else is bringing/doing,…
File Details- Added: May, 12th 2011
- Reads: 138
- Downloads: 0
- File size: 483.64kb
- Pages: 10
- content preview
- Name: alide
Embed Code:
Related Documents
Using Google Docs In Education
by: kazunari, 16 pagesUsing Google Docs in Education Kent Gerber TLTR Meeting February 18, 2009 What is Google Docs?  Suite of software like Microsoft Office, with some unique features  Google ...
INDIVIDUAL OFFICIAL ENTRY FORM - CARE FOR SCHOOL CHAIRS RUN
by: jally812, 1 pagesINDIVIDUAL OFFICIAL ENTRY FORM - CARE FOR SCHOOL CHAIRS RUN
GROUP OFFICIAL ENTRY FORM - CARE FOR SCHOOL CHAIRS RUN
by: jally812, 1 pagesGROUP OFFICIAL ENTRY FORM - CARE FOR SCHOOL CHAIRS RUN on 25 March 2012 @ Rotary Park, Tagum City
Download Fake Doctors Notes - Using Doctors Notes Printable As Excuse Letters For School Or Work
by: eracave75, 2 pagesRight now there is a new sensation that is going around and turning out to be very well-liked with s...
Using Social Media For A Business
by: singer3wrench, 2 pagesStarting out essentially as a medium for people to connect and stay in touch, it has evolved to don ...
Using Social Media For A Business
by: sex44weight, 2 pagesStarting out essentially as a medium for people to connect and stay in touch, it has evolved to don ...
Using Social Media For A Business
by: singer3wrench, 2 pagesIt has enabled people to assume digital personalities and connect with like minded people and hence ...
I’ve (probably) been using Google App Engine for a week longer than you have
by: petra, 24 pagesI’ve (probably) been using Google App Engine for a week longer than you have
Content Preview
- Using Google Docs for School Signups
Why Use Google Docs For Sign Ups?- It’s efficient. Organizers avoid sending and receiving multiple emails. Everyone can see what everyone else is bringing/doing, what is still left to sign up for, so everyone shares the responsibility.
- It’s flexible. Because it’s a spreadsheet, you can create any type of sign up that you need. Parties, field trip drivers, mom’s night out, fundraising projects, etc. can all be done.
- It’s accessible. Anyone can access Google Docs through a browser or even on mobile devices like the iPhone.
- It’s free. Need I say more?
- People not online won’t be able to use it.
- To set one up, you should know how to use spreadsheets.
- Permissions can be difficult to set.
- Easiest way is to make the sign up public.
- So you need to have rules in place to preserve confidentiality, eg. use only first names/last initial of kids.
- URLs are long and ugly – and easy to break when sending by email.
- Determine what needs to be brought or done.
- Create the sign up.
- Add information about the event.
- Set up permissions and get the link to send to people.
- Optional: Create a short URL.
Here’s an example of the list for a teacher appreciation breakfast. Make a similar list for field trip drivers, etc.- 6 people to set up from 7am-8am
- 2 people to bring 1 dozen bagels each
- 1 gallon of orange juice
- 1 pound of ground coffee
- 2 tubs of cream cheese
- 2 fruit platters
- 1 dozen baked goods
- 6 people to clean up from 9am-10am
- Go to http://docs.google.com (note: there is no “www”). If you have a Google Account, go ahead and sign-in. If you don’t, you’ll need to create an account.
- Select “New” and then “Spreadsheet”. OR skip down to #6 and copy an existing sign up. You can also upload a spreadsheet you create in Excel – see #8 below.
- Next step is to rename the sign up and save it. Click on “File” then select “Rename…”
- Rename the document. Pick a descriptive name like “Breakfast Sign Up for 2nd Grade”. Then click “OK”.
- At this point, your sign up will auto save itself. If you don’t see this happening, give it a minute, or refresh the page. You should see the on the right an indicator that shows when it was last autosaved.
- OR Copy an existing Google Doc. For example, copy the Teacher Breakfast sign up.
- To copy an existing sign up, go to “File” and then “Make a copy”. Templates available:
- Teacher breakfast sign up: http://bit.ly/teacherbreakfasttemplate
- Field trip sign up: http://bit.ly/fieldtripsignuptemplate
- You will be prompted to rename the sign up. Rename it and then click “OK”. Your new sign up will be ready to do, already set up for autosaving.
- You can also create a sign up in Excel and then upload it to Google Docs.
- Add information about the event at the top of the page, such as the name, date/time, location. Include general instructions on how to use the sign up, such as “Please enter your name in the yellow field next to something you can bring or do. It will save automatically. If you have any questions, email xxxx@xxxxx.com or call xxx-xxx-xxxx.”
- Here’s an example of what this section could look like if you are creating it from scratch:
- Format and highlight the sign up any way you would like, using the formatting tools.
- Add the sign up items.
- Create a sign up item for anything someone would sign up for. Example: If 6 people are needed for set-up, then create 6 lines. Put the items in columns, and if needed, a place for the sign ups.
- Highlight the rows next to the sign up items, so people know where to put their names. To do this, click on the multi-colored square and choose a color.
- Adding rows or columns. If you need to add a row or column (for example, adding a new item):
- Put your cursor where you want the new row to go.
- From the menu, select “Insert” then what you want to insert, e.g. “Row above” or “Column to the right”.
- If you insert something in the wrong place, press Ctrl+Z, or click “Edit” and then “Undo” in the menu.
- Deleting rows or columns. Similarly, if you want to delete a column or row, do this:
- On the side margin or top margin lick on the row or column you want to delete. For example, click on the gray “13” to remove Row 13.
- Right click on your mouse, and select “Delete row” or “Delete column”.
This is perhaps the most confusing part of using Google Docs, and where problems usually arise. You need to make the page “public” AND you have to allow people to make changes to the sign up without signing-in.
Privacy note: Because these sign up will be viewable by the public, caution people not to enter children’s full names if they are going to be in the sign up (for example, for field trip car assignments). Instead, use first name and first initial of the last name if needed.- On the upper right hand side of the screen, click on “Share”, then select “Get the link to share”.
- Click on the two boxes next to “Allow anyone with the link to view (no sign-in required)” AND “Also allow them to edit”.
- Then select and copy the entire URL.
- Click “Save & Close”. You may want to open up another browser window and paste that URL into it to make sure it works.
- At this point, you can simply cut and paste the long URL into an email, but it tends to break. Here’s an example:
- To avoid this, make sure that the link in your email is actually the entire address, and not chopped off. Depending on your email program, you can highlight text in the email and paste the URL manually.
- Another way to avoid this is to shorten your URL – if you’re having problems, go to the next step.
A URL shortner takes a long ugly URL and makes it short and easy. So this URL:
http://spreadsheets.google.com/ccc?key=0AirX3NV5BeZsdGRocmdWZjlYV3p2bV9sOE1zdThLN0E&hl=en
Becomes this one: http://bit.ly/teacherbreakfasttemplate- Copy the URL you want to shorten. Go to “Share”, then “Get the link to share”.
- Go to http://bit.ly. There is no “www” and no “.com” in the address. Paste the long URL, then click “Shorten”. Another URL shortening site that’s good is http://tinyurl.com.
- At this point you’ll see a shortened URL. You can simply use that short URL – copy and paste it into the email.
Troubleshooting
“Someone accidentally erased all of the sign ups!”
You can “time travel” with Google Docs, and take the sign up back to the point before the accident. For example, let’s say a pet guinea pig got thrown on to the keyboard and erased a bunch of sign ups, so that it looks like this.- Go to “File” then select “See revision history”.
- Click on “Older” until you get to the version that you want, then click on “Revert to this one”.
Add New Comment