Skip to main content

Course Description and Learning Objectives

Course Description

Computer Science 101 is designed to teach students how to use computer applications as effective tools for problem solving and data analysis. The course introduces four different Microsoft Office applications, with a primary focus on using Excel and Access to analyze and explore real world data. After completing the course, students will be competent users of the Microsoft Office suite and will have data analysis skills that will be useful in future classes and careers.

Prerequisites and Expected Skills

There are no course prerequisites for Computer Science 101.

Incoming students are expected to be familiar with using a Windows-based computer including managing files and extracting ZIP files. We also expect students to be comfortable with using a web browser, e-mail, and a PDF reader such as Adobe Acrobat Reader. Previous experience with Microsoft Office is helpful.

General Education Curriculum

This course meets GEC Objectives 2C and 4.

General Education Foundations

This course is in GEF Area 2A: Science & Technology.

GEF Area LEAP Essential Learning Outcome Course Learning Outcome or Objective which Aligns with LEAP Outcome Assessment that will be used to Measure the Aligned Outcomes
GEF 2A: Science & Technology LEAP 2: Intellectual and Practical Skills - Quantitative Literacy

C01: Build spreadsheets to perform calculations, display data, conduct analysis, and explore what-if scenarios.

C02: Design and construct databases to store, extract, and analyze scientific and real world data.

C05: Identify, access, and evaluate information to solve real world problems.

 Homework #6

Course Learning Objectives

After completing Computer Science 101, students will be able to:

# Course Learning Objective Learning Activities
& Informal Assessments
Formal Assessments
C01 Build spreadsheets to perform calculations, display data, conduct analysis, and explore what-if scenarios.
  • Access: Database Design Participation Project
  • Excel: Charts Participation Project
  • Excel: Excel Basics Participation Project
  • Excel: Formatting Participation Project
  • Excel: Formulas & Functions I Participation Project
  • Excel: Formulas & Functions II Participation Project
  • Excel: Formulas & Functions III Participation Project
  • Excel: PivotTables Participation Project
  • Excel: Solver Participation Project
  • Excel: Tables Participation Project
  • Excel: What-If Analysis Participation Project
  • MyITLab Lesson A
  • MyITLab Lesson B
  • Exam #1
  • Final Exam
  • Homework #1
  • Homework #2
  • Homework #3
  • Homework #6
  • MyITLab Lesson A
  • MyITLab Lesson B
  • MyITLab Bonus Project #1
C02 Design and construct databases to store, extract, and analyze scientific and real world data.
  • Access: Access Basics Participation Project
  • Access: Database Creation Participation Project
  • Access: Database Design Participation Project
  • Access: Fields & Keys Participation Project
  • Access: Forms Participation Project
  • Access: Queries I Participation Project
  • Access: Queries II Participation Project
  • Access: Queries III Participation Project
  • Access: Queries IV Participation Project
  • Access: Reports Participation Project
  • Access: SQL Participation Project
  • MyITLab Lesson C
  • MyITLab Lesson D
  • MyITLab Lesson E
  • Exam #2
  • Final Exam
  • Homework #4
  • Homework #5
  • Homework #6
  • MyITLab Lesson C
  • MyITLab Lesson D
  • MyITLab Lesson E
C03 Create scientific and technical documents incorporating equations, images, tables, and bibliographies.
  • Data Analysis: Online Scavenger Hunt Participation Project
  • Word: Layout & Pagination Participation Project
  • Word: References & Workflow Participation Project
  • Word: Styles & Illustrations Participation Project
  • MyITLab Lesson F
  • MyITLab Lesson G
  • Homework #6
  • MyITLab Lesson F
  • MyITLab Lesson G
  • MyITLab Bonus Project #2
C04 Develop technical and scientific presentations which use charts and visual aids to share data.
  • PowerPoint: Layout & Formatting Participation Project
  • PowerPoint: Presentation Techniques Participation Project
  • MyITLab Lesson G
  • Final Exam
  • Homework #6
  • MyITLab Lesson G
  • MyITLab Bonus Project #3
C05 Identify, access, and evaluate information to solve real world problems.
  • Access: Access Basics Participation Project
  • Access: Database Creation Participation Project
  • Access: Database Design Participation Project
  • Access: Fields & Keys Participation Project
  • Access: Forms Participation Project
  • Access: Queries I Participation Project
  • Access: Queries II Participation Project
  • Access: Queries III Participation Project
  • Access: Queries IV Participation Project
  • Access: Reports Participation Project
  • Access: SQL Participation Project
  • Data Analysis: Online Scavenger Hunt Participation Project
  • Excel: Charts Participation Project
  • Excel: Excel Basics Participation Project
  • Excel: Formatting Participation Project
  • Excel: Formulas & Functions I Participation Project
  • Excel: Formulas & Functions II Participation Project
  • Excel: Formulas & Functions III Participation Project
  • Excel: PivotTables Participation Project
  • Excel: Solver Participation Project
  • Excel: Tables Participation Project
  • Excel: What-If Analysis Participation Project
  • PowerPoint: Layout & Formatting Participation Project
  • PowerPoint: Presentation Techniques Participation Project
  • Word: Layout & Pagination Participation Project
  • Word: References & Workflow Participation Project
  • Word: Styles & Illustrations Participation Project
  • Exam #1
  • Exam #2
  • Final Exam
  • Homework #1
  • Homework #2
  • Homework #3
  • Homework #4
  • Homework #5
  • Homework #6
  • MyITLab Bonus Project #1
  • MyITLab Bonus Project #2
  • MyITLab Bonus Project #3

Course Organization

Computer Science 101 is organized into three units: Excel & Data Analysis, Access, and Word & PowerPoint. Each unit focuses on one or two of the Microsoft Office applications taught in the course and lasts approximately one-third of the semester. Units are further broken down into chapters corresponding with those used in the textbook and Supplemental Content.

Each unit includes a number of learning activities, informal assessments, and formal assessments: