Wednesday, April 18, 2018

Creating Macros in Google Sheets

What in the world is a macro?  A macro allows you to automate repetitive tasks such as formatting text, change column settings, etc in a spreadsheet.  You can simply record the procedures once and then play the macro anytime you need to reapply it.  Here is the procedure.

  1. Click Tools>Macros>Record Macros.

  2. Complete any formatting you want such as making text bold, changing fonts, adding labels, etc.
  3. Click Save.
  4. When you need to run the macro go back to Tools>Macros and select the macro.

Google Sheets Adds the Checkbox Feature

The checkbox people should be happy. Google is rolling out a checkbox feature in Google Sheets.  You should start seeing it appear in the coming week.  Take a look below.

Thursday, March 29, 2018

Track Writing Growth with WriQ

Are you looking for a great tool that helps your students reach their writing potential? Have you checked out the Google Doc add-on called WriQ? You can learn more on this site. . Follow these steps to get it set up.

  1. Installed the WriQ add-on-
  2. Open a document your students have typed in Google Docs
  3. Click the Add-on menu>WriQ>Show WriQ.
  4. After setting up your account select the Main Writer, Grade, and Genre.
  5. Click Score this Document.
  6. Review the document as needed and then click Next.
  7. Mark the rubric and click Save.
  8. Type feedback and click Confirm.
  9. Click Go to Dashboard to learn more.