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.

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.

This course meets GEC Objectives 2C and 4.

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

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

MyLab Lesson A

Lesson A MyLab Lesson B Exam #1

Final Exam

Homework #1

Homework #2

Homework #3

Homework #6

MyLab Lesson A

MyLab Lesson B

Lesson B MyLab 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

MyLab Lesson C

Lesson C MyLab Lesson D

Lesson D MyLab Lesson E Exam #2

Final Exam

Homework #4

Homework #5

Homework #6

MyLab Lesson C

Lesson C MyLab Lesson D

Lesson D MyLab 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

MyLab Lesson F

Lesson F MyLab Lesson G Homework #6

MyLab Lesson F

Lesson F MyLab Lesson G

Lesson G MyLab 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

MyLab Lesson G Final Exam

Homework #6

MyLab Lesson G

Lesson G MyLab 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

MyLab Bonus Project #1

Bonus Project #1 MyLab Bonus Project #2

Bonus Project #2 MyLab Bonus Project #3

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: