Academic Catalog


Foothill College Course Outline of Record

Foothill College Course Outline of Record
Heading Value
Effective Term: Summer 2021
Units: 0
Hours: 5 lecture per quarter (5 total per quarter)
Advisory: Basic experience with internet software tools, browsers, hyperlinks, online media resources, and basic skills using a computer; students will need a free Google account to participate in this course.
Degree & Credit Status: Non-Degree-Applicable Non-Credit Course
Foothill GE: Non-GE
Transferable: None
Grade Type: Non-Credit Course (Receives no Grade)
Repeatability: Unlimited Repeatability

Student Learning Outcomes

  • Format sheets and cells, including non-text elements.
  • Manage data values, rows, cells, and columns.


This noncredit workforce preparation course provides an overview of Google's cloud-based spreadsheet service, Google Sheets, as part of the G Suite of tools. Skills covered include cell management, formatting spreadsheets, using functions, and managing data. This course will prepare students for the Sheets portion of the G Suite Certification exam.

Course Objectives

The student will be able to:

  1. Manage data values, rows, cells, and columns.
  2. Format sheets and cells.
  3. Insert non-text elements into sheets.
  4. Use basic functions to manipulate data and solve numeric problems.
  5. Manage and transform data to meet different user needs.
  6. Collaborate on, and share sheets with other users.
  7. Import, export, and convert from other file types to utilize data across multiple formats and applications.

Course Content

  1. Manage data
    1. Adding
    2. Deleting
    3. Freezing
    4. Inserting
  2. Formatting
    1. Bolding and italicizing
    2. Merging cells
    3. Text wrapping
    4. Fill color
    5. Borders
    6. Data validation
    7. Alignment
    8. Fonts
    9. Font size
    10. Date formats
    11. Currency
    12. Sheet formatting
      1. Adding
      2. Deleting
      3. Duplicate
      4. Copy to...
      5. Renaming
  3. Non-text elements
    1. Charts
    2. Images
    3. Links
    4. Forms
    5. Drawings
  4. Functions
    1. Function list
    2. SUM
    3. AVERAGE
    4. MIN
    5. MAX
    6. COUNT
  5. Transform data
    1. Conditional formatting
    2. Naming, sorting, and protecting sheets and ranges
    3. Creating filters and filter views
    4. Validating data
    5. Creating and modifying charts
  6. Collaboration and sharing
    2. Revision history
    3. Download as
  7. Other file types
    1. Comma separated values
    2. Excel sheets

Lab Content

Not applicable.

Special Facilities and/or Equipment

1. When offered on campus: Lecture room equipped with computer projector system, whiteboard, and internet connectivity. Computer laboratories with internet connectivity and computers or internet enabled devices running standard operating systems (e.g., iOS, MacOS, Windows, Android, Linux)
2. When taught online via Canvas students must have current email accounts and/or ongoing access to computers with email and web browsing capability

Method(s) of Evaluation

Methods of Evaluation may include but are not limited to the following:

Completing assignments through an online course system
Class performance with demonstrations

Method(s) of Instruction

Methods of Instruction may include but are not limited to the following:

The student will be writing notes, listening, and participating in lecture presentation
The student will be observing an instructor-led demonstration and/or actively practicing the demonstrated skills
The student will be presenting and communicating their ideas in discussion and/or participating in peer reviews

Representative Text(s) and Other Materials

La Counte, Scott. The Ridiculously Simple Guide to Google Apps (G Suite), 1st ed.. 2019.

Types and/or Examples of Required Reading, Writing, and Outside of Class Assignments

  1. Example reading assignment: Students will read, both in print and online, instructions relating to the basic operation of a G Suite application. Additionally, there will be written material which will accompany either video or direct instruction.
  2. Example writing assignments: Students will write responses to questions regarding the demonstration of using a G Suite application, such as email, word processing document, or spreadsheet.


Instructional Design/Technology