Spreadsheet Applications
CT 183-H20
New for Fall 2007
Flash Cards Online for Terminology
ExamView Player Online for Objective Testing
Instructor developed Hands-On Exams

Syllabus, Outline, Textbook introduction, information sheet, sign-off sheet, went over new attendance policies, and introduced the new "Business Student Success Center".

Project 1 PreTest

E-mail to instructor the original completed spreadsheet for each assignment.
Print as directed in the instructions

Perform the following using your textbook:

Begin on page 361:

1) Read the Guidelines for Creating a Table in Excel (Table 5-5)
HINT:  You will not create the table.  I have sent it to you in e-mail already completed.

Open the spreadsheet sent to you and on the DATA TAB, CLICK the FILTER BUTTON to turn on the AutoFilter for completion of the steps.

2) continue the steps on the next page, which means all the round red circles with numbers and the red bulleted items included under the numbers.  Follow all steps to the end of the chapter.

3) Printouts along the way.

First Printout: page 370 (figure 5-36)
Second Printout: page 370 (figure 5-37)
Third Printout: page 372 (figure 5-39)
Fourth Printout: page 374 (figure 5-42)
Fifth Printout: page 377 (figure 5-47)
Sixth Printout: page 381 (figure 5-52)
Seventh Printout: page 384 (figure 5-56)
Eighth Printout: Page 387 (figure 5-59)
Ninth Printout: Page 389 (figure 5-61)
Tenth Printout: page 395 (figure 5-67)
Eleventh Printout: page 398 (figure 5-71)

BONUS:
5 points - Search and Replace activity on pages 481 - 484.
10 points - Consolidating Data by Linking Workbooks on pages 485 - 491.