Creating QR Codes

If you would like to create QR codes for your class here is a workflow that works for me.

ShortenMe

Using the Chrome web browser install the ShortenMe chrome extension. Click Here

What this extension allows you to do is create a short URL and a QR code from any website.
shortenme qr code

 

Google Slides

Create a new Google Slides presentation from Google Drive. Choose a white presentation. Since I am going to print the slides, I choose the slide size to be the “Standard 4:3″
Google Slides Standard Size

 

Blank Layout

I am going to make each slide a large QR code. Choose the blank layout for each slide.

Websites

Go to the websites you want to direct your students to via QR code. Oftentimes this is a  YouTube video with basic skills tips or advanced tips to extend the learning.

Click on Extension

The ShortenMe Chrome extension looks like 3 dots. You will find this to the right of the Omnibox.
shortenMe

Click on the QR Code

By default the short URL will be copied to your clipboard. You need the link to the QR code. Clicking directly on the QR code does not copy the image of the QR code, but rather the URL to the image.
shortenme qr code

Insert Image

Back in Google Slides, use the insert menu to insert an image.
Screen Shot 2014-10-30 at 11.41.52 AM

By URL

Rather than uploading an image, choose the “By URL” option along the top of the insert image screen. Paste the URL that was automatically copied to your clipboard into the input box.
Insert image by URL Google Slides

Resize QR Code

The QR code will be small on the slide. Use the image resizing handles to allow it to fill the entire slide.

Insert Blank Slide

Insert a blank slide in the Google Slides presentation and insert another QR code. Repeating the process of going to the website, clicking on the extension, clicking on the QR code, inserting image by URL in Google slides allows you to quickly create a collection of QR codes.

Print

QR codes are made to be printed. They allow mobile devices to scan and link to a webpage or information. Print the Google Slides presentation and make these QR codes posters on the wall.

Posted in Google, Presentation | Tagged , , , , | 1 Comment

Google Sheets: Create a Map

Google Sheets Country Map

 

Today I needed a map of the countries that participate in the TIMSS study. The website provided a list of the countries, I just needed to map them.

Google Sheets

From Google Drive (http://drive.google.com) create a new Google spreadsheet.

Copy

Highlight the data on the website. Use Control C to copy the data.
Screen Shot 2014-10-30 at 9.51.26 AM

Paste

Selecting cell A1 I paste the data from the website using Control V. I only need the list of country names, not the rest of the data. However, the extra columns will not inhibit my ability to create the chart so it is optional to delete the superfluous columns.
Screen Shot 2014-10-30 at 9.52.46 AM

Clean Up the Data

When copying and pasting data there is a potential for the rows and columns to not paste perfectly. Make sure you check the data you copied and pasted. In particular the first and last data point might have pasted funky. Also check the data that occurs after headers. If the data has multiple sections you may need to delete out section headers or move data around.

Highlight the Data

In my example only column 1 contains the names of the countries I want to chart. I clicked on the column header for column A. If this was not the case I would want to highlight the range of data that I want to graph. Note that if your data skips columns, such as column A and D contain the data you want to chart, you might want to copy and paste into a new tab the data you want to chart so you can move column D next to column A. It is better if your data is together.
Screen Shot 2014-10-30 at 9.59.15 AM

Chart Wizard

Click on the chart wizard icon in the toolbar or use the Insert menu to choose “Chart.”
Google Sheets Insert Chart

Choose Country Chart

Google Sheets looks at your data and gives you some suggestions for the charts it thinks you might want to use. Since the data is a list of countries, Google Sheets shows me a suggestion for a chart of the map of the world. Choose this chart. If that is not an option click on the tab that says “Charts” and locate the countries map.
Google Sheets Recommended Country Chart

Own Sheet

After choosing the blue “Insert” button the chart will be floating on the tab with the data. You can move this chart around and also resize it if you want it to be side by side with the data. Alternatively, notice the drop down arrow in the upper right hand corner. Clicking on this provides options for saving the image or moving it to it’s own sheet.
Google Sheets Map Countries Move to own sheet

Posted in Google, Spreadsheet | Tagged , , , | Leave a comment

Google Classroom: Turning in Group Work

google classroom groups

Currently Google Classroom does not have a feature for group work. Here is my work around.

Create a Spreadsheet

I use Google Sheets to have students indicate who is in their group. Alternatively, when I assign students to groups, I will list out their names on a Google spreadsheet also.

Google Classroom makes it easy to share the spreadsheet. Attach a Google Sheets file from Google Drive and set it as “Students can edit file” if they choose their own groups or “Students can view file” if you have assigned the groups.

Suggestion to have the first column say “Group Leader” to indicate which student is going to take responsibility for the group work documents.
Google Sheets group work sign up

Tip from Alice

I number all of my assignments to make it easy to keep track of them in the gradebook. This also creates a nice file structure in the Google Classroom folder in my Google Drive. Click Here for my blog post on this.

In addition to numbering the assignments, I also start any documents students will be using in connection with this assignment with the same assignment number. This makes it clear for the teacher and the students which documents go with with assignment. This is particularly helpful when an assignment has multiple documents.

Attach Template

Attach the template or graphic organizer with a status of “Make a copy for each student.” This ensures that the students work is shared with the teacher and is in the assignment folder in Google Drive.

This creates a copy for each student, not for each group.
google classroom assign group work

 

Group Leader

The group leader will need to open the group work document and click on the blue share button. The group leader will add the group members to the document to allow them to edit.

The group leader will also need to modify the document title to add the names of the group members to the end of the document title.

Group Members

In Google Classroom the other group members will need to click on “OPEN” and click on the X on the right hand side of the attached documents.
google classroom delete default assignments

Turning In

Once the group work is completed, the group leader will “TURN IN” the document to Google Classroom.

The other group members will go into Google Classroom and click on “MARK AS DONE.”
Google Classroom Mark as Done

Posted in Classroom, Google | Tagged , , | 2 Comments

Mobile Google Slides: Adding an Image

Screen Shot 2014-10-22 at 4.16.43 PM

If you are on a Mobile device such as an iPad, android tablet or your phone you probably have the Google Drive and Google Slides app.

If you are using Google Slides on the Mobile device you will notice that you can not add an image to the slides. Here is a tip I learned from Jon Corippo.

Convert to PowerPoint

If you take your Google Slides and export to PowerPoint and open the PowerPoint in Google Slides you are able to add images to the slides. You can then convert back to Google Slides when you are done adding images.

Open the Google Slides App

image

Open a Google Slides Presentation

image

 

Triple Dot

Click on the triple dot icon in the upper right hand corner to reveal options for the presentation.
image

Share and Export

Choose “Share & export” from the settings options.

image

 

PowerPoint

Choose the “Save as PowerPoint (.pptx)” option. image

 

Tap on Slide

This will launch the presentation in Google Slides as a PowerPoint file. Notice the orange P in the upper left hand corner.

image

 

Plus Button

Tap on a slide to reveal the edit options. The plus icon allows you to add elements to the slide.

image

 

Add Image from Camera

Choose the option to add an image from camera. Click the blue checkmark.

Triple Dot Again

Once you have inserted your images you can convert the file back to Google Slides. Click on the triple dot in the upper right hand corner. The first settings option says “Office Compatibility Mode.” Click on this first option.
image

 

image

 

Back to Slides

Choose “Save as Google Slides” to convert the file back if you wish. Note that this is a NEW copy and that the original Google Slides presentation remains without pictures.
image

Posted in Drive, Google, Uncategorized | Tagged , , | Leave a comment

Second Life in Education

Screen Shot 2014-10-22 at 2.24.41 PM

 

Second Life is a 3D virtual space where each player has an avatar that has the ability to explore the world. Second Life is free to use, although you are able to purchase virtual items within the space. Second Life is a tool that could be utilized in the classroom. A caution is the required bandwidth and computer processing power. Second Life is also a community of players. Setting students loose to explore the virtual spaces of Second Life could potentially cause them to interact with elements that may not be appropriate.

Purchase an Island

Second Life allows you to purchase specific space to build and create. This space can be crafted for your students to interact and learn. This space can be set up to have students meet, create, interact and most importantly explore. As the teacher you design the learning environment in the physical classroom. This becomes literally true in Second Life. As an instructor you have complete creative control to set up an exploratory environment for students.

Virtual Field Trips

When it would be impossible to take your class to Globe Theater, Second Life can allow for virtual interactive field trips. Many historical places, museums and locations have been recreated in Second Life. Rather than simply watching a slideshow of images, students can use their avatar to explore, wander, and “touch” things in the virtual environment. This can be significantly more enriching and immersive.

Online Interactions

Students in your face to face class are able to use Second Life in a variety of ways, however, Second Life can have some positive benefits for students enrolled in a fully online class. The classroom can be recreated in Second Life to give students the classroom experience. This would include intermingling with classmates, conversations, sharing and discussion. Getting outside of the traditional classroom structure Second Life provides collaborative space for students to create, meet, explore and engage in inquiry based learning.  This gives online students the feeling they are physically together when they are separated by distance.

Machinima

Machinima is a technique of using video games or virtual worlds to create videos with a storyline that is outside of the game itself. An example would be students using World of Warcraft to have their characters (toons) act out a scene from a Shakespearean play. Second Life can act as a stage for students to recreate historical events, carry on a debate or otherwise demonstrate their learning.

Posted in Gamification | Tagged | 1 Comment

Google Forms: Formative Assessment Tips

Google Forms Google Drive

If you use Google Forms for formative assessment quizzes here are some tips for managing the resulting spreadsheet.

Ask for Student ID Number (SID)

When organizing data it is important that your data match. Trying to sort data by student name can be sketchy when students type in their own name. They might use “Robert” one day and “Bob” another. They may simply misspell their name. While I do not need the students ID number it is harder for students to get creative in how they fill it out. This makes it much easier to sort and organize the results.

First Name

Rather than ask for “name” make 2 questions. One for “First Name” and one for “Last Name.” This way you can easily sort the resulting spreadsheet by either first or last name. This is also very handy when putting the results in the gradebook.

View Responses

From the edit screen of the Google Form you want to “View Responses” in the toolbar in order to open the spreadsheet of data. (The first time you will want to leave the defaults in the pop up window and click on “create.”)
view responses google sheets

Answer Key

After creating your Google Form go to the live form and take the quiz. For first name put “Answer” and for last name put “Key.” Fill out the form with the correct answers. This makes the first line of data in the spreadsheet the correct answers.

google forms answer key

Freeze Bar

By default the first row of the spreadsheet is frozen. This allows you to scroll through all of the student answers and still see the questions. If you were the first person to answer the Google Form quiz and you used “Answer Key” for the name, then the second row contains the answers.

On the left hand side, between rows 1 and 2, hover over the freeze bar. You will notice the cursor turns into a hand. Click down on the freeze bar and drag it down to freeze the first 2 rows. This will freeze the answer key at the top of the spreadsheet. As you scroll through the student answers you can compare their answer to the answer key easily.
freeze bar

animation

Sort

Hovering over the column indicators will reveal a small drop down arrow. Click on this to choose to sort the sheet. You can sort the results by Last Name, Period, etc…
sort sheet

Sort each question. This will allow you to cluster which students answered what. Since the results of a Google Form are instantly in the spreadsheet as students submit you are able to quickly identify which students answered each answer choice for a particular question. Divide up the students by who answered what to provide a differentiated activity.

Multi – Column Sort

You probably want to sort by multiple columns. Such as by Period, Last Name and then First Name. There is a blank box to the left of column A and above row 1. I call this the “awesome box.” Right click on the “awesome box” to reveal a list of options for the entire spreadsheet. Choose “Sort range…”

awesome box

 

Check the “Data has header row” checkbox. Choosing “Add another sort column” allows you to sort by multiple columns at once. The order matters. If you want to sort by Period and then Last Name you need to sort by Period first and Last Name second.
sort range google sheets

Conditional Formatting

Conditional formatting allows you to color code the cells based on the answer. For example if the student put down the correct answer the cell background color will be green. If a score is less than 70% you can have the background color be red. This allows you to easily identify trouble areas and find selected answers quickly.

Click on the column indicator of a question to highlight the entire column. Right click on the column indicator and choose “Conditional formatting.”
conditional formatting google sheets

There are a variety of ways you can test the data for the conditional formatting. If you have an exact answer you are looking for choose “Text is exactly” from the drop down menu. If you are testing numbers you may want to choose something like “Greater than.”
conditional formatting

Choose the formatting options that will display if the cell has that value. You can add multiple rules.
add another rule conditional formatting

Example of Conditional Formatting

Conditional Formatting

Posted in forms, Google, Spreadsheet | Tagged , , , | 2 Comments

Google Drive: Do NOT Share Everything in a Folder

Folder Image by Ken Hess

Folder Image by Ken Hess

One trick for collaborating using Google Drive is to create a folder in Google Drive and to share the folder. Anything you put into the folder will automatically have the same sharing permissions as the folder.

Sharing a Folder

Previously I had blogged about how to share a folder in the new Google Drive. Create a folder, click on the share icon in the toolbar, add permissions.

Sub Folders

You are able to create a folder within a folder. Go to the folder in Google drive and click on the “New” button to create a new folder. This folder will be nested inside the first folder. Usually by default a folder is private; however, the sub folder will take on the same sharing characteristics as the parent folder.

This is also true for any documents you put into the parent folder.

Organizing but Not Sharing

Occasionally I have need to have files in a shared folder to NOT be shared with my collaborators. Perhaps I have some brainstorming notes or something else that is related to the project but not intended for others to see.

Peer Evaluations

This is especially true when I am working with students. I want to create a folder for peer evaluations. I set the folder to anyone can edit which allows the students to comment on the work of other students. I use a Google Form to have students provide feedback and to give me data to analyze about the peer evaluations. I want to save the form and the spreadsheet in folder with student work, however, I do not the students to have access to the spreadsheet.

Change Sharing Settings

While any documents or folders within the parent folder automatically take on the sharing settings, these can be modified on a case by case basis.

Within a document click on the blue share button. The pop up window will indicate who the document is shared with, clicking on the text that says “Shared with…” or on the word “Advanced” in the bottom right hand corner will open the sharing window.
click on these links

The advanced sharing window allows you to change editing rights or REMOVE collaborators from a document. Next to each persons name is a drop down menu to change from “Can edit” to “Can comment” or “Can view.” Remove the collaborator all together by clicking on the “X” on the right hand side.
remove or change permissions on sharing google docs

Document Level Permissions

Each document has it’s own sharing settings. Placing a document into a shared folder does not permanently alter the documents sharing settings. Moving the document out of the folder will restore the documents previous share settings. This allows you to temporarily allow access by some collaborators by placing documents into a folder. You are then able to easily restrict access again by taking the document out of the folder.

Example

Let’s say I have a document that is privately shared with person A and person B.
privately shared document

I have a folder that is set to anyone with the link can view and is also shared with person C, D and E.
share folder anyone with the link can view

If I move the document into the shared folder, it will be shared with person A, B, C, D, and E and will now have the sharing permission of anyone with the link can view.
Anyone with the link can view

I can remove editing rights from person B and C from the document by clicking on the blue share button in the document and removing their individual permissions.
Remove permissions

If I take the document OUT of the folder. It will go back to being privately shared. It will NO LONGER be shared with person D and E. Since at the document level I removed permissions for person B they also will no longer have access.
Untitled drawing (4)

Posted in Drive, Google | Tagged , , , | 1 Comment

iPad in Physical Education Bootcamp

iPad-Bootcamp-Advert-1

I believe Physical Education is an important part of schools. Being an expert in EdTech, I will occasionally encounter a comment along the lines of “You can not use technology in PE.” I know many excellent PE teachers who are not only using technology in their classes, but are doing amazing things with it.

Fellow Google Certified Teacher, Jarrod from Australia, has an amazing website (https://thepegeek.com) with uses for technology in the Physical Education classroom. Jarrod has been a big help to me on several occasions. He is also the creator of the Move-It Chrome extension that I use everyday. You can follow Jarrod on Twitter @mrrobbo.

Bootcamp

The PE Geek is offering a FREE bootcamp in using iPads in PE. You can sign up by going to the PE Geek website: https://thepegeek.com/2013/10/the-ipads-in-pe-bootcamp/

Posted in iPad | Tagged , | Leave a comment

Google Classroom Deployment: Advice from David Malone

If your school is considering using Google Classroom, or is already using Google Classroom, here is some advice from David Malone on managing Google Classroom from the administrative perspective.

Posted in Classroom, Google | Tagged , | 1 Comment

10 Reasons to Introduce Google Classroom to Blackboard

Posted in Classroom, Google | Tagged , , , | Leave a comment