background preloader

Google Resources

Facebook Twitter

Google Drive: Students Turn In a Folder. If you are having students organize multiple work samples and files into a folder, you may wonder how it can be organized and submitted. I have written a script to allow students to submit a folder. Distribute a copy of the template to students. You can do this through Google Classroom or just give them the link to the template.Students go to Google Drive and open the folder they wish to turn in.Students need to copy the folder ID.

The ID can be located in the folder URL. It is the string of numbers and letters after the folders/ in the URL. Example: will go to the Add-On menu and choose “TurnInFolder” and “Start.” Since the folder is shared with the teacher, the files inside the folder are automatically shared with the teacher also. Copyright secured by Digiprove © 2015 Like this: Like Loading...

Google Sheets: Create Tabs Quickly. If you have ever clicked the plus icon to create a new tab and renamed the tab multiple times you know how tedious this can be when using a spreadsheet. I wrote a script that allows you to take a list and create a tab for each item in the list. I previously posted the RosterTab script for Google Sheets. I have updated the script to give you the option to delete the original list. The original RosterTab creates and names a tab for each item in column A. I have added ListToTabs to the RosterTab menu. To utilize either ListToTabs or RosterTab start with the RosterTab template: Type or paste a list of names or items in Column A of the first sheet. If you would like to have a template on each of the sheets rather than creating blank sheets try out TemplateTab. Like this: Like Loading... Create Group Documents. One request I am often asked about Google Classroom is how to create documents for small groups.

If you create a copy of a document for each student then each group member receives a copy, which can be confusing. I have created a script that will assign students into random groups (or non random) and create a copy of a template document for each group. After making a copy of the template, place your roster in column A and the student email in column B. Place the group size in cell B1. Go to the Add-On menu and choose “Group maker.” To create random groups click on the “Make groups” button in the sidebar. For each group a template document will be created for students to collaborate on. You will need the document ID. When prompted by the script, paste the document ID.

Each group will have a group document created. The links to the group docs are placed in the spreadsheet. Post the spreadsheet in Google Classroom as “Students can view file.” Convert Your PDF’s to Google Docs. This Google Docs tip tells you how to convert a photo or PDF into a Google Doc. Earlier I blogged on annotating PDF’s being a bad lesson plan. I had suggested that at the very least to put the information into a Google Doc so students can collaborate around it and insert comments. From Google Drive, right click on the image file or PDF file. Choose “Open with” and choose “Google Docs.” This will make a copy of the image or PDF into a new Google Document.

Images When converting an image, Google scans the image for text and extracts readable text out of the document. PDF’s When converting a PDF, Google Drive takes an image of each page and inserts it into the Google Document. Just because you can does not mean you should. Remember the 4 C’s for modern teaching: Critical Thinking, Collaboration, Creativity, and Communicate. Copyright secured by Digiprove © 2015. View images, videos, documents, and other files - Drive Help. With Google Drive on the web, you can view things like videos, PDFs, Microsoft Office files, audio files, and photos.

View a file Go to Double-click a file. If you open a Google Doc, Sheet, Slides presentation, Form, or Drawing, it will open using that application. Open a file using a different app You can open a file using web apps or apps installed on your computer. Go to Learn how to set a default app for opening certain file types. Share this: Evan is a Docs & Drive expert and author of this help page. Was this article helpful? How can we improve it? One Stop Resource For Google Docs.

If you’re a Google Docs user, curious about Google Docs, work with Google Docs with students, and especially if you’re looking for help understanding all of the features of Google Docs, then you’ve got to bookmark MaryFran’s Google Docs Tutorials. Created as a Google Site (of course), this is a huge collection of resources, tutorials, videos, … all devoted to helping the visitor understand the ins and outs of working with Google Docs.

That’s really the best description I can think of to describe this site. Navigation and use is as simple and powerful as Google Docs itself. Just select a topic of interest from the left side navigation menu and read on. Google Docs users – make sure that you bookmark this resource. Powered by Qumana Like this: Like Loading... Related OTR Links 12/16/2011 Main Page - Math Lesson and Unit Plans page divided by grade level and strand. In "Links" OTR Links 04/09/2012 OTR Links for 07/10/2011 In "Computers" 100 Google Docs Tips. November 9th, 2009 Students and educators have a wealth of learning and productivity tools available to them online. Google offers some of the highest-quality resources on the web to meet all your study and teaching needs, and all you need to access them is an internet connection.

The Google Docs collection provides a streamlined, collaborative solution to writing papers, organizing presentations and putting together spreadsheets and reports. But besides the basic features, there are lots of little tricks and hacks you can use to make your Google Docs experience even more productive. Here are 100 great tips for using the documents, presentations and spreadsheets in Google Docs. Keyboard Shortcuts Navigate your documents and screen a lot faster when you use these keyboard shortcuts for formatting and more. Productivity Hacks These hacks will make your Google Docs experience even more efficient and streamlined. Features and Tools Collaboration Files, Folders and Filters Organization Edits Search. Google Apps for Education: Tips & Tricks.

Leveraging Web 2.0 tools like Google Apps is a powerful learning strategy in the 21st Century. But how do you choose the right tool that will enhance classroom learning and not be an afterthought or add on? We’ve put together some best practices for Google Apps for Education. Collaborate Students, colleagues, and professionals can share ideas, give feedback, produce meaningful products and more! Collaborate on a singular document (versus sending multiple versions back and forth via email)Upload and convert document files (up to 2 MB)Work together synchronously or asynchronously Share Documents can be made private, public or shared with just a few peopleGoogle accounts aren’t required for everyone to collaborateInformation is stored in the cloud and can be accessed 24/7 Use the Templates App Free templates include teacher and student planning tools, evaluations, rubrics, newsletters and more!

Use the search feature Organize Google Apps for Education: want to learn more? Enjoy this? Documents. Google. 38 Ideas to Use Google Drive in Class. August 11, 2014 This is the third post in a series of posts aimed at helping teachers and educators make the best out of Google Drive in classrooms. This series comes in a time when teachers are getting ready to start a new school year and hopefully will provide them with the necessary know-how to help them better integrate Google Drive in their teaching pedagogy. The two previous posts featured in this series were entitled consecutively "New Google Drive Cheat Sheet" and "Teachers Visual Guide to Google Drive Sharing".

Today's post covers some interesting ideas and tips on how to go about using Google Drive in your classroom. This work is created by Sean Junkins from SeansDesk. Google Docs. Google Classroom: A Sneak Peek. 7/30/2014 By: Shannon Mersand Google is starting to allow early adopters to check out Google Classrooms this month. Although the program is limited in functionality, it looks pretty exciting. Here’s how it works: When a user creates a Classroom, a join code is created. Users can either add students manually or give them the join code to use. Users are only able to add students from within their GAFE domain. A folder structure is created in the user’s Drive, which also acts as a holding area for documents that have been assigned and collected from students. The two main functionalities of Classrooms are the ability to add announcements and assignments.

When creating assignments, teachers can allow students to view a file, edit a file, or make a copy for each student. Assignments and Grading: When teachers use the “Create a Copy” function in Classroom, students cannot continue to edit the assignments once they submit it. Summary: Don’t throw away your LMS just yet. 20 Things You Can Do With Google Classroom. Early Review of Google Classroom -e-Literate.