Google Docs – 100 TIps for Teachers and Students

This is from a Google Doc [naturally]. The links in each tip takes you to a web page with more info.


 

100 Great Google Docs Tips for Students & Educators

Students and educators at online universities 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.

  1. Ctrl+Home: Get back to the top of your doc.

  2. Ctrl+B: Bold.

  3. Ctrl+E: Center alignment

  4. Ctrl+L: Back to left alignment.

  5. Ctrl+M: Insert comment.

  6. Ctrl+H: Replace.

  7. Ctrl+End: Go to last cell in data region.

  8. Ctrl+Home: Go to first cell in data region.

  9. Shift+spacebar: Select entire row.

  10. Ctrl+Z: Undo.

  11. Ctrl+Y: Redo.

  12. Ctrl+spacebar: Select entire column.

  13. Ctrl+J: Full justify.

  14. Ctrl+Shift+L: Bulleted list.

  15. Ctrl+Shift+Space: Insert non-breaking space.

  16. Page Down: Move down one screen.

  17. Ctrl+K: Inset link.

  18. Ctrl+Shift+F: Full screen.

  19. Page Up: Move up one screen.

  20. Ctrl+Space: Remove formatting.

  21. Ctrl+: Heading style 1. Change the “1” to any number 1-6 and get the corresponding header.

 Productivity Hacks

These hacks will make your Google Docs experience even more efficient and streamlined.

  1. Templates: Use Docs’ 300 templates to get started on different types of documents.

  2. Work offline: View and edit documents even when you don’t have access to an Internet connection.

  3. Create shortcuts: Create shortcuts and bookmarks for new documents, Google Docs home and more frequently visited pages.

  4. Save as different file types: Instead of converting docs to different file types, you can simply change it to HTML, RTF, PDG, ODT and more whenever you save it.

 Features and Tools

Make use of features and tools like Docs Translation or CSS Editing to customize your docs and make them work for you.

  1. Polyline: Draw shapes and lines in Google docs to make graphs, images and examples.

  2. Docs Translation: Find the docs translator under Tools.

  3. Snap to Guides: With this Edit feature, you can line up shapes in your doc automatically.

  4. Reference tools: Google docs comes with access to a dictionary, thesaurus and encyclopedia that you can use within the document.

  5. CSS Editing: Change the display of your doc by manually plugging in your CSS text.

  6. HTML tags: Docs supports, or partially supports, some HTML tags, shown here.

 Collaboration

One of the best things about Google Docs is that you get to share and collaborate on projects with others. Learn how to make the most of these features here.

  1. Shared foldersCreate shared folders and drag-and-drop items from other folders.

  2. Privacy: You can choose to have documents published publicly or privately.

  3. Share, don’t email: Instead of emailing docs back and forth, type in email addresses of people you’d like to share your Google document with, and they’ll be sent an editable, web copy.

  4. Make changes at the same time: You and your classmates can log into the same document at the same time to make edits.

  5. Share a folder: Share entire groups of documents saved in a single file with coworkers and students.

  6. Invite mailing lists as collaborators: You can share a document with all members of your email mailing lists with this function.

  7. Make a presentation in real-time: Invite others to view a presentation you’ve made as you see it too.

  8. Data validation: Make sure everyone is entering data into the spreadsheet the same way by controlling data validation settings.

  9. Allow people to edit without signing in: This means anyone, even if they don’t have a Google account, can sign in and edit your piece.

  10. Remove collaborators: If you want to take someone off a project, click None next to the name of the person you want to remove.

  11. Forum: If you get stuck with a docs problem, you can head over to the forums and find help from other users.

  12. Change ownership: Switch ownership of Google docs as project leaders change.

Files, Folders and Filters

Find out how to use files, folders and filters for optimum organization and a clearer display.

  1. View and unviewed: You can mark new shared documents as viewed or unviewed, like an inbox.

  2. Create subfolders: Make subfolders for better organization. Create, then choose to move it wherever you want.

  3. Drag-and-drop folders: Drag-and-drop folders and docs to spreadsheets, documents and presentations.

  4. Tag: Tag items with certain keywords instead of going to the trouble of moving them to a folder.

  5. Star: You can also star documents, like you would in Gmail.

  6. Upload multiple files: Click “select more files” to upload multiple files in Google Docs.

Organization

These hacks are designed to organize your Google Docs, from starting a new assignment to sharing and publishing.

  1. Color code folders: Color-code the names of folders.

  2. Insert bookmarks: Insert a link to another part of your document, like in a table of contents.

  3. Zip archive: Export Google docs, spreadsheets and presentations in a single ZIP archive.

  4. Block quote: Use this setting to automatically indent and set aside a long quote in your document.

  5. Minimize: Star only the docs you want to see at one time, and minimize everything in the left pane for a minimized view.

  6. Annotate with footnotes: Insert annotations as footnotes to your document easily.

  7. Preview templates: Preview a template before committing to it.

 Edits

With these editing tools, you’ll track comments, save editing history and more.

  1. Color-code comments: You can color-code live comments in Google Docs.

  2. Revision pruning: When you have too many revisions, they’ll automatically collapse, or prune, but can still be viewed in revision history.

  3. Track edits and changes: In Google Docs you can go back and forth between edits that you or collaborators made.

  4. Revision history: View older versions of your document, and choose to “revert to this one” if you choose.

  5. Find and replace: This version of find and replace lets you match cases, match whole words, find previous words, and more.

 Synchronization

Make your Google Docs work with other tools too.

  1. Preview docs in Gmail: You can preview Google docs attachments in Gmail.

  2. Google Finance: Enter information from Google Finance into spreadsheets with this formula Syntax: =GoogleFinance(“symbol”; “attribute”).

  3. Sync with Office Documents: With Syncplicity, you can sync Google Docs with Microsoft Office.

  4. Sync with your server: To work offline, your documents will have to be synced to your server.

  5. Google Mobile: Use Google Mobile to access docs on your phone.

Search

Google Docs uses Google search to find documents and more.

  1. Search PDFs: There’s a search box in the upper right corner of your PDF document.

  2. Search for docs using keywords: If you don’t remember the title of a doc, type in keywords from the document instead.

  3. Advanced search: Find documents by selecting who you’ve shared with, keyword, title, and more.

  4. Search the web: Highlight a word and search the web for matching websites and images.

  5. Search operators: Search operators will help you find starred, hidden and other documents quickly. Example: [is:starred]

 Presentations

Learn how to make and present projects with videos, images and more.

  1. Embed a presentation in a website: Add your class presentations to your website or blog by publishing and pasting the HTML code that is revealed.

  2. Insert tables: You can insert tables into Google Presentations, too.

  3. Sequentially reveal objects on a slide: Bullets and text boxes will be revealed one at a time if you select this option.

  4. Custom colors: You can choose custom colors to add to your presentation.

  5. Hide the gray bar: In presentation view, click on the icon in the upper-right corner of the gray bar at the bottom of your screen to make it disappear.

  6. Chat: Chat with your audience in view presentation mode. You’ll need Adobe Flash Player 8 or above.

  7. Insert videos: You can add videos to your presentation, minimize and maximize it, and move it around your screen.

  8. Hide chat: Keep everyone quiet during your presentation by clicking the left side of the chat module.

  9. Organize slides: You can reorder slides, make duplicate slides, and insert new slides wherever you want.

  10. Replace image and video placeholders: Depending on your presentation’s template, you can replace placeholders with an actual image or video.

 Spreadsheets

With spreadsheets, you can create forms, reports, invoices, portfolios, and other docs that solve problems, save email addresses and more.

  1. Google search inside your spreadsheet: Highlight a word, right click, and select Search the web.

  2. Print as PDF: Choose to print your spreadsheet as a PDF if you want all formatting to stay intact.

  3. Live lookup: Use the following formula in a cell to ask Google to look up quantitative information: Syntax: =GoogleLookup(“entity”; “attribute”).

  4. Roman function: Have numbers displayed as Roman numerals with this formula =ROMAN(number, form).

  5. Create forms: Google Spreadsheets has various templates for forms you can create and have people fill out.

  6. Edit forms: Add section headers to make it easier to divide up forms and make them easier to fill out.

  7. List view: Select list view to load spreadsheets faster, view from your mobile phone and access basic editing features.

  8. Protect sheet: Select Protect sheet to prevent certain collaborators from editing it.

  9. Automatically add email addresses: If you have Google Apps, the email addresses of the people who fill out the form will automatically be saved.

  10. Scientific notation: Adjust spreadsheets so that cells display in scientific notation.

  11. Solve: Maximize and minimize values when you solve problems in your cells.

  12. Add and delete comments: You can add, delete and edit comments in spreadsheets too.

  13. Freeze columns and rows: Freeze rows and columns to stop editing.

 Tasks

These tasks, from printing to tracking tournaments, are examples of other ways you can use Google Docs.

  1. Print as a webpage: You can print your doc so that it displays as a web page.

  2. Insert mathematical equations: Insert Equation makes an equation editor dialog box appear to add an equation to your doc.

  3. GoogleTournament: Create brackets, and let Google automatically update data according to the Men’s and Women’s NCAA Division I Basketball Championship.

  4. Enable offline access: You can install offline access for Google Docs to edit existing documents anywhere.

  5. Track analytics: Track visits to published documents.

  6. Update posts: You can republish posts that are already on your web page if you want to make edits and support an updated version.

iMovie 11 How-to

Click here for the PDF version

The Setup

  1. Collect all your parts in one place – on the desktop, your documents folder, wherever – I suggest inside a folder. That makes it easier to grab the parts.
  2. Fire up iTunes. Drag any audio files into the iTunes window.
    1. You could create a new playlist and put them there – useful if there are a ton of tunes already in iTunes.
  3. OPTIONAL → Fire up iPhoto. Place any still shots there, into a new event.
  4. Fire up iMovie.
  5. Start a new project.
  6. Collect the clips into an Event
    1. You are supposed to be able to drag-n-drop, but I’ve had trouble getting it to work.
    2. File → Import → Movies
      1. select the file.
      2. Place the FIRST one into a new event.
        The rest of them, place into that same newly created event.
  7. So you have movie clip in an event, external audio in iTunes, and still shots in a folder [or in iPhoto].

Start Assembling the Project

  1. In the Event pane, drag on a clip to highlight the part you want next.
  2. Hit the E key on the keyboard. That places the clip in the Project.
  3. Keep doing this in the order you want the clips to appear.
  4. You can drag clips into a new order if you change your mind.
  5. TO ADD PHOTOS/STILL SHOTS: Drag the file from your folder directly into the Project Pane [the part where the clips are being ordered].
  6. TO ADD PHOTOS FROM iPHOTO: Press Command-2on the keyboard to show the Photo browser. Click a photo and drag it to the Project Pane.
  7. TO ADD PHOTO FROM YOUR FOLDER: Drag the file into the project pane.

Make Changes

  1. Drag clips into a different order.
  2. Add transitions → Command-4 to show the transition browser. Pick one, drag it between the 2 clips where you want the transition used.
  3. Add Titles → Command-3. Drag a title ONTO a clip to add it to a clip. Drag it to a BLANK SPOT of the project pane to add it to the end of the list [i.e. titles will be on a black screen]. Then you can drag it to the desired location.
  4. You can generally click and drag anything to any other location. Click ON a clip, then click the GEAR icon to make changes [like make the audio louder, change the start/stop points, etc.]

Finish – when everything is more-or-less perfect:

  1. IF you have a lot of hand-held video [the camera was just held in your hands, and so it moves around], you can select File → Analyze Video → Stabilization. That often make the video less jerky.
  2. File menu → Finalize [this can take a while. Go for a walk to relieve stress.]

Export – now where does it go?

  1. Morning Announcements – as I type this, we are still experimenting with the correct settings. Look for an update on http://tech2.mountdesales.net for the latest info.
  2. Share → iTunes
    1. File will be located inside the folder Music → iTunes → iTunes media → Home Movies
  3. Share → Export
    1. You can select the location and sometimes the “size” of the final project. It’s all checkboxes. If you have an option, I suggest selecting the biggest [i.e. best quality] option
  4. Share → Export using Quicktime
    1. Gives you the greatest number of options. You can select the final size, frame rate, video and audio codecs to use, etc.
    2. Which settings to use will take some experimentation. I like exporting three or four ways and seeing which works for what I’m trying to do.
    3. THEN write those settings down somewhere!

 

screen3

screen1

screen4

screen2

When you have a guest on campus and they need wireless access

The details will vary depending on what device you use, but here is the overview:

  1. Set your device to join the network MDS-public
  2. In the Login screen that appears, click “Create Account
  3. Fill in the information, and then you’ll be allowed on the network. It’s a temporary account that will expire after some time.

If you don’t see the login screen after connecting:

  1. Try to get on the web. Your browser should automatically go to the account screen.
  2. Windows 7 [and maybe others] has a little dialog box that pops up after you try to connect, down on the bottom right, that says something like “more info may be needed – click here“. So click there, your default web browser will pop up, and you’ll be taken to the login screen.

Notes, Tips, Hints, & Answers