Graphs

[Hydride]

Alright, now i'm working with my teacher on a project where he chose me as i'm his top student in his class :grin: and we have to figure it out in 3 weeks.

Anyways, the thing is it's for school obviously So.. we have 9 subjects. Each subject has a "School Award, Diploma Exam, Final Mark, Participation Rate"

We want to show the improvment of our school in a graph of each year (02-06) but it is a bit hard since we have to have 4 different graphs for 9 subjects.. Which is a total of 36 graphs. Now thats a hellova lot of graphs just to show improvement.

Now, him and I are trying to figure out ways to get it down to less then 15 graphs. We are going to try a stock graph (Close, high, low).

*Bar graph was used for the 36 graphs*

Any other kinds of graphs out there that can hold a large amount of data that it can show without a huge cluster?

An example of the Data:

Year  |  School Award |  Diploma Exam | Final Mark | Participation Rate 
02   | 2 | 1 | 3 | 4    |  4 | 5 | 6 | 7  |     4         |  1      |     2 
03   | 3 | 2 | 4 |3    |  5 | 4 |7  | 6  |     5         |  2      |     1 

The "|"'s seperate the amount of data (4 pieces to "School award", 4 to "Diploma Exam" 1 to "Final Mark" and 2 to "participation Rate (%)"


Thanks in advance

EDIT: Sorry its a bit sloppy

[Sufficient]

Do total of 9 graphs one for each subject. Keep it a simple line graph ... or maybe semi3d line graph (plates). Should be fairly straightforward to create using exel.

[Hydride]

Do total of 9 graphs one for each subject. Keep it a simple line graph ... or maybe semi3d line graph (plates). Should be fairly straightforward to create using exel.

The problem is showing all that data without a HUGE cluster
It will have about 10 different data points for one graph, which is hard to follow

[Sufficient]

It's shouldn't be too bad ... you have 4 different lines for each of the 9 graphs right?

[Hydride]

No it's 11 pieces of data to each graph
So there would be 11 pieces of data on the graph.. and for a bar graph it's really clustered

Like is there any graph out there that is made for a huge set of data that won't have a big cluster

[KiAN]

Make 9 graphs, and on each one, have 4 diff. colored bars for the diff. years in that subj. And just space it out so you can tell or just make the bars smaller

[Rab]

We want to show the improvment of our school in a graph of each year (02-06)

In what document? For whom?

Perhaps it would be better to have graphs to show the % change from the previous year?

Perhaps choose not to graph all data, but only the final mark?

Perhaps do not show the stats for each individual subject, but rather the year as a whole?

... the thing is, who's gonna take the time to interpret 36 graphs? Who is the document for?

[Sleepy Weasel]

Can you give us an example graph so we see what the problem is? I know it's "clustered" but I'm having a hard time picturing the problem.

[Hydride]

Can you give us an example graph so we see what the problem is? I know it's "clustered" but I'm having a hard time picturing the problem.

I do not know how to post a graph in this thread...

Anyways, the thing is Rab it's for open house to those percentage of kids who met the provincial standard/excellence marks

It's to show how our school is rated academically and the subjects cant be put together because people may want to see how our school is in Social or Science, etc

Well Kian we would do just 9 graphs but 11 strings of data for a 5 year spread on 1 graph is hard to explain without people getting confused/frustrated

I was thinking of adding a 1 in front of Provincial Acceptable (percentage of those who met it) so it would show over and Provincial Excellence (percentage of those who met it) under but that hasnt worked out very well

[Money]

Pie Graphs

[Hydride]

Pie Graphs

The thing is with a pie graph you are not able to show data over a period of time (02-06)

Otherwise I would have used it
The whole point of this is to show the increase of the students marks over the years to get people to go to our school because of the high academics

[Rab]

The thing is with a pie graph you are not able to show data over a period of time (02-06)

Otherwise I would have used it
The whole point of this is to show the increase of the students marks over the years to get people to go to our school because of the high academics

Then put time on x, and score on y.. ?
Is it going to be printed or online? If it's online you could let the user select what data to view.

[gerry]

There really isn't any other way to present the data like you want, (all in one).

Why don't you just make a summary without too many graphs?

[Rab]

There really isn't any other way to present the data like you want, (all in one).

Why don't you just make a summary without too many graphs?

that clearly shows the improvement, but only in one subject... that's not for a year as a whole... still a lot of graphs that way.

[gerry]

that clearly shows the improvement, but only in one subject... that's not for a year as a whole... still a lot of graphs that way.

yes, that's why I said there's no real way to graph that info out..