Бакалавриат
2024/2025
Цифровая грамотность
Статус:
Курс обязательный (Международный бакалавриат по бизнесу и экономике)
Направление:
38.03.01. Экономика
Где читается:
Санкт-Петербургская школа экономики и менеджмента
Когда читается:
1-й курс, 1, 2 модуль
Формат изучения:
без онлайн-курса
Охват аудитории:
для всех кампусов НИУ ВШЭ
Преподаватели:
Вологжанина Ангелина Александровна,
Коптелова Александра Витальевна,
Павлова Екатерина Валерьевна,
Рыбальченко Вероника Дмитриевна,
Шашина Ирина Александровна
Язык:
английский
Кредиты:
5
Course Syllabus
Abstract
People encounter a lot of data at work and outside of work: for example, they look at predicted travel times and choose which mode of transportation to take, analyze prices of products they buy, plan dates for upcoming events, etc. Companies also operate with a lot of data: it can be financial (e.g., costs or revenue) and non-financial (e.g., level of service). This data can be discussed verbally or processed in mind but much more often it is visualized in some way and presented in a way that is easy for different people to work with. When is there a need to present data? For example in the preparation of reports, in presentations on a consulting project, at meetings to change the assortment of the company, when making decisions about inventory management, risk management, transportation, logistics, warehousing, etc. How correctly data is searched, processed, analyzed and visualized often determines a company's decision-making. Despite the evolving processes of digitalization, companies in all areas of business continue to use seemingly basic tools (such as Excel, Power Point and Word, Google Docs) for most data-related tasks (concerning both analysis and presentation) because of their relative simplicity and convenience. Even when using more advanced technologies for these tasks, employees need a basic understanding of why and how data work is needed. That's why this course will remain relevant throughout training and on the job, regardless of the position or area of business. The course is an adaptation of the university-wide Digital Literacy course; specifically for the Management and Digital Innovation program. This course focuses on an introduction to the basic principles of working with data. In particular, the course includes such topics as: preparation of data for processing and analysis, working with data, data aggregation, visualization using graphs and infographics, building a logical structure of the presentation for the most correct presentation of analysis results, computer literacy and security, basics of media communication, work with search engines, etc.
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 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.
- 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 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 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.
- 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.
Interim Assessment
- 2024/2025 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
- 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