https://www.youtube.com/playlist?list=PLpQQipWcxwt8hmVAPM940Ed1GArcH5A0G
Common Spreadsheet Tasks l 2 Creating Simple Formulas Learn all about creating simple formulas in Google Sheets. 1 3 Creating Complex Formulas Learn all about creating complex formulas in Google Sheets. 1 4 Types of Cell References Learn about relative and absolute cell references. 15 Working with Functions Learn all about working with functions in Google Sheets. 1 6 Sorting and Filtering Data Learn how to sort and filter data in Google Sheets. Google Drive and Google Docs *K Exit Fullscreen All About Google Drive Learn all about using Google Drive. 2 Getting Started with Google Drive Get started using Google Drive. 3 Creating Google Docs Learn how to create new documents, spreadsheets, presentations, forms, and drawings. 4 Uploading Files to Google Drive Learn how to upload and sync Google Drive files. Managing Your Files Learn how to manage and organize your Google Drive files. 6 Sharing and Collaborating Learn how to share and collaborate on Google Drive files.Extras 1 7 Understanding the New Google Sheets Discover new features in Google Sheets. 1 8 Understanding Number Formats Better understand how number formats work in Google Sheets so you can make your spreadsheet easier to read. Quiz 1 9 Google Sheets Quiz Test your knowledge ofGoogle Sheets by taking our quiz. H9 JX A B C D E F G H 1 Unit 3 and 4 Culminating Assignment: Organizing and Analyzing Data on Google Sheets 2 3 Question: 4 5 6 7 For this assignment, select data that is of interest to you, some good sources of primary 8 data can be found on the following websites: Statistics Canada https://www.statcan.gc.ca/eng/start 10 Gapminder https://www.gapminder.org/data/ 11 United Nations Statistics Division http://data.un.org/ 12 United States Census https://www.census.gov/ 13 Sports websites: mlb.com nhl.com nba.com nfl.com baseball-reference.com 14 hockey-reference.com etc. 15 (please note- do not select secondary data - data that is selected and manipulated) 16 In the table provided on Sheet1 record the data that you have selected. Be sure to 17 describe the variable in detail with units. 18 Perform the calculations indicated on Sheet1 and Sheet2 19 Record the first set of data and the second set of data in Sheet3 in the table provided 20 (you will need to decide which variable could be the independent variable and which 21 could be the dependent variable in a correlation study). 22 Marks: Application /11 marks, Thinking /7 marks, Communication /4 23Suggested Tutorials 9 Google Tips Get the Google help you need in this free Google Tips tutorial so you can search, create surveys, book flights, and more. \"6 Google Docs This free Google Docs tutorial will teach you how to use this free cloud-based document program for creating professional documents. Google Maps \"6 In this free Google Maps tutorial, get answers to common questions about using this popular map program. an: - ,m EXIt Fullscreen 7 Converting and Printing Docs Learn how to convert, download, and print Google Drive files. Spreadsheet Basics 8 Getting Started with Google Sheets Get to know the Google Sheets interface, and learn how to create new spreadsheets. 9 Modifying Columns, Rows, and Cells Learn how to modify rows, cells, and columns to help personalize yourfiles. l O Formatting Cells Learn all about formatting cells in Google Sheets. 1 1 Working with Multiple Sheets Learn how to work with multiple worksheets in Google Sheets
