Programming and Databases

Bachelor 2025/2026

Type: Elective course (International Programme in Economics and Finance)

Delivered by: International College of Economics and Finance

When: 1 year, 1 semester

Open to: students of one campus

Instructors: Акиншин Анатолий Анатольевич

Language: English

Full Syllabus Ask Question

Abstract

a. Pre-requisites High school informatics: • solid user-level understanding of the Windows (or other desktop) operating system, including user interface and navigation, file system, running and installing applications, using standard applications: text editor, browser, mail client, etc. • programming basics (any high-level language): types and variables, flow control, simple data structures b. Abstract The course is consists of three parts. The first part is aimed at developing initial and basic competencies in the field Computer Hardware and Software Architecture, Networks and Internet. . This is part of the HSE educational project “Data Culture”. These competencies are necessary for the safe and effective use of digital technologies and Internet resources in the framework of academic activities. The second part is teaching at advanced level the specific features of spreadsheet software MS Excel for economic and financial tasks as well as with data and output analysis. This part also considers the Visual Basic for Applications (VBA) programming, which facilitates processing spreadsheet data and increases the productivity in MS Excel. The third part is teaching databases. It deals with Microsoft Access, which is used to create and manage small and midsize computer-based databases on desktop computers and/or on network connected computers for the Microsoft Windows family of operating systems. This part also covered SQL to communicate through the server.

Learning Objectives

To give students a holistic view of modern information technologies and their role in professional activities.
To develop programming skills in using the object-oriented language aiming on expanding the functionality of MS Excel and MS Access
To show how integrate MS Access with SQL Server and other Business Intelligence (BI) applications.
To teach how to build business applications that integrate local data, web-generated data, and data available from SQL Server and other sources

Expected Learning Outcomes

Demonstrate capability of reading and writing queries in SQL and/or relational algebra.
expand the functionality of MS Excel by VBA
solve system of equations by graphing
use built-in functions for data analysis
use MS Excel Add-ins (Analysis ToolPak, Solver) for solving economic tasks
work with large series of data
Use calculations in SQL queries
Know basic commands of SQL language, be able to perform requests.
1. Understanding what role data types in SQL have 2. Distinguish different numerical, text, logical and date data types 3. Ability to convert data types
1. Ability to use subqueries in a SQL query both as a Common Table Expression and as a classical Understanding what window functions are and when there is a need to use them
• Knows the tools and capabilities of Google digital services (Docs, Spreadsheets, Presentations) • Uses Google Cloud for studying and research • Prepares solutions for text assignments using the tools of Google Doc, MS Word • Applies knowledge in Google Spreadsheets and MS Excel to perform basic data analysis • Uses Google Presentations and MS Power Point to create descriptive and coherent presentations
• Knows how to correctly seek and select scientific sources from the web. • Uses Google Scholar to search for academic articles and filter them. • Applies such services as Zotero and Mendeley to do the correct referencing • Knows the key features of the license framework -Creative Commons
• Recognizes types of threats on the web • Knows the ways of self-defence from web-fraud. • Uses tools and services to avoid spam on the Internet and secure own personal data • Understands the difference between regular Hypertext transfer protocol and secure one. • Uses web-browser efficiently and safely
• Knows the rules of Independent Assessment of Digital Literacy • Knows the basics of Media Literacy and Online Ethics. • Uses rules and recommendations of Media Literacy for communicating in the web with other users. • Tracks and clears own digital footprints on the web. • Recognizes fake news on the web domain.
Ability to write SQL queries in a relational DBMS

Course Contents

Digital literacy
Computer Architecture
Using built-in functions for data analysis
Graphical Data Analysis in MS Excel
Working with large series of data.
MS Excel Add-ins for solving economic tasks.
Expanding the functionality of MS Excel by VBA.
Database concepts and terminology
Relational database management systems
MS Access Basics. Creating a Database and Using the Tools
Queries
Forms and Reports
Using Other Applications with MS Access
Microsoft SQL Server

Assessment Elements

Home assignments
Control work: In-class assignment
Exam: In-class assignment
In order to get a passing grade for the course, the student must sit (all parts) of the examination.
Digital literacy home assignments (tests)

Interim Assessment

2025/2026 1st semester
0.29 * Control work: In-class assignment + 0.1 * Digital literacy home assignments (tests) + 0.46 * Exam: In-class assignment + 0.15 * Home assignments

Bibliography

Recommended Core Bibliography

Bernd Held, Theodor Richardson (2015) Microsoft Excel Functions and Formulas, 3rd ed. Mercury Learning. [HSE access, books 24*7]
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
SQL. Полное руководство, Грофф, Дж., 2018
Дробахина, А. Н. Информационные системы: основы проектирования и реализации в СУБД Microsoft Access : учебное пособие / А. Н. Дробахина. — 2-е изд., перераб. и доп. — Новокузнецк : КГПИ КемГУ, 2019. — 88 с. — ISBN 978-5-8353-1943-5. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/169582 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.
Кузин, А. В. Разработка баз данных в системе Microsoft Access : учебник / А.В. Кузин, В.М. Демин. — 4-е изд. — Москва : ФОРУМ : ИНФРА-М, 2024. — 224 с. — (Среднее профессиональное образование). - ISBN 978-5-00091-752-7. - Текст : электронный. - URL: https://znanium.ru/catalog/product/2157444
Мотошкин, П. В. Создание реляционных баз данных на основе MS ACCESS с вариантами заданий : учебное пособие / П. В. Мотошкин, Л. Ю. Прудова, Н. Н. Дампилов. — Улан-Удэ : ВСГУТУ, 2019. — 80 с. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/236675 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.
Основные принципы и концепции программирования на языке VBA в EXCEL : учеб. пособие, Белоусова, С. Н., 2010
Построение запросов и программирование на SQL : учеб. пособие для вузов, Маркин, А. В., 2008
Самоучитель Access 2010, Бекаревич, Ю. Б., 2013
Фомина, Е. Е. Работа с базами данных в MS Access 2013 : учебное пособие / Е. Е. Фомина, А. А. Артемьев. — Тверь : ТвГТУ, 2022. — 144 с. — ISBN 978-5-7995-1198-2. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/288269 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.
Чикунова, Н. Ф. Проектирование баз данных и организация их защиты в СУБД ACCESS : учебное пособие / Н. Ф. Чикунова. — Калининград : БГАРФ, 2019 — Часть 1 — 2019. — 106 с. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/160059 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.

Recommended Additional Bibliography

Биллиг, В. А. Основы офисного программирования и язык VBA : учебное пособие / В. А. Биллиг. — 2-е изд. — Москва : ИНТУИТ, 2016. — 708 с. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/100309 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.

Authors

AKINSHIN ANATOLIY ANATOLEVICH

Course Syllabus