SRJC Course Outlines

12/8/2024 1:08:07 PMCS 161.11A Course Outline as of Fall 2009

Changed Course
CATALOG INFORMATION

Discipline and Nbr:  CS 161.11ATitle:  INTRO MS EXCEL, LEVEL 1  
Full Title:  Intro to MS Excel, Level 1, for Office Professionals
Last Reviewed:11/27/2000

UnitsCourse Hours per Week Nbr of WeeksCourse Hours Total
Maximum.50Lecture Scheduled8.004 max.Lecture Scheduled32.00
Minimum.50Lab Scheduled01 min.Lab Scheduled0
 Contact DHR0 Contact DHR0
 Contact Total8.00 Contact Total32.00
 
 Non-contact DHR0 Non-contact DHR Total0

 Total Out of Class Hours:  64.00Total Student Learning Hours: 96.00 

Title 5 Category:  AA Degree Applicable
Grading:  P/NP Only
Repeatability:  34 - 4 Enrollments Total
Also Listed As: 
Formerly:  BOT 162.3A

Catalog Description:
Untitled document
In this introductory Excel class students get started with Excel; create modify, print, and format worksheets; work with basic formulas and functions; use multiple worksheets; enhance worksheets; use styles and AutoFormats; and work with charts.  (Formerly BOT 86.27)

Prerequisites/Corequisites:


Recommended Preparation:

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
In this introductory Excel class students get started with Excel; create, modify, print, and format worksheets; work with basic formulas and functions; use multiple worksheets; enhance worksheets; use styles and AutoFormats; and work with charts.(Formerly BOT 86.27).
(P/NP Only)

Prerequisites:
Recommended:
Limits on Enrollment:
Transfer Credit:
Repeatability:34 - 4 Enrollments Total

ARTICULATION, MAJOR, and CERTIFICATION INFORMATION

Associate Degree:Effective:Inactive:
 Area:
 
CSU GE:Transfer Area Effective:Inactive:
 
IGETC:Transfer Area Effective:Inactive:
 
CSU Transfer:Effective:Inactive:
 
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
The student will be able to:
1.  Get started with Excel 2000
2.  Create worksheets
3.  Modify worksheets
4.  Format worksheets
5.  Print worksheets
6.  Work with basic formulas and functions
7.  Use multiple worksheets
8.  Enhance worksheets
9.  Use styles and Autoformats
10. Work with charts

Topics and Scope
Untitled document
1.  Getting Started with Excel 2000
   Exploring spreadsheet uses
   Defining workbooks and worksheets
   Moving around worksheets
   Selecting ranges
   Exploring toolbars and menus
2.  Creating Worksheets
   Creating new workbooks
   Entering data and text
   Using the AutoComplete feature
   Entering numbers and dates
   Editing data
   Saving and closing new workbooks
3.  Modifying Worksheets
   Locating and opening existing workbooks
   Copying worksheet data
   Copying data using the clipboard, AutoFill, and drag and drop
   Moving, cutting and pasting worksheet data
   Copying and moving data from multiple sources
   Deleting data and reversing actions
   Reversing actions
   Saving workbooks with different names
4.  Formatting Worksheets
   Inserting and deleting rows and columns
   Changing column widths and row heights
   Using AutoFit
   Using numeric, accounting and currency, percent, comma, and date
   formats
   Changing the alignment of data
   Using conditional formatting
5.  Printing Worksheets
   Previewing print jobs
   Using page break preview
   Defining page setup options
   Changing print size and margins
   Creating headers and footers
   Printing worksheets
6.  Working with Basic Formulas and Functions
   Using formulas
   Creating formulas
   Editing formulas
   Using cell references
   Using functions
   Using AutoSum
   Using the paste function feature
   Using AutoCalculate
7.  Using Multiple Worksheets
   Working with multiple worksheets
   Inserting and deleting worksheets
   Moving and copying data between worksheets
   Moving and copying worksheets
   Grouping worksheets
   Creating 3-dimensional formulas
   Renaming worksheets
   Previewing and printing multiple worksheets
8.  Enhancing Worksheets
   Enhancing text and font attributes
   Changing text and font attributes
   Adding and modifying borders
   Shading ranges
   Creating and modifying 3-dimensional objects
   Inserting, resizing, and moving pictures
9.  Using Styles and AutoFormats
10. Working with Charts
   Creating, formatting, modifying and changing charts
   Repositioning legends
   Resizing and moving charts
   Editing chart data
   Placing and modifying data tables in charts
   Printing charts

Assignments:
Untitled document
Completion of exercises and drills.

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
20 - 50%
Application problems
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams.Skill Demonstrations
20 - 75%
Software functions
Exams: All forms of formal testing, other than skill performance exams.Exams
0 - 0%
None
Other: Includes any assessment tools that do not logically fit into the above categories.Other Category
5 - 30%
Attendance, class participation, staying on task.


Representative Textbooks and Materials:
Untitled document
Excel, Module I, ComputerPrep, 1998

Print PDF