Finalize Mail Merge Files

You need to finish off your mail merge documents:

You should have these three files in the MailMerge folder, they need to also be named in this way. I will simply delete any file that is not in this form. You will not be receiving credit if the name is not correct!

name-DataSheet.xls
name-LetterMaster.doc
name-LetterMerged.doc

You also need to open up the files and make sure they are connected to the proper datasheet. The best way to make sure that the file is set up properly is to have a friend try to open the file. If they can't connect to the data, then you need to connect it to your own datasheet that is in the public folder.

Once you have completed this, move on to the html assignment listed below.

Mail Merge Data

One of the more powerful uses of Excel is the Mail Merge. We are able to take data from a spreadsheet and create personalized copies of a form letter.

To work with the mail merge data you need to create a new spreadsheet that contains the names and addresses of 25 people.

Your data should contain the following columns:

1. Last Name
2. Hand Phone
   
3. House/Block Number
   
4. First Name
5. Work Number
6. Phone Number
7. Street
8. Postal Code
9. City
10. Country
11. Percentage
12. Letter Grade
13. Tuition Owed
    

Place the columns in an order that makes sense!

Use the same names as you did for the gradebook, we will be including some values from the gradebook spreadsheet.

For the different numerical data columns you should create a random function to get the values.

We will look at a way to connect the Percentage and Letter Grade columns to the gradebook sheet you have created already.

Excel Project #3 - Gradebook

You need to create a workbook to track the grades in your class. Your gradebook needs to include:

• A large merged cell with your name and the subject.
• The names of at least twenty students listed down the left columns.

1. Name should be in three columns:
• Last
• First
• Full
2. Each student should have a four-digit id#.

• Twenty-five assignments that pertain to the class.

1. For each assignment you need to give the points possible.
• Your assignments should have different values, some values may be used multiple times, but not for all assignments.
2. You also need to calculate the average score for each assignment.

• A summary section to the right of the individual grades that includes summary information for each student:

1. Total points
2. Percentage
3. Letter Grade
• On a separate worksheet you will need to list your grading scale for letter grades (ABCDF).

• Nicely formatted data that makes the spreadsheet easy to read. This should include cell borders and background color changes.
• You need to use conditional formatting to highlight high scores and low scores.
• You need to format your assignment names so that they are turned 90 degrees.
  

In class we will be working on formulas that:

• Take a list of names that is in full name format and separate it into two columns
• Take two columns of names and combine it for a full name
• Create a random id-number
• Create random grades in the proper range
• Look up the letter grade

I will also take some time to work on more advanced conditional formatting and other issues we come across while working on this assignment.

Word Macro

Create a macro named OldEnglish that will replace the word "the" with the word "thee" everywhere it appears in the document.

Assign the macro to the key combination ctrl+8.

Be sure you test the program on different paragraphs and documents to make sure that it works properly. When you are done, go to the Visual Basic editor and copy the code into your document. Then save the document as:

assignments\macro\OldEnglish-[Whi, Danny].doc (replace with your name)

Microsoft Word

Today we will be discussing some of the basic features of Word. I'm going into the discussion assuming you already know how to work with many of these topics. Here are some of the things we will be discussing:

• Toolbars and Menus
  
• Bulleted lists
• Borders
• Headers and Footers
• Margins
• Columns
• AutoCorrect

ASCII Assignment

You must have a message consisting of at least 50 characters (spaces and punctuation are characters too!) This should be all digits: 1001110001010101010010101001101001100101010101010101011110101010010101000001101010010101101001010101010

No spaces or enters should be used in creating your message.

Send your message to my email account with a subject of "ASCII message". If you don't have email, you may post a comment to this and include your message that way.