Technology for Educators

May 1, 2009

18 Comments »

  1. Sue – Thanks for the great “tips” – this one looks like something I can really use!
    Sally

    Comment by Sally — July 26, 2009 @ 10:03 pm | Reply

  2. Great! If there are other kinds of tasks you’re looking to accomplish in an easier way, feel free to drop me an email!

    Comment by Sue Frantz — July 31, 2009 @ 6:50 am | Reply

  3. I want to get work sheets via email

    Comment by Eyob — October 5, 2009 @ 7:36 am | Reply

  4. Good tutorial Sue. Instead of shrinking the number you can also use a formula to convert it to a Percent. After toggling your Field Code, select your mergefield and press Ctrl-F9 to embed an additional field. Next enter the following formula: {={MERGEFIELD YourField}*100 \# 0%}

    Cheers!

    Comment by Scot Wiedenfeld — November 11, 2009 @ 12:18 pm | Reply

  5. Thank you, thank you, thank you!

    I’m not a whiz with Word (in fact, I rather hate it, but ….)

    I’ve been hand-writing these things and I figured that there *had* to be a way to generate them electronically. I just want to have it generated on “index card” or “mailing labels!” I have 125 students, and that would be a lot of paper to generate a full letter-sized report each time!

    I have 3 lecture classes and 5 labs — and I keep all the grades in the same Excel file in different tabs. Will this work with that, or will I need to save each tab as a single file first? (not that that’s a problem — when I get them uploaded to WebCT [our version of Blackboard] I have to do that and save as a .csv file!)

    Comment by FlorentineScot — February 15, 2010 @ 7:07 pm | Reply

    • Great! I also keep my classes in the same Excel file, each one has it’s own worksheet (tab). When you tell Word which Excel file to link to, it will ask you which worksheet you want. So, no, there’s no need to put your classes into their own files.

      If emailing your students is an option, there’s no need to use any paper at all. If you want to print it on something smaller, in your Word grade report file, under ‘page layout,’ click the ‘size’ button to choose a different paper size. If your printer will print on index cards, go for it!

      Give it a try and let me know how it goes!

      Comment by Sue Frantz — February 15, 2010 @ 8:14 pm | Reply

  6. We’re not allowed to send grades over email. TPTB don’t feel like it’s a Secure Venue ™.

    I am so playing with this over the weekend.

    Comment by FlorentineScot — February 15, 2010 @ 8:17 pm | Reply

  7. Bwahahahaha! Phear my mad Word skillz! Of course, I had to lay it out in WordPerfect first! I’d be a really happy camper if I could figure out how to make Word’s help tell me what all the formatting things are!

    Comment by FlorentineScot — February 20, 2010 @ 8:09 pm | Reply

    • Great! Now, what sort of Word formatting things? Maybe I can help. Best, Sue

      Comment by Sue Frantz — February 21, 2010 @ 5:18 pm | Reply

      • How do you change the line height/spacing and paragraph spacing for an entire document instead of having to change it for *EVERY* paragraph? Drives me nuts! Took me forever to figure out how to “right justify” *part* of a line like you do when you do a Table of Contents. Piece of Cake in WordPerfect!

        But MailMerge is much nicer in 2007 than it was in 2003!

        Comment by FlorentineScot — February 21, 2010 @ 5:25 pm

  8. Do CTRL-A to select the entire document, then change the line spacing. All of your previous paragraphs will change to the new spacing, and anything new you type will also use that new line spacing. Once you’ve set up a document, you can save it as your default ‘style.’ A quickie blog post is coming soon on how to do that!

    Comment by Sue Frantz — February 21, 2010 @ 5:42 pm | Reply

    • Thanks. With WP, everything from where I change settings has the new setting. The only time I need to select anything, is if I want to change it for a specific part of text.

      Comment by FlorentineScot — February 21, 2010 @ 5:45 pm | Reply

  9. HELP!!!!!!!!!!!!!!!!!

    So I got the files all set up for the Lecture Classes (I’ve got 3 lectures and 5 labs) — and I’m setting up the sheets for the 5 labs now; and I broke something.

    After “Selecting Recipients” and navigating to my spreadsheet, and clicking ok, I get a list of tabs. When I click on the proper tab for that particular lab section, I get another *similar* popup window titled “Select Table” only it’s empty. I can click on options and make it show me stuff — reselect the proper tab and I get the message “Word is unable to open the Data Source.”

    What does it mean? What did I do wrong? I got it a few times last night — but I was trying to open the wrong tab for the file — or at least I *think* that’s what I was doing wrong — but that got fixed!

    Comment by FlorentineScot — February 26, 2010 @ 6:07 pm | Reply

    • Hmmm… This happened to me once. I ‘repaired’ Office 2007, and it worked fine after that. The select table popup shouldn’t be there; I don’t think you’re doing anything wrong.

      Comment by Sue Frantz — March 1, 2010 @ 3:16 pm | Reply

      • Actually, I took all the files to school on my stick, and opened them up in Office 2003 — and everything worked just fine!

        Who Knows!

        Thanks!

        Comment by Jerusha Kilgore — March 1, 2010 @ 5:47 pm

  10. […] Last May I explained in a post how to use MS Word and Excel to create grade reports. As I was walking across campus this week, I ran into my colleague in Engineering, Rich Bankhead. He had a great idea. […]

    Pingback by Mail Merge: Creating Individualized Assignments « Technology for Educators — March 13, 2010 @ 8:46 am | Reply

  11. […] next two most popular blog posts are PowerPoint’s presenter view and using mailmerge to link Word and Excel. Together they account for 15% of hits, almost equally split between the two. I get that. I have no […]

    Pingback by A Little Reflection « Technology for Educators — November 12, 2010 @ 9:52 am | Reply

  12. […] next two most popular blog posts are PowerPoint’s presenter view and using mailmerge to link Word and Excel. Together they account for 15% of hits, almost equally split between the two. I get that. I have no […]

    Pingback by A Little Reflection | Technology for Educators — December 29, 2010 @ 3:22 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: