Download the GR 5,6 Placement file in excel
On the ELA and Math spreadsheet copy and past so that the student id's are first
Copy the ELA placement tab and past it on a new spreadsheet so that you have two spreadsheets side by side. One for ELA and one for math.
Use Vlookup to match the student ela placement with their math placement
Save
Now that you have the data (ela and Math) placement one one spreadsheet
Begin with the 5th grade placement letter and once completed you can do 6th grade placement letters
Use the most updated District letterhead
Download it to word
Copy and past the placement letter on to the district letterhead and format so that it fits the page
Using word, Select mailings and "start mail merger". Utilize the step by step wizard
Follow the wizard steps on the right-side
Select the recipients
Choose the recipient list
Select the table within the recipient list
Select OKx2
On the letter in Word
Insert the fields you would like to merge
Complete
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article