Бакалавриат
2020/2021
Вводный научно-исследовательский семинар
Статус:
Курс обязательный (Международный бизнес и менеджмент/ Менеджмент)
Направление:
38.03.02. Менеджмент
Кто читает:
Департамент менеджмента
Где читается:
Санкт-Петербургская школа экономики и менеджмента
Когда читается:
1-й курс, 1, 2 модуль
Формат изучения:
без онлайн-курса
Язык:
английский
Кредиты:
3
Контактные часы:
30
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 Excel1 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 Word8 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 PowerPoint12 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
Interim Assessment
- Interim assessment (2 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