IT - Web/Software Development (152)

152-105 -  Relational Databases  

Explore relational database concepts and the use of Structure Query Language while working within a Database Management System (DBMS). Design, build and query a relational database and its tables. Manipulate a DBMS using concepts such as stored procedures and triggers. (Prerequisite: Completion of or concurrent enrollment in 890-101 College 101)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-106 -  Web Site Design  

Design, develop and publish a web site using industry standard software with an introduction to the code being produced by the software. Enhance web sites using advanced techniques with web forms, media queries and responsive design. Credit for Prior Learning Available

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-107 -  Graphics for the Web  

Students will gain skills in optimizing graphics and photos to ensure efficient speed and mobile friendly sites. Students will gain skills in creating artboards and UI Kits as well as designing website mockups, backgrounds, navigation bars and buttons employing Adobe Photoshop. Credit for Prior Learning Available

2 Credit hours  
18 Lecture hours  
36 Lab hours  
152-108 -  Introduction to Programming  

Explores basic concepts of programming including data types, variables, expressions, arrays, collections, strings, conditional statements, streams, functions, recursion, classes and objects. Students will employ these fundamental building blocks of programming to create projects.

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-112 -  Web Coding Technologies  

Students are introduced to web design by learning to code HTML (Hypertext Markup Language) and CSS (Cascading Style Sheets) using text editor software. Focus on learning the HTML and CSS coding schemes to produce a small website by gaining skills in formatting text, inserting images and backgrounds, positioning elements on the page for layout, apply styles, both inline and via an external style sheet. CSS best practices and browser support issues are also addressed. Students gain skill in using FTP software to upload files to a web server.

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-113 -  Web Programming Technologies  

Develops skills in using programing concepts by employing the JavaScript language to create Web-based applications and to add animation and interactivity to a Web site. Addresses utilizing preexisting scripting sources, modifying script from other sources and creating original scripting features. Utilize skills gained to develop a content based mobile application. (Prerequisites: 152-112 Web Coding Technologies. Completion of or concurrent enrollment in 103-159 Computer Literacy – Microsoft Office)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-114 -  CSS Technologies  

Explores new features of CSS3. Students will create selective styling, control font properties, control text properties, manipulate color and background properties and work with list and table properties. Also covers CSS box properties, style sheets, responsive design, mobile web app styling, page layout and CSS transformation. (Prerequisite: 152-112 Web Coding Technologies)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-115 -  Design/Implementation/Maintenance Workflow  

Perform the tasks involved in the process and documentation of strategic planning, implementing and maintaining a Web site in a team-based environment. Addresses specific tasks in the Web site design, planning and development process such as project scope and proposals, budgeting, scheduling, specifications, obtaining domain names, registering Web sites, end-user analysis, statistics, testing and troubleshooting, training, and presentation topics. (Prerequisites: 152-106 Web Site Design or 152-112 Web Coding Technologies)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-116 -  Content Management Systems  

Builds skills in employing content management systems (CMS) to create dynamically updated websites. Explores the fundamentals of planning dynamic websites, CMS database management, and developing CSS-controlled site templates. Examines procedures for performing backups and restores on websites, use of third party products and hosting options. (Prerequisite: 152-118 Database Driven Websites)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-117 -  Emerging Web Technologies and Trends  

Evaluates new technologies, emerging trends, new standards and specifications in the Web development field by performing application of these in the Web site design/development process. Investigation and use of resources and tools for maintaining up-to-date skills in the field will be done. Self-directed learning skills will be developed. (Prerequisite: 152-113 Web Programming Technologies)

1 Credit hours  
36 Lab hours  
152-118 -  Database-Driven Web Sites  

Students will build a dynamic, data-driven, interactive Web site employing PHP and MySQL. Students gain skills in coding PHP language for variables, arrays, loops, functions, conditional statements in order to work up to building dynamic Web pages with a MySQL back end. Students explore blueprint applications; structure and interact with databases; build, validate and process forms; and regulate user access with passwords. Cover best practices and demonstrate refactoring techniques for improving exiting code. (Prerequisite: 152-106 Web Site Design or 152-112 Web Coding Technologies)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-119 -  Web Designer/Developer Concepts  

Provides a conceptual overview of PC computer, network, Internet, and Web site concepts. Students focus on developing and applying core Internet and Web terminology in regards to network and Internet infrastructures and development concepts. (Prerequisite: Completion of or concurrent enrollment in 890-101 College 101)

2 Credit hours  
18 Lecture hours  
36 Lab hours  
152-120 -  Web and Mobile Internship  

Provides students an opportunity to apply skills learned in prior program coursework to internship situations. Emphasis is on seeking a job, applying skills to job tasks, adapting to company culture, modeling the core abilities, and demonstrating online collaboration and communication. Employment-ready work samples are required upon course entry. Advised to enroll in last semester of program. (Prerequisite: Completion of or concurrent enrollment in 152-121 Object-Oriented Programming or 152-124 e-Commerce: Designing and Marketing Web Sites) Credit for Prior Learning Available

3 Credit hours  
18 Lecture hours  
144 Other hours  
152-121 -  Object-Oriented Programming  

Designs and outlines the logic and structure of programming. Builds skills in using object oriented programming concepts such as the use of API’s, user defined classes, and program documentation for use in developing complex web applications. Builds skills in creating classes, employing classes, use of data objects, and incorporation of RSS and XML. (Prerequisite: 152-118 Database Driven Websites)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-122 -  Migrating to Native Platforms  

Builds skills using a third party software to convert web-based mobile apps to native platforms. Explores native SDK’s (software development kits) for various mobile platforms for native application development. Examines the processes required for distribution to mobile marketplaces. Builds skills in advanced CSS technologies for use in mobile development. (Prerequisites: 152-173 Coding for iOS for Web Application Development; 152-174 UX/UI Design for iOS for Web Application Development; 152-175 Coding for Android for Web Application Development; 152-176 UX/UI Design for Android for Web Application Development)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-123 -  PHP  

In this course, you will begin to gain the knowledge you need to begin a path in becoming a PHP developer by gaining skills in employing the basic programming elements such as variables, methods, and loops; along with gaining experience with the most popular design pattern used in creating dynamic websites: MVC. (Prerequisite: Completion of or concurrent enrollment in 152-118 Database Driven Websites)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-124 -  e-Commerce: Designing and Marketing Web Sites  

Students investigate e-commerce technologies and solutions. Students will incorporating e-commerce technologies to sell products and services into a web site project. Students will investigate, plan and implement online marketing strategies including SEO, SEP, traffic building, and marketing techniques. (Prerequisite: 152-118 Database Driven Websites)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-126 -  Introduction to Systems Analysis  

Introduces the System Development Life Cycle (SDLC) as the logical sequence of steps for successful completion of a system project. All phases of the SDLC are investigated along with their rationale. (Prerequisite: Completion of or concurrent enrollment in 103-159 Computer Literacy – Microsoft Office)

3 Credit hours  
54 Lecture hours  
152-131 -  ASP.net  

Introduces the principles of creating Web base programs in ASP.NET. Students will write, test, debug and execute programs. Students use the Visual Studio.NET development suite to: interact with a database, create a user interface using HTML and ASP’s Razor Pages, and design and secure a model-view-controller based website. (Prerequisites: 152-105 Relational Databases; 152-112 Web Coding Technologies; 152-139 C# Development)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-132 -  SQL  

Gain beginning to advance levels skills in using SQL to create select statements to query and retrieve information from databases. Students will also develop using SQL for CRUD (create, read, update and delete) tasks, backup and import databases as well as exploring best practices in SQL. (Prerequisite: 152-105 Relational Databases)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-133 -  IT Project Management  

Examines the organization, planning and controlling of projects; also provides practical knowledge on managing project scope, schedule and resources. Topics include project life cycle, work breakdown structure and Gantt charts, network diagrams, scheduling techniques and resource allocation decisions. Concepts are applied through team projects and tutorials using project management software. Concepts are aligned with professional standards of project management. (Prerequisite: Completion of or concurrent enrollment in 801-197 Technical Reporting)

3 Credit hours  
54 Lecture hours  
152-137 -  Java Programming  

Introduces an overview of Java and explains its role in the computing environment. Students learn the fundamentals of the Java language, including classes and objects. Highly recommended students have prior programming experience. (Prerequisite: 152-108 Introduction to Programming)

2 Credit hours  
18 Lecture hours  
36 Lab hours  
152-138 -  Advanced Java Programming  

Advances skills programming in Java. Students will gain experience in employing use of streams, XML (Extensible Markup Language) in Java, programming network connections, using the JDBC (Java Database Connectivity) API (application programming interface), including use of the Date and Time Package API and ending with learning to manipulate graphics using Java. (Prerequisites: 152-105 Relational Databases; 152-137 Java Programming)

2 Credit hours  
18 Lecture hours  
36 Lab hours  
152-139 -  C# Development  

Introduces the principles of programming in C#. Students will write, test, debug and execute programs. Students use the Visual Studio.NET development suite to create control structures, methods, arrays, data files and object classes. Online sections: On-campus lab instruction available. (Prerequisites: 152-108 Introduction to Programming. Completion of or concurrent enrollment in 103-159 Computer Literacy – Microsoft Office)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-142 -  Software Developer Capstone  

Provides students with the opportunity to apply competencies and skills acquired throughout their study in the Information Technology - Software Developer program. Students will work in a team environment to design, integrate and develop software applications and documentation based on real-world scenarios. Technical skill attainment is measured through demonstration of program outcomes in this final-semester capstone course. (Prerequisites: Completion of or concurrent enrollment in 152-138 Advanced Java Programming; 152-148 Systems Analysis and Implementation)

3 Credit hours  
18 Lecture hours  
72 Lab hours  
152-143 -  Advanced SQL  

In this course, students will explore T-SQL implementation and standard. Students will gain skills in using this standard to perform tasks involving queries, sub-queries, table expressions, set operators, data modifications, temporal tables, transactions and programmable objects. (Prerequisite: 152-132 SQL)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-147 -  Systems Analysis and Design  

Examines the process of developing information systems that use hardware, software, data, processes and people to support a company's business objectives. Provides fundamentals for a potential systems analyst to develop business systems that will support operations, improve productivity and provide information so managers can make sound business decisions. (Prerequisite: 152-126 Introduction to Systems Analysis)

3 Credit hours  
54 Lecture hours  
152-148 -  Systems Analysis and Implementation  

Designed as a capstone experience, this course provides hands-on development and implementation of the case study project that was designed in the prerequisite class 152-147 Systems Analysis and Design. Students work as a team to code and implement a case study project. This working system finalizes the System Development Life Cycle. (Prerequisite: 152-147 Systems Analysis and Design)

3 Credit hours  
18 Lecture hours  
72 Lab hours  
152-172 -  Web Site Security  

Employs security strategies to websites. Topics covered: updating platforms and scripts, installing security plugins, securing directories and file permissions, site backups, developing username/password combinations, using server-side validation for forms and login pages, installing a security certificate, forcing login pages to a secure page, and secure FTP file transfers.

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-173 -  Coding for iOS Web Application Development  

Develops foundational skills in coding and programming languages used in iOS Web Application development. Students will employ the skills to develop an iOS Web Application for web-based delivery. (Prerequisite: Completion of or concurrent enrollment in 152-174 UX/UI Design for iOS for Web Application Development)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-174 -  UX-UI Design for iOS Web Application Development  

Employs principles of UX-UI design for the iOS based market. Students will apply design principles in creating user experiences, as well as develop hands on skills with software applications related to UX-UI design work.

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-175 -  Coding for Android Web Application Development  

Develops foundational skills in coding and programming languages used in Android Web Application development. Students will employ the skills to develop an Android Web Application for web-based delivery. (Prerequisite: Completion of or concurrent enrollment in 152-176 UX/UI Design for Android for Web Application Development)

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-176 -  UX-UI Design for Android Web Application Development  

Employs principles of UX-UI design for Android base market. Students will apply design principles in creating user experiences, as well as develop hands on skills with software applications related to UX-UI design work.

3 Credit hours  
36 Lecture hours  
36 Lab hours  
152-177 -  Introduction to VR Applications  

Explores Software Development Kits (SDK’s) that are used to create virtual reality experiences for Android and iOS apps. Students examine how SDK’s simplify common Virtual Reality (VR) development tasks and explore the smart phone as a VR platform. Students will examine the common VR tasks such as the use of smart phones to display 3D scenes with binocular rendering, tracking and reacting to head movements, and interaction with apps through the trigger input. Students will also explore steps for building apps that display 3D scenes, adapting an existing 3D app for virtual reality and/or building your own VR experience from scratch. Students will apply best practices for designing apps for VR. (Prerequisites: 152-173 Coding for iOS for Web Application Development; 152-174 UX/UI Design for iOS for Web Application Development)

3 Credit hours  
36 Lecture hours  
36 Lab hours