Bachelor
2023/2024
Data Analysis in Spreadsheets
Category 'Best Course for Career Development'
Category 'Best Course for Broadening Horizons and Diversity of Knowledge and Skills'
Type:
Elective course (Economics)
Area of studies:
Economics
Delivered by:
School of Economics and Finance
Where:
Faculty of Management
When:
4 year, 3 module
Mode of studies:
distance learning
Online hours:
20
Open to:
students of one campus
Instructors:
Dmitry Kirpishchikov
Language:
English
ECTS credits:
6
Contact hours:
18
Course Syllabus
Abstract
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. Some additional topics related to the data analysis will be covered. The final part of the course is devoted to techniques of data visualization using Spreadsheets. Some lectures and final examination are provided by lecturers of National Research University Higher School of Economics.
Learning Objectives
- 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.
Expected Learning Outcomes
- 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.
Assessment Elements
- Самостоятельная работаизучение онлайн-курса
- ЭкзаменFinal student assessment is a project, that is performed in a team of no more than 2 people. Each team uses provided dataset or their own data, define research question and apply one or a combination of the learnt methods of data analysis with Spreadsheets. As a result of the project each team provide the Spreadsheet. The grade for the exam includes the grade for the working file and the grade for answering questions.
- Аудиторная работа
Interim Assessment
- 2023/2024 3rd module0.3 * Аудиторная работа + 0.3 * Самостоятельная работа + 0.4 * Экзамен
Bibliography
Recommended Core Bibliography
- 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
Recommended Additional Bibliography
- 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