Information Сomputer Systems

Bachelor 2021/2022

Type: Elective course

Area of studies: Economics

Delivered by: International College of Economics and Finance

Where: International College of Economics and Finance

When: 1 year, 1, 2 module

Mode of studies: offline

Open to: students of one campus

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

Language: English

ECTS credits: 4

Contact hours: 72

Full 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 course is not a part of the External Curriculum of the London School of Economics. 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

To give students a holistic view of modern information technologies and their role in professional activities
To 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
To 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

Analyze data using the Solver and Analysis ToolPak
Create and edit slides with speaker notes and graphic objects , import data from other sources.
Create dialog boxes (UserForms) to obtain information, clarify commands, and display messages.
Customize different charts. Use advanced charting technique representation of data
Declare and work with different types of variables
Manipulate Excel objects.Referencing objects.
Outline principles of Network types and Internet functioning. Search engines and portals. E-mail.
Record the macro, examine and edit the macro.
Sort and filter table data. Extract results of Advanced Filter.
To apply important control structures in VBA, which gives applications decision-making capability.
Understand Functions Syntax. Use Computational and financial Excel functions.
use computer hardware, explain characteristics of the main computer devices, their impact on efficient work, System and application software.
Use Excel logical functions in conditional analysis performing different actions depending on whether a condition is met.
use skills in creating and formatting text documents, applying the font and paragraph formatting, creating tables of any structure, adding graphic objects to the text.

Course Contents

Computer Architecture.
Networks and Internet.
Formatting text via MSWord
Creating presentations via MS PowerPoint
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

Mid-term exam
End-of-term exam
Online format.
Class performance: ha1 and ha2 - home assignments of part1 and part2 (5 tasks for each of the two
Online Test at the end of September.

Interim Assessment

2021/2022 1st module
For final grade determination see module 2.
2021/2022 2nd module
0.4 * End-of-term exam + 0.1 * Online Test at the end of September. + 0.35 * Mid-term exam + 0.15 * Class performance: ha1 and ha2 - home assignments of part1 and part2 (5 tasks for each of the two

Bibliography

Recommended Core Bibliography

Accounting information systems, Romney, M. B., 2017
Algorithms, DasGupta, S., 2018
Information systems : process and practice, , 2018
Бессонова, И. А. Основные принципы и концепции программирования на языке VBA в Excel : учебное пособие / И. А. Бессонова, С. Н. Белоусова. — 2-е изд. — Москва : ИНТУИТ, 2016. — 191 с. — ISBN 978-5-9963-0258-1. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/100287 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.
Бизнес-аналитика средствами Excel : учеб. пособие / Я.Л. Гобарева, О.Ю. Городецкая, А.В. Золотарюк. — 3-е изд., перераб. и доп. — М. : Вузовский учебник : ИНФРА-М, 2018. — 350 с. + Доп. материалы [Электронный ресурс; Режим доступа http://www.znanium.com]. - Режим доступа: http://znanium.com/catalog/product/854421
Бурнаева Э.Г., Леора С.Н. - Обработка и представление данных в MS Excel: учебное пособие - Издательство "Лань" - 2018 - 156с. - ISBN: 978-5-8114-1923-4 - Текст электронный // ЭБС ЛАНЬ - URL: https://e.lanbook.com/book/108304
Лебедев В. М. - ПРОГРАММИРОВАНИЕ НА VBA В MS EXCEL. Учебное пособие для академического бакалавриата - М.:Издательство Юрайт - 2019 - 272с. - ISBN: 978-5-9916-7880-3 - Текст электронный // ЭБС ЮРАЙТ - URL: https://urait.ru/book/programmirovanie-na-vba-v-ms-excel-433415
Лебедев В. М. - ПРОГРАММИРОВАНИЕ НА VBA В MS EXCEL. Учебное пособие для СПО - М.:Издательство Юрайт - 2019 - 272с. - ISBN: 978-5-9916-9836-8 - Текст электронный // ЭБС ЮРАЙТ - URL: https://urait.ru/book/programmirovanie-na-vba-v-ms-excel-437015

Recommended Additional Bibliography

Gunter Löeffler, & Peter N. Posch. (2007). Credit Risk Modeling Using Excel and VBA. Wiley.

Course Syllabus