Practice Activities

Lesson 1: It Works for Me!

Before You Begin: Download the sample spreadsheet: Student Records.xlsx

 

Try This: Do the following steps

1. Open the spreadsheet: Student Records.xlsx

2. Delete the columns for Grade and Homeroom Teacher

3. Add the following students to the bottom of the spreadsheet

 
Student Percent Class
Lauren Ball 96 2012
Brandon Ayers 45 2011
Arnold Johnston 78 2012
Brittney Evans 82 2013

 

4. Sort the Spreadsheet by Class

5. Format with Table Style Light 8 and select “My Table has Headers”

6. Use the Remove Duplicate Tool

7. Apply conditional formatting.  Create a new rule and select 2 color scale. 

    Pick red for the lowest value and green for the highest value.

8. Save this as YOUR NAME Works for Me Practice