Ask a New Question
Menu

The following chart shows how many students are in GACA High school by Grade level:

Freshman
Sophomores
Juniors
Seniors
922
892
853
576

Using the data from the chart and Google Spreadsheets, Create a Bar Graph (vertical) and a Pie Graph.

Here are the steps

Step 1: Open a google Spreadsheet.
Step 2: In cells A1, B1, C1 and D1 type the words Freshman, Sophomore, Junior and Senior (one in each cell)
Step 3: Type how many of each under their name (how many Freshman are there, put that number in A2)
Step 4: Highlight your 8 cells, go to insert, then chart. You will have the choice of pie chart and Bar Graph.
Step 5: Repeat step 4 but this time choose the bar graph (vertical one)
Step 6: Use a screenshot or your snipping tool to copy and paste all this on your google slide

Copy and paste both charts into slide 2 of your Capstone Google Slide template.

On the same slide, describe in a few words how a principal could use this information.

Feel free to add backgrounds, pictures and any decorative items to your slideshow to make it your own.

1 answer

Here's a step-by-step guide on how to create the bar graph and pie chart in Google Sheets and then insert them into Google Slides, along with a suggestion on how a principal could use this information:

Step-by-Step Instructions for Google Sheets

  1. Open Google Sheets:

    • Go to Google Drive and click on “New” → “Google Sheets” to create a new spreadsheet.

  2. Entering Data:

    • In cell A1 type Freshman
    • In cell B1 type Sophomore
    • In cell C1 type Junior
    • In cell D1 type Senior
    • In cell A2 type 922 (number of Freshmen)
    • In cell B2 type 892 (number of Sophomores)
    • In cell C2 type 853 (number of Juniors)
    • In cell D2 type 576 (number of Seniors)

  3. Creating the Pie Chart:

    • Highlight cells A1 to D2 (these include both the labels and the corresponding values).
    • Click on Insert in the top menu and then select Chart.
    • In the Chart Editor that appears on the right side, select "Pie Chart" as the chart type.

  4. Creating the Vertical Bar Graph:

    • Repeat the chart creation process by highlighting the same A1 to D2 cells again.
    • Click on Insert → Chart.
    • This time, in the Chart Editor, select "Column Chart" (it is the vertical bar graph option).

  5. Taking Screenshots:

    • After creating both charts, take screenshots of each chart using your snipping tool or screenshot feature.
    • Make sure to capture both the pie chart and bar graph.

Step-by-Step Instructions for Google Slides

  1. Open Google Slides:

    • Go to Google Drive and click on “New” → “Google Slides” to create a new presentation.

  2. Inserting Screenshots:

    • Click on slide 2 (or create a new slide if needed).
    • Go to Insert → Image → Upload from computer and upload the screenshots of the pie chart and the bar graph.
    • Position both images as desired.

Adding Context

  1. Describing Use of Information:

    • Below the charts, you could type a sentence or two on how a principal might use this information. For example:
      • “The principal can analyze the distribution of students across grade levels to identify class sizes and assess staffing needs. Understanding which grades have the most students can help in resource allocation, program planning, and engagement activities tailored to each grade.”

  2. Enhancing Your Slide:

    • Feel free to add backgrounds, images, and any decorative items to personalize your slideshow. Use the Background option in the toolbar to change the slide's background.

Final Review

Look over your slide to ensure everything is clear and visually appealing. Check to make sure the charts are legible and that your descriptions provide meaningful context.

Once satisfied with your work, you can share the Google Slides presentation as required!