Skip to main content

Learning Units

Units

This course consists of 3 units. Students should work through the units as shown on the Section Schedule page.

Excel & Data Analysis
Access
Word & PowerPoint

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