I’ll assume I’ve got an assignment with 3 questions on it, each worth 10 marks. Let’s start off with a simple spreadsheet. 25, 2014: In the comments below, “Anna” mentioned that she’s verified that this also works in Office 2013. Note that I’m using Microsoft Office 2010, although that webpage is for Office 2003, so I’m sure it works with other versions.
While it’s still fresh in my mind, I wanted to write a blog post explaining it so that the next time I need to do this, I’ve got something to reference, and hopefully it will be helpful for other people, too! I ran across this web page that really helped me to understand what’s going on.
#How to do a mail merge in word with an excel file how to
I know that there’s a way to format them correctly, but I can never remember how to do it, and the notes I’ve kept don’t seem to always work, and I’ve never quite got my head wrapped around the way it works. The only problem I have, though, is that when I do a mail merge, the formatting of my calculated numbers is thrown off, and the worst is the percentages. I’m also more able to be sure that I’m giving similar comments and marks for similar work. I like doing it this way because then I’ve got a copy of all the comments and marks that I’ve given the students, and I can do some simple calculations to see how effective my teaching has been in different areas of the course material. When I mark student assignments, I usually put the students’ marks and comments in a spreadsheet, then I do a mail merge to send out the marks to the students.
0 kommentar(er)
