SRJC Course Outlines

3/29/2024 2:50:57 AMCS 65.11 Course Outline as of Fall 2011

Changed Course
CATALOG INFORMATION

Discipline and Nbr:  CS 65.11Title:  MICROSOFT OFFICE  
Full Title:  Microsoft Office
Last Reviewed:9/10/2018

UnitsCourse Hours per Week Nbr of WeeksCourse Hours Total
Maximum3.00Lecture Scheduled3.0017.5 max.Lecture Scheduled52.50
Minimum3.00Lab Scheduled04 min.Lab Scheduled0
 Contact DHR0 Contact DHR0
 Contact Total3.00 Contact Total52.50
 
 Non-contact DHR0 Non-contact DHR Total0

 Total Out of Class Hours:  105.00Total Student Learning Hours: 157.50 

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 74.11

Catalog Description:
Untitled document
An introductory course using programs contained in the Microsoft Office Suite. Using Word, students will create and format documents including inserting graphics and mail merging. Using Access, students will create databases and manipulate data with queries and display data with forms and reports. Using Excel, students will create spreadsheets with basic formulas and functions and prepare charts to display the spreadsheet data. Using PowerPoint, basic presentations will be made. Students will also exchange data between programs.

Prerequisites/Corequisites:


Recommended Preparation:
Eligibility for ENGL 100 or ESL 100; AND Course Completion of CS 5 or CS 101A or CS 105A

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
An introductory course using programs contained in the Microsoft Office Suite. Using Word, students will create and format documents including inserting graphics and mail merging. Using Access, students will create databases and manipulate data with queries and display data with forms and reports. Using Excel, students will create spreadsheets with basic formulas and functions and prepare charts to display the spreadsheet data. Using PowerPoint, basic presentations will be made. Students will also exchange data between programs.
(Grade or P/NP)

Prerequisites:
Recommended:Eligibility for ENGL 100 or ESL 100; AND Course Completion of CS 5 or CS 101A or CS 105A
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: Both Certificate and Major Applicable



COURSE CONTENT

Outcomes and Objectives:
At the conclusion of this course, the student should be able to:
Untitled document
Upon completion of the course students will be able to:
1.   Create, edit, format, and print simple documents in Microsoft Word.
2.   Create, edit, format, and use formulas and functions to create spreadsheets in Microsoft Excel.
3.   Use the charting capabilities of Excel to display spreadsheet data.
4.   Create a database with the appropriate tables and data types.
5.   Use simple queries to extract useful information from the database.
6.   Use the Wizard to create simple reports.
7.   Design and create forms.
8.   Create presentations with text and graphic objects using Microsoft PowerPoint.
9.   Share documents and information between Office programs.
10. Choose the appropriate type of software to accomplish a given task.

Topics and Scope
Untitled document
A. Common elements between programs in Office
   1. Office button
   2. Ribbon
   3. Tabs
   4. Groups
   5. Wizards
   6. Templates
B. Word processing in Word
   1. Creating a simple document
   2. Spell check
   3. Formatting
       a. Character
       b. Paragraph
       c. Document
   4. Printing
   5. Tables
   6. Inserting clip art and other graphics
   7. Styles
   8. Find and Replace
   9. Mailings
   10. Headers and Footers
C. Spreadsheets with Excel
   1. User interface with Excel
   2. Rows/Columns/Cells/Cell Contents
   3. Entering - Values/Text/Formulas
   4. Editing
   5. Formatting
   6. Using formulas
       a. Order of precedence
       b. Functions
       c. Absolute references
   7. 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 [Object Linking and Embedding]
   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 and PowerPoint in a common document

Assignments:
Untitled document
1.  Weekly computer problem-solving assignments
2.  Quizzes (2-6)
3.  Final exam, written and practical component of final exam
4.  Reading (20-40 pages per week)
5.  Projects reflecting the various applications

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%
Computer problem solving assignments
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams.Skill Demonstrations
15 - 25%
Projects and practical component of final exam
Exams: All forms of formal testing, other than skill performance exams.Exams
25 - 50%
Quizzes and Exam: Multiple choice, true/false, completion
Other: Includes any assessment tools that do not logically fit into the above categories.Other Category
0 - 10%
Attendance and participation


Representative Textbooks and Materials:
Untitled document
Microsoft Office 2010 Illustrated Introductory, by Beskeen, Vram, Dufy, Friedrichsen and Reding.  Thomson Course Technology:  2011.

Print PDF