- •Английский язык
- •1 Terms to learn
- •2 Read the text Everyday uses of computers
- •3 Answer the questions.
- •1 Terms to learn
- •2 Read the text Types of Computer
- •3 Answer the questions.
- •1 Terms to learn
- •2 Read the text Parts of a computer
- •3 Answer the questions
- •1 Terms to learn
- •2 Read the text Keyboard and Mouse
- •3 Answer the questions
- •1 Terms to learn
- •2 Read the text
- •Interview: Student
- •3 Answer the following questions:
- •1 Terms to learn
- •2 Read the text
- •Input Devices
- •Optical input devices
- •3 Answer the following questions
- •1Terms to learn
- •2 Read the text Output devices
- •3 Answer the following questions.
- •1 Terms to learn
- •2 Read the text Storage devices
- •3 Answer the following questions.
- •Supplementary Reading
- •1Terms to learn
- •2 Read the text Graphical User Interface
- •3 Answer the following questions.
- •Unit 10
- •1 Terms to learn
- •2 Read the text Computing Support Assistant
- •3 Answer the following questions.
- •Unit 11
- •1 Words to know
- •2 Read the text Networks
- •3 Answer the following questions
- •Unit 12
- •1 Words to learn
- •2 Read the text Communications
- •3 Answer the following questions:
- •Unit 13
- •1 Words to know
- •2 Read the text The Internet 1: email and newsgroups
- •3 Answer the following questions
- •Unit 14
- •1 Words to know
- •2 Read the text
- •Internet 2: the World Wide Web
- •3 Answer the following questions:
- •Unit 15
- •1 Words to know
- •2 Read the text
- •Interview: Website Designer
- •3 Answer the following questions:
- •Unit 16
- •1 Terms to know
- •2 Read the text Word processing
- •3 Answer the following questions:
- •Test 10
- •Unit 17
- •1 Words to know
- •2 Read the text Databases and spreadsheets
- •3 Answer the following questions:
- •Unit 18
- •1 Words to know
- •2 Read the text Graphics and Multimedia
- •3 Answer the following questions:
- •Test 11
- •Unit 19
- •1 Words to know
- •2 Read the text Programming
- •3 Answer the following questions:
- •Unit 20
- •1 Words to know
- •2 Read the text
- •Interview: Analyst/Programmer
- •3 Answer the following questions:
- •Test 12
- •Unit 21
- •1 Words to know
- •2 Read the text Languages
- •3 Answer the following questions:
- •Unit 22
- •1 Words to know
- •2 Read the text
- •3 Answer the following questions:
- •Test 13
- •Unit 23
- •1 Words to know
- •2 Read the text Future Trends 1
- •3 Answer the following questions:
- •Test 14
- •Unit 24
- •1 Words to know
- •2 Read the text Future Trends 2
- •3 Answer the following questions:
- •Unit 25
- •1 Words to know
- •2 Read the text
- •Interview: it Manager
- •Unit 26
- •2 Read the text
- •Issues in computing
- •3 Answer the following questions:
- •Test 15
- •Unit 27
- •1 Words to know
- •2 Read the text Careers in computing
- •Unit 28
- •1 Words to know
- •2 Read the text
- •Interview: Systems Manager
- •3 Answer the following two questions:
- •Test 16
- •List of english-russian terms
- •Английский язык
Unit 17
1 Words to know
database, n |
база данных, БД |
field, n |
поле; пространство; область; зона |
record, n |
запись |
search, v,n |
поиск; искать, перебирать |
condition, n |
условие , состояние |
selection, n |
селекция; выбор(ка), выбор, вариант выбора, выбранный элемент |
rule, n |
линейка, линия (в НИС), правило (например, в нечёткой логике) |
cell, n |
ячейка, клетка |
row, n |
ряд; строка |
column, n |
колонка, столбец; графа |
formula, n |
формула; аналитическое выражение |
a blank record, n |
пустая запись |
a query language, n |
язык запросов |
SQL (Structured Query Language), n |
язык структурированных запросов, язык SQL |
logical operator, n |
логический оператор |
search condition, n |
условие поиска |
wildcard, n |
подстановочный символ |
wildcard symbol, n |
подстановочный символ, шаблон подстановки |
cell reference, n |
ссылка на ячейку, адрес ячейки |
spreadsheet, n |
крупноформатная (электронная) таблица |
addition, n |
сложение, суммирование |
subtraction, n |
вычитание |
multiplication, n |
умножение; перемножение |
division, n |
деление |
percentage, n |
процент, процентное отношение |
spreadsheet program, n |
программа обработки крупноформатных таблиц |
sum function, n |
сумма-функция |
rectangular box, n |
прямоугольник |
grid, n |
сетка |
array, n |
массив |
2 Read the text Databases and spreadsheets
A database is used to store information so that it can be searched and sorted in various ways. Each item of information is sorted in various ways. Each item of information is stored in a field. A collection of related fields forms a record. Simple searches can often be created by allowing the user to type the required field information into a blank record, and pressing a search button. More advanced database programs usually use a query language known as SQL (Structural Query Language). This allows users to type statements using logical operators to specify the search conditions.
Logical operator |
Meaning |
A. AND. B |
both condition A and condition B are true |
A. OR. B |
either condition A or condition B or both are true |
. NOT. A |
condition A is not true |
If you only known part of the field you are searching for, you can use special symbols, called wildcards, to represent combinations of characters. Although the actual wildcard symbols used can vary, most programs use a standardized set of wildcard symbols.
A spreadsheet program is used for calculating formulae. It is made up of a grid or array of rectangular boxer called cells, as shown below.
|
A |
B |
C |
D |
1 |
|
|
|
|
2 |
|
|
|
|
3 |
|
|
|
|
The columns are labelled A, B, C … and the rows of cells are numbered 1, 2, 3 … To refer to a particular cell, you use the column label followed by the row number. For example, the cell in the top left corner of the spreadsheet is A1, the one to the right of it is B1, and the one below it is A2. The cells can contain text, numbers, or formulae. The formulae are written using the cell references, e.g. to add the first three cells in the A column, you would use the formula A1+A2+A3, or the sum function Sum (A1:A3), i.e. the sum of cells A1 to A3. When a formula is assigned to a cell, the result of the formula is displayed in the cell rather than the formula itself. By varying spreadsheet values and formulae, different possible outcomes can be analysed.
Other common mathematical symbols used in formulae are shown in the table below.
Symbol Name Function | ||
+ |
plus |
addition |
- |
minus |
subtraction |
* |
multiply by (or times) |
multiplication |
/ |
divided by |
division |
% |
per cent |
percentage |