Google Docs, Slides, Sheets Templates Workflow on iPads

The Google Docs, Slides, and Sheets apps provides some great TEMPLATES for students to create something that will "show what they know".  All of the screenshots in the presentation below are from the iPad app.  While this was the workflow I used for Lunch N' Learn, all of the same template options are found on a computer.

VIEW THE PRESENTATION

The presentation above was created on Keynote on my iPad.  I "made a copy" of it and sent it to my Google Drive.  If you are desiring students to make Keynote presentations, this is the workflow to get the presentation to a teacher.  As blogged about earlier, I really like Keynote on my iPad while presenting.

IMPORTANT: Teachers must have students turn in any assignment in Canvas that requires a Google Doc, Slide, or Sheet to be submitted as a "File Upload" through Safari and not simply a "Website URL".  See poster below.

Canvas Settings For Google Assignments by ClayReisler

Research Topic Sign Up Cross Out When Taken

I just worked through a process where Mr. Gosse, Chemistry teacher, wanted students to sign up for research topics.  He created a Google Sheet that will be shared with students.  He added formulas to the right side of the sheet so that the topics are crossed out when a student adds their name.

Because the entire sheet needs to be shared with students in an editing mode, he wanted to know if certain cells (the topics on the right side) could be protected.

They can.

Students will now choose their topic and add their name all within the Google Sheets app on their iPad.

Here's the document.

Explore - Design Suggestions In Google Docs, Slides, and Sheets

Google Docs, Slides, and Sheets used to have a "research" area on each file to help with finding information while creating.  Google has changed that to "Explore".

Explore Colorful Image Above Created By Jack Wallen

All of the features are available on a computer or Chromebook.  Unfortunately, they are not available on an iPad at this time.  However, many educators continue to create lesson content on a laptop or computer, and these features may come in handy.

A detailed description of how these work can be found here.

The official Google Docs Blog also has some quick tips on how to use the new features.

Docs...

Slides...

Sheets

Many of the Explore options will be discussed today during Lunch N' Learn.

Doctopus + Goobric + Google Classroom

If you are considering using Google Classroom or are a current user, connecting Doctopus and Goobric would be an excellent efficiency tool.

If you use a rubric to grade student work, Doctopus and Goobric will allow for an assessor to place a rubric directly on a digital document.

During Lunch N' Learn, the "how to's" and "what if's" will be discussed.

Google Apps Needed On The iPad

Google Apps are getting better every day!  Yesterday, when I created a picture, I just tweeted it.  Today, I realized I've utilized and posted a large number of times on these tools.

Google Drive App
Drive & Docs on iPad
Turn In Folder
Updates For Staff
Book Exporting Options
PicCollage To Google Drive To Teacher
Google Drive i Stands For Information
Google Drive To Document Standards
Google Drive on Computer and iPad
Google Drive on the iPad
Stick Around To Google Drive

Google Docs App
Google Docs on the iPad
Google Docs via Safari on Web
Google Docs Discovery By Student
Reading Book and Using Google Docs

Google Sheets App
Google Sheets on the iPad
Time Sheet via Google Form

Google Slides App
Google Slides on the iPad
INSERT Image in Slides (workflow for now)
Explaining Blood Flow in Heart (Images coming soon on iPad)
Google Slides to Explain Everything
Rethinking Slides
Google Linking Options

Google Search App
Slightly Different on iPad
Google Search Features
Underutilized app - Need to do more with this!

Google Classroom App
Google Classroom (app just came out, reviewing later)
Assignment Quick View
Starting New Semester or Removing Students
Google Classroom Intro

For an amazing resource, Check our Google Apps for the iPad by ShakeUpLearning

40 Seconds With Flex Mod Digital Workflow

As readers of iPaddiction know, Pulaski High School is transitioning to the flexible modular schedule so finally, "Time can serve students, instead of students serving time".  As a result, we are creating informational videos to answer questions.

WITHOUT the use of the iPad and all its apps, Google Drive and its collaboration capabilities, and the incredible creativity by our staff and students, these videos would NOT have been completed in LESS THAN 24 HOURS!

Making these videos required an efficient Digital Workflow.  The process included:

• Google form to gather questions from students after the introductory video
• Answering the questions in print form on a Google Spreadsheet
• Assigning multiple teachers to record videos via smartphones of students asking the questions 
• Uploading these videos to a Google Folder using the Google Drive app on smartphones
• Renaming the video questions by the question in the Google Drive app
• Assigning multiple teachers to record videos via smartphones of teachers answering the questions
• Importing a introduction "40 Seconds With Flex Mod" graphic created by our art teacher on an iMac in Photoshop into a single iPad using Google Drive
• Creating the original soundtrack by our band teacher using AudioTool in Chrome
• Converting the soundtrack from a MP3 file to an ACC file using Online Covert 
• Importing the soundtrack onto a single iPad using Google Drive
• Using "Open In" for all of the graphics, sound, and video into iMovie on the iPad
• A black background was placed for two seconds before and after the video to allow for the music track to work
• The audio track was cut at the time the student started asking the question and the teacher ended answering it.  The audio during the speaking was dropped to 30% of the original volume
• The video was renamed the question and produced to the camera roll.
• Google Drive allowed for all the videos to be uploaded into a shared Google Drive folder
• Our website designer placed them on our flex mod website's  FAQ page

Playlist

2014 Midwest Google Summit Day 1 Resources and Reflection

The 2014 Midwest Google Summit began today as a two day learning opportunity for educators.  Teachers were focused on integrating Google Apps for Education by certified Google Teachers.  My notes were taken with the Paper 53 app which allows for tremendous creation opportunities.  I used the #Sketchnote option to produce ideas.  I chose this method because all of the resources that presenters create are online.  I wanted to create the notes so that they make sense in a visual way.  Below are the highlights of my learning day complete with visual Sketchnotes and written information.

Mark Garrison - Keynote

Important Statements:

• Experiences In Technology Involve Innovation
• It's Not What The Teacher Knows About Tech, It's What The Students Create
• Ask Students To Change, Need Teachers To Lead
• 4 Cs are Above SAMR
• Start Stop Share

David Freeburg - Google Apps On The iPad

Important Statements:

• Google Search App is Under Used
• Google Earth and Google Maps On the iPad Can Be Integrated
• Google Play For Adding Books

Jennifer Zurawski - YouTube: From Consumer To Producer

Important Statements:

• Four Stages of YouTube Use: Funny Videos, Tutorials, Publishing, Google Hangouts On Air 
• Funny Videos For Hooks and Discussion Starters
• Tutorials For Sub Plans and Video Tutorials of Lessons
• YouTube for Uploading of Content, Web Cams, Hangouts, and Editor

John Taylor: gMath Google Add-On

Important Statements:

• Created By John McGowan
• Math Equation Editor For Docs, Sheets, Slides, Forms
• LaTex is the Language That Makes It Work, Preview Is What Makes It Make Sense

Day 2 Reflection

Google Sheets, Slides, & Classroom on the iPad

Part 2 of 2. View Part 1 with Drive and Docs on the iPad

Google Sheets on the iPad


Google Slides on the iPad

• View preexisting Google Presentations created on a laptop/computer
• Share preexisting Google Presentations created on a laptop/computer
• Present preexisting Google Presentations created on a laptop/computer
• Create new presentations with formatting of each slide 
• Cannot (at this time) insert an image into a Google Slide on the iPad
• Collaborate on a slide presentation with multiple users

Educational Uses For Google Presentations/Slides

• Virtual Tours
• Choose Your Own Adventure
• Step By Step Processess

Google Classroom

• Use with Chrome or Safari browser
• Access all Google Drive content
• Teacher/Student Dialogue
• Teacher assigned tasks with due dates
• Attach photos from iPad, links, YouTube content

View the Features

Google Templates, Google "Save As A Doc" Google on the iPad

Google Template
Many items that pertain to content area, classroom management, and personal computing can be found in the Google Template Gallery.  People around our school district and the world can submit "documents for use" so that students or teachers can use them in their classrooms.

The Google Template Gallery is not automatically in your Google Drive.  You will need to restore the gallery into your drive.

Having students or teachers submit documents/forms/sheets/presentations to the gallery can provide some great resources for YOU to use.

Mr. Barszcz, English teacher, created a Sub Plan Template that could be used by any teacher for any subject.  Consider using it.

Mrs. Moehr, FACS teacher, created a grocery order form that can be used during each project.  No need to recreate.  An "automatically created" new document is created for you.

Mrs. Forsberg, middle school teacher, created a paragraph/essay planning template.  When students "use this template" a new copy will be created for the students.

Google "Save As A Doc"
Through this blog post, I was provided a solution to a problem that has perplexed our teachers who use forms for some time.  When lengthy questions are entered into a Google form, it is challenging to read in the "sheets" format.  Finding the "Save As A Doc" add-on, places all chosen cells of data from a sheet into a document which is easy to read.



Google Shuffle Questions on Forms
GET THE AMAZING INFORMATION

Google on the iPad
Mr. Ken Westphal, technical support, provided our staff with excellent directions that explains why/how a Google doc, spreadsheet, or presentation can be edited on the iPad.  Remember, the Google Drive app (video is from 2012; some slight current differences) now does not allow for editing one of these three items...

• If users want to Edit a Google Doc, they'll now need the Google Docs iPad app - see here
• If users want to Edit a Google Spreadsheet, they'll now need the Google Sheets iPad app -see here
• NEW - If users want to Edit a Google Presentation, they'll need to the Google Slides app -see here

Time Sheet via Google Form For AP Psych PBL

Mr. Krause will be providing a Problem/Project Based Learning opportunity.  Students will create a "time sheet" via a Google form to record their total minutes focused on specific tasks.  Sure, we could just have them create a Google Sheet for recording of data, but we wanted something "flashy".  Google Forms provides a way for students to "enter" their time.

After the time sheets are recording in the Google sheet, students will use a formula to add of the total minutes.

View Presentation To Students On Making A Google Form

Impact On Students:
Critical Thinking:  Allotting the correct amount of time on the correct task is a valuable life lesson. Not only are we allowing students to design their own time sheet, we are also asking them to be responsible for their time on tasks.