SRJC Course Outlines

7/31/2021 2:20:28 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:
 
UC Transfer:Effective:Inactive:
 
C-ID:

Certificate/Major Applicable: Both Certificate and Major Applicable

Approval and Dates
Version:07Course Created/Approved: 10/11/1995
Version Created:4/4/2018Course Last Modified:6/5/2021
Submitter:Mike StarkeyCourse Last Full Review:9/10/2018
Version Status:Approved Changed CoursePrereq Created/Approved:9/10/2018
Version Status Date:9/10/2018Semester Last Taught:Spring 2021
Version Term Effective:Fall 2019Term Inactive:


COURSE CONTENT

Student Learning Outcomes:
Upon completion of the course, students will 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

OTHER REQUIRED ELEMENTS

Student Preparation
 Matric Assessment Required:ERequires English Assessment
 Prerequisites-generate description:NPNo Prerequisite
 Advisories-generate description:UUser-Generated Text
 Prereq-provisional:NNO
 Prereq/coreq-registration check:NNo Prerequisite Rules Exist
 Requires instructor signature:NInstructor's Signature Not Required
   
BASIC INFORMATION, HOURS/UNITS & REPEATABILITY
 Method of instruction:02Lecture
 72Internet-Based, Delayed Interaction
 71Internet-Based, Simultaneous Interaction
 Area department:CSComputer Studies
 Division:72Arts & Humanities
 Special topic course:NNot a Special Topic Course
 Program Status:1Both Certificate and Major Applicable
 Repeatability:00Two Repeats if Grade was D, F, NC, or NP
 Repeat group id:  
   
SCHEDULING
 Audit allowed:NNot Auditable
 Open entry/exit:NNot Open Entry/Open Exit
 Credit by Exam:NCredit by examination not allowed
 Budget code: Program:0000Unrestricted
 Budget code: Activity:0701Computer & Information Science
   
OTHER CODES
Disciplines:Computer Information Systems
 Basic Skills:NNot a Basic Skills Course
 Level below transfer:YNot Applicable
 CVU/CVC status:YDistance Ed, Not CVU/CVC Developed
 Distance Ed Approved:YEither online or hybrid, as determined by instructor
 Emergency Distance Ed Approved:YFully Online
Partially Online
Online with flexible in-person activities
 Non-credit category:YNot Applicable, Credit Course
 Classification:YCareer-Technical Education
 SAM classification:CClearly Occupational
 TOP code:0514.00Office Technology/Office Computer Applic
 Work-based learning:NDoes Not Include Work-Based Learning
 DSPS course:NNO
 In-service:NNot an in-Service Course

Print PDF