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.

Advanced Filter Scenarios In Excel, pt 2

In which we make a named criteria range grow and shrink, in order to incorporate it into our solution of the Scenario manager and Advanced Filtering. We take care NOT to name this range Criteria, but rather some other name, so that it is not replaced when the Advanced Filtering happens.

To understand this, you probably want to view the preceding post first.

Advanced Filter Scenarios In Excel

This makes use of things covered during class, but puts them together nicely.
Part 1 of X

Excel Final Review

Here is a review of the Microsoft Excel final, explaining in detail what I was looking for.

Question 1:


Question 2:


Question 3:



Question 4:



Question 5:


Question 6, 7:


Question 8:


Question 9:


Question 10:


Question 11:


Question 12:


Question 13:

More Excel Videos

I lieu of class this Thursday, here are a bunch more excel videos to watch:

7) Circular References In Excel, part 4


8) Circular References In Excel, part 5


9) Circular References In Excel, part 6


10) Circular References In Excel, part 7


11) Custom Formatting in Excel, part 1 (runtime: 43 minutes)


See you next Tuesday!