01/27 (SYNCH): 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

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

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."

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.