Elective Courses Taught: IFS 490

Advanced Concepts and Techniques Business Computing

Application of computer hardware, software, and computing techniques to common business problems and activities: microcomputers and business productivity packages including word processors, spreadsheets, databases, and other systems and applications software; extensive hands-on work in a graphical user environment. PREREQ: Introduction to Business Computing or equivalent.

• Syllabus for Course:
• Weekly Notes:
• Computer Assignments:

Microsoft Word topics:

1. Creating a Document with a Title Page and Tables
2. Generating Form Letters, Mailing Labels, and Envelopes
3. Creating a Professional Newsletter

Microsoft Excel topics:

1. Creating Templates, Workbooks with Multiple Worksheets and Web Pages
2. Data Tables, Visual Basic for Applications, Hyperlinks, and Scenario Manager
3. Sorting and Filtering a Worksheet Database, Pivot Tables, and Creating a Data Map

Microsoft Access Topics:

1. Reports, Forms, and Publishing Reports to the Web
2. Enhancing Form with OLE Fields, Hyperlinks, and Subforms
3. Creating an Application System Using Macros, VBA, and the Switchboard Manager

Microsoft PowerPoint:

1. Using Embedded visuals to Enhance a Slide Show
2. Creating a Presentation containing Interactive OLE Documents