Introduction to Spreadsheets

Overview

This activity introduces students to spreadsheets over the course of two or three lessons. The first lesson helps students learn the parts of a spreadsheet and how to read a spreadsheet table. The second lesson directs students to make changes to their spreadsheet. Through this activity, they will see one of the most powerful aspects of spreadsheets: the use of formulas. Purpose (SWBAT) Students will be able to create, format, and manipulate basic data in a Google Sheets spreadsheet. Students will also be able to change formatting, highlights, and create charts and graphs based on data provided or created. Objective(s) Recognize basic parts of a spreadsheet window Read a spreadsheet with data Make changes in a spreadsheet to data and formatting

Introduction Video

Introductory Practice Worksheet
Note: Click the link below to Open the Practice Worksheet, click File and Make a Copy, and then SHARE your copy of the Practice Worksheet with Mr. S (harvey.scribner@techfreire.org) for credit. Make sure to Change the Name of your Practice Worksheet by adding your Last Name and Class Period to the Title Block for easy reference.

https://docs.google.com/spreadsheets/d/1vGbsKzk7C4e9j0CQk5y_RXFCcV3dMRG7U0AQ5FXJzqg/edit?usp=sharing

Vocabulary
Menu Bar

Toolbars

Column & Row 

Reference 

Formula Bar 

Sheets Tab 

Work Space 

Cells 

Active Cell 

Mouse Pointer 

Standards 

Common Core Math Students consider the available tools when solving mathematical problems and working with/understanding data sets. 

PA SAS Digital Literacy Use Technology to enhance effective communication. Use technology to enter and manipulate data and text. Apply basic mathematical operations to solve problems. 

CCSS.ELA-LITERACY.RST.6-8.2 Determine the central ideas or conclusions of a text; provide an accurate summary of the text distinct from prior knowledge or opinions. 

CCSS.ELA-LITERACY.RST.6-8.3 Follow precisely a multistep procedure when carrying out experiments, taking measurements, or performing technical tasks. 

CCSS.ELA-LITERACY.RST.6-8.4 Determine the meaning of symbols, key terms, and other domain-specific words and phrases as they are used in a specific scientific or technical context relevant to grades 6-8 texts and topics. 

CCSS.ELA-LITERACY.RST.6-8.7 Integrate quantitative or technical information expressed in words in a text with a version of that information expressed visually (e.g., in a flowchart, diagram, model, graph, or table). 

CCSS.ELA-LITERACY.RST.6-8.9 Compare and contrast the information gained from experiments, simulations, video, or multimedia sources with that gained from reading a text on the same topic.