Informatics and computer engineering (code - ICh 93).

Replenishment date: 28.08.2013
Content: 30828120705160.rar (337.78 KB)
️Automatic issue of goods ✔️
Sales:
3
Refunds:
0
Reviews:
0
Views:
133
Seller
Seller:
alevtina_sar
Rating:
3,21
Ask a Question
Report a violation
Description
Task 1
Computer structure. Show the structure of a personal computer. The central part of the circuit is to make a common bus (system highway), to which all the main PC devices are connected, indicating their short designations (for example, CPU, OP, GMD, etc. Under the diagram, decipher the designations and indicate the purpose of the device.
Task 2
Number systems.
2.1. Convert decimal number 12 to binary, octal and hexadecimal notation systems.
2.2. Convert decimal fractional number 0,42 to binary with three digits precision.
2.3. Convert binary number 1110011 to decimal.
2.4 Obtained in clause 2.2. convert binary number to decimal. Compare with the original number, explain the reason for the mismatch.
Task 3
Machine arithmetic.
3.1. Add binary numbers 1100 and 111. Check the correctness of the addition operation by converting the terms and the result to decimal numbers.
3.2. Multiply 1100 pure by 111.
3.3. Subtract 11 from 1100.
3.4. Divide 1100 by 11.
Task 4
Algebra of logic. A logic circuit with three inputs is given (logical variables X1, X2, X3). including two logical elements AND (logical multiplication), two logical elements NOT (logical negation) and one OR element (logical addition).
Required:
a) Using the circuit, write down the logical function F (X);
b) Create and fill out a truth table for all possible combinations of values ​​of logical variables X1, X2, X3

X1 X2 X3 F (X)


c) Determine from the table for which combinations of values ​​of logical variables the logical function F (X) will be true, i.e. will take the value 1.

Task 5
File size calculation
1. Considering that each character is encoded in one byte, estimate the information volume of the following sentence: “My uncle of the most honest rules, when he got seriously ill, he made himself respect himself and could not invent better”.
2. The amount of video memory is 256 KB, the number of colors used is 16. Calculate the options for display resolution, assuming that the number of pages can be equal to 1,2 or 4.
3. The data transfer rate through the ADSL connection is 1024000 bps. It took 5 seconds to transfer the file over this connection. Determine the file size in kilobytes.
Task 6
Reserving memory for placing a file on disk. User generated document contains:
a) two paragraphs of text, 10 lines each, 60 characters per line;
b) a raster image (high quality color photo) with a size of 150 by 120 pixels (24 bits per pixel). Calculate file size in bytes
Task 7
Algorithmization
The user enters consecutively into an array of X numbers (positive and negative). Develop and depict in the form of a flowchart calculating the sum of negative S and the product of positive elements of this array.
Task 8
Word processor.
In a word processor Word, it is necessary to prepare a document for distribution to addressees with the following content: "Where; ...... (address)
Recipient: ...... (surname, name, patronymic)
Dear ...... (name, patronymic). I invite you to a scientific and practical conference, which will be held at the institute (name of the institute) (date). The work starts at 11.00. Rector: (surname, initials)
Describe the procedure for creating a document as part of two files: a) the main file with the above content: b) a file with a mailing list containing the names and addresses of the invited persons. In the process of printing, insert the missing data into the text of the document from the mailing list
Task 9
Excel spreadsheet processor. Given a table of accounting of goods of the following content
Product Grade Price Quantity New price Amount
Bow 1 40 50 = =
Potatoes 3 20 100
Beet 2 50 100
Total *
The store manager decided to increase the prices of 1st grade goods by 10 percent and reduce the prices of 2nd and 3rd grade goods also by 10%.
It is required in cells E2 and F2 to enter the formulas for calculating the new price and the amount of goods sold at the new price, respectively, and also calculate in the cell
Additional Information
Task 7
Algorithmization
The user enters consecutively into an array of X numbers (positive and negative). Develop and depict in the form of a flowchart calculating the sum of negative S and the product of positive elements of this array.
Task 8
Word processor.
In a word processor Word, it is necessary to prepare a document for distribution to addressees with the following content: "Where; ...... (address)
Recipient: ...... (surname, name, patronymic)
Dear ...... (name, patronymic). I invite you to a scientific and practical conference, which will be held at the institute (name of the institute) (date). The work starts at 11.00. Rector: (surname, initials)
Describe the procedure for creating a document as part of two files: a) the main file with the above content: b) a file with a mailing list containing the names and addresses of the invited persons. In the process of printing, insert the missing data into the text of the document from the mailing list
Task 9
Excel spreadsheet processor. Given a table of accounting of goods of the following content
Product Grade Price Quantity New price Amount
Bow 1 40 50 = =
Potatoes 3 20 100
Beet 2 50 100
Total *
The store manager decided to increase the prices of 1st grade goods by 10 percent and reduce the prices of 2nd and 3rd grade goods also by 10%.
It is required in cells E2 and F2 to enter the formulas for calculating the new price and the amount of goods sold at the new price, respectively, and also to calculate in cell F5 the total revenue of the store from the sale of all the goods specified in the table.
Task 10
Database.
The Goods database table keeps records of goods sold in the store (see the table of Tasks 9). You need to perform the following steps: calculate new prices, increasing them by 10 percent for all goods and the amounts received from the sale of each product. Data search queries and calculations should be written in two query languages:
a) in QBE language (Query By Example) - on the form of queries in the New price field and the Amount field;
b) in the SQL query language (Structured Queue Language) in the form of two Select statements.
Task 11
Power Point Presentation System.
The user is faced with the task of using the Power Point system to create an album on the theme Flowers as part of 3 slides - the title slides and 2 slides of the "Object with Signature" type from the Office Theme set. Provide a title on each slide. On the last two in the Text field, prepare a short commentary on the flower. Photos of flowers can be found on the Internet. Animate each slide with colors, including animation effects for the text comment (movement of the text from bottom to top). Equip slides with control buttons. Describe all d
Similar items
Digital and computer technology
Seller:
Alex
Rating:
0
Sales:
0
price:
2,00 $
Mathematics and Computer Science
Seller:
alevtina_sar
Rating:
3,21
Sales:
0
price:
2,72 $
Computer science option 0
Seller:
alevtina_sar
Rating:
3,21
Sales:
1
price:
0,87 $
Informatics test CODE IC
Seller:
alevtina_sar
Rating:
3,21
Sales:
1
price:
0,87 $