CSC 101 CompLit, Fall 1996
Merrie Bergmann
Ileana Streinu
Dominique Thiébaut

1. Create a one-page, two-column "newsletter" that contains all of the following features:

(1) A centered title in a suitably impressive font and style; (include your name in the title)

(2) a table with at least three columns and at least three rows, and using some type of borders;

(3) a boxed paragraph;

(4) a double rule separating the title from the main text;

(5) a figure consisting of an oval with some text printed inside (fancier figures are okay, too!).

(6) a footnote.

The title should extend across the full page. This will require you to divide your document into two sections; you will find the "Insert Section Break" and "Format Section" commands useful. The first section should be single-columned, centered; the second section should be double-columned, left-justified. The figure must be created using the "picture editor" in Word. Other instructions and hints are included in the sample newsletter, which can be found in the Literacy folder as H2.Word.Example. Please read it!

Name your file "H2.Word.Name" with "Name" your last name (first letter uppercase) with your first initial if your last name is not unique, and drag it to the "DropBox" in the Literacy folder on the Seelye server. Also, please hand in a printout of your newsletter: before class starts on Thursday, September 19th. I will not often ask for printout, but I want to verify that you know how to do it.

2. Make an Excel Spreadsheet for computing grades in a class like this. It should have six columns: student name, homework grade, quiz1, quiz2, final, and course grade. All grades can be entered on a scale of 100 (so a quiz grade might be, e.g., 87). The course grade is composed of 60% homework, 10% for each quiz, and 20% final, and should be computed with a formula. (For those not comfortable with percentages, let me give an example. If the grade were determined by 60% homework and 40% final, then the formula could be written 0.60*[homework] + 0.40*[final], where the bracketed words should be replaced by the corresponding cell identifiers.)

Enter grades for at least five students, and define cells for the class averages for each column. The averages should also be computed with a formula. (For those not comfortable with averages, you sum up the cell entries in the column and divide by the number of students. So if there were three students in column C, the average would be (C2+C3+C4)/3. Please note the parentheses are necessary here, so Excel knows to first sum and then divide.)

Lastly, make a chart of the averages of the four components of the course grade. Which type of chart you use is up to you. You should feel free to copy the averages to another section of your spreadsheet (as you did in Lab 2) if that helps. A sample chart is in the H2.Word.Example file in the Literacy folder (it is not necessary to look this up, but if you need a model it is there).

Try to make the final product (both the data and the chart) appealing to the eye, as if you had to use it in a presentation. In particular, format both the averages and the course grades to use one decimal place.

Name your spreadsheet "HW2.Excel.Name," (with name as before) and drag it to the "DropBox" in the Literacy folder on the Seelye server.

Due: Two files in the DropBox by the deadline, and a printout of the Newsletter, to be handed before class on Thursday.