ISA 2010 - Proficiency in Excel & SQL

Institution:

Utah Tech University

Subject:

Description:

Required of all students in the College of Business and open to other interested students. This hands-on course covers fundamentals and advanced concepts necessary to prepare students to pass the Microsoft Office Specialist (MOS) Excel Expert Certification. Students will take the MOS Excel Expert Certification as part of the course. Covers beginning Structured Query Language (SQL) commands used in most relational database management systems for joining and extracting data to solve business problems. Skills in this course will be critical for several upper division courses in the College of Business. Inclusive Access Course Material (electronic book) fees may apply, see Fees tab under each course section for details. **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Create spreadsheet models that include advanced formulas, functions, charts, pivot tables, and macros. 2. Prepare valid data analysis spreadsheet models to aid in decision making. 3. Use basic SQL syntax in typical business applications. 4. Develop SQL queries that extract and join data from multiple tables to solve a business problem. 5. Identify and defend personal, ethical, and organizational issues related to the use and misuse of spreadsheet models and SQL commands. FA, SP, SU

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

05/22/2006 - 08/14/2020 

Institution Website:

www.utahtech.edu/

Phone Number:

(435) 652-7500

Regional Accreditation:

Northwest Commission on Colleges and Universities

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.