Information Сomputer Systems

2024/2025

Academic Year

ENG

Instruction in English

4

ECTS credits

Delivered at:

International College of Economics and Finance

Course type:

Elective course

When:

1 year, 1 semester

Instructors

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

Bessonova, Irina

Рафаелян Георгий Робертович

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

• Digital literacy
• 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

Assessment Elements

• Home assignments
• Test in digital literacy
• Middle term exam
• Exam
  In order to get a passing grade for the course, the student must sit (all parts) of the examination.

Interim Assessment

• 2024/2025 1st semester
  0.4 * Exam + 0.15 * Home assignments + 0.35 * Middle term exam + 0.1 * Test in digital literacy

Authors

• BESSONOVA IRINA ANATOLEVNA
• AKINSHIN ANATOLIY ANATOLEVICH