How Diverse Are We? -- Comparing Racial Composition of NYC and USA, 1980-2000

Bernadette Kwee Garam, Manhattan College, Bronx, NY
Author Profile
This material was originally developed by Spreadsheets Across the Curriculum as part of its collaboration with the SERC Pedagogic Service.


In this Spreadsheet Across the Curriculum activity, students will build spreadsheets to explore the racial/ethnic composition of New York City and the US using Census data from 1980, 1990 and 2000. They will start by interpreting stacked bar graphs for NYC and USA from Censusscope. After answering diversity-related questions from the bar graphs, sutdents build spreadsheets to explore the same questions using the actual numbers behind the graphs. The questions focus on percentages: the part-to-whole percentages of the various racial/ethnic groups and the percent changes from Census to Census. The module emphasizes the difficulties involved in talking about percentages, and comparing them, in an unambiguous way.

Learning Goals

Students will

In the process, the students will

Context for Use

This module is suitable for college level students sophomore and up.


Module itself: 2 1/2 -3 hours. Module could be an introduction to a course on race and ethnicity or a stand alone module in an urban sociology course.

Description and Teaching Materials

The module is a PowerPoint presentation with embedded spreadsheets. If the embedded spreadsheets are not visible, save the PowerPoint file to disk and open it from there.

The above PowerPoint files are the student version of the module. An instructor version is available by request. The instructor version includes the completed spreadsheet. Send your request to Len Vacher ( by filling out and submitting the Instructor Module Request Form.

Teaching Notes and Tips

Teach in a computer lab. Let students work in teams. Make sure students are introduced to prerequisite of basic functions of Excel and practice on a few functions. Cut and paste function of a spreadsheet may be done here or within the module.


Pre and post tests not only for the modules but also for the pre-requisites to ensure students are comfortable with Excel.

References and Resources

Websites relevant to this module: