BUS 220 - Applied Business Applications
A case study approach to the use of office productivity software to solve business problems and manage business processes. Emphasis will be on the use of spreadsheet and database applications to analyze data. Word processing and presentation software will be used to document and present solutions. Several major projects will be assigned to be completed outside of class. Each student will create a semester-long portfolio of related work. Basic knowledge of the PC, keyboard, and mouse are required. This course requires the use of the Microsoft Windows version of Office, including Microsoft Access, which is not available for the Macintosh version of Office. Two class hours, two lab hours. 3 Credits.
Prerequisite: BUS 104 with a grade of C or higher
Course Learning Outcomes
1. Create a relational database in Boyce-Codd Normal Form (BCNF) for a given set of sales, customer, or inventory data.
2. Manage data by adding, deleting, and updating records for an existing sales, customer, or inventory database.
3. Write multi-table queries to extract data in response to specific questions for the purpose of business performance analysis of an existing sales, customer, or inventory database.
4. Apply business functions for the purpose of business performance analysis in a spreadsheet.
5. Apply word processing, database, and spreadsheet software to create a business proposal, including; a description of the business function and/or product, a S.W.O.T. analysis, a budget, and a description of prior experience using background information in a case-study format.
6. Create a professional-quality presentation of the business proposal developed by the student.
Course Offered Fall and Spring