Class Roster
The first 2 charts are for ONLY YOUR Computer Apps class
students
Chart #1: Male first name and age
Chart Type: Line with markers
Appropriate chart title and
axis titles
No legend
As a new sheet named Males
Format Chart 1:
*plot area- light color of your
choice
*Title of chart-font comic sans ms-size 16-dark green
*Axis title-font comic sans ms-size 14-red
*Axis title-font comic sans ms-size 14-purple
*Change marker shape to any style-size 8-any colors
*Change line style-any style-color-weight
Chart #2: Female first name and age
Chart Type: Clustered column
Appropriate chart title and
axis titles
No legend
As a new sheet named Females
Format Chart 2:
*plot area-white
*Title of chart-font comic sans ms-size 16-dark green
*Axis title-font comic sans ms-size 14-blue
*Axis title-font comic sans ms-size 14-orange
*Change all column color-your choice
These next 2 charts are for students in both classes:
1 chart to compare the number of students,
average age, youngest age, and oldest age for MALES
1 chart to compare the
number of students, average age, youngest age, and oldest age for FEMALES
*Chart type: your choice
*Must have a legend for Each
Class Periods
*Must have Axis titles
*Must have a Chart title
*Format chart (colors, size)
*Place each chart on its own sheet (name the sheets Class Periods-Males
& Class Periods-Females)