SRJC Course Outlines

3/29/2024 4:13:10 AMCS 65.11 Course Outline as of Fall 2019

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

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
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

Student Learning Outcomes:
At the conclusion of this course, the student should be able to:
Untitled document
1.  Create, edit, format and print moderately complex Word documents.
2.  Use Excel to solve moderately complex problems including the effective use of formulas and
    functions.
3.  Design a database, manipulate the data using simple queries, and display data by designing
    simple forms and reports.
4.  Create and display a PowerPoint presentation.
 

Objectives: 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
I. Common Elements between Programs in Office
    A. Office button
    B. Ribbon
    C. Tabs
    D. Groups
    E. Wizards
    F. Templates
II. Word Processing in Word
    A. Creating a simple document
    B. Spell check
    C. Formatting
         1. Character
         2. Paragraph
         3. Document
    D. Printing
    E. Tables
    F. Inserting clip art and other graphics
    G. Styles
    H. Find and Replace
    I. Mailings
    J. Headers and Footers
III. Spreadsheets with Excel
    A. User interface with Excel
    B. Rows/Columns/Cells/Cell Contents
    C. Entering - Values/Text/Formulas
    D. Editing
    E. Formatting
    F. Using formulas
         1. Order of precedence
         2. Functions
         3. Absolute references
    G. Charts
IV. Database with Access
    A. Organization of database structure
    B. Creating and editing a simple database
    C. Querying a database
    D. Creating reports
V. Presentations with PowerPoint
    A. Creating presentations
    B. Entering and formatting text
    C. Creating and running slide shows
VI. Sharing Data between Office Programs
    A. OLE [Object Linking and Embedding]
    B. Clipboard
    C. Integrated applications
         1. Embedding an Excel worksheet in a Word document
         2. Linking an Access database file to a Word document
         3. 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
Illustrated Microsoft Office 365 & Office 2016: Introductory, Loose-leaf Version (Illustrated Series). Beskeen, David and Cram, Carol and Duffy, Jennifer. Cengage L. 2016

Print PDF