Question

Table 3.3 Educational parameters in the Green Valley City in a decade

(Number of students in each level)

Month	1995	2005	2015
Preschool	423	657	814
Basic education	567	886	1206
Secondary education	456	678	1200
College	678	987	2088
Graduate Schools	12	68	208

(You need to change the table into a suitable graph/chart)

Answer 1

We construct a Stacked Column Chart in order to show the number of students in each level of schooling in 3 decades

With this chart we can see a visible difference in the number of students in each level and the change that may have occured over the time period

We use Excel tool Stacked Column Chart. The series are the 3 years and the names of each series is given by the names of the Years. Every level of schooling represents one column. The legend shows the colours used for different years.