Learning Spreadsheets

posted May 15, 2013, 12:55 PM by Unknown user   [ updated May 29, 2013, 12:29 PM ]
Here is a link to the entire Excel unit (online version!).

Here is the link to help you learn the google drive website: http://www.gcflearnfree.org/googlespreadsheets/2.4

In total, we are completing lessons 1, 5, and lessons 8-16.
Use these lessons to get the sample files and to watch the videos.



For the week of the missions trip, if you are working ahead, try to get a feel for how google drive and spreadsheets work (the first two lessons). We will go through each lesson as a class after the mission trip. Ask the sub for the worksheets on google drive.

Spreadsheet project (TBA)
After we finish the booklets, we will learn how to use the finance functions in Google spread sheets to create a 'live' portfolio (along with some graphs and charts)
Google finance for Drive Reference sheet
Your final project will look something like this:

If you need hard copies of the material for this unit, you can print them off from these links

https://docs.google.com/file/d/0BzQ3kg30d6vbbTBhV3FvUTJRajA/edit?usp=sharing
https://docs.google.com/file/d/0BzQ3kg30d6vbeUV0SzBlUGpnanc/edit?usp=sharing
https://docs.google.com/file/d/0BzQ3kg30d6vbbHNGMDBLLWZUYWc/edit?usp=sharing
https://docs.google.com/file/d/0BzQ3kg30d6vbV2xkMWgyN0I1YVU/edit?usp=sharing
https://docs.google.com/file/d/0BzQ3kg30d6vbUnBLUkVsekJTSFE/edit?usp=sharing
https://docs.google.com/file/d/0BzQ3kg30d6vbZ1ZjczVhOS1uekk/edit?usp=sharing
https://docs.google.com/file/d/0BzQ3kg30d6vbRTltWHk1TFRIb1U/edit?usp=sharing
https://docs.google.com/file/d/0BzQ3kg30d6vbMWFzM25MaTQ0UGc/edit?usp=sharing
https://docs.google.com/file/d/0BzQ3kg30d6vbcjg1Zk82Wkljbmc/edit?usp=sharing
https://docs.google.com/file/d/0BzQ3kg30d6vbQ2o1bzdOMHZmUkE/edit?usp=sharing

Comments