Friday, February 12, 2016

The NEW Google Forms: 9 classroom uses

from:

The new Google Forms makes classroom activities more efficient and more attractive. Here are 9 ways you can use Google Forms.
The new Google Forms makes classroom activities more efficient and more attractive. Here are 9 ways you can use Google Forms.
For years, educators have been using Google Forms to gather data, assess learning and create fun techy learning experiences.
Recently, Google Forms got a facelift, and even more recently, it added some new features. These features make some new things possible in the classroom, and they make some things easier — and prettier — than before.
Here are some of the changes and what you can do with them in class. If you’ve used Google Forms before, please keep your favorite uses of Forms in mind and add them as a comment at the end of the post!
The new Google Forms makes viewing submissions easier than ever.
The new Google Forms makes viewing submissions easier than ever. (Click for full-size image.)
1. Hustle through student responses to quizzes, assignments and surveys. Responses in Google Forms are much easier to review now. Before, you could view them in a spreadsheet or see a brief summary of them. Now they’re all gathered right in the form editor under the “responses” tab. You can now view a summary of answers (all in one place … nice!) OR click through each individual response.
You can still view results in spreadsheet view. However, as I learned on Twitter from Google guruAlice Keeler, Forms won’t automatically create a spreadsheet for you like it did. You’ll have to click the little green spreadsheet icon to create one now.
2. Get an email when students submit forms. Before, to see whether there were new submissions to a form, you had to go into the form (or the spreadsheet of results) and check. Now, you can opt to have Forms email you with new submissions.
This is GREAT for infrequently-used forms, and it’s GREAT to turn on after most of your student submissions have come in. I would NOT turn it on right before giving a quiz or test in Forms. Your inbox will be flooded!
CLASSROOM USE IDEA: Create a “late work submission” form. Since Google Classroom (and other assignment collection options) won’t notify you when late work comes in, a form for that (with email notifications on) would notify you! It’s great for absent students, too.
3. Use add-ons and scripts. This was possible with the old Google Forms, but it was just added with new Google Forms. Add-ons and scripts let you add new functions to your Google Forms for your specific needs. They’re available by clicking the three dots in the top right and clicking “Get add-ons …” or “Script editor …”.
Unless you write code or have some to copy into a form, you probably won’t use the script editor.
ANYONE can use add-ons, though, and there are a few that are really useful in education. I’ll show you one here and one later.
A graph added with the g(Math) add-on.
A graph added with the g(Math) add-on.
CLASSROOM USE IDEA: Add math equations to Google Forms with the g(Math) add-on.
  • Click the three dots in the top right and choose, “Get add-ons …”.
  • Find the g(Math) add-on by searching or clicking on its icon.
  • Click the “free” button and install it.
  • Click the puzzle piece icon in the top right and choose “g(Math) for Forms”.
  • Choose which type of entry you want. (At first, if you’re not sure, experiment. If you don’t like what you create, you can always delete it!)
  • Add all the details you need. It will add an image to your question!
4. Make sharp-looking forms with templates and themes. If you’re not exactly sure how you want to make a form, there might be one already created for you. Forms has a library of templates you can choose from as soon as you load it up.
PRO TIP: Type “forms.google.com” in your browser to get to forms quickly. (In the past, you had to go to Drive and click “New” and “Google Forms.”)
Forms offers several templates that do a lot of the work for you.
Forms offers several templates that do a lot of the work for you. (Click to see full-size.)
Some of the templates available:
  • Contact information (users submit their name, address, email, etc.)
  • T-shirt sign up (users give their name, t-shirt size, etc.)
  • Exit ticket (students say what they learned, whether they were prepared, and what would have made the lesson more effective)
  • Assessment (students fill in their name/email and answer quiz questions that you add)
  • Worksheet (students fill in their name/email and answer questions that you add)
  • Course evaluation (students fill in class name and instructor and rate the course in various areas … this one is a good example of how a multiple choice grid works!)
Once you choose a template, you can customize it however you’d like (i.e. add text, images, videos, different kinds of questions, etc.).
Customize your forms by clicking the paint palette in the top right. Choose a color for color scheme or click the photo icon in the bottom right to choose a theme. Themes provide colors and images for forms. You can also upload your own photo to create a theme.
OTHER USES OF FORMS: In a recent reader survey, many people said they wanted to better understand Forms and how it could be used in the classroom. The following ideas were possible in the old Google Forms and are still available in new Google Forms.
5. Create and grade a quiz or test with Flubaroo. Host your quizzes, tests and other assessments digitally with Google Forms. Then, with responses in a spreadsheet, autograde the closed-ended questions (multiple choice, true false, matching) with Flubaroo, an add-on for educators using Google Forms.
  • Create your quiz in a Google Form (from scratch or using one of the templates). If you want to email results to students later, make sure you make a short-answer question called “Email”.
  • Click the eye icon in the top right to view the assessment. Fill it in with all the correct answers and use the words “ANSWER KEY” as the name. Submit it with the button at the bottom.
  • Deliver your quiz to your students:
    • Use the “send” button to get a link to the assessment that you can give students
    • Use the “send” button to email a link to students
    • Add the form to an assignment in Google Classroom
  • When students have taken the assessment, click the “responses” tab and click the green spreadsheet button to see responses.
  • Go to that spreadsheet and click “Add-ons > Get add-ons …”. Search for Flubaroo and add it. (If you already have Flubaroo installed, you won’t need this step.
  • Go to “Add-ons > Flubaroo > Enable Flubaroo for this sheet”.
  • Go to “Add-ons > Flubaroo > Grade assignment”.
  • Use the drop-down menus to tell Flubaroo what to do with each question. Click “Continue.”
  • Choose the answer key you created earlier. (This will be easy if you made the name “ANSWER KEY”!)
  • Flubaroo will create a grading report for you with student scores and more.
Get more information about Flubaroo and its advanced features at the Flubaroo website.
6. Create a place for you to store quick grades. When students completed simple assignments for me, sometimes I would walk around the room, quickly grade their assignments on the students’ desks and write a grade on them. Instead of collecting those assignments, I wanted a place where I could store those grades to transfer to my gradebook later.
I created a Google Form with all of my students’ names on them. As I walked around the room, I had the form loaded on my iPad. I put each student’s scores into that form. Later, I pulled up the responses and transferred them to the grade book.
7. Create a digital sign-out sheet. Need an easy way to track students as they leave and return to your class? Create a Google Form where they log their name and their destination, as well as whether they’re leaving or returning. In the spreadsheet view, it will time stamp their submission, so they won’t need to write the time. (That way, the return time can’t be fudged to make it look like they weren’t gone as long as they were!)
8. Create a flipped classroom assessment. The flipped classroom comes in many different shapes and sizes, but many teachers have students watch a video and then answer some comprehension questions afterward. This is easily done in Google Forms.
  • Create a form. Add a YouTube video (click the icon to the right of the form with the triangle “play” button).
    • Note: You can also add a link to a website, an image, etc. … whatever content you want to deliver to students.
  • Add questions afterward to gauge their understanding.
  • Deliver the form to students:
    • Use the “send” button to get a link to the assessment that you can give students
    • Use the “send” button to email a link to students
    • Add the form to an assignment in Google Classroom
9. Make a Choose Your Own Adventure activity. By using branching (the “go to section based on answer” choice in the three-dots menu in a multiple-choice question), you can create fun Choose Your Own Adventure Story-type activities. Create them for your students or let students create their own!
Here’s a screencast video tutorial I created a while ago to show you how it works. The basics are still there, although the video shows how to do it with the old Google Forms.
Question: How have you used Google Forms in your own school? Which of these are you most likely to use yourself? You can leave a comment by clicking here.

Friday, December 18, 2015

Google Classroom Creating a Discussion Board





Google Classroom: Creating a Discussion Board: by Alice Keeler


Google Classroom Sheets Discussion Board
While I want threaded discussions in Google Classroom, I do not want them in the stream. Multiple student responses will clutter up the Google Classroom stream quickly. I always say “the answer is always a spreadsheet” so I created a way to use Google Sheets for a threaded discussion and use it in Google Classroom. It is not perfect, I’m a teacher not a programmer.
The advantage to using a spreadsheet for discussions is… it is a spreadsheet!! Google Sheets are in your Google Drive, easy to locate. It can be embeded into another website or linked to from just about anything. Information in the spreadsheet can be sorted and organized. Formulas can be applied, Add-On’s can be used, charts can be generated. Since the discussion board is not in another platform, it is easy to save the discussion board.
Since a spreadsheet has tabs, this allows you to conduct multiple discussions over the course of a unit.

Template

Go tohttp://alicekeeler.com/discussionboardto create a copy of the template.

Google Classroom

After creating the copy of the template attach it as an assignment in Google Classroom as “Students can edit file.” This explicitly shares the spreadsheet with the students. This way their name will show up in the revision history so you know which student made edits when. Google Classroom also protects the privacy of the students. The spreadsheet discussion board is closed to people outside of the class. Posting the discussion board in Google Classroom also makes it easy for students to locate and keep coming back to for repeated discussions.
Attaching a spreadsheet from Google Drive in Google Classroom as “Students can edit file” allows for all the students in the class to contribute to the same spreadsheet. As new discussion prompts are added to the discussion board, the same spreadsheet can be attached to a new assignment in Google Classroom. This ensures the discussion is located at the top of the stream.

Directions

After making a copy of the spreadsheet, you will want to go to the “Discussion Board” menu at the top and choose “Start Discussion Board.” This will require that you authorize the script.
Start Discussion Board

It will then prompt you for the first discussion topic and freeze the template cells so students can not edit the template.
Prompt for Question

Discussion Tab

A tab on the spreadsheet will be created that has the same name as the question. The question will also be placed at the top of the sheet. You may want to rename the tab, to make the name shorter, by double clicking on the tab.
Discussion Board
This creates a discussion board that students can respond to.
You can create multiple discussion boards by going back to the first tab and clicking on the add discussion button or by using the “Discussion Board” menu along the top. Choose “Add Discussion Topic.” A new tab will be created on the spreadsheet. Newer topics are placed to the left of older topics.
Discussion Topic added

Attach in Google Classroom

In Google Classroom create a new assignment and click on the Google Drive icon.
DIscussion Board attach in classroom
Browse your Google Drive for the discussion board you created. Change the default from students can view to students can edit file.
Students can edit

Locate Tab

Students need to locate the tab of the discussion they want to respond to. They can click on the “Big Mac” icon in the lower left-hand corner, next to the plus icon, to find a list of the discussion tabs.
Find tab at the bottom.

Select a Row

The script for this spreadsheet discussion board will insert a row below the row the student has selected. If the student clicks one time in any cell in a row and clicks the response button a new row will be inserted and their email address will be captured in column A. Students will type their own name into column B.
Response Button

Respond to Question

Two columns have been set up to allow students to either respond to the question directly or to respond to another student. Students will use Column C to respond directly to the question. Column D can be used to distinguish from initial posts.
Respond to Students

Students Can Not Delete Other Students Responses

The script is set up to not allow students to edit the responses of other students. However, they will be able to edit their own responses. Students are also NOT able to delete a discussion board unless they created the question.
Protected Cells

Attach Files

Files can not be directly attached into a spreadsheet. However, hyperlinks to the Google document in Google Drive can be placed in Column E.
Create a Hyperlink

One trick for creating hyperlinks is to type a short description of what you are linking to in Column E. Press enter. Click one time back on the cell with the text. Use Control K to create a hyperlink. Paste the URL where the text will link to in the “Link” box.

Notifications

Students can subscribe to changes in the discussion board by going to the “Tools” menu and choosing “Notification rules…”
Notification Rules
The students can then choose to receive an email after each student response, or receive a daily digest.
Daily Digest

Grading

I do not currently have grading features natively built into the spreadsheet. I recommend that when the discussion board is closed to click on the blue share button in the spreadsheet and REMOVE the students as editors. Change to viewers or remove all access. You could also make a copy of the spreadsheet to allow you to sort organize and filter the student data without messing up the discussions.
Use Column F on the discussion board to mark a score for the students. Using a pivot table you can add up the students total points or count up how many times they posted. You can also use the chart options under the insert menu to create graphs of student participation.
Digiprove sealCopyright secured by Digiprove © 2015

Monday, October 19, 2015

7 Great Chromebook and Google Drive Apps for Editing Photos


7 Great Chromebook and Google Drive Apps for Editing Photos

from:


In response to a couple of requests we received from our readers here in EdTech & mLearning, we went ahead and curated for you this collection comprising some of the best photo editing tools in Chrome web store. Most of these apps work perfectly on Chromebooks and some of them are also integrated with Google Drive allowing you to easily edit and save photos directly to your Drive account. Some of the things you can do with these apps include: editing photos, cropping, resizing, adding effects, adjusting contrast, rotating, removing unwanted parts, adding frames and many more.

1- Pixlr Editor

‘Pixlr Editor is a browser photo editor for all your editing needs. Have full control over your images, including layers and effects…If you're used to working with Gimp, PaintShop Pro, or Photoshop you will feel right at home with this online image editor. It contains a lot of the features that you normally see in desktop graphic design applications. Jump in and start using this tool with no registration required.’

2- PicMonkey


‘Free photo editor with Collage, Touch Up, Teeth Whiten, Fonts, Effects, Filters, Frames, Stickers & more…When you install our chrome photo app, the PicMonkey icon appears in Chrome's app launcher on the New Tab page, along with your other Chrome apps.  So you can fire up the Monkey from here, instead of pinned tabs or the address bar.  Go forth and photogrify!’

3- BeFunky


‘With BeFunky’s photo editor, you can play with hundreds of amazing photo effects that you can’t find anywhere else, like our world-famous Cartoonizer®, oil painting, and pop art effects. You can also add extra flair to your photo with hundreds of one-of-a-kind, hand-drawn graphics, like hats, beards, jewelry, photo frames, and graphic overlays. If text is your thing, BeFunky photo editor has tons of fonts and customized text layouts for you to choose from, or use any of the fonts stored on your computer! ’

4- Fotor Photo Editor


‘Online photo editing & photo creatives made simple and fun with Fotor. Fotor's free photo editing features including photo collage, photo frames, photo effects, photo retouching, color splash, tilt-shift, clip arts, text, photo cards, online HDR and more.’

5- iPiccy Photo Editor



‘iPiccy provides new, easy-to-use tools for modifying pictures, using advanced image processing. iPiccy offers the easiest user interface and workflow of any photo editing application, allowing users to easily pull images from any Web site or file folder. iPiccy includes an extensive variety of easy Web-based photo-editing tools such as Auto-fix, Rotate, Crop, Resize and Color adjustment and Sharpen - all in one place and in real-time. ’

6- Pixlr Express


‘Pixlr Express is a fun and powerful photo editor that lets you quickly crop, resize, and fine-tune any picture, all in a completely ad-free experience. Choose from over 2 million combinations of free effects, overlays, and borders to further personalize your images. Pixlr Express makes you look like a pro, even if you’ve never edited a photo before. ’

7- Pixlr Touch Up 

‘Smart, easy offline photo editor. Touch up, clone, crop, resize, rotate, adjust color, add effects, and more. Put the finishing touches on your photos with this free offline photo editor from Autodesk. Automatically remove unwanted details from your photos so it looks like they were never there.’

Monday, October 12, 2015

A Deep Dive Into Google Classroom - video tutorial/overview

A Deep Dive into Google Classroom video






For those of you interested in Google Classroom, and would like a video overview, here is a good one for you to try from The Gooru.


Friday, January 30, 2015

Become an ed tech ninja with your friends

Technological change evolves much faster than institutional change can keep pace, so we need a way to learn in a way that fits our busy lives.  Your teacher feedback has shown this to be the case, and you are looking for a way to quickly collaborate and share ideas in an organized way.

This video will show you how to use Bedford's Ed Tech blog the post and comment on your ed tech successes and challenges.


Your posts do not need to be formal.  The idea is that you have a place to quickly share thoughts and ideas when it is convenient for your schedule.  You are extremely busy and getting everyone together for a regular meeting may not be realistic, so a blog like this is ideal in this situation.

Using video, images, audio and links can greatly enhance your ideas.  Most people agree that face-to-face collaboration is the most desirable way to work as a team, but adding something like a short video explanation can get us pretty close.

If you can think of Blogger, Youtube, Facebook, Google, etc. as the modern versions of the slide-rule, abacus, pencil, paper, etc., we can accomplish great things while keeping pace with the way the world works today.  

Our students desperately need us to help them navigate the wide open world of technology.  If we can help our students to avoid getting lost in all of the garbage out there, we can show them how to use technology to love to learn...to become creators of information instead of consumers.

A great place for us to start would be to sign up to follow this blog from the "Follow by email" box in the upper-right corner of this page.  Then I would recommend finding a couple of other blogs that interest you to follow by email.  In this way, you will get frequent updates of other teachers' thoughts and experiences which can provide great motivation and inspiration for your classroom.

Here are a couple to start with:

All Bedford school teachers have been invited to be an author on this blog.  If you can't find it in your email, send a request to support@bedford.k12.ia.us.  If you are not a Bedford school teacher and would like contribute a post to this blog, contact our tech team at support@bedford.k12.ia.us to be added as an author.

Tools used to create this post:
iMovie



update: it appears that we are only allowed 100 authors per blog, so if you didn't receive an invitation and would like to post, let me know and we'll make it work.  :)