CIT100 Introduction to Computers Prerequisites None 3 credits

CIT100 Introduction to Computers - Prerequisites None - 3 credits Spring 2005

Instructor: Kenneth L Moore. Office N457 Phone 724-325-6778

http://web.acd.ccac.edu/~kmoore/

Text Book

Microsoft Office 2003 Volume 1

by Grauer/Barber Prentice-Hall (ISBN 0-13-183852-0)

An introduction to computer concepts, applications, and information systems. Topics include the use of software, such as spreadsheet, database management, graphics, word processing and computer communications via the Internet. Students develop beginning level skills with common applications in order to use a computer as a tool, make informed decisions concerning computer generated information, and obtain basic information systems concepts and terminology to provide a basis for future learning in the field. Students will have substantial hands-on time in both dedicated classrooms/labs and open lab environments. This is a general computer literacy course.

Learning outcomes:

Upon the completion of the activities in this course, the student should be able to:

Discuss the relationship among the various hardware and software components of a computer system including processor, memory, external storage, input/output, systems and application programs.
Use the graphical user interface features of a windows type environment, use file management to find information on the PC (or network file server) and organize data in directories.
Understand and use basic features of word processing, spreadsheet, graphics, and database applications and transfer skills regardless of the specific brand name of the application used in this course.
Understand the basic issues concerning computer communications, access then find information on the Internet using a Web browser; discuss some of the ethical issues associated with computer use.

Grading: There will be 3 exams. Exams will be curved. There is NO final exam. There are quizzes online and practice exams online for homework. Quizzes and practice exams may be retaken to achieve the grade you want. There is a final project. Your grade will be your average on the exams + a letter grade for homework/quizzes + a letter grade for the final project.

Example: Exam 1 C Exam 2 D Exam 3 C avg = C + letter grade for HW/Quizzes -> B + letter grade for final project -> A. Final grade A.

Exams: Exams will be online. They consist of 100 multiple choice and T/F questions. For internet students, you will be given a week in which to take each exam. You may take the exam at home. You are honor bound to do your own test. You must complete the exam in 45 min or you must come in for a proctored make-up exam. Non-internet students will take the exam in class online. Exams will be open book open note - however, do not underestimate these exams. They will be difficult for someone who has not studied and done the assignments.

Schedule

Note: As you read the chapters, do the hands on exercises.

Week:	Reading/Exercises	Homework/Quizzes
1: Jan 24 - Jan 30	Essential Computing Concepts pp 889- pp 943 Getting Started With Microsoft Windows XP pp 1 -> as far as you get.	Essentials of Computing Concepts: Practice Exam Essentials of Microsoft Windows: Practice Exam
2: Jan 31 - Feb 6	Getting Started With Microsoft Windows XP finish to pp 72 The Internet and the World Wide Web pp 825 - pp 887	Essentials of the Internet: Practice Exam Quiz 1 Basic Computer, Internet and Window Concepts
3: Feb 7 - Feb 13	Word: One pp 73- pp119 Word: Two pp 121-pp 174	Chapter 001: WORD: Practice Exam Quiz Word Chapter 1 Chapter 002: WORD: Practice Exam Quiz Word Chapter 2
4: Feb 14 - Feb 27	Word: Three pp 175 - pp 224 Skip Mail Merge. Word: Four pp 125 - pp 255 Except page numbers, headers and footers, skip Long Docs.	Chapter 003: WORD: Practice Exam Quiz Word Chapter 3 Chapter 004: WORD: Practice Exam Quiz Word Chapter 4
5: Feb 28 - Mar 6	EXAM 1 Excel: One pp 281 - pp 344	Chapter 001: EXCEL: Practice Exam Quiz Excel Chapter 1
6: Mar 7 - Mar 13	Excel: Two pp 345 - pp 355 Skip web related sections.	Chapter 002: EXCEL: Practice Exam Quiz Excel Chapter 2
7: Mar 14 - Mar 20	Excel: Three pp 389 - pp 438	Chapter 003: EXCEL: Practice Exam Quiz Excel Chapter 3
8: Mar 28 - Apr 3	Excel: Four pp 439 - pp 496 Know the built in functions AVERAGE, PMT, SUM only. Skip FV, COUNT, IF, VLOOKUP etc. Know Goal Seek.	Chapter 004: EXCEL: Practice Exam Quiz Excel Chapter 4
9: Apr 4 - Apr 10	EXAM 2 Access: One pp 497 - pp 543	Chapter 1: ACCESS: Practice Exam Quiz Access Chapter 1
10: Apr 11 - Apr 17	Access: Two pp 545 - pp 597	Chapter 2: ACCESS: Practice Exam Quiz Access Chapter 2
11: Apr 18 - Apr 24	Access: Three pp 599 - pp 656 Skip Crosstab Queries. Skip Action Queries. Skip Access Chapter Four.	Chapter 3: ACCESS: Practice Exam Quiz Access Chapter 3
12: Apr 25 - May 1	EXAM 3
13: May 3 - May 9	Power Point: One pp705 - pp768 Power Point: Two pp769 - pp824	No homework or quiz. Study for your other finals and work on final project.
May 10		Final Projects Due