Information Systems & Analytics (ISA)

ISA 2010. Proficiency in Excel & SQL. 3 Hours.

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.

ISA 2011. Microsoft Office Specialist (MOS) Excel Expert Certification. 0 Hours.

Will post a Pass on student transcript if student can show they have met Microsoft Office Specialist (MOS) Excel Expert Certification. **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Demonstrate certification in Microsoft Office Specialist (MOS) Excel Expert.

ISA 2050. Management Information Systems. 3 Hours.

Designed for students to gain an understanding of the application of technology in business. Covers information systems solutions to business problems and accounting systems concepts fundamental to the support of business processes in the operational, strategic, and decision making roles of management. Includes systems design and development, enterprise resource planning, control issues, system security, and maintenance. Emphasizes end-user applications of management information systems (MIS), challenges of managing information technology, and using MIS as a strategic management tool. **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Demonstrate proficiency in the fundamentals of Information Systems. 2. Describe and identify the key elements of Global Information Systems. 3. Analyze a complex business situation, identify relevant functional business and technological issues and defend viable courses of action. 4. Articulate strategies for implementing and/or improving information systems to create value for an organization. 5. Demonstrate the skills needed for working effectively in teams. 6. Identify and defend personal, ethical, and organizational issues in Information Systems. Prerequisites: ISA 2010; ENGL 1010 or ENGL 1010D; MATH 1010 or MATH 1000 or higher. FA, SP.

ISA 3001. Info Sys and Analytics Intermediate Career Strategies. 1 Hour.

Business Foundations, with emphasis placed on executing successful and focused career research in Information Systems and Analytics. Target industry sector(s) and specific opportunities within preferred sector(s) will be identified. Professional networking skills will be developed. Students will put together their career strategy document that includes short and long term career goals, and an implementation plan for achieving those goals. Students will update their career portfolio to match their career strategy. It is recommended that students take this course prior to their senior year. Dual listed with ACCT 3001 and FIN 3001 (students may only take one course for credit). **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. At the successful conclusion of this course, students will be able to: 1. Conduct a targeted career search related to individual skills, interest, and current career opportunities. 2. Create and maintain a professional network that will support a targeted career search. 3. Create a customized resume for each identified career opportunity. 4. Create a Personal Career Portfolio, presenting academic work product germane to their targeted career search. 5. Demonstrate a professional manner during phone and personal interviews. Prerequisites: Recommended SSC 1010, or BUS 1050, or BUS 2000. FA, SP.

ISA 3020. SQL & Python for Analytics. 3 Hours.

This course will introduce essential concepts in SQL and Python as it relates to data analytics. Students will be required to gain competency in cleaning , organizing, and analyzing data in ways that are common to business. **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Demonstrate proficiency in building tables, inserting and deleting data, and updating existing data. 2. Demonstrate proficiency in querying the database including joining tables, including specific rows, and including specific columns. 3. Demonstrate proficiency utilizing subqueries, aggregates , group by , and having statements. 4. Demonstrate proficiency building stored procedures to extract understanding from the data. 5. Apply Python to read in data sets and include data oriented libraries. 6. Utilize Python to perform basic data analysis including descriptive statistics as well as aggregate statistics. 7. Utilize Python to Identify independent and dependent variables to perform extensive regression analysis. 8. Demonstrate a working proficiency in using regression analysis to gain insight into business problems. Prerequisites: ISA 2010 or CIS 2010 (Both Grade C- or higher). FA, SP.

ISA 4060. Big Data Analytics. 3 Hours.

Course focuses on a theoretical and hands-on exploration of business intelligence and analytics. It covers current best practices in statistical and quantitative analysis using large-scale data sets, exploratory and predictive models, and evidence-based methods to improve business decisions and actions. Dual listed with IT 4060 (students may only take one course for credit). **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Identify the key components and concepts associated with big data analytics. 2. Apply big data and statistical best practices to collect, cleanse, transform, and store large-scale data for subsequent analysis. 3. Analyze large-scale data sets to identify hidden patterns. 4. Evaluate data models using best practices. 5. Create recommendations for improving business decisions based on the data analysis. Prerequisites: STAT 2040 (Grade C- or higher); OR Both MATH 1040 (Grade C- or higher) and ISA 2010 (Grade C- or higher); OR Both MATH 2050 (can be taken concurrently) and ISA 2010 (C- or higher). FA.

ISA 4070. Data Visualization and Storytelling. 3 Hours.

A focus on the methods, tools and processes to effectively visually encode and present insights discovered from previously analyzed data. It includes practice transforming simple and complex data analysis outputs into relevant, accurate, and effective visual displays to improve communication and decision making. Dual listed with IT 4070 (students may only take one course for credit). **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Identify the key components and concepts associated with data visualization. 2. Recognize the ethical and financial consequences of poor data visualization techniques. 3. Differentiate between effective and ineffective methods in data analysis reporting. 4. Create graphically encoded data into useful formats from previously analyzed data. 5. Demonstrate the accurate communication of statistical findings for real world big data problems to decision makers with diverse skill levels. SP.

ISA 4450. Project Management. 3 Hours.

The project management course introduces students to the main stages of effectively managing the work of a team to achieve desired objectives. These stages include: initiating, planning, executing, controlling, and closing. It covers common pitfalls and best practices for successful management of a project. Software tools to facilitate the process will also be introduced. Finally, students will practice relating with stakeholders and team members in a professional manner. **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Describe best practices for managing projects of various sizes including quality, time, cost, scope, risk, and success factors. 2. Identify common project pitfalls and strategies for avoiding them. 3. Identify resources needs, constraints, and estimate costs for each stage of the project life cycle. 4. Articulate roles to team members and clearly identify responsibilities and accountability. 5. Use good project management skills in a real world scenario including alignment with the organization's strategic plan, resolving differences, tracking progress, and making adjustments as necessary. 6. Analyze software tools to enhance the project management process. 7. Collaborate with stakeholders and project members in a professional manner. SP.

ISA 4600. Senior Project. 3 Hours.

Capstone course requiring the completion of an aggressive information systems and analytics project. **COURSE LEARNING OUTCOMES (CLOs) At the successful conclusion of this course, students will be able to: 1. Plan, identify, and design an ISA related project using industry standard techniques. 2. Communicate effectively with stakeholders on project progress and produce professional quality written and oral ISA reports that meet their needs. Prerequisite: Senior Standing, OR Instructor Permission. SP.