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!




Saturday, January 7, 2017

T.H.I.N.K before you post...

Everyday, someone gets hurt by someone else's words.  We sometimes say nasty things.  Sometimes, hurtful, harmful things.  These things can really stick with someone.

I try to think... "would I say that in front of my Grandma?" 

I realize that not everyone has the same Grandma.  Mine helped me learn to bake, milk cows, drive a tractor, and taught me some manners. Maybe you have someone else you have in your life like that... that you would not want to have them think any less of you.

Would my grandma be proud of what I just posted online?
Grandma finds the internet via generator-meme.com
Not actually my grandma.


Many students and teachers have accounts for many things.  Facebook, Instagram, Twitter, YouTube,... the list probably is longer than my arm.  Sometimes multiple accounts, based on who might read it.

THINK before posting image via www.technologyrocksseriously.com

I want to make my grandma proud, every time she opens her computer and sees something I posted.  If you want to T.H.I.N.K. of a way to remember if you should post something... try this approach.

Is it True?  

Invasion of Fake News via Flickr
'Invasion of Fake News' by Free Press via CC 2.0

Are you about to post or share something that you can't prove?  There are many people out there that are spreading lies, and half truths.  Consider using an online fact checker, such as snopes.com.

Is it Helpful?  

You might have a talent, a skill, or something beautiful you created.  It might help someone else that is trying to learn to do that awesome 'thing'.  
Cat Helping
Helpful by wotthe7734 via CC2.0

Is it Inspiring?  

Does it help motivate others? Does it make you want to get up and dance? Is it too awesome for words?

High Five Gif via DESIGNBENT.COM
High Five Gif via DESIGNBENT.COM and GIPHY

Is it necessary?  

Sometimes, we just over-share.  Sending out stuff that just doesn't need to be there.  Sometimes, we have to post something, or email something, maybe for class work.  But does it need to be said?
"Don't be a parrot..." by LiveLifeHappy via CC2.0

Is it Kind?  

If you are posting something that is not nice,  I just do not think Grandma would approve.

Grandma Drawing
"Grandma drawing" by Olivia Schultz all rights reserved