Professional >> Technology
« back to courses page

Learn the basic skills and concepts needed to use Microsoft Access 2013 productively and efficiently. After an introduction to the Access 2013 environment, learn how to plan databases and create tables. Learn to organize fields and records, and to work with data entry rules. Create basic queries and work with forms and reports.   Prerequisite: Experience with Windows. Learning Objectives: Identify components of the Microsoft Office Access 2013 environment Identify the components of a database Organize data in tables Show data in a table Demonstrate how to Query a database Design forms Produce reports Note: No refunds on bundled prices.

Learn additional skills and concepts needed to use Microsoft Access 2013 productively and efficiently. Learn to normalize data, join tables while observing referential integrity, and query multiple tables. Insert background images and charts and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.   Prerequisite: Access 2013 - Beginning. Learning Objectives: Demonstrate how to streamline data entry and maintain data integrity Show how to join tables to retrieve data from unrelated tables Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries Prepare customized reports to organize the displayed information Note: No refunds on bundled prices.

Advance your skills in the AutoCAD workspace and gain the final pieces of knowledge you need to pursue the Autodesk certification after the class. Learn to work with advanced tables, annotations, editing and viewing tools of the AutoCAD software. You will create advanced dynamic blocks and attributes and learn about sheet sets. Prepare to publish and use collaboration tools all while managing layers and learning to use the right tools for optimal performance. You will complete a hands-on project in this program that can be used in your professional portfolio. Textbook is required at the first class meeting and is available at the KSU Center bookstore. Internet access is also required. It is recommended that students have access to the AutoCAD software outside of the classroom, but the software will be provided in the classroom for you to use and complete everything necessary for the class. Learning Outcomes: Demonstrate how to navigate the AutoCAD software and system setup Demonstrate how to work with advanced text objects and tables Organize and manage drawings using layers Define dynamic blocks and attributes Use publishing, collaboration, and automation tools Show how to publish, create, and customize sheet sets Demonstrate how to customize the AutoCAD user interface to increase productivity Use macros and custom routines   Prerequisite: AutoCAD Essentials and AutoCAD Intermediate or equivalent experience. High school diploma or equivalent. Complete the Basic Skills Assessment and submit Program Application if not done for previous AutoCAD classes. Working knowledge of computers and access to computer and Internet are required. The Basic Skills Assessment & Program Application are located online. Click here for the Basic Skills Assessment and Program Application instructions.

Are you interested in learning AutoCAD? Join us for an information session led by our Instructor where you will learn more about the AutoCAD Essentials and Intermediate Certificate Programs. This session will go into detail on the course prerequisites, required books, course fees, and the course syllabus. Bring your questions, because you will have an opportunity to participate in the Q&A session with the Instructor. Even if you are simply looking for more details, you will leave our information session with the tools you need to make an informed decision about your future!

AutoCAD is the most widely used computer-aided design (CAD) software for producing architectural, engineering, and construction drawings. This program will teach the core topics required for preparing professional drawings using AutoCAD.   Learn to navigate the AutoCAD workspace and use basic drawing, editing, and viewing tools of the software. You will organize drawing objects on layers and insert reusable blocks. Prepare layouts to plot and add text, hatching, and dimensions. You will complete a hands-on project in this program that can be used as a foundation for your professional portfolio. Textbook is required at the first class meeting and is available at the KSU Center bookstore. Internet access is also required. It is recommended that students have access to the AutoCAD software outside of the classroom. Learning Outcomes: Demonstrate basic drawing and editing commands Organize drawings using layers Create advanced object types such as arcs, polylines, polygons, and ellipses Set up and organize layouts in AutoCAD Create and edit text in a drawing Apply dimensions to drawings Demonstrate how to annotate drawings Prerequisite: High school diploma or equivalent. Complete the Basic Skills Assessment and submit Program Application. Working knowledge of computers and access to computer and Internet are required. Students should have a working knowledge of computers. The Basic Skills Assessment & Program Application are located online. Click here for the Basic Skills Assessment and Program Application instructions.

This course is approved for VA Education Benefits.   Do you love numbers? This unique combination course will offer you the fundamental skills of effective bookkeeping. Additionally, you will become savvy with QuickBooks accounting software on a remote computer. This virtual desktop environment allows for hands-on QuickBooks practice inside and outside of the classroom. The Department of Labor projects an 11% growth rate through 2022 as bookkeeping skills are in high demand by employers due to the increased complexity and requirements of compliance and regulation. This program will teach you to work with general ledgers, assets, liabilities, equity accounts, balance sheets and income statements. You will also learn to compute and record basic book and tax depreciation, manage bills and invoices, reconcile bank and credit card accounts, and provide financial statements for tax preparation. Textbooks required at the first class meeting and are available at the KSU Center bookstore. Internet access is also required. This course is excellent for individuals starting a business or for those operating a small business who seek experience with QuickBooks. It is also helpful for those desiring the Certified Bookkeeper (CB) designation from AIPB.org. Learning Outcomes: Create a new QuickBooks company file Manage accounts payable Demonstrate how to invoice for customer purchases of goods and/or services Manage sales taxes Show how to reconcile bank and credit card accounts Produce insightful reporting to management Prerequisite: High school diploma or equivalent. Complete the Basic Skills Assessment and submit Program Application. Working knowledge of computers and access to computer and Internet are required. Working knowledge of Windows and Excel. Accounting Fundamentals online class or equivalent experience. The Basic Skills Assessment & Program Application are located online. Click here for the Basic Skills Assessment and Program Application instructions.

Do you love numbers? This unique combination course will offer you the fundamental skills of effective bookkeeping. Additionally, you will become savvy with QuickBooks accounting software on a remote computer. This virtual desktop environment allows for hands-on QuickBooks practice inside and outside of the classroom. Join us for an information session led by our Instructor where you will learn more about the Bookkeeper Professional Certificate Program. This session will go into detail on the course prerequisites, required books, course fees, and the course syllabus. Bring your questions, because you will have an opportunity to participate in the Q&A session with the Instructor. Even if you are simply looking for more details, you will leave our information session with the tools you need to make an informed decision about your future!  

Cisco certifications were included in a list of the 15 Top-Paying IT Certifications in both 2016 and 2017 (Global Knowledge). Gain the knowledge necessary to earn the Cisco Certified Entry Networking Technician (CCENT) credential and Cisco Certified Network Associate (CCNA) credential, preparing you for a career in networking. Learn the architecture, structure, functions, components, and models of the Internet and computer networks. The principles of IP addressing and fundamentals of Ethernet concepts, media, and operations are also introduced to provide a foundation for the curriculum. You will be able to build simple LANs, perform basic configurations for routers and switches, and implement IP addressing schemes. Learn the architecture, components, and operations of routers and switches in a small, large, and complex network. You will learn to configure routers and switches for advanced functionality and develop the knowledge and skills needed to implement DHCP operations in a network. This course enables students to understand the selection criteria of network devices and WAN technologies to meet network requirements. Students will configure and troubleshoot network devices and resolve common issues with data link protocols as well as develop the knowledge and skills needed to implement virtual private network (VPN) operations in a complex network. Textbooks are required at the first class meeting and are available at the KSU Center bookstore. Internet access is required. 1GB USB required for class. We strongly recommend that you have a basic knowledge of networking before entering the class. Learning Outcomes: Describe the devices and services used to support communications in data networks and the Internet Design an IP addressing scheme to provide network connectivity for a small to medium-sized business network Explain how switching operates in a small to medium-sized business network Use monitoring tools available for small to medium-sized business networks Employ DHCP, network address translation (NAT), and access control lists (ACLs) to filter traffic Set up and configure Ethernet switch ports Use monitoring tools and network management protocols to troubleshoot data networks Set up, verify, and troubleshoot VLANs spanning multiple switches: VTP, DTP and EtherChannel Set up, verify, and troubleshoot STP protocols: Rapid Spanning Tree Protocol (RSTP), Per VLAN Spanning Tree Plus Protocol (PVST+) and Rapid Per VLAN Spanning Tree Plus Protocol (RPVST+) Explain, configure, and troubleshoot first hop redundancy protocols (HSRP) Describe dynamic routing protocols, distance vector routing protocols, and link-state routing protocols Set up, verify, and troubleshoot routers in a complex routed IPv4 or IPv6 network using single-area OSPF, multi-area OSPF, and Enhanced Interior Gateway Routing Protocol (EIGRP) Describe different WAN technologies and the benefits of virtual private networks (VPNs) and tunneling Set up, configure, verify, and troubleshoot tunneling operations, network problems using SPAN, serial connections: HDLC and PPP, and eBGP in a single-homed remote access network Use SNMP to monitor network operations in a small to medium-sized business network Describe basic QoS concepts: network transmission characteristics, queueing algorithms and QoS mechanisms Describe Cloud Computing and Network Programmability in an enterprise network architecture Identify and troubleshoot end-to-end connectivity in a small to medium-sized business network, using a systematic approach Prerequisite: Complete Cisco Skills Assessment and Application.

Are you interested in earning your Cisco certification? Join us for an information session led by our Instructor where you will learn more about the Cisco Certificate Program. This session will go into detail on the course prerequisites, required books, course fees, and the course syllabus. Bring your questions, because you will have an opportunity to participate in the Q&A session with the Instructor. Even if you are simply looking for more details, you will leave our information session with the tools you need to make an informed decision about your future!

Companies are falling victim to data breaches at an alarming rate. By 2020, enterprises and governments will fail to protect 75% of sensitive data (Gartner). Become a part of the solution by training to be an asset in this critical industry. Enter the world of ethical hacking by learning to understand and identify weaknesses and vulnerabilities in target systems. You will use the same methods and tools as a malicious hacker, but in a lawful and ethical manner to evaluate the target system’s security. This class will help prepare you to take the Certified Ethical Hacker (CEH) certification exam. Textbook is required at the first class meeting and is available at the KSU Center bookstore. Internet access is also required. It is strongly recommended that students have a background or interest in information security. The CEH credential certifies individuals in the specific network security discipline of Ethical Hacking from a vendor-neutral perspective. You can find more information about this certification by visiting https://www.eccouncil.org Learning Outcomes: Assess ethical and legal requirements of security assessment and penetration testing and determine a strategy to comply with these requirements. Analyze different phases of hacking and recommend the strategy to use ethical hacking for assessing security of various components of information systems. Compare and contrast different hacking techniques and analyze the legal implications of hacking. Examine different vulnerabilities, threats, and attacks to information systems and recommend the countermeasures. Analyze cryptography algorithms and encryption techniques, and design implementation strategies for securing information. Compare and contrast various network security assessments and hacking tools. Assess various network security techniques and tools, and implement the appropriate level of information security controls based on evidence, information, and research. Prerequisite: High school diploma or equivalent. Complete the Basic Skills Assessment and submit Program Application. Working knowledge of computers and access to computer and Internet are required. Students should have a basic understanding of network operations and security terminology. The Basic Skills Assessment & Program Application are located online. Click here for the Basic Skills Assessment and Program Application instructions. Textbooks are required on the first day of class. Textbooks should be purchased new as you will need the access codes included in them for class. In addition, students will need to purchase access to the iLab site, but will get an academic discount. This will give 6 months of access to a virtual lab environment with step-by-step instructions where you can practice at home and in the classroom. Further instructions for purchasing iLabs will be available closer to class time.  

Are you interested in the field of ethical hacking? Join us for an information session led by the course Instructor where you will learn more about the Ethical Hacker Certificate. This session will provide details on the course prerequisites, required books, course fees, and the course syllabus. Bring your questions, because you will have an opportunity to participate in the Q&A session with the Instructor. Even if you are unsure of your career path or simply looking for more details, you will leave our information session with the tools you need to make an informed decision about your future! Visit the Ethical Hacker Certificate Program webpage for a complete course description.

Build on skills acquired in Excel 2013 Intermediate by working with advanced functions and formulas, as well as lookup functions. Learn about data validation and advanced data filtering. Apply advanced chart formatting and create complex charts. Work with PivotTables and PivotCharts, export and import data, and query external databases. Explore Excel’s analytical features, run and record macros, and discover VBA code.   Prerequisite: Excel 2013 - Intermediate Learning Objectives: Recognize advanced functions and formulas Set up lookups and data tables Use advanced data management and charting Create and work with PivotTables and PivotCharts Show how to Export and import data Use analytical tools Apply Macros and Visual Basic Recognize accessibility and language features