Link to: http://docs.google.com/speadsheets
Table of Contents
III. How does it work?
Purpose of Google Sheets
The reason why Google Sheets was created was to develop and expand a spreadsheet program that would be made available to more students, teachers, employees, and businesses in general. Although Microsoft Excel is a sufficient program, it is not available through the internet and is not available for everyone to share. Students can work through Google Sheets and can update information easily without worrying about losing their data. Teachers can immediately see how the students are working and can give them immediate feedback, whereas e-mailing attached spreadsheets through excel can become tricky and confusing. Also, you can access and update Google Sheets through your iphone or other mobile device that has internet. Most importantly, it is a free application to all who have internet access. Therefore, if there were businesses and schools looking to save money, they could easily cut costs by using Google Sheets instead of paying for the Excel program or any other program that charges for their product.
The Legendary History and Development
Google Docs originated from two separate products, Writely and Google Spreadsheets. Writely was a web-based word processor created by the software company Upstartle and launched in August 2005. Spreadsheets, launched as Google Labs Spreadsheets on June 6, 2006, originated from the acquisition of the XL2Web product by 2Web Technologies. Writely's original features included a collaborative text editing suite and access controls. Menus, keyboard shortcuts, and dialog boxes are similar to what users may expect in a desktop word processor such as Microsoft Word or OpenOffice.org Writer.
Meanwhile, Google developed Google Spreadsheets using the technology it had acquired from 2Web Technologies in 2005 and launched Google Labs Spreadsheets on June 6, 2006 as the first public component of what would eventually become Google Docs. It was initially made available to only a limited number of users, on a first-come, first-served basis. The limited test was later replaced with a beta version available to all Google Account holders, around the same time as a press release was issued.
Introduction to Google Docs
How does it work?
Below is a link to a Tutorial that walks you through the basics of Google Sheets
To start using Google Sheets, one must first go to www.google.com. From there, if you look at the top left of the broswer screen you will see options such as Web, Images, Video, etc. You will want to click on more, and then scroll down to Documents.
Then, you will be brought to the welcome screen for Google Documents. On the right hand side is a sign in option. You must have a google account to use this program. The account is free to use.
If you already have an account, simply type your account information in to the appropriate fields and select "sign in." If you do not have an account you should click on "Get started" and fill in the necessary fields. After you recieve a conformation email, follow the instructons listed above to return to this page and then type in your account infomation and select "sign in."
After you sign in correctly, you will be brought to the Google Documents homepage. You're almost able to use Google Sheets. From this page you can use other programs such as Google Presentation. This homepage lists the documents you have saved. So if you have previously worked on a spreadsheet, when you log in, you will see it listed here for easy access. To create a new spreadsheet, for first time use, or for another project, look to the left hand side of the browser.
Click on "New" and scroll down to Spreadsheet.
After you click on Spreadsheet, you will be taken to the Spreadsheet homepage where you will edit your spreadsheet's data.
To begin, click on a box. The box will become highlighted. You can then enter your data. After your data is entered in a box, you can click another box, or use the arrow keys to move.
After you are done manipulating your data and adding the exciting features you wish to include, you will want to save your work. Look towards the upper left hand side by the title of your document and you can see that it automatically saves for you as you type. This is an awesome feature! No more worrying about unexpected computer failure and not having that work saved. Now it saves the work as you type and make changes.
Then, just sign out, or return to the main homepages if you need to work on a different project.
[HOW IT WORKS WITH OTHER APPS]:
If you are new to using Google Sheets, but you have previous work done on another spreadsheet program, you do not necessarily have to re-enter it all into your Google Sheets document. Google Sheets will upload files if they are in these formats: 2
- .xls a 97-2003 Excel Document
- .xlsx the newer Excel format
- .ods an Open Document Spreadsheet
- .csv A Comma Seperated Values file
- .txt A simple text file
In addition, you can upload PDF files, but there is a catch to this process. You may not edit these files, only copy and paste text. 3
You do not necessarily have to save your data to Google Sheets's database. You may export it to your own computer. You may save under the following formats:
The ability to save to a pdf file is extremely useful as it is a universal file type. Any computer can easily get a pdf reader (one of the most common being Adobe Reader) for free, so any computer is capable of viewing the files in that format.
Not only is Google Sheets compatible with other spreadsheet programs, you don't even have to use a computer to access and edit your data. If your phone has a Webkit-based browser (which does include the iPhone), you may access google sheets 4. You won't have the full capabilites of google sheets as you would on a computer, but you do still have some abilities. You may still enter data, edit data, and share the data.
Google Sheets is a very versatile program. It can be used on your phone, and you can even use it without the internet. If you want to use Google Sheets offline, you must first install an application called Google Gears. Click "offline" in the top right of the screen.
Then, follow the instructions found here: Click here for instructions. With the use of Google Gears, you may edit your data as you would online, and save it. Then, the next time you are online, you will be able to synchronize your edited data with your old files. This will update your new files in Google's database and let you edit from there. It may take some time to properly synchronize. For troubleshooting, see Google's advice: Click here for advice.
Insert a Gadget
Google sheets has a feature under the insert menu called gadgets. There are a total of 21 gadgets. You can insert anything from a calendar to graphs to translation tables. There is a lot of useful gadgets. Especially the pie chart and other information graph charts that can be inserted using the gadgets feature. Also you can use this feature for fun. You can add word searches to your document. Also this feature works well for advertising. The gadgets list contains a QR code generator. This is perfect if you put up a flyer and then someone with a smart phone can scan the QR code and instantly be directed to the events website or Facebook page.
There are many benefits for using Google Sheets in the Elementary level. The first benefit is that children would be able develop a better understanding of Google Sheets, and the Internet in general. Not only would students be able to access the information at school but they would be able to go back on at any computer at any time to make changes. Students can use Google Sheets to create multiple types of charts and graphs.
These are the different types of charts, graphs, and gadgets that can be used at the Elementary level:
- Pie Chart
- Bar Charts
- Line Chart
- Column chart
- Bars of Stuff *
- Timeline Gadget
- Table Chart
- Organization Chart
- Pile Chart
Many of these gadgets and charts are found in similar software, except the "Bars of Stuff" gadget. This gadget enables teachers and students to make fun bar charts with images such as trains, chocolate, worms, and more!
Google Sheets presents endless opportunities to further the learning process! The following lesson plans are plans that can be adapted to use Google Sheets.
Elementary Lesson Plans
Below are examples of educational lesson plans for that incorporate Weebly into the learning process. These lesson plans are intended for use at the elementary level.
Using Sheet for Averages
This lesson plan shows a lesson of teaching students how to do averages, and as an activity has them each make a spreadsheet of their own, displaying some of their own averages. This lesson plan may require two class periods if you split up the explanation of averages and lab time, but most likely could be fit into one class period.
Time line of Egypt
This lesson plan has the students learn the different time-periods of Egypt. They then incorporate this into making a spreadsheet on Google Sheets using the timeline data. Would take more than one class period, and some out of class group work.
Using Sheet for Water Levels
This lesson plan has students study the effects of global warming. They then apply this knowledge to making a spreadsheet on Google Sheets displaying the varying water levels over the years. This lesson plan would require more than one class period, but everything could be during class periods in a computer lab.
Secondary Lesson Plans
Below are examples of educational lesson plans for that incorporate Weebly into the learning process. These lesson plans are intended for use at the seconday level.
Battery Technology Comparison
Application outside of Education
There is a Google Docs application available for download on to your phone free of charge. Its downloaded to your phone and then you have access anytime you want. It has an “all Items” section to access any document from a list. It has an “owned by me” section to select the documents that were created by you and owned by you. This is helpful if an organization you are in uses Google Docs a lot and you just want to see a paper that you wrote and not an attendance sheet or budget statement. There is also just a documents section so that you can choose a document and not a picture. There is also just a picture option to select all the pictures and none of the documents. Also this application allows you to edit each document as if you were sitting at a computer and changing it.
Many corporations have decided not to use Google Sheets because as of right now they believe the program does not offer enough tools like other online programs offer. They hope that one day Google Sheets will have more useful tools for a business level. Until then many companies are opting to use OpenOffice.org. 8
Although larger businesses and corporations are not using this program smaller companies such as Target, Shoe Carnival, American Eagle, and Macy's opt to use this program to keep track of their finances.9 10 11 12
Google sheets is even taking the route of being an at home program. Some families are beginning to use this application to balance their check books, keep track of savings accounts, and create lists for collaboration on projects or to-do lists. Families are opting for this since it is a mess free way of creating a file that can be easily edited. Families are also opting for this program since it is free and can be used online or offline.13
The following is a lesson plan that could be used for a business or industry lesson plan setting. Although the lesson plan itself is geared towards an upper level class and not a particular industry, it does provide essential skills for manipulating data and following a budget, in which many businesses and industries focus on.
Meals on Wheels
Application at TAFE in Australia
An RTO is a Registered Training Organisation. An RTO is an accredited training organisation that is registered to deliver nationally endorsed training packages for industry. This includes Private RTO's - Board members and Investors, TAFE - Government sector, some schools have a registered status as an RTO to deliver in the vocational education sector approved by the Queensland Department of Education as part of their school curriculum towards their senior certificate. Some schools deliver certificate I, certificate II and some certificate III. The most common packages delivered are Engineering / automotive / construction trades. Some deliver cert III in hospitality. Some deliver certificate I and complete the certificate II through an RTO either TAFE or Private training provider. The learning styles can be delivered face to face, workplace, online or simulated with verbal, written or practical assessments.
Learning new information is great and learning new ways in new environments to communicate gives more variety and keeps you fresh.
A ready application for Google sheets would be in the communication and technology units that apprentices undertake when attending TAFE (Technical and Further Education). These modules are interlinked as they show apprentices how vital technology has become for good communication in the workplace. While attending TAFE apprentices currently use Microsoft Word and Excel programs. Word is used for writing work instructions, reports and safety instructions documents while Excel is used for recording data and producing charts to better illustrate the data. A drawback with this situation is that when an apprentice is not on site they may not have access to the programs.
With TAFE placing a greater emphasis on providing apprentices with the option of flexible delivery for the theory component of units of competency, a resource like Google sheets will be extremely useful. Documents, spreadsheets and presentations can all be created on Google sheets. The fact that apprentices do not have to purchase specific software will save them money and reduce the costs of training.
There are other reasons besides the cost saving factor that make the Internet option a good one. The ability to set up a secure site with access via the Internet greatly increases the flexibility of delivery that is available for collaboration. Being able to set up an environment that lets the teacher control who has access to it, enables work to be set up for individual students or groups of students. Because all of the information is in one location the need for documents being attached to emails is eliminated. This situation assists with version control, as there is only one current version on the Internet at any time. This set up assists with better communication between teacher and student. The presentation function on Google sheets enables slide shows of lessons to be created. These presentations can be made available to apprentices to supplement the resources that are available to them. With everyone using the same program the resources that are created can be tailored just for those applications.
With TAFE Queensland setting up the my.TAFE web site that enables apprentices to access teaching staff and materials via the internet. Google sheets would be an ideal resource for apprentices to use as part of my.TAFE. Access via the Internet and the use of Google sheets is ideally suited to the concept of flexible delivery. 15 16
Private Registered Training Organisation also deliver endorsed nationally accredited qualifications and embrace industry that whatever your goals, we can offer flexible training solutions to help you get there.
"Within the Private Registered Training Organisation, students learn in world-class facilities, supported by teachers and trainers who are highly qualified, industry experts. It is a flexible and dynamic organization which allows us to deliver on the job training to our students, as well as more traditional classroom based delivery and e-learning.
Students from more than 70 countries have experienced the safe, supportive, and harmonious learning environment.
The Registered Training Organization provides students with nationally recognized skills and qualifications, creating pathways into employment or further study." 17
Documents, spreadsheets and presentations can all be created on Google sheets. The use of google sheets is endless and one of many tools available to be utilised. Students / employers can access the web page and relevant links to enquire or submitt evidence against course outcomes. Students can go on line with their e-learning. The use of Google sheets via access on the Internetis is ideally suited to the concept of flexible delivery. 18 19