Course

Course Summary
This apprenticeship is federal/state registered
Credit Type:
Apprenticeship
ACE ID:
SSTI-0003
Occupation Title:
Enterprise Agile: Analytics and Insights Engineering
Organization:
Type of Apprenticeship Program:
Traditional/Time based
Estimated length of On the Job Training (OJT):
2 years (4,000 hours)
Estimated length of Related Training Instruction (RTI):
14 weeks (560 hours)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Communications
Lower-Division Baccalaureate 3 Agile Project Management
Lower-Division Baccalaureate 3 Scripting Languages
Lower-Division Baccalaureate 3 Introduction to Programming
Lower-Division Baccalaureate 3 Introduction to Web Development
Lower-Division Baccalaureate 1 Seminar in Computer Science
Lower-Division Baccalaureate 6 Internship in Information Technology
Lower-Division Baccalaureate 3 Introduction to Databases
Lower-Division Baccalaureate 3 Introduction to Software Development
Lower-Division Baccalaureate 3 Introduction to Cloud Computing
Lower-Division Baccalaureate 3 Introduction to Python Programing
Upper-Division Baccalaureate 3 Decision Making
Upper-Division Baccalaureate 3 Web Programming
Upper-Division Baccalaureate 3 Web Frameworks
Description

Occupation Description:

Work-based learning allows for students to get hands on learning and experience in an agile enterprise development environment utilizing multiple technologies and frameworks. Whereas in the Agile Enterprise courses the students learn in a simulated environment, on-the-job learning allows students to continue their growth and learn by working on real world projects. These two years of learning are an integral growth stage for a developer to choose their career specialization in years 3 through 5.

Program Description:

Students will learn Data Analytics and Insights Engineering in an enterprise-agile environment, complete with product owners, scrum masters, and stakeholders.

As a Data analytics and Insights Engineer, students will have the practical knowledge of how to automate data processing tasks using scripting languages such as Python, design and implement data pipelines to collect and process large volumes of data, create and maintain ETL workflows, and leverage AWS Quicksight to perform data analysis and visualization.

Program Objective:

The program objective is for students to learn Analytics and Insights in an enterprise-agile environment, complete with product owners, scrum masters, stakeholders, etc.

Learning Outcomes:

  • Communications - The student will be able to conduct audience analysis; construct and deliver oral speeches; conduct small group instruction; execute basic speech and instructional skills; deliver an oral presentation using multimedia; and collect, analyze, and report data.
  • Agile Project Management –The student will be able to create a project charter; develop a business case that includes a requirements document; describe project management integration; identify stakeholders and define customer expectations; define project scope and work breakdown structure; develop a project schedule; develop cost estimates; describe methodologies for quality assurance; develop a human resource plan; develop a communication plan; perform risk assessment and mitigation; develop a procurement management plan; and utilize Microsoft Project software to manage a project.
  • Scripting Languages - The student will be able to discuss the basic techniques used to create scripts for automating administrative tasks; employ regular expressions in processing text; demonstrate the use of scripting languages to manage applications using networks; explain how to use scripting language to process other application's data; and show the use of scripting developing applications using networks and databases.
  • Introduction to Programming - The student will be able to create programs using fundamental concepts; identify programming's role in cyber operations; create flow charts and design and implement pseudo-code to solve problems; identify variable types and strings; analyze, create, and compile programs; describe the use of classes and objects in programming; and explain vectors and create functions in programming languages.
  • Introduction to Web Development –The student will be able to explain Internet and world-wide-web concepts related to web development; code HTML5 web pages; create the body and content of a web page with HTML tags, attributes, values, e.g. headings, paragraphs, hyperlinks, images, tables, forms, etc.; demonstrate proficient use of CSS (Cascading Style Sheets) to format the appearance of web pages and provide layout; define web design best practices; create web page layouts using the most recent industry best practices; implement user accessibility best practices, e.g. mobile/responsive, people with disabilities, etc.; use W3C to validate HTML and CSS; identify recommended practices for web site promotion and Search Engine Optimization (SEO); create and use a JavaScript in a web page; incorporate multimedia and Interactivity into a web page; explain what acquiring a domain name, hosting, and publishing a web site entails; and publish a web site.
  • Seminar in Computer Science –The student will be able to analyze a complex computing problem and apply principles of programming and other relevant disciplines to identify solutions; evaluate the requirements for a specific programming problem and recommend solutions; create a program to meet the objectives; function effectively as a member or leader of a team engaged in activities appropriate to the task; identify and analyze user needs then create, integrate solutions in the computing-based project; demonstrate the application of knowledge and skill sets acquired from the courses and workplace in the assigned job function; exhibit critical thinking and problem-solving skills by analyzing underlying issues and apply to project challenges; and recommend ideas to improve work effectiveness and efficiency by analyzing requirements then considering viable options.
  • Internship in Information Technology – The student will be able to analyze a complex computing problem and apply operating system administration principles and other relevant disciplines to identify solutions; analyze a complex computing problem and apply principles of programming and other relevant disciplines to identify solutions; evaluate the requirements for a specific system configuration and recommend solutions; create a program to meet the objectives; function effectively as a member or leader of a team engaged in activities appropriate to the task; identify and analyze user needs then create, integrate solutions in the computing-based project; demonstrate the application of knowledge and skill sets acquired from the courses and workplace in the assigned job function; exhibit critical thinking and problem-solving skills by analyzing underlying issues and apply to project challenges.; and recommend ideas to improve work effectiveness and efficiency by analyzing requirements then considering viable options.
  • Introduction to Databases - The student will be able to input data into forms; download data sets for analysis; develop SQL reports; administer updates to the database management system (DBMS); and integrate the database with external systems.
  • Introduction to Software Development – The student will be able to describe software development and design methodologies; create data and object models; develop use cases; communicate using information system terminology; work with stakeholders to develop requirements; develop, integrate, and implement a multifaceted software application as a team; and categorize different data types analyze the data collection process.
  • Introduction to Cloud Computing – The student will be able to explain the phases of transition from classic data center to virtual data center and then to the cloud; describe virtualization technology and compute, storage, network, desktop, and application layers in IT infrastructure; describe business continuity solutions in a virtual data center environment; explain the key characteristics, services, and deployment models of cloud; describe the cloud infrastructure components and service management process; describe the cloud security concerns and solutions; and list the key considerations for migration to the cloud.
  • Introduction to Python Programing - The student will be able to utilize the Python programming language format and structure in coding; understand and utilize Python programming concepts, including lists, dictionaries, classes, and loops; use Python libraries and tools; debug basic Python programs; and employ Python as a means for developing information security tools.
  • Decision Making - The student will be able to use creative thinking to solve problems; develop strategies for risk analysis and risk mitigation; conduct situational analysis; use decision support systems; conduct backward planning; allocate resources to resolve problems; and apply ethics to problem-solving.
  • Web Programming –The student will be able to code using key web programming concepts, structures, and processes; explain Full Stack development and its related front- and back-end concepts and tools; develop code using JavaScript/python/ that makes advanced use of functions, loops, event control, array processing, and DOM manipulation; create templates, modules, and components using front-end frameworks; use code editors and workflow tools to effectively develop and debug code; employ version control systems, such as Git, to manage source code changes and use and share code on repository hosting services, such as GitHub; use key code libraries and front- and back-end frameworks; create responsive page layouts using front-end frameworks; use Model View Controller (MVC) design patterns, two-way data binding, and create templates, modules, and services; implement single page application using front-end frameworks; design single page application using a back-end framework which exchange data with a database; connect to databases and data sources whether SQL or NoSQL; and debug code by using online documentation and forums.
  • Web Frameworks –The student will be able to identify the industry’s most popular client-side and server-side web frameworks and the programming languages used in each; describe how client-side web frameworks are used to speed up development time and create cross-platform, accessible, responsive, and dynamic user-interfaces and web sites; describe how server-side web frameworks are used to speed up development time and create dynamic web sites and applications; use a client-side web framework to create a web page/site; use a server-side web framework (web application framework) to create a web page/site; demonstrate the use of web frameworks to create cross-platform web sites, e.g. desktops, mobile devices, etc.; and utilize an Application Programming Interface (API) to add functionality to a web page.

General Topics:

  • Core Python
  • Numpy and Pandas
  • Spark Programming
  • ETL - Informatica - Power Center Overview
  • ETL - Informatica - Data Transformation
  • Linux and Cloud
  • AWS Cloud and Quicksight Visualization
Instruction & Assessment

Instructional Strategies:

  • Classroom Exercise
  • Computer Based Training
  • Discussion
  • Laboratory
  • Learner Presentations
  • Lectures
  • Practical Exercises
  • Project-based Instruction

Methods of Assessment:

  • Other
  • Presentations
  • Quizzes
  • Individual Assignments

Minimum Passing Score:

70%
Supplemental Materials