Bachelor
2021/2022![Learning Objectives](/f/src/global/i/edu/objectives.svg)
![Expected Learning Outcomes](/f/src/global/i/edu/results.svg)
![Course Contents](/f/src/global/i/edu/sections.svg)
![Interim Assessment](/f/src/global/i/edu/intermediate_certification.svg)
![Bibliography](/f/src/global/i/edu/library.svg)
Programming and Databases
Type:
Elective course
Area of studies:
Economics
Delivered by:
International College of Economics and Finance
When:
1 year, 1, 2 module
Mode of studies:
offline
Open to:
students of one campus
Instructors:
Акиншин Анатолий Анатольевич
Language:
English
ECTS credits:
4
Contact hours:
72
Course Syllabus
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
- confidently use Microsoft SQL Server
- create a Database and Using the Tools
- create and use Forms and Reports
- expand the functionality of MS Excel by VBA
- manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
- solve system of equations by graphing
- use built-in functions for data analysis
- use Microsoft BI: PowerPivot, PowerView, PowerMap
- use MS Excel Add-ins (Analysis ToolPak, Solver) for solving economic tasks
- use Other Applications with MS Access
- work with large series of data
Course Contents
- Computer Architecture
- Networks and Internet. (
- Formatting text via MS Word
- Creating presentations via MS PowerPoint.
- 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
Interim Assessment
- 2021/2022 1st moduleFor final grade determination see module 2.
- 2021/2022 2nd module0.4 * End-of-term exam + 0.35 * Mid-term exam + 0.1 * Online Test + 0.15 * Home assignments
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
Recommended Additional Bibliography
- Биллиг, В. А. Основы офисного программирования и язык VBA : учебное пособие / В. А. Биллиг. — 2-е изд. — Москва : ИНТУИТ, 2016. — 708 с. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/100309 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.
- Работа в Microsoft Access XP : учебное пособие. — 2-е изд. — Москва : ИНТУИТ, 2016. — 127 с. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/100430 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.