HW #3

1. Put the text Josh Horatio Waxman into cell A1. Use the MID function to extract the first letters of the first name, middle name and last name. Put them together again to form J. H. W.

2. In column A, put the letters A through Z, a through z, and the numbers 0 through 9. In column B, use the CODE function to find the corresponding ASCII code. In column C, use the CHAR function to covert the ASCII codes in column B back into symbols.

If You Need Tutoring For This Class

It seems that the Computer Science Department offers free tutoring. Stop by the CS Departmental office and ask them about it, in terms of what the hours are.

Video Review of Homework #1

Here is a link to homework #1, which is a gradebook. The video below shows a walk-through of this homework:

HW #2

Note: A partial solution to the previous assignment, which we worked on in the lab, is now up on Blackboard, within "Course Documents."

1. Put values in cell A1 within Sheet1 and Sheet2. In cell A1 on Sheet3, find the sum of the A1 cells of Sheets 1 and 2.

2. Type in the following formulas in one Excel referencing convention and change to the other convention. Type them in while in cel A1.

R4c[-2]
c32 (while in z9 and in A1)
C$92
R5C5

Using the Digital Dropbox To Submit Homeworks

We'll go over this in class, so don't worry about it, but here is a video taking you through the steps.

HW #1

Make a grade book. Make up the names of 10 students (first name and last name in two separate columns), and give them grades for a midterm and a final.
The grade for the course should be 40% of the midterm and 60% of the final.
Use VLOOKUP to match the course grade with a letter grade.
Use string concatenation to concatenate the first name with the last name.
Calculate the minimum grade, the maximum grade, the mean, the median, the mode, and the range. Use this website's definition of these terms.
Give the third student in your list a 70. Use Goal Seek to find out the exact grade he needs on the final to get a semester average of 75.

Welcome to the new semester!

You can see some of the material from last semester below.

For now, I will provide a link to the book on Amazon.com. The book is Excel 2003 Formulas, by John Walkenbach. Check back later for more information.

Homework is to get the book and to skim through the first two chapters.