Syllabus

CIS 100‎ > ‎

Course Description

This is an introductory course in computer concepts. It is required of most college graduates in general. The purpose of the course is to provide the necessary computer literacy that would enable the students to function effectively in today's digital world. The focus is on general computing from an individual and enterprise perspective. The emphasis is placed on both the theory and practice of personal and business computing that is essential for all majors of business.

The course is composed of two components, namely a lecture component and a lab component. Hardware, software and system concepts are covered in the lecture component. The lab component is essentially a series of hands-on laboratory sessions designed to familiarize the students with Microsoft's Office suite of software. Each week, equal amount of time will be allocated to the lecture and lab components.

The syllabus for both components is outlined below.

Weekly Plan

Lecture Section

Week	Chapter	Topic
1	1	Introduction to Computers
2	2	The Internet and the WWW
	3	Application Software
3	4	The System Unit
4	5	Input and Output
	6	Storage
5	7	Operating System and Utility
6		Midterm Examination
7	8	Communications and Networks
8	9	Database Management
	10	Security, Ethics and Privacy
9	11	System Development and Programming Languages
10	12	Enterprise Computing.
11		Final Examination

Lab Section

Week	Chapter	Topic
1	OS1	Introduction to Windows Operating System
2	W1	Creating and Editing a Document
	W2	Creating a Research Paper
3	W3	Creating a Cover Letter and Resume
	W4 (Web)	Creating a Web Page Using Word
4	E1	Creating a Worksheet and an Embedded Chart
	E2	Formulas, Functions, Formatting and Web Queries
5	E3	What-if Analysis, Charting and Working with Large Worksheets
	E4 (Web)	Creating Web Pages Using Excel
	X	Mid-term Review
6		Mid-term Examination
7	A1	Creating and Using a Database
	A2	Querying a Database
8	A3	Maintaining a Database
	A4 (Integration)	Sharing Data Among Applications
9	P1	Creating and Editing a Presentation
	P2	Creating a Presentation with Illustrations and Shapes
10	P3 (Web)	Creating Web Pages Using PowerPoint
	X	Final Review

Learning Outcome

Lecture Section

Upon completion of the lecture section, the students will be able to:

identify the basic hardware and software components used in building applications in an organization.
understand the functioning of the computer at the system level, namely at the operating system level.
grasp the multitude of uses of microcomputers for personal productivity.
understand the importance of computer communications and its many applications in today's digitally connected world.
fathom the process of developing applications that includes an early exposure to different types of programming languages and tools used in application development.
comprehend the important role played by computers in the society and the relevant issues that relate to ethics, security and privacy.
interrelate the components of Information Systems that interact and work together to facilitate the effective functioning of enterprise level IT applications.
understand the functions and feature of Intranet, Extranet and Internet.

Lab Section

Upon completion of the lab section, the students will be able to:

basic operations of the Windows operating system

creating and editing a word document
writing a research paper based on the MLA documentation style with citations, footnote, bibliographical list etc. using the features provided in Word
writing a cover letter, resume and an addressed envelope using Word
creating a worksheet with charts and performing calculations on data using Excel
using formulas and functions to calculate average, maximum etc. and performing similar calculations using Excel
performing what-if analysis, creating 3-D charts and formatting a worksheet using Excel
developing and using a database by creating tables, storing data in tables and querying the table using Access
Querying, retrieving and displaying data based on a variety of retrieval criteria using Access
Maintaining a database by storing and updating the data using forms and by employing validation rules in Access
Creating, editing and presenting a PowerPoint slide show
Including illustrations and shapes in a PowerPoint presentations
Incorporating various video and audio effects in the presentation

Assessment and Letter Grade

There will be two examinations conducted, a midterm and a final examination. Both examinations will be conducted in the lecture hall. The cumulative score on which the letter grade is based will be composed of contributions from the midterm examination, final examination and from the points received for the lab work. The approximate percentage contribution from each component towards the final score is as follows:

Section	Component	Contribution
Lecture	Midterm	30%
	Final	30%
	Lecture Total	60%
Lab
	Midterm	20%
	Final	20%
	Lab Portfolio	TBA
	Lab Total	40%

Revised Contribution

Component	Contribution
Midterm	35%
Final	45%
Lab Attendance	10%
Lab Portfolio	10%
Total	100%

The contribution from the lab component may be adjusted to reflect the material covered during the quarter.

The final letter grade will be assigned based on a curve representing the cumulative score distribution of the students in the class.

Mid-Term Examination

The midterm examination will be held on the sixth week during regular class hours in the lecture hall.

The test will be composed of multiple-choice questions divided into two parts. The examination is divided into two parts. The first part will cover the lecture component and the second part will cover the lab (recitation) component. There will be a total of 100 questions of which the first 60 questions will come from the lecture component and remaining 40 questions will come from the lab complement. The questions will be based on the material covered in the previous five weeks. The midterm examination will be a closed-book examination. The chapters included in the midterm examination are as follows:

Chapter	Topic	Questions (Approximate)
1	Introduction to Computers
2	The Internet and the Worldwide Web
3	Application Software
4	The Components of the System Unit
5	Input and Output
6	Storage Unit
	Total

Final Examination

The final examination will be held on the date and time printed on the Class Schedule. The duration is 2 hours and 30 minutes. Emphasis will be placed on the material covered after the midterm examination. The examination format will be similar to the midterm examination. Again, there will be 100 questions with 60 questions drawn from the lecture component and the remaining 40 questions drawn from the lab component. The final examination will also be a closed-book examination. The chapters included in the final examination are as follows:

Chapter	Topic	Questions (Approximate)
7	Operating Systems and Utility Programs	12
8	Communications and Networks	15
9	Database	5
10	Computer Ethics, Security and Privacy	11
11	Information Systems Development of Programming Languages	10
12	Enterprise Computing	7
	Total	60

Examination Schedule

Midterm - Sixth week during regular lecture hours.

Final - As indicated in the University Schedule.

Policy on Make-up Examination

A make-up examination will not be offered except under extreme and compelling conditions of personal distress. Unfortunate circumstances relating to you or to an immediate family member may be considered only with appropriate documentation. Excuses will not be accepted during the week immediately preceding the midterm or final examinations. In this case, any request for the assignment of an incomplete grade will automatically be rejected.

In the extreme event that a make-up examination is conducted, the penalties assigned due to the delay in conducting the examination will be as follows:

Examination Delay Penalties

1 Week 15%
2 Weeks or more 25%

No examination will be conducted prior to the scheduled examination dates. There will not be a make-up examination conducted for the final examination.

Text Book

Delivery of Instruction

This evolving website will play an important role in disseminating course related information. In-class meetings may be reduced by a certain length of time to enable the students to take full advantage of Technology Mediated Learning (TML) facilitated by this website and the future release of multimedia instructional modules.

References

There are no suggested references except for those provided during the course of the lectures.

Student ID and Enrollment

Students are required to carry a student ID with them at all times, both during regular class meetings and during examinations.
Students not enrolled in the class will not be given a grade even though they sit for examinations and complete their lab assignments. A grade change request will not be entertained in this case.

Summary

Information about the course will largely be disseminated through this website
Duration of class meetings may be reduced by an appropriate length of time to facilitate Technology Mediated Learning (TML)
The cumulative grade is composed of individual grades received in the midterm and final examinations and a grade assigned to the lab report
The letter grade is assigned based on a curve depicting the cumulative score distribution of the students in the class
The lab instructors are responsible for assigning the grade
Each examination is composed of two parts, one representing the lecture component and the other representing the lab component
There are normally 100 multiple-choice questions in each examination
The first 60 questions will relate to the material covered in the lectures and the last 40 questions to the material covered in the labs
The midterm examination will be held on the 6th week of the Quarter
The midterm examination will cover the material presented in the first five weeks of lectures and lab sessions
The final examination will be held on the date and time printed on the class schedule obtained from the following link: http://www.calstatela.edu/academic/registrar/finals.htm
The final examination will mostly cover the material presented in the last five weeks of lectures and lab sessions
A make-up examination is not normally offered