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.