BUS 0252. Excel for Business Applications
Units: 3
Formerly known as IT 25
Advisory: Completion of BUS 250 and SKDV 10 with grades of "C" or better
Hours: 72 (54 lecture, 18 laboratory)
Design and use of "what-if" analysis, static and dynamic web pages, financial functions, data and lookup tables, amortization schedules and templates. Includes working with multiple worksheets and workbooks, analyzing worksheet results, sorting and querying a worksheet database, using macros, and integrating software. (CSU)
BUS 0252 - Excel for Business Applications
http://catalog.sierracollege.edu/course-outlines/bus-0252/
Catalog Description DESCRIPTION IS HERE: Formerly known as IT 25 Advisory: Completion of BUS 250 and SKDV 10 with grades of "C" or better Hours: 72 (54 lecture, 18 laboratory) Description: Design and use of "what-if" analysis, static and dynamic web pages, financial functions, data and lookup tables, amortization schedules and templates. Includes working with multiple worksheets and workbooks, analyzing worksheet results, sorting and querying a worksheet database, using macros, and integrating software. (CSU) Units 3 Lecture-Discussion 54 Laboratory 18 By Arrangement Contact Hours 72 Outside of Class Hours Course Student Learning Outcomes Research, analyze and evaluate information to solve business problems using a spreadsheet application. Design and produce spreadsheet solutions incorporating current trends, security, and best practices. Employ spreadsheet concepts and terminology in professional communication. Demonstrate marketable spreadsheet career skills. Course Content Outline I. Getting Started with Excel A. Overview of working with spreadsheets B. Planning a worksheet II. Formatting Workbook Text and Data A. Fonts, Fills, Styles and Themes B. Number formats C. Align and Merge III. Performing Calculations with Formulas and Functions A. Common functions, COUNT, ROUND, AVERAGE B. What-If analysis C. Auto fill options D. Absolute, Mixed and Relative referencing IV. Analyzing and Charting Financial Data A. More functions, PMT B. Understanding Chart options C. Choosing the right chart to depict the data V. Working with Excel Tables, PivotTables, and PivotCharts A. Structured Data Tables & Ranges B. Filters and Sorts C. Pivot Tables and Pivot Charts VI. Managing Multiple Worksheets and Workbooks A. Grouping Worksheets B. Linking Workbooks C. Creating Templates VII. Developing an Excel Application A. Defined Names B. Protecting a Worksheet C. Macros VII. Working with Advanced Functions A. IF, And, Or – Logical functions B. Lookup Tables C. Nesting functions IX. Exploring Financial Tools and Functions A. PMT, FV, NPER and PV B. Depreciation C. RATE, NPV, IRR X. Performing What-If Analyses A. Break Even Analysis B. One and Two Variable Data Tables C. Scenario Manager D. Solver XI. Analyzing Data with Business Intelligence A. Data Queries B. Data Modeling C. Power View D. Power Map XII. Collaborating on a Shared Workbook A. Change Tracking B. Finalizing a Workbook Course Objectives Course Objectives Lecture Objectives: Through hands-on exercises, exams and skill demonstrations: 1. Explain the use of worksheets to make critical business decisions, including the use of functions, formulas and cell referencing; 2. Diagram the process used to import data into worksheets; 3. Describe the concepts of design and critical thinking in presenting business information; 4. Identify the steps needed to integrate with other applications and the Internet; 5. Identify techniques to automate tasks using macros; 6. Describe the process for linking multiple worksheets and workbooks; 7. Identify collaborative tools available within Excel; 8. Explain auditing of a workbook; 9. Analyze data to produce meaningful results; and Laboratory Objectives: Through hands-on exercises, exams and skill demonstrations employ best practice to: 1. Practice the use of goal seek, what-if analysis and scenario manager to make business decisions; 2. Demonstrate the use of advanced functions, formulas and cell referencing; 3. Apply best practices of design concepts and employee critical thinking in developing Excel applications; 4. Create appropriate informative charts and graphs to convey a visual representation of data; 5. Develop professional quality worksheets by applying special formatting techniques such as alignments, text wrapping, borders and shading and conditional formatting; 6. Demonstrate the following skills using lists: sorting and filtering data, conditional formatting, data entry validation; 7. Integrate multiple data sources and import data into worksheets; 8. Apply techniques to automate tasks using macros; 9. Construct, design and modify summary worksheet by linking multiple worksheets and workbooks; 10. Develop data tables and apply scenario management and solver tools for complex problems; 11. Analyze and depict alternate views of critical business data using Pivot tables and Pivot charts. Methods of Evaluation Objective Examinations Problem Solving Examinations Projects Skill Demonstrations Reading Assignments 1. Read and study the textbook chapters and online lecture materials; using a word processor describe the steps necessary to correctly use the Pivot Table Wizard. 2. Go to the Small Business Administration web site at www.sba.gov and locate the section on Budgets. Read the section on "Creating a Budget Worksheet to Make Financial Decisions." Using this detailed information create a set of linked worksheets to track 12-months of your household cash inflows and outflows. Writing, Problem Solving or Performance 1. Create a macro named "PrintChart" with the shortcut key CTRL+a, that performs the following tasks: -Prints the chart and input-output area in landscape orientation, centered horizontally on the page with the text "Break-Even Analysis" centered at the top of the printout and your name and date in the lower-right corner of the printout. -Makes cell A1 the active cell after printing is completed. 2. Create a one-variable data table that calculates the total revenue, expenses, and net income for fees that range from $130 per person per night to $180 per person per night in increments of $5. 3. Read, research and respond to a discussion board question - Example: Assume you have a list of college students, and in the list there is a code for males and females, and there is a field identifying the student's major. Which two, AutoFilter or Pivot Table, would you use in each of the following situations: -You want a list of all females majoring in history. -You want the number of males and females in each major at your institution. Other (Term projects, research papers, portfolios, etc.) Methods of Instruction Laboratory Lecture/Discussion Distance Learning Other materials and-or supplies required of students that contribute to the cost of the course.
Business
http://catalog.sierracollege.edu/departments/business/
The business discipline offers training in nine major areas: Accounting, Administrative Professional, Business Administration, Business Entrepreneurship, General Business, Management, Marketing and Real Estate. For Information Technology (formerly known as Computer Information Systems) and Computer Science, see separate catalog listings. The Business department plays a vital role in preparing students for their careers. Experience has demonstrated the importance of a background in general education for all students planning a career in business.
Information Technology
http://catalog.sierracollege.edu/departments/infotech/
...Required Courses: Course List Code Title Units BUS 0252 Excel for Business Applications 3 IT...
