CS120
Introduction to Computers

David Levine

Due dates and attendance:

Most of the material in this course can only be mastered by using the computer directly. Therefore, attendance is strongly encouraged. While there will be no formal deduction for lack of attendance, neither will there be any opportunity to make up quizzes and/or exams due to lack of attendance. (Exceptions will be made for emergencies and absences in the service of the university.) The due date for any work done in class is 4 p.m. on the Thursday following the class, i.e. 48 hours after class. If a student chooses to miss class, then it is assumed that the student has already completed the work; therefore it is due at the end of the class that the student is missing. (This probably means that the student will need to turn it in BEFORE class.)

Late Penalties:

A late penalty goes into effect immediately after class. An assignment turned in on the day it was due, but later than the due date will receive a 10% penalty. Thereafter, the penalty is 25% per day that the assignment is late. (Saturday and Sunday count as one day.) Hence, for a student who attends class, an assignment turned in on Friday, will be docked 25%, one turned in over the weekend will be docked 50%, and one turned in Monday will be docked 75%.

Date	In class	Preparation for next class
January 17	Exploring the Basics of Microsoft Windows XP, Review Asssignments 1-29 (omit 2, 12, 15). Type answers in WordPad	Read Essential Computer Concepts, EC3-34; find an ad for computer system; be prepared to tell why you chose it based on reading. If you haven't purchased your textbook bundle yet, the reading is available at http://www.course.com/downloads/newperspectives/office2003/ECC.pdf Read/do Managing Your Files, pp. 3-21. Download the folder/files (FM Tutorial) you need (right click/save target as/save in desktop/save). Double click/open/run/ok/browse to external media/unzip/ok. Open FM tutorial folder. You will need the unique SAM product key on the back cover of you SAM CD case for class next time. Read/do Browser and E-Mail Basics, pp. 3-35 Right click, Save Target As (B&B Ideas.doc).
January 24	ECC Quiz/File management/Mail Case Problem 1, pp. 22-23, 1-10. Right click to download the folder/files you need (FM Cases) (right click/save target as/save in desktop/save). Double click/open/run/ok/browse to external media/unzip/ok. SBU e-mail. WSJ email; WSJ search; Internet Explorer; Internet Addresses	Study for exam on Windows/ECC/File Management/Internet WORD Tutorial 1; create and save Web Time Contract Letter.
January 31	Word 1 - Exam on Windows/ECC/File Management/Internet WORD Tutorial 1 Review Assignments 1-19, pp. 33-34; save in Tutorial 1 folder. Case 4, 1-14, p. 38; save in Tutorial 1 folder. Turn in both printouts. Make sure that your names are on the printouts. Take exam.	WORD Tutorial 2, pp. 41-79; right click and save FAQ in the Tutorial 2 folder. WORD Tutorial 3, pp. 89-126; right click and save WAN in the Tutorial 3 folder. Open WAN from your disk or Word.
February 7	Word 2/Word 3 WORD Tutorial 2 Practice (Statmnt). Case 2, 1-8, pp. 82-84; right click and save Moths on your computer. Open Moths from your disk or Word. WORD Tutorial 3 Practice (Trouble) Open Trouble from your disk or Word. Case 1, 1-15, pp. 128-129. Right click and save Textiles on your computer. (#5 and #6, create a header and footer that appear only in section 2; #9 remember the Clipboard; #14 center table horizontally on the page).	WORD Tutorial 4, pp. 135-173; right click and save Addresses, Clothes, and Letter in the Word folder. Scan a photo of yourself (alone or with others) to your flash drive or e-mail it to yourself. Be sure to have your student ID number with you for next class. Study for quiz on Word (concepts through Tutorial 3).
February 14	Word 4/Front Page/Word Quiz WORD Tutorial 4 Practice (Convert). Review Assignments 1-23, p. 174-175; right click and save Travel, Highlights, and Addresses in the Word folder. (Note that the last file is named addresses2 on the server to distinguish it from the earlier file named addresses.) Print a copy of one merged letter. Create a basic web page with FrontPage. This is the guide we will use in class to begin work on the page. Your actual assignment differs slightly from this guide. We have also provided some other information about using FrontPage with a flash drive or a floppy disk. Take quiz.	Study for the exam on word. Use this list of topics covered in the tutorials for guidance. (Four training sessions are also available through SAM.) Review Excel Tutorial 1. Excel 1, pp. 3-43. Print the Dalton workbook as directed. (You don't need to turn this in, but this time it is worth "wasting the tree" to see how it will look.)
February 21	Word Exam/Excel 1 Tutorial 1 Practice. Do all of the steps. Case 1, p. 46, 1-13. Right click and save Altac1 in Tutorial 1 folder on your disk. Hand in three sheets - documentation sheet, worksheet with values, and worksheet with formulas. Take Word Exam (SAM)	Excel 2, pp. 51-73. Right click and save Budget1 in Tutorial 2 folder on your floppy disk. Print the worksheet once with data and once with formulas. Add a footer with your name. This is homework and will be collected. Excel 2, pp. 74-85. Continue with Budget2, created in the first session of Tutorial 2. Print Budget 3 worksheet once with data and once with formulas. Add a footer with your name. This is homework and will be collected.
February 28	Excel 2 Download the Sales file for in-class practice. Case 2, p. 88, 1-8, Sales1. Include a footer with your name. Do not print the documentation sheet. Print the worksheet twice, once with values and once with formulas. Change orientation and/or resize columns and margins as needed to fit on one page. Case 2, pp. 88-89, 9-21, (Works1). Include a footer with your name; do not print the documentation sheet. Print the worksheet twice - once with numbers and once with formulas. Change orientation and/or resize columns and margins as needed to fit on one page.	Excel 3, pp. 95-135. Right click and save Sales1and Back in the Tutorial 3 folder on your disk. Print as directed in the Tutorial. This is homework and will be collected. Excel 4, pp. 145-186. Right click and save Excel Tutorial 4 (Vega1) and (Space). Print each chart that you created. This is homework and will be collected.
March 7	Spring break	Nothing to do (other than the above)
March 14	Excel 3 Practice Worksheet Case 4, pp. 142-143, 1-8. You create the Payroll1 workbook. Print the worksheet twice, once with values and once with formulas. Include a footer with your name. Excel 4 (Use of Charts) Practice Worksheet Case 4, pp. 190-191, 1-9. You create the BCancer workbook. Do not print the documentation sheet.	Study for Excel Quiz Integrating Microsoft Office 2003 Tutorial 1, pp. 1-20. LHCGrowth, LHCLetter, LHCServiceReferrals Here is a primer on Object Linking and Embedding. Access 1. Create a folder on your flash drive named Tutorial. Download the file Seasonal. Complete Access Tutorial 1. Print p. 1 of the Employer table, p. 1 of the Employer List query and p. 1 of the Employer List report. This is homework and will be corrected. BONUS ASSIGNMENT: A grade sheet for CS 120
March 21	Grade Computation Worksheet Integrating Applications, Review, p. 21-22, #1-18. LHCMemo, LHCServicesDistribution, LHCGrowthUpdated Access Tutorial 1 Review (seasons), pp. 29-30, 1, 2, 4-9. Save in Review folder. Include your last name in the title of each object created, e.g. Employers (Levine). Print the first page (only) of each of the three objects. Excel Quiz	ACCESS Tutorial 2 You create the database (Northeast) for the tutorial and copy/import files nejobs and seasonal (continued from Tutorial 1). Create/save Northeast on your flash drive. We will use the Northeast database in class on March 28.
March 28	Access 2 Complete Tutorial 2; print and hand in p. 1 of the three tables you created (Employer, NAICS, Position). This is homework and will be graded. Tutorial 2 Review, 1-18, pp. 72-74. You create the database (Recruits). Create and save Recruits in the Review folder. Include your last name in the title of each object created, e.g. Employers (Levine). You copy records from (elsa) Excel Exam	ACCESS Tutorial 3. You use Northeast (that you saved before) again for this tutorial. Include your last name in the title of each query you create.
April 4	Access 3 Practice with Northeast database. Complete Tutorial 3; after you complete the tutorial, print and hand in p. 1 of the 8 queries you created. This will be graded. Tutorial 3 Review, pp. 122-123, 1-12. (Recruits is the database you used in Tutorial 2). Design (p. 40) and create a personal addressbook. Create/save the database on your flash drive. You will need this database for class 4/18. You will be unable to complete the assignment without it.	Access Tutorial 4. You use Northeast in the Tutorial folder again for this tutorial. You will need globe.
April 11	Complete Tutorial 4; print the form (Employer ID 10185) and report (p. 1) as directed. This will be graded. Tutorial 4 Review, pp. 161-162, 1-14. Recruits in the Review folder (continued from Tutorial 3). You will need travel. NOTE: THIS WORK IS DUE AT THE BEGINNING OF OUR NEXT CLASS (April 18) PowerPoint notes PowerPoint assignment Take Access Quiz	Integrating Office Tutorial 3 Read through the tutorial. LHCLetter2, LHCMostRequested, LHCOutline, LHCPresentation, LHCServices, SocialWorkContacts. Be sure to bring addressbook (see April 4) to class on April 18. STUDY for the ACCESS Exam. As part of your studying, you may complete Case Problem 1 on page 163. If you do so and turn it in at the beginning of class on April 18, you will receive up to five bonus points. (videos, events, camcord).
April 18	Integrating Tutorial 3 . Create a mailing query from your addressbook. Print the query. Review, p. 3.21, 1-24. Use the addressbook query as the data file in step 4. Use Avery standard 5160; print the labels. LHCEmployeesOutline, LHCEmployees, LHCGrowth2, LHCServices Take Access Exam	Prepare PowerPoint presentations Print ONE copy of handouts (six per page) and bring them with you to the presentations next Tuesday. These MUST be submitted at the beginning of class.
April 25	Powerpoint presentations

Final Exam time: Self-scheduled; details announced in class.