Reordering Sheets…

Today I was asked how to reorder sheets from within a Google Spreadsheet. Google Spreadsheets is one of my favorite collaboration tools. It provides the capabilities for assigning different sheets to individual students or a collaborative group. Sheets can become out of order when collaborators use one spreadsheet. No worries! It is easy to drag the sheet into an alpha or numerical order. Just click down on the sheets tab and drag to the right or left to reorder sheets.

Reorder Sheets in a Spreadsheet - drag to the left or right
Advertisements

Changing Bullet Defaults in Google Slides

Love when users help community question transforms into a helpful tutorial. Earlier this afternoon a Google Slides user inquired about changing bullet defaults. Changing bullet defaults can be a timesaver for both graphic designers as well as students. Sometimes it is helpful to guide others and show them how to use timesaving fun tools for designing purposes. Following is the video tutorial I ended up creating to help the Google Slides user.

Quick Access Turn It On In Google Drive

In Google Drive, there is a setting called Quick Access. This setting provides quick access to frequently used files. It is one of those personal timesaving features. Thanks to quick access teachers and students will have up to four regularly used files right under their fingertips.

Easy Tips for Turning Off Google Forms Assessment

Recently a teacher came to the Google Docs Help Forums to learn how to turn Google Forms Assessments off. The teacher was afraid students would copy the Assessment’s URL to share with friends. I was glad when Lance a Google Doc’s Product Expert friend reached out to me for help. The teacher learned two simple steps for maintaining assessment confidentiality.

First Make a Copy of Testing Template

  1. Open the Google Forms Assessment
  2. Click More Settings (3 Vertical Dots)
  3. Select “Make a Copy”

BENEFITS:

  • Making a Copy allows the user to make a blank question bank template to be used for future assessments.
  • Allows teachers to easily share individual forms with each class.
    • Copies provide more control for turning an assessment on & off.
      • Teacher has a choice of turning off one class or all

Turn Forms Assessment On & Off

  1. Open the Google Forms Assessment
  2. Click Responses Tab
  3. Toggle “Accepting Responses” to Left for OFF
  4. Toggle “Accepting Responses” to Right to Turn ON

BENEFITS:

  • Teacher may turn Forms Assessment Off after Assessment is Completed
  • If Student was absent teacher may turn the assessment on.
  • Provides control for collecting deadline information

Easily Ungroup Shared Calendars

In the Google Help Forums, I spotted the following question. “If there was a tool for ungrouping and grouping shared Google Calendars?” Naturally, my reply was you can group shared calendars by checking them off individually. However, there is a tool for users to ungroup all at once by using the following steps.

  1. Open Google Calendar
  2. Click Option Settings (3 vertical dots) for the Calendar to leave open
  3. Select “Display this Only”

I suggested to the user about grouping calendars together and embedding into a New Google Site. My idea would provide a simple method for viewing several team member calendars at once.

You may find the following Google Help Center resources beneficial:

  1. CALENDAR: Add a Google Calendar to your Website
  2. NEW SITES:Add Google Files Video & More
    • Scroll to Section: Add HTML, CSS, or JavaScript code to your site

If you would like more detailed instruction please leave a comment.