dividing space bar

Menu:

Updates:

May 11, 2017:
A new version.

Links: Spreadsheets

Option 1 - Look at Mr. Barton's Getting Started with Spreadsheets that was developed by Alice Keeler.

Option 2 - iWork Tutorial – Create a summer activities chart for kids from iCreate Make the most of Numbers on your Mac and use it to keep yourself active with a chart for summer play. Just follow this step-by-step guide to get stated. If you prefer to use Google Sheets there's a Summer Vacation Activity Chart for you to use as a template.

Option 3 - Creating a Shopping Budget with Chart Using Google Sheets. See the below for a step-by-step guide. There's also a My Pet Shopping Budget for you to use.

Students create a shopping budget that calculates total expenses and money left over.

Students utilize the following spreadsheet skills:

  1. Format a chart title and merge cells.
  2. Enter and format data and numbers.
  3. Use formuas to sum total expenses and subtract total expenses from spending allowance.
  4. Create and format a bar chart.

     

Instructions:

Students begin with $100.00 budget and enter 6 or more items to purchase for a new pet. Students enter costs for each item, limiting their total to less than $100.00. Students use the SUM function to automatically calculate the total expenses. Students enter a formula to automatically subtract the $100.00 spending allowance from the total expenses. Students use the data to create a bar chart. Students format the data with increased font sizes, bold text, dollar signs and chart colors.

Students are allowed to shop online at PETCO/dogs.

Finished iWork Numbers Shopping Budget Example:

Finished spreadsheet.

Calculating the Total Expenses

To calculate the Total Expenses, click and drag to select all of the expenses. Next, click the function button and click Sum. This adds all of the expenses together and puts the total directly underneath.

Spreadsheet showing how to add the SUM function.

Formula for Calculating Money Left Over

Click in the cell to the right of the Total Expenses cell and enter the equal sign. Enter the formula B2-B11. This subtracts the value in cell B2 from the value in B11. Click the green check mark to complete the calculation.

Instructions on how to enter a formula.

Creating the Shopping Budget Chart

Select the data as shown below. Click the Chart button and click the column chart selection.

Instructions on how to create a chart.