CASE05-EN.pdf - CASE 5 Klein Technology Seminars Lisa...

Info icon This preview shows pages 1–3. Sign up to view the full content.

1 CASE 5: Klein Technology Seminars Lisa Miller Table of Contents SKILLS CHECK ............................................................................................................................. 1 CASE BACKGROUND .................................................................................................................. 2 CASE SCENARIO ........................................................................................................................ 2 Design Specifications ............................................................................................................. 3 Information Specifications ....................................................................................................... 5 Implementation Concerns ........................................................................................................ 5 Test Your Design ................................................................................................................... 7 CASE DELIVERABLES .................................................................................................................... 8 SKILLS CHECK You should review the following areas: Spreadsheet Case Difficulty Rating: * * SPREADSHEET SKILLS AVERAGE Function Cell Formatting • Chart COUNTIF Function MEDIAN Function MODE Function • PivotChart • PivotTable SUM Function Worksheet Formatting
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

CASE 5: Klein Technology Seminars 2 CASE BACKGROUND Klein Technology Seminars provides information technology seminars to local corporations and continuously strives to provide its corporate clients with quality, timely instruction. As part of its quality-first strategy, seminar students are asked to complete customer satisfaction surveys. These satisfaction surveys are then reviewed by Dr. Klein, the company’s founder. Based on the survey results, Dr. Klein makes adjustments to the company’s courses To facilitate his analysis of the customer satisfaction surveys, Dr. Klein asks you to develop a Survey Results workbook. The preparation of this workbook requires you to design worksheets, use formulas, use several functions, use basic cell and worksheet formatting techniques, and prepare PivotTable and PivotChart reports. CASE SCENARIO Dr. Earl Klein is the founder and president of Klein Technology Seminars. As a former university vice president, Dr. Klein came into contact with many corporate executives. Frequently, the corporate executives would remark about the necessity of keeping their employees up-to-date in their field. Dr. Klein took this message to heart, and when he retired a few years ago, he formed Klein Technology Seminars. Since its beginning, Klein Technology Seminars has seen a steady growth in its business and has a reputation for providing quality instruction to its clients. The company’s reputation is due in part to its 10 full-time, highly qualified instructors. The instructors teach a variety of courses, ranging from productivity to certification courses. The courses are one-week courses, last from 8 a.m. to 5 p.m. each day, and are limited to 24 students. The company offers its courses on its campus, at the client’s site, and at other off-site locations. Figure 1: Customer Satisfaction Survey Klein Technology Seminars Satisfaction Survey 1. Have you previously attended a technology seminar offered by Klein Technology Seminars? No — Yes 2. Have you attended a technology seminar offered by another company? No — Yes 3. Overall, I am satisfied with the course. Strongly Agree — Agree — Neutral — Disagree — Strongly Disagree 4. I will take another course with Klein Technology Seminars.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '16
  • all

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern