California State University Dominguez Hills

College of Business Administration and Public Policy

CIS270- Information System/Tech Fundamentals

Summer 2007

MW 6:00 - 9:50 pm Room Wh-C155

Instructor:

Name: Mohammad Eyadat, Ph. D.

Email:

Website: http://www.csudh.edu/eyadat

Office

Location: EAC-806

Phone Number: (310) 243-2132

Hours: MW 5:00 - 5:55 PM, after each class, by email, and by appointment

Department: CIS

Location: SBS-D325

Phone number: (310) 243-3525

Catalog Description

and Prerequisites:

This course provides an introduction to information technology, systems concepts, and application software. It covers system components and relationships, cost/value and quality of information, and package software solutions. It includes Basic skills related to operating systems, word processing, spreadsheet software, and Internet.

Prerequisites: None

Required Textbook:

·  Computer Concepts 9th edition. By J. Parsones and D. Oja. 2006. Course Technology. http://www.course.com/np/concepts9/

·  Microsoft Word 2003, Brief Edition. By S. Zimmerman, B. Zimmerman, and A. Shaffer. 2006. Course Technology.

·  Microsoft Excel 2003, Brief Edition. By J. Parsones, D. Oja, and R. Ageloff. 2006. Course Technology.

·  Microsoft Access 2003, Brief Edition. By J. Adamski and K. Finnegan. 2006. Course Technology.

·  Integrating Microsoft Office 2003. By R. Romer. 2006. Course Technology.

·  HTML Second edition, By E. Reding and S. Vodnik. 2006. Course Technology.

Student Learning Objectives:

The students will be able to:

·  describe the purpose and functioning of information systems encountered in everyday life (e.g., ATMs).

·  define and describe a computer as well as basic hardware and software components and implementations.

·  demonstrate knowledge of commonly used information systems terminology (e.g., browser).

·  compare and contrast various types of computers in terms of size, capability, and application

·  demonstrate awareness of the pace and direction of progress in communications, electronic storage and computing power.

·  use the basic features of the Windows environment.

·  create and maintain basic Word documents by using MS-Word software.

·  create and maintain basic electronic spreadsheets using Ms-Excel software and its various functions.

·  create and maintain a database with its basic objects using MS Access.

·  demonstrate navigating the Web.

·  distinguish between different Internet applications including email: how they work and how they are used.

·  create and maintain a simple home page by using HTML.

·  utilize the searchconcepts used in libraries and databases.

·  demonstrate awareness of the social implications of information technology (e.g., security and privacy).

·  describe the interaction of communications and computers as related to remote transaction processing.

·  describe the role of programming language and software engineering

·  explain the process of planning, coding, and testing a computer program

Note: Objectives related to each topic will be addressed at the beginning of each class.

Course Expectations and Policies:

·  Course Expectations: Each student is expected to read the assigned material and prepare the written assignments prior to class. The university standard for course workload is two hours of outside work for every hour in class, i.e., a 3-unit course requires 6 hours of work outside the classroom, or a total of 9 hrs/week.

·  Attendance Policy: It is expected that students will attend class regularly and participate in the class discussion throughout the term. Attendance and class participation will be used in the final determination of grades and can alter your grade up or down. Students are allowed two excused absences. More than two may result in a lower grade or failure in the course

·  Academic Integrity: Cheating or plagiarism in connection with an academic program or class at a campus is subject to discipline as provided in Sections 41301 through 41304 of Title 5, California Code of Regulations. Please see the University Catalog for further information.

·  Due Dates/Make Up Work: Examinations must be taken as scheduled; Assignments are due when scheduled. Make-ups will be allowed only if the student has contacted the professor before the due date, detailing a serious problem.

Grading

Grades for this course will be based on weighed average of exams, quizzes, and lab assignment scores:

Participation 05%

Hands-On Activities 25%

Case Problems 25%

Exams 45%

Grading Scales: >90% = A, 88-89% = A-,

86-87% = B+, 80-85% = B, 78-79% =B-

76-77% =C+, 73-75% =C, 70-72% =C-

66-69% =D+, 65%=D, 60-64% =D-

<60% =F.

Class Schedule and Reading Assignments

Dates / Topics / Reading Assignments
Week 1 / ·  Computer, Internet, Web, and Email Basics
·  Computer Hardware
·  Introduction to MS Office
·  Word Processing – MS Word / Chapter 1
Chapter 2
MS Word : Tutorials 1 and 2
Week 2 / ·  Computer Software
·  File Management, Virus Protection, and Backup
·  Word Processing – MS Word / Chapter 3
Chapter 4
MS Word : Tutorials 3 and 4
Week 3 / ·  Internet and LAN technology,
·  E-commerce
·  MS Excel / Chapter 5
Chapter 6
MS Excel tutorials 1, 2, and 3
Week 4 / ·  Digital Media
·  The Computer Industry
·  MS Excel (cont'd) / Chapter 7
Chapter 8
MS Excel tutorials 4
Week 5 / ·  Information systems Analysis Industry and Design
·  Databases
·  MS Access / Chapter 9
Chapter 10
MS Access Tutorial 1, 2, and 3
Week 6 / ·  Computer programming
·  HTML / Chapter 11
HTML Tutorials 1 and 2

Exams Schedule

Week / Exam / Notes
Week 2 (June 4th / Test 1 / Chapters 1 and 2
Week 3 (June 11th ) / Test 2 / Chapters, 3 and 4
Week 3 (June 13th ) / Test 3 / MS Word: Tutorials 1, 2, 3, and 4
Week 4 (June 18th ) / Test 4 / Chapters 5 and 6
Week 5 (June 25th ) / Test 5 / Chapters 7 and 8
Week 5 (June 27th) / Test 6 / MS Excel (Practical)
Week 6 (July 2nd) / Test 7 / Chapters 9 and 10

Lab Assignments Schedule

Assignment Number / Topics / Case Problems # / Page # / Page # / Due Date
1 / MS Word 2003
Tutorial 1 / 1 / WD 34 / WD1.36 / Wednesday June. 6th
2 / MS Word 2003
Tutorial 2 / 4 / WD 86 / WD2.45 / Wednesday June 6th
3 / MS Word 2003
Tutorial 3 / 3 / WD 130 / WD3.36 / Wednesday June 13th
4 / MS Word 2003
Tutorial 4 / 4 / WD 181 / WD4.38 / Wednesday June 13th
5 / MS Excel 2003
Tutorial 1 / 2 / EX 47 / EX1.39 / Wednesday June 20th
6 / MS Excel 2003
Tutorial 2 / 4 / EX 91 / EX2.35 / Wednesday June 20th
7 / MS Excel 2003
Tutorial 3 / 3 / EX 139 / EX3.43 / Wednesday June 27th
8 / MS Excel 2003
Tutorial 4 / 1 / EX 187 / EX4.43 / Wednesday June 27th
9 / Integrated MS office
Tutorial 1 / 1 / INT 1.20 / INT 1.20 / Wednesday June 27th
10 / MS Access 2003
Tutorial 1 / 3 / AC 31 / AC1.29 / Monday July 2nd
11 / MS Access 2003
Tutorials 2 / 3 / AC 77 / AC2.40 / Monday July 2nd
12 / MS Access 2003
Tutorials 3 / 3 / AC 125 / AC3.40 / Monday July 2nd
13 / Create Web Pages using HTML / Will be assigned

·  Each student must turn-in a hard copy of each assignment. Also you must keep a soft copy of it which might be collected at the end of the session.

·  Each file in each assignment must be documented by the file title, student name, and course number and section in appropriate format.

·  Documentation is required on all assignments, include at least the following:

Assignment Number, Student Name, Date and, Purpose (Identify what the entire exercise will accomplish)

NOTE:
·  This syllabus is subject to change depending on class progress.
·  The student will be informed if any change in the syllabus, exams’ dates, or any other announcement. http://www.csudh.edu/eyada

Disabled Students Services: Students with verified disabilities are eligible for a variety of support services from the Disabled Services Office. Information regarding special facilities and services available to students with a disability may be obtained from the Director of Disabled Student Services Office, located in WH B-250.

Important reminders:

1.  Since this course is skill based, each student will be expected participate actively in the classroom. Also, each student must spend at least 2 additional hours a week practicing on the computer.

2.  Students must attend every class. Attendance will be recorded at the beginning of each class session.

3.  Students are expected to always be on time.

4.  Lab exercises and lab assignments will be provided weekly, and must be turned-in at the beginning of class on the following Week. See the assignment sheet.

5.  Students must do their own work. The CSUDH policy statement on cheating and plagiarism applies to all students. All work submitted is to be original work, and any one caught cheating will receive an “F: as a final grade.

6.  Turn off all cell phones and pagers before entering class.

Important Dates:

4

Revised on 6/13/2007®Eyadat