SRJC Course Outlines

4/22/2021 4:40:06 PMADLTED 761.6 Course Outline as of Fall 2018

New Course (First Version)
CATALOG INFORMATION

Discipline and Nbr:  ADLTED 761.6Title:  BASIC COMPUTER OPS 6  
Full Title:  Basic Computer Operations 6: Basic Excel and Google Sheets
Last Reviewed:4/3/2018

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

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

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

Catalog Description:
Untitled document
Introduction to the basic functions and uses of the computer, including: Google Sheets and Google Drive; creating formulas in Excel; creating and formatting graphs in Excel.

Prerequisites/Corequisites:


Recommended Preparation:
Course Completion of ADLTED 761.5

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
Introduction to the basic functions and uses of the computer, including: Google Sheets and Google Drive; creating formulas in Excel; creating and formatting graphs in Excel.
(Non-Credit Course)

Prerequisites:
Recommended:Course Completion of ADLTED 761.5
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.  Prepare simple spreadsheets in Excel.
2.  Demonstrate basic skills mastery of computers and software programs.
3.  Use Google Sheets and Google Drive.
 

Objectives: Untitled document
Upon completion of the course, students will be able to:
1. Create, modify, format, and edit workbooks in Excel
2. Create simple formulas in Excel
3. Insert and format graphs in Excel
4. Create spreadsheets in Google Sheets
5. Use Google Drive

Topics and Scope
Untitled document
I. Formulas and Graphs in Excel
    A. Format graphs in Excel
    B. Charts in Excel
    C. Create simple formulae
         1. Addition
         2. Subtraction
         3. Multiplication
         4. Mixed formulae
II. Google Sheets and Google Drive
    A. Basic elements of Google Sheets
    B. Use Google Drive

Assignments:
Untitled document
1. Excel exercises (3 - 5)
2. Google Sheets exercises (3 - 5)
3. Google Drive exercises (2 - 3)
4. Summative demonstraton 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 - 70%
Excel practice and exercises; Google Sheets exercises; Google Drive exercises; Summative demonstraton 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
30 - 35%
Attendance and participation


Representative Textbooks and Materials:
Untitled document
Instructor prepared materials

Print PDF