Systems Builders should have a number of tools under their belt in order to successfully create sustainable systems both in schools and beyond. Please see below for a variety of topics related to systems building in Google Sheets. Click on the available icons to read, watch, or practice on the subject of your choice! Scroll down for more advanced systems building topics.
STEP-BY-STEP
WATCH A VIDEO
APPS CHALLENGE!
OTHER RESOURCES


APPS NOVICE?
No need to fear. Browse the following topics to learn more about the Google Apps suite with an emphasis on spreadsheet basics.

Google Apps Intro
A short introduction to Google Apps for Education.
https://docs.google.com/presentation/d/1JM4M0Wlu8Ad-Cbgkuxt9IldIw4i2Pjq2tUveezEXxSk/preview 
https://www.youtube.com/watch?v=jMWrsRNveSI




Student Data Privacy and Google Apps

Check out our slidedeck about student privacy when using Google Apps!
https://docs.google.com/presentation/d/1tdNckBKGyXl5ke_nfbJrIKD1ulOuOstkls8a6PzIIyY/preview




Intro to Forms

Learn more about Google's Forms App.
https://docs.google.com/presentation/d/17qtDLo3gceT1NKvy9VYIQuwzzug9JQLD7qQKPm4Ppjs/preview 
https://www.youtube.com/watch?v=cm3KyqbaMJA
   https://apps.google.com/learning-center/assets/pdf/products/forms/cheatsheet-forms.pdf



Importing Data from Source Systems

Learn how to easily upload a CSV from a source system into a Google Sheet.
https://docs.google.com/presentation/d/1iGwfWWy8lqWra4YpfBrfodgjrRxkCrGCKJwECydgt1U/preview 
https://drive.google.com/drive/folders/0B5wuGys5IdDrLWJIQVNCbnZSUXM
   http://www.gcflearnfree.org/googlespreadsheets/4



Spreadsheet/Formula Basics

A short intro to Sheets, plus some formula basics.
https://docs.google.com/presentation/d/17tpIWOPkV9HjkfLOc_0Xmep57JzeteA4e8Yx9lQtloQ/preview 
   http://www.gcflearnfree.org/googlespreadsheets/12



Spreadsheet Setup and Formatting

Learn how to create and format a Google Sheet!
https://apps.google.com/learning-center/assets/pdf/products/sheets/cheatsheet-sheets.pdf 
   http://www.gcflearnfree.org/googlespreadsheets/10



Data Validation and Conditional Formatting

Learn how to download information or reports from various systems and upload that info into a Google Sheet.
https://docs.google.com/presentation/d/1HpjJm85DVVdT_B1hMWudAn4xaSmD-p0nQmDzOymQuFs/preview 
https://www.youtube.com/watch?v=Zq7-X3WCd5M
   https://www.youtube.com/watch?v=m2FuBlS26X8


NEXT LEVEL
Take your knowledge of Sheets to the next level with these advanced topics. Test yourself with each associated challenge!

Ways to Filter
Learn about the multiple ways to filter information in Google Sheets.
https://docs.google.com/presentation/d/1cpcFwRTlFGcOK8a1OAF5CLElcKYTv1ke0Ma0WQSM6AA/preview 
https://www.youtube.com/watch?v=vLhyVSfMbgw
https://docs.google.com/spreadsheets/d/1J-USTCjcngVscJXbbM8n_T45fqk0lbejDvquzPny1Vc/copy
https://support.google.com/docs/answer/3540681?hl=en




SumIF/CountIF/AverageIF

Three basic formulas to learn and master in Sheets!
https://docs.google.com/presentation/d/1OxEaD9k52j0Po7RL5NB4ltClUV__PtBurWPEt9grTtM/preview 
https://www.youtube.com/watch?v=LQby0g5KWMo
https://docs.google.com/spreadsheets/d/1sHr-vrPq4e6Nw8fJE19mimWNWBh4oi594xGWcjWDMDo/copy




Text to Columns and Concatenate

Advanced information manipulation in Sheets.
https://docs.google.com/presentation/d/12ZCrabS7fpXFQAiNHF-P2vPnlaoKdCmhmAA_P2-NsJg/preview 
https://www.youtube.com/watch?v=qdC2e0eWEJU
https://docs.google.com/spreadsheets/d/1KzWj94A9dI1iBto_KexONw2KJGgj_6XO66Xu2Odhqow/copy
https://www.bettercloud.com/monitor/the-academy/text-columns-google-spreadsheets/
   https://support.google.com/docs/answer/3094123?hl=en



importRange

Import data from one spreadsheet to another, quickly and easily.
https://docs.google.com/presentation/d/1QSSw7xWlIaTlsMsExtunGlvZciLG1dlMj-LR1uNLDBQ/preview 
https://www.youtube.com/watch?v=b4In4WZjcQU
https://docs.google.com/spreadsheets/d/1KzWj94A9dI1iBto_KexONw2KJGgj_6XO66Xu2Odhqow/copy
   http://cloudlab.newvisions.org/technical-blog/pullingspreadsheetdatanoscriptsrequired



vLookup

A deep look into Sheets' vertical reference formula.
https://docs.google.com/presentation/d/1WUBkSgUB-Ihq19Lma-96UlgGLqtMfvGJU69Q0vxMIFA/preview 
https://www.youtube.com/watch?v=XcLkB1wov7o
https://docs.google.com/spreadsheets/d/1KzWj94A9dI1iBto_KexONw2KJGgj_6XO66Xu2Odhqow/copy
   https://www.bettercloud.com/monitor/the-academy/vlookup-google-sheets/



Pivot Tables/Charts in Sheets

Learn how to quickly analyze data sets using tables and charts.
https://www.youtube.com/watch?v=eUa1LuOjea8
http://trendct.org/2015/09/04/tutorial-how-to-make-pivot-tables-in-google-sheets/
   https://support.google.com/docs/answer/1272898?hl=en&ref_topic=1258755

SYSTEMS SUPERSTAR
See below for advanced systems tutorials using some of CloudLab's most popular Google Add-Ons.

Automagic Agenda Creator
Featuring autoCrat, formRanger, and copyDown!
https://docs.google.com/presentation/d/1Wgj-GrW5iLrfXufLHHdQJcvyi7sVAZrEWugJqvKjGAs/preview 




Student Accountability System

Create student-facing emails using copyDown, formRanger, and formMule.
https://docs.google.com/presentation/d/1VrmN7Agizf-lrY-RlQNaX_PkrjT6Couw1-x_9yAydnM/preview