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)
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.
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