[E-Book] Everything you wanted to know about

Google Apps for Education



Fill out the form to download your free E-Book




Google Apps for Education are a phenomenal free resource for schools. They’re powerful. They’re intuitive. They’re flexible. They offer unique collaboration opportunities for classrooms.


When we made Chalkup, we prioritized seamless integration with Google Drive so that educators could continue to use these powerful free tools, layering in discussions, rubrics, flashcards, and time management tools through the Chalkup platform.


We quickly learned how many of our users were huge Google Apps nerds like us. (I mean this as the ultimate compliment.)


Over the last year we’ve been sharing our favorite Google tips from around the Chalkup office. We’ve covered shortcuts that have saved us time, interesting formulas for Google Sheets, and even Chromebook tips to benefit classrooms that have gone all in on Google’s laptop. And what an awesome response. We we thrilled that everyone enjoyed these resources; I love getting stories from instructors who used our tips in their own workflow.


Working Faster: Google Drive Shortcuts

Navigating in Drive

/: Search Drive

c: Create menu

a: More actions menu

f: Current folder actions menu

r: Sort menu

t: Settings menu

g then l: Go to items view

v: Switch between grid and list in items view

i: Show or hide activity pane

d: Show or hide details pane

g then d: Details pane

g then t: Go to top of application (Google bar)

g then u: Go to upload status

g then a: Go to download status


More in our free e-book


Editing Smarter: Google Docs

Doc Basics

  • You can find a doc’s revision history under the “File” tab.
    • Similarly - click any file (single-click) and then click the “i” in the right corner to view the activity history of a doc.
  • Track changes by navigating to the “editing” button on your toolbar and selecting “suggesting” instead of “editing” mode.
  • Docs has citation support, accessible via the research option under “Tools.” This pane has a built in search. At this point, Google gives you the option to insert a link or citation.

More in our free e-book


Organizing Better: Google Sheets

Data Validation

  • Collaborating is the best. But sometimes there are data points you’d like to keep formatted in a specific way. Use Google Sheets Data Validation in those cases; this tool will allow you to restrict values of certain cells, force collaborators to select values from a list, or warn them when they’ve entered something that doesn’t fit the scheme you have in place.
  • To use data validation on a set of cells, select “data” and then “ validation.” You’ll be prompted to include instructions that users will see when they hover over a cell you’ve validated.
  • The validation menu will also allow you to lock in the formula a collaborator uses in a cell, a date range, or custom text options. A tricky way to keep your data squeaky clean.


More in our free e-book


Presenting SweeterGoogle Slides

Design Hacks

  • Media. If you’d like to add video to your Google presentation, navigate to “insert” and then “video.” Now we’re cooking. You’ll be prompted to drop in a url and then size your video once it appears on your slide.
  • Size Em Up. You can now change the sizes of your slides. Just make sure you scope out the type of projector you’ll be using so your chosen size fits your screen/projector/IT setup.
  • Image Masking. The time may come when you’d like to change the shape of an image embedded on your slide. For example, maybe you want your headshot to appear in a circle, not a rectangle, like the original image. Masking is how we’re going to do that.


More in our free e-book


Connecting Seamlessly: Chromebooks

Chromebook Basics

  • You Can Still Have a Home Icon: You can get a “home” icon on your omnibar by navigating to “settings” and then “appearance.” You’ll then select “show home.”
  • Are You Pinning Tabs? You Should Be. Right click a tab and then select “pin tab.” Next time you open Chrome, your pinned tabs will automatically open. It’s beautiful.
  • Your Chromebook is a Big Ol’ Calculator. Using a Chromebook now? Just type a math command into the omnibar (ex: 10*10). We’ll wait.
  • Lock it Down. You can lock down your Chromebook screen before stepping away from your desk. Just press Ctrl+Shift+L.

  • Create Shortcuts. Really simple. Head to your apps, right click the one you want a shortcut for, and click “create.”


More in our free e-book