Bachelor
2023/2024
Information Сomputer Systems
Type:
Elective course (International Programme in Economics and Finance)
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
Language:
English
ECTS credits:
4
Contact hours:
72
Course Syllabus
Abstract
The course of Information Computer Systems is a part of set of the mandatory courses (B2. Maths&Sciences) for the bachelor degree and is delivered during the first semester of the first year students of ICEF. The knowledge gained through this course will improve student’s professional status as well as enhance the efficiency of other following courses. The course covers half year and consists of two parts. The first part deals with specific features of spreadsheet software MS Excel for economic and financial tasks as well as with data and output analysis. This part is teaching at advanced level. The second part covers programming in Visual Basic for Applications (VBA), which facilitates processing spreadsheet data and increases the productivity in MS Excel. This part is teaching at a basic level.
Learning Objectives
- give students a holistic view of modern information technologies and their role in professional activities
- reveal the possibilities of computer's hardware and software and to form the stable skills of working in computer technologies area for solving economic and financial tasks
- develop basic programming skills in using the object-oriented language, aiming on expanding the functionality of MS Excel in processing the large data volumes, in developing the user-defined functions and subroutines, in event handling and in creating a graphical user interface
Expected Learning Outcomes
- Use Computational and financial Excel functions.
- Customize different charts. Use advanced charting technique representation of data.
- Analyze data using the Solver and Analysis ToolPak
- Use Excel logical functions in conditional analysis performing different actions depending on whether a condition is met.
- Sort and filter table data. Be able to extract results of Advanced Filter.
- Record the macro, be able to examine and edit the macro.
- Manipulate Excel objects
- Declare and work with different types of variables.
- To apply important control structures in VBA, which gives applications decision-making capability.
- Create dialog boxes (UserForms) to obtain information, be able to clarify commands, and display messages.
Course Contents
- Using built-in functions for data analysis
- Graphical Data Analysis in MS Excel
- MS Excel Add-ins for solving economic tasks
- Using Formulas and formatting for Conditional Analysis
- Working with large series of data
- Introduction to Macros and VBA. Introduction to Macros and VBA. Recording macros
- MS Excel objects
- Variables and data types. Manipulating data
- Loop and Conditional Statements used in VBA Excel programming.
- User Forms
