Academic Catalog

ALTW 211: INTRODUCTION TO SPREADSHEETS

Foothill College Course Outline of Record

Foothill College Course Outline of Record
Heading Value
Effective Term: Summer 2024
Units: 3
Hours: 3 lecture per week (36 total per quarter)
Degree & Credit Status: Non-Degree-Applicable Credit Course
Basic Skills
Foothill GE: Non-GE
Transferable: None
Grade Type: Letter Grade (Request for Pass/No Pass)
Repeatability: Not Repeatable

Student Learning Outcomes

  • A successful student will be able to produce simple data entry tasks such as creating a spreadsheet, entering data and editing data in a spreadsheet
  • A successful student will be able to use Excel to add, subtract, multiply.
  • A successful student will be able to identify two or more practical applications of Excel in work or personal life.

Description

Introduction to spreadsheet computer application. Beginning level of spreadsheet database tool, emphasis on spreadsheets, charts, and tables.

Course Objectives

The student will be able to:

  1. Describe and apply simple spreadsheet software functions
  2. Format and edit spreadsheets
  3. Format and edit ruled and boxed tables in spreadsheets
  4. Create charts and tables

Course Content

  1. Spreadsheet functions
    1. Practice formatting boxed tables in spreadsheets
    2. Practice formatting ruled tables in spreadsheets
    3. Practice deleting and inserting cells, columns, and rows
    4. Practice printing the worksheet
  2. Spreadsheet
    1. Charts
      1. Practice formatting charts
      2. Practice creating and modifying charts
      3. Practice creating combination charts
  3. Use spreadsheets for simple mathematical and accounting applications
    1. Practice using formulas for addition
    2. Practice using formulas for subtraction
    3. Practice using formulas for multiplication
    4. Practice using simple accounting templates
  4. Data entry and data collection
    1. Practice collecting data using forms
    2. Practice entering data into spreadsheets
    3. Practice tabulating and formatting data using functions
    4. Practice generating a report for data

Lab Content

Not applicable.

Special Facilities and/or Equipment

1. Accessible classroom with computers, monitors, printer, and appropriate software.
2. When taught online/virtual: students and faculty need internet access with Zoom-capable computer, monitor, and speakers.

Method(s) of Evaluation

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

Participation in all class activities
Teamwork assignments
Homework
Quiz
Final exam or final project

Method(s) of Instruction

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

Lecture
Discussion
Cooperative learning exercises
Demonstration
Peer demonstration

Representative Text(s) and Other Materials

No materials are required for this course.

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

  1. Development of graphs with practical application to academic assignment, independent living scenarios.
  2. Development of spreadsheet with practical application for home-related spreadsheets, academic assignments, and work or volunteer setting spreadsheets.

Discipline(s)

Developmental Disabilities: Disabled Students Programs and Services