Syllabus_HB473_F2010 - HB 473(Hospitality Industry Research...

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

View Full Document Right Arrow Icon
HB 473 (Hospitality Industry Research) Fall Semester 2010 The School of Hospitality Business Michigan State University Instructor Seung Hyun Kim, Ph.D. The School of Hospitality Business 204 Eppley Center 517-353-1928 (phone) 517-432- 1170 (fax) [email protected] Office Hours Monday/Wednesday 10 a.m. to Noon. and by appointment Class Location Eppley #109 (computer-lab) Class Hours Tuesday and Thursday 2:40 p.m. – 4:00 p.m. Course Website Graduate Teaching Assistant Ms. Jellna Chung ( [email protected] ): She will have her office hours from 10 to 11 a.m. on MON, 3 to 4 p.m. on WED and by appointment in #232 Eppley (center conference room). Required materials Joseph J. Manzo , Excel In Business, Pearson Custom Business Resources , Prentice Hall, 2010 (ISBN: 0-558-72933-9). Additional required materials Additional required materials will be posted either at HB 473 ANGEL course website. COURSE DESCRIPTION: Presenting and analyzing data are common and often critical tasks in hospitality business. There are many different tools by which to conduct hospitality industry research. HB 473, in particular, is to provide undergraduate HB students with manageable but powerful analytical and quantitative research skills and tools, based on Microsoft Excel. Main goals of this course are to learn the dynamic abilities of Excel to communicate and present key business information effectively with others or to others. Students will learn how advanced functions can increase decision making efficacy and power when presenting information and data to others in the business environment. Students should be able to apply lessons covered in this course, to two common hospitality business practices: financial modeling and quantitative statistical analysis. Major topics include financial planning, capital-budgeting decision methods, sensitivity analysis, valuation, demand forecasting, survey techniques, and statistical analysis. HB 473 course outline – Fall 2010 1
Background image of page 1

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

View Full Document Right Arrow Icon
COURSE OBJECTIVES: By the end of HB 473, successful students will be able to: 1. Master Excel data management skills such as data entry, formatting, editing. 2. Master Excel primary tools such as formulas, functions, and analysis. 3. Construct comprehensive financial plans for new/existing businesses. 4. Evaluate multiple “what if” scenarios or potential outcomes for business decision- making. 5. Forecast future demands. 6. Run statistical analyses to evaluate market potential. 7. Effectively prepare and present research results. METHODS OF INSTRUCTION: Course format includes lectures, small group exercises, media presentations, and hands-on exercises. EVALUATION COMPONENTS: Exams 1, 2, 3 450 points (45%) Individual assignments 200 points (20%) Team research project 200 points (20%) Exercises (computer lab) Class participation/Attendance 100 points (10%) 50 points (5%) Total: 1000 points (100%) Student grades are determined by percentage of maximum points achieved, using the following
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 7

Syllabus_HB473_F2010 - HB 473(Hospitality Industry Research...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online