La Sierra University

Department of Mathematics & Computer Science

CPTG104 Introduction to Information Systems (4 Units)

Fall 2009


Instructor: Denny Lin

Offices: Thaine B. Price Hall 250 and Information Technology (IT) Modular

Office Phone: (951) 785-2551

Office Hours: Mondays - Thursdays: 11:00AM - 1:00PM

E-mail: dlin@lasierra.edu

Purpose of course: Conceptual basis of computer operations, logic, introduction to use of word processing, spreadsheet, database, and Internet access software. Applications to personal and business problems.

Pre-requisite: MATH007 or secondary school equivalent

Lectures and Labs: 9/21/09 - 12/2/09 Mondays and Wednesdays 1:00PM - 2:50PM, Price Hall 145.

Grading criteria:

A-range - 90% - 100%

B-range - 80% - 89.99%

C-range - 65% - 79.99%

D-range - 50% - 64.99%

F-range - Below 50%

Homework Assignments 10%: 3 homework assignments

Lab Assignments 30%: Textbook projects covered during lectures

Midterm Exams 40%: One hour exams, Monday 10/14/09 and Wednesday 11/2/09

Final Exam (comprehensive) 20%: Two-hour exam, Monday 12/7/09 at 11:00AM

Required textbook:

"Microsoft Office 2003: Introductory Concepts and Techniques", Second Edition by Shelly, Cashman and Vermaat, Thomson Course Technology. ISBN 0-619-25477-7

Class Website:

http://www.lasierra.edu/~dlin/classes/cptg104

Class Policies:

Attendance

It costs $2,628.00 to attend this class, which meets 21 times. In addition to loss in learning, each meeting you miss is $125.14 wasted. Your attendance at every meeting is expected. Four (4) or more unexcused absences from class or lab sessions will result in an F grade. To be excused from a class or lab session due to medical reasons, you must show the instructor a doctor's note documenting the reason(s) for your absence. It is entirely your responsibility to catch up on any material you missed. Your performance on quizzes is used to measure your reading comprehension and attendance; missed quizzes cannot be re-taken.

Late assignments

Lab assignments are late if they are not turned in at the conclusion of the lab session. All late assignments are worth half its value for each day the assignment is late.

Academic dishonesty

All students are expected to read and honor the Academic Integrity Policy, as printed in the University Bulletin. As stated in the preamble, "embracing the principles of Academic Integrity...provides a vital foundation for this community of scholars and its larger society." By attending the University, you have agreed to the following statement: "I will act with integrity and responsibility in my activities as a La Sierra University student. I will not participate in violations of academic integrity, including plagiarism, cheating, or fabricating information. I will not stand by when others do these things. I will follow the academic integrity policy."

While you are encouraged to seek assistance from teachers or your fellow classmates, it is academically dishonest to turn in quizzes, lab assignments, or exams written by someone else. Plagiarism occurs when a writer appropriates another's ideas without proper acknowledgement of the source or uses another's words without indicating that fact through the use of quotation marks. You must give proper credit for any help you receive, clearly stating who helped you, and how, whether it is from a classmate, faculty, friend, or the Internet (cite URL). Failure to give proper credit for expertise and guidance received will be treated as an act of academic dishonesty. Acts of academic dishonesty during exams will result in an automatic failure of the class for all parties involved, and may include further disciplinary action.

Disability

La Sierra University complies with the Americans with Disabilities Act (ADA) and Section 504 of the Rehabilitation Act of 1973. Any student with a documented disability (physical, learning, or psychological) needing academic accommodations should contact the Learning Support and Testing Center (LSTC) as early in the quarter as possible. All discussions will remain confidential. Please contact LSTC (La Sierra Hall, Suite 100, extension 2452) for additional information.

Class Website: Updates to this class syllabus, and Microsoft PowerPoint lecture notes, are posted at: http://www.lasierra.edu/~dlin/classes/cptg104

Tentative Schedule Outline:

Month

Date

Topic

Homework

Labs

Pages

SEP

M 21

Introduction to Computers



COM 1 - 40


W 23

Introduction to Windows XP and Office 2003



WIN 1 - 41


M 28


Lab 1

WIN 41 - 89


W 30

Creating and Editing a Word Document

HW 1

Lab 2

WD 1 - 72

OCT

M 5

Creating a Research Paper


Lab 3

WD 73 - 136


W 7

Creating a Resume and a Cover Letter


Lab 4

WD 137 - 202


M 12

Word Web Feature



WD 203 - 216


W 14

Midterm 1





M 19

Creating a Worksheet and an Embedded Chart


Lab 5

EX 1 - 64


W 21

Formulas, Functions, Formatting, and Web Queries


Lab 6

EX 65 - 143


M 26

What-If Analysis, Charting, and Large Worksheets


Lab 7

EX 145 - 224


W 28

Excel Web Feature



EX 225 - 240

NOV

M 2

Midterm 2

HW 2




W 4

Creating and Using a Database


Lab 8

AC 1 - 64


M 9

Querying a Database Using the Select Query Window


Lab 9

AC 65 - 112


W 11

Removing redundancy in a database


Lab 10

AC 50 - 51


M 16

Access Integration Feature


Lab 11

AC 173 - 192


W 18

Using a Design Template and Text Slide Layout


Lab 12

PPT 1 - 80


M 30

Using the Outline Tab and Clip Art


Lab 13

PPT 81 - 140

DEC

W 2

PowerPoint Web Feature



PPT 141 - 159


M 7

Final Exam (11:00AM - 1:00PM)

HW 3



Last day to withdraw with no record: 10/2/09; last day to withdraw with a "W": 11/13/09


You are visitor number

Main Page | Biography | Project Esther | Computer Tips, Tricks & Tools | Movie Reviews | My Faith | My Car | April | E-mail