Worlds of Learning @

Jackson R-2 School District

Digital Badges in Professional Learning

Google Sheets

Google Sheets

0 Points

In addition to offering users most of the common features available in other spreadsheet programs, Google Sheets also offers specific online benefits – sharing spreadsheet documents, online storage, shared, real-time editing over the Internet, and, most recently, offline access to files.

This is lesson one, not highly entertaining, but he does explain basic functions and has follow-up lessons in which do get more detailed and show more options within Google Sheets.

Google Sheets Badge Demo:

Click on link above and follow the instructions below.  If all goes well, your document should look the same as the document shown at the end of the steps.

 

  1. Make of copy of the google sheet so you are able to modify the sheet
  2. Click the top left corner so the entire sheet is selected and change font size to 14 for all entries.

 

3. With all cells still highlighted, Double click the line between columns A and B. This will expand all the columns to width of all entries.

4. With all cells still highlighted, click on the center icon to center all data entries.

.

5. Click on Column B, change the font color to dark blue.

6. Select columns N and O.  To expand their decimal places to the thousandth, keep clicking this button until reached.

Now expand the columns like earlier to make them fit.

 

 

 

 

 

7. Now let’s add some of the data together to get totals.  Select Cell E2 through E13 (vertical column), then click on the following Icon and select SUM, then hit enter.

         

 8. Repeat this for data in columns F, K, and L.

9. Now let’s AVERAGE some of the data.  Select Cell N2 through N13 (vertical column), then click on the following Icon and select AVERAGE, then hit enter.

10. Click the top left corner to select all of the sheet and make the columns fit the data to make them easier to see as we did earlier. (Once whole document is highlighted, pick any line between columns and double click.)

11. Let’s highlight the totals in yellow.  Click the cell, then select Fill color tab, choose color.

12. Let’s check your spreadsheet against the final version:

13. Add your name to the title of the Sheet, Set sharing so that Anyone in JR2 can view and submit your link.

People who have earned this:

  • Profile photo of Andrea Gentry
  • Profile photo of Angie Grimm
  • Profile photo of Ashley Gettinger
  • Profile photo of Brandon Brazel
  • Profile photo of Brittany Limbaugh
  • Profile photo of Chelsea Mahnken
  • Profile photo of Christine Dillingham
  • Profile photo of Christy Gibbs
  • Profile photo of Cindy Lawson
  • Profile photo of croach
  • Profile photo of Christine Zirges
  • Profile photo of Danette Bollinger
  • Profile photo of Danna-Bruns
  • Profile photo of Dylan Tangen
  • Profile photo of Emily Young
  • Profile photo of Geannie Floyd
  • Profile photo of Heidi Geiger
  • Profile photo of Tonya Skinner
  • Profile photo of Jeana Roach
  • Profile photo of Jenn Miller
  • Profile photo of Jennifer Moyers Moyers
  • Profile photo of Jennifer O\'Day
  • Profile photo of Jenny Dunham
  • Profile photo of Jessica Bardot
  • Profile photo of Jessica Clardy
  • Profile photo of Joey ONeal
  • Profile photo of Julie Rushing
  • Profile photo of Kara Brown
  • Profile photo of Kelsi Prewitt
  • Profile photo of Kerrie Middleton
  • Profile photo of Kelli Guyot
  • Profile photo of Lance McClard
  • Profile photo of Laura McClard
  • Profile photo of Laura Stoverink
  • Profile photo of Lesley Todd
  • Profile photo of Lindsey Gross
  • Profile photo of Melody Ellison
  • Profile photo of Ronna Kramer
  • Profile photo of Samantha Trankler
  • Profile photo of Tara Wortmann
  • Profile photo of Tori Mirly
  • Profile photo of Tori Schweer
Skip to toolbar