SRJC Course Outlines

6/30/2022 10:01:34 PMADLTED 762.3 Course Outline as of Fall 2022

Changed Course
CATALOG INFORMATION

Discipline and Nbr:  ADLTED 762.3Title:  COMP OPS WRKP 3  
Full Title:  Computer Operations for the Workplace 3
Last Reviewed:12/13/2021

UnitsCourse Hours per Week Nbr of WeeksCourse Hours Total
Maximum0Lecture Scheduled012 max.Lecture Scheduled0
Minimum0Lab Scheduled2.003 min.Lab Scheduled24.00
 Contact DHR0 Contact DHR0
 Contact Total2.00 Contact Total24.00
 
 Non-contact DHR0 Non-contact DHR Total0

 Total Out of Class Hours:  0.00Total Student Learning Hours: 24.00 

Title 5 Category:  Non-Credit
Grading:  Non-Credit Course
Repeatability:  27 - Exempt From Repeat Provisions
Also Listed As: 
Formerly:  ADLTED 761.6

Catalog Description:
Untitled document
This is the third course in a 5-course series to build competency in Microsoft (MS) Word, Excel, and PowerPoint for personal and professional use. The student will learn the basic features of MS Excel to create and format simple worksheets.

Prerequisites/Corequisites:


Recommended Preparation:
Course completion of ADLTED 762.2

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
This is the third course in a 5-course series to build competency in Microsoft (MS) Word, Excel, and PowerPoint for personal and professional use. The student will learn the basic features of MS Excel to create and format simple worksheets.
(Non-Credit Course)

Prerequisites:
Recommended:Course completion of ADLTED 762.2
Limits on Enrollment:
Transfer Credit:
Repeatability:27 - Exempt From Repeat Provisions

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

Student Learning Outcomes:
Upon completion of the course, students will be able to:
Untitled document
1. Create simple worksheets in Excel
2. Enhance a worksheet using different formatting options
 

Objectives: Untitled document
In order to achieve these learning outcomes, during the course the students will:
1. Identify the different components of an Excel worksheet
2. Open an existing workbook and create a new one
3. Enter and delete text and numbers
4. Insert and delete rows and columns
5. Format rows and columns
6. Sort and filter data

Topics and Scope
Untitled document
I. Getting Started with Excel
    A. Navigate the ribbon
    B. Use the quick access toolbar
    C. Worksheet views
    D. Create a new workbook
    E. Open an existing workbook
 
II. Basic Features and Elements in Excel
    A. Enter and delete data
    B. Copy and paste cell content
    C. Use the fill handle
    D. Save a workbook
 
III. Working with Rows and Columns
    A. Insert and delete rows and columns
    B. Modify column width and row height
    C. Hide and unhide rows and columns
    D. Wrap text and merge cells
 
IV. Formatting Cells
    A. Change font, size, and color
    B. Add cell borders and fill colors
    C. Apply cell styles
    D. Change text alignment
    E. Apply number formats
 
V. Organizing Data
    A. Sort data
    B. Filter data

Assignments:
Untitled document
1. Using basic features and elements in Excel (2-4)
2. Working with rows and columns (3-6)
3. Formatting cells (3-6)
4. Organizing data (2-4)
5. Summative demonstration of skill attainment (1)

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
Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills.Problem Solving
0 - 0%
None
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams.Skill Demonstrations
65 - 100%
Basic features and elements in excel exercises; working with rows and columns exercises; formatting cells exercises; organizing data exercises; summative demonstration of skill attainment
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
0 - 35%
Attendance and participation


Representative Textbooks and Materials:
Untitled document
Instructor and department prepared materials

Print PDF