Welcome to CSC150 Lab 2

This is the second of two Microsoft Excel labs. You will be creating a robust grade book for this course. Please follow these directions:

1. Open Microsoft Excel.

2. In the cells A1, place the title: name.

3. In the first column, insert 5 names (starting with your own).

4. As above place the title: test 1 in entry B1 and continue with titles test 2 through 5 in columns C through F respectively.

5. Enter grades for all five students for the five exams.

6. In cell G1 enter the title course test average.

7. By inserting the appropriate averaging functions (either by entering the formula manually or using the excel average function) calculate the average of the five tests in the G column.

8. In cell H1 place the title Required Paper.

9. In cells H2 through H6 enter either Yes or No. This indicates whether or not the student handed in a required paper that is needed to pass the course (be sure that both yes and no appear at least once in the column, ie. don't insert all yes's or all no's).

10. Place the title course grade in cell I1.

11. In cell I2, place an if statement that will give the student an A if he/she has a 90 or greater test average and has completed the required paper, a B if the student has an average between 80 and 89 and has completed the required paper, a C if the student has a test average between 70 and 79 and has completed the required paper, a D if the student has a test average between 60 and 69 and has completed the required paper and an F if the student's test average is below 60 or has not completed the required paper. NOTE: The student should not pass if they have a No in their required paper column. Also, your if statement's condition will have to use quotation marks so that it can read the Yes or No. You will also have to use an and or or statement embedded in your if statement for this to work. The instructor will be around for questions in the lab.

Save the file to your network drive with filename type gfoobar_2s1.xls (for Gordaon Foobar lab 2 section 1) and email a copy to whuddell@NOSPAMeastern.edu (remove the NOSPAM from the address) with the subject lab 2 section 2.