Бакалавриат
2020/2021
Научно-исследовательский семинар "Информационное обеспечение исследований в менеджменте"
Статус:
Курс обязательный (Международный бизнес и менеджмент/ Менеджмент)
Направление:
38.03.02. Менеджмент
Кто читает:
Департамент менеджмента
Где читается:
Санкт-Петербургская школа экономики и менеджмента
Когда читается:
1-й курс, 3, 4 модуль
Формат изучения:
без онлайн-курса
Язык:
английский
Кредиты:
6
Контактные часы:
60
Course Syllabus
Abstract
This module aims at providing students with knowledge, practical skills and experience to conduct both applied and fundamental research with a substantial emphasis on quantitative studies in business. The module aims to enable students to carry out their individual projects as well as contribute to collective research. The Research seminar covers the most relevant issues of a research process that might be valuable for students. The key idea of the course is to provide insights into philosophy and basics of pure academic as well as applied studies in management and economics. The module is designed to provide students with knowledge, skills, positive values and competencies to solve nontrivial problems and creative tasks in the frame of business studies.
Learning Objectives
- Acquire knowledge about modern information technologies used to conduct research
- Acquire knowledge about working in MS Excel
- Develop skills for searching and processing information
Expected Learning Outcomes
- UC-7 The ability to work in a team
- PC-27 The ability to find and evaluate new market possibilities and formulate new business ideas
- PC-31 The ability to collect, process, and analyze data necessary for solving research tasks
- PC-32 The ability to choose relevant methods for processing information in correspondence with scientific tasks, to analyze the results of calculations, and to defend conclusions based on these calculations
- PC-34 The ability to analyze and interpret data from domestic (Russian) and foreign statistics about social and economic processes and trends, and to identify regular changes in social and economic indicators
- PC-35 The ability to use modern technical tools and information technology to solve analytic and research tasks
Course Contents
- 1. Basic Data Analysis in Microsoft Excelrevision (Worksheets and workbooks, inserting data in cells and ranges, formatting cells and ranges, ordering, subtotals, grouping, outlines, filters, conditional formatting.Getting External Data (text to columns)). Managing Connections. Removing Duplicates. Excel functions. Basic formulas: SUM, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, IF, NOT, AND, FIND, SEARCH, TRIM, CONCATENATE, LEFT, RIGHT, MID, UPPER, LOWER.
- 2. Graphs and Math functions: ABS, SIGN, ROUND, MROUND, POWER etc.
- 3. SMALL, LARGE, Advanced charts (BCG chart, Pie chart, scatter plot)
- 4. Basic lookup and references functions: VLOOKUP, HLOOKUP, MATCH, INDEX, Lookup+IF, multiple criteria match.
- 5. Advanced lookupsLOOKUP as massive, massive, multiple matches. Advanced filtering, Dependent DDLs (INDIRECT), Paste Special
- 6. Financial functionsPMT, PPMT, IPMT. NPV, XNPV, IRR, XIRR, PI. Charts: waterfall. Applying custom data formats.
- 7. Data AnalysisGoal Seek, What-If-Analysis, Scenario Manager. Subtotal. Consolidation and 3D function.
- 8. Date & Time functions. CHOOSE, OFFSET.
- 9. Basic Pivot Tables and Pivot charts.
- 10. Multiple Pivot Table.
- 11. Advanced PivotGETPIVOTDATA, match several tables. Formulas auditing: Trace Precedents, Trace Dependent. Troubleshooting functions.Information functions. Forecasting (TREND, FORECAST). Advanced data validation.
- 12. MS Excel Macros and Excel VBA basics.
- 13. MS Excel Macros and Excel VBA intermediate.
