Полтавський університет економіки і торгівлі

Final Exam. Task 3

2017-11-29T11:36:00.000+02:00

1. Download the file here.
2. Perform the actions specified in the file.
3. Send the file to the teacher for review.
Comments and explanations on how to complete the task can be viewed at this link.

Final Exam. Task 2

2017-11-29T11:33:00.002+02:00

The file MS Excel on a sheet "Database" to build a simple database with 50 records with fields.Format the field according to the type of data contained in these fields (text, date, number, money ...)

Number of order	Account number	Provider	Delivery Date	Goods	Price	Quantity	Cost
The numbers from 1 to 50	Several numbers from 84123 in increments of 7 to increasing	Make a choice from a list of providers: 1. Delicious products 2. Builder 3. Epicenter 4. Household goods 5. Gardener	Several dates from now to the past with step 8 days	Enter one of 10 available products: 1. Meat 2. Milk 3. Brick 4. Cement 5. Rake 6. Hose 7. Dishes 8. Kettle 9. humus 10. Fertilizers	Arbitrary numbers for each product	Several numbers from 227 in steps towards increasing 9	The formula of price (quantity multiplied by price)

Run the task of working with the database. The results obtained during the database to insert a new page file.

1. To select vendor records "Gardener" with the product number is more than 400.

2. To select entries supplies Dishes in the past two months.

3. Sort database suppliers simultaneously, and then the goods.

4. Find up the goods on the field "Quantity".

5. Create summary table, placed in areas of the diagram fields:

a. Page - "Delivery Date".

b. Column - "Supplier".

c. The line - "Goods".

d. Data - "Number"

Output data providers from provider "Epicenter".

6. Split database window between the cap and the table data (fixed area).

Final Exam. Task 1

2017-11-29T11:30:00.001+02:00

Task 1

Analysis of product sales plan for the year 2016

Name of product groups	Turnover				Total
	Retail		Wholesale warehouse		Total
	fact	plan	fact	plan	fact	plan
1	2	3	4	5	6	7
...					?	?
Total	?	?	?	?	?	?

Please fill in the table recalling 10 products.

Insert the formula instead of the question mark.

Excel

2017-11-28T11:10:00.000+02:00

Бібліотека ім. Вернадського

2017-11-28T10:02:00.002+02:00

Завдання

Deep Web

2017-11-15T11:16:00.001+02:00

1. Глибинна мережа
2. Глубокий интернет: сайты, как попасть
3. ЗАТЕРЯННЫЙ ВЭБ
4. TOR browser / ТОР браузер / обзор. Всё что вам нужно знать о нём

ІТР

2017-10-05T08:26:00.001+03:00

Завдання №2
Завдання №3

Modern information and communication technologies

2017-09-27T12:51:00.000+03:00

Excel (part 1):
Tasks: 1, 2, 3a, 3b, 3c, 3d, 4a, 4b, 4c, 4d, 4e.

Excel (part 2):
Tasks: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12.

Інформаційні системи та технології

2017-09-26T11:21:00.000+03:00

Завдання №1
Завдання №2
Завдання №3
Завдання №4
Завдання №5
Завдання №6
Завдання №7

Методи пошуку інформації в Інтернеті засобами пошукового сервісу Google

2017-09-19T09:54:00.004+03:00

Для перегляду завдання #1 перейдіть за посиланням
Для перегляду завдання #2 перейдіть за посиланням.

The science of effective presentations

2017-02-27T11:52:00.000+02:00

1. Наука ефективної презентації (eng)
2. Top 5 найкращих Prezi 2016 року (eng)

2017-02-24T11:46:00.001+02:00

1. Уроки створення презентації від Стіва Джобса
2. іПрезентація
3. Уроки убеждения от Стива Джобса

Смерть від PowerPoint

2017-02-23T11:26:00.000+02:00

Death By PowerPoint Rus from Alexei Kapterev

Final exam

2016-12-28T14:19:00.002+02:00

1. Download the file here.
2. Perform the actions specified in the file.
3. Send the file to the teacher for review.

Coursework. Unit 1.3

2016-11-24T13:18:00.001+02:00

Current situation you researched phenomenon. Describe current trends occurring in the studied subject.
What expects this segment in the future. How is moving and where this sector.
The first paragraph of the unit - a theme actualization.
The last paragraph of the unit - a result in which to write what we did and what it gives us and others.

Coursework

2016-11-24T12:06:00.000+02:00

Today we will work on the second unit the course work.
In this section should describe the conceptual and definitions of the subject.
We must give a definition of all terms that you will use in the course work.
You should also provide links to sources where these definitions were taken.
The volume of this unit should be 4 pages.
First paragraph - is actualization unit. Need to write that the correct definition of the concepts is essential and so on.
At the end of the unit should sum up and explain what has been done in this unit and what benefits is gives us.

Topics for coursework.

2016-11-23T11:22:00.003+02:00

To view the topics, click on this link

Good day.
Today we'll talk about writing a research paper.
In our classes you need to learn not only practical skills but also get scientific experience.
Our task - is to write coursework.
Today I ask you the following objectives:
First, choose a topic of which you like best.
Second, think up with a title of the topic and write a scientific text in volume four pages.
This scientific text should consist of distinct component elements:
The first part - is the relevance of the text. It is necessary to explain why this unit is our scientific work.
The second part - the main. Here you write generalized knowledge (based on sources you read with reference to the source).
The third part - the result. Summarize what we wrote here that it gives us.
The text must be written in the language of science. You can not use art style, journalistic style, you can not have a dialogue with the reader and so on.
Describe the history of the topic you have chosen.
Four pages of text. Only the most important date.

Куди піти навчатися після 11 класу?

2016-11-18T23:24:00.001+02:00

Одна з найперспективніших спеціальностей - електронна комерція
http://ecommercepuet.com/

Working with a database in MS Excel

2016-11-09T10:44:00.001+02:00

The file MS Excel on a sheet "Database" to build a simple database with 50 records with fields.Format the field according to the type of data contained in these fields (text, date, number, money ...)

Number of order	Account number	Provider	Delivery Date	Goods	Price	Quantity	Cost
The numbers from 1 to 50	Several numbers from 84123 in increments of 7 to increasing	Make a choice from a list of providers: 1. Delicious products 2. Builder 3. Epicenter 4. Household goods 5. Gardener	Several dates from now to the past with step 8 days	Enter one of 10 available products: 1. Meat 2. Milk 3. Brick 4. Cement 5. Rake 6. Hose 7. Dishes 8. Kettle 9. humus 10. Fertilizers	Arbitrary numbers for each product	Several numbers from 227 in steps towards increasing 9	The formula of price (quantity multiplied by price)

Run the task of working with the database. The results obtained during the database to insert a new page file.

1. To select vendor records "Gardener" with the product number is more than 400.

2. To select entries supplies Dishes in the past two months.

3. Sort database suppliers simultaneously, and then the goods.

4. Find up the goods on the field "Quantity".

5. Create summary table, placed in areas of the diagram fields:

a. Page - "Delivery Date".

b. Column - "Supplier".

c. The line - "Goods".

d. Data - "Number"

Output data providers from provider "Epicenter".

6. Split database window between the cap and the table data (fixed area).

More Functions

2016-10-27T13:24:00.000+03:00

Video

Exercise

Plot a graph

2016-10-26T12:04:00.003+03:00

Roses (curves Guido Grandi)
ρ=a*sin(k*φ), a and k - steel number (consisting of rose petals k for k odd and 2k for k even)
k = 2 (four-Rose), φ is [0,2π]

Plot a graph

2016-10-26T11:54:00.002+03:00

Cardioid

ρ=1-sin φ, φ є [0,2π]

Plot a graph

2016-10-21T10:47:00.000+03:00

Consider plotting in polar coordinates.

Archimedean spiral
ρ = aφ, a> 0

1. Let a = 2. In column A, we insert the angle φ on the interval [0,2π] in increments of 0.25.
2. In Column C enter the appropriate formula Archimedean spiral.
3. Convert polar coordinates into Cartesian using corresponding formulas connection between these coordinates.

The relationship between Cartesian and polar coordinates:
x=ρ*cos(φ)
y=ρ*sin(φ)

4) Building a spot-chart based column D i E.

Plot a graph of the function

2016-10-20T09:19:00.000+03:00

Build a graph of the function

2016-10-20T08:38:00.001+03:00