BT110 Business Editing  (Course offered online)

Credits 3Spring

Registration Requirement: RD090 and WR090, or IECC201R and IECC201W, each with a grade of "C" or better; or placement above stated course levels. Flash/jump drive is required on the first day of class.

This course provides an opportunity for in-depth study of the mechanics of language; review of grammar and punctuation rules; and practice in correcting, editing and revising business documents.

View Course Outcomes:

1. Compose messages using common business communication format (memo style)
2. Identify and correct the most common errors in the mechanics of business writing
3. Properly spell commonly misspelled words
4. Use an approved dictionary as a valuable writing resource
5. Use editing marks used in business

BT116 Communication Technologies

Credits 3Winter

Registration Requirement: RD090 and WR090, or IECC201R and IECC201W, each with a grade of "C" or better; or placement above stated course levels.

In this course students are exposed to new communications technologies. To maximize employment opportunities and business skills, students will learn Microsoft's most popular information tool, Microsoft Outlook. Students become familiar with this high-powered organizational tool in a model office environment, which is the key to using Microsoft Outlook software effectively and efficiently. The most current business etiquette techniques are discussed and reviewed while students work with email, calendaring, handling contacts and strategies in using business telephone systems. Flash/jump drive is required on the first day of class.

View Course Outcomes:

1. "Demonstrate competency in placing outgoing calls
2. answering, screening, and transferring incoming calls
3. and setting up conference calls
4. Discuss current communication management technologies
5. Record and critique voice and delivery on the telephone
6. Use a customer service attitude
7. ""Use Microsoft Outlook in an """"intranet"""" classroom environment to:a. Compose, send and receive email.b. Schedule meetings, appointments and events.c. Create and store contacts.d. Customize and organize Outlook.e. Create and use tasks""
8. Use telephone resources
9. "

BT123A Keyboarding Skill Development

Credits 3Fall/Winter/Spring

Registration Requirement: RD090 or IECC201R with a grade of "C" or better, or placement above stated course level; and familiarity with keyboarding and the ability to type by touch at a minimum of 20 words per minute. USB drive is required on the first day of class.

Students can improve speed and/or accuracy with this course. This is a lab/lecture course using a specific software package in a self-directed instructional environment as a lab activity. This course provides students with an opportunity for diagnosing and evaluating computer keyboarding problems, prescribing and developing individualized practice and increasing speed and accuracy skill development. USB drive is required on the first day of class.

View Course Outcomes:

1. Demonstrate ability to self-assess speed and accuracy level and use appropriate drills and achieve improvements
2. Demonstrate appropriate use of computerized software
3. Demonstrate appropriate use of keyboarding technique
4. Determine achievement of goals through post test timed writings
5. Determine keyboarding problems areas through diagnostic tests
6. Establish and meet a skill building goal
7. Identify common concentration errors that are roadblocks to improved accuracy and speed
8. Measure beginning speed and accuracy through pretest writings
9. Measure skill development at regular periods
10. Practice specifically designed exercises
11. Select appropriate practice lessons based on diagnostic test analysis

BT123B Keyboarding Skill Refinement

Credits 3Fall/Winter/Spring

Registration Requirement: BT123A.

Students continue to improve accuracy and speed for sustained employability. This intermediate course provides students with the opportunity to improve both speed and accuracy at the keyboard. Utilizing a computerized diagnostic system, students are provided with an opportunity for self-diagnosing and evaluating computer keyboarding problems, prescribing and developing individualized practice, and speed and accuracy skill development.

View Course Outcomes:

1. Apply principles of skill development to self-assessment of accuracy and speed progress
2. Demonstrate appropriate use of computerized software
3. Demonstrate appropriate use of keyboarding technique
4. Determine achievement of goals through post test timed writings
5. Determine keyboarding problems areas through diagnostic tests
6. Develop speed and accuracy through the use of skill development paragraphs
7. Establish a skill building goal for numeric keyboard/keypad
8. Establish and meet a skill building goal
9. Identify common concentration errors that are roadblocks to improved accuracy and speed
10. Measure beginning speed and accuracy through pretest writings
11. Measure numeric keypad beginning speed and accuracy through pretest timed writings
12. Measure skill development at regular periods
13. Practice specifically designed exercises
14. Select appropriate practice lessons based on diagnostic test analysis
15. Use numeric keypad to complete data entry

BT210ZAA Access - Level I

Credit 1Fall/Winter/Spring

Registration Requirement: RD090 or IECC201R with a grade of "C" or better, or placement above stated course level; and a previous computer course and familiarity with Windows environment.

Learn basic operations of a database using Access. USB is required on the first day of class. Prior knowledge of Microsoft applications is recommended. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment.

Additional Course Fee: $25.00

View Course Outcomes:

1. "Create a ""one"" to ""many"" relationship between two tables
2. Create a database and tables
3. Create a variety of commonly used queries, including simple criterion queries, wild cards, comparison operators, compound criterion, parameter, and calculated
4. Sort data in datasheet view
5. Use the design view of a table structure to create data validation rules
6. "

BT210ZAB Access - Level II

Credit 1Fall/Winter/Spring

Registration Requirement: BA131 or BT118 or BT210ZAA; or instructor consent.

Learn intermediate operations of a database using Access. USB drive is required on the first day of class. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment. BT210 classes can be added during the current term by bringing an ADD slip to one of the required orientations during Week 1 (for section 60) and/or during Week 6 (for section 70).

Additional Course Fee: $25.00

View Course Outcomes:

1. Create advanced queries and reports
2. Create and enhance reports to display data
3. Create and use forms to add/delete records
4. Create simple macros to create more efficient processes in data manipulation and display of data information
5. Use Access templates to improve gathering of data information

BT210ZEA Excel - Level I

Credit 1Fall/Winter/Spring

Registration Requirement: RD090 or IECC201R; and MTH20; each with a grade of "C" or better; or placement above stated course levels; and a beginning Windows course or equivalent experience.

Create simple spreadsheets using Excel. USB drive is required on the first day of class. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment.

Additional Course Fee: $25.00

View Course Outcomes:

1. Apply mathematical order of operations when using parentheses, exponents, multiplication, division, addition, and subtraction
2. Create and edit formulas, including AutoSUM and other common functions such as AVERAGE, COUNT, MA,X MIN, TODAY, NOW, IF, VLOOKUP, and HLOOKUP
3. Create, design, size, position, and edit Excel chart objects and create chart sheets
4. Create, save and open an Excel workbook
5. Demonstrate use of range names and relative, absolute, and mixed cell references in a formula
6. Edit a workbook by entering and deleting text, using the Fill Handle to complete a series, and using the cut, copy and paste features
7. Finalize a workbook by spell checking, adding document properties, applying page setup options, and printing
8. Format a worksheet using different font attributes, borders, shading, cell styles, themes, and the Format Painter
9. Insert, delete, edit, format, and rearrange worksheets
10. Resize, insert, delete, and hide and unhide columns and rows in a worksheet

BT210ZEB Excel - Level II

Credit 1Fall/Winter/Spring

Registration Requirement: BA131 or BT210ZEA, Excel - Level I; or instructor consent. Flash/jump drive is required on the first day of class. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment. BT210 classes can be added during the current term by bringing an ADD slip to one of the required orientations during Week 1 (for section 60) and/or during Week 6 (for section 70).

Learn intermediate features and functions of Excel. Flash/jump drive is required on the first day of class. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment. BT210 classes can be added during the current term by bringing an ADD slip to one of the required orientations during Week 1 (for section 60) and/or during Week 6 (for section 70).

Additional Course Fee: $25.00

View Course Outcomes:

1. Apply and manage Conditional Formatting using cell rules, Color Scales, Icon Sets, and Data Bars
2. Build and use database, logical functions, statistical calculations, financial functions, and Lookup and Reference functions in Excel worksheets
3. Create and format an Excel table and a PivotTable, and export data for use in other programs
4. Create both a static, and a dynamic consolidation of data from multiple worksheets and linked workbooks
5. Group worksheets and edit and format grouped worksheets using SmartArt, hyperlinks, and screenshots
6. Import data into Excel from a text file, database file, or web site and use Flash Fill and data connections
7. Sort data by text, number, color, or icon using AutoFilter or an Advanced Filter to data
8. Use commands such as Subtotal, Goal Seek, and Protection
9. Use multiple criteria in functions such as SUMIFS, AVERAGEIFS, and COUNTIFS

BT210ZEC Excel - Level III

Credit 1Fall/Winter/Spring

Registration Requirement: BT210ZEB or instructor consent.

A hands-on course which expands on the intermediate excel spreadsheet knowledge. Emphasis will be on spreadsheet advanced functions such as database-like activities of sort and query; macros, recorded and written; and creating specialized menus. Flash/jump drive is required on the first day of class. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment. BT210 classes can be added during the current term by bringing an ADD slip to one of the required orientations during Week 1 (for section 60) and/or during Week 6 (for section 70).

Additional Course Fee: $25.00

View Course Outcomes:

1. Create a workbook from a template, save a new template, and mark a workbook as final and encrypt a workbook with a password
2. Create and manage scenarios for worksheet data using Scenario Manager
3. Create and use a form with form controls and ActiveX controls
4. Create data validation, input messages and error alerts
5. Create, edit, enable, and disable macros and record a new macro and save an Excel macro-enabled workbook
6. Inspect a workbook, check compatibility, and define a trusted location
7. Install and use Solver to find solutions and create reports
8. Perform advanced tasks such as customizing a PivotTable and PivotChart, and building one-variable, as well as two-variable, data tables
9. Perform the steps necessary to share a workbook, set change tracking options, and compare and merge workbooks
10. Perform the steps of Importing and working with XML data

BT210ZPA PowerPoint - Level I

Credit 1Fall/Winter/Spring

Registration Requirement: RD090 or IECC201R with a grade of "C" or better, or placement above stated course level; and a previous computer course and familiarity with Windows environment.

Learn basic operations and create presentations using PowerPoint. Flash/jump drive is required on the first day of class. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment.

Additional Course Fee: $25.00

View Course Outcomes:

1. Create charts that show relationships between data values and emphasize data in different ways
2. Create, open, develop, rearrange, and save a presentation using a variety of presentation functions and commands
3. Demonstrate changing file properties and presentation preview of print slides, handouts, and outlines
4. Link to an online video in a presentation
5. Organize information in a grid format using tables and customize the arrangement of columns and rows, emphasizing portions of a table by applying styles, colors, and effects
6. Search for pictures and illustrations, modify picture appearance, and compress picture file size
7. Use and modify styles, shapes, WordArt, color, and themes to change slide size and use the Slide Master to change theme colors and fonts
8. Use headers and footers to add identifying information and transition and animation effects to add visual information and interest
9. Use rehearsal techniques to prepare for presentation delivery

BT210ZPB PowerPoint - Level II

Credit 1Fall/Winter/Spring

Registration Requirement: BA131 or BT210ZPA; or instructor consent.

Intermediate operations of presentation software using PowerPoint. Flash/jump drive is required on the first day of class. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment. BT210 classes can be added during the current term by bringing an ADD slip to one of the required orientations during Week 1 (for section 60) and/or during Week 6 (for section 70).

Additional Course Fee: $25.00

View Course Outcomes:

1. Add advanced animation, hyperlinks, and rich media to presentations
2. Create folders and add, move, copy, and share files in cloud storage and create a group in the cloud, invite a member, and change group options
3. Customize images, illustrations, and themes through the use of various PowerPoint tools
4. Edit pictures to make photo corrections, apply artistic effects, adjust picture order, layout, captions, and remove backgrounds
5. recolor illustrated images
6. Practice using collaboration and sharing tools to include adapting presentations for accessibility, checking compatibility, inserting, editing, and reviewing comments, comparing presentations, considering reviewer feedback, and collaborating on a presentation in Office Web Apps
7. Protect a presentation by marking it as final and adding a password
8. Share a presentation by sending it as an email attachment, presenting online, or publishing slides
9. Use a Slide Master to create a custom theme with new colors, fonts, and background and create and use a custom template

BT210ZWA Word - Level I

Credit 1Fall/Winter/Spring

Registration Requirement: RD090 or IECC201R with a grade of "C" or better, or placement above stated course level; and keyboarding speed of 20 wpm; and a beginning Windows course; or equivalent experience.

Create, edit and format documents using Microsoft Word. Flash/jump drive is required on the first day of class. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment.

Additional Course Fee: $25.00

View Course Outcomes:

1. Create a finalized document using Word's proofing tools and applying custom document properties
2. Create and edit documents using Word features such as selection techniques, word wrap, AutoComplete, AutoCorrect, AutoFormat, paragraph breaks, line breaks, spaces, non-breaking spaces, cut, copy, paste, the Clipboard, and the undo, redo, and repeat features
3. Create enhanced document layouts by effectively using page numbers, headers, footers, tab stops, and controlling pagination with page and section breaks
4. Customize and enhance documents using different fonts, font sizes, and attributes, text alignment, line and paragraph spacing, margins, page orientation, paper size, vertical and horizontal alignment, and customized bulleted and numbered lists
5. Demonstrate efficiency and consistency in working with reports and multi-page documents by formatting with styles and themes, using find and replace, integrating bookmarks, creating and editing a table of contents based on headings, and inserting a cover page and modifying content and document fields
6. Improve overall document design and format by using borders, shading, horizontal lines, hyperlinks, and applying custom headers and footers
7. Use Word tools to create a bibliography using proper source format, to include inserting citations, footnotes and endnotes

BT210ZWB Word - Level II

Credit 1Fall/Winter/Spring

Registration Requirement: BA131 or BT210ZWA; or instructor consent.

Learn intermediate features and functions of Microsoft Word. Keyboarding skills are recommended. Flash/jump drive is required on the first day of class. Every attempt will be made to accommodate all students wanting to add BT210 classes. All sections with the same meeting time share seats and will not close until all similarly scheduled courses reach a total maximum enrollment. BT210 classes can be added during the current term by bringing an ADD slip to one of the required orientations during Week 1 (for section 60) and/or during Week 6 (for section 70).

Additional Course Fee: $25.00

View Course Outcomes:

1. Create and edit tables, columns, and graphics within Word documents
2. Create, use, and/or customize a template from a blank document or an existing Word document
3. Demonstrate use of advanced tables and graphics functions in Word
4. Enhance the appearance and function of a table by using the Table Tools tabs, applying borders and shading, using table styles, inserting formulas, and converting text into a table
5. Use custom styles and building blocks to create and enhance document creation
6. Use Word to create envelopes, mailing labels, recipient lists, and merged documents using the Mailings tab

BT271 Advanced Business Projects

Credits 3Spring

Students will use the processes, techniques, and tools needed by a project manager in an office setting to complete projects alone and as part of a team. Students will practice using oral and written communications, analyzing information, problem solving, decision making, prioritizing, and using time management skills in this capstone course that combines knowledge and skills acquired in foundation courses, such as word processing, document formatting, proofreading, and editing.

View Course Outcomes:

1. Analyze and interpret information to make decisions that accomplish the goals of a project
2. Collaborate with colleagues to recognize problems, develop potential solutions, and evaluate the effectiveness of the results
3. Demonstrate the ability to communicate in oral and written format in diverse office environments
4. Demonstrate the ability to function professionally and effectively as an individual and as a team member is a variety of situations
5. Demonstrate the ability to perform a range of office procedures and generate documents such as letters, forms, memos, and spreadsheets using a variety of industry standard software and equipment