Task 1

Step 1: Download the three documents below.

Attendance Practice Document

Credits Practice Document

Regents Passed Practice Document

Step 2: Open up a blank document.

Step 3: Use the VLOOKUP formula to combine the data from all three documents on to one spreadsheet.

Task 2
​

Goal: Make the data look like what is on the document below for all grade levels.

Button Text

Note that the name is replaced with first initial, last initial and the first 4 numbers in the ID number. 
Note the conditional formatting. Yours should have conditional formatting.
Note that the attendance is reflected as a percentage.

GO! GO! GO!