Sheets
What is Google Sheets?
lesson6_1_introduction.mp4Accessing Google Sheets
lesson6_2_accessinggooglesheets.mp4HIGHLIGHTS
Sign in to your Google Account
Go to sheets.google.com
Creating a Google Sheet
lesson6_3_creatingagooglesheet.mp4HIGHLIGHTS
Click the colorful icon to create a new Sheet
Enter student names and grades in two different columns
Sorting and Organizing Data
lesson6_4_sortingandorganizingdata.mp4HIGHLIGHTS
Organize and sort data by using the column drop-down menu
Click the Sigma button and choose "Average" to get a group grade average
Filtering Data
lesson6_5_filteringdata.mp4HIGHLIGHTS
Highlight cells with the data you want to filter
Click Filter in the toolbar
Click the Filter lines at the top of the cell
Choose your filtering options
Editing a Google Sheet
lesson6_6_editingagooglesheet.mp4HIGHLIGHTS
Change fonts, type size, type color, and more using the toolbar options
Format numbers into currency, percentages, decimals, and more using the toolbar options
Click the Function button to access special formulas
Creating Charts and Graphs
lesson6_7_creatingchartsandgraphs.mp4HIGHLIGHTS
Highlight cells containing the data you want to graph
Select Chart from the Insert menu
Customize your chart or graph using the Chart Editor
Sharing a Google Sheet
lesson6_8_sharingagooglesheet.mp4HIGHLIGHTS
SHARE
Click the Share button
Enter an email address
Set a permission level
SHARE A PUBLIC LINK
Click the Share button
Click "Get a shareable link"
Choose "Anyone with the link"
Set permission level to "Can view"