- Главная
- Разное
- Дизайн
- Бизнес и предпринимательство
- Аналитика
- Образование
- Развлечения
- Красота и здоровье
- Финансы
- Государство
- Путешествия
- Спорт
- Недвижимость
- Армия
- Графика
- Культурология
- Еда и кулинария
- Лингвистика
- Английский язык
- Астрономия
- Алгебра
- Биология
- География
- Детские презентации
- Информатика
- История
- Литература
- Маркетинг
- Математика
- Медицина
- Менеджмент
- Музыка
- МХК
- Немецкий язык
- ОБЖ
- Обществознание
- Окружающий мир
- Педагогика
- Русский язык
- Технология
- Физика
- Философия
- Химия
- Шаблоны, картинки для презентаций
- Экология
- Экономика
- Юриспруденция
Exam презентация
Содержание
- 1. Exam
- 2. Task 1 MS Excel: ВПР(VLOOKUP) and simple
- 3. Total problem 2. Read task to the
- 4. Task 1
- 5. Task 1: solution ВПР = VLOOKUP ЕСЛИ = IF СУММ = SUM
- 6. Should remember and know: 1. Functions ВПР
- 7. Common problems 1. СУМ, SUMM – such
- 8. Task 2
- 9. Task 2: solution
- 10. Should remember and know: 1. Logical operations.
- 11. Common problems 1. Use existing comparison symbols! 2. Write criteria according to the task!
- 12. Task 3
- 13. Task 3: scheme
- 14. Task 3: datatypes
- 15. Should remember and know: 1. Database normalization
- 16. Common problems 1. Don’t forget data types
- 17. Task 4
- 18. Task 4: solution Pay to broker: [Purchase-Sale]![Cost]*0,01
- 19. Should remember and know: 1. Query constructor.
- 20. Common problems Don’t forget about correspondence between
- 21. Task 5
- 22. Task 5: solution SELECT Apartments.[Area,m2], [Purchase-Sale].Cost, [Purchase-Sale].OperationTypeID,
- 23. Should remember and know: 1. SELECT operator
- 24. Common problems Previous task with query using
- 25. Task 6
- 26. Task 6: form design
- 27. Task 6: code
- 28. Should remember and know: 1. Ability to
- 29. Common problems Form design should be present
Слайд 2Task 1 MS Excel: ВПР(VLOOKUP) and simple operations 7
Task 2 MS
Task 3 MS Access: DB design 7
Task 4 MS Access: query constructor 5
Task 5 MS Access: SQL 6
Task 6 VBA: conditional task 8
Total max 40 points
Слайд 3Total problem
2. Read task to the end.
3. Don’t write answer to
4. Don’t write answer to somebody’s other task!
5. Don’t use anything on exam, including
calculators on the mobile phone.
6. Do exact that task requires!
7. Don’t distort task.
1. Duration – 3 astronomical hours.
Слайд 6Should remember and know:
1. Functions ВПР and ЕСЛИ.
2. Basic ideas to
adressing, functions.
Слайд 7Common problems
1. СУМ, SUMM – such functions don’t exist!
2. Don’t mess/,
3. SUM(G3 +G4+G5+G6) – unfortunately ☺,
will work correctly, but no points for this.
4. If you can not:
get correctly percentage from some number;
use signs > and < correctly;
you will be punished☺!
Слайд 10Should remember and know:
1. Logical operations.
2. Interface of extended filter.
3. Usage
filter.
Слайд 15Should remember and know:
1. Database normalization ideas.
2. Types of relations.
3. Types of data.
Слайд 16Common problems
1. Don’t forget data types and their properties!
2. Link compatible
fields!
3. Calculated fields are not required to be in table!
4. Don’t mess structure of the table
with its content.
5. If you know that solution limits the task –
please specify this.
6. Link 1-1.
7. Solve the problem from task exactly.
Слайд 19Should remember and know:
1. Query constructor.
2. Data selection operators Like, Between
3. Calculated fields!
Слайд 20Common problems
Don’t forget about correspondence between query and database scheme (previous
2. Don’t miss checkpoints to print fields of query.
3. Don’t forget to add more fields to query
to make it readable.
4. Don’t mess parameter and query condition!
5. Don’t forget about correspondence between scheme
in query and selected fields of tables.
6. Betmen – is not a Between operator!
7. Compare dates with Between, compare numerical
values with … And …
Слайд 22Task 5: solution
SELECT Apartments.[Area,m2], [Purchase-Sale].Cost, [Purchase-Sale].OperationTypeID, Condition.Condition, [Purchase-Sale]![Cost]*0.01 AS [Pay to
FROM Condition INNER JOIN (Apartments INNER JOIN [Purchase-Sale] ON Apartments.ApartmentID = [Purchase-Sale].ApartmentID) ON Condition.ConditionID = Apartments.ConditionID
WHERE (((Apartments.[Area,m2])>50) AND (([Purchase-Sale].Cost)>100000) AND ((Condition.Condition)="satisfactory"));
Слайд 23Should remember and know:
1. SELECT operator structure.
2. SQL common syntax.
3. Union of tables with INNER JOIN or WHERE.
4. Selection of data with WHERE and logical operations.
5. Calculated fields!
Слайд 24Common problems
Previous task with query using constructor should be done.
2. SQL
3. Don’t forget to union tables!
4. Don’t forget about explanation!
Слайд 28Should remember and know:
1. Ability to cerate math for the task.
2. Remember main controls of interface
and their properties (Button, TextBox).
3. Ability to link event with code.
4. Ability to get values from form,
calculate corresponding values,
print results on a form.
Слайд 29Common problems
Form design should be present with
clear names for every
2. Write code as correctly as you can.
3. Don’t write things you do not know exactly.
4. Check math formulas!
