6 Виправте помилки в реченнях (письмово)

1. Mobile TV Broadcasting is a system who lets you watch TV on a PDA or mobile phone. 2. A computer geek is someone which is an enthusiastic user of computers, sometimes to an obsessive degree. 3. The Recycle Bin is the folder that deleted files are stored until you decide to delete them completely. 4. Digital Terrestrial TV is a technology where allows you to receive more channels and a better picture through a conventional aerial instead of a satellite dish.

Тема 15 Електронні таблиці та бази даних - part 26

1 Перекладіть текст (усно). Напишіть до нього п’ять запитань (письмово)

TYPES OF DATABASES

A database consists of an organized collection of data for one or more uses, typically in digital form. One way of classifying databases involves the type of their contents. Digital databases are managed using database management systems, which store database contents, allowing data creation and maintenance, and search and other access.

Operational databases store data about the operations of an organization. Every organization uses such databases. Examples include customer databases that record information about a business' customers, personnel databases that hold information such as salary, benefits, skills data about employees, manufacturing databases that record details about product components, parts inventory, and financial databases that keep track of the organization's money, accounting and financial dealings.

Distributed databases are databases of local work-groups and departments at offices and plants. These databases can include segments of both common operational and common user databases, as well as data generated and used only at a user’s own site.

End-user databases consist of data developed by individual end-users. Examples of these are collections of documents in spreadsheets, word processing and downloaded files, or even managing their personal baseball card collection.

Hypermedia databases. The Worldwide web can be thought of as a database. Web browsers "process" this data one page at a time, while web crawlers and other software provide the equivalent of database indexes to support search and other activities.

2 Заповніть пропуски в тексті словами із списку (письмово)

List of words: database; field; layout; merging; record; sorted; updated;

1. In order to personalize a standard letter you can use 'mail … '. (a technique which consists of combining a database with a document made with a word processor). 2. Records can be automatically … into any order. 3. You can decide how many fields you want to have on a … . 4. Files can easily be … by adding new information or deleting the old one. 5. A … program can be used to store, organize and retrieve information of any kind. 6. The … of the records can be designed by the user. 7. Each piece of information is given in a separate … .

3 Заповніть пропуски в реченнях словами із списку (письмово)

List of words: there are two types of; is composed of; is a type of; are made up of; there are four main classes of ;

1. … microchips: (1) microprocessors, used as CPUs in computers, (2) memory chips, used to store data, (3) digital signal processors, used in mobiles and digital TVs, and (4) application-specific integrated circuits, used in cars and appliances. 2. In the future, people may have biochips inserted under their skin. Biochips … two components: a small chip, called a transponder, and a scanner. 3. A network … two or more computers connected together to share information and resources. 4. … network architecture: peer-to-peer, where all PCs have the same capabilities, and client-server (e.g. the Internet), where servers store and distribute data, and clients access this data. 5. Bluetooth … wireless technology for transferring data between devices.

4 Прочитайте та перекладіть текст (письмово)

SPREADSHEET PROGRAMS

A spreadsheet program is normally used in business for financial planning - to keep a record of accounts, to analyze budgets or to make specific calculations. It's like a large piece of paper divided into columns and rows. Each column is labeled with a letter and each row is labeled with a number. The point where a column and a row intersect is called a cell. A cell can hold three types of information: text, numbers and formulas. Formulas are functions or operations that add, subtract, multiply or divide existing values to produce new values. We can use them to calculate totals, percentages or discounts.

When you change the value of one cell, the values in other cells are automatically recalculated. You can also update the information in different worksheets by linking cells. This means that when you make a change in one worksheet the same change is made in the other worksheet.

The format menu in a spreadsheet usually includes several commands allowing you to choose the font, number alignment, borders, column width and so on. Most spreadsheet programs can generate documents with graphic representations and some include three-dimensional options. The values of cells are shown in different ways such as line graphs, bar or pie charts.

Some programs also have a database facility which transforms the values of the cells into a database. In this case each column is a field and each row is a record.

5 Виправте речення, що містять технічні помилки. Напишіть правильний варіант речень. (письмово)

1. A spreadsheet program displays information in the form of a table, with a lot of columns and rows; 2. In a spreadsheet you can only enter numbers and formulas; 3. In a spreadsheet you cannot change the width of the columns; 4. Spreadsheets programs can produce visual representation in the form of pie charts; 5. Spreadsheets cannot be used as databases;

6 Заповніть пропуски в реченнях словами із списку (письмово)

List of words: back up; keep up; update; built up; set up; upgrade; catch up; start up; starts up; uploaded; free up;

1. To avoid losing data, you should … your files regularly. 2. You can … your PC by adding a new motherboard. 3. Delete some files to … space on your hard disk. 4. Data is … from regional PCs to the company's mainframe each night. 5. The operating system boots when you … your computer. 6. She's taking a course to … her knowledge of computing. 7. The computer checks the memory when it … . 8. He … a website to advertise his travel company. 9. You can … with developments by reading PC magazines. 10. If you miss a class, you can study the hand-outs to … . 11. The image in a digital camera is … from a red, green and blue image.