Introductory Research Seminar

2019/2020

Academic Year

ENG

Instruction in English

3

ECTS credits

Delivered at:

Department of Management

Course type:

Compulsory course

When:

1 year, 3, 4 module

Instructors

Zakharova, Aleksandra

Travin, Alexander

Чигринская Любовь Андреевна

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, MS Word, MS PowerPoint and the development of skills for searching and processing information.

Learning Objectives

• The aim of the course consists of developing skills of conducting scientific researches in the management sphere;
• acquering knowledge in modern information technologies, being used for conducting scentific reaserches;
• acquering knowledge of working in MS Excel, MS Word, MS Powerpoint;
• developing skills in information searching and processing.

Expected Learning Outcomes

• 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 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

• Part 1. Principles of Research Methods & Introduction to Data Analysis in Microsoft Excel
  1 Applied and Academic Research. Quantitative and Qualitative Research. Empirical and Theoretical Research. Research and Presentation Skills. Sources of Statistical Data and Academic Literature for Research in Economics and Management. 2 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. Data Management. Getting External Data. Managing Connections. Removing Duplicates. Outlines 3 Getting External Data. Managing Connections. Removing Duplicates. Functions: MIN, MAX, AVERAGE, SUM, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNT, COUNTIF, COUNTIFS. 4 Test 1 5 Applying text functions RIGHT, LEFT, MID, TRIM, UPPER, LOWER, CONCATENATE. Applying logical functions: IF, AND, OR, NOT etc. 6 Charts and graphs: creation, formatting, inserting and formatting an object. 7 Test 2
• Part 2. Writing and Presentation Skills in Microsoft Word
  8 Microsoft Word. Documents: creation, managing, formatting, customizing options and views, printing and saving. Text formatting, inserting a text and paragraphs, ordering and grouping text and paragraphs. 9 Creating and modifying tables and lists. Managing references: reference markers, simple references. Managing graphic elements. 10 Managing documents and templates. Preparing documents for reviewing. Managing documents changes. Performing advanced editing and formatting. Creating advanced references. Managing bibliography. Creating custom Word elements. 11 Test 3
• Part 3. Writing and Presentation Skills in Microsoft PowerPoint
  12 Microsoft Power Point. Presentation basics. Modifying slides, ordering and grouping slides. Changing presentation options and views. Configuring presentation for print. Configuring and presentation for a slide show. Text management. Tables, charts and other objects in presentations. Applying transitions and animations. Managing multiple presentations. 13 Test 4

Assessment Elements

• Test 1
• Test 2
• Test 3
• Exam

Interim Assessment

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

Bibliography

Recommended Core Bibliography

• Bernd Held, Theodor Richardson (2015) Microsoft Excel Functions and Formulas, 3rd ed. Mercury Learning. [HSE access, books 24*7]
• Held, B., Moriarty, B., & Richardson, T. (2019). Microsoft Excel Functions and Formulas (Vol. Fifth edition). Dulles, Virginia: Mercury Learning & Information. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=2051937

Recommended Additional Bibliography

• Windows Helpline Number +1-855-866-7714. (2018). Microsoft Office Support Number +1-855-866-7714. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsbas&AN=edsbas.16000E7D