The following work is done in the Student Data EXCEL file.

1.Highlight columns A and B in your Excel file. (Time Stamp and Username)

Go to EDIT>DELETE…

Choose Shift Cells Left. Click OK

2. Fix any errors in the data.  For example, if someone wrote “Two” instead of “2”, fix it.

3. Simplify the column headings.  (First Name, Last Name, # Siblings, etc)

4. Adjust the column widths if necessary.

5. Insert a 7 new worksheets and copy and past your original data into each one.   Click here for directions.

You should have 8 identical worksheets at this point.

7. Rename your worksheets with the following names.  Double -Click on the tab to rename it.

• Original
• Sort school, name
• Sort school, birthday
• Sort “your choice”
• Filter 2 siblings
• Filter “your choice”
• Averages
• Min/Max

Now You can begin to Sort and Filter your data.