This course is designed for students with no prior programming experience. Through the programming languages of C and C++, the course introduces the fundamental concepts, terminology, and elements of programming. Topics include data types, functions, conditions & loops, arrays, strings, files, and libraries. In addition, the course provides an overview and basic concepts of object oriented programming. Throughout the semester, students are guided through a series of small programming projects, culminating in a personalized final project. All sessions take place in a computer lab on campus.
|sct: 1||M||9/21||6:15 PM||$655.00|
Learn the Structured Query Language, the industry-standard syntax for interacting with relational databases, using Oracle, the industry-leading database software. This course will cover database diagramming, design, and creation, entity-relationship (ER) modeling, querying, data warehousing, reporting, and more. This one course introduces you to two mainstays of the data-management world.
|sct: 1||Tu||9/22||6:15 PM||$655.00|
These free, high-performance, industry-standard technologies work together to allow the development of any type of database-driven web application without costly licensing fees. In lab sessions, participants will enhance standard HTML pages with PHP code to manage session information and store data in a MySQL database server. Prerequisite: Website design in HTML or equivalent background.
|sct: 01C||Tu||9/22||6:15 PM||$655.00|
|sct: 01C||M, W||9/21||6:15 PM||$725.00|
|sct: 1||M, W||11/2||6:15 PM||$725.00|
Designed for people who "learned on the job" as well as those who have never used spreadsheet programs before, this course teaches functions and features of Excel 2016. After an introduction to spreadsheet terminology, you will learn how to navigate worksheets, enter and edit text, values, and formulas. You will learn about absolute and relative references, and use Excel's math and date functions. Formatting and printing strategies are covered as well as conditional formatting. PREREQUISITE: Mouse and keyboard expertise navigating the Windows environment; ability to download and extract zip files.
|sct: 1||W||9/23||6:15 PM||$245.00|
In this class you will work with formulas that span across multiple worksheets and use the VLOOKUP and INDEX functions. You'll create and modify macros, protect workbooks, and use Excel's data validation features. Prerequisite: You must have expertise in using range names and/or have successfully completed the Excel 2016 Basic and Intermediate classes.
|sct: 1||W||11/4||6:15 PM||$245.00|
This course is designed to give experienced Excel 2016 users hand-on experience in creating macros that run in response to specific spreadsheet conditions, working with control structures, developing user screens to accept or display data, validating data entry as well as debugging and handling code errors. Prerequisite: Excel 2016 - Advanced or equivalent experience.
|sct: 1||M||11/2||6:15 PM||$345.00|
This course builds on the fundamentals in the Excel 2016 Basic course. In this class, you will create financial outlines and subtotals, create and manage cell range names, as well as create and modify column and pie charts. Sorting, filtering and calculations using calendar date functions will be covered as well as Pivot tables and charts. You'll also learn how to use text functions to manipulate non-numeric data. Prerequisite: Excel 2016 Basic or equivalent knowledge.
|sct: 1||W||10/14||6:15 PM||$245.00|
This introductory course is designed for Excel users who would like develop their quantitative skills for managerial decision-making. It is designed for Excel users with little or no finance background. Students will learn how to use present value, Internal Rate of Return, Standard Deviation and more. It features a mix of case studies, individual exercises and group activities. This course is appropriate for all students who wish to strengthen their quantitative skills. The emphasis is on real-world scenarios that are widely used in diverse industries. Prerequisites: ITS6005 Excel 2016 Basic or equivalent experience.
|sct: 1||Sa||12/5||9:30 AM||$245.00|
This Power Pivot course will teach you how to use Excel to analyze and manipulate very large sets of data imported from a variety of popular relational data bases (e.g. Oracle, SQL Server etc.). By the end of the course you will be able to: ? Set up relationships between tables in a data model.? Use formulas to create calculated columns, measures and hierarchies.? Create various meaningful pivot tables and charts.? Create interactive dashboard reports . This course only requires basic knowledge of Excel and is ideal for professionals across all business sectors who want to be able to aggregate, summarize, and present data efficiently and in a way that provides better business insights and informed decision making.
|sct: 1||Sa||11/21||9:30 AM||$399.00|
Java provides an ideal environment in which to grasp the universal concepts of Object Oriented Programming. Use the Java API to create Graphic User Interfaces, handle mouse events & other user input, work with data structures, manage the file system, connect to a database using JDBC, and create dynamic web pages using HTML and JSP. PREREQUISITES: Fundamentals of Programming (or prior programming experience), and Database Management with MS SQL (or prior database experience). Co-requisite: Databases and SQL Queries with Oracle
|sct: 01C||Th||9/24||6:15 PM||$695.00|
This hands-on course will cover creating web pages, organizing content with tables, planning a site structure with a site map, linking web pages, implementing navigation, publishing content to the web, and web hosting. Learn how to quickly and easily create a website even if you don't have prior programming experience!
|sct: 01C||Sa||9/26||10:00 AM||$520.00|
Develop mobile applications for iOs devices like the iPhone and the iPad using the Objective C programming language. Learn to use the iOs Software Development Kit and Xcode - Apple's Integrated Development Environment.
|sct: 1||Sa||9/26||10:00 AM||$425.00|
Developing for handheld devices is a new frontier in software. Learn about the different platforms that are available, and create a mobile application for Google's Android operating system using Java and the Eclipse Development Environment. Requirements: Completed Java programming course or equivalent; Students must provide their own laptops in class; instructor will send information about software requirements.
|sct: 1||Sa||11/7||10:00 AM||$425.00|
Gain greater control of your website's look and feel using CSS, the industry-standard technology for layout and presentation. In a series of project-driven labs, you will learn to standardize colors, fonts, and layouts across groups of pages, and to customize content for different browsers and mobile devices. Prerequisite: Build Your Own Website in HTML or equivalent background.
|sct: 01C||Sa||11/7||9:00 AM||$520.00|
Learn the basics of the programming language Python. Essential data types such as numbers, strings, lists, and dictionaries, and well as reading and writing functions will be covered. Additionally, control flow will be taught, using for-loops, while-loops, and if-statements. Students will work to produce a project using these elements as the course progresses. No prior knowledge of Python required.
|sct: 01C||Th||9/24||6:15 PM||$545.00|
Take a deeper dive into programming with Python. More advanced data types such as sets, tuples, and custom classes will be addressed. Students will also be introduced to run-time analysis and will learn about some of the applications of Python, such as writing programs to read and process CSV files and writing a web server to respond to requests. This is a project-based course and the acquired knowledge will be applicable to professional or personal uses. PREREQUISITE: Completed ?Python ? Introduction? course or demonstrated prior knowledge of Python.
|sct: 1||Th||10/29||6:15 PM||$545.00|
Visualization of data is a key requirement for business decision makers. Tableau is one of the most popular software packages to achieve rich visualization to understand data patterns and create an engaging story. This hands-on course designed for the beginner Tableau user will guide you through the foundations of the software and you will begin to generate simple visualizations and interactive worksheets and dashboards.
|sct: 1||Tu||11/10||6:15 PM||$405.00|
This course teaches basic capabilities of Google Analytics in order to understand how users find and use a website. We will cover how to navigate the application, utilize various functions, and identify core metrics that are relevant across various industries. In addition, we will explore basic reporting and dashboards. By the end of the course, participants should be able to comfortably access this data platform, identify how to pull relevant metrics to make more data-based decisions, and have a better understanding of their website?s user demographics and behavior.
|sct: 1||M||10/26||6:15 PM||$425.00|
This course introduces the key business, technical, legal and ethical issues in cybersecurity and privacy faced by business and government. Using case studies and simulations, the class will analyze the management and technical causes for breaches and actual company responses, and apply strategies and best practices for detection and prevention of data theft and intrusions.After completing the course, students will have a foundational knowledge of privacy and cybersecurity issues that must be addressed in for-profit, non-profit, and government activities and organizations.
|sct: 1||M||10/26||6:15 PM||$425.00|