Mrs. Bonicelli's Edublog

Hagen Jr. High

Timer Online


Google Timer

  1. Go to the Google Search Page:
  2. Enter: timer 5 minutes (or whatever time you want)
  3. Press the enter key.
  4. The timer will automatically start counting down!
    Click the speaker icon to mute the alarm.
    Click the frame icon to switch to the full-screen mode.



Important Note for Google Chrome Users:

If you use the Google Chrome browser, you can just type, “timer 30 seconds” into the location bar at the top of any page! Then press the “Enter” key to activate the timer.

online google timer

posted under Class Work, Google Tools | Comments Off on Timer Online

Using Google Forms To Give a Test And Then Grade It With Flubaroo


Using Forms in Google Documents allows you to create a quiz of questions of all types–true/false, multiple choice and short answer.  Along with this feature of administering and collecting the answers for a test or quiz, you can also use the Flubaroo script to grade multiple choice and or true/false questions.

Flubaroo is a free script that you can use grade the quizzes that you administer through Google Docs. Flubaroo provides great step-by-step directions for using the script. I’ll give an quick overview of how it works. First, create your multiple choice quiz using Forms in Google Docs (get directions here). Then take the quiz yourself and have students take the quiz (you can embed it in a webpage or direct students to the URL for your form). Now instead of trying to grade the spreadsheet cells you will insert the Flubaroo script by selecting it from the “insert” menu in your spreadsheet. Once the Flubaroo script is inserted just select it and it will grade the quiz for you.

Watch the video below for a demonstration of Flubaroo.

Google Drive is Alive! Keep Anything–Share Anytime


Google DriveGoogle’s online file storage system, is now alive. With it you can upload and access all of your files including videos, photos, PDFs, Google Docs and more.

Google Docs is integrated with Google Drive so you can work on all your documents, presentations and spreadsheets, as well as share content and then add and reply to comments on any file (PDF, image, video, and so on) and receive notifications when some one else comments on a shared item. It has added some social networking features to cloud file storage. Drive will also recognize text in scanned documents. (similar to what Evernote does).

One other nice  (and big asset!) feature is that you can open all these types of files (over 30 different ones) right in your browser, even if you don’t have the original program the file was created in on your computer.

You can access your files on the web and install the Drive on your Mac or PC and your Android phone (iOS app coming soon). There is also a screen reader for blind readers.

You can also search your files easily by keyword, file type, owner and more. Not surprising that you can search like this since it is Google.

 The free account is 5GB. You can purchase more if you need it. 25GB for $2.49/month, 100GB for $4.99/month, or, get ready for it, 1TB for $49.99/month. That’s a lot of memory. When you upgrade to a paid account, your Gmail storage goes up to 25GB also.

This is another great option for backing up and having cloud access to all of your files. The social sharing and commenting features and how it is integrated into Google Docs makes everything dovetailed into one area.

Here’s a video about Google Drive..Go Google Google Drive – YouTube

Get Started with Google Drive:

Google Drive & Google Docs For Teachers


Google Drive and Docs for Teachers 2012

Adding A Map To Your Blog or Online Site


Maybe this could be tried on the “Fake Facebook” assignment for introducing historical characters.

It’s now real simple to add a Google Map to your blog!

Here’s how:

1. Make sure the Google Maps plugin is activated in the Plugins menu.

2. Look for the Add Map icon that now shows in your page and post editor.


3. Complete the information by putting in an address or place name of what you want to show.


4. Click on “Insert this map” and a code will be placed in your text which will automatically show the map when you publish.

5. For “Street View” simply drag the yellow “peg man” from the top left corner into the map where you want him to be. Move him around and choose the view you want to display. Visitors to your blog will be able to move him around, but when they refresh the page or visit again, he will always be reset to the starting place you choose.

5. To make changes, simply click on the map icon again.

Other Options

1. You will also find a Google Maps widget under Appearance > Widgets which lets you place a map in a sidebar.

2. By going to Settings > Google Maps you will be able to set the default size and views of all maps you create.

posted under Blog Info, Google Tools, Resources for Teaching | Comments Off on Adding A Map To Your Blog or Online Site

Google Tools for Educators


Great site for Google features….


posted under Google Tools | Comments Off on Google Tools for Educators

Google Forms/Spreadsheet Formatting


Google forms are fabulous for gathering information, but sometimes, the data in the spreadsheet can be difficult to view. In this post, I’ll share a simple-to-implement formula and a bonus tip that will make it much easier to deal with (and even print) form-fed data!

The Original Data:

When you collect data into a Google spreadsheet from a form, it will look something like this:

If you have a large amount of questions (and especially if some of them are essay questions), it requires a lot of scrolling to view the data.

The Transpose Formula: By using the “Transpose” formula, you can easily make the data look like this:

Notice that the information is now vertical instead of horizontal, making it much easier to view individual responses.

How to do it:   Transpose Formula
Changes data from rows to columns

  1. Create a new sheet.
  2. Enter the following formula in ceel A1 of Sheet2:  =Transpose (Sheet1!A:H)
    Note: Adjust
    A:H to the desired range of columns. If you don’t want the timestamp to show, enter B:H.
  3. Press the enter key and watch the data fill the sheet!

Inserting Rows (optional)

If you want, you can insert rows (use the “Insert” menu) within the data to add labels, notes, or formulas.

Once you’ve entered a label or formula, grab the square in the bottom-right corner of the cell and drag across to the right to fill the label/formula across.

For printing purposes (see bonus tip below) select all cells and change the alignment to “left” and “top.” (Use the “alignment” icon in the toolbar at the top of the page.)

Change fonts, colors, styles, and sizes, as desired.
Resize the rows to change the spacing within the data.


Bonus Tip
Printing All Records (One per page)

  1. Follow the directions above to transpose the data
  2. Follow the directions above to insert rows and add labels (optional).
  3. Click the triangle at the top of Column A and choose “Hide Column.”
  4. Select all columns with data.
  5. Click a triangle in the column header area and “resize” the column widths to 725.
  6. Note – The number 725 may need to be adjusted for different printers.
  7. Choose the print options shown in the screen shot below.

If all goes well, each “record” will print on a separate page:


posted under Google Tools, Quizzes, Tests | Comments Off on Google Forms/Spreadsheet Formatting

Batch Geo and Google Form–Good First Day Activity


This activity could be a good get-acquainted activity for new students.  A Google Form can be created, data collected in the spreadsheet view and then data entered into BatchGeo creating an annotated map.

Resources / Things you’ll need:

 A Google account for the teacher (students will NOT need accounts)
 A Google form/spreadsheet to gather the data
 The BatchGeo tool to map the data

Instructions:    Creating the Form
1. Go to
2. Pull down the “Create New” button and choose “Form.”
3. Add a title and some questions similar to these:
– Name
– City
– State or Country
– Interesting Fact

Note – You could find out: where students were born; the farthest they’ve ever traveled; their favorite vacation spot; if they could live anywhere in the world; etc.


  1. 4. Send students to the blue URL at the bottom of the form-creation page.
    Note – You can use to shorten the address!

  2. 5. Give students time to fill out the form.





Copying the Data:
1.Go to the spreadsheet that collected the form data.
– From the form-editor window, pull down the “See Responses” button and choose “Spreadsheet.”
– Go to the Google Docs homepage ( and click the link with the title of your form.
2.Click and drag to select the data (including the column headers).








3.Copy the selected data.
– Control + C (Win)
– Command + C (Mac)

 Creating the Map:

1. Go to BatchGeo.
2.  Paste the data into the provided area.
– Control + V (Win)
– Command + V (Mac)


3. Click the “Map Now” button.

4. Click a placemark on the map to reveal the student’s name and interesting fact.
5. Click the Save & Continue button. (Optional)
6. Enter a name for your map and enter your email address. (Optional)
7. You will receive an email that contains a URL and embed code for your map. Then you can easily share it with others! (Optional)

posted under Google Tools | Comments Off on Batch Geo and Google Form–Good First Day Activity

Using Google Docs without a GMail Account


Using Google Docs without a GMail Account

Using Google Docs w/o a GMail AccountTo answer the question: “Do I need a Gmail account to access Google Docs?” the following video explains the answer of “No”. You don’t need a Gmail account but you DO need a Google Account. That Google Account can have any type of email account with it.  This video explains the how-to.

posted under Google Tools | Comments Off on Using Google Docs without a GMail Account

HOTTS (Higher Order Thinking/Technology Skills)


Picture 8A revised Bloom’s Taxonomy–comparing digital techniques to traditional standards that Bloom created.  This essay on ways to use free technology in schools to help students reach each level of Bloom’s Taxonomy is a good resource.  A short wiki version of information is posted on Free Technology For Teachers on April 16, 2011 but a more indepth source is Andrew Churches’ website, Educational Origami. Andrew Church has several good resources–Starter Sheets– for  teachers to introduce a tool, technology or activity that can be used in the classroom, as well as 21st Century Learning and 21st Century Teaching.

Google Tools for Revised Bloom’s Taxonomy.shrock_blooms

posted under Google Tools, Resources for Teaching, Web 2.0 | Comments Off on HOTTS (Higher Order Thinking/Technology Skills)
« Older Entries

Skip to toolbar