Business Requirements Specialist - Technical Diploma

Students gain skills that lead to success in college, employment, and life. Students should take this course in their first semester. (Pre-requisite: None.)

This course provides an overview of the interconnectedness among careers within Information Technology. Learn how various fields within the broader industry each play an integral role and how a personal brand fits into preparing you for your career choice.  (Corequisite: 10-890-101, College 101)

Creating worksheets; enter data, make modifications, work with formulas and functions, create and enhance charts, manage data, transform data, conditional formatting, importing/exporting data, introduction to PivotTables and PivotCharts.

A foundational understanding of business analysis, the key concepts within the skills needed, and the underlying competencies of a business analyst.

All college students, regardless of their college major, need to be able to make reasonable decisions about fiscal, environmental, and health issues that require quantitative reasoning skills. An activity based approach is used to explore numerical relationships, graphs, proportional relationships, algebraic reasoning, and problem solving using linear, exponential and other mathematical models. Students will develop conceptual and procedural tools that support the use of key mathematical concepts in a variety of contexts. This course may be used as the first of a two part sequence that ends with Quantitative Reasoning as the capstone general education math requirement. (Prerequisite: Next Gen Arith score greater/equal to 250 AND Rdg score greater/equal to 250; OR ACT Math score greater/equal to 15 AND ACT Reading score greater/equal to 16; OR prep courses-contact an academic advisor 920-498-5444).

Instruction in the multiple approaches used for performing business analysis, planning activities and ongoing communication, defining scopes, process improvements, assumptions, constraints, and dependencies, and the management process.

Covers working with data tools, advanced formatting techniques, advanced functions, evaluating formulas, collaboration tools, data validation, form controls, macros, working with templates, and collaborating with multiple Excel users. (Pre-req: 10-103-131, MS Excel Intro)

Database uses, database terminology, analyzing information requirements, data models, database design phases, entity relationships, normalization processes, database management systems, database objects, development environments, creating tables, writing queries using SQL, testing.

Students will learn to use BA software tools- Visio, SharePoint, OneNote, and advanced Excel involving scenarios and case studies. (Corequisite: 10-103-132, MS Excel Part 2)

Define stakeholders and use the stakeholder analysis to conduct elicitation activities accurately capturing information needs, documenting, and confirming results. Facilitates meetings and communication plan to support ongoing collaboration. (Prerequisite: 10-102-124, Planning and Monitoring)

Prioritize and trace requirements, organize large amounts of data, understand and model requirements using various analysis techniques; verify, validate, and communicate the requirements. (Prerequisite: 10-102-126, Elicitation Techniques)

Write queries in a relational database: creating tables, setting primary/foreign keys, populating tables, manipulating data and reporting. Explore join types, stored procedures, functions, and database administration SQL statements. (Prerequisite: 10-152-125, Database Design)

The role of project management, developing a project proposal, demonstration of relevant software, working with project teams, sequencing tasks, charting progress, dealing with variations, budgets and resources, implementation, and assessment.

Understand the principles of solution requirements, traceability, measuring, and tracing quality of BA work, utilizing metrics, complying with organizational standards, and managing and supporting organizational change. (Prerequisite: 10-102-128, Requirements Life Cycle Management)

Identify and define business needs; understand business structure, strategy, and impact of work efforts; define the importance of vision, strategy, goals, and objectives; and define solution scope. Effectively facilitate change management. (Prerequisite: 10-102-130, Requirements Analysis & Design)

In this course, students will learn to organize, manage, and analyze very large data sets from various sources. Students will use software tools to present complex data in visually meaningful representations that can be communicated to business stakeholders. Upon completion, students will learn how to transform raw data into meaningful information that will be utilized for data-driven decision making. (Corequisite needed for Data Analytics program: 10-103-175, Power BI)