Under The Sheets - Google Spreadsheets Tutorial

This professional development session, designed and created by Rick Mallon, has been created for our educators and business staff at Korea International School, but free for anyone else wanting to access this material of course. 

This Session includes:

• Spreadsheet basics
• calculate with formulas/functions
• manage data from Google Forms
• Format cells
• Build charts
• Generate and sort data from PowerSchool
• Basic scripts

Get a copy of the presentation at http://goo.gl/9lV3fG

Create an online ‘textbook’ with Flipboard

Create an online ‘textbook’ with Flipboard

This Professional Development opportunity presents an idea that I came across while at Learning 2.014 (courtesy of Jeff Utecht). As a longtime Flipboard user, the use of Flipboard always seemed geared mostly towards individual consumption of news, blogs and social media feeds. 

Flipboard presents content in a beautiful way. But in this session, we show you how to use Flipboard for classroom learning. It's simple and intuitive. 

The premise quite simply is to create a Flipboard Magazine, and then clip content from across the internet into it. It's easy and fast to do this. The great part though is that not only can people 'Follow' your Magazine, but if invited, can contribute to it as well in a collaborative manner. 

For the teacher, used to posting links to various individual pieces of content to students through Learning Management Systems such as Schoology (as is the case at KIS), this provides the 'Curation' add on. 

Session Objective: Create a Flipboard Magazine, add Content, and Share. 

The Hour of Code - Computer Science Education Week

The Goals for the Session is to provide teachers with an introduction to computer science aimed to demystify "code," show that anyone can learn the basics, and provide information on why students should learn code. 

Student Benefits:

• Be exposed to a new way of understanding their world; see the role of computer science in their daily lives. 
• Gain vital, transferable skills that can be used in other areas (problem solving, critical thinking, decision-making, creativity, and innovation skills). 
• Be prepared for future STEM careers. 
• Take action regarding social and political issues in their world. 

Please remember:  Feed the Fish!  

Welcome to the Googleverse

Korea International School is a Google Apps school. We use many Google tools in to communicate, organize, and to teach. (Short explanations of Google tools.)

The Goal of Today's Session is to give a brief explanation of common Google Apps that are used daily at KIS.  There will be future training sessions, but this is meant to be used as a jumpstart to 2014 - 15.

In the above tutorial, we will cover the basics of:

Gmail

Add accounts
Signature
Labels
Filters
Labs
Groups

Drive

Docs
Forms
Convert
Share

Blogger

Portfolio
Labels

YouTube

There is more detail in Google's Learning repository, http://learn.googleapps.com/