Tag Archives: Google Spreadsheets

6th grade #DigitalCitizenship lesson in #LifeSkills with @DenaeMSisco:

Below are the slides Denae Sisco (@DenaeMSisco) used to introduce a quick unit on Digital Citizenship. Sometimes, I like to drop the “digital” and just call this a Citizenship unit to reinforce that we should be good citizens online and offline…

After discussing the content of the slides and answering questions as they arose, students were split into groups of three and assigned a social media site to explore: Facebook , InstagramTumblrSnapchatYouTubeWikipediaOovooGoogle+kik, ask.fm. The groups were tasked with reading their site’s Terms of Service and answering the following questions into a shared Google Spreadsheet (see below for a screenshot):

  • How old do you need to be in order to use this site/app?
  • How can you use this site in positive ways?
  • What are some concerns about this site (either your concerns or the site’s policies)?
  • Who owns the content?
  • Can you adjust the privacy settings?
  • How would you contact the site to ask questions or express concerns?
  • What are some actions that would cause profiles to be deleted or blocked?

Screen Shot 2016-05-04 at 2.35.16 PM

Leave a comment

Filed under Uncategorized

In Katie Reimer’s 8th math class, analyzing stocks with Google spreadsheets and formulas:

 

http://google.com/finance
Katie Reimer, 8th grade Algebra teacher at The School at Columbia University, stopped by yesterday to talk about her upcoming mini-unit on stock prices and percent changes. She wanted students to figure out relationships between today’s price, yesterday’s closing price, and price from one year ago today. She asked about ways to assess this, and we decided to use information located via Google Finance and a Google Spreadsheet with formulas to calculate change on day and change over a year. Students chose 10 stocks based on products they use everyday and analyzed their changes. Tomorrow, kids will take the roles of front office and back office to assess each other’s research.

Katie left finance in 2008, and it’s been a pleasure to join her class and learn math with someone who has used it in the real world. I’m pretty sure these 8th grader’s are more financially savvy then me at this point…

Leave a comment

Filed under Uncategorized

My slides from “Redefining Collaboration with Google Apps” at #NYNJGS13

Today, I’m presenting at Google Apps in Education NY/NJ Summit. This is my first Google Apps Summit, and I’m excited to be a part of it. I’m a big fan of Lisa Thumann (@lthumann), and she worked hard to put together this event.

My session is Redefining Collaboration with Google Apps from 10am-11:00am in Room 318. Here’s the description for my session on the summit’s website:

Presented by: Karen Blumberg, Technology Integrator, The School at Columbia University This session is geared towards: Techie, Teacher, Admin Level of Session: Basics

Google Apps for Education provides tools that enable a community of teachers and students to collaborate differently. With shared Calendar, Presentations, Documents, Sites (and with the advantage of Google Drive), a school’s population can communicate paperlessly, plan dynamically, and work productively and efficiently.

We’ll discuss a few examples of how Google Apps enhances our 21st Century classrooms:

Teachers at The School at Columbia University share meeting notes in a single Google Doc that is added to at every gathering.
6th grade scientists curate their personal Google Site to keep track of notes, lab work, data, and assessments.
7th grade historians locate articles and add them to a class page using the “announcements template” on a class “Current Events” Google Site.
8th grade English students share multiple drafts of their creative writing in a Google Doc that they share with their teacher.

Leave a comment

Filed under Uncategorized