Formatting 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 spreadsheets. 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, highlight, 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 Videos

Modifying Cells CHALLENGE File (Click Here)

Formatting Cells CHALLENGE File (Click Here)

Creating Simple Formulas CHALLENGE File (Click Here)

CLASSROOM PRESENTATION & ACTIVITIES (click link below)
https://docs.google.com/presentation/d/1Mk3P6hVQL6gmiAVBLiGv4tdg2TSYHvQ8ZAxgYIfmHKc/edit?usp=sharing

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

(❗️) Assessment

Students will open their Google Drive and CREATE a new Google Sheet that includes all the data listed in the picture below.  Students will then format their worksheet to look EXACTLY like the image below (Colors may vary slightly).  Students should NAME their work "Google Sheets Assessment (Last Name) P (1-7)" and SHARE it with Mr. S (harvey.scribner@techfreire.org) for credit.  This assessment is due by Friday, February 11th, 2022 at 4pm.  You may utilize any of the references or sites listed here for help.  This is an individual assignment.

Vocabulary

Cell: A single data point or element in a spreadsheet.

Column: A vertical set of cells.

Row: A horizontal set of cells.

Range: A selection of cells extending across a row, column, or both.

Function: A built-in operation from the spreadsheet app, which can be used to calculate cell, row, column, or range values, manipulate data, and more.

Formula: The combination of functions, cells, rows, columns, and ranges used to obtain a specific result.

Worksheet (Sheet): The named sets of rows and columns making up your spreadsheet; one spreadsheet can have multiple sheets

Spreadsheet: The entire document containing your worksheets

Extension Activity

Google Sheets Cloud Skills Boost Course (Click Here)  In this course you will be introduced to Google Sheets - Google’s cloud-based spreadsheet software included with Google Workspace. With Google Sheets you can create and edit spreadsheets directly in your web browser—no special software is required.

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.

Alternate Resources (Training Sites for Google Sheets)

https://zapier.com/blog/google-sheets-tutorial/

https://www.w3schools.com/googlesheets/index.php

Reference Site Acknowledgement: https://edu.gcfglobal.org/en/
About GCF Global: "For almost 20 years, the GCFLearnFree.org program has helped millions around the world learn the essential skills they need to live and work in the 21st century. From Microsoft Office and email to reading, math, and more—GCFLearnFree.org offers more than 200 topics, including more than 2,000 lessons, more than 1,000 videos, and more than 50 interactives and games, completely free."