Spreadsheet Basics 101

Featuring Office 2013 Excel and Google Sheets

What is a Spreadsheet?

Microsoft Excel / Google Sheets are spreadsheet programs which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis and more!


There are many uses in and out of the classroom!


ISTE Student Standards: http://www.iste.org/standards/standards/for-students-2016

Microsoft Office 2013

Awesome Tools to LEARN More!

2013 Microsoft Office Excel Reference Guide: https://goo.gl/2iyhWl


2013 Microsoft Office Excel Tutorial: http://www.gcflearnfree.org/excel2013/


EXCEL Tips and Tricks: http://www.excelfunctions.net/


Learn Excel - Step by Step Directions: https://goo.gl/tqnbK


Excel 2013 YouTube Tutorial Playlist: https://goo.gl/bmJMuX


ABC to EXCEL: https://goo.gl/sUj2VB (Click on the Links above too.)


Office 365: https://www.office.com


Microsoft Forms


Microsoft Forms is a new part of Office 365 Education that allows teachers and students to quickly and easily create custom quizzes, surveys, questionnaires, registrations and more. ... Form data, such as quiz results, can be easily exported to Excel for additional analysis or grading.

Excel 2013 for Beginners Part 4: How to Start Using Excel 2013

Google Sheets

Awesome Tools to LEARN More!

Google Spreadsheet Reference Guide: https://goo.gl/Jv1bvV


Google Sheet Tutorial: http://www.gcflearnfree.org/googlespreadsheets/


Learn Google Sheets Step by Step: https://goo.gl/qNgGOA


Google Sheet Tutorials YouTube Playlist: https://goo.gl/2U5Bax

The Basics of Google Sheets for Students and Teachers

Please provide me with some information.

Click on the following Link and complete the four questions.


https://goo.gl/forms/DhYpZCe9V5T4dk8n1


Avatar Created at: https://www.androidify.com

Using Spreadsheets in the Classroom

Excel Templates

Browse Templates by Product and Theme

Google Sheets Add Ons

5 GREAT Google Add Ons for Teachers

Google Drive Spreadsheet Templates

Google Sheet Template Gallery

Flip over Flippity - Google Sheets add on

Flippity Website: http://www.flippity.net/


Flippity Examples:


Flash Cards: https://goo.gl/VtnHwN

Jeopardy: https://goo.gl/jBIrbg

Crossword: https://goo.gl/9K6gZr


Bingo: https://goo.gl/D0rMCY

Hangman: https://goo.gl/5a9Pqa

Spelling List: https://goo.gl/45Ug5F


Random Name Picker: https://goo.gl/4jg1dt

Mix and Match: https://goo.gl/fMHNJE

Badge Tracker: https://goo.gl/8DdwEj


Progress Tracker: https://goo.gl/qZHk8c

Mad Libs: https://goo.gl/SlmRbA


Google Forms


Using Google Forms to Creative Interactive Google Maps - https://goo.gl/4zaQtw


Great site for learning more about Google Forms: https://goo.gl/Hdxrdq

Creating Charts to Visualize Data

After you've entered data into Excel or Google Sheets, you may want to create a visualization of that information to make it easier to convey.


Luckily, Excel and Google Sheets makes it easy for you to convert data into a graph or chart.

Big image

Other Resources and Social Media

Live for Livebinders

More Excel/Google Sheet Templates & Ideas for Teachers

Internet 4 Classroom - GREAT Excel Ideas!

Links to a variety of Excel/Google Sheets Ideas & More

Blogs to Follow for GREAT Technology Ideas

Alice Keeler - http://alicekeeler.com

Split Text into Columns - https://goo.gl/HqR5il

Check my Spelling Words - https://goo.gl/qVLHIQ

Google App Templates - https://goo.gl/i1zWlD

Exploring Graphing with Kindergartners: https://goo.gl/KBzEfD


Tammy's Technology Tips: http://tammyworcester.com/

Create Batch QR Codes: https://goo.gl/QWGmA9

Creating a Classroom Notebook using Google Sheets: https://goo.gl/oeDSMA


Free Technology for Teachers: http://www.freetech4teachers.com/

Google Forms and Quizzes: https://goo.gl/JiPv3r


Control Alt Achieve: http://www.controlaltachieve.com/

Spreadsheet Activities for all Subjects: https://goo.gl/DB1uuC


Shake Up Learning: http://www.shakeuplearning.com


Educational Technology: http://www.educatorstechnology.com/

Google Tools: https://goo.gl/15ZNIR


Bloglovin: https://www.bloglovin.com

10 Google Sheet Tips: https://goo.gl/GvgTUq

Great Google Sheet Tips: https://goo.gl/vftQmK

Using Pinterest to Find Spreadsheet Ideas

A Variety of ideas to use Excel/Google Sheets from Pinterest

Using Scoop.it to Find Spreadsheet Ideas

"Scoop It" is another source of finding information.

Classroom Google Site

This is a link to my Classroom Google Site.

Creating your Smore Project

Wanting to create your own SMORE Informecial....Click Here!

Sheila Opsal

Business Education Teacher at St. Clair High School

Technology Integration Specialist


My responsibilities include providing technology resources that teachers can use with their students to help enhance their classroom. I also assist students and other employees of the district.


If you have any questions, please email me at any time.

"Never stop learning,

because life never stops teaching!"