The Electric Educator: Google Drive
Showing posts with label Google Drive. Show all posts
Showing posts with label Google Drive. Show all posts

Friday, March 15, 2019

5 ways to prevent cheating on your Google Form Quiz

5 ways to prevent cheating on your Google Form Quiz


If you are using Google Forms to give quizzes and tests in your classroom, you are likely aware that some students have figured out various ways to "game" forms to get a better grade:

  1. Open a tab to look up answers
  2. Preview your form before class to look up answers
  3. Send questions to their friends
  4. Share answers with friends
  5. Take screenshots of your the quiz questions
  6. View the HTML page source to find answers
  7. Look at a friends screen to select answers
  8. Right-click on words to check definitions and spelling
  9. Share answers with classmates during passing time
  10. Write down "cheats" on their hand or paper

The fact that students are looking for shortcuts to improve their quiz scores shouldn't come as a surprise. (You may have been this student when you were in school!!)

I believe that formative and summative assessments have an appropriate role in the classroom and that it is our duty as educators to take reasonable action to maintain the integrity of these assessments.

Google Forms is a tremendous tool for organizing and automating digital quizzes. Here are five tips for designing "cheat proof" Google Forms!

πŸ‘‰ Note: want to see all of these tips in action? Check out this demo form!

Shuffle answer choices to block screen creepers

When asking a multiple choice question, click on the "snowman" to find the "shuffle option order" feature which will randomize the order of the answer choices in your question.

Shuffling answer choices will make it more difficult for "screen creepers" to copy answers from a classmate.

Note: Google Forms does have a "shuffle question order" feature, however using it can lead to issues. I recommend shuffling answers over shuffling questions. 


Prevent cheating in Google Forms: shuffle option order

Use page sections to block assessment previews

Add sections to your quiz to prevent students from previewing a form before class. This is a common problem if you post your quiz through Google Classroom to all of your sections early in the day. 

You can take this a step further by adding a "password" to your form to prevent students from moving ahead until you are ready. 

An easy way to do this is to collect their personal information (name/section) on the first page of the form, but require a password before they can access the quiz question. 

Set up a password by adding a short answer question and using the data validation feature to require a specific number or phrase. 

Note: this is not a 100% secure solution and should not be used to protect sensitive information. 

Prevent cheating in Google Forms: add sections to prevent assessment previews

Use page breaks to create alternative assessment paths


Google Forms doesn't have a question bank feature to create different assessments for each student. However, you can create a similar experience by creating a branched form. 

First, add an un-graded multiple choice question in your quiz: “pick a number”, “pick a color”, etc. 

Next, set up 3-5 different sections to your quiz using the section feature mentioned in tip #2 above. Add as many questions as you like to each section.

Finally, add a "go-to" rule to direct students to a different section of the based on their response to the un-graded question that you added. 

Prevent cheating in Google Forms: use page breaks to create alternate assessment paths


Prevent cheating by asking better questions!


Don't limit your self to multiple choice questions. 
  • Sequence questions - use the "checkbox grid" question type to ask students to sequence or arrange items in a list.
  • Matching questions - use the multiple choice grid question type to create a matching question (great for vocabulary quizzes!)
  • Reading Passage - use the title/text element to add a short reading passage. 
  • Video question - have students watch a video and then answer questions about it (great for math and world language. 
  • Image question - images can be used as the question stem or question choices (great for science, math, social studies, and elementary students)
  • Free response / short answer - If a student can answer all of the multiple choice questions correctly, but can't articulate 2-3 sentences on the same topic...something is wrong.

Prevent cheating in Google Forms: ask better questions


Enable locked quiz mode

Locked quiz mode is one of many tools you have to protect the integrity of your assessments. When used in combination with the tips above, you have done your part to protect the integrity of your classroom quizzes. 

Locked mode prevents students from accessing external resources while taking a quiz. Their tabs, extensions, chrome apps, and screenshot functions will be disabled during the duration of the quiz. 

You can turn on this feature the settings page on your Google Form OR when assigned through Google Classroom.

I wrote a detailed overview of locked quiz mode here.

Prevent cheating in Google Forms: locked quiz mode

If you use some / all of the tips listed above, you have done your part to protect the integrity of your assessments and encourage your students to practice academic honesty. 

There is no way to be 100% certain that students can't cheat on an assessment. Ultimately, they are harming themselves and their academic growth. Our job is to encourage, instruct and train them to do their best and show good character, even when they have the opportunity to cheat. 

Monday, March 4, 2019

5 tips to design better forms



5 tips to design better forms...

Google Forms is a marvelous tool in the classroom. Get even more value out of form by applying these five tips that go beyond the basics.


1. Use validation to collect better data

Your Google Form is only as good as the data it collects. If your data is a mess, it won’t be very useful.

Many of the question types in Google Forms offer a setting called “response validation.” Use it to require a response to fit a certain criteria:



  • Checkbox questions: set a minimum or maximum number of choices that can be selected.
  • Short Answer question: use the Regular Expression feature to get consistently formatted phone numbers, zip codes, or state abbreviations.
  • Paragraph Question: set a minimum or maximum response length

2. Make your form look pretty!

While Forms has added the ability to change the header image, background, and some limited font options, with a little effort you can really make your form look nice!

I frequently split my form into different sections and use the image element to add graphics.

A good example is this conference registration form: http://tinyurl.com/y48js49p



I use Canva to create most of my form graphics. I discovered that the “Leaderboard” template works really well with forms.

Another trick you can try is adding emoji to your form questions and answer choices. I use the πŸ”₯and πŸ‘‰ symbols to emphasize important information or 1️⃣2️⃣3️⃣4️⃣ if I have a set of steps I want to clearly explain.

The Emoji One Chrome extension is what I use to access emoji icons on my Chromebook (works on Mac and PC too!).


3. Automate with Add-ons

Once you’ve mastered the essential elements of forms, you MUST dive into add-ons.

Add-ons are like apps for Google Drive. To become a true Form Fanatic you need to be familiar with add-ons for forms AND sheets.

Add-ons will help you work more efficiently and create automated systems. I use a LOT of different add-ons for different situations. Here are some of my favorites:

Form Add-Ons:

  • Choice eliminator removes MC options from your form after they have been selected. Great for sign-ups, volunteer opportunities, and reservations.
  • Form Limiter will set limits on how long your form is available or how many responses a form will receive before it is turned off. Great for forms with deadlines.
  • Use Email Notification for Forms to send out email or mobile phone notifications when a new submission is received.

Sheet Add-ons

  • Autocrat is one of my personal favorites! I use Autocrat to generate documents based on form data (certificates, invoices, meeting agendas, etc)
  • Copy Down isn’t super exciting, but it’s very helpful! I use Copy Down to apply formulas to incoming form data to create automatic calculations.
  • FormMule is an email merge utility that you can use to send customized emails based on form responses. I use FormMule when I need to run calculations on my form data before sending out an email.
There are a LOT more add-ons, but those are some of my favorites!


4. Filter, Sort, and Pivot your Data!

We use Google Forms to collect data. Once someone submits a form, the information gets dumped into Google Sheets...and things get interesting!

A spreadsheet is an amazing tool for collecting and organizing information. Here are three things that you should know how to do in Google Sheets:


  • Sort - Sort a column in your spreadsheet to organize your data alphabetically or numerically. This is basic, but very useful!
  • Filter - Filter your sheet to isolate the information you want to see. For example, you might use the filter option to hide quiz scores for your first and third hour classes so that you can review the scores from second hour.
  • Pivot - A pivot table lets you look at your data from a different perspective. This is especially helpful with things like test scores or survey information. For example, you might “pivot” your data to see if the 8th grade students who had failing grades in math also struggled in their ELA courses.
Data analysis is super important topic. If you want to learn more, I recommend that you connect with Ben Collins, the smartest Google Sheets guy I know!


5. Autograde and lock your quizzes!

Google Forms has a special quiz mode that will auto-grade student choices!

Stop wasting your precious time hand-grading paper quizzes! Auto grade them!

Don't limit your quiz to traditional multiple choice questions! Here are a few ideas you might want to try:
  • πŸ–Ό Image Questions - insert and image of a map or equation and and then ask comprehension questions (great for math and science!)
  • 🎦 Video Questions - Add a short video to your quiz and then ask questions about the video content (great for world language!)
  • ✅ Check Box Questions - Use the checkbox question and have students select “all that apply.”
  • πŸ“ Matching Question - use the grid question type to set up a matching question.
Be creative... there are LOTS of possibilities.

You may have heard about the new LOCKED MODE for Google Forms.

I shared an early review a few months ago. When enabled, locked mode will prevent students from accessing other information during a quiz.

It's pretty awesome!



Locked mode is NOT available yet...but it should be very soon (March?)! Watch this video or read this blog post to see how it works!

Are you ready to become a Form Fanatic?

Each spring I teach a 5 week Google Forms masterclass. Join me for a deep dive into Google Forms!

I offered this course for the first time in the spring of 2018 and the feedback was outstanding:

"I was a casual user of Forms, but I was not using the data that I had collected to it's full potential. Now I am writing better Forms so my data is of higher quality and I am better able to analyze the results so I'm making decisions based on data...not just giving surveys." - Laura Foreback, middle school teacher
This course is perfect for classroom teachers, tech coaches, and school administrators!

Interested? Click here for details!

Thursday, April 12, 2018

Sharing Classroom Data with Sheets


There are some really interesting ways that classroom teachers can use Google Forms, Sheets, Slides, and Sites to share information. 

The best way to explain what I mean is to show you an example.

I created a classroom reading log to track the number of books that my class read.

Students fill out a Google Form each time they finish a book and that information is automatically published on our class website

Because forms, sheets, and sites are all connected, the class chart is immediately updated each time the form is submitted. Like magic! 

There are a few things going on behind the scenes that makes this system possible. 

Step 1: Collect data with a form

Using a form ensures the consistency of the data and makes it very easy for students to fill out. 

You can easily share your form in Google Classroom for easy access. 

Here's an example of my reading log form


Step 2: Collect & Calculate in Google Sheets

Each time the form is submitted, the data is logged automatically into a Google Sheet. 

That's great, but we need to perform a few simple calculations in order to track our class goal of reading 100 books and 10,000 pages. 

If you view the spreadsheet you will notice that for every form entry I add "1" to the "Book #" column. This allows me to add up all of the submissions to determine the total number of books that we have read. 

In order to make sure that my calculation is added for each new form submission I am using the Google sheet add-on "copy down" to copy my formula to all new submissions. 

If you look at the "class data" sheet you will see where I have entered target goal of 100 books and 10,000 pages as well as the current progress (added from the form responses) and our % of completion. 

All of these calculations were created using simple spreadsheet functions. 


πŸŽ₯ Need some help?  Watch this video on adding simple calculations into Forms

Step 3: Create your Charts


Now that I have collected the data and calculated my total, I can create graph. 

The graph was created from the "class data" sheet that summarizes all of the submissions. I only have two data points (books read and pages read), so this is a pretty easy chart to create. 

The chart editor in Google Sheets will walk you through the process. Just highlight your data, click on insert > Chart and edit as needed. 


For my book log I chose the "gauge" chart type. You could also chose a line graph, pie chart, etc.  

πŸŽ₯ Need some help? Watch this video on creating custom charts with Sheets!




Step 4: Embed / Share your Chart


Once you have created your chart you can share it in a variety of ways: 
Because each of these charts is connected back to the spreadsheet, as new form submissions come in, the chart will automatically update! 

πŸŽ₯ Need some help? Watch this video on publishing charts. 

Other Ideas:


Class reading logs aren't the only way that you could use this idea in your classroom or at your school. Here are a few other ways that displaying live data might be helpful: 
  • Track student absences
  • Track plant growth (or any lab data)
  • Track overall student performance
  • Track physical fitness (health class)
  • Track fundraising goals
  • Track team stats (turnovers, rebounds, assists, etc)

Make a copy!

Interested in setting this up for your school? I did all of the hard work for you! Click here to make a copy of everything you need!

Note: due to limitations with the new Google Sites, you won't be able to make a copy of my site. Setting up your own will only take a few minutes.

Want to become a Forms Master? 



I offer a 5-week online course called "Google Forms for Educators." This is one of the activities that I help you create during the course. If you are interested in more tips on using Forms and Sheets in the classroom head over to the course page and add your name to the wait list!

Tuesday, April 10, 2018

How to Create a Matching Question in Google Forms


You have probably used Google Forms to ask free response or multiple choice questions, but did you know that you can also create a matching question? 

Forms doesn't offer an obvious "matching" question type, but with a little creativity, you can make it work! 

The secret is to use the "grid" question type to set up a matching style question. 

Unfortunately the quiz feature available in Google Forms will not work with "grid" questions however you can use the Flubaroo add-on for Google Sheets to auto-grade quizzes with this type of question.

Tips:

  • Place your definitions in the row and use the columns for your terms. 
  • Enable "require a response for each row."
  • Make sure that you select the "limit to one response per column option" 
  • Enable "shuffle row order"
Watch this short video for some additional tips on creating a matching question with Google Forms.



This video is part of my online course "Google Forms for Educators." In this 5 week course I help educators use Google Forms to organize their classroom and create automated systems so that they can spend less time shuffling paper and more time connecting with students. Interested? Visit chrm.tech/forms for details!

Here's a live example of a matching question using Google Forms. 



The width of the embedded form is a bit too narrow to properly show all of the text. I recommend that you view the form here to get the full experience.

------------------------------------------------------

Are you ready to become a Form Fanatic?

Are you a Form Fanatic?Each spring I offer a 5 week Google Forms masterclass. Join me for a deep dive into Google Forms!

The feedback has been outstanding:
"I was a casual user of Forms, but I was not using the data that I had collected to it's full potential. Now I am writing better Forms so my data is of higher quality and I am better able to analyze the results so I'm making decisions based on data...not just giving surveys." - Laura Foreback, middle school teacher
This course is perfect for classroom teachers, tech coaches, and school administrators!

Interested? Visit Chrm.tech/forms for all the details!


Sunday, April 8, 2018

Google Forms: Set your Default Preferences

Google Forms: Set default preferences

I uncovered a helpful feature in Google Forms that I thought was worth sharing. You can change your default preferences! This is very handy for teachers who create a lot of quizzes using Forms.

The preference options include:
  • Make questions required by default
  • Set default point value for quiz questions
  • Turn on email collection by default


Are you ready to become a Form Fanatic?

Are you a Form Fanatic?Each spring I offer a 5 week Google Forms masterclass. Join me for a deep dive into Google Forms!

The feedback has been outstanding:
"I was a casual user of Forms, but I was not using the data that I had collected to it's full potential. Now I am writing better Forms so my data is of higher quality and I am better able to analyze the results so I'm making decisions based on data...not just giving surveys." - Laura Foreback, middle school teacher
This course is perfect for classroom teachers, tech coaches, and school administrators!

Interested? Visit Chrm.tech/forms for all the details!

Friday, March 16, 2018

30 Ways to use Google Forms in the Classroom (updated examples!)



Google Forms is one of my favorite classroom tools.

But here's the deal - most teachers aren't taking full advantage of what Google Forms has to offer!

You have probably used Forms to create a survey or give a quiz, but that's not all Forms can do!

Here are 30 different ways you can use Google Forms in your Classroom - with an example for each!


I also created a PDF version of this post with links, images, and an option to make a copy of each form. Click here and I'll send it to you via email!

1. Reading Quiz - Hold students responsible for reading assignments by giving a simple quiz. This example is based on Fahrenheit 451 in a high school English classroom and is configured to release the quiz score immediately after submitting the quiz.

2. Chromebook Quiz (with images) - This quiz uses images to test basic Chromebook literacy. It is set up so that the student immediately receives their score and can see which questions they got wrong.

3. Bell ringer / Do now activity - This morning math check in activity is completed by students first thing in the morning before the start of class. The form uses data validation to provide hints if the student is struggling to get the correct answer.

4. Mood Check-in - Students will have a difficult time learning if the arrive at school filled with worry and concern. This mood check in provides a safe space for students to share their current mood and concerns with you. By using a tool like Form Postman you can configure the form to send you an email if a student indicates a negative emotion.

5. Permission slips - Field trips are fun. Permissions slips are not. This form allows parents to digitally sign permission slips. In an effort to prevent students from completing their own permission slip a parent email address is required and a notification is sent to this email address using Form Postman.

Choice eliminator is used to remove student names from the drop-down list once a parent has given their permission. This makes it easy for a teacher to identify which students do not have a permission slip on file.

6. Book report generator - Writing reflectively is a key component of the common core standards. A book report is a tremendous way to help students practice reflective, informational writing, and to also encourage them to identify elements of literature such as genre, plot, and setting. As a bonus, they can share their writing with others!

This form provides a simple way for students to share their thoughts on a book that they have read. I am using a tool called AutoCrat to take the form submissions and turn it into a nicely formatted Google Doc which can be easily printed or shared electronically.

7. Lab Data Collection - Simplify data collection and analysis for your next lab activity! In this example, student submit their lab data through a Google Form which automatically updates the totals on the lab document.

Tim Welch set up a similar activity with a detailed video and written explanation.

8. Yearbook Photo Page - Google Forms has a file upload feature that you can use to collect digital files. In this example, teachers submit their favorite Bitmoji image for use in the school yearbook.

You can go even further by using AutoCrat to take the images and add them to Google Slide presentation ready for printing!

Jennifer Scott is using Google Slides to design her school yearbook. Check out how she uses this system in this video.

9. Certificate Creator - Creating certificates is a pretty common tasks in education. Whether honoring students for their academic or athletic achievement or documenting professional development activity. Forms is a convenient way to generate certificates.

This simple example collects your name and email address to generate a simple certificate in Google Docs which is emailed to you as a PDF.

10. Form to Lesson Plan - Use a Google Form to fill in your plans each week. This form is filled with checkbox and drop down fields to simplify submitting information.

Thanks to Amanda Dykes for sharing this example! Check out this guide to setting up and using this form!

11. Course Evaluation (with branching) - Good teachers seek feedback and constantly work to improve their course. This is the course evaluation form that I use to solicit feedback on my online courses. This form takes advantage of question branching; based on your answer to a question the form splits to ask additional follow up questions (i.e. indicating that you would like a sticker takes you to the address section).

12. Call for Speakers Form - If you help organize a conference or professional development day you can use Google Forms to collect session descriptions. This example is carefully designed to collect all of the information that is used to create the conference program with minimal editing.

13. Elementary reading Inventory - Use this form when evaluating the reading fluency of a student. Reading inventories are typically completed 2-3 times each year. This form makes it easy to collect store, and analyze collected data to observe student growth.

14. Idea / Opportunity Tracker - Record ideas when inspiration strikes! Add in your own categories and fields to make sorting and organizing your ideas easier. Use the reminder add-on for sheets to receive an email reminder of upcoming opportunities. I have this form saved as a bookmark for easy access.

15. Google Forms as a Rubric - Rubrics are the ideal method of evaluating project based learning. This Google Form makes it easy to complete an evaluation while you are reading a student paper or viewing their physical project. Use a tool like AutoCrat or FormMule to automatically send students a summary of your evaluation and comments.

Google Forms for Educators


16. Track Standards Based Grading - This simple Google Form simplifies the process of tracking standards-based grades using Google Sheets. This form is filled out by the teacher each time you introduce a new assignment to your students. Once submitted, you can view and modify student grades through Sheets.

Watch this video for more insights on how to setup and use this system in your classroom!
Thanks to Stephanie Howell for sharing this example!

17. Parent Teacher Conference Sign Up - Coordinating conferences with parents is a difficult administrative task. This Google Form collects the necessary information and displays the available time slots. By using the Choice Eliminator add-on time slots are automatically removed from the form once selected, minimizing the chance of double booking. The FormMule add-on automatically sends an email with conference information.

18. Discipline referrals - Quick action is important when dealing with student discipline issues. Google Forms provides an easy way for teachers to submit incident reports which can immediately be routed to the appropriate administrator for follow up. Because Form data is pushed to Google Sheets, administrators can add additional comments and use a tool like AutoCrat to generate a discipline referral documents.

19. Volunteer Registration - Coordinating volunteers is a lot of work! Google Forms can help organize and coordinate volunteer positions. By using a tool called “choice eliminator” you can automatically remove volunteer opportunities after they have been filled.

20. Parent Contact form - The parent contact information that schools have on file is frequently incomplete or out of date. During back to school night I provide parents and opportunity to share their contact information with me so that I can keep them up to date on the progress of their student. This is also a great time to ask if the parent is interested in receiving Google Classroom updates.

21. Engagement tracker - Are your students engaged in classroom learning on a daily basis? Anecdotal observations frequently fall short when you are tracking engagement of 25 or more students. This simple form makes it easy to quickly scan your classroom and identify students who are engaged in the learning process. Over time, the summary of responses will reveal which students are regularly engaged, allowing you to identify opportunities to improve instruction and intervene with students who are frequently disengaged.

22. Behavior logs - This form was created for a school that adopted the Antecedent - Behavior - Consequence (ABC) discipline model. The form allows a teacher to make quick observations using their mobile phone which they can review, modify, and update during their planning period.

23. Parent contact log - This is a simple form to record conversations with parents and guardians. Veteran teachers understand the importance of documenting classroom communication to resolve conflicts and comply with IEP requirements.

24. Student progress tracker - When working on a long-term assignment such as a research paper, tracking student progress and understanding what each student is working can be challenging. Ask your students to complete this form each time they finish a component of their project. This will give you a snapshot of what students are working on.

This form has been configured to automatically collect user email address and limit to one response. After submitting the form the first time, the student will be prompted to “edit your response” rather than submitting the form a second time. This allow them to update their progress so that the form response data is accurate.

25. LIVE Reading log - Keep track of how many books and pages your class (or school) has read by taking advantage of the LIVE chart and graph feature of Google Sheets.
  • Have students log their reading using a Google form (like this)
  • The data that is collected feeds into a Google Sheet (like this)
  • Create a chart that tracks pages and books read. (like this)
Embed the chart into a Document, Presentation, or Google Site and watch it grow!

26. Classroom Observations - School administrators can create a standardized and transparent observation system with Google Forms. This Form includes all of the agreed upon observation criteria which can be completed on a mobile phone or tablet during the walk through. This system removes the guesswork from observations. By using a tool like FormMule the administrator can provide a copy of the observation to the teacher immediately upon submitting the form.

27. Kindergarten Registration - Google Forms is a helpful tool for collecting information on incoming Kindergartners. This form is filled out by teachers after interviewing new students. After submitting the form, a summary document is generated by AutoCrat which is accessible to the entire grade level team and school administrators.

28. Digital Escape Room - Google Forms can be used to create a digital puzzle, similar to an escape room or BreakoutEDU box. This example example was created for a teacher conference. Forms like this are accompanied documents, links, videos, etc which contain the answers to the riddles. Escape forms like this take advantage of page breaks and data validation to block progress until the correct answer is submitted.

29. Elementary Math Quiz - This simple math quiz helps first grade students practice basic math skills and the use of technology in the classroom.  This example places each question in its own section so that students can only see one question at a time. Images are used extensively to reduce the reading complexity.

30. Digital CLUE - Technology Coach Stephanie Howell from Pickerington, Ohio created a version of  CLUE using Google Forms! Students answer content questions to reveal clues that can be used to identify a suspect, location, and method to solve a classroom mystery.

Watch this detailed video to make your own version of CLUE using Google Forms!

I hope I have been able to inspire you with what you can accomplish with forms! I would love to help you dig into creating Forms for your classroom.


Want to design better forms?

Each spring I teach a 5 week course via Google Classroom for teachers like you! You can get the details and find out the next time I'm offering the course by visiting chrm.tech/forms.




Wednesday, March 14, 2018

Unlock the Power of Google Forms for your Classroom!


Google Forms is one of my favorite, and most frequently used tools. I've blogged about it quite a few times over the past few years: 

You have probably created a survey or quiz using Forms. That's great! I would love to help you unlock the full potential of Google Forms in your classroom. 

Google Forms can help you organize, streamline, and automate classroom tasks so that you can spend your time and energy connecting with your students. If you are sick of pushing paper around and spending time on procedural work like checking in homework assignments, scheduling parent teacher conferences, or collecting data for IEPs, Forms can help! 

Starting April 15, 2018 I will be leading a 5 week master course on Google Forms through Google Classroom. 


If you've tinkered with forms in the past, this course is for you! I will take you from tinker to expert in 5 weeks! 

Here's what I have planned: 

Week 1: Form Building Blocks

During our first week we are going to explore the "building blocks" of forms - question types, data validation, add-ons, summary page, multimedia options, sharing and notification settings. 

During week 1 you will also identify areas of your classroom that could be improved through Forms so that we can build them later in the course. 

Week 2: Forms for Assessment

Google Forms is a great tool for assessment. In week 2 you will learn about using Forms for assessment and build a quiz for your classroom. We will go beyond multiple choice questions and look at multimedia questions, free response, reading prompts, matching, and more.  

Week 3: Forms for Record Keeping

Week 2 is devoted to helping your organize classroom record keeping. You will build a form to track lunch counts, attendance, on/off task behavior, hall passes, or whatever you want! We will also spend some time looking at the Forms summary of responses to organize and analyze data. 

Week 4: Forms for Automation

Google Forms + Sheets is a powerful combination that can be used to create automated sequences. During week 4 you will learn how to use Forms + Autocrat to create certificates, book reports, research projects, meeting agendas, or other similar documents. 

Week 5: Data Week

Collecting information is easy; understanding what that information means and using it to take action is hard! During week we will analyze the data collected in our forms using charts, graphs, and filters.


I will work with you throughout the course and will answer questions and provide personal feedback on a weekly basis. My goal for this course is to help you SAVE TIME by eliminating time-consuming processes. By streamlining and automating common, repetitive tasks you will have MORE time to connect with your students. 

The cost for this 5 week course is $99. 

Interested? You can register here


Friday, May 5, 2017

10 Tips for Organizing Google Drive


10 Tips for Organizing Google Drive

Google Drive has become one of my essential tools. All my files are in Google Drive. With unlimited storage and easy access from any device, I put everything in Drive. At first, this was no big deal. But after about five years of heavy drive usage, it became more difficult to find and manage my files. 

Here are my top 10 tips for organizing your Drive account.


1. Use folders


Your files are like people. Folders are like houses. Make sure that everyone has a home! The goal is to eliminate any "homeless" files.

Test it out: click on "my drive." What do you see - files or folders? Move any "homeless" files into folders. 


Put every file in a folder


Tip: Don't be shy about how many folders you create. I have folder "trees" that are 7+ deep. If you want your files to be in a specific order, add a number prefix.

Create sub folders to organize your files.

Tip: if you have a LOT of homeless files to organize, open the file tree on the left and drag and drop you files into folders. You can also hold down the ctrl key to select multiple files at the same time.

2. Name your files carefully

Generic files names were okay when they were only your files. But Google Drive is for sharing, and when you share a file called "notes," you aren't doing your friends any favors. Be super detailed and specific with your file names.

  • Bad: Lesson Plan
  • Good: Week 3 Lesson Plan | John Sowash, 2017
  • Bad: Meeting Agenda
  • Good: Curriculum Meeting Agenda, March 21, 2017

Tip: you can use hashtags and special characters to draw attention to special files. I use [template] to identify documents that I copy frequently.

Name your Google Drive files carefully

3. Share folders not files


Sharing individual files is fine if you are sharing with a small number of people on an infrequent basis. But most of us work in teams, groups or committees and share and pass files around. This is a prime use for a shared folder.

When you share a folder, no one has to remember everyone on the team. The folder already knows. Dump your file in and you're done!

Tip: I recommend sharing folders as "view only." You can make any file within the folder editable, but you don't want everything editable by default.


Tip: I recommend sharing folders as "view only." You can make any file within the folder editable, but you probably don't want everything editable by default.

Team Drive

Your team could benefit from using a TEAM Drive folder. This feature became available in the spring of 2017 and offers new features for team sharing:
  • The TEAM owns the files, not a person (important when team members leave) 
  • Team Drive files do not show up in shared with me 
  • Team Drive has a very different visual design to set it apart from a shared folder. 
  • Team Drives can be centrally created and managed through the Google Admin Console.
You can learn more about Team Drive here.


Google Groups


When sharing with large groups of people, set up a Google Group and share the resources with the group, not individuals. You can manage access to resources simply by adding / removing individuals from the group. No need to re-share files with people who were recently added to the group.

Google Groups are important when sharing files with more than 200 people (like all students). You can manage access to resources simply by adding / removing individuals from the group. No need to re-share files with people who were recently added to the group.

share with google groups


4. Use shift + z to add files to a folder

Tip #3 creates a problem: "How do you add a file to the shared folder and keep it in your files"? The answer is "shift + z." Use this shortcut to ADD a file to several folders. Now you can keep files organized using your personal system AND put it in a shared folder.

Try it: click on a file in drive and press "shift + z." It's magic!

Note: you can’t use shift + z to add a file to a team Drive, only a traditional folder.

don't duplicate files, add them!

5. Dealing with "shared with me."

It's hard enough organizing your own stuff. With Google Drive, you also need to organize shared files! Going into "shared with me" is enough to trigger a panic attack. Here's how to handle the clutter:

If you see something you want, drag it into "my drive" and place it into a folder. You are not making a copy, you are organizing the original into your personal system. Now that you have added it into a folder, you don't need to find it in shared with me.

Ignore any file in shared with me that you don't need. Don't do anything. These files will will "disappear" eventually. Yes, you can "remove" a file, but if your goal is to empty out "shared with me" it is going to take you a LONG time.

Do not treat "shared with me" like email. It is NOT your responsibility to visit and empty out shared files every day. It is the responsibility of the person who shares a file with you to explain why they are sharing the file.

If you are using Google Classroom you are going to see a LOT of files in shared with me that come from Classroom. Ignore them. To view or manage these files, visit Google Classroom.

6. Purge old files

Google Drive has unlimited storage (for those using G Suite for Education). This is a blessing and a curse. Over time, clutter increases. Take a few minutes and delete any duplicate or outdated files. This make is much easier to find what you are looking for!

Create an archive folder for files you can't delete, but don't access use. Hiding old content cuts down on the number of folders you need to sort through to find what you are looking for.

Create an archive folder in drive.

7. Upload with care

If you are a Microsoft Office user, you probably know that you can upload and convert your existing MS Office files into Drive. While it might be tempting to use the "folder upload" button to upload your entire my documents folder, resist the urge!

Upload existing office files to Drive.

If you are a Microsoft Office user, you know that you can upload your existing MS Office files into Drive. Resist the urge to upload and convert your entire my documents folder.

If your documents folder is anything like mine, it's a mess. I had hundreds of files that I had not used in years. Why upload them to Drive? Instead, adopt the Drive migration challenge:
  1. Each day, upload only the files that you use. 
  2. If you need to create a new file, create it in Drive. 
  3. After 1 year, throw whatever is left on to an external hard drive and toss in a drawer.

9. Color your folders


Add color to your most frequently used folders to make them easy to find. Right click on a folder and look for the "color" option.
add color to your drive folders.

8. Use emoji πŸ˜€

If color isn't enough for you, you can add emoji to your folder names. Install Emoji for Chrome and add your favorite emoji into your folder names!

Tip: If you add your emoji at the front of the folder name it will move to the top of your list.
add emoji to your drive folders

10. Use Google Keep

Convert a Keep note to Google Docs


Need somewhere to jot a quick note? Making a grocery list? Trying to keep track of your to-do list? This is a job for Google Keep, not Google Docs!


Google Keep is great for all of your digital odds-n-ends. Putting these items in Keep reduces clutter in your Drive account. Need to move a Keep note into Drive? No problem! You can quickly convert an entire note to a Google Doc!


Google Keep and Docs are now integrated!