Syllabus

Advanced Computer Applications

CPTG-2201

Instructor: Peter Archibong, Ph.D.

For questions or Comments, please contact me at:

Tel: CSU (678) 466-4400

Email: PeterArchibong@clayton.edu

Web: http://cims.clayton.edu/parchibong

Course website: WebCT Vista

Office Hours: Mon & Wed. 7:46PM or by appointment

Class time: MW 6:30 pm - 7:45 pm

Credit Hours: 3

Classroom: LECTURE HALL UC416

Class Website: WebCTvista: https://clayton.view.usg.edu

User-Name: School Email ID

Password: School Email password

Or Contact the HUB for logon help.

I. Course Materials:

Required Two Textbooks:

New Perspectives on Microsoft Office Excel 2007, Introductory, CourseCard Edition June Jamrich Parsons, Dan Oja, Roy Ageloff, Partrick Carey
© 2008; ISBN 10: 1-4239-0584-9; 2008

New Perspectives on Microsoft Office Access 2007, Introductory, CourseCard Edition; Joseph J. Adamski, Kathy Finnegan
ISBN 10: 1-4239-0588-1 2008

Required Software: Microsoft Office Pro. 2007

1. Free download: http://us1.trymicrosoftoffice.com/default.aspx

2. Contact the HUB for free software installation before class begins.

You are expected to have the textbook available at each class and examination session. Book is available in the Bookstore.

II. Course Description:
CPTG2201 Advanced Computer Applications

CPTG 2201 - Advanced Computer Applications (3-0-3) This course provides detailed coverage of common computer software applications used in business and industry. It assumes that the student is conversant with basic computer skills and builds on that base. Emphasis is on the application of advanced features of electronic spreadsheets, word-processing and presentation graphics; the fundamentals of database systems; use of the Internet for research.

Prerequisite(s): Math 1101 (C)

Prerequisite(s): ITFN 1101 (C), MATH 1101 (C), ENGL 1101 (C), CRIT 1101 (C).

III. Course Outcomes:

Students are expected to obtain a developing level of mastery of Advanced Computer Application of Microsoft Office 2003: Microsoft Excel, Microsoft Access. Students will demonstrate an emerging level of knowledge of Microsoft Office 2003. Students should show potential to perform independently. Students should be aware of the skills required for successful Microsoft Office 2003 electronic spreadsheet and Database.

IV. Course Objectives:

The specific objectives that support the outcomes for developing level of mastery from the course are:

Microsoft Excel 2007

Lesson 1: Excel Basics

Lesson 2: Changing the Appearance of a Worksheet

Lesson 3: Organizing the Worksheet

Lesson 4: Entering Worksheet Formulas

Lesson 5: Using Functions

Lesson 6: Enhancing a Worksheet

Lesson 7: Working with Multiple Worksheets and Workbooks

Lesson 8: Working with Charts

Microsoft Access 2007

Tutorial 9 (1): Creating a Database

Tutorial 10 (2): Building a Database and Defining Table Relationships

Tutorial 11 (3): Maintaining and Querying a Database

Tutorial 12 (4): Creating Forms and Reports

Tutorial 13 (5): Creating Advanced Queries and Enhancing Table Design

Tutorial 14 (6): Using Form Tools and Creating Custom Forms

Tutorial 15 (7): Creating Custom Reports

Tutorial 16 (8): Sharing, Integrating, and Analyzing Data

Microsoft PowerPoint 2007:

Project presentation

V. Course Methodology:

A. Student:

. Read and study assigned material.

. Submit all assignments on time.

. Maintain communications with the instructors.

. Attend all classes and participate in classroom discussion.

. Apply knowledge, experience and learning to a critical analysis of current issues, case materials and examinations.

VI. Student Course Requirements:

A. Attendance and Punctuality:

a. Regular attendance and punctuality are expected and necessary to attain maximum success in your studies and your course grades.

b. An absence does not relieve you of your responsibility for examinations, skill building exercises, assignments and/or the submission of any report(s) etc. nor the consequences of a late submission of assignments.

B. Examinations:

a. Examinations will cover materials presented in the textbook.

b. Examinations may have additional questions that offer bonus points for correct answers. They will only be offered for credit during the scheduled exam times and will not be available on any make-up exam.

c. If a scheduled exam is missed, you must contact me within two days. If there is a valid reason for missing, a make-up exam will be scheduled immediately. All make-up exams are comprehensive in nature. Failure to do so will result in a grade of zero for that exam.

d. Incomplete will be given only in rare nonacademic situations.

e. Failure to attend the scheduled final exam will result in a grade of "F".

C. Withdrawal:

a. To be qualified for "WP", you must be doing the necessary work for passing grade and be current in all assignments, examinations, etc. The college has specific policies regarding withdrawals. Consult the current academic catalog for specific policies.

D. Classroom Participation:

a. I encourage you to ask questions to clarify understanding of theories, principles and concepts from the text and materials provided to you. IT IS IMPORTANT that you study the assignments and the textbook on a regular basis.

E. Assistance:

a. Please seek individual assistance from me should you need extra help in understanding any course material.

F. Course Changes:

a. This course syllabus provides general guidelines for the course. I reserve the right to make periodic necessary changes to the syllabus; including assignments, timetables, examinations and projects, etc., in order to accommodate the needs of the class as a whole and fulfill the goals of the course.

VII. Course Schedules:

The following schedule is intended as a guide only. Deviation may be necessary by week, but the materials will be covered in the sequence indicated: Should submit all assignments before due date.

No.

Days

Reading/Lecture

Labs10%

Pages#

Quiz20%

Test20%

Midterm20%

Final20%

Project10%

Day 1

Mon

18-Aug

Introduction

Day 2

Wed

20-Aug

Tutorial1

Quiz1

Day 3

Mon

25-Aug

Lab1

C1EX49

Quiz2

Day 4

Wed

27-Aug

Tutorial2

Lab2

C1EX104

Quiz3

Day 5

Mon

1-Sep

Labor Day

Day 6

Wed

3-Sep

Tutorial3

Lab3

C1EX153

Quiz4

Day 7

Mon

8-Sep

Test1

Day 8

Wed

10-Sep

Tutorial4

Quiz5

Day 9

Mon

15-Sep

Lab4

C1EX208

Day 10

Wed

17-Sep

Tutorial5

Lab5

C1EX273

Quiz6

Day 11

Mon

22-Sep

Tutorial6

Lab6

C1EX327

Quiz7

Day 12

Wed

24-Sep

Tutorial7

Lab7

C1EX385

Quiz8

Day 13

Mon

29-Sep

Tutorial8

Lab8

C1EX444

Day 14

Wed

1-Oct

Test2

Day 15

Mon

6-Oct

Mid .Exam

Day 16

Wed

8-Oct

Tutorial-AC1

Lab9

C1AC38

Quiz9

Day 17

Mon

13-Oct

Tutorial-AC2

Lab10

C1AC89

Quiz10

Day 18

Wed

15-Oct

Tutorial-AC3

Day 19

Mon

20-Oct

Lab11

C1AC146

Quiz11

Day 20

Wed

22-Oct

Tutorial-AC4

Quiz12

Day 21

Mon

27-Oct

Lab12

C1AC191

Day 22

Wed

29-Oct

Tutorial-AC5

Lab13

C1AC251

Quiz13

Day 23

Mon

3-Nov

Test3

Day 24

Wed

5-Nov

Tutorial-AC6

Day 25

Mon

10-Nov

Lab14

C1AC324

Quiz14

Day 26

Wed

12-Nov

Tutorial-AC7

Day 27

Mon

17-Nov

Lab15

C1AC379

Quiz15

Day 28

Wed

19-Nov

Tutorial-AC8

Day 29

Mon

24-Nov

Lab16

C1AC436

Quiz16

Day 30

Wed

26-Nov

Test4

Day 31

Mon

1-Dec

Review

Project

Day 32

Wed

3-Dec

Review

Project

Day 33

Mon

8-Dec

Project

Day 34

Wed

10-Dec

Final

Project

PROJECT GUIDELINE:

You will form a team of minimum three and maximum five students. You will put your heads together to come up with your own scenario: a business problem that you can solve with Excel and Access together. The project needs to be complete and should include the following items: A PowerPoint presentation introducing the team, project plan, and project timeline.
An Access Database containing data that can be manipulated via a well designed user interface and from which relevant reports can be generated.
An Excel file that contains charts, calculations, pivot and lookup tables as appropriate

VII. Evaluation Criteria:

Mid Term Exam 25%

Final Exam 25%

Labs (15) 10%

Quizzes (15) 10%

Tests (5) 20%

PowerPoint Project: 10%

================

Total 100%

**** Evaluation for course participation will be based on timely completion and submission of assignments/projects, participation in all classes, Case study and analysis, reading and studying the assigned materials prior to class.

Please Note:

DISABILITY STATEMENT

Students with disabilities who require reasonable accommodations need to register with Disability Services (DS) in order to obtain their accommodations. You can contact them at 678-466-5445 or disabilityservices@clayton.edu. If you are already registered with DS and are seeking accommodations for this course, please make an appointment with your instructor to discuss your specific accommodation needs for this course and provide your accommodations letter

ITP CHOICE: All students at CSU are required to state that they have on-demand access to a notebook computer that meets the recommended hardware/software specifications that have been established by Clayton State faculty. Academic penalties may be incurred for not meeting this requirement. Refer to the ITP Choice website for specifications and FAQ’s: http://itpchoice.clayton.edu/.

To obtain this document in an alternative format, contact:

Disability Service Coordinator, 678-466-4400 or

developmental disability @clayton.