Professional >> Technology

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.

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. 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.

Continue learning how to work more effectively in AutoCAD in this Intermediate-level class. You will be able to better utilize productivity tools and learn how to work with constraints. Create and organize more advanced blocks and layouts as well as build templates and annotation styles from scratch. Learn how to use zoom commands, external references, QuickCalc, and dimensioning tools for a more complete and advanced drawing. 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: Operate the AutoCAD software effectively Use accurate positioning and coordinate entry Create and organize drawings using blocks and constraints Set up advanced layouts Create and modify drawings using external references Use advanced Annotation and Dimension styles Demonstrate how to use advanced productivity tools Prerequisites: AutoCAD Essentials or equivalent working experience. Students should have a working knowledge of computers. Skills Assessment & Program Application are located online. Click for instructions. You will be directed to the program application after completing the Skills Assessment.

It has been reported that the number one qualification employers seek in a potential new employee is computer skills.  This course will equip you with the most up-to-date technology skills in an ever-changing discipline.  You will gain a technical understanding of the desktop computer, notebook computer, smart phone, portable media player, and digital camera.  This course will teach you the fundamentals of computers, software, and the Web.   In addition to gaining a practical understanding of the computer, through application and instruction, you will gain intermediate-level skills to create documents, presentations, worksheets, and databases using the various Microsoft Office products:  Windows 10, Internet Explorer 11, Word 2013, PowerPoint 2013, Excel 2013, and Access 2013.  This course provides the perfect opportunity to empower you with the skills and knowledge to either enter or advance your skills as an Office Professional. Prerequisites:  High School Diploma or equivalency. Complete Skills Assessment and submit Program Application. Computer and Internet access required. Basic knowledge of Windows Operating System is also required.    Textbook: "Discovering Computers & Microsoft Office 2013: A Fundamental Combined Approach" by Shelly/Vermaat      Textbook and a flash drive are required at the first class meeting and are available at the KSU Center bookstore. It is recommended that students purchase Microsoft Office 2013, but it is not required to successfully complete the class. Additional material to use as independent study is available for purchase at www.cengagebrain.com.  The purchase of this material is not necessary to complete the class.      

Find out how this course will equip you with the most up-to-date technology in an ever-changing discipline. You will gain a working understanding of the functionality of the desktop computer, notebook computer, smart phone, portable media player, and digital camera. It will also teach you the fundamentals of computers, software, and the Web. In addition to gaining a working knowledge of the computer through application and instruction you will gain the skills to create documents, presentations, worksheets, and databases using the various Microsoft Office products: Windows 7, Internet Explorer 8, Word 2013, PowerPoint 2013, Excel 2013, and Access 2013. This course provides the perfect opportunity to empower you with the skills and knowledge to either enter or advance your skills as an Office Professional.

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. 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.

Please note, this is the combined CCENT and CCNA class. Cisco certifications were included in a list of the 15 Top-Paying IT Certifications in both 2015 and 2016 (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. 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 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!

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 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.    

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

Learn the fundamental concepts of Microsoft Excel 2013, including identifying Excel window components, navigating worksheets, and downloading templates. Learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. Move and copy data and formulas, work with ranges, rows, and columns. Learn how to use simple functions and formatting. Create charts and graphics.   Prerequisite: Experience with Windows Learning Objectives: Create an Excel workbook and navigate worksheets. Identify order of operations. Demonstrate how to move and copy data and formulas. Use SUM function; perform calculations. Apply formatting to a worksheet Create inserted charts and graphics Prepare workbook contents for printing. Note: No refunds on bundled prices.