Illegal Software Installation: Tracking software piracy rates around the world

Maryann S. Allen
Colby-Sawyer College, New London, NH
Created: 2006-07-27 12:23:05 Last Modified: February 13, 2008 11:05
Author Profile
This material is replicated on a number of sites as part of the SERC Pedagogic Service Project


In this Spreadsheets across the Curriculum activity, students analyze software piracy data with Microsoft Excel using the Pivot Table tool. Students will compare the degree of piracy as measured by absolute dollars lost, and rates of piracy. In addition, students also gain experience with graphical data presentation by making a Pivot Chart.

Learning Goals

Students will: In the process the students will:

Context for Use

This module was designed for use in an introductory computer class for first-year college students. It could also be easily adapted for use in a secondary-education computer course.

Description and Teaching Materials

SSAC2006.QA76.MA1.1_student (PowerPoint 759kB May29 07)

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.

This PowerPoint file is 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

This activity can be used as an independent homework assignment, or as an in-class activity where creation of the PivotTable and PivotChart is led by the instructor. The activity takes approximately 45 minutes to complete, with additional time needed to answer the End of Module Questions.


The student version of the module includes an end-of-module assignment that can be used for assessment. The instructor version also includes a pretest that can be coupled with the end-of-module assignment.

References and Resources

For more information on illegal software installation please visit

See more SSAC General Collection Modules »