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 #5 |
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. |
|
|
| C02 | Design and construct databases to store, extract, and analyze scientific and real world data. |
|
|
| C03 | Create scientific and technical documents incorporating equations, images, tables, and bibliographies. |
|
|
| C04 | Develop technical and scientific presentations which use charts and visual aids to share data. |
|
|
| C05 | Identify, access, and evaluate information to solve real world problems. |
|
|
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:
- 1 Exam
- 1-3 Homeworks
- 1-3 MyLab Lessons
- 2-8 Participation Projects
- 0-2 MyLab Extra Credit Projects