SRJC Course Outlines

4/19/2024 2:25:48 PMADLTED 764.2 Course Outline as of Fall 2024

Changed Course
CATALOG INFORMATION

Discipline and Nbr:  ADLTED 764.2Title:  GOOGLE TOOLS 2  
Full Title:  Google Tools and Applications- Part 2: Sheets
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.8

Catalog Description:
Untitled document
This is the second course in a 5-course series to build competency in web-based applications and programs for personal and professional use. Students will advance their knowledge of Google Sheets, part of the Google suite of apps. The student will learn how to create, edit, share, and collaborate on files in Google Sheets and understand their purpose and use in a personal and professional setting.

Prerequisites/Corequisites:


Recommended Preparation:
Course completion of ADLTED 764.1

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
This is the second course in a 5-course series to build competency in web-based applications and programs for personal and professional use. Students will advance their knowledge of Google Sheets, part of the Google suite of apps. The student will learn how to create, edit, share, and collaborate on files in Google Sheets and understand their purpose and use in a personal and professional setting.
(Non-Credit Course)

Prerequisites:
Recommended:Course completion of ADLTED 764.1
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:
At the conclusion of this course, the student should be able to:
Untitled document
1. Understand and utilize G-Suite app: Sheets
2. Create, edit and share documents utilizing Google Sheets
 

Objectives: Untitled document
At the conclusion of this course, the student should be able to:
1. Create, edit, and share Google Sheets
2. Utilize basic and complex formulas for data analysis in Google Sheets
3. Organize data and insert and format charts to provide a better visual representation of the data

Topics and Scope
Untitled document
I. Basic Features and Elements in Google Sheets
    A. Create a new spreadsheet
    B. Select cells
    C. Insert and delete cell content
    D. Copy and paste cell content
    E. Use the fill handle
    F. Share a Google Sheet
 
II. Working Rows and Columns
    A. Modify column width and row height
    B. Insert and delete rows and columns
    C. Wrap text and merge cells
    D. Hide and unhide rows and columns
 
III. Formatting Cells
    A. Change font, size, and color
    B. Change text alignment
    C. Add cell borders and change fill color
    D. Apply number formats
 
IV. Formulas and Functions
    A. Create simple formulas
    B. Edit a formulas
    C. Create complex formulas
    D. Create functions
    E. Create formulas using functions
    F. Edit a formula
 
V. Organizing Data
    A. Sort data
    B. Filter data
 
VI. Charts
    A. Insert a chart
    B. Change chart type
    C. Add chart and axis titles
    D. Change chart colors, fonts, and style
    E. Move and resize a chart

Assignments:
Untitled document
1. Using basic features and elements in Google Sheets (1-3)
2. Working with rows and columns (1-3)
3. Formatting cells (1-3)
4. Formulas and functions (2-4)
5. Organizing data (1-2)
6. Inserting and formatting charts (2-4)
7. Summative demonstration of skills 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%
Google Sheets 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