HOME PAGE

City Collge of San Francisco

 

Syllabus


MABS 60: Introduction to Microcomputers 3 Units

Prepared by: Glenn Knapp,
Summer 2002, Phelan Campus

COURSE OUTLINE

 

Description:

 

This is the foundation course for computer courses. It is an introduction to computers and their applications, and it includes a general overview of how a computer system operates. The concepts of operating systems, programming languages, and data structures will be introduced. Laboratory activities will include applications in Windows, word processing, spreadsheets, and database. The student will do traditional library research; electronic library resources and computer links from the World Wide Web will be introduced. The Internet/Web Pages will be explored.


Prerequisites: None

Attendance Policy:

 

Three unexcused absences reduce your final grade by one grade point on a four-point scale. Late for class three times will constitute one unexcused absence. The student with four unexcused absences will be dropped from the course.

 

Course Objectives:

 

- To learn about the field of Computer Technology.

 

- To understand how to use computers to solve problems of importance to students in their everyday lives. In particular:


Windows 98
Word 2000
Excel 2000
Access 2000
Internet

- To understand how computers are used in businesses today, and how to develop a research paper from an electronic library (World Wide Web).

 

- To prepare students who are planning on majoring in Business, Accounting, and related areas and for more advanced classes in those majors.

 

- To learn how to use knowledge of computers to get a job.

The class sessions will consist of a combination of lecture and hands-on laboratory activity. Each class (except the first) will have use of Computers. It is possible that assignments can be completed in class, but it may require substantial time outside of class. In addition, homework will be assigned from the book and handouts. There will be a midterm and final exam covering material from the textbook, handouts and lectures. A library project may be assigned. The student will explore Web Pages.


Textbook Required:

Passewark, William R., et al Microsoft Office 2000, Introductory Course, ISBN 0-538-68824-6 (Belmont, Ca.:South Western Ed., 2000).


Schedule:

 
Week 1: 
        Introduction to the Class  
        Lecture:       Course Overview / Hardware / Introduction to Windows98
                       Appendix B and C
INTRODUCTION:
Week 1:
        Lecture:       Office 2000 Basics/Internet  Assignment: Lesson 1
                       assignments(End of Chapter:Questions, Projects, Activities)
ACCESS:
Week 1:
        Lecture:       Access Basics Assignment: Lesson 1
                       assignments(End of Chapter:Questions, Projects, Activities) 
 
Week 1:
        Lecture:       Manipulating Data Assignment: Lesson 2
                       assignments (End of Chapter:Questions, Projects, Activities)
 
Week 1:
        Lecture:       Creating/Modifying Forms Assignment: Lesson 3
                       assignments(End of Chapter:Questions, Projects, Activities)
 
Week 2:
        Lecture:       Finding/Ordering Data Assignment: Lesson 4
                       assignments (End of Chapter:Questions, Projects, Activities)
 
Week 2:
        Lecture:       Reports/Macros Assignment: Lesson 5
                       assignments (End of Chapter:Questions, Projects, Activities)
 
Week 3:
        Lecture:       Integrating Access Assignment: Lesson 6
                       assignments (End of Chapter:Questions, Projects, Activities)
 
EXCEL:
Week 3:
        Lecture:       Excel Basics Assignment: Lesson 1
                       assignments(End of Chapter:Questions, Projects, Activities)
 
Week 3:
        Lecture:       Changing Worksheet Appearance Assignment: Lesson 2
                       assignments(End of Chapter:Questions, Projects, Activities)
 
 
Week 3:
        Lecture:       Organizing Worksheets Assignment: Lesson 3
                       assignments(End of Chapter:Questions, Projects, Activities)
 
Week 3:
        Lecture:       Worksheet Formulas: Lesson 4
                       assignments(End of Chapter:Questions, Projects, Activities)
 
Week 4:
        Lecture:       Function formulas Assignment: Lesson 5
                       assignments(End of Chapter:Questions, Projects, Activities)
 
Week 4:
        Lecture:       Making Worksheets Useful Assignment: Lesson 6
                       assignments(End of Chapter:Questions, Projects, Activities)
 
Week 4:
        Lecture:       Working With Software Tools Assignment: Lesson 7
                       assignments(End of Chapter:Questions, Projects, Activities)
 
Week 4:
        Lecture:       Worksheet Charts Assignment: Lesson 8
                       assignments(End of Chapter:Questions, Projects, Activities)
 
Week 5:
Midterm     TBA
 
WORD:
Week 5:        
        Lecture:       Word Basics Assignment: Lesson 1      
                       Assignments (End of Chapter:Questions, Projects, Activities)
Week 5:
        Lecture:       Basic Editing Assignment: 2
                       Assignments (End of Chapter:Questions, Projects, Activities)
Week 5:
        Lecture:       Basic Formatting Assignment: Lesson 3
                       Assignments (End of Chapter:Questions, Projects, Activities)
Week 5:
        Lecture:       Controlling Text Assignment: Lesson 4
                       Assignments (End of Chapter:Questions, Projects, Activities)
          
Week 6:
        Lecture:       Helpful Word Features Assignment: Lesson 5
                       Assignments (End of Chapter:Questions, Projects, Activities)
Week 6:
        Lecture:       Working With Documents Assignment: Lesson 8
                       Assignments (End of Chapter:Questions, Projects, Activities)
 
Week 6:
        Lecture:       Desktop Publishing Assignment: Lesson 6,7
                       Assignments (End of Chapter:Questions, Projects, Activities)
 
 
Week 6:
       Lecture:   Web Pages
 
Week 6:
       Lecture:   Web Pages/Final Review 
 
 
Week 6:           FINAL EXAMINATION  TBA 
 

Grading:

 

            Homework and programming exercises:      15 percent

            Project (Web Page)                                          5 percent

            Midterm:                                                        20 percent

            Final exam:                                                     50 percent

            Participation:                                                  10 percent

 

 

 

Special Project or Incentive For Earning Extra Credit:

 

Extra credit is available to all students at the election of the instructor.  The extra credit incentive can be in the area of critical thinking and computer technology/communication.  The instructor must approve topics.

 

Research Tools:


http://gknapp.tripod.com/GLENN108.HTML [JAVA]
E-Mail:
gknapp@knapp-phd.com



Late work without a valid excuse will be graded-down one grade.


Research Engines:

http://www.google.com

http://fog.ccsf.edu/~gknapp


Special Project or Incentive For Earning Extra Credit:

Extra credit is available to all students at the election of the instructor. The extra credit incentive can be in the area of critical thinking and computer technology/communication. The instructor must approve topics.