Assignment 6

A106 Introduction to Computing, Spring 1999

Sections: E127, E129, E133, E135

Due: The end of the lab session, Mar. 16 or Mar. 17

Spreadsheet Basics

  1. Perform the activities 7.1 to 7.4 from Chapter 7 of the lab manual (pp. 121-128) and the exercise marked "On Your Own" on p. 128. Print the spreadsheet after Step 3 on the bottom of p. 128.


  2. Perform Activity 7.5 (pp. 129-133), the exercise marked "On Your Own" on p. 133, the activities 7.6 to 7.11 (pp. 134-142), and the exercise marked "On Your Own" on p. 143. Print the spreadsheet after Step 3 on p. 143.


  3. Perform the activities 8.1 to 8.6 from Chapter 8 of the lab manual (pp. 145-152) and the exercise marked "On Your Own" on p. 152. Print the spreadsheet after Step 4 in the middle of p. 152.


  4. Perform Activity 8.7 (pp. 152-153) and the exercise marked "On Your Own" on p. 154. Print the spreadsheet after Step 5 on p. 154.


  5. Perform the case study on pp. 154-155 and the activities 8.8 to 8.12 (pp. 156-160). Print the spreadsheet after Step 3 on p. 160.

  6. Perform the exercise marked "On Your Own" on pp. 160-161. Print the spreadsheet after Step 3 on p. 161.


  7. Perform Activity 8.13 on p. 162 and the case study on pp. 162-164. Print the spreadsheet after Step 17 on p. 164.


  8. Use the MS Works Word Processor to create and print a document (call it QC6) that will contain the questions 5 and 6 from p. 144, Question 5 from p. 164, and your answers to those questions.


  9. In the MS Works Word Processor, create and print a cover page for this assignment. Don't forget to type in a brief one-paragraph description of Assignment 6.


  10. Turn in the cover page and the printouts, preferably, stapled together with the cover page on top.