Skip to main content

Course Information

Section Information

Sections

Please see the Instructors page for a listing of course sections.

Course Websites

Main Websites
Other Important Links

Contact Information

Instructor Contact Information

Please see your instructor's webpage for contact information.

Course Coordinator Contact Information

If you are unsatisfied with the response from your instructor, you may contact the Course Coordinator for assistance.

Brian M. Powell, PhD
E-mail: brian.powell@mail.wvu.edu
Phone: (304) 293-6255
Offices: 205 Armstrong Hall and 259 Advanced Engineering Research Building
Office Hours: Please schedule an appointment through Calendly.

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 #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.
  • 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
  • MyLab Lesson B
  • Exam #1
  • Homework #1
  • Homework #2
  • Homework #5
  • MyLab Lesson A
  • MyLab Lesson B
  • MyLab Extra Credit 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
  • MyLab Lesson D
  • MyLab Lesson E
  • Exam #2
  • Homework #3
  • Homework #4
  • Homework #5
  • MyLab Lesson C
  • MyLab 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
  • MyLab Lesson G
  • Homework #5
  • MyLab Lesson F
  • MyLab  Lesson G
  • MyLab Extra Credit 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
  • Exam #2
  • Homework #5
  • MyLab Lesson G
  • MyLab Extra Credit 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
  • Homework #1
  • Homework #2
  • Homework #3
  • Homework #4
  • Homework #5
  • MyLab Extra Credit Project #1
  • MyLab Extra Credit Project #2
  • MyLab Extra Credit 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: