using msoffice mail merge to create reports with data director
DESCRIPTION
Using MSOffice Mail Merge to Create Reports with Data Director. Thumb Data Director Institute Huron ISD, March 30, 2011 Cynthia Compton, Supervisor for Curriculum, Port Huron Area Schools. Student Data. Data Director stores many types of student data pulled from multiple places. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/1.jpg)
1
Using MSOffice Mail Merge to Create Reports with Data Director
Thumb Data Director Institute
Huron ISD, March 30, 2011Cynthia Compton, Supervisor for Curriculum, Port Huron Area Schools
![Page 2: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/2.jpg)
2
Student Data
• Data Director stores many types of student data pulled from multiple places.– You can create a report for a class, a
school, or a district.– You can pull a complete individual profile
for a student.• Data Director has the built-in
capability to compile this type of information easily.
![Page 3: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/3.jpg)
3
Sharing Student Data
• Why not use the data and technological capabilities provided to make individual student reporting easier?–Use the data to automatically fill
in required forms, letters, and reports.
![Page 4: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/4.jpg)
4
Student Data In Data Director
• Address & Phone Number
• School & Teacher• Class Schedule• Attendance• Participation in
Federal/State Programs
• Demographics• Grades• Class Schedules
• ELPA scores• MEAP scores• MME/ACT scores• District Assessments• Classroom
Assessments• Anything else you
would like to input…
![Page 5: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/5.jpg)
5
Possible Uses for Mail Merging Data
• Enrollment Forms• Parent Letters• Address Labels• Program Invitation Letters• Individual Monitoring Forms• Individual Score Reporting• Student Evaluation Forms• Custom Reporting Forms• Customized Student Reports
![Page 6: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/6.jpg)
6
Examples
• Title I Parent Labels• After School Program Invitations• Summer School Material Requests• FLEP Student Forms• K-2nd Grade Literacy Profiles• PLAN/EXPLORE/ACT Parent Reports
![Page 7: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/7.jpg)
7
Getting Started…
• What information do you want to share?• Who will be receiving the information?• What will your Microsoft output will be?
– Letter– Labels– Form
• What Data Director Information will you need?
![Page 8: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/8.jpg)
8
Let’s Try It…
• We will go through the steps of the process together.* Slides 9- 21 of this presentation
have step by step instructions for you to refer back to later.
• First, let’s look at our information in Data Directorwww.achievedata.com/sccresa
![Page 9: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/9.jpg)
9
1. Build a Custom Data Director Report
For detailed instructions on how to build a custom report go to the “Tools for Schools” section of the St. Clair County website and choose “Data Director”.
http://www.sccresa.org/toolsforschools/datadirector/
![Page 10: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/10.jpg)
10
1a. Save the Report
Choose to save the report as an Excel file.
![Page 11: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/11.jpg)
11
1b. Save the Report
Choose the location to which you want to save the report.
Renamethe file
something easy to identify.
![Page 12: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/12.jpg)
12
2. Create Your Microsoft Word Document
•Open Microsoft Word.•You can choose to
•create the document first •begin with the merge wizard•use a previously saved document
![Page 13: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/13.jpg)
13
Go to the "Mailings" tab in the toolbar.
Click“Start Mail
Merge”.
Go down to the“Step by Step Mail Merge
Wizard”.
3. Start the Mail Merge Process
![Page 14: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/14.jpg)
14
Choose the type of document you will
use then click "Next: Starting document" at the bottom right
of the page.
At this point you can choose to:• Use the current
document• Open another
document
Choose the document then click
“Next: Select recipients”.
3a. Choose the Document
![Page 15: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/15.jpg)
15
You will use the Excel file saved from Data Director, so you want to “Use an existing list” and click “Browse…”
• This will open up a "Select Data Source" box.
• Find your previously saved Excel document.
• Then "Open".
3b. Select Recipients
![Page 16: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/16.jpg)
16
3b. Select Recipients
*If you want to delete any students or sort the list, you
can do it here.
Click “OK” for both pop-up
boxes.
![Page 17: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/17.jpg)
17
*The type of document you are creating will show here…i.e. “labels” instead of “letter”
3c. Select Recipients
Then click"Next: Write your letter“at the bottom right of the
page.
![Page 18: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/18.jpg)
18
A. In the Word document, click the place you want to insert
data.
4a-b. Insert Data Into the Document
B. Then click "More items..." from the right Mail Merge
menu. This will give you a box with a list of data fields.
![Page 19: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/19.jpg)
19
C. Choose the fields you want to put in the spot where you placed the
cursor.
D. Click "Insert".
*You will repeat steps 4 A - D for each piece of data
you want to insert into the document.
4c-d. Insert Data Into the Document
![Page 20: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/20.jpg)
20
Once you have inserted all of the data fields that you need, click "Next: Preview
your letters" from the bottom right of the page.
You will be able to preview the letters.
As you change the recipient, the information (student
name and scores) will change.
5. Preview Your Merged Documents
![Page 21: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/21.jpg)
21
From the bottom right of the page, click on "Next: Complete the
merge".
You are ready to print your merged documents.
*You can even add notes toindividual students by clicking
"Edit individual letters...".
6. Merge & Print
![Page 22: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/22.jpg)
22
Time to Apply…
• Think of one, simple thing you could apply this to for this year.–Student information cards for
grouping or substitutes.–Parent letters–Student Labels
• Follow the same steps to practice.
![Page 23: Using MSOffice Mail Merge to Create Reports with Data Director](https://reader036.vdocuments.us/reader036/viewer/2022062321/5681305c550346895d962080/html5/thumbnails/23.jpg)
23
For More Information…
Cindy Compton, Supervisor for Curriculum• Port Huron Area School District• [email protected]• (810) 984-3101 x282
You can find this presentation at:• www.protopage.com/ccompton
– “Data Director” tab
http://support.microsoft.com/kb/294683 (letters)http://support.microsoft.com/kb/294684 (labels)
Resources for using the MS Mail Merge Feature: