• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Finally, you can manage your Google Docs, uploads, and email attachments (plus Dropbox and Slack files) in one convenient place. Claim a free account, and in less than 2 minutes, Dokkio (from the makers of PBworks) can automatically organize your content for you.


Google Apps for Education

Page history last edited by pbworks 5 years, 2 months ago

Notes from our discussion:


EdCampCville: Summary of Links for Google Docs

Contact Tony Wayne with your questions about these links,mailto:twayne@k12albemarle.org
Anyone with this link, goo.gl/p9Gs2, can edit this document.

For the novice, the most important tip is to pick ONE use for Google Apps with your students and develop it. ...Then explore.

The files listed below are accessed only by a link. Some are editable and some are not.

The links for files can be very long. I use a url shortner to make them more manageable. I like Google’s shortner, http://goo/gl. It’s links are case sensitive. I use a plug-in that I added to my web browser to create the shortened urls with a click of a button. Others url shortners are more refined and offer some nice additional features, http://bit.ly

My entry form:http://goo.gl/9cqon
The spreadsheet connected to this form: http://goo.gl/3pFAy (View mode only)
Minimal skills are required to make this function.

Parent Information Form
This is the entry form and link that I would share: http://goo.gl/xSE5z
This is the spreadsheet that is connected to the form: http://goo.gl/CP6Mz (View only)
Minimal skills are required to make this function.

Dimensional Analysis Team exercise
Student instructions: http://goo.gl/TLPoG
Student Response Summary Sheet: http://goo.gl/ZgljE
Answers to the team sheet (Not shared with the students):  http://goo.gl/ecrr4
Some spreadsheet skills are required.

Test data Collection from students
The form students fill out: http://goo.gl/jHCXC
The spreadsheet connected to the form: http://goo.gl/JGkyV
It does not require much skill to collect the data. It does require advanced skills to set up the second spreadsheet’s sheet: functions like addition, subtraction, multiplication, division drag-down, create a new sheet, rename a sheet, read data off another sheet, sum(), average(), max(), and min().

Large Class Focusing Activity

This form is an example of how to collect hundreds of pieces of input from 30+ students. Students are provided with a question and then, without talking, they go to a form and enter their question. To enter more than one question they type a new question and press the submit button again. I then copy this data to a new spreadsheet and share it with them while giving them editing privileges. Each student is assigned a group of rows to score according to the rubric on the spreadsheet. I then sort the results and students eliminate the duplicates. Before we know it, the project has developed a focus on 5 or 6 variables and becomes something easy to manage.

This make a simple form where students provide input: http://goo.gl/WNWjg
Spreadsheet connected to the form:goo.gl/XiUZH
Basic skills are needed to create this document. Students are to input what they thing will effect the outcome of an experiment. The teacher copies the results and puts them in a spreadsheet that is shared with the students. Depending on the number of responses each student assesses the value of each response. They rate them as 1: Need to know this answer. 2: Need to know this answer but we do not have the equipment. 3: Duplicate question or we don’t need to know this. The results are sorted and posted on the board. The teacher then repeats the precess as needed to widdle the results down. The students then create an experiment while focusing on one of these suggestions. Example results: http://goo.gl/aTRR1 . Example form for creating the experiment, http://goo.gl/uCkkT .

Activity Example:
Instructions shared with the students: http://goo.gl/WC60w
“IML” Document that is referred to above: http://goo.gl/5FKPl
This file contains some animated gif’s that Google Doc’s new editor no longer supports. :-(
Organize the assignment into 2 documents

    • Document (1): Instructions
    • File naming convention: use complete words like "Impulse and Momentum Lab."
  • This gives the basic instructions -including links to YouTube instructions.
  • Students are given access to VIEW the instructions file.
  • Students do not type anything on this document.
  • If you need to make any changes, you type the change and it shows up on everyone's account.


    • Document (2): Student responses
    • Students will edit this file. To do this they will make a copy of the file. This will make then an owner and allows then to edit their copy of the file. They should then share it with their group partners and you.
    • File naming convention: The name has 3 parts to it.
    • Part (1): class period
    • Part (2): a lab acronym. In this case I wold use IML for Impulse and Momentum Lab. I also know that acronym’s stand for student responses.
    • Part (3): The last names of the team in alphabetical order.
    • Example” B3_IML_Janeway_Kirk_Picard.”
    • This is the only file you grade. It contains the student responses. Grading on a computer can me cumbersome. Sometimes it helps to ask the questions in the instructions file and ONLY answer them in this grade file.
    • Webmail
    • Grade by adding comments using the comment command.


Activity Instructions
Video Analysis Instructions: http://goo.gl/Gx2zU
Spreadsheet summary of video inputs: http://goo.gl/N2ZjE (View mode only)
Form to input request: http://goo.gl/cOl9h (View mode only)
Basic skills are required to get this done.

Example Set of Activity Instructions
No handouts. These instructions include links to videos online to explain the set and a link to the on line activity.
Instructions: http://goo.gl/izX3t
Prelab form filled out by students: http://goo.gl/dmn8M
Spreadsheet connected to the prelab form: goo.gl/rbB5M




Sally Hill-Outten from www.brvgs.k12.va.us
Google Apps is not Microsoft Office. It is open the world and made for collaboration. There is a time and place for Office and for collaboration using Google Apps.
List of current projects: http://www.brvgs.k12.va.us/index.php?option=com_weblinks&view=category&id=47&Itemid=59

To organize teachers in different location use Google docs to get kids doing large projects. The teachers are doing seven projects in the same time frame. This gives timelines, contacts expectations -including the grading rubric, etc. This is what the current projects page above shows. (The web site is made in Google Sites.)

Everything is done electronically.

Google docs ideas and management.
What was called folders is not called “collections.” You can share a collection. When a document is placed in a collection, it will be automatically shared when any document is placed in the collection.  






The most important tool in management is the file name. Teach students a naming structure that will allow you to find a specific document later. See above for some hints.

Instead of using comments, which are pasted all over the place, use discussions to keep a conversation in one place on the page. Select text, like when making comments, and click on the discussions button at the top left of the screen. The “resolve” button in the discussions closes the discussion.

Training website. http://edutraining.googleapps.com This is a collection of training tips put out by Google.




Are you a real estate agent? Does social media scare you?


Realtors are some of the best marketers in an offline person-to-person environment. You’re incredibly brilliant at getting to know your clients on a very personal level, getting involved in your community, and connecting with your local market.


What you’re not very good at is applying this to your social media.(Well, most of you aren’t!).


The best real estate marketers think of social online like they do social offline!


Social media provides a way to further connect with your local clients and groups and boost your real estate marketing efforts. Social can build trust, and spread your marketing through friends of friends.


But how do you do it?


In this article I’ll give you an overview of Facebook, Twitter and Pinterest (and a few more) and how real estate agents can use them for social media marketing.

Comments (0)

You don't have permission to comment on this page.