Friday, January 29, 2016

Web Resources Hoarder Site

Yesterday I attended a SPARCC INFOhio user group meeting at Suffield Elementary School in Portage County.  I attend these valuable meetings quarterly so that I can share resources with other media specialists.

While there, I attended a presentation from Anthony Luscre, a technology integration specialist from SPARCC.  He showed us an amazing website chock-a-block full of resources for educators.

This website is an absolute goldmine of technology resources!  It seriously has something for everyone.  The Web Resources Hoarder Site is maintained by Eric Curts and Anthony Luscre, our technology integration specialists at SPARCC.  (They are Google Gods, by the way.)  Anyway, this site has hundreds of web resources that are categorized by curriculum, literacies, news and media, searching, free ebooks, LSNED (Learn Something New Everyday).  This last category contains over 200 randomly awesome websites for educators.

When you have a spare minute (yeah!) pop in and discover some amazing resources.  And, yes, this site is constantly updated.  

Wednesday, January 20, 2016

EdListen Google Scripts Add-Ons

I wanted to share some awesome Google resources from a software engineer that creates scripts and add-ons specifically for educators.  If you have ever reserved a computer lab, you have benefited from one of his scripts called Lab Scheduler.  Bjorn Behrendt maintains a website called EdListen, which is full of free Google scripts and add-ons. These scripts can be added to Google Docs, Forms, and Sheets to increase functionality and efficiency.  If you're scratching your head, don't despair.  I will describe some of these scripts and will gladly make myself available if you need help using them.

To get an overall view of these scripts, go to http://scripts.edlisten.com.

Some of the scripts and add-ons that I think would be most beneficial at our school are:

This is a Google Form add-on that allows you to keep track of items that you might loan to students.  For example, you might have a class set of novels.  Using CheckItOut, you can easily keep track of where your items are at any given time.  

This is another Google Form add-on.  If you provide a question with multiple choice answers, Choice Eliminator will eliminate responses that have been taken by previous participants.  A handy use of this add-on would be for creating time slots for appointments.  When a time slot is taken by a participant, its option disappears for future participants.

This Google Sheets add-on allows you to create an email contact list in a spreadsheet.  The spreadsheet can be shared with others.  When names and email addresses are added to the sheet, the Gmail contact lists of all participants will be update.  This is a great add-on for teachers of a community that want to share parent email addresses.

This is the Google Sheets add-on that I use to maintain our computer lab sign-up sheet.  You can use Lab Scheduler to create a shared spreadsheet with class period blocks.  Share it with others, and they can reserve any kind of resource, or they can make an appointment.  The sky is the limit.  And it is easy to use.

Simply Send is a Google Form add-on that allows the owner of a form to add recipients to the form who will then receive an email of the results.  If students are completing a form that numerous teachers would want to see, the form owner can use Simply Send to arrange for all interested parties to receive the results.  

You must be signed into Chrome for these scripts to work.  If any of these concepts sound really helpful to you, do not hesitate to contact me to help you get off the ground.  I'd be happy to hold your hand.  :-)

Tuesday, October 13, 2015

Awesome Add-ons for Google Forms

I am a frequent visitor to Richard Byrne's Free Technology for Teachers blog.  Richard recently posted an article Five Google Forms Add-ons I Frequently Recommend.  In this article Richard promotes Add-ons that directly impact teaching and learning.  Teachers regularly use Google Forms to gather information from students or to provide assessment.  I will summarize the five Add-ons.

1.  formLimiter
FormLimiter allows you to set a time for a form to automatically stop accepting responses. You can also use FormLimiter to set a limit on the number of responses a form will accept. In the video below demonstrates how to enable and set limits on Google Forms.  The video below was created by Richard Byrne and explains how to use formLimiter.


2.  Form Notifications
Form Notifications is a Google Forms Add-on that will send you a notification when someone has completed your Form. You can set notifications to be sent to your email address after every response has been gathered or after a set number of responses has been gathered. You can have notifications sent to more than one email address. 

3.  g(Math)
g(Math) is a Google Forms Add-on that allows you to insert graphs and mathematical expressions into your Google Forms. To insert graphs and equations into your Form select g(Math) from your Add-ons menu and follow the directions that pop-up on the right side of the screen.  

4.  Choice Eliminator
Choice Eliminator removes response choices from your Google Form as they are used up. This can be handy when you are having people complete a Google Form in order to select meeting times with you, or you're having them complete a form to indicate what they are sending into school for a class party. To use Choice Eliminator start by creating your Google Form as you normally would. Then enable Choice Eliminator on your Form. Once Choice Eliminator is enabled you can select the question or questions that you want to have choices removed from as they are used. 

5.  CheckItOut
CheckItOut is a great little Google Forms Add-on that allows you to create a simple check-out/ check-in system. With CheckItOut enabled in Google Forms you simply title the set of items that people will be checking out (iPads for example), then choose if you want people to choose from check boxes, a list, or multiple choice question. Watch the video below to see how the CheckItOut Add-on works.  


As always, if you have any questions about implementing any of these technology tools, do not hesitate to contact me.  Happy Googling!  :-)

Sunday, August 16, 2015

Summer grab bag

G'day everyone!  Welcome back!  I hope you had a wonderful summer.  Now it's August, which means you will be bombarded with more information than your vacation brain can handle.  Allow me to throw more information your way.  :-)

Over the summer I gathered a list of resources that I feel would be useful to teachers as they implement instructional technologies into their lessons.  I will list them here by subject area.  Feel free to use them on your own, or better yet, invite me to help you implement them with your students.

I added these resources to my Diigo account, which contains a public goldmine of excellent teaching resources.  Please bookmark http://www.diigo.com/user/polarbears, and view it regularly for new resources.  Without further ado ...

Information & Communication Technologies for all subjects

1.  Sharalike -
Sharalike is a service that allows you to create audio slideshows online. You provide the pictures.  Sharalike mashes the pictures into a movie with music.  To create an audio slideshow on Sharalike simply import some images from your computer or iPad, drag them into the sequence in which you want them to appear, and then add some music. Sharalike offers a small collection of stock music that you can use or you can upload your own music. Sharalike videos can be shared privately through email or you can make them public through social media. You can also embed your Sharalike videos into blog posts. 

2. Remind -
Remind is a free texting service that allows teachers to send SMS messages to students and parents.  Nobody’s phone numbers are ever revealed, and users have the option to leave the service at any time.  This summer Remind opened their chat feature to all registered teachers. That feature allows teachers to have students and parents reply with text to their messages. Now that feature has been extended to allow teachers and administrators in the same school building to text each other through Remind. Remind allows you to search for colleagues using the service within your school building. 

3.  FlipQuiz -
FlipQuiz is an excellent new site for creating Jeopardy style board game quizzes.  Everything is very user friendly and allows users to create a game through the use of a template or search through previously created quizzes/games.  Also, a user can share games via a link or through social media and there is even a handy built in timer/stopwatch when answering a question. 

4.  Wideo -
Wideo is a video editor that can be used for creating Common Craft-style videos. You can create animated videos on Wideo by dragging and dropping clipart and text in storyboard frames. You set the position and animation sequence for each element in each storyboard frame. When you have completed your storyboards Wideo generates a video for you. 

4.  Hidden Gems:  20 Awesome Web Tools For Teachers -
This is a link from a blog I read called Edutech For Teachers.  This link contains an amazing array of web tools for teachers of all subjects.  Have a peek.  You'll probably find a treasure.

5.  Stupflix -
Stupeflix allows you to create dazzling animated slideshows by selecting pictures, adding text, transitions, and music.  It publishes your completed videos to the web.

6.  Show What You Know -
This site contains a handy infographic that displays 50 awesome web and mobile apps that allow students to demonstrate their knowledge.  Included are apps to create audio recordings, collages, comics, posters, slide presentations, digital books, narrated slideshows, movies, animations, screencasts, and study aids.  

7.  WhatsDue -
WhatsDue is a free service for sending due date reminders to students. The service sends push notifications to students' iOS and Android devices.  Parents can join with a simple join code.  Members will receive push notifications on their smartphone to alert them about new assignments and due dates. 

8.  Screencasts - A collection of the best web tools and apps -
Are you planning to dabble in flipping your classroom?  It's actually quite easy to post instructional videos on your website.  This list of screencapture apps will enable you to create narrated videos from your computer.  Guide students through Smartboard lessons, present slideshows, create multimedia lectures.  They can all be recorded and posted online.  If a student is absent during a critical lecture, they can catch up by watching your online screencast.  This site discusses some of the popular screencast software.  Some of it operates as a web app; others require installation into Windows.  Please see me for recommendations and how to easily flip your lessons. 



Social Studies

1. HSTRY -
HSTRY is a digital learning tool that enables teachers, students and historians to create and explore interactive timelines. Using a platform designed to mimic social media, HSTRY presents content in a format that is easily understood, engaging, and familiar to the 21st century student. With HSTRY, teachers facilitate discovery as students explore primary sources, create timelines, and engage with history.

Health and PE

1. National Geographic Food Education - Contains many excellent resources to help your students learn about food, the environmental and societal problems that involve food, and to gain the information necessary to formulate their own opinions on food-related issues.  Includes videos and other multimedia.


Math

See my Diigo account for all Math resources.


Science

See my Diigo account for all Science resources.




As always, please see me if you have any technology integration ideas.  I love working with classes on projects that involve multimedia.  Come and pick my brain if you want to discuss your options about a teaching unit.  The possibilities are endless!


Tuesday, July 28, 2015

AP makes one million minutes of historical footage available on YouTube

[Taken from http://www.ap.org/Content/Press-Release/2015/AP-makes-one-million-minutes-of-history-available-on-YouTube]

Hey Social Studies teachers!  Check this out!

July 22, 2015

LONDON — The Associated Press and British Movietone, one of the world's most comprehensive newsreel archives, are together bringing more than 1 million minutes of digitized film footage to YouTube. Showcasing the moments, people and events that shape the world, it will be the largest upload of historical news content on the video-sharing platform to date.

The two channels will act as a view-on-demand visual encyclopedia, offering a unique perspective on the most significant moments of modern history. Available for all to explore, the channels will also be powerful educational tools and a source of inspiration for history enthusiasts and documentary filmmakers.

The YouTube channels will include more than 550,000 video stories dating from 1895 to the present day. For example, viewers can see video from the San Francisco earthquake in 1906, exclusive footage of the bombing of Pearl Harbor in 1941, Marilyn Monroe captured on film in London in the 1950s and Twiggy modeling the fashions of the 1960s.

Here are the links to the YouTube channels:

Associated Press:  https://www.youtube.com/c/aparchive
British Movietone:  https://www.youtube.com/channel/UCHq777_waKMJw6SZdABmyaA



Friday, January 23, 2015

g(Math) for Google Sheets

I have been approached numerous times by math teachers who wish they could write mathematical expressions into Google Forms to create online quizzes.  At the moment, I know teachers are creating the expressions in a drawing program and then inserting them as images into a Google Form.  Time consuming?  Yes.  Frustrating?  Yes.

g(Math) for Sheets to the rescue!  This is a Google Sheets Add-on that allows you to create mathematical expressions directly in a Sheet for use in Form.  It is easy to add into your Google Sheets.  Simply pull down the Add-ons menu while creating your Form.  Search for gmath.  Add it.  You're ready to roll!  g(Math) for Sheets will remain in your Add-ons menu whenever you need to access it in the future.

I admit I am mathematically challenged.  So I won't pretend to understand all the features of g(Math) for Sheets.  However, I encourage our math teachers to watch the video below to get an understanding of how to use g(Math) for Sheets and what this add-on is capable of achieving.  As always, contact me if you need any help using this tool.  I hope this saves you a lot of time.  Additionally, this website offers help with g(Math) for Sheets:  http://www.gmath.guru .


Wednesday, January 21, 2015

Save As Doc: Create easy-to-read pages from Google Spreadsheets responses

If you've ever administered a test using a Google Form, you may have been frustrated by the results when students complete extended response essays. Student responses are recorded in a spreadsheet. Each answer is placed in a cell. The extended response cells are very difficult to read because the sentences are squeezed into a very small area.  Save As Doc to the rescue!  Save As Doc is a Chrome extension that converts the spreadsheet into an easy-to-read document.  Those extended response essays can now be read clearly online with the click of a button.

Here's how to use Save As Doc:

1.  Sign into Chrome.
2.  Open the results spreadsheet for the online test.
3.  Pull down the Add-ons menu.
4.  Select Get add-ons.


5.  Search for Save As Doc.
6.  Click on the Save As Doc add-on and install it.  Authorize and accept all permissions.
7.  Select the Add-ons menu again.  Select Save As Doc.  Select Start.



8  Select all the cells in your spreadsheet (including the Row 1 header) that you wish to grade.  [I recommend selecting all of the completed cells in the spreadsheet, even the non-extended response answers.  This will ensure that you include the students' names and class periods.]


9.  Type a name for your document in the Save Doc file as section.
10.  Check the boxes for First row of selection contains headings and Add a pagebreak after each row.
11.  Press the blue Save as Doc button.
12.  Once it finishes working its magic, click the link to Open the Doc.  (This document has been saved in your Drive.)
13.  Voila!  You can now scroll through the results and easily read your students' extended responses.  :-)