Excel Tutorial 5 (Supplemental Material)-- Lab Assignments


First you need to copy the student data files to your X drive from acdutil through the following path: \\acdutil\zhang\cs104 (open an internet explore and copy the link exactly the same as shown). Under CS 104, open Student Data Files --> Excel, and copy Tutorial.05, Tutorial.06, Tutorial.07, and Tutorial.08 to your X drive: X drive --> CS 104 --> Excel.

Locate the files needed for this tutorial in the following path: MY COMPUTER --> X drive --> CS 104 --> Excel --> Tutorial.05. You may erase folders you no longer need from your disk to avoid duplication of names and also to provide room for new files.



Today in class

Complete the tutorial (Sections 5.1-5.3) and print out only the worksheets Appraised Value Summary and Acquired By Year to hand in.

Also complete the Case Problem #33, 1-13, on page EX 275. Print out only the worksheets Q10, Q11 Loans-Type And City, and Q12 Loans-Type and Loan Date to hand in.

Hand in the printouts with the tutorial printout above. Write your name on the top page.

After-class assignment:

Complete a practice quiz on Excel Tutorial 5.

Due Next Class

Excel Project.

Return to the CS 104 Main Page.