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.