Technology Tools

Basic spreadsheet terminology

Introduction to google spreadsheets

___________________________________________________________

Sample Activity Using Google Spreadsheets

Directions: Follow the steps below to create a sample google budget spreadsheet.

Create the new spreadsheet

Here is a short video on Creating a new google spreadsheet

• Log into your google docs account and create a new spreadsheet.
• Rename the new spreadsheet in the following format: John Doe Budget (use your name in place of John Doe)
• A new spread will open.

Create your budget table

• Use information from class or create your own to fill in the [enter amount] values that you will use for this spreadsheet.
• Create a table similar to the one below, Be sure to use the indicated cells. All amounts are monthly.

• Enter the amounts from your My Life, My Budget worksheet in column B.
• Format column B to be dollar amounts (highlight the column and click on the $ in the toolbar).
• In cell B9, enter the following formula: =B1-(sumB2:B8)

Create a pie chart

Here is a short video on Creating a Chart

• Highlight cells A2 through B9.
• Click on the chart icon on the toolbar.
• Select the pie chart
• Click the customize tab and add a chart title. You may also customize other features, but make sure your final chart is a pie chart that includes a title and a legend.
• Insert the chart, and move it to a location on the sheet where it is easily viewed.
• If you need to edit the chart, click on the chart box and you should see a title bar appear. Click on the drop down box on the title bar and select Edit Chart.

Share your spreadsheet with your teacher

• Click on the Share button in the upper right corner of the page.
• Under the Add People section, type the email address your teacher provides.
• Click Close.

Your final product should look similar to this: