Learn Google Sheets

Anyone who wishes to learn how to manage and analyse data using Google Sheets will find this learning capsule useful. Whether you are a High School student or a Undergrad/Grad student or even an adult learner, learn an important digital literacy skill – collecting and analysing data to manage projects/schedules/expenses using spreadsheets.

What You Need

Ensure you have a Google Account. yourname@gmail.com. From your Gmail Inbox, you should be able to access Google Drive, Google Sheets and other workspace apps. A Headphone helps as you will view videos suggested in this capsule.

Start Learning

Work on these Google published courses in the order suggested:

  1. Create a Study Schedule to Meet Your Goals
    Organize and track your goals, and improve your study skills using a spreadsheet.
  2. Create a Guide to an Area
    Research and organize information about a location to create an interactive guide.
  3. Create a Budget in Google Sheets
    Learn to make good financial decisions by researching and comparing costs and spending in a spreadsheet.
  4. Make Art with Google Sheets
    Create a pixel art project using conditional formatting in a spreadsheet.
  5. Understand your Digital Footprint
    Visualize your digital footprint by recording your online actions in a spreadsheet.
  6. Manage Your Time with Google Sheets
    Analyze your day and use what you learn to make decisions about how you spend your time.
  7. Organize College Information with Google Sheets
    Compare colleges by researching important criteria and organizing it in a spreadsheet.
  8. Calculate Probability with Google Sheets
    Calculate probability using formulas and functions in a spreadsheet.
  9. Research Career Paths
    Research potential career paths and organize your findings in Google Sheets.\
  10. Create a Crossword Puzzle
    Create a crossword puzzle by adding words and clues and formatting a spreadsheet in Google Sheets.
  11. Waze a Sea Battle with Google Sheets
    Create a navy-themed guessing game in Google Sheets.
  12. Make A Word Game
    Use Google Sheets to create a fun word game you can play with a friend! Along the way, learn how to use formulas and functions.
  13. Find the Mean, Median or Mode of a Data Set
    In “Find the Mean, Median, or Mode of a Data Set”, students demonstrate statistical concepts using Google Sheets.
,