Running Presidential Awards

 APs usually ask for this after Semester 1 ends

Use the Ad Hoc folder called Presidential Awards

1. Run the ad hoc for milestones (if they have been imported). This will give you performance levels. 

2. Grades for Presidential will give you posted Q2 grades. Filter and removed anything other than (ELA, math, sci, ss). 

3. Transcript Grades for Presidential will give you all 5th graders posted grades from last year. Filter and removed anything other than (ELA, math, sci, ss). 

Combine the sheets for numbers 2 and 3 above making sure the fields line up. Sort on the last and first name. You will also need to concatenate the name fields. You might have to use the text to columns feature to format the numbers correctly. 

Once you have done this, subtotal at each change in full name to show the average of all the grades. Then paste special (values) to get the averages in another sheet. Then filter on the word averages and paste special one more time in another sheet. Sort these averages. 

Then all you need to do is add the performance levels in this sheet. 

Convert Numbers in Excel

 https://support.microsoft.com/en-us/office/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885

Convert numbers stored as text to numbers

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 More...

Numbers that are stored as text can cause unexpected results. Select the cells, and then click  to choose a convert option. Or, do the following if that button isn't available.

1. Select a column

Select a column with this problem. If you don't want to convert the whole column, you can select one or more cells instead. Just be sure the cells you select are in the same column, otherwise this process won't work. (See "Other ways to convert" below if you have this problem in more than one column.)

2. Click this button

The Text to Columns button is typically used for splitting a column, but it can also be used to convert a single column of text to numbers. On the Data tab, click Text to Columns.

3. Click Apply

The rest of the Text to Columns wizard steps are best for splitting a column. Since you're just converting text in a column, you can click Apply right away, and Excel will convert the cells.

4. Set the format