coll134: intro to google spreadsheets & forms october 30, 2009 rachel r. medina, lsntap
TRANSCRIPT
COLL134: COLL134: Intro to Google Intro to Google Spreadsheets & FormsSpreadsheets & FormsOctober 30, 2009
•Rachel R. Medina, LSNTAP
Learning ObjectivesLearning ObjectivesWhy Use Google DocsHow to Use Google Docs
Why Use Google DocsWhy Use Google Docs
Other ReasonsOther Reasons◦Cost Savings ◦http://tinyurl.com/ddny2g
◦ Increase Your Organizations Productivity ◦http://tinyurl.com/2kbzbe
New Features◦Google Docs:
http://googleappsupdates.blogspot.com/search/label/Google%20Docs
Google Spreadsheets New Google Spreadsheets New Features…Features…4/28/2009: Sheet protection in spreadsheets4/30/2009: Themes for forms added6/1/2009: .xlsx support6/25/2009: Editing improvements to Forms
and new question types8/17/2009: Groups can now edit
presentations9/3/2009: Advanced functionality in forms
(pre-populate responses, sign-in access, grid question type, etc.)
10/2/2009: Detect and translate languages on a spreadsheet
Example UsesExample UsesCollaborate on a schedule
or “Sign-up” sheetImport Excel files that you’d like to
share with othersManage and evaluate responses to a
form surveyUse to track software licensing, staff
software updatesUse to track tech issues (never
formally tracked tech issues prior to this)
Creating A SpreadsheetCreating A SpreadsheetFormatting Options
ToolsToolsQuick Sum Auto FillCreating a number seriesFreeze rows & Sort unfrozen rowsNo built in spellchecker, but you can
use the Google toolbar which spellchecks anything put into a web form (http://www.google.com/tools/firefox/toolbar/index.html)
Creating a FormCreating a Form
Demo forms, spreadsheets & Demo forms, spreadsheets & sitessites
THANK YOUTHANK YOUDon’t forget to complete our survey
Rachel R. [email protected] Coordinator LSNTAP