Wednesday, October 12, 2016

Equation Balancing MEGA PRACTICE

Looking to practice some equation balancing? I've got a mega-sheet of 214 practice equations on it:
https://docs.google.com/document/u/1/d/1v52Nyx6o00ABjoISuZHLujTHJGbqAriGw4-9LhqXbhM/pub

Looks pretty lame, right? No answers to any of the balancing equations? Highlight the whole line and the coefficients magically pop out (use Ctrl-A to highlight the whole page) Ok, its not MAGIC, per se, but still cool.

Here's how I got it to work - when you publish a Google Doc, you can't change the color of the background. It always just goes to a white page. HOWEVER, if you create a table, you can set the background of the table. So I set the coefficients to be the same color as the background, so they are hidden until you highlight it.

The REAL fun was selecting every single coefficient at the same time with a regular expression in Word and then exporting it to Google Docs, but I'll save that for anyone who cares. :)

Google Sheets 101

So last year the website Curious.com contracted me to make a series of videos for them on Google Sheets. The 1-year exclusivity ended, and the videos are now able to be shared with a wider audience on YouTube. If you can, however, I would recommend taking the lessons on Curious.com, since I wrote assessments and included attachments on there that cannot be put into YouTube.

If you are looking to get started (or get proficient) on Google Sheets, here is my Google Sheets 101 series of videos:

  1. Creating / Saving / Sharing Google Spreadsheets
  2. Formatting rows & columns
  3. Formatting text and cells
  4. Formatting & viewing spreadsheet
  5. Data
  6. Data Formatting
  7. Data Viewing
  8. Collaborative Tools
  9. Calculations with Google Sheets and Cell References
  10. Cell Ranges
  11. Spreadsheet Functions
  12. Absolute ("locked") references
  13. References