|
|
CIS 100 LAB - Business Computer Systems
|
Instructor
Dr Jose Perez-Carballo
Office: ST-608
Email: jperezc at calstatela.edu
For office hours and class shcedule please see: http://www.calstatela.edu/faculty/jperezc/
Course Description
Introduction to Computers (4 units). History of computers; hardware, software including , Windows,word processors, spreadsheets, and data base , programming languages; social and ethical implications.
Required Text:
Shelly, Cashman, Vermaat "Discovering Computers Fundamentals shrinkwrapped with Office 2003 Intro 5th edition Course Technology 142393993X
Additional Resources:
Goals and Objectives
- Provide the student with a introductory understanding of computer hardware and system software
- Form a foundation of technical knowledge for Internet, MS Windows, etc.
- Develop Microsoft Office knowledge
- Develop good IS/IT knowledge
Requirements and Grading
- 50 % of CIS100 Lab
- 50% is from CIS100
Exams
There will be one mid-term and one comprehensive final exam.
Exams are closed book, closed notes, no computers. Topics to be on exams will be covered in class discussions and completely defined before each test.
Grades
Grades for the lab section will be assigned based on the following weights:
| Class Activities (Lab work, Attendance, Participation in Class) |
20% |
| Homework assignments |
40% |
| Midterm |
20% |
| Final |
20% |
Letter Grades
Letter grades will be assigned using the following scale:
Letter
|
Percentage
|
| A |
93-100 |
| A- |
90-92.9 |
| B+ |
87-89.9 |
| B |
83-86.9 |
| B- |
80-82.9 |
| C+ |
77-79.9 |
| C |
73-76.9 |
| C- |
70-72.9 |
| D+ |
67-69.9 |
| D |
63-66.9 |
| D- |
60-62.9 |
| F |
0-59.9 |
Policies
Students are expected to attend every class session. Since Computer Hardware and Software concepts are presented during class time, class attendance is essential for successful completion of assignments and tests. Since a large part of the course involves work on Computer Hardware and Software, it is essential that you utilize the time in class for discussion and exercises on the computer and applications. If you don’t, you would not catch up the class and then you would fail. If attendance is not possible for one of the class meetings, please contact the instructor beforehand.
Students are expected to use the equipment of the computer labs at CSULA.
Students who have a strong background and experiences in Computer Hardware and Software and feel they do not need to attend should speak with the instructor and make special arrangements.
Late Work
Late work will not be accepted.
Tentative Schedule
| Week 1: Course Overview and Syllabus |
Reading Assignment / Homework |
| Week 2: Windows XP and Office 2003 1. Introduction to Microsoft Windows XP and Office 2003 Word 2003 1. Creating and Editing a Word Document 2. Creating a Research Paper |
|
| Week 3: Word 2003 3. Creating a Resume Using a Wizard and a Cover Letter with a Table Web Feature: Creating Web Pages Using Word |
Windows assignment due |
| Week 4: Excel 2003 1. Creating a Worksheet and an Embedded Chart 2. Formulas, Functions, Formatting, and Web Queries |
Word assignment due |
| Week 5: Excel 2003 3. What-If Analysis, Charting, and Working with Large Worksheets Web Feature: Creating Static and Dynamic Web Pages Using Excel |
|
| Week 6: Midterm Exam |
Excel assignment due |
| Week 7: Access 2003 1. Creating and Using a Database 2. Querying a Database Using the Select Query Window |
|
| Week 8: Access 2003 3. Maintaining a Database Using the Design and Update Features of Access Integration Feature: Sharing Data among Applications |
Access assignment due |
| Week 9: PowerPoint 2003 1. Using a Design Template and Text Slide Layout to Create a Presentation 2. Using the Outline Tab and Clip Art to Create a Slide Show |
Access assignment due |
| Week 10: PowerPoint 2003 Web Feature: Creating a Presentation on the Web Using PowerPoint |
|
| Week 11: Final Exam |
PowerPoint assignment due |
|
