Saturday 17 May 2014

Lesson 5. Create a spreadsheet document in Google Drive

In this lesson I will show you how to create a spreadsheet document in Google Drive which is very similar to creating a text document.

I believe that you already know how to log in to your Google Drive.
If you are still struggling with this part, please check the previous lessons or ask your tutor for help.

Creating a new spreadsheet document

When you open Google Drive, you will see a "Create" button on the left. This button allows you creating different types of documents, including spreadsheet. Click this button and choose "Spreadsheet" from the drop down menu as shown on the image below.



You have just created a new spreadsheet document.

As you remember from the previous lessons, I always suggest changing the name of the new document from the default one to something more meaningful.

If you are not sure how to change the name of the document, please refer to Lesson 2 and Lesson 4.



Once you have set the name, you can start adding your content and editing it in a similar way as in Microsoft Excel or other spreadsheet editors. In this example I’m going to create a spreadsheet with the information about cars. This information will include: car model, year, kilometres, fuel type, engine cc, transmission and price.

The final result is shown on the image below.


When you finish with creating and editing your spreadsheet, you can return to Google Drive home page by clicking on the green spreadsheet icon in the top left corner.
The image below shows the Google Drive home page with the spreadsheet file I have created.


Downloading a spreadsheet document to your computer

To save the document to your computer:
1. Select a spreadsheet document
2. Click More button and select Download link from the drop down menu
3. Select the file format you would like to save the document in (Microsoft Excel or PDF)
4. Click Download button to download the file to your computer

Sharing spreadsheet document with others

To share the document with others:
1. Select the spreadsheet document
2. Click Share button (or click More button and select Share form the drop down menu)
3. Change the visibility and access options to choose who can access your spreadsheet
4. Invite people by sending them a link to this document

Activity
  1. Open Google Drive.
  2. Create a new spreadsheet document.
  3. Crete a table with the following columns: Student name, Class, Subject, Grade.
  4. Use fake student names, classes etc. to create at least 3 rows of data.
  5. Change file name to “Lesson5_Your name”.
  6. Share your spreadsheet with the tutor.
  7. Select permission that allows reading the document only.

Assessment

Send a message to the tutor from your Google email with the link to your spreadsheet.

Total marks: 15
 

No comments:

Post a Comment