Creating grade reports with mail merge

In this video, we're going to use the power…of microsoft mail merge to create a very…basic grade report that we can quickly print…out and send home to parents of our students.…To do this, we're going to take the grade report form,…which is located in chapter four of the exercise files.…And we're going to connect it to an Excel grade book,…which is also located in chapter four of the exercise files.…Before we get started creating our mail merge, let's go ahead and…make sure our computer is set up to merge these documents properly.…There's one setting we need to confirm is turned on.…Let's go to the file section, choose options, under advanced we're…going to scroll all the way down to the general settings section.…

Here, there's a check box that says confirm file format conversion on open.…We want to make sure that this check box is checked.…Otherwise, if we try to bring a percentage in from…Excel, it'll come in as a number, not a percentage.…We're going to go ahead and click okay. And head back to our greater port form.…

Resume Transcript Auto-Scroll

Author

Updated

10/15/2015

Released

9/5/2013

Teachers, your time is valuable. Learn to reduce your workload, streamline grading and lesson planning, and share resources with students and other teachers with Microsoft Office. Aaron Quigley teaches you how to use Word's templates to create lessons and worksheets more efficiently, use Track Changes to digitally grade papers, build gradebooks in Excel, give presentations from PowerPoint, collaborate over SkyDrive, and connect using Outlook and SharePoint. These lessons are explored using sample lessons, homework, and tests like you'd find at a real-world school. And at the end of each section, Aaron invites you to test what you've learned in a video challenge.