Using Google Sheets Tutorial Submission
- Due Oct 16, 2016 by 11:59pm
- Points 55
- Submitting a text entry box
First, create a folder called Google Sheets Tutorial
inside your CS120/Tutorials
folder.
Check out the tutorial at GcfLearnFree.org, Spreadsheet Basics
Links to an external site.. You will complete each of the challenges from lessons 8 through 16 there. Each challenge has you alter a file. For each of the challenge files, you will make a copy and move it to your Google Sheets Tutorial
folder. Don't forget to give the file a better name than Copy of Google Sheets - Complex Formulas
. Instead name the file something like Beatrice's Complex Formulas 13
.
The following tutorials are about the basics of Google Sheets Links to an external site.:
- Getting Started with Google Sheets Links to an external site..
- Modifying Columns, Rows, and Cells Links to an external site..
- Formatting Cells Links to an external site..
- Working with Multiple Sheets Links to an external site..
The following tutorials are about common tasks using Google Sheets Links to an external site.:
- Creating Simple Formulas Links to an external site..
- Creating Complex Formulas Links to an external site..
- Types of Cell References Links to an external site..
- Working with Functions Links to an external site..
- Sorting and Filtering Data Links to an external site..
For your submission you need only supply a link to your Google Drive folder Google Sheets Tutorial
. You will have a total of 9 documents in your folder.
Rubric
Criteria | Ratings | Pts | ||
---|---|---|---|---|
'Google Sheets Tutorial' folder in CS120\Tutorials
threshold:
pts
|
|
pts
--
|
||
Getting Started sheet copied and edited
threshold:
pts
|
|
pts
--
|
||
Columns, rows and cells sheet copied and edited
threshold:
pts
|
|
pts
--
|
||
"Formatting cells" copied and edited
threshold:
pts
|
|
pts
--
|
||
"Working with multiple sheets" copied and edited
threshold:
pts
|
|
pts
--
|
||
"Creating simple formulas" copied and edited
threshold:
pts
|
|
pts
--
|
||
"Creating complex formulas" copied and edited
threshold:
pts
|
|
pts
--
|
||
"Types of cell references" copied and edited
threshold:
pts
|
|
pts
--
|
||
"Working with functions" copied and edited
threshold:
pts
|
|
pts
--
|
||
"Sorting and filtering data" copied and edited
threshold:
pts
|
|
pts
--
|
||
Total Points:
55
out of 55
|