Topic 1.1. Primary processing
Scope spreadsheet. preprocessing means
data. Consolidated Analysis. Data templates.
Topic 1.2. forecasting Fundamentals
Statistical data processing and forecasting. Models sliding
average and exponential smoothing. The model linear trend.
Topic 1.3. Financial and economic calculations in spreadsheet
The objective of the fund. The solution of equations and optimization problems.
The problem of optimizing the investment portfolio.
Application packages are solutions of economic and mathematical tasks.
SECTION 2. Artificial Intelligence Technology
Topic 2.1. Fundamentals of Artificial Intelligence.
The concept of artificial intelligence (AI). Applications of AI: System
natural language understanding, pattern recognition, symbolic system
computing system with fuzzy logic, genetic algorithms, game theory, etc.
The use of AI in the economy.
Topic 2.2. Expert systems and decision support systems.
The concept of expert system (ES). Classification ES. Purpose and
principles of EC. The use of ES in the economy. system concept
Decision Support (DSS). Conceptual model of DSS. application
DSS in the economy.
Topic 2.3. Fuzzy logic.
Basics of fuzzy logic. Scope based systems based on
fuzzy logic. Constructing expert system based on fuzzy logic.
Example of an expert system using fuzzy logic.
Topic 2.4. Neural networks.
Model of artificial neuron. The algorithm of the neuron. Artificial
neural networks. Application of Neural Networks for solving economic problems.
Topic 2.5. Genetic algorithms.
Basic theory of genetic algorithms. Application of genetic
algorithms. Application of genetic algorithms in the DSS. An example of solving the problem
using genetic algorithms.
SECTION 3. Corporate information systems
Topic 3.1. Relational databases
Types of databases and their structure. Relational databases. Objects database
data. Tables, queries, stored procedures. Normalization of data. anomalies
data. Queries. Types of queries. Providing access to databases.
client / server architecture. The SQL language.
Topic 3.2. Classification of corporate information systems
Data Warehouse (Data Warehouse). Data Mining (Data
Mining). Operational and analytical systems transaction processing (OLAP and
OLTP-system). Enterprise Resource Planning (ERP-systems).
Standards MRP, MRPII, ERP. ERP-system as a planning tool
SECTION 4. Local Area Networks
Topic 4.1. Classification of computer networks
The concept of a computer network. Classification of computer networks.
LANs and WANs. Regional networks. Corporate networks.
Topic 4.2. The principles of construction and operation of local networks
Local networks. Principles and standards for the construction of local networks.
Main components of LANs. Network resources. Transmission media:
Classification and basic characteristics. Methods to access a transmission medium.
Network topology: physical and logical. Basic Network topology: bus, ring,
star. The OSI reference model of interaction. The concept of the protocol stack
protocols. The basic protocol stacks.
SECTION 5: Global computer network. the Internet
Topic 5.1. The organization of the Internet. Addressing
Global network the Internet. History of the Internet education. protocols
TCP / IP family. Structure and coordinating the Internet authorities. Addressing
Internet: IP-addresses and Domain Name System (DNS). Absolute and relative
Topic 5.2. Access to the Internet
Forms of access to the Internet. Network service providers. The on-line and
off-line. Direct connection. The compound of a dedicated telephone line.
Topic 5.3. Services Internet
Services Internet Services. Email. Mail protocol on the Internet.
ID and address of the user. Internet mail server free
access. E-mail in the on-line and off-line. Teleconferencing System.
Mailing lists. IRC (Chat). Access to the remote computer resources (Telnet).
File Transfer Protocol (FTP). Systems of the automatic search on FTP- file
servers (archie). World Wide Web: history of occurrence. Hypertext documents. Concept URL. Language creating hypertext documents HTML. Structure
Topic 5.4. Browsers
Browsers Internet. General characteristics and possibilities of the most
Topic 5.5. Search the Internet
Finding information on the Internet. information retrieval systems in the network
The Internet. The query language search engines. An effective information retrieval.
SECTION 6. Creation of Web-pages
Topic 6.1. Basics of Web-pages
HTML format. Tags. The structure of HTML-pages. Creating a simple HTML-
document. Enable headers and text formatting of the document.
Use the URL-addresses when creating NTML documents. table decoration,
hyperlinks in an HTML list. The use of sound and graphics in HTML. Cards
Topic 6.2. Making Web-pages
Cascading Style Sheets CSS. Styles, description styles. Store style
external description file.
Topic 6.3. Dynamic Web-page
Forms and CGI-scripts. Programming languages (in this case, PHP) to create
dynamic Web-pages. Test and publish a website.
SECTION 7. Internet Marketing
Topic 7.1. Internet Marketing Basics
The Basics of Internet Marketing. Kibermarketing mix. Advertising on the Internet.
Means of promotion on the Internet. WHOIS service. Submit your site to search engines
Topic 7.2. Banner and context advertising
Banner advertising. Types of banners. banner exchange services.
The effectiveness of advertising campaigns on the Internet. Indicators CTR, CPM, CPC, CTI,
CTB, CPV, CPS, AD Impression, AD Reach, AD Frequency, AD Exposure. Context
Topic 7.3. Marketing research in Internet
Marketing research. Passive and active
study. Issues of copyright on the Internet.
SECTION 8. E-commerce
Topic 8.1. Basics of E-commerce
Basic terms and concepts. E-commerce, e-business, network
forms of organization, network economy. Advantages of electronic means
business. The theory of the network economy. Volumes and structure of e
trade in the world. The dynamics of involvement in e-sectors
trade. Factors of e-commerce development. Stages of e-commerce.
Sectors of e-commerce. Sector business-to-business. Sector business-toconsumer. Sector business-to-government.
Test task is likely to be of such a plan:
Put Denver (basic set of Web Developer)
Put NotePad ++
Create a simple HTML page
Create a table in it
Garnish with CSS
Create a database using phpmyadmin
Fill in the test information database
Try INSERT queries, UPDATE, SELECT, DELETE, to understand what the key and poly Auto_Increment
Output data from the SQL database query filter and sort them using PHP in HTML table document
Calculate the total amount of some sort columns by clicking on the button.
Try to work with PHP objects for understanding OOP.
Try to HTML multiple functions JQuery, for understanding
Try to look at our service code by FTP only-read access
Understanding the basics of FrameWork, URL Routing, MVC, SOA
Try to look at our service database by phpmyadmin only-read access
View popular types of input-s for forms inside the admin panel.