Embedded Files
Purpose: To understand how to create and use Google Sheets
Purpose: To understand how to create and use Google Sheets
Guiding Questions:
Guiding Questions:
How do I adjust the formatting of a Google Sheet to make it easier to read?
How do I use Google Sheets for calculations?
How do I sort and filter data?
How can I use Google Sheets to create an assignment that provides student with instant feedback?
Getting Started
Getting Started
Getting Started
Modifying Cells: Resize, Add/Remove Rows & Columns, Freeze
Formatting Cells: Font, Border, Color
Working with Multiple Sheets (Tabs)
Creating Simple Formulas
Summing a Column
Sorting Data
Exploring Examples
Exploring Examples
Applying Learning
Applying Learning
Freeze the first row and first column of a Sheet.
Create a second sheet/tab and rename it.
Create a simple formula to add, subtract, multiple, or divide two cells.
Find the sum of values for an entire column.
Sort a sheet using the data from one Column.
Use "sort range" under Data to sort by more than one factor.
Learning More
Learning More
Creating Complex Formulas: Using Order of Operations
Working with Functions
Feedback in sheets.webmConditional Formatting: Provide Students with Instant Feedback
Type of Cell Reference
Using Filters
Pivot Tables
Exploring Examples
Exploring Examples
Applying Learning
Applying Learning
Create a formula that uses more than one mathematical operation.
Create an assignment that uses conditional formatting to provide students with instant feedback.
Create a filter to focus on a specific set of data.
Use a pivot data to filter and sort your data.
Page updated
Report abuse