Бакалавриат
2023/2024
Цифровая грамотность
Лучший по критерию «Полезность курса для Вашей будущей карьеры»
Лучший по критерию «Полезность курса для расширения кругозора и разностороннего развития»
Лучший по критерию «Новизна полученных знаний»
Статус:
Курс обязательный (Международный бакалавриат по бизнесу и экономике)
Направление:
38.03.01. Экономика
Кто читает:
Департамент менеджмента
Где читается:
Санкт-Петербургская школа экономики и менеджмента
Когда читается:
1-й курс, 1, 2 модуль
Формат изучения:
с онлайн-курсом
Онлайн-часы:
20
Охват аудитории:
для всех кампусов НИУ ВШЭ
Преподаватели:
Захарова Александра Алексеевна,
Коптелова Александра Витальевна,
Павлова Екатерина Валерьевна,
Ткачук Николай Викторович,
Травин Александр Сергеевич
Язык:
английский
Кредиты:
5
Контактные часы:
56
Course Syllabus
Abstract
This course is an adaptation of the university-wide course «Digital Literacy»; specifically for students of the bachelor program «International Bachelor's in Business and Economics»; (in English). 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
- Acquire the knowledge about modern information technologies used to conduct both research and business
- To acquire the knowledge about working in MS Office
- To develop skills for searching, processing, and analyzing information
Expected Learning Outcomes
- 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 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 collect, process, and analyze data necessary for solving research tasks
- The ability to find and evaluate new market possibilities and formulate new business ideas
- The ability to use modern technical tools and information technology to solve analytic and research tasks
- The ability to work in a team
Course Contents
- 1) Computer literacy
- 2) Computer security
- 3) Media literacy
- 4) Legal aspects of information technology
- 5) Internet and browsing
- 6) Basic text technologies. work with texts in MS Office Word and Google Docs
- 7) Preparation of presentations: tools and usage
- 8) Working with tabular data in MS Excel and Google Spreadsheets
- 9) Basics of working with data.
Assessment Elements
- Test 1The test is held in a computer class on a PC in the format of practical assignments using the appropriate software (MS Word, MS PowerPoint, MS Excel). The test consists of 10 practical exercises in MS Word, MS PowerPoint, MS Excel. The test duration is 60 minutes. Cheating is strictly prohibited during the tests (using mobile devices, paper materials, cheat sheets, connecting to the Internet / local network, talking with other students, and viewing another screen or recordings). If the facts of cheating are revealed, the student is removed from the classroom ahead of schedule and receives 0 (zero) points for a specific test.
- Test 2This test checks student’s ability to use intermediate techniques in processing data in tabular from. The test is held in a computer class on a PC in the format of practical assignments using the appropriate software (MS Word, MS PowerPoint, MS Excel). The test consists of 10 practical exercises in MS Word, MS PowerPoint, MS Excel. The test duration is 60 minutes. Cheating is strictly prohibited during the tests (using mobile devices, paper materials, cheat sheets, connecting to the Internet / local network, talking with other students, and viewing another screen or recordings). If the facts of cheating are revealed, the student is removed from the classroom ahead of schedule and receives 0 (zero) points for a specific test.
- Final ExamThe exam is held in a computer class on a PC in the format of practical assignments using the appropriate software (MS Word, MS PowerPoint, MS Excel). The exam consists of 10 practical exercises in MS Word, MS PowerPoint, MS Excel. The exam duration is 80 minutes. Cheating is strictly prohibited during the tests (using mobile devices, paper materials, cheat sheets, connecting to the Internet / local network, talking with other students, and viewing another screen or recordings). If the facts of cheating are revealed, the student is removed from the classroom ahead of schedule and receives 0 (zero) points for a specific test.
- Research ProjectThis method of control checks the ability of students to apply in practice the knowledge gained during the online course and face-to-face seminars in the context of independent research team-work. The work is carried out in project groups (2-3 students of one seminar group). As a result, a well-structured analytical presentation of the project is expected, demonstrating convincing evidence and general academic literacy of the student. Students define a framework, major goals, tasks, and desirable results for a project (in accordance with basic norms of logical reasoning and common sense). Basically, this project may be a draft of course paper (e.g. data collection and quantitative analysis), a business plan for a virtual company, a supplementary analytical dashboard for any practical tasks and projects related to student(s) current courses, internships, etc. Each project should include: - In MS Word. An abstract of the research project (max. ~ 500 words). Samples of abstracts: https://writing.wisc.edu/handbook/assignments/writing-an-abstract-for-your-research-paper/ + Bibliography of used sources (APA style). - In PowerPoint. An interactive presentation (max. 10 slides) which should include the following information: brief overview (main goals, tasks, desirable results etc.), teamwork distribution, project results. - In Excel. It is the main part which reflects each seminar's subjects (MS Excel functions and tools). In the main part, students should apply MS Excel functions and tools to pre-defined goals and tasks to reach any valuable results within the overall framework of the project (e.g. hypothesis check, profit/loss balance, data visualization etc.).
- Test 3This test checks student’s ability to use advanced techniques in processing data. The test is held in a computer class on a PC in the format of practical assignments using the appropriate software (MS Excel). The test consists of 10 practical exercises in MS Excel. The test duration is 60 minutes. Cheating is strictly prohibited during the tests (using mobile devices, paper materials, cheat sheets, connecting to the Internet / local network, talking with other students, and viewing another screen or recordings). If the facts of cheating are revealed, the student is removed from the classroom ahead of schedule and receives 0 (zero) points for a specific test.
Interim Assessment
- 2023/2024 2nd module0.2 * Final Exam + 0.2 * Research Project + 0.2 * Test 1 + 0.2 * Test 2 + 0.2 * 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]
- Freedman, J. J. (2013). Microsoft Word 2013 Plain & Simple. Microsoft Press.
- 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
- Muir, N. (2013). Microsoft PowerPoint 2013 Plain & Simple. Microsoft Press.
- Rockoff, L. (2013). Microsoft Excel 2013 for the Business Analyst. Cengage Learning PTR.
Recommended Additional Bibliography
- Fraser C. Business statistics for competitive advantage with Excel 2016: basics, model building, simulation and cases. New York, NY: Springer Science+Business Media, 2016. 475 с.
- Danielle Stein Fairhurst (2015). Using Excel for Business Analysis