Google Sheets is a spreadsheet program included as part of a free, webbased software office suite offered by Google within its Google Drive service. The service also includes Google Docs and Google Slides, a word processor and presentation program respectively.
SYSTEM SOFTWARE VS APPLICATION SOFTWARE
Computer software is a general term that describes computer programs. Related terms such as software programs, applications, scripts, and instruction sets all fall under the category of computer software.
System software has quite a different purpose to application software.
TASK
Open this worksheet and research system software and application software. You will need to copy this Google Doc to your Google Drive DTC folder.
Sheets Default Interface
TASK
Click the image below to go to the Google Sheets Online App.
Check out the template gallery.
Try out the options.
Go to this Getting Started webpage to find out more about Google Sheets
TASK
Do the challenge
Getting Help on how to use Google Sheets
Go to the Getting Started Guide to find out about how to use it.
Also look at Use Formulas and Functions in a Spreadsheet.
TASK
Open this activity Match The Terms
Make a copy and complete the activity
Go to the Getting Started Guide to find out about how to use it.
Also look at Use Formulas and Functions in a Spreadsheet.
TASK
Open this activity Match The Terms
Make a copy and complete the activity
Learn to Format a Spreadsheet
Have you ever played Battleships. Battleships works on a grid. And each cell in the grid has a letter and a number. After you place your ships on the grid each play has a go at sinking the other players ships. This is done by choosing cell based on letters from AK and numbers from 19.
This is similar to a Spreadsheet, it has cells which have letters for the vertical and numbers on the horizontal. What the video and have a go at making a Battleships game.
When you have finished have a game with the classmate sitting next to you.
Have you ever played Battleships. Battleships works on a grid. And each cell in the grid has a letter and a number. After you place your ships on the grid each play has a go at sinking the other players ships. This is done by choosing cell based on letters from AK and numbers from 19.
This is similar to a Spreadsheet, it has cells which have letters for the vertical and numbers on the horizontal. What the video and have a go at making a Battleships game.
When you have finished have a game with the classmate sitting next to you.
Local Area Network (LAN) vs Connect Wide Area Networks (Internet)
The computers in your classroom are networked, which means they can communicate with each other and other networks. The type of network is a local area network and it is confined to Alfriston College. All learners at AC are given an area of storage on the school network.
All learners also have access to the biggest network in the world the internet. On the internet all learners have access to Google Apps and many other services.
TASK
Open this worksheet and complete it.
Creating Simple Formulas
We are going to complete some tutorials from the Goodwill Community Foundation website www.GCFGlobal.org. These tutorials will teach you the main skills needed to use Google Sheets.
Click here.
Simple Formulas Spreadsheet Activity
Click here for the Saving for a Prize Activity.
Try doing the activity, you will need to make a copy of the Google Sheet.
Creating Complex Formulas
Click here for the webpage.
Click here for the webpage.
Complex Formulas Spreadsheet Activity
Click here for the Order of Operations Activity
Try doing the activity, you will need to make a copy of the Google Sheet.
Working with Functions
Click here for the webpage.
Click here for the webpage.
Here is a list of the functions available in Google Sheets.
Click here for the Functions Activity
Try doing the activity, you will need to make a copy of the Google Sheet.
Spreadsheet Activities
Open your a "Spreadsheets" file in your Spreadsheets folder in your DTC folder in Google Drive. Make a new worksheet for each new set of calculations. To name the Worksheet rightclick on the tab, and choose rename.
Countdown to an Important Date!
1) Type date you are counting down to in cell A1, for example: 6/1/07
2) Type this formula in cell A2: =TODAY()
3) Type this formula in cell A3: =A1A2
4) Next A1 put the label 'Future date'. Next to A2 put the label 'Today's date'. Next to A3 put the label 'Number of days'
Try out some different dates in the future e.g. Christmas day etc.
Create a “Self Test”
You will need:
1) Short questions, short answers
2) Optional list of words for matching
3) Indicator of right or wrong answer
4) The “IF” function
Layout:
<> Heading with directions
<> Subheading with optional list of words from which to choose
<> OR, additional column with list of words from which to choose
<> First column for question
<> Second column for answer
<> Third column contains “IF” function to indicate if the answer is right or wrong
Explanation:
Note the following components of the “IF” function: =IF( )
All formulas or functions begin with an equal sign. IF indicates the function to be performed. The parenthesis enclose the “variables” to be considered.
A3=
This gives the cell address whose content is to be compared.
“Sun”,
This is the value with which to compare the cell content. It must be in “quotation” marks if it is text. Note that ALL text must be in quotation marks. Also, if a student typed “sun”with a lowercase S, there would not be a match. CASE MATTERS when text is in quotation marks. The commas separates the comparison value from the next value.
“YES”,
This is the value which is shown in the cell where you type the “IF” function, IF A3 does equal “Sun”. Again, quotation marks are necessary to indicate text. The comma separates this value from the last.
“NO”
The final value in the function is the value which appears IF A3 does not equal the value given immediately following the equal sign.
Note the following components of the “IF” function: =IF( )
All formulas or functions begin with an equal sign. IF indicates the function to be performed. The parenthesis enclose the “variables” to be considered.
A3=
This gives the cell address whose content is to be compared.
“Sun”,
This is the value with which to compare the cell content. It must be in “quotation” marks if it is text. Note that ALL text must be in quotation marks. Also, if a student typed “sun”with a lowercase S, there would not be a match. CASE MATTERS when text is in quotation marks. The commas separates the comparison value from the next value.
“YES”,
This is the value which is shown in the cell where you type the “IF” function, IF A3 does equal “Sun”. Again, quotation marks are necessary to indicate text. The comma separates this value from the last.
“NO”
The final value in the function is the value which appears IF A3 does not equal the value given immediately following the equal sign.
Conversions
There are times when you may be required to convert a measurement in one unit to another unit. For example you may need to convert temperatures from Celcius to Fahrenheit, One reason might be cooking, another is that you may want to travel in a country that uses Fahrenheit.
Celsius to Fahrenheit
This is the formula to convert Centigrade to Fahrenheit: 9/5 x Centigrade + 32 = Fahrenheit
Using this formula, create a Google spreadsheet that shows the Fahrenheit equivalent of a temperature in Centigrade (or Celsius).
Challenge 1
Covert the temperatures from 5 to 35 degrees (5,6,7,8 ...35) in Celcius to Fahrenheit.
Use the Fill feature to create the numbers and to copy the formula after the first instance of the formula is entered.
Challenge 2
Write a conversion formula for:
<> kilograms to pounds and
<> metres to feet
Writing Custom Functions for Google Sheets using JavaScript and the Script Editor (Tools menu)
JavaScript can be used in Google Sheets by using the Script Editor on the Tools menu. Watch this video to get an idea of how to create your own custom Google Sheets function.
The Basics of JavaScript
These two videos will explain:
 how to work with script editor, main spreadsheet app structure, how to write to a cell or a range & how to read information from a cell using Google Sheets Scripts.
 how to work with variables, for loops, how to write comments in Google


Functions TASKS
Create a function that doubles a number.
Create a function that converts a number in metres to the equivalent number in feet.
Challenges
TASK: Write a function that converts Celsius to Fahrenheit.
TASK: Write a function that says negative number if a number is negative and positive number if a number is positive, and zero if its zero. You will need to use an if (numb<0) {result = "positive"; } else if () else structure. For more info on using the If else: https://www.w3schools.com/js/js_if_else.asp
TASK: Write a function that converts Celsius to Fahrenheit.
TASK: Write a function that says negative number if a number is negative and positive number if a number is positive, and zero if its zero. You will need to use an if (numb<0) {result = "positive"; } else if () else structure. For more info on using the If else: https://www.w3schools.com/js/js_if_else.asp
 Create an appropriately named function
 Create a variable for the result
 Use an argument to pass the input from the spreadsheet cell to the function eg. numb
 Use the If () else if () else structure to determine which string to assign to the result variable
 return the result
 Use a correct comment so that the function appears as a help tip