Skip to content

Course Syllabus

BUS 2010 Business Computer Proficiency

  • Division: Business and Applied Tech
  • Department: Business
  • Credit/Time Requirement: Credit: 3; Lecture: 3; Lab: 0
  • Prerequisites: N/A
  • Corequisites: N/A
  • Semesters Offered: TBA
  • Semester Approved: Spring 2022
  • Five-Year Review Semester: Fall 2026
  • End Semester: Fall 2027
  • Optimum Class Size: 20
  • Maximum Class Size: 24

Course Description

This course is designed for business majors and those wanting a thorough knowledge of spreadsheets and databases. Students will use the current version of Microsoft Excel and Access. The course will cover introductory to intermediate database and spreadsheet concepts. Students will complete an integrated project using both applications to summarize data that can be analyzed to make decisions. To be successful in the class, students should have a basic understanding of computer applications and file management. BUS 1020 is recommended as a prerequisite. Successful mastery of BUS 2010 and CS 1520 will qualify you for the Snow College 'Foundations of Data Analysis' internal certificate. (Additional fee required)

Justification

This course is required for the ASB and prepares students for job readiness and/or transfer to a university. The course meets the requirements as agreed upon by the UBAAN state committee (articulation committee for the ASB) and is accepted at many state institutions.

Student Learning Outcomes

  1. Students will use a variety of spreadsheet and database features to effectively organize and manage data.
  2. Students will use formulas and functions in database and spreadsheet software for efficiency and accuracy in summarizing data.
  3. Students will perform appropriate analyses of quantitative and qualitative data using spreadsheet and database software.
  4. Students will use spreadsheet and database features to complete an integrated project and deliver quality documents using professional standards.

Course Content

Course objectives will be accomplished with learning experiences in the following areas: Excel – SpreadsheetGeneral applications: e.g., insert, name, and reference worksheets; apply the order of operations; use absolute, relative, and mixed cell references; apply numeric formats, cell alignment, styles, borders, shading Specialized skills: e.g., create and modify a variety of charts; use advanced filters and sort multiple fields; nest functions (If, And, Or, VLookup, HLookup, Subtotal, etc.); use conditional formatting, slicers, sparklines, databars; apply table features; use what-if and data analysis tools; create PivotTables, and PivotCharts; use named ranges, connect to external dataAccess – DatabaseGeneral applications: e.g., create tables, queries, forms, and reports using Wizards; apply themes, conditional formatting, and alignment; sort, find, and filter records; Specialized skills: e.g., customize tables, queries, forms, and reports; edit field types and properties; create primary keys and relationships; create action queries; import and export data