Thursday, March 9, 2017

Tech Tip: Google Sheets

Google Sheets image.


Google Sheets is the G Suite's version of a spreadsheet.   

Spreadsheets are an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.  In MS office, Spreadsheets are created in Excel.  Most formulas that work in Excel, also work in Sheets.

Here is a simple tutorial of some basic functions, in under 5 minutes.


   

Thursday, March 2, 2017

Teaching new Tricks with YouTube LIVE for Professional Development

Teaching tricks.


I have a loveable little dog.  Her name is Molly.  It takes her a bit to get something, but once she gets it... she knows it.  She doesn't do tricks, but she sits and stays. She is a good dog.
Molly wearing glasses
I get a treat after this, right?
Well, as a Technology Integrator, I have been trying to find ways to teach my teachers 'computer tricks'.  I am new to my school this year, but I feel like I am getting there.  Winter is nearly over, so new doesn't cut it anymore. The schedule at my school is a bit difficult to meet with many groups on a regular basis, and my teachers are busy.  And asking them to attend a training is difficult.


So, I started using YouTube LIVE.  I have been planning Professional Development sessions, and broadcasting a live version on Tuesday afternoons, which I have been calling 'Tech Tuesdays in the 803'.  I use a Google Site to promote, send the link to the live stream, and send the teaching session materials.  I archive the sessions on the site for teachers to watch later, or go back to for reference.


Screen shot of Technology Professional development page.


With this, my teachers can watch at other sites in my school district, from their computer, smartphone, etc.  They do not have to watch it live either, they get a recorded stream, all done automatically from YouTube.  They can sit back, and watch it in their pajamas later...

So in essence, I have teachers learning new computer tricks in their pajamas.

How I did this...

There have been a few technical things to get it moving.  I start things off by going to YouTube Live Events and setting up my Event details.  This is found in the 'Creator Studio' tab of your YouTube account.

After I setup my settings, I get my equipment organized.
Screenshot of YouTube Settings
My settings.  My stream name is blurred on purpose.
















My current list includes:


OBS Studio icon
I use OBS Studio for Mac on my Macbook Air to encode my broadcast. This mixes and mashes the video fun down into a live stream for YouTube.

I made a short video of the settings I am using, that might help you get started with OBS working with YouTube Live.


I hope this might help another Technology Integrator or Tech Coach out there that might have a similar problem.

Go find your tricks to teach to your staff, and get started!