Ask a New Question
Menu

In the unit, you went through instructions for how to export data from Obvibase, import it into Google Sheets, and create a graph from the data. In this activity, you are going to follow those same steps but with different data. If you get stuck, refer back to the unit where the steps were explained in detail.

Open the Obvibase database entitled Sales.
Export the data, keeping all the default settings.
Import the data file into Google Sheets.
Delete the Date Added column completely, not just the data.
Highlight column E (Total), click on Format, and select Number. This changes the data type of the numbers from general to number, which will make it easier to do calculations with the numbers later. This step is sometimes done automatically after importing, but may not always format approprately.
The Google sheets format options with number selected.
Insert a chart.
In the Chart Editor, select all of the spreadsheet data (A1:E44) and make sure Column Chart is the chart type.
On the X-axis, set the column data to Item.
X-axis column data dropdown with Item selected.
Tick the box that says Aggregate to group the items together.
Change the chart title to say Total Items Sold by clicking Customize > Chart and Axis Titles > Title Text.
Under Series, remove all items except for Total.
Go to the bottom of the Total column (D45) and type in the formula to compute the average of that column, using the formula you learned in the unit.
To submit your spreadsheet, click the Share button in the top right corner. You should see a Get Link box. Make sure the permission is changed to Viewer (instead of Editor). Then click Copy link and paste it into a word processing document to submit in this unit’s dropbox.

The Get link window with Copy link, Viewer, and Done options highlighted.
Activity 2 Grading Rubric
Full Credit All steps have been followed accurately. A visually pleasing and correct graph is created, with proper titles and formatting.
Partial Credit Several steps have been followed accurately, with some mistakes along the way. A graph is created but may contain errors or incorrect titles.
Little Credit Very few steps were accurately followed. There are numerous errors. A graph may not have been produced, or it is completely inaccurate.

1 answer

Step-by-Step Instructions to Complete the Activity

  1. Open the Obvibase Database:

    • Access your Obvibase account and locate the database titled "Sales".

  2. Export the Data:

    • Click on the "Export" option in Obvibase.
    • Ensure all default settings are kept (CSV format is typically standard) and download the data file.

  3. Import the Data into Google Sheets:

    • Open Google Sheets and create a new spreadsheet.
    • Go to File > Import, click on Upload, and select the CSV file you exported.
    • Choose to import data into the current sheet.

  4. Delete the Date Added Column:

    • Locate the "Date Added" column (most likely the first few columns, depending on your dataset).
    • Right-click the column header and select "Delete column" to remove it completely.

  5. Format the Total Column:

    • Click on column E (assuming it's labeled "Total").
    • Navigate to Format > Number and select Number. This changes the format and makes it easier to perform calculations.

  6. Insert a Chart:

    • Highlight all the data in your spreadsheet, typically A1 to E44.
    • Click on Insert > Chart.

  7. Chart Editor Configuration:

    • In the chart editor sidebar that appears, ensure the chart type is set to Column Chart.
    • For the X-axis, set the data to the Item column.
    • Tick the checkbox that says “Aggregate” to group the items together.

  8. Customize the Chart Title:

    • Click on Customize > Chart and Axis Titles.
    • In the Title Text field, change it to "Total Items Sold".

  9. Adjust Data Series:

    • Under the Series section in the chart editor, remove all items except for "Total".

  10. Calculate Average in Total Column:

    • Scroll down to cell D45 (or the first empty row in the Total column) and type the formula for the average: 
      =AVERAGE(E2:E44)
    • This formula computes the average of the Total column.

  11. Share the Spreadsheet:

    • Click the Share button in the top right corner of Google Sheets.
    • In the “Get Link” window, change the permission to “Viewer”.
    • Click on “Copy link”.

  12. Submit Your Work:

    • Open a word processing document.
    • Paste the copied link into the document.
    • Save and submit the document to the appropriate dropbox.

Final Checks

  • Ensure your graph looks visually pleasing and correctly represents the data.
  • Verify that titles and formatting are accurate.
  • Double-check the average calculation for accuracy.

Tips

  • If you encounter any issues, revisit the steps outlined above to ensure you've followed them correctly.
  • Utilize Google Sheets’ help resources or community forums if you have troubles with specific features.