SRJC Course Outlines

3/1/2024 7:50:56 PMCIS 74.11 Course Outline as of Fall 1999

Changed Course
CATALOG INFORMATION

Discipline and Nbr:  CIS 74.11Title:  MS OFFICE  
Full Title:  Microsoft Office
Last Reviewed:9/10/2018

UnitsCourse Hours per Week Nbr of WeeksCourse Hours Total
Maximum3.00Lecture Scheduled2.0017.5 max.Lecture Scheduled35.00
Minimum3.00Lab Scheduled08 min.Lab Scheduled0
 Contact DHR3.50 Contact DHR61.25
 Contact Total5.50 Contact Total96.25
 
 Non-contact DHR0 Non-contact DHR Total0

 Total Out of Class Hours:  70.00Total Student Learning Hours: 166.25 

Title 5 Category:  AA Degree Applicable
Grading:  Grade or P/NP
Repeatability:  00 - Two Repeats if Grade was D, F, NC, or NP
Also Listed As: 
Formerly:  CIS 82.22

Catalog Description:
Untitled document
An overview of the integrated program Microsoft Office for beginners, including Microsoft Word, Excel, Access and PowerPoint. Students will be introduced to word processing, spreadsheet, database and presentation software. Information will be included on exchanging data between programs. This course is taught using Windows and Mac operating system platforms.

Prerequisites/Corequisites:
Course Completion of CS 105A ( or CIS 105A or CIS 81.5A or BDP 81.5A) OR Course Completion of CS 5 ( or CIS 5 or BDP 5 or BDP 51) OR Completion of CS 101A or higher (CIS1)


Recommended Preparation:
Eligibility for ENGL 100 or ESL 100

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
An overview of the integrated program Microsoft Office for beginners, including Microsoft Word, Excel, Access and PowerPoint. Students will be introduced to word-processing, spreadsheet, database and presentation software. Information will be included on exchanging data between programs. This course is taught using Windows and Mac operating system platforms.
(Grade or P/NP)

Prerequisites:Course Completion of CS 105A ( or CIS 105A or CIS 81.5A or BDP 81.5A) OR Course Completion of CS 5 ( or CIS 5 or BDP 5 or BDP 51) OR Completion of CS 101A or higher (CIS1)
Recommended:Eligibility for ENGL 100 or ESL 100
Limits on Enrollment:
Transfer Credit:CSU;
Repeatability:00 - Two Repeats if Grade was D, F, NC, or NP

ARTICULATION, MAJOR, and CERTIFICATION INFORMATION

Associate Degree:Effective:Inactive:
 Area:
 
CSU GE:Transfer Area Effective:Inactive:
 
IGETC:Transfer Area Effective:Inactive:
 
CSU Transfer:TransferableEffective:Fall 1995Inactive:Fall 2022
 
UC Transfer:Effective:Inactive:
 
C-ID:

Certificate/Major Applicable: Certificate Applicable Course



COURSE CONTENT

Outcomes and Objectives:
At the conclusion of this course, the student should be able to:
Untitled document
Students will:
1.      Create, edit, and format simple documents in Microsoft Word
2.      Create, edit, format and use formulas to create spreadsheets in
Microsoft Excel
3.      Create and Query a simple database using MS Access
4.      Create presentations with text and graphic objects using Microsoft
PowerPoint
5.      Share documents and information between Office programs

Topics and Scope
Untitled document
A.      Common elements between programs in Office
       1.      Screen contents
       2.      Toolbars and menus
       3.      Wizards and templates
B.      Word processing in Word
       1.      Creating a simple document
       2.      Correcting text and spell checking
       3.      Formatting a document
       4.      Tables
C.      Spreadsheets with Excel
       1.      Creating simple spreadsheet
       2.      Editing and formatting techniques
       3.      Applying formulas
       4.      Creating charts
D.      Database with Access
       1.      Organization of database structure
       2.      Creating and editing a simple database
       3.      Querying a database
       4.      Creating reports
E.      Presentations with PowerPoint
       1.      Creating presentations
       2.      Entering and formatting text
       3.      Creating and running slide shows
F.      Sharing data between Office programs
       1.      OLE
       2.      Clipboard
       3.      Integrated applications
               a.      Embedding an Excel worksheet in a Word document
               b.      Linking an Access database file to a Word document
               c.      Integrating Word, Excel, Access & PowerPoint in an
Office Binder

Assignments:

Methods of Evaluation/Basis of Grade.
Writing: Assessment tools that demonstrate writing skill and/or require students to select, organize and explain ideas in writing.Writing
0 - 0%
None
This is a degree applicable course but assessment tools based on writing are not included because problem solving assessments and skill demonstrations are more appropriate for this course.
Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills.Problem Solving
25 - 50%
Lab reports, Quizzes, Exams, Lab checklists & excercises
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams.Skill Demonstrations
15 - 25%
Projects
Exams: All forms of formal testing, other than skill performance exams.Exams
15 - 25%
Multiple choice, True/false, Completion
Other: Includes any assessment tools that do not logically fit into the above categories.Other Category
15 - 25%
Printed work set to specifications.


Representative Textbooks and Materials:
Untitled document
"Microsoft Office 97 Professional", by Hutchinson & Coulthard -
Irwin/McGraw-Hill 1997

Print PDF