Group Size: Partners
 

Learning Objectives:
 

1. Students will accurately compile raw data into meaningful forms using Microsoft Excel.
 

Materials:
 

Computers with Microsoft Excel

Photocopies of the sales records

Photocopies of receipts from buying resources to make the products

Attached example spreadsheets
 

Procedures:
 

This is the initial class in analyzing the results of the project. Explain to the students that we will be spending the next week taking the information that we have generated while running our business, and turning that information into a reportable form for the "stakeholders" in our business (namely the administration). This will ultimately include making a spreadsheet that breaks down our sales results and an Annual Report that reports the salient features of our success. At the end of this week, we'll have a party with our proceeds!

In this lesson, you simply need to take the material data (i.e. the record of the number of units sold and the money that has been gathered) and transform it into workable, electronic data. Thus, students will work with their partners to create three separate spreadsheets: one which records the total amount of revenue earned as a breakdown by denomination (i.e. a final "till"); one which details the total amount of costs the business incurred as a breakdown of type (i.e. how much did we spend on cups? how much did we spend on cocoa powder? etc.), and one which records the total number of units sold as a breakdown by sales period (i.e. May 25th, morning recess: 21 units sold, etc.).

You can begin the class by having a number of students quickly count the money in different denominations and place the data on the board. Then, students should work with their partners to generate each of these spreadsheets from photocopies of the data and from the data on the board. If necessary, take a moment to walk students through how to format spreadsheets, and how to use the basic "Autosum" functionalities. If time permits, you can also begin to introduce the "function" functionalities of the program (e.g. multiplying one column by another to get a column of products -- see the attached cost example spreadsheet). If you don't cover that in this lesson, it is covered more extensively in the next lesson. Have students save their work in their individual folders (student pairs may save their work under each student's name).
 

Attached Files:
 

    ExampleofFinalTillSpreadsheet.xls 
    Finalcostchartexample.xls 
    Finalrevenuechartexample.xls 

Non-profit Tax ID # 203478467