Course | Google Sheets for Educators

Description

Harnessing Data Power: Google Sheets for Educators
Is your school tired of the software update rat race? Sheets could be the solution you’ve been searching for! Google Drive is a free web-based storage program allowing users to create, edit, and share files from any computer. You can create Documents (like in Word®), Sheets (like in Excel®), and Slides (like in PowerPoint®). Unlike your computer’s drive, all Google Drive files are stored online. All you need is a free Gmail account.

This 15-hour course will teach you how to use Google’s online spreadsheet software, Sheets. You’ll create a personal budget as well as a grade sheet and learn to mail merge address labels and share files. Additionally, you’ll explore Google Apps for Education to see if it fits your school setting. It’s a must-have free web-based tool for every teacher. Earn professional development hours while exploring this powerful program.

Course Details

15 Hours
1.5 IACET CEUs
12 ACSI Credits

Projects To Be Completed

• Personal Budget
• Grade Sheet
• Address Labels (Mail Merge)
• Assessment
• Download Files

Prerequisites

• Basic computer file management knowledge (opening, saving, uploading files, creating folders)
• Ability to create or access a Gmail account and download Google Drive

Materials

• Google Gmail Account (Free)
• Google Drive (Free with Gmail)
• Internet Access
• Adobe Acrobat Reader 11.1.01 or later.

Professional Learning Objectives

• Increase Technical Fluency: Use course text and guided instruction to master Google Sheets’ core features like inserting, editing, and formatting cells, writing formulas, and sorting and filtering data with 100% completion.
• Create Budget and Grade Sheet: Implement learned technical skills to create a personal finance budget and grade sheet with 100% completion.
• Mail Merge for Labels: Download an Add-On to mail merge spreadsheet data and create mailing labels for parents with 100% completion.
• Integrate Google Tools: Provide a written response exploring the integration of Google tools in personal and professional settings with 100% completion.
• Apply Skills in Assessment: Apply the learned skills in a practical assessment with 100% completion.
• Analyze Benefits of Google Apps: Provide a written analysis of the benefits of utilizing Google Apps for Education with 100% completion.

Common Core Standards

• CCSS Math Practice
• CCSS Math 2.4
• CCSS ELA- Writing 1.4