IT / Computer Applications

The Information Technology faculty of the Center for Business and Professional Development at UA fort Smith are all authorized and certified instructors in their areas of expertise and are all professional educators.  When you enroll in a class taught by a member of our Information Technology team, you will be gaining the most current and relevant information and certification courses offered in Business Technology, Web Business Marketing, College Credit Courses or Noncredit Microsoft Office Courses.

Microsoft Office 2010 is the version currently in use in UA Fort Smith computer labs, but the courses will benefit users of all versions of Microsoft Office.  For additional information, please contact Micki Voelkel at 479-788-7771 or by email Micki Voelkel.

Business Technology

Introduction to PC's for the Workplace

This 4-hour class is for anyone new to computers and will cover only the basics.  Introduction to hardware, input devices such as a mouse, keyboard, monitor and printers, protecting your computer against viruses, basic email, and managing data are included in the topics covered.    

Killer Presentations: No Bullets

Typical presentation design inhibits rather than promotes audience attention to and retention of information that you share.  Learn an exciting new approach to presentation design that you can use to keep your audience excited and engaged instead of napping.  This fun and interactive session will provide you with the resources and the research to improve presentations on any subject. 

Please contact Micki Voelkel for information. 
 

College Credit Classes

WFL 1631 Data Fundamentals Using Microsoft Access (Beginning Access)

Topics for this one-credit hour college level course include database terminology and concepts, exploring an existing Access database, creating a database file, creating and populating tables, creating simple queries, calculating in queries, table relationships, and simple forms and reports.

Please contact Micki Voelkel for information.
 

WFL 2661 Database Standards and Design Using Microsoft Access (Intermediate Access)

This one-credit hour college level course will teach you design and development of relational databases using intermediate-level Microsoft Access. Topics include data normalization and related tables, creation of forms using
combo boxes and calculated controls, creation of data-access pages, and creating of reports using calculated controls. Prerequisites for this course are ITA 1201 Computer Database or WFL 1631 Data Fundamentals Using Microsoft Access or consent of the instructor.

Please contact Micki Voelkel for information.
 

WFL 2671 Data Control and Analysis using Microsoft Access (Advanced Access)

Topics for this one-credit hour college level course include parameter and action queries, queries using inner-, outer- and self-joins, forms using tab controls, subforms and option groups, reports using advanced calculations, and macros. Prerequisites for this course are WFL 2661 Database Standards and Design Using Microsoft Access or consent of the instructor.

Please contact Micki Voelkel for information.
 

WFL 1611 Basic Business Calculations Using Microsoft Excel (Beginning Excel)

Learn the fundamentals of spreadsheet designing this one-credit hour college level course. Topics include entering and editing data, simple formulas, the order of mathematical operations, simple functions, absolute cell references, worksheet formatting, page setup and simple charts.

WFL 2631 Business Data Analysis Using Microsoft Excel (Intermediate Excel)

Topics for this one-credit hour course include creating multi-sheet workbook using 3-D formulas, creating decision-making formulas, calculating payments and future values of investments, and using lists to sort, filter, and subtotal data. Prerequisites for this course are WFL 2603 Integrating Technology with Management, ITA 1251 Computer Spreadsheets or WFL 1611 Basic Business Communications Using Microsoft Excel.

WFL 2641 Process Improvement Calculations using Microsoft Excel (Advanced Excel)

This one credit-hour course includes advanced spreadsheet calculations for business and industry. Topics are: complex decision-making formulas and functions, pivot tables and charts, worksheet protection and templates, data consolidation, and macros. Prerequisites for this course are WFL 2631 Business Data Analysis Using Microsoft Excel or consent of the instructor.

WFL 1621 Basic Electronic Presentations Using Microsoft PowerPoint (Beginning PowerPoint)

Topics for this one-credit hour college level course include creating and delivering electronic presentations, working with graphics including graphics files, clip art, word art and drawing tools, charting, animation, and sound. 

Please contact Micki Voelkel for information. 
 

WFL 2651 Advanced Electronic Presentations Using Microsoft PowerPoint (Advanced PowerPoint)

One-credit hour course that includes creating templates using custom backgrounds, color schemes and slide masters, advanced multimedia including movies, animated GIF's, sound files and animation, creation of interactive presentations using hyperlinks and custom shows. Effective presentation delivery will also be stressed. Prerequisites for this course are WFL 2603 Integrating Technology with Management or ITA 1101 Computer-Presentation Graphics or WFL 1621 Basic Electronic Presentations Using Microsoft PowerPoint. 

WFL 1601 Basic Business Communications Using Microsoft Word (Beginning Word)

Basic word-processing skills provided in a business context. Topics in this one-credit hour course include text entry and editing, character formatting, paragraph formatting, tabs, tables, document formatting, and print setup. 

Please contact Micki Voelkel for information. 
 

WFL 2611 Electronic Communication using Word (Intermediate Word)

The mechanics of creating business documents using intermediate level Microsoft Word skills. Topics include: documents with multiple sections and multiple document formats, advanced tables, creating of business mailings using mail merge, and document automation using styles, templates and other automation features. Prerequisites for this one-credit hour course are WFL 2603 Integrating Technology with Management , ITA 1051 Computer-Word Processing, or WFL 1601 Basic Business Communications Using Microsoft Word. 

Please contact Micki Voelkel for information.
 

WFL 2621 Process and Policy Documentation Using Microsoft Word (Advanced Word)

Advanced word-processing skills necessary to create process and policy documentation in business and industry. Topics include automatic indexes and tables of contents, advanced graphics, document sharing and change tracking, and Webpage development using Microsoft Word.

Please contact Micki Voelkel for information.
 

Integrating Technology with Management

WFL 2603 Integrating Technology with Management

This three-credit hour course includes instruction and hands-on application using office and enterprise management software to identify, gather, classify, analyze and present information.

Please contact Micki Voelkel for information.
 

Non-credit Classes

Beginning Microsoft Access

This 8-hour course covers the basics of database terminology and concepts, creating database files, creating and editing tables, working with table data, creating select queries, creating calculations in queries, creating forms and reports using the wizards. Instructor is subject to change.

Please contact Micki Voelkel for information.
 

Intermediate Microsoft Access

Covers the basics of database design, including table relationships and normalization of data. Also includes ways of controlling data entry through table design, queries that include concatenated fields, updatable queries, forms with combo boxes and calculated controls, and reports with calculated controls and manual grouping. Instructor is subject to change. 

Please contact Micki Voelkel for information. 
 

Advanced Microsoft Access

Covered in this 8-hour course are parameter and action queries, crosstab queries, specialized table joins, advanced form techniques including calculated controls using functions, tab controls, macros, and advanced report techniques including check boxes and calculated controls using functions. Instructor is subject to change.

Please contact Micki Voelkel for information. 
 

Beginning Microsoft Excel

In this course, you'll learn to create and format an Excel worksheet, organize the data in your worksheet so that it's much easier to work with and various other basic tasks. Recommended for new users but will also benefit experienced users of previous versions. Instructor is subject to change.

Intermediate Microsoft Excel

This 8-hour course will cover multi-sheet workbooks using 3D formulas and functions, IF functions, Nested IF functions, PMT functions, and working with data lists (sorting, custom lists, subtotaling filtering and Dfunctions). Instructor is subject to change.

Advanced Microsoft Excel

Topics in this 8-hour course include lookup tables and lookup functions, pivot tables, customized toolbars, macros, files passwords and protection, sheet and cell protection, data consolidation, solver and goal seek. Instructor is subject to change.

Beginning Microsoft Outlook

Topics covered in this 4-hour course include using the Inbox to read, create, send, and reply to messages; set delivery options and flag messages; using the Contacts folder to manage email addresses; using the Tasks folder to add, edit, and mark tasks; create and organize meetings by using the Calendar. Instructor is subject to change.

Please contact Micki Voelkel for information. 

Manage Your Time with Microsoft Outlook

Learn tips to help you use Microsoft Outlook to focus and manage your time.  Based on the time-management principles in the 7 Habits of Highly Effective People, this class focuses on ways to use the features of Microsoft Outlook to help you plan your time more efficiently.  The course will focus on basic time mangement principles, Outlook essentials using Mail and Calendar, Weekly and Daily planning adjustments you can make in Outlook, and some extra tools that can help you keep your organization going strong. 

Please contact Micki Voelkel for information. 

Beginning Microsoft PowerPoint

Master PowerPoint from the beginning with this 8-hour basic course. The course will cover the fundamentals of the newest version of Microsoft PowerPoint. Recommended for new users but will also benefit experienced users. Instructor is subject to change. 

Please contact Karen Harmon for information. 

Intermediate/Advanced Microsoft PowerPoint

This 8-hour course covers custom backgrounds and templates, inserting new slide and title masters, working with multimedia clips, advanced animation and animation schemes, creating custom shows, linking between shows, using hyperlinks, creating action buttons, and tips for creating effective presentations. Instructor is subject to change.

Please contact Karen Harmon for information.

Animation and Multimedia in Microsoft PowerPoint

Learn to insert movies, sound and create fun animations in PowerPoint. Focuses on entrance, exit and motion path animation as well as audio and video effects. Instructor is subject to change.

Please contact Micki Voelkel for information.
 

Beginning Microsoft Project 2010

Topics in this 8-hour course include working with project files, task lists, creating and assigning resources, base calendars, working with views, filtering, grouping, sorting, and finalizing schedules. Instructor is subject to change. 

Please contact Micki Voelkel for information.
 

Beginning Microsoft Word

This basic course is designed to give you easy access to every command and feature of Microsoft Word. New features will make creating, editing and formatting documents much easier. Recommended for new users but will also benefit experienced users of previous versions. Instructor is subject to change.  

Please contact Karen Harmon for information.
 

Intermediate Microsoft Word

Covers section breaks, multiple headers and footers, automatic page numbering, footnotes and endnotes, newspaper columns, mail merges, using existing templates and wizards, creating your own templates, AutoText entries and styles. Instructor is subject to change.  

Please contact Karen Harmon for information.
 

Advanced Microsoft Word

Covers macros, long document features such as Master Documents, automatic tables of contents, indexes, tables of authorities, etc., track and consolidate change, save multiple versions of a document, and create advanced graphics. Instructor is subject to change.  

Please contact Karen Harmon for information.
 

Web Business Marketing

Social Networking 101

Are your colleagues all atwitter about Twitter? Think Facebook is just for kids? This fun session will introduce the basics of Twitter, Facebook, LinkedIn, and some specialized social networks. Participants will have the opportunity to set up their accounts and practice using the accounts.

Please contact Micki Voelkel for information. 
 

Marketing Using Social Networking

Social networking sites like Twitter and Facebook and free bloggin sites like Blogger.com can be valuable business tools to drive potential customers to your business. Check out techniques for marketing your business online by looking at examples of how several organizations are using these networks to maintain an online presence.

Registration is required for all non-credit classes prior to the start date.  To register, please email Karen Harmon or call 479-788-7742.