Parallel Computing in the Computer Science Curriculum > Workshops > SIGCSE 2012 > SIGCSE 2012 > Statistical Graphs: Aids Cases and Deaths by Year and Historical Poverty in the US

Statistical Graphs: Aids Cases and Deaths by Year and Historical Poverty in the US

Charlotte Gregory
Trinity College
Author Profile
This material was originally developed by the the National Numeracy Network
as part of its collaboration with the SERC Pedagogic Service.


This assignment asks students in a Quantitative Literacy foundations course to summarize data by using graphs they create in an Excel spreadsheet. Working in pairs, students are to work on part I of the assignment by completing the following: 1) create an AIDS chart from the given data, 2) determine the mean and median of the data, and 3) summarize the information by identifying statistical trends. Once each pair of students completes part I they have to complete part II by doing the following: 1) create a Poverty by Race Chart from given data, 2) determine statistical trends from the data, 3) find percent increase/decrease the data represents, and 4) determine what type of graph they could use to display percent data and explain their choice.

Learning Goals

Context for Use

This assignment is the sixth of eleven computer labs given to students who must enroll in a lab in conjunction with a Math 101 class. (Math 101 is a Quantitative Literacy course taught at Trinity College, Hartford, CT, for students who do not successfully complete the QL test given to all incoming students.) The number of students in each lab (usually there are three labs per semester) ranges from 20—30 students, usually first-years, and is offered once a week (usually on Monday afternoons) for one hour and fifteen minutes. The concepts are introduced to the students in the Math 101 class and the lab is designed to reinforce these concepts by helping the students to "see" how the concepts might appear in the real world. Once the lab is complete, students can hand in a hard copy or submit the completed lab via a digital drop box. For those submitting a hard copy, a quick scan of the math is done and if correct, the lab is taken and the students are able to leave the lab. If the math is incorrect, the students are told where the error(s) is(are) and are asked to go back and make necessary corrections before final submission of the lab.

Description and Teaching Materials

Teaching Notes and Tips


Rubric for grading lab:

Graphs (20)
Math (40)
Questions (40)

References and Resources