• A
  • A
  • A
  • АБВ
  • АБВ
  • АБВ
  • А
  • А
  • А
  • А
  • А
Обычная версия сайта
07
Апрель

Research Seminar "Informations Support for Research in Management"

2019/2020
Учебный год
ENG
Обучение ведется на английском языке
3
Кредиты
Статус:
Курс обязательный
Когда читается:
2-й курс, 1, 2 модуль

Преподаватели

Course Syllabus

Abstract

Practice-oriented course, the objectives of which are: the development of the ability to conduct research in the field of management, the acquisition of knowledge about modern information technologies used to conduct research, the acquisition of knowledge about working in MS Excel, the development of skills for searching and processing information.
Learning Objectives

Learning Objectives

  • Acquire the knowledge about modern information technologies used to conduct research
  • Acquire the knowledge about working in MS Excel
  • Develop skills for searching and processing information
Expected Learning Outcomes

Expected Learning Outcomes

  • The ability to work in a team
  • The ability to collect, process, and analyze data necessary for solving research tasks
  • 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
  • The ability to find and evaluate new market possibilities and formulate new business ideas
  • 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
  • The ability to use modern technical tools and information technology to solve analytic and research tasks
Course Contents

Course Contents

  • Introduction to Data Analysis in Microsoft Excel
    1. Worksheets and workbooks: creation, navigation, formatting, customizing options and views, configuring to print or save. Inserting data in cells and ranges, formatting cells and ranges, ordering. Grouping, outlines, filters. 2. Getting External Data. Managing Connections. Removing Duplicates. Functions: MIN, MAX, AVERAGE, SUM, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNT, COUNTIF, COUNTIFS. Applying logical functions: IF, AND, OR, NOT etc. 3. Charts and graphs: creation, formatting, inserting and formatting an object.
  • Intermediate Data Analysis in Microsoft Excel
    Lookup and references functions: VLOOKUP, HLOOKUP, MATCH, INDEX. Defining names for ranges and objects. Conditional formatting.
  • Advanced Data Analysis in Microsoft Excel
    1. Functions: PMT, PPMT, IPMT. Information functions. Charts: waterfall, thermometer, sparklines. 2. Data Analysis: Goal Seek, What-If-Analysis, Scenario Manager. Advanced filters. Subtotal. Consolidation and 3D function. 3. Basic math functions. Pivot Table. 4. Multiple Pivot Table. Applying custom data formats and validation. Applying advanced conditional formatting and filtering.
Assessment Elements

Assessment Elements

  • non-blocking Test 1
  • non-blocking Test 2
  • non-blocking Test 3
  • blocking Test 4
Interim Assessment

Interim Assessment

  • Interim assessment (2 module)
    0.25 * Test 1 + 0.25 * Test 2 + 0.25 * Test 3 + 0.25 * Test 4
Bibliography

Bibliography

Recommended Core Bibliography

  • Bernd Held, Theodor Richardson (2015) Microsoft Excel Functions and Formulas, 3rd ed. Mercury Learning. [HSE access, books 24*7]

Recommended Additional Bibliography

  • Larry Rockoff (2014) Microsoft Excel 2013 for Business Analyst.