Click Here
Click Here
For both Process and Achievement Grades
To earn 18 points, you must show
how to do 9 skills.
To earn 20 points, you must show
how to do 10 skills
To earn 14 points, you must show
how to do 7 other skills
To earn 16 points, you must show
how to do 8 other skills
Process Grade
Insert Video Here
Remember to comment and tag Mrs. Murat if you post a screencast.
Name your Sheet: 21-22 G Suite Sheets
Create a new Sheet from a Template
Download as an Excel document
Publish you Sheet to the Web
Print in Portrait mode
Change the margins to narrow when printing
Show TWO ways to delete a row
Add 3 Rows
Type in the term G Suite in 10 different cells
Using Find and Replace, change the word
G Suite to Assessment
Process Grade
Insert Video Here
Freeze the first row
Freeze the first column
Show formulas
Zoom to 125%
Insert a Chart
Insert an Image
Insert a function of SUM
Insert a Link
Insert a checkbox
Insert another Sheet
Remember to comment and tag Mrs. Murat if you post a screencast.
In order to complete this section, you must do the 2 steps below FIRST!
1. Type in column headings as follows A, B, C, D for the first 4 columns.
2. In cell A1, type A, in B1 type B, in C1 type C
Process Grade
Insert Video Here
Remember to comment and tag Mrs. Murat if you post a screencast.
Find the Keyboard Shortcuts
Memorize 9 Google Sheets
Keyboard Shortcuts that will be
useful to your future self.
You have to show what the
shortcuts do, not just what the
shortcut is. You also have to do
it from memory.
Process Grade
Insert Video Here
Remember to comment and tag Mrs. Murat if you post a screencast.
Show TWO ways to insert a row above.
Show TWO ways to insert a row below.
Show TWO ways to insert a column to the left
Show TWO ways to insert a column to the right
Hide a column
Show that column you just hid
Group two columns
Type your name in a cell and then show TWO WAYS to add it to 15 cells below it without copying and pasting it individually into each cell.
Type Murat into a cell and then add it to 15 more cells following one of the ways you used above and then find and replace Murat with your name without changing each individual cell.
Move column A to between column C and D
Process Grade
Insert Video Here
Remember to comment and tag Mrs. Murat if you post a screencast.
Show THREE ways to insert a comment
Show TWO ways to insert a new sheet
Rename TWO sheets
Show THREE ways to bold
Show THREE ways to Italicize
Show THREE ways to Strikethrough
Change to TWO different borders
Show THREE ways to add a link
Show TWO ways to change the font style
Show TWO ways to access the ability to change the number formatting
Process Grade
Insert Video Here
Change the theme
Change the number 1000 to a different number format in each of the cells.
Show TWO ways to align a column to center
Show TWO ways to merge 6 cells
Unmerge the 6 cells you just merged
Actually show four ways to wrap text.
Actually show three ways to rotate the text
Show what alternating colors does
Show two other formatting skills (2)
Remember to comment and tag Mrs. Murat if you post a screencast.
In order to complete this, you must put the number 1000 in 7 different cells.
For this part, you need to type this sentence into one of the cells. “This is what text wrapping will do in Google Sheets”
Process Grade
Insert Video Here
Show how to auto fill the next 16 rows so that you now have sequential numbers in A1 - A20
Show TWO ways to SUM column A
Show TWO ways to AVERAGE column B
Show TWO ways to determine the MAX number
in column C
Show TWO ways to determine the MIN number
in column D
Show TWO ways to change column A to percents.
Show TWO ways to change column B to currency
Increase the decimal places in column C,
Show TWO ways to then decrease it back
Show how to change column D to Japanese Yen
Remember to comment and tag Mrs. Murat if you post a screencast.
In order to complete this, you must put sequential numbers in columns A, B, C and D for Rows 1-20. Each column has to have a different sequence of numbers
In order to complete this, you must put sequential numbers in A1, A2, A3, A4
Process Grade
Insert Video Here
Show how to sort that column A-Z
Show how to sort that column Z-A
Add a slicer
Show the embedded tutorial about slicers
Put 1000 in cell A1 and 1001 in cell A2. Highlight both A1 and A1 then drag the blue box down and 10 rows and show what it does.
Add a pivot table using the above data.
Show how to edit the pivot table.
Protect a range
Protect a sheet
Remove duplicates
Remember to comment and tag Mrs. Murat if you post a screencast.
In order to complete this, you must put different last names into 10 different cells in a column.
In order to complete this, you must put the number 1000 in 10 different cells
Process Grade
Insert Video Here
Create a new form.
Edit that form in TWO different ways
Set TWO notification rules
Set TWO accessibility settings
Show how to get help in Tools
Show how to learn to create an app
Explain TWO things you learned about creating
an app. (2)
Add two words to your personal dictionary.
Spell check the last names you added in the
Data slide.
Remember to comment and tag Mrs. Murat if you post a screencast.
Process Grade
Insert Video Here
For this slide you need to teach Mrs. Murat 5 things about
Google Sheets.
Hint: If it is something you had to show for Google Sheets,
she knows how to do it.
4 points per skill.
Remember to comment and tag Mrs. Murat if you post a screencast.