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

Data Analysis in Spreadsheets

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

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

Программа дисциплины

Аннотация

The course “Data analysis with Spreadsheets” is designed to provide students with basic knowledge and skills of data analysis with Spreadsheets, in particular Microsoft Excel. The course begins with an introduction to basics of Spreadsheets, data types and predefined and conditional functions. Then students will learn how pivot tables are created and analyzed and how statistical analysis is performed. The final part of the course is devoted to techniques of data visualization using Spreadsheets. The course is supported by online platform for education DataCamp (www.datacamp.com). Students are expected to watch online lectures and complete assignments using the platform. Some lectures and final examination are provided by lecturers of National Research University Higher School of Economics.
Цель освоения дисциплины

Цель освоения дисциплины

  • Know basic principles of working with Spreadsheets.
  • Import data, make basic manipulation with it to prepare data for analysis, apply basic methods of preliminary data analysis and visualize data.
  • Have skills of interpreting the result of data analysis and understanding limitation and relevance of applied methods.
Результаты освоения дисциплины

Результаты освоения дисциплины

  • Know basic data types in Spreadsheets. Is able to determine data types and convert them. Have skills of conditional formatting.
  • Know basic functions to calculate summary statistics. Is able to build pivot tables. Have skills of data visualizing depending on data and task type.
Содержание учебной дисциплины

Содержание учебной дисциплины

  • Spreadsheet Basics
    1. Basics of Spreadsheets and data types. 2. Predefined and conditional functions.
  • Data Analysis and Visualization with Spreadsheets
    3. Pivot tables. 4. Statistics in Spreadsheets. 5. Data visualization
Элементы контроля

Элементы контроля

  • Self-study work (неблокирующий)
  • Exam (неблокирующий)
Промежуточная аттестация

Промежуточная аттестация

  • Промежуточная аттестация (1 модуль)
    0.6 * Exam + 0.4 * Self-study work
Список литературы

Список литературы

Рекомендуемая основная литература

  • Goldmeier, J. (2014). Advanced Excel Essentials. [United States]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=898783
  • Slager, D. (2016). Essential Excel 2016 : A Step-by-Step Guide. [Berkeley]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1361984

Рекомендуемая дополнительная литература

  • Schmuller, J. (2013). Statistical Analysis with Excel For Dummies (Vol. 3rd ed). New York: For Dummies. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=566464