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


Wednesday, November 2, 2016

Make your Google Searches Awesome!

https://flic.kr/p/7eg4Ep
Look! by Mark's Postcards... via CC2.0


Searching the internet is not hard. 

It has actually gotten easier!



There are lots of ways to find your information faster... by knowing how to search.  In the slides below, there are lots of tips and information to follow to make searches:

  • Faster,
  • Easier,
  • and more accurate.

Take notes and do your own search here:
https://goo.gl/KKQs1p

What did you find helpful?  Make a comment below!


Friday, October 28, 2016

YouTube for Educators.

Waupaca Middle School will be opening YouTube to students soon.  So... Why?

Super 8 Camera Image
'introducing kobena super 8 for the creative film maker 1966' by
Nesster via CC 2.0


YouTube is a fantastic learning resource.  Don't know how to fix your garbage disposal? Chances are, someone on YouTube has already created a video to help you along.  Want to learn the basics of playing the guitar?  Again, there is a giant pile of video content for that.  YouTube seems to be the way that people learn.

But YouTube can also create new opportunities for your classroom.  Heard of 'Flipping' your Classroom?  YouTube is often a great way to change the dynamic of your classroom.

What about homework help.... linking videos that cover content that you are sending home, that might be able to remind the student about what was discussed in the classroom.

Here are my slides for the session:



Here is my Handouthttps://goo.gl/hv5oZr
Here is the shortened link to this post: https://goo.gl/27CoQx
QR Code to this post

Tuesday, September 27, 2016

New Job, New School, new blog...

Life has been interesting moving back to the USA.  My new job has been interesting.  Still settling in, finding where to best use my techie skills.  I enjoy working with the fantastic staff at Waupaca Middle School.




A big change for me this year is supporting Chromebooks mixed with iMacs as teacher computers.  It's a Google Apps for Education school, with Hapara dashboard mixed in.   Some good tools.  This is the first year of a 1:1 Chromebook initiative for the Middle School.  Although teachers have had Chromebooks in their classrooms in the past, the devices did not travel with the students around the school. The Chromebook program, at this point, has taken up most of my time.

To help with the Chromebook program, I have started a new tech training blog for the Waupaca School District.  This is where I am posting information, tech tips, and training materials.  As the school year is young, I still have yet to start face to face tech training activities.  But that is on the way.



http://waupacawaytechtips.blogspot.com/