Computer and Information Technology

Techniques of personal computer hardware maintenance and installation. Course covers hardware and software diagnostics, system troubleshooting, and methods of achieving effective system upgrades to enhance capabilities or improve system performance.

Course covers computer network infrastructure, network uses, and basic network management issues. CIT 112 has no prerequisite but assumes that students are familiar with computer hardware, have a basic understanding of stand-alone operating systems, and can use applications software.

A first course in programming. Offers an introductory course on computer program design and development. Emphasizes identification and solution of business problems through the use of logic development tools and scripting languages.

Java is a general-purpose, object-oriented programming language best known for, but not limited to, creating applets to run on the Internet. This course will include applet creation, but the primary emphasis will be on general purpose object-oriented programming.

Create and maintain web pages using HTML. Build interactive web pages using dynamic HTML. Topics include images, tables, frames, CSS styles, forms, FTP, and site maintenance.

A continuation of CIT 151, Beginning Web Development. This programming class creates interactive web pages using technologies such as Javascript, SQL, and server-side programming language.

Course covers Linux installation, configuration, and workstation operating system concepts.

Covers concepts required for Linux server system administration and common networking services configuration, operation, and management. There is no formal prerequisite, however, CIT 173 or a basic understanding of either the UNIX or Linux workstation environment is recommended.

This class is targeted for people with little or no SQL knowledge. The objective of this class is to familiarize students with database concepts that will be needed by programmers as well as professionals maintaining data management systems in such as those used in GIS. The class is accented with hands-on learning in Structured Query Language (SQL) and SQL procedures. CIT 129 recommended but not required.

Various short courses and workshops covering a variety of subjects in computer and information technology. The course will be variable credit depending on the class content and number of hours required to cover that content. No prerequisites, but various skills may be recommended depending on class content, see syllabus for any such recommendations. Unlimited repeatability. [S/U]

A hands-on course building on the foundation laid in COT 151 and continuing on to sophisticated manipulation of word processing software. Topics include tables, graphic boxes, clip art, desktop publishing, fonts, macros, styles, and spreadsheets. Recommend: COT 151.

In-depth exploration of Excel spreadsheets. Topics include advanced functions, importing and exporting data, multiple tables and workbooks, pivot tables, macros, and VBA. Team and student projects are conducted.

In-depth exploration of Access database management. Topics include tables, relationships, queries, forms, and reports. Macros, VBA modules, and web pages are created. Team and student projects are conducted in building and maintaining a database. Access 2007 required.

Introduces students to computer network server administration and management using MSMCSE II. CIT 211 or an advanced understanding of a Windows desktop environment is recommended.

Prepares professionals with some networking experience and who possess a thorough knowledge of TCP/IP to take and pass the CompTIA Security + certification exam. Topics will include general security basics of cryptography and operational/ organizational security. Working knowledge and network servers or associated certifications would be considered essential.

This course is designed to equip students with the essential skills for effective data handling using Python. It covers data analysis fundamentals, including collection, cleaning, transformation, statistical methods, and data visualization, leveraging Python libraries like pandas, numpy, matplotlib, seaborn, and scikit-learn. Practical case studies in business and sports analytics provide real-world applications, guiding students through data lifecycles and predictive modeling. Additionally, the course incorporates ChatGPT Prompt Engineering, allowing students to master the art of formulating prompts for AI language models, enhancing their data analysis capabilities.

This course serves as an introduction to data analysis using the R programming language, a powerful open-source tool for statistical computing. It provides a solid foundation in R programming, covering key aspects such as data manipulation, data visualization, and statistical analysis. Practical, real-world data analysis projects will offer hands-on experience, and by the course's end, students will be proficient in conducting data analysis and visualization with R.

Interactive web pages will be built to accomplish store front applications. Storefront software will be used to produce shopping cart applications with product display, shopping cart, check out, and confirmation web pages along with several databases.

Visual Basic for applications involves programming inside Microsoft Office, Word, Excel, and Access. This is the most common type of programming in today's work world and creates more interactivity in the office software.

The purpose of this course is to help students gain the knowledge required to effectively plan, implement, and complete IT projects across the organization. Topics will include business practices, interpersonal skills, and management process.

Covers a full range of security concepts, techniques, and applications as required by server operating systems and networks. This will include VPNs, authentication, encryption, and patching. It will culminate in discussions of monitoring, auditing, and disaster recovery. Recommended prerequisite: CIT 212 or CIT 173.

Introduction to Blockchain is a course building the foundations to blockchain technology, which is a type of distributed ledger technology: what blockchain is, how blockchain was developed, how blockchain works, and the primary issues, challenges, and opportunities blockchain faces. Students will engage in hands-on work, such as contextualized coding exercises, to lay a strong foundation for post-secondary education in blockchain development.

This course surveys essential concepts in a wide range of computing fields including database management, GIS, graphic communications, networking, and programming required by managers of computing systems and departments. This class assumes students understand at least one area of computing well then builds on that understanding to provide them with a survey of additional computing technologies that IT managers could reasonably be expected to facilitate and supervise.

Course provides in-depth coverage of TCP/IP concepts, protocols, and programming including IPv6.

eCommerce concepts and topics will be examined. Working eCommerce sites will be developed on the Internet.

This course covers concepts required to design, implement, and administer a database management system for use in a modern organization. The emphasis will be on database structures, logical and physical data organization, the relational database model, development of stored programs, and database administration.