# Put individual student values onto a bar chart

**URL:** <https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145>\
**Category:** Questions\
**Tags:** aggregate\
**Created:** [June 23, 2020, 4:08pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145 "2020-06-23T16:08:55Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ellis\_Johnson](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/ellis_johnson/32/870_2.png) [@Ellis\_Johnson](https://cl.desmos.com/u/Ellis_Johnson)\
**Post date:** [June 23, 2020, 4:08pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/1 "2020-06-23T16:08:55Z")

</div>

I want to get the classes responses populated onto a bar chart.

> **[Estimation: Lesson 1 • Activity by Ellis Johnson](https://classroom.amplify.com/activity/5ef20ac4552b5d320d6a7f27)**
>
> This activity is designed to work alongside the Lesson 1 of Estimation for Mathematical Studies.

The data input is slide 3 and I would like the bar chart on slide 4.

If anyone could help, that would be fab! Thanks!

---

<div class="post-metadata">

**Author:** ![cwinske](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/cwinske/32/3106_2.png) [@cwinske](https://cl.desmos.com/u/cwinske)\
**Post date:** [June 25, 2020, 1:51am UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/2 "2020-06-25T01:51:40Z")

</div>

This should do the trick.

> **[\[Copy of\] Estimation: Lesson 1 • Activity Builder by Desmos](https://teacher.desmos.com/activitybuilder/custom/5ef3fd7c4e816221424182c1)**
>
> This activity is designed to work alongside the Lesson 1 of Estimation for Mathematical Studies.

---

<div class="post-metadata">

**Author:** ![Ellis\_Johnson](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/ellis_johnson/32/870_2.png) [@Ellis\_Johnson](https://cl.desmos.com/u/Ellis_Johnson)\
**Post date:** [June 25, 2020, 6:51am UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/3 "2020-06-25T06:51:49Z")

</div>

Thank you so much! Is there any chance you could tell me how you did that?! I have so many idea for my lessons and zero coding experience. I do love to learn a formula though!

---

<div class="post-metadata">

**Author:** ![cwinske](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/cwinske/32/3106_2.png) [@cwinske](https://cl.desmos.com/u/cwinske)\
**Post date:** [June 25, 2020, 3:20pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/4 "2020-06-25T15:20:38Z")

</div>

Most of the work is on slide 4, in the graph component. Here’s the code I used:  
 ![image](https://canada1.discourse-cdn.com/flex031/uploads/desmos/original/1X/b5259497cc1270f4353203d0ef1f210d1042312b.png)  
The first line aggregates the class answers from slide 3, creates a list of all those numbers, and sends them to the graphing calculator. The second line is just adjusting the graphing window so the data fits within the graphing screen. The 25 may need to be adjusted depending on whether or not you think more than 25 students will estimate the same age.

In the actual graph, I have this:  
 ![image](https://canada1.discourse-cdn.com/flex031/uploads/desmos/original/1X/8420d1edf1dc5548cec900df95f367c03f871229.png)  
Line 1 isn’t necessary as the class data will override what I have in this list, but I used it just to test out everything else. Line 2 creates the histogram. Line 3 is used for the bounds as the maximum value on the x-axis. Hopefully this helps a little, but let me know if you need more clarification!

---

<div class="post-metadata">

**Author:** ![Ellis\_Johnson](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/ellis_johnson/32/870_2.png) [@Ellis\_Johnson](https://cl.desmos.com/u/Ellis_Johnson)\
**Post date:** [June 25, 2020, 4:22pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/5 "2020-06-25T16:22:06Z")

</div>

I don’t think I’ll be making my own any time soon but can use this when I am comparing different bits. Thank you!

---

<div class="post-metadata">

**Author:** ![Markie\_Dinkel](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/markie_dinkel/32/1484_2.png) [@Markie\_Dinkel](https://cl.desmos.com/u/Markie_Dinkel)\
**Post date:** [November 24, 2020, 4:50pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/6 "2020-11-24T16:50:04Z")

</div>

Is there a way to do this so it just compiles 1 student’s data into the histogram? Each student has 10 data entries. I was able to make a histogram with all of the class data following these steps. But can I make it so each students sees just their data in a histogram? The same 10 inputs for both histograms. Just one that is individual data and then the one I already have that aggregates the class data. Thanks for your time!

---

<div class="post-metadata">

**Author:** ![cwinske](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/cwinske/32/3106_2.png) [@cwinske](https://cl.desmos.com/u/cwinske)\
**Post date:** [November 25, 2020, 5:31pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/7 "2020-11-25T17:31:32Z")

</div>

I might be answering this wrong if I interpreted your question incorrectly, so let me know if I’m way off here. It sounds like the student has 10 inputs from the same data source (i.e. throw a ball 10 times and track the speed of the ball, submit those speeds)? If so, I would have the student put the data in a table. After that, it’s pretty similar to the directions above. In a graph component, put this code:

```auto
numberList(`A`): table.columnNumericValues(1)

```

This would be if the first column contains the data. Everything else should be the same.

---

<div class="post-metadata">

**Author:** ![Markie\_Dinkel](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/markie_dinkel/32/1484_2.png) [@Markie\_Dinkel](https://cl.desmos.com/u/Markie_Dinkel)\
**Post date:** [November 25, 2020, 7:25pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/8 "2020-11-25T19:25:30Z")

</div>

Thank you! I will play with this. The inputs aren’t currently in a table. It’s just 10 mathematical inputs and they’re named input1, input2, input3, etc, so that then I can aggregate the inputs to make a class histogram. If I organized it in a table instead, would I still be able to aggregate the class data?

---

<div class="post-metadata">

**Author:** ![Daniel\_Grubbs](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/daniel_grubbs/32/719_2.png) [@Daniel\_Grubbs](https://cl.desmos.com/u/Daniel_Grubbs)\
**Post date:** [November 25, 2020, 7:43pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/9 "2020-11-25T19:43:46Z")

</div>

You can aggregate table cells as well, just use `table.cellNumericValue(1,2)` instead of input1 etc., or `graph.number(`A[1]`)` for each element from the list @cwinske created above.

---

<div class="post-metadata">

**Author:** ![Markie\_Dinkel](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/markie_dinkel/32/1484_2.png) [@Markie\_Dinkel](https://cl.desmos.com/u/Markie_Dinkel)\
**Post date:** [November 30, 2020, 12:33pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/10 "2020-11-30T12:33:16Z")

</div>

Perfect! I will play around with it. Doing a lot of Googling and learning on the fly as I find myself using Desmos a ton during our remote learning with our students. Thank you for the help.

---

<div class="post-metadata">

**Author:** ![Markie\_Dinkel](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/markie_dinkel/32/1484_2.png) [@Markie\_Dinkel](https://cl.desmos.com/u/Markie_Dinkel)\
**Post date:** [December 18, 2020, 9:20pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/11 "2020-12-18T21:20:32Z")

</div>

Hi. Me again. 🙂

Can you adjust the aggregate command so that it collects all of the column entries for a single table all at once? Or does it have to be done one cell at a time?

I’ve got a table with 2 columns and 4 rows. (1st row is a header and all of 1st column is pre-filled.) I want it to collect all of column 2 for all students and then ultimately average the data.

---

<div class="post-metadata">

**Author:** ![Daniel\_Grubbs](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/daniel_grubbs/32/719_2.png) [@Daniel\_Grubbs](https://cl.desmos.com/u/Daniel_Grubbs)\
**Post date:** [December 18, 2020, 11:20pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/12 "2020-12-18T23:20:32Z")

</div>

`aggregate` can only do numbers, so one at a time.

---

<div class="post-metadata">

**Author:** ![Markie\_Dinkel](https://yyz1.discourse-cdn.com/flex031/user_avatar/cl.desmos.com/markie_dinkel/32/1484_2.png) [@Markie\_Dinkel](https://cl.desmos.com/u/Markie_Dinkel)\
**Post date:** [December 21, 2020, 3:58pm UTC](https://cl.desmos.com/t/put-individual-student-values-onto-a-bar-chart/1145/13 "2020-12-21T15:58:11Z")

</div>

That makes sense. Thank you for the reply!
