Make your own free website on Tripod.com

 

 

 

 

 

 

 

 

CS205 COURSE SYLLABUS

Computer Literacy and Office Automation

Instructor: Joe Sunday

JosephJSunday@Hotmail.com

237-0985

 

COURSE OBJECTIVES:

·        To understand basic computer operations and the principal components of a computer and connected peripheral devices

·        To understand and examine current operating systems, software utilities, device drivers and application software

·        To define and understand current storage technology and learn about logical file storage and management

·        To become proficient in using:

      -Windows

      -Word Processing Applications

      -Spreadsheet Applications

      -Database Applications

      -Presentation Graphics Applications

·        To understand the basics of e-mail.

·        To introduce networking concepts including the Internet and its components and web browser basics

·        To learn ways to protect your data and avoid computer disasters

 

The course is divided into 7 modules and may be presented in the following order:

1)      Computer Concepts

2)      Introduction to the Internet including e-mail and newsgroups

3)      Introduction to Windows

4)      Word Processing

5)      Spreadsheets

6)      Database

7)      Presentation Graphics Software

 

The following software is used in the 320 Oleman lab:

-    Microsoft Windows 2000

-         Microsoft Office XP Professional suite

-         Internet Explorer

 

REQUIRED TEXTS:

Computer Concepts 4rd Edition by June Jamrich Parsons and Dan Oja

Microsoft Office XP Introductory Concepts and Techniques by Shelly, Cashman and Vermaat

 

Note:  You are responsible for purchasing the books and bringing them with you to class.  Books for loan are not available in the classroom and lab.

 

You must also have the following material:

5 blank high-density diskettes (1.44 MB)

1 diskette carrying case – optional

1 notebook to keep your work

 

 

DISABILITY SERVICES:

Students with special needs should make the Instructor aware of any requirements needed to complete CS205 during the FIRST WEEK OF CLASS. 

 

320 Oelman OPEN LAB HOURS:

If you do not finish your assignments during class time, you may use the lab during the listed open lab

 

Monday & Wednesday                        12:15 – 1:00 PM

Monday & Wednesday                        3:00 – 6:00 PM

Saturday*                                             1:00 – 6:00 PM

 

*  Weekend hours will begin the second weekend after classes begin and end on the last day of classes.  During the weekend, the only open door to Oelman is next to the student lounge area.  Summer hours may be different.  Also remember to visit the labs in the library annex or 152C Russ Eng building.

 

SAVING DATA:

All data generated by applications in 320 Oelman must be saved to your local diskette drive (drive A).  You should save often – do not wait until you are finished (there is always a risk of something going wrong with the computer).  Data saved to the local hard drive may not be recoverable after you log out.  If you save your files to the C drive, they may be deleted when the cleaning program is run.

BACKUP POLICY:

You are responsible for maintaining a backup copy of your assignments. Keep a copy on a separate disk

 

NETWORK DRIVES TO REMEMBER:

   Drive U: is a network drive.  Each section has a folder identified by “sect0x” under U:\CS205.  Example: students enrolled in CS205-section 09 can find files that may be placed there by the Instructor at U:\CS205\sect09.

 

LABORATORY POLICIES FOR 320 Oelman

1)      Do not modify or add files to the hard disk on the computers.  You are responsible for saving your work to your personal 3.5", 1.44MB diskette, not to the C drive (hard drive) on the computers.  If you save your files to the C drive, they may be deleted when the cleaning program is run.

2)      You are responsible for doing your own work.  You are not to make copies of files for others or accepting others files from others. Be aware that there are computer viruses. 

3)      You must follow all lab guidelines.  Academic misconduct procedures will be followed.  Refer to the following web site for a listing of the Academic Integrity Guidelines.  http://www.wright.edu/students/judicial/stu_integrity.html

4)      Refer to the following web site for a complete listing of Responsible Use of Information Technology Guidelines for the rules on Internet use at the university.  http://www.wright.edu/students/handbook/03_22.html

5)      Regarding all work to be turned in.  Label all work, such as print outs and diskettes with YOUR NAME and SECTION NUMBER, and the ASSIGNMENT.

6)      Do not use the computers during the lecture, unless instructed to do so by the instructor.  YOU SHOULD NOT BE WORKING ON HOMEWORK DURING LECTURE.

7)      While in the CS205 lab, the printers are to be used for CS205 assignments only.  Do not print any assignment or any other document unless instructed to do so by your instructor.  For CS205 printed assignments print 1 copy only.  Don’t waste your time – check the print preview first.  This will give you an indication of what the final product will look like.

8)      Computers are electrical. Watch where you put your feet and hands.  The computers are connected to the network and electric outlets by cables that can become unplugged if moved.  Do not move the computers or printers.  By kicking a cable you may loose you work.

9)      When finished working on your PC, please follow proper shutdown procedures.  Please be sure to turn off both the monitor and the central processing unit.

10)  No eating, drinking, smoking, or chewing gum at the computers.  Drinks with twist lids are allowed at the front of the room.  Label your drinks

11)  Making unauthorized copies of the software is prohibited and academic misconduct procedures will be followed.

12)  Notify the instructor or proctor of any hardware malfunction.  Do not attempt to correct the problem yourself.  This applies to all hardware in the lab, especially while USING THE HP LASERJET 4 PRINTERS.  Do NOT attempt to correct problems yourself, including paper out or paper jam problems.  Do NOT print during lectures.

13)  If you don’t have a floppy disk, see the instructor.  Don’t disturb the other working students.

 

 

CS205 WAIVER APPLICATION

If you feel that you are already proficient in the material covered in CS205, you may apply to waive this class (based on the requirements of your college).  Please check with your advisor. You may pickup a  CS205 waiver  application form in 303 Russ Center.  Note that if you do choose to apply for a waiver, you must remain enrolled in the class while the waiver is processed.  If the waiver is approved, you must then formally drop the class.  With a waiver, you do not receive credit for the course.

 

COURSE EVALUATION:

Each module includes assignments to check your understanding of the presented material.  The assignments each have an assigned due date and the assignments must be turned in at the beginning of that class (before class starts) in order to receive full credit.  Late assignments will not be given full credit…no exceptions.  All assignments should be turned in, even if it is already late.   Please collect and keep all graded assignments for your records. You are responsible for you work until you receive your final grade.

 

 

Exams must be taken at the scheduled times.  If for emergency reasons, you are unable to take an exam on the scheduled date, CONTACT ME PRIOR TO THE EXAM to receive full credit or AS SOON AS POSSIBLE to schedule your exam. You have my e-mail address.  I should hear from you before the next class.  Be prepared to provide supporting documentation on why you are not able to take the exam, per department policy.

 

 

There are surprise quizzes and examinations covering the concepts and applications of each module.  The exams are a combination of written and “hands-on”.

 

Grade Weights:

Lab. Assignments         100 pts.*

Surprise quizzes            100

Attendance                   100

Examination 1               100               * You must complete a minimum of 60% of

Examination 2&3          100                        the assignments for each module to pass

Examination 4&5          100                        the course.

                                    600 pts.  

               

There will be 10 points of extra credit assignments available during the quarter and we will use the following grade scale.

90-100 =A       80-89=B          70-79=C          60-69=D

 


ËËË GRADE/HOMEWORK ASSIGNMENTS: ËËË

 

Follow all the directions and steps carefully (from the syllabus and book)!!!
This is simply a summary – Look at the following pages for detailed instructions.

 

This table is to help you organize your assignments and grades.  Keep this for your records.

Due Dates and Grade will be give to you as we complete each section

Reference the syllabus for updates

 

 

Assignment

Date Due

Grade

Concepts Assignment 1

Fill in from page 29

 

     /4   

Concepts Assignment 2

Fill in from page 61

 

     /4   

Concepts Assignment 3

Indep. Challenge 4 page 94

 

     /1.5

Concepts Assignment 4

Fill in from page 157

 

     /4

Concepts Assignment 5

Internet and E-Mail

 

     /6

Windows Module Assignment 1

From syllabus

 

     /5.5 

Test #1

 

 

     /100

Word Assignment 1

Cases and Places 3 pg WD1.70

 

     /5    

Word Assignment 2

In the lab 2 pg WD2.60

 

     /10    

Test #2 (Word)

 

 

     /50

Excel Assignment 1

In the lab 1 pg E1.58

 

     /5  

Excel Assignment 2

In the lab 1 pg E2.69

 

     /10  

Excel Assignment 3

In the lab 1 pg E3.69

 

     /10  

Excel Extra Credit

Case 1 pg E3.79

 

     /5    

Test #3 (Excel)

 

 

     /50

Access Assignment 1

In the lab 1 pg A1.56

 

     /10   

Access Assignment 2

In the lab 1 pg A2.44

 

     /10  

Access Assignment 3

In the lab 1 pg A3.52

 

     /5  

Access Extra Credit

Case 1 pg A1.62 A2.48,A3.58

 

     /5    

Test #4 (Access)

 

 

     /53

PowerPoint Assignment 1

From syllabus

 

     /10  

Test #5 (PowerPoint)

 

 

     /47

Surprise Quizzes

 

 

 

Attendance

 

 

 

 


Computer Concepts Module   Printed and Online

 

Procedure for Answering Questions:

For these questions you are required to supply typed answers.  Use any word processing software, such as Notepad. WordPad or Word, to record the answers to the questions.  The first items typed in the file should be your name, the assignment number and assignment name and the CS205 with the section number.  Do not worry about formatting the document.  Save and print the document and turn it into the HOMEWORK INBOX at the front of the room.     

 

Assignment 1: Read:  Computer Concepts Book - Unit A

Do:      Fill in the Best Answer on page 29

 

Assignment 2: Read:  Computer Concepts Book - Unit B

Do:      Fill in the Best Answer on page 61

                               

Assignment 3: Read:  Computer Concepts Book - Unit C

Do:      Independent Challenge 4 on page 94

                

Assignment 4: Read:  Computer Concepts Book - Unit E

Do:      Fill in the Best Answer on page 157

 

Assignment 5: Read: Office XP Book – Intro to Computers – Pages COM2 – COM30

 

Note:  To do this assignment on campus, you must obtain your Wright State student account from Computing and Telecommunications Services.  All WSU students are assigned accounts.  You will need to pick up the account information at the CATS help desk in the basement of the Library Annex. (Room 025) – bring a picture ID.

The mail reader used here on campus is http://webmail.wright.edu

 

Part 1 -       Turn to the last page of the COM chapter, find LEARN IT ONLINE.  Read the Instructions. As stated in the instructions in the book you will be using the website www.scsite.com/off2002/exs.htm and you should print your answers.  Open this web site. Follow the instructions in question 1.  Then do on the Multiple Choice and Short Answer part.  Then do question 5 at the end of the chapter . 

                 

Part 2 -      Look through web sites to find the computer system you would personally want to purchase.  Some popular manufacturers that you are likely to find on the web are Dell, Gateway, IBM and Apple or web sites for stores like BestBuy, CompUSA or Target.  You are not limited to these vendors.   E-mail me the web page that shows the information about the computer you chose.  Send the e-mail to me and in the body of the e-mail include your full name and the reason you choose the computer that you did.


Windows Module (1 assignment worth 5.5 points) – Written

 

 

Read:   Computer Concepts Book - Unit D

Microsoft Office – Introduction to Windows pages INT 1.04 – 1.61

 

Part A:

In the Concepts book, look at the file organization options in Question 1 of Independent Challenge 3 on page 126.  Consider the hard disk methods given in options a – g and choose the method that you like best and write a paragraph on the advantages and disadvantages of that method.

 

Part B:

Type in the definitions, instructions or step by step procedures for each of the following.

 

1)       What is an active and inactive window

2)       What is a path of a given file – include an example

3)       How do you show file properties

4)       What are the different views in Windows Explorer

5)       How does a file become fragmented

6)       What does a file that has an exe or com extension do

7)       Define the terms Byte, KB, MB, GB

8)       Define the terms root, subdirectory and file

9)       How do you do a proper shutdown of Windows

10)    How do you change a file name

11)    How do you erase files

12)    How to select a series of adjacent files from a list

13)    How to select a series of non-adjacent files from a list

14)    How to move and copy files from a drive/folder to another

15)    How to maximize, minimize and restore a window

16)    How to Format a disk

17)    Find (or search) for a specific file

 

 

Procedure for Printing Future Assignments:

All future printouts must have a required “header” and “footer”.  The header must have your name and the assignment number.  The footer must have your section number and the current date.  This required information can be positioned anywhere across the top and bottom of the page.

Note:   If you complete the homework assignments outside of the CS205 lab, the files must be in a format readable by Office XP.  You are responsible for presenting the files in a readable format!

 

Word Processing Module (2 assignments totaling 15 points) – Printed

Assignment 1: Read:  Microsoft Office - Word Project 1

Do:  Cases and Places 3, page WD 1.70

The finished results should be similar to the example in the chapter and must be on one page.  You must use each of the topics learned in this chapter and lecture (examples: bold, underline, italics, size, bullets….). Be sure to include the required header and footer. 

 

Assignment 2:  Read:    Microsoft Office - Word Project 2 (entire chapter) and 3 (pages 3.49-3.56)

Do:   In The Lab 2, page WD 2.60-2.62 (Part 1: Steps 1-5 and Part 2: Steps 1-5, 7-11)

-         The assignment requires a specific header and you should also include my required header and footer. 

-         In part 2 step 9, also use the help menu to remove the endnote separator.

-        Before part 2 step 11 do the following:  After the last paragraph of text, before the work cited page, insert a table containing a list of application software categories and their use (example: word processing, spreadsheets….).  The table should then be formatted to Classic 1 style and single spaced.  Your finished product will be on multiple pages.  Print the paper and handwrite the number of words, including the footnotes, on the print out.


Spreadsheet Module (3 assignments totaling 25 points) – Printed

*Assignments will not be accepted without “formula printout”*

Make sure that the whole formula is showing.  Points will be taken off if we can not see the whole formula. 

Assignment 1: Read:  Microsoft Office - Excel Project 1

Do:  In The Lab 1, page E1.58

Use the following clarifications for the specified steps provided in the book.

-         Skip step 6 (do not create a chart).

-         In step 7, type the requested information in cells A11:A15.

-         Before you print in step 9, be sure to include the required header and footer.

-         After step 10, display the formulas and then print again.  This formula printout should be in landscape and on one page.

-         Skip step 11 and save the revised spreadsheet.

 

Assignment 2: Read: Microsoft Office - Excel Project 2

Do:   In The Lab 1, page E2.69-2.70

Use the following clarifications for the specified steps provided in the book.

-         In step 3, use the sum function.

-         In step 11, make sure you have the proper header and footer and make sure it prints on one page.

-         In step 12, print the formulas in landscape on one page.

-         Skip steps 13-14.

-         After you are done with the steps in the book, create a 3-D pie chart using the Employee Names and their Net Pay.  Include a title, no legend, and with category name and percentage showing.  Create the chart as a new sheet.  Once it is finished, increase the title font, bold the labels, explode the smallest pie piece and elevate the chart to 50.  Add the required header and footer before printing.

-         Turn in your three printouts.

 

Assignment 3: Read:  Microsoft Office – Excel Project 3

Do:   In The Lab 1, page E3.69-3.71 (Part 1 and 2 only)

Use the following clarifications for the specified steps provided in the book.

-         In step 4, format column B-H to a width of 11.57

-         In step 5, format the assumptions so that they look the same as shown.

-         In step 7, be sure to use the “Absolute Reference Rule of Thumb” that we discussed in class.  Try to create your own formulas using the “math equation in words” given and do not look at the actual formula with cell references that is also given.

-         Before you print in step 10, add the required header and footer.

-         Skip step 11

-         In Part 2, include the required header and footer then print the chart only.

-         After you finish Part 2, go back to the spreadsheet and use the goal seek to determine a margin (cell B24) that would result in a net income in 2009 of $5,000,000.  Print the chart again and on that printout hand write the new margin that the goal seek computed.

 

Extra Credit: (5 points)  Do:  Cases and Places Number 1, page E3.79

There are few specific requirements for this assignment.  You still need the required header and footer.  With the information given in the case calculate the requested information.  You will have two sets of assumptions (% of output for each flower and price for each). You should use absolute references where needed.

Format the worksheet to look professional and print on one page.  Display the formulas and print again (in landscape and on one page).  Print the chart with the required header and footer.

 


Database Module (3 assignments totaling 25 points) – Printed

 

**You MUST use Office XP to complete the Access Assignments**

 

Assignment 1:  Read:  Microsoft Office – Access Project 1

Do:  In The Lab 1, page A1.56

Use the following clarifications for the specified steps provided in the book.

-         Skip steps 4 and 7. 

-         During step 9, when you create the report, include you full name in the title of the saved report.  Print the report.

-         When you are finished with the steps in the book do the following steps:

10)   Open the Product table in datasheet view.  Highlight all of the records.  Copy the records into the “clipboard memory”.

11)   Click on the Start button and open Microsoft Word.  In a new document make the file landscape and insert your required header and footer.  Paste the records from the “clipboard memory” into your Word document.

12)   On the task bar at the bottom of the screen, click on the Microsoft Access button.

13)   Open the Supplier table in datasheet view.  Highlight all of the records.  Copy the records into the “clipboard memory”.

14)   On the task bar at the bottom of the screen, click on the Microsoft Word button.  Paste the records from the “clipboard memory” into the Word document with the other table.  Print the document from Word with both tables (in landscape) and on one page.

15)  Turn in both printouts.

 

Assignment 2:  Read:  Microsoft Office – Access Project 2

Do:   In the Lab 1, page A2.44-2.45 (Continuation of Assignment 1)

DO NOT PRINT EACH STEP!!

Use the following clarifications for the specified steps provided in the book.

-         For each step, where it says to print, you should “SAVE AS” the query onto your disk.  Use the step number from the book to individualize the queries.

-         In step 2, do not use the “Simple Query Wizard”.  Create all queries in Design View

-         Skip steps 3, 7, 11, and 16.  (You should have 10 queries when finished.)

-        When you are all finished, open each query and copy to word as explained in Assignment 1.  You should be able to fit the results of all the queries on 2-3 pages.  Print these pages from Word.

 

Assignment 3:  Read:  Microsoft Office – Access Project 3

Do:   In The Lab 1, page A3.52-3.53 (Continuation of Assignment 2)

Use the following clarifications for the specified steps provided in the book.

-         Skip steps 2, 7, 10, and 14-15

-         Print the contents of the Product and Supplier tables as described in Assignment 1.  Turn in this printout along with your written answers from step 3.

 

Extra Credit: (5 points)  Do:  Cases and Places 1, page A1.62, A2.48 and A3.58

-         In the first chapter, create the tables explained in the book.  You will have one table for the clients and another table about the helpers.  After you have all of the data entered you will print the tables using the same instructions given in Assignment 1 and using the required header and footer.

-         In the second chapter, create and save 3 of the 6 queries given.  Print the results of these queries as you did in assignment 2.

-         In the third chapter, step (b) create the validation rule asked for and another of your own choice.

-         Print the tables again – using the same instruction in Assignment 1 with header and footer.  On your printouts record the following information:

-         Validation rules - Write on your printout EXECTLY what you typed in as the validation rules.

-         Your analysis of the database requested in step (d).

 


Presentation Graphics Module (1 assignment at 10 points) – On Disk or by E-Mail

 

Assignment 1:  Read:  Computer Concepts Unit F

Microsoft Office – PowerPoint Project 1 and 2

Do:  Create a PowerPoint Presentation on your own:

-         Choose a couple of pages from the Computer Concepts pages listed above, using the topics covered on those pages create a presentation that is at least 5 slides in length.

-         Use whichever template design you want.

-         You must use each of the following four slide layouts (at least one time each) then you can use any other layouts you wish:  Title Slide, Bulleted List, 2 Column Text and Text & Clip Art

-         On the Title Slide, include your name and the section number as the sub-title.  The section number should be a smaller font then your name.  Bold and Italicize your name.

-         Be sure to save the file to your disk often so that you do not loss your information.

-         On at least your 2 column text slide, you must use at least three levels of bullets.

-         On one slide, double space at least one paragraph.

-         On all of the slide, change the first level bullet to a picture of a disk (from the Wingdings Font).

-         On all of the slides, change the Title Font color to a shade of green.

-         Choose one slide and change the background color to something other then what it was originally.

-         Include a header/footer on all slides that contains the date, your name, and the slide number.

-         Relocate your title slide to the end of the presentation.

-         Add an appropriate clipart to your Text & Clipart slide.

-         Choose one transition style and apply it to all of the slides.

-         On your 2 Column Text slide, apply a build effect that is grouped by 3rd level paragraphs.  Apply to both columns of text.

-         Spell check your presentation.

-        This assignment is NOT printed.  When you are all finished, turn in your disk for grading.  Make sure your name and the file name are written on the label of the disk.