- Arts & Culture 5943
- Business & Economics 689
- Computers 319
- Dictionaries & Encyclopedias 81
- Education & Science 76068
- Abstracts 252
- Astrology 4
- Astronomy 1
- Biology 8
- Chemistry 2330
- Coursework 15587
- Culture 9
- Diplomas 411
- Drawings 574
- Ecology 6
- Economy 83
- English 75
- Ethics, Aesthetics 3
- For Education Students 17617
- Foreign Languages 11
- Geography 3
- Geology 1
- History 89
- Maps & Atlases 5
- Mathematics 13871
- Musical Literature 2
- Pedagogics 19
- Philosophy 23
- Physics 14874
- Political Science 5
- Practical Work 101
- Psychology 60
- Religion 4
- Russian and culture of speech 8
- School Textbooks 7
- Sexology 42
- Sociology 9
- Summaries, Cribs 87
- Test Answers 150
- Tests 9243
- Textbooks for Colleges and Universities 32
- Theses 24
- To Help Graduate Students 14
- To Help the Entrant 37
- Vetting 364
- Works 13
- Информатика 10
- Engineering 3062
- Fiction 696
- House, Family & Entertainment 107
- Law 132
- Website Promotion 71
Practice RFEI "Information systems"
Refunds: 0
Uploaded: 27.09.2015
Content: Информац.сист.в эконом. КП.rar 10,11 kB
Product description
Practice RFEI the course "Information systems" 6 jobs
Additional information
Exercise 1
Create a file MS Excel, giving it the name "Zadanie_1." Search the Internet for information about the dollar and the euro for the current week of the current year. Copy the data on the model considered in the computer lab №2 Workshop (Part 1) Figure 2.13 on List 1 and List 2 books you have created Excel. Rename sheet 1 in the "dollar" and rename it to Sheet 2 "euro".
Arrange to get a table, as shown in Figure 2.13 Computer Workshop (Part 1).
On a sheet of "dollar" plot the dynamics of the dollar and decorate it according to the figure 2.19 practical lesson number 2 computer workshop (part 1).
On a sheet of "euro" plot the dynamics of the euro and to design it in accordance with Figure 2.19 practical lesson number 2 computer workshop (part 1).
Save the file "Zadanie_1" folder you created in the "Test".
Task 2
Create a file MS Excel, giving it the name "Zadanie_2." Open the file named "Zadanie_2" and on the first sheet
create a table modeled on the table, pattern represented 2.23 Computer workshop (part 1).
How to do it?
Imagine that you are an employee of the company, which employs 10 people. Fill in your own content columns "Name", "Sex", "Birthday" (think of the data or take your work colleagues or your fellow students), "date of employment", "The salary" (here you can dream up but did not take his "high" from reality).
Further, according to the pattern discussed in Table 2.23, calculate the age and experience you invented 10 employees, respectively, filling out the remaining two columns "Age" and "work experience."
Determine the number of employees over 35 years old. Apply for a job, as shown in Figure 2.23.
Save the file "Zadanie_2" folder you created in the "Test".
Activity 3
The earlier you have created a working folder "Test" create a file MS Excel, giving it the name "Zadanie_3", and proceed to the assignment.
Open the file you created and copy jobs from the 2 two columns - "Name" and "The salary" in the list Open your file "Zadanie_3."
Add the resulting two-column table of the third column, calling it the "Financial assistance to leave."
Using logical functions discussed in practical work №3 first part of the computer workshop, determine the size of the financial assistance to employees.
Conditions for allocation of financial assistance are:
if the salary of the employee no more than (less than or equal to) 20 000 p., the financial aid allocated to the release of 5% of the salary;
if the salary of the employee for more than 20 000 rub., the financial aid allocated to the leave at a rate of 3% of salary.
If your employees´ salaries are not included in the proposed range in the problem, then resize the salaries so that the task was different solutions.
In the columns "Name" and "Financial assistance to the release of" build on the same piece of the pie chart to include the signature value in the sectors chart.
Save the file "Zadanie_3" folder you created in the "Test".
Task 4
The earlier you have created a working folder "Test" create a file MS Excel, giving it the name "Zadanie_4", and proceed to the assignment.
Make a table for the calculation of rent for tenants of 10 apartments, presented in the screenshot below (the remaining 7 apartments area and the number of living people need to come up with your own).
For the calculation you need the raw data, that you take from the top of the table represented by the screenshot - tariffs.
Feedback
0Period | |||
1 month | 3 months | 12 months | |
0 | 0 | 0 | |
0 | 0 | 0 |