SRJC Course Outlines

3/28/2024 2:05:59 PMCIS 61.33 Course Outline as of Spring 2001

Changed Course
CATALOG INFORMATION

Discipline and Nbr:  CIS 61.33Title:  MORE EXCEL  
Full Title:  More Microsoft Excel
Last Reviewed:9/25/2000

UnitsCourse Hours per Week Nbr of WeeksCourse Hours Total
Maximum3.00Lecture Scheduled2.0017.5 max.Lecture Scheduled35.00
Minimum3.00Lab Scheduled017.5 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.18

Catalog Description:
Untitled document
A second lecture/lab course in the use of Microsoft Excel. Topics cover concepts beyond the fundamentals of Excel, such as linked formulas, macros and what-if analysis.

Prerequisites/Corequisites:
Course Completion of CS 61.11 ( or CIS 61.31)


Recommended Preparation:

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
A lecture/lab course in the further use of Microsoft Excel. Topics cover Excel features and functions beyond the fundamentals, such as linked formulas, macros and what-if analysis.
(Grade or P/NP)

Prerequisites:Course Completion of CS 61.11 ( or CIS 61.31)
Recommended:
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 1996Inactive:Fall 2010
 
UC Transfer:Effective:Inactive:
 
C-ID:

Certificate/Major Applicable: Not Certificate/Major Applicable



COURSE CONTENT

Outcomes and Objectives:
At the conclusion of this course, the student should be able to:
Untitled document
Students will:
1.  Customize toolbars
2.  Apply logical and string built-in functions
3.  Use range names in formulas
4.  Create linked formulas
5.  Setup and use pivot tables
6.  Create and manage lists using list management commands
7.  Perform what-if analysis with the scenario manager
8.  Create and edit macros

Topics and Scope
Untitled document
1. Creating links
  a.  Using link formulas
  b.  Consolidating worksheets
  c.  Object linking and embedding
2.  What-If analysis
  a.  Data tables
  b.  Scenario manager
  c.  Using the Solver
3.  Working with arrays
  a.  Creating arrays
  b.  Using two dimensional arrays
  c.  Working with array formulas
4.  Advanced functions
   Logical functions
     b.  String functions
     c.  Lookup and reference functions
5.  Macros
   a.  Using the macro recorder
   b.  Relative and absolute referencing
6.  Pivot tables
   a.  Creating a pivot table
   b.  Rearranging table fields
   c.  Creating groupings
   d.  Using summary functions

Assignments:
Untitled document
1. 20 - 25 pages of reading from text book
2. Class discussion
3. Hands on exercises and various lab assignments
4. Written responses to questions and problems

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 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
20 - 70%
Homework problems, Lab reports, Quizzes, Exams
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams.Skill Demonstrations
0 - 0%
None
Exams: All forms of formal testing, other than skill performance exams.Exams
20 - 60%
Multiple choice, True/false, Matching items, Completion, Short answers
Other: Includes any assessment tools that do not logically fit into the above categories.Other Category
10 - 20%
Short written answers and definitions of terms. Participation in class discussion.


Representative Textbooks and Materials:
Untitled document
"Running Excel", by Cobb - Microsoft Press, 2000.

Print PDF