Practical class № 1-2

Subject: «Number systems. Transfer numbers from one number system to another. Arithmetic in the
number systems.»
Purpose: To acquire the skills of operations in different number systems.
There are many methods or techniques which can be used to convert numbers from one base to another. We'll
demonstrate here the following
• Decimal to Other Base System
• Other Base System to Decimal
• Other Base System to Non-Decimal
• Shortcut method - Binary to Octal
• Shortcut method - Octal to Binary
• Shortcut method - Binary to Hexadecimal
• Shortcut method - Hexadecimal to Binary
Decimal to Other Base System
Steps
• Step 1 - Divide the decimal number to be converted by the value of the new base.
• Step 2 - Get the remainder from Step 1 as the rightmost digit (least significant digit) of new base number.
• Step 3 - Divide the quotient of the previous divide by the new base.
• Step 4 - Record the remainder from Step 3 as the next digit (to the left) of the new base number.
Repeat Steps 3 and 4, getting remainders from right to left, until the quotient becomes zero in Step 3.
The last remainder thus obtained will be the most significant digit (MSD) of the new base number.
Example
Decimal Number: 2910
Calculating Binary Equivalent:
Step Operation Result Remainder
Step 1 29 / 2 14 1
Step 2 14 / 2 7 0
Step 3 7/2 3 1
Step 4 3/2 1 1
Step 5 1/2 0 1

As mentioned in Steps 2 and 4, the remainders have to be arranged in the reverse order so that the first remainder
becomes the least significant digit (LSD) and the last remainder becomes the most significant digit (MSD).
Decimal Number: 2910 = Binary Number: 111012.
Other base system to Decimal System
Steps
• Step 1 - Determine the column (positional) value of each digit (this depends on the position of the digit and
the base of the number system).
• Step 2 - Multiply the obtained column values (in Step 1) by the digits in the corresponding columns.
• Step 3 - Sum the products calculated in Step 2. The total is the equivalent value in decimal.
Example
Binary Number: 111012
Calculating Decimal Equivalent:

Step Binary Number Decimal Number

Step 1 111012 ((1 x 24) + (1 x 23) + (1 x 22) + (0 x 21) + (1 x 20))10
Step 2 111012 (16 + 8 + 4 + 0 + 1)10
Step 3 111012 2910

Binary Number: 111012 = Decimal Number: 2910

Other Base System to Non-Decimal System
Steps
• Step 1 - Convert the original number to a decimal number (base 10).
• Step 2 - Convert the decimal number so obtained to the new base number.
Example
Octal Number: 258 Calculating
Binary Equivalent:
Step 1: Convert to Decimal
Step Octal Number Decimal Number
Step 1 258 ((2 x 81) + (5 x 80))10
 Step 2 258 (16 + 5 )10
Step 3 258 2110
Octal Number: 258 = Decimal Number: 2110
Step 2: Convert Decimal to Binary
Step Operation Result Remainder
Step 1 21 / 2 10 1
Step 2 10 / 2 5 0
Step 3 5/2 2 1
Step 4 2/2 1 0
Step 5 1/2 0 1
Decimal Number: 2110 = Binary Number: 101012
Octal Number: 258 = Binary Number: 101012
Shortcut method - Binary to Octal
Steps
• Step 1 - Divide the binary digits into groups of three (starting from the right).
• Step 2 - Convert each group of three binary digits to one octal digit.
Example
Binary Number: 101012
Calculating Octal Equivalent:
Step Binary Number Octal Number
Step 1 101012 010 101
Step 2 101012 28 58
Step 3 101012 258
Binary Number: 101012 = Octal Number: 258
Shortcut method - Octal to Binary
Steps
• Step 1 - Convert each octal digit to a 3 digit binary number (the octal digits may be treated as decimal for
this conversion).
• Step 2 - Combine all the resulting binary groups (of 3 digits each) into a single binary number.
Example
Octal Number: 258 Calculating
Binary Equivalent:
Step Octal Number Binary Number
Step 1 258 210 510
Step 2 258 0102 1012
Step 3 258 0101012
Octal Number: 258 = Binary Number: 101012
Shortcut method - Binary to Hexadecimal
Steps
• Step 1 - Divide the binary digits into groups of four (starting from the right).
• Step 2 - Convert each group of four binary digits to one hexadecimal symbol.
Example
Binary Number: 101012
Calculating hexadecimal Equivalent:
Step Binary Number Hexadecimal Number
Step 1 101012 0001 0101
Step 2 101012 110 510
Step 3 101012 1516
Binary Number: 101012 = Hexadecimal Number: 1516
Shortcut method - Hexadecimal to Binary
Steps
• Step 1 - Convert each hexadecimal digit to a 4 digit binary number (the hexadecimal digits may be treated
as decimal for this conversion).
• Step 2 - Combine all the resulting binary groups (of 4 digits each) into a single binary number.
Example
Hexadecimal Number: 1516
Calculating Binary Equivalent:
Step Hexadecimal Number Binary Number
Step 1 1516 110 510
Step 2 1516 00012 01012
Step 3 1516 000101012
Hexadecimal Number: 1516 = Binary Number: 101012
Тasks.
1. This figure in the decimal system to translate into binary, octal and hexadecimal numbers.
2. Set this a number on the decimal system.
3. Add the numbers.
Variant 1
1. а) 86010; б) 78510; в) 14910; г) 95310; д) 22810.
2. а) 10010102; б) 11001112; в) 1101011012; г) 1111111002; д) 7758; е) 29416.
3. а) 11011000002 + 101101102; б) 1011101112 + 10001000012; в)10010001112+1000011012;
Variant2
1. а) 25010; б) 75710; в) 71110; г) 91410; д) 26110.
2. а) 11110002; б) 11110000002; в) 1111011002; г) 1001111002; д) 12338; е)2B316.
3. а) 10101012+100001012; б) 11110111012+1011010002; в) 1001001112+1001110102;
Variant 3
1. а) 75910; б) 26510; в) 7910; г) 36010; д) 24010.
2. а) 10011012; б) 100010002; в) 1001110012; г) 11110100002; д) 14618; е) 9D16.
3. а) 1001010112+1110100112; б) 10011011102+11011001112; в) 10100001002+110111102
Variant4
1. а) 21610; б) 33610; в) 74110; г) 71210; д) 18410.
2. а) 11000001102; б) 11000102; в) 10110102; г) 10101000102; д) 15378; е) 2D916.
3. а) 1011111112+11011100112; б) 101111102+1000111002; в) 11011000112+11000112
Variant 5
1. а) 53010; б) 26510; в) 59710; г) 30010; д) 7510.
2. а) 1010001112; б) 1100010012; в) 10011010102; г) 10111101002; д) 13178; е)2F416.
3. а) 11000110102+111011002; б) 101110102+10101101002; в)10001101112+11100011112
 Practical class № 3
Subject: «Components of the computer. System resources. Storage devices. Data storage. Installation of
peripherals and test the operation.»

Purpose: Introduce basic components of a computer, to form the ability to work with system resources. Install
peripheral devices and test your computer.
Basic concepts
Modern computers are electronic and digital. The actual machinery -- wires, transistors, and circuits -- is called
hardware; the instructions and data are called software.
All general-purpose computers require the following hardware components:
 memory: enables a computer to store, at least temporarily, data and programs.
 mass storage device: allows a computer to permanently retain large amounts of data. Common mass storage
devices include disk drives and tape drives.
 input device: usually a keyboard and mouse, the input device is the conduit through which data and
instructions enter a computer.
 output device: a display screen, printer, or other device that lets you see what the computer has
accomplished.
 central processing unit (CPU): the heart of the computer, this is the component that actually executes
instructions.
In addition to these components, many others make it possible for the basic components to work together
efficiently. For example, every computer requires a bus that transmits data from one part of the computer to another.
Computer Classification, By Size and Power
Computers can be generally classified by size and power as follows, though there is considerable overlap:
 personal computer: a small, single-user computer based on a microprocessor. In addition to the
microprocessor, a personal computer has a keyboard for entering data, a monitor for displaying information, and a
storage device for saving data.
 workstation: a powerful, single-user computer. A workstation is like a personal computer, but it has a more
powerful microprocessor and a higher-quality monitor.
 minicomputer: a multi-user computer capable of supporting from 10 to hundreds of users simultaneously.
 mainframe: a powerful multi-user computer capable of supporting many hundreds or thousands of users
simultaneously.
 supercomputer: an extremely fast computer that can perform hundreds of millions of instructions per second.
Common PC Components
This table lists all of the common computer components, what they connect to and what they are used for.

№ COMPONENT PURPOSE
The motherboard or mainboard is the main circuitboard which interconnects to all other
1 Motherboard components. The motherboard allows communication and power to flow throughout the
computer system.
The Central Processing Unit (CPU) is the brain of the computer system. This is the part of
2 Processor (CPU)
the computer which processes all inputs and decides how they will be outputed.
Random Access Memory (RAM) is your computers short term memory and enables the
3 Memory (RAM) computer system to perform multitasking functions such as copy and paste or type
information into a word document without it saving.
The Video/Graphics Card is responsible for receiving visual inputs and displaying
(outputing) all visual data. Graphics processing has a very difficult task which is why
4 Video/Graphics Card modern graphics cards now have Graphics Processor Units (GPU) which work like a CPU
but for visual data only. This allows quicker rendering of 3D images and streaming of high
definition video and leaves the CPU free to work on all other data.
Network Interface The Network Interface Card (NIC) allows your computer system to communicate and pass
5 data to other computer systems within a Local Area Network (LAN) or over the internet
Card (NIC)
to Wide Area Networks (WAN).
The Hard Drive (HDD) is the long term storage for your computer system. Hard Drives
6 Hard Drive (HDD)
are used to archive and store data for future retreival.
The CD/DVD ROM Drive allows your computer system to read data from external media
CD/DVD Drive
7 like CDs and DVDs. Generally there are two types of CD/DVD ROM; readers and writers
(ROM)
(burners).
The Sound Card allows for the input (Microphones) and output (Speakers) of audio related
8 Sound Card
data.

Exercise 1.
1. Open the folder Comp on your desktop.
2. Locate the file RootMovie.swf and open(picture 1).
 Picture 1- Virtual Desktop
3. You need to close the tab and go to the tab to Learn(Picture 2).

Picture 2- The tab to Learn

4. In this tab you should consider Forums motherboard, adapter cards, internal drives, drives in external bays,
internal cables, external cables(picture 3).

Picture 3- Power Supply

5. Write down in your notebook features the basic components.

 Task
1. Consider the quick reference to the components in section Explorer.
2. Use mode Test to test your ability to assemble a desktop computer from starch. You must still follow the
layers of access, however you will not receive any instruction.

Control questions:
1. The place of the computer in the sciences?
2. What is the address of memory organization?
3. What is associative memory organization?
4. What is a stack of memory organization?
5. How is memory speed?

Practical class № 4
«MicrosoftWord as a word processor. Inserting pictures, creation graphical objects»
Objectives: todevelop skills as using graphical objects, such as OLE technologies.

Creation pictures in Word.These are the basic types of graphics that you can use to enhance your Word
documents: drawing objects, SmartArt, charts, pictures, and clip art. Drawings refer to a drawing object or a group
of drawing objects. Drawing objects include shapes, diagrams, flowcharts, curves, lines, and WordArt. These
objects are part of your Word document. You can change and enhance these objects with colors, patterns, borders,
and other effects. (Налентеуправления: Insert tab(ВкладкаВставка)Illustrations
group(ГруппаэлементовИллюстрации) Shapes objects (ОбъектФигуры)).

Group selected shapes. Select several shapes at a time by pressing CTRL on your keyboard and clicking each shape
you want to include in the group. On the Format tab (ВкладкаФормат) in the Arrange
group(ГруппаэлементовУпорядочить),click Group (Группировать) so that all of the shapes will be treated like
a single object. To cancel the groupselectyourobjectandclickGroup (Группировать)Ungroup
(Разгруппировать)or use context menu.

Pictures can be inserted (or copied):

1. from other applications (for example.,Paint, MsDrawing,Paintbrush and et.)
2. Drawing objectincurrentdocument (using Shapes objects).
3. Using Clipart or Online pictures.

After you have inserted a picture or drawing object into a Word document, you can use a variety of tools to
position the item relative to the page and text.
Picture position in text.
1. Selectyourpicture, thenopentheFormattab (ВкладкаФормат).
2. Click onWrapping Text (Обтеканиетекстом). Click the wrapping position that you want to apply.
OLEtechnology.The main differences between linked objects and embedded objects are where the data is stored
and how you update the data after you place it in the Word file.
You place either a link to the object or a copy of the object in the document. You can insert objects this
way from any program that supports the technology of linking and embedding objects (object linking and
embedding, or OLE).
For example, a monthly status report may contain information that is separately maintained in an Excel
worksheet. If you link the report to the worksheet, the data in the report can be updated whenever the source file is
updated. If you embed the worksheet in the report, your report contains a static copy of the data.
1. Embedded object
2. Linked object
3. Source file
Linked objects.When an object is linked, information can be updated if the source file is modified. Linked data is
stored in the source file. The Word file, or destination file, stores only the location of the source file, and it displays
a representation of the linked data. Use linked objects if file size is a consideration.
Linking is also useful when you want to include information that is maintained independently, such as data
collected by a different department, and when you need to keep that information up-to-date in a Word document.
Embedded objects.When you embed an Excel object, information in the Word file doesn't change if you modify the
source Excel file. Embedded objects become part of the Word file and, after they are inserted, they are no longer
part of the source file.
Because the information is totally contained in one Word document, embedding is useful when you don't
want the information to reflect changes in the source file, or when you don't want the document recipients to be
concerned with updating the linked information.
Two ways to use OLEtechnologies: Open Insert (ВкладкаВставка), then on the Text
group(ГруппаэлементовТекст)
1. Click on Object(Объект)
2. Click on Text from file (Текстизфайла)
The first method can be used for embedding (linking) a document fragment or an entire document, the second
one is used only for an entire document.

Exercise 1.Createscheme (see on the picture), group all graphical objects.

1. draw the rectangle ABB1A1;

2. make a line, for example, A1D1;
3. copyA1D1and insertthree timesВС, B1C1andAD;
4. make linesCC1, DD1, DCandD1C1;
5. select lines and click on Format tab
(ФорматВкладка)Shape Styles group
(ГруппаэлементовСтилифигур)Shape outline(Контурфигуры),
choosingDashes (Штрихи)Type of dashes (Типштриха) –
dotted-dashes (штрихпунктирный);
6. finish drawing reference axes, choosing the instrumentLine with
arrow (Линиясострелкой). For selecting AutoShape style, click the
right button of the mouse over the object and selectFormat
AutoShape (Форматавтофигуры) in the right click menu.
7. For placing the letter in the place required click onInsert tabText groupText box (Надпись) .
8. Clicking the buttonLine color (Цветлинии) in Format tab (Вкладкаформат)Shape Styles group
(ГруппаэлементовСтилифигур)Shape outline(Контурфигуры)(the frame should be selected), select
in the given pallet No line (НетЛинии),similarly the following Fill color (Цветзаливки) — No fill
(Нетзаливки), your frame becomes transparent. Now the text can be placed in it (we need only one letter –
top labelling).
9. Select your frame, copy it and paste 10 times. Sub index is established with theHome tab
(Вкладкаглавная)Font group (ГруппаэлементовШрифт)  Subscript Subscriptоr press CTRL+=

(Нижнийиндекс).
10. Modify the drawing into the single graphics object. For this purpose activating on Home tab
(Вкладкаглавная)Editing group(Редактирование) Select (Выбор) Selectobjects(Выборобъектов)
button stretch the punctuated frame around the whole drawing (select the drawing) and click Format tab
(Вкладкаформат) Arrange group (Группаэлементовупорядочить) selectGroup (Группировать).

Advancement questions:
1. What tool can be used for drawing the graphic objects in Word text processor?
2. What approaches is the work with graphics based on in Word text processor?
3. What isOLE –technologies?
4. What is the difference between linked objects and embedded objects?
5. What does Group objects mean?

Practical class № 5
Subject: «Spreadsheet processor MS Excel. Data entry and editing. Addressing cells. Calculating values
of a function. Master function.»

Purpose: Repeat the basic concepts of Excel spreadsheet, create the ability to enter and edit data, use various
types of addressing when solving problems, generate skills to calculate the values of functions to plot functions.
In a spreadsheet application, at a very basic level, values often need to be added, Class programs for the
creation and processing tabular data in electronic form, called tabular processors or spreadsheets. Feature spreadsheet
is the possibility of applying the formulas to describe the connection between the values of the various cells.
Excel document is called a workbook, the book is a collection of worksheets, each sheet has a table structure,
and may contain one or more tables. The maximum number of worksheets - 255, they are designated as the Page 1
(Sheet 1). Excel document is saved as a file with the extension * .xls. User representation spreadsheet Excel XP
(worksheet) consists of 65,536 lines (rows) and 256 columns or columns (columns), that appear on the computer
screen. Rows are numbered from 1 to 65536 and the columns or the column marked with the Latin letters A, B, ..., Z,
AA, AB, ... IV. At the intersection of the row and column is the basic structural element of the table - cell (cell). By
the contents of the cell can be accessed by its address (link), for example, A5.
In the worksheet cells may be the following types of data: text, Constants and Formulas. In one cell, you
can enter up to 32,767 characters of text or numerical.
 By default, numeric data align to the right, and text to the left. If the category name does not include the
width, the right-hand box (if it is not empty) overlaps the previous one.
Group adjacent cells forming a rectangular table area is called range.
Addressing cells. In Excel distinguish 3 types of cell addressing: absolute, relative, and mixed. When you
copy a formula from one cell to another cell automatically change the address included in the formulas. This is called
relative addressing of cells. Relative references used by default in Excel. But sometimes it is necessary not to
change the address of a cell with the formula is copied. This address is called an absolute and absolute link is set by
specifying a dollar sign before the row and column number, such as $A$2 or by pressing the <F4> key.
A mixed reference is a combination of absolute and relative references, when the row and column used
different ways of addressing, for example, $A1, B$2. the absolute part of the link is not changed when copying the
formula.
All formulas in Excel must begin with the character "=", finishes entering the formula by pressing the Enter
Examples of formulas: = 2*5^3+4 = A1 + A2 = A1 + Cos (5,282)
Editing formulas: To begin editing the contents of a cell, you must first select the cell. Next, turn on edit
mode by pressing F2 or by double-clicking the mouse. To edit the formula, you can press the button = in the formula
bar. In the edit mode is activated formula bar, which can be seen the formula text and not the result of its computation.
To change the formula you need to click to the line item where you want to make changes.
Formatting Data. First of all, you need to select the cells in which it is necessary to change the format of
the data. Then you can either open the right-click context menu and call it the command Format Cells, or cause a
command Format Cells from the Format menu. In any case, the screen will display the Format Cells dialog box.
Using it, you can install the data representation format in the cells: number formats alignment, borders and type of
cells, and to determine the level of data protection.
Since many complex and simple calculations are very common, the Excel program offers more than 200
pre-programmed functions. The functions in Microsoft Excel are called computational operation on a particular
algorithm and formula. INSERT Function is ready to enter into the calculation formulas. Button INSERT Function
on the toolbar looks like fx
To quickly find the required functions are divided into categories: 10 recently used, complete alphabetical
listing, Financial, Date and time, Math end Trig, Statistical, Database, Text, Logical, and check the properties.
Built-in INSERT Function helps to apply the function. It allows you to build and calculate the most functions.
Function in Microsoft Excel are formulas that have one or more arguments. The arguments specify
numerical values or cell addresses.
For example:
= SUM (A5: A9) - the amount of cells A5, A6, A7, A8, A9;
= AVERAGE (G4: G6) - average value of cell G4, G5, G6.
Functions can be nested in one another, for example: = ROUND (AVERAGE (H4: H8); 2).
Description of the basic functions.
Category Math.
ABS (number) - the module number.
COS (number) - the cosine of a predetermined number.
EXP (number) - returns the number of e raised to the specified power.
LN (number) - returns the natural logarithm of a number.
SIN (number) - returns the sine of the given number.
TAN (number) - returns the tangent of the given number.
ROOT (number) - returns the positive square root.
PI () - Returns the number of up to 15 digits.
POWER (number, power) - returns the result of the exponentiation;
SUM (number1; number2; ...) - returns the sum of all the numbers included in the list of arguments;
Statistical functions.
MAX (item1, item2, ...) - is looking for a maximum of arguments;
MIN (arg1; argument2; ...) - is looking for a minimum of the arguments;
AVERAGE (item1, item2, ...) - calculates the average of its arguments;
COUNTIF (range, condition) - counts the number of arguments in the range corresponding to the condition
When entering basic formulae, the mathematical operators defining the operation to be carried out are as
follows:
Operation: Sign: Example:
Addition + =A1+B1+C1+D1
Subtraction - =A1-A2
Multiplication * =C4*C5
Division / =C4/D4
Combination ( ) = A1*(B1+C1)
Charts - a graphical representation of data. They are used for analysis and comparison of data, presenting
them in a visual form.
Chart Wizard allows you to build a chart of 14 standard types of planar and volumetric representation, as
well as 24 non-standard type. To auto-build the chart just press the F11 key.
 Editing charts is running as using the context menu or by using the commands of the control chart menu.
Logical functions are used to perform calculations, depending on certain conditions. The conditions can be
used comparison operators =,>, <, <> (not equal),> = (greater than or equal to), <= (less than or equal to).
Function IF (logical_test; value_if_true; value_if_false) result is value1 if value2 and boolean true
otherwise.
logical_test - is any value or expression in the calculation yields a value of TRUE or FALSE.
Value_if_true - is the value that is returned if logical_test is TRUE. If logical_test is TRUE and value_if_true
omitted, it returns TRUE.
Value_if_false - is the value that is returned if logical_test FALSE. If logical_test FALSE and value_if_false
omitted, it returns FALSE.

Exercise 1. It is necessary to calculate the amount of tax, bonus and salaries sum of the whole, after
deduction of all taxes and charges premium.
1. Open an MS EXCEL program. Save the book under the name Laboratory work in its own folder.
2. Rename the current worksheet (Sheet1) to Exercise 1.
3. Enter the source data name1.
4. Make a table for the model.
5. To merge cells, select the cell and press the button or the Cell Format menu

6. To change the orientation of the text, you must

• Select the cell that contains the text context menu → Format Cells, Alignment tab, go to the field
orientation
• Click on the red diamond by holding down the left mouse button, drag to 90 °.
7. In order to calculate the amount of professional fee is 5% of the salary, it is necessary:
• Select cell D5, and enter the formula = C5*5%
• Similarly, for all taxes and premiums.
8. Calculate the amount received on the hands after calculating all taxes and accrued bonuses in H5 cells.
9. To sum up the entire amount of the salary of all employees and the amount of wages received by them
in his arms. For this
• Select a block of cells H5: H12.
• Click on the AutoSum button on the Standard toolbar.

Exercise 2: Using the capabilities of Excel, to find the sum of sales revenue in rubles and dollars.
1. Click on Sheet2. Rename it to Exercize2.
2. Create a table, fill it in the original data of the problem
3. Calculate the proceeds from the sale in dollars and tenge.
4. E6 cell, enter the following formula: = C6 * D6
5. In cell F6 enter the following formula: = E6*B3. B3 is the absolute addressing, click on the F4, you should get
$B$3.

Exercise 3. Set the rating on any subject as a percentage. If it is not lower than 45%, the student attested on the
subject, not otherwise attested.
1. Rename Sheet1 to Exercise 3.
2. Fill in the table on the model.

3. To determine whether a student is certified. Select cell C3. Run the following command. Formulas The functions
of the wizard to select the category of Logic, name of the function IF.
4. In the drop down box, the IF function. In the logical expression set conditions, check the cell B3, whether it is
greater than 50%, if so, the student is certified, if there is not certified. For this:
In the logical expression of the condition record: B3> = 50%
• In the Value_if_true «certified»
• In the Value_if_false «not certified»
• Click on OK.
5. Copy the formula to the rest.
Control questions:
1. What is a spreadsheet?
2. What forms autofill you know?
3. What types of addressing you know? How do they differ from each other?
4. How can merge cells?
 5. What are the ways you can enter a function in Excel spreadsheet application?
6. What are the categories of functions do you know?
7. What are the statistical functions do you know?

Practical class № 6-7

Subject: «Spreadsheet processor MS Excel. Data entry and editing. Logical functions»

Description of the basic functions.

Category Math.
ABS (number) - the module number.
COS (number) - the cosine of a predetermined number.
EXP (number) - returns the number of e raised to the specified power.
LN (number) - returns the natural logarithm of a number.
SIN (number) - returns the sine of the given number.
TAN (number) - returns the tangent of the given number.
SQRT (number) - returns the positive square root.
PI () - Returns the number of 𝜋 up to 15 digits.
POWER (number, power) - returns the result of the exponentiation;
SUM (number1; number2; ...) - returns the sum of all the numbers included in the list of arguments;

Learn how to use Excel's logical functions such as the IF, AND and OR function.
If Function
The IF function checks whether a condition is met, and returns one value if TRUE and another value if
FALSE.
1. Select cell C1 and enter the following function.

The IF function returns Correct because the value in cell A1 is higher than 10.

And Function
The AND Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are
false.
1. Select cell D1 and enter the following formula.

The AND function returns FALSE because the value in cell B1 is not higher than 5. As a result the IF
function returns Incorrect.

Or Function
The OR function returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are
false.
1. Select cell E1 and enter the following formula.

The OR function returns TRUE because the value in cell A1 is higher than 10. As a result the IF function
returns Correct.
Exercise 1.

Createthe table that calculates the n-th term and the sum of the arithmetic progression. The formula of the n-
th member of the arithmetic progression:an=a1+d(n-l) and the sum formula of the first n terms of the arithmetic
progression:Sn=(a1+an)*n/2, where a1 is the first term of the progression, adis the difference of the arithmetic
progression, using the absolute reference. The first term, which is equal to -2, and the difference is 0,725.
1. Click on Sheet1. Rename it to Exercize1.
2. Write down the formulas yourself.
 Exercise 2.Construct a graph of the function y = cos2 (2x) sin (x) + e-x│x│ for x in steps of 0.1.
1. Create the following table on sheet 2: fill in the values of the variable x with the fill marker.
In cell B3 enter the formula: = cos (2 * A3) ^ 2 * sin (A3) + EXP (-A3) * ABS (A3), copy the formula to the
remaining cells.
2. Select the values for the function and start the Chart Wizard.
3. Select the chart type - Graph.
4. In the Row tab, in the X-Axis signatures, select the range of X values.
5. Place the chart in this sheet and rename sheet 2 as the Function Graph.

Exercise 3.
Attestation was conducted on 3 subjects and it is necessary to determine whether a student is certified in all
subjects.
1. Go to Sheet3. Rename it to Ex3.
2. Fill the table according to the sample.

3. The values must be written in percentages. For this: Select the range B3: D7. Clickl the context menu → Format
cells.Go to the Numbers tab. Number format select Percentage, Set the number of decimal places to 0.
4. In cell F3, click the IF function.
 5. At the level of the formula line on the left side, click on
6. In the list, select Other functions, in the Logical category, select the function AND.
7. In the field Logical_value1: B3> = 50%, Logical_value2: C3> = 50%,
Logical_value3: D3> = 50%.
8. Click in the formula bar on the IF.
9. In the field Value if true, type the words: "attestation"
10. In the Value field, if you want to type words: "not attestation"
11. Click on OK
12. The result should be stretched for other cells.

x,y1;1
Exercise 4Building 3D Surface Plots

z  3x  2sin ( y) y
2 2 2

Create a work page called Ex_4.


1. Enter the values of X in 0.2 steps in the form of a column, starting from cell A2;
2. Enter the values of y in 0.2 steps as a string starting from cell B1;
3. in cell B2 write the Formula: =3*A2^2 – 2* SIN(B1)^2*B1^2;
After writing the formula, try to observe the correct change in addresses when copying it to the rest of the cells, draw a
conclusion: the values of X should be in Column A all the time, so that the column does not change, the sign of the absolute
address is placed in front of it, that is, A, and according to the values of Y, the address of the first row changes to 1 1.
4. in accordance with this, we bring the formula in cell B2 to the form: =3*$A2^2 – 2* SIN(B 1 1)^2*B 1 1^2;
5. extract the remaining values of z using the fill marker;
6.to do this, mark the range B2:B12 and stretch the fill marker until the corresponding rectangle is filled;.
 Figure 9
1. embroidery, Y, Z. mark with values;
2. call the chart Wizard (Charts), select the chart type (1st type);
3. change the chart parameters;
4.Place the chart on the same page, rename it to Surface.

Tasks for independent work:

You should build х, у =[-1;1], Z= surface according to the following tasks

Variant Tasks
1 Z=5x2cos2(y) –2y2ey

2 Z=2x2cos2(x) –2y2

3 Z=2e0.2xx2 –2y4

4 Z=x2 –2e0.2yy2

5 Z=3x2sin2(x) –5e2yy

Control questions:
1. What is a spreadsheet?
2. What types of addressing you know? How do they difference from each other?
3. What is a chart?
4. How can you create charts? Could you tell about the types of charts?
5. What kind of ways can you enter a function in Excel?
6. What categories of functions do you know?
7. Give me examples of statistical functions, which you know
8. Give me examples of math functions, which you know
9. Give me examples of logical functions, which you know
 Practical class № 8-9
Subject: «Database management System Microsoft Access. Creating a database from multiple tables.
Purpose: To introduce the main database objects from the ability to build a database from multiple tables, creating a
connection between them.
Database - a collection of data (tables) is stored together and connected to each other, or is it a special electronic
storage related data.
Database management system Microsoft Access is one of the most popular applications in the family desktop database.
All versions of Access have in their arsenal of tools greatly simplified data entry and processing, retrieval of data and
information in the form of tables, graphs and reports.
Microsoft Access is made up of individual components, which used for storing and presenting information. These
components are the tables, forms, reports, queries, macros, modules. Each object Microsoft Access have at least
two ways to create: with the constructor or using the Wizard. In Design created or modified the structure of the
object, in Wizard uses ready-made versions of objects that allows the user to choose.
Data is any information that you need to save to be able to refer to it periodically. Most databases have a table
structure. As we know, in a tabular data structure address is determined by the intersection of rows and columns.
The database columns are called fields and the rows - recordings. Fields form the structure of the database, and
write up information that it contains.
Field - are the main elements of the database structure. They possess properties. From the properties of the fields
depends on what types of data can be made in the field, and what does not, and what you can do with the data contained
in the field. For example, the data contained in the price, can be summed to determine the final result. To summarize
the data contained in the phone number, it is meaningless, even if the phone numbers written in figures. It is obvious
that these fields have different properties and are of different types.
Different types of fields have different purposes and different properties.
1. The main property of the text box - the size.
2. The numeric field to enter numeric data. It also has a size, but are different numeric fields, for example for input
integers and real numbers for input. In the latter case, in addition to field size also sets the size of a decimal part of the
number.
3. The fields for entering dates or times are of type Date / Time.
4. To enter the logical data having only two values .. Yes or no, 1 or 0, True or False, etc.), is a special type - Boolean
field. The length of this field is always equal to 1 byte, because this is more than enough to express a Boolean value.
5. A special type of field - Money. From the title it is clear what data it is stored. Monies can be stored in a numeric
field, but in currency format is easier to work with them. In this case, the computer shows the number, along with the
currencies distinguishes rubles and kopecks, pounds and pence, dollars and cents, in general, refers to them more
elegant.
6. In the current database, you can store not only letters and numbers, but also pictures, music clips, and videos. The
field for these objects is called a field object OLE.
7. In the text field has the drawback that it is limited in size (256 characters). If you want to insert in the long text, for
this is the MEMO type field. It can store up to 65,535 characters. MEMO field feature is that the actual data is not
stored in the field and elsewhere, and only a pointer is stored in the field on which the text is.
8. A very interesting field meter. At first glance, this is a common number field, but it has the ability to automatically
increase. If there is such a field basis, the number is automatically entered when entering a new entry is made one
greater than the value in the same field of the previous record. This field is useful for numbering records.
If the information is stored in a simple structure, to work with, it could do without a special database management
system. In practice, we have to deal with more complex structures, which are formed from many related tables.
Databases having associated tables, also referred to as a relational database.
The division bases on related tables are not only convenient, but sometimes necessary. For example, to increase the
number of orders of the company manager, dealing with rental of CDs, I have decided to put in the common room the
computer on which every client can view the list of available drives with illustrations of the games. If the database
contains only one table, along with information about the disks casual visitor will have access to information about
other clients of the firm. This manager is not only acquiring new customers, but will lose those who had.
In order to relationships between tables to work reliably and the records from one table could definitely find a record
in another table, you must provide a unique field in the table. When you create a table structure one field (or a
combination of fields) can be assigned to the key. With the key fields of computer runs too much. It checks their
uniqueness and faster to sort on such fields. Key Field - an obvious candidate for making connections. Sometimes the
key field is called the primary key.
The types of links:
1: 1:. The ratio of "one-to-one" For example: (a student - № student’s book)
1: N: ratio of "one-to-many". For example: One supplier... a)... can supply some products... b)... but each product can
be only one provisioned. (A group of students)
N: M: ratio of "many-to-many" entries in Table A can have multiple entries in Table B, and records in Table B
several entries in table A. For example: (students courses that they listen)
To create linked tables Requirements:
Data integrity is a system of rules that are used in an Access database for the relationships between records in related
tables. Monitor the integrity of the data as possible if the following conditions are met:
• Linked to the same table field is a key field or a unique index.
• Related fields have the same data type. Exception: The field meter can be connected with a number field, if it is of
type Long Integer.
• Both tables belong to the same Access database.

Exercise 1.Creation of databases Task data "Dean’s office"

1. Create a new database "Dean’s office" base. To create a new database:
• Load the Access, in the window that appears on the left side, click on office button, select the point where the new
database;
• In the "New Database" in the File name field as the name of the database, specify the name of the Dean’s office and
select the folder (click folder) where your database is located, in its own folder.
• click on the button <New>.
2. Create a database table. To create a database table:
• On the toolbar menu Creating a focus controls to call all types of Access objects (tables, queries, forms, etc.). In the
window, select the type of document to be created. You create a table, so select a tab, and then click Table to open the
Mode tab of the table.
• In the View menu / View is a list of options for further work: Table Mode and Designer.
• Select Designer and then click. A window appears in which you want to set Teachers table name and click OK. All
tablesare created, and we are in the mood of the Table Designer.
3. Define the field in the table under the table. 1. To determine the fields of the table:
• Enter into a string column "Field Name" the name of the first field of the teacher code;
• In column "Data type" list, click the button and select the numeric data type and field size; The whole of the General
tab
• Golf teacher automatically becomes a key code. To do this, you can also click on a key figure in the toolbar or context
menu.
• Enter the restrictions on data in the <code>;These data must be repeated, since Teachers codes do not have repeats
ured, as well as their changes must be provided. On the General tab, click the parameter row indexed floor;
Note.Index - a tool Access, accelerating search and sort data in a table. The key field (the primary key field) index
table automatically. It is not allowed to create indexes for the MEMO field types and Hyperlink, or OLE Object fields.
• Select the item in the list Yes (matches are not allowed);
• To determine all other fields of the database table Teachers under with table.1 follow steps similar to those described
above.

Table 1
Field name Data Type Field size
Teacher code Number Field Size: Integer
Full name Text 40
Date of birth Date/Time Format of field: Short format of date
Position Text 9
Discipline code Number Field Size: Integer
Discipline Text 11
Phone Text 9
 Salary Currency Format of field: General Number
The number of decimal places: 0

Save the created table. To do this, click on the sign "Close" .In the window that appears, click Yes.

Exercise 2. Edit the database.

1. Log in to the design mode for the projected table. If you are in the Database window, select in inset All Access
objects / Teachers table and from the context menu, click on the button Design
2. Enter the restrictions on data entered in the "Position"; You must be entered only words of Professor, Docent or
Assistant.
To set conditions to the value the input data:
• Click in the "Position" at the bottom of the Generalgo onValidation Rule;
• Click on the button to determine the conditions on the value of usingexpressionbuilder;
• In the window that appears, write to the professor, then click on the button (the button performs the function
of OR), please contact Docent, again click on the same button, writesAssistant and click <OK>. So you enter a
condition in which the field "Position" can only be entered as defined above

3. Enter the text of the error message that will appear on the screen when you enter incorrect information in the
"Position".
In line Validation text,error message type the sentence "This position is not, correctly enter the data."
4. Set the default value for the field "Position" in the form of words Docent.
Line Default Value, type the word "Docent". Go out from Design Mode. Save the changes in the table.
Exercise 3. Work in the table mode.
1. Go to the Table mode:
On the toolbar, the command Home / View, select the mode of the table. On the question of the preservation of the
table, click <Yes>.
2. Fill in the data table in accordance with the Table. 2 and check the system response to the input of incorrect
information in the "Position".
Try it in the <title> of any entry to enter the word Laboratoryassistant. Look what happened. You should see a
message: "This position is not correct, enter the data". Enter correct word
Table 2
Code Full name Date of Position Code of Discipline Phone Salary
birth discipline

1 Docent
AbayNargiza 23.10.1965 InformationScience 104468 120000
2 Professor
AmanovaAydan 25.07.1967 Economy 122140 289000
3 Docent
AsanAydar 05.12.1982 Mathematics 602365 180000
4 Assistant
Osman Adil 12.02.199 Mathematics 348569 107000
5 Docent
NurtasTalgat 16.02.197 Economy 667533 250000
6 Docent
NazarAygerim 30.05.1976 InformationScience 103698 103000
7 Docent
Abay Aisha 30.07.1981 Physics 1667533 107000
3. Change the width of each field in the table according to the data width:
• Click in any row of the field "code";
• The command Home / Blog / Advanced;
• To click <column width> window that appears. The width of the field changes, click the “best fit” button;
• Repeat this procedure with the other fields.
4. Make a table lookup teacher Abav:
• Set the cursor to the first line of the field "Name";
• The command Home / Find / Find
• Under the Sample line parameter, enter Abav;
• Click on <Find>. The cursor will move to the second record and allocate word Abay;
• Click on <Find Next>. The cursor will move to the seventh record and just as Abavalso selects a word;
• Click on <Close> to exit the search mode.
5. Make the replacement of data: Change wages assistant Osman from 107000 to 200000:
• Move the cursor to the first field line "Salary";
• The command Home / Find / Replace;
• In the window that appears, type in the sample line 107000
• Replace in line to enter 200000. Note the other options -
You have to search through all the records of the field;
• Click on <Replace all >. The data will be changed;
6. Perform data sorting in the "Salary" field in ascending order.
• Clickon any record field of "salary";
• Click the button on the control panel or the command Home / Sort and Filter. All data in the table will sorted in
accordance with the increase in value in the "Salary".
7. Learn how to use the filter:
a) Perform data filtering through the fields "Position" and "Discipline":
• Click on the entry field Associate Professor "title";
• Click on the button or use the command Home / Sort and Filter, the filter on the selected. The table will only
write about the teachers-docent;
• Click on the Information Science entry field "discipline";
• Click on the button or use the command Home / Sort and Filter, the filter on the selected. The table will only
write about the teachers - docent of computer science;
• To cancel the filtering, click the button on the toolbar or
8. Save the table.

Exercise 4. Create three tables: Students, Evaluation and Discipline.

1. Create a table Students
Field name Data type Field size

Student code Number Field Size: Integer

Full name Text 40

Group number Text 10

Phone Text 12

Scholarship Yes/No Yes/No

Set the "student code" as a key field. To do this, click on the field "student code" and the button on the toolbar
or click follow Design / Tools / Primary Key; Close the table by specifying the name of her students.
2. Create a table Disciplines:
Field name Data type Field size

Discipline code Number Field Size: Integer

Discipline name Text 15

The set "Code of discipline" as a key field. This table will be filled in mode shapes.
3. Create a table structure of the Evaluation:
Field name Data type Field size

Student code Number Field Size: Integer

Discipline code Number Field Size: Integer

 Evaluation Number Byte

Attention!!!In this table define the key field is not necessary, since the data in all the fields may be repeated. This
table is similar to the previous one, will be filled in Form view.

4. Develop a database schema, create relationships between tables: Teachers, Students, Evaluation, Discipline:

• Click on the toolbar or use the command work with databases /Design/Relationships/ Show table A window
will appear "Data Scheme";

• The name of one of the tables will be highlighted in the dialog box. Click <Add>;
• Move the highlight to the next table name and click <Add>. Similarly, add the remaining two tables;
• Close the window by clicking <Close>;
• Create a connection between tables Discipline and Evaluation. To do this, move the mouse cursor to the "Code of
Discipline" Discipline in the table, click the left mouse button and, without releasing it, drag the cursor to the "Code
of discipline" table Evaluation, and then release the mouse button. The screen opens the window "Edit Relationships";
• Check the box ("tick") in the property Enforce Referential Integrity by clicking on it. It cannot be done if both types
of fields are set differently
• Check the property of Cascade Update Related Fields and Cascade delete related records;
Note. Setting cascade update related fields and cascade delete related records will allow you to edit records only
Disciplines table, and table Evaluationthese actions are recorded automatic. For example, if you remove the
Disciplines table is one thing, the Evaluation in the table Delete all lines connected with this subject.
• Click on the button <New>. Communication will be created;
• Similarly create a connection between the field "code of discipline" in the table and Disciplinefield "code of
discipline" in the table Teachers, as well as between the field "student code" in the table of students and the field
"student code" in TableEvaluation. The result is shown in Fig. 4.;
• Close the window data schema, have answered yes to the question of preserving the layout.

Tasks for independent work:

1. Create a database... see table.

Independently think of these tables, fields, select the key fields, set links between tables.
Variant № Task
1 "Music Album", consisting of three tables, "Composer", "Singer," "Songs".
2 "Clinic", consisting of three tables "doctor", "Patient", "Land".
3 "Schedule", consisting of three tables "class", "Teacher", "Objects".
4 "Computer Show", consisting of two "Commodity bundle" of tables, the
"Buyer".
 5 "The participants of the conference" consisting of two tables "List of
Participants", "Themes of reports."

Control questions:

1. What is the database?

2. What do you know the main objects of a Microsoft Access database?
3. What do you know the ways to create objects
4. What types do you know of data, types of relationships?
5. What are the requirements for the creation of relationships between tables?

Practical class № 10-11

Subject: "Database management System Microsoft Access. Creating a database from multiple tables,
forms, reports, queries, macros, modules.

Aim: To introduce the main database objects from the ability to build a database from multiple tables, forms,
reports, queries, macros, modules; creating a connection between them.

Exercise 1. Create a form of Discipline through Wizards of forms.

1. To create a form of Discipline:
 In the Database window, click the Forms tab and click on button Create.
 In the New Form dialog box, select Master forms.
 Click on the icon list at the bottom of the screen and select from the displayed list table Disciplines
 Click on the «OK» button.
 Select the fields that will be present in the form. At this example will present all fields, so click on the
button .
 Click the button Next.
 Select the appearance of the form - table. Click the button «Next». Select required style and «Next».
 Set the name of the form: Discipline. Click the by Button «Done».
1. Fill in the data below.
Discipline code disciplinename
1 Computer science
2 Mathematics
3 Physics
4 Economy
 Close the form by naming it discipline.

3. Fill the table Teachers in table mode:

 In the database window, in the Tables tab, select the Teachers table, i.e. 2 times click on the Teachers table.
 Column Discipline Code fill in data from the table above.

Exercise 2. Fill in the table Students in forms mode using AutoShapes.

1. To create a form Students follow these steps:
 Click on the Forms tab in the database window;
 Click «Form Wizard»;
 In the window select the table Students;
 Select AutoForm: «Tabular»;
 Click the «OK» button. A form for data entry was created.
2. Fill in the table with data Students, below, through the form.
Code Full name Group Phone Scholarship
Student Number
1 AbdikarimovaSamalKorgankova F-15 260-15-63 Yes
2 ZholdasovaSholpanShorabekovna F-15 110-67-82 Yes
3 AktaevNyrbol F-17 172-97-21 No
4 AlimovaSholpanAtabayishi F-18 130-31-87 Yes
5 BaidildinaAidanaBeibitovna Mn-12 269-53-75 Yes
6 AtanovAdilkhanKairzhanovich F-17 234-11-63 No

2. Close the form by naming it Students.

 Exercise 3: Create an Evaluation form using Design.
1. To create a form Evaluation;
 In the data dialog window select the tab Forms. Click the button Create.
 In the «New Form» dialogwindow select mode Design. In this window select the table Evaluation
containing data and on its basis will be created the form and OK.
 Window form will be displayed inmenu Design ->Add Existing Fields.
 Click Field List on panels tools. Highlight all fields; hold downthe Ctrl keywith the left hand. Drag and
drop the mouse at data area.
 Close the window of list. Arrange the elements conveniently in the field.
 Set the size of the text fields of the student code equal to 18. To enlarge the size of element respectively the
title, follow the commandFormat - size - by the size of the data. Save the form with the name of theEvaluation.
 Close the form.
2. In the Database window will appear Evaluation form. Click 2 times. Fill in Data table Evaluation by
form
Student code Discipline code Evaluation

1 1 4
1 2 5
1 3 4
1 4 4
2 1 5
2 2 5
2 3 4
2 4 4
3 1 3
3 2 5
3 3 4
3 4 3
4 1 4
4 2 4
4 3 5
4 4 4
5 1 5
5 2 5
5 3 5
5 4 5
6 1 5
6 2 4
6 3 5
6 4 4

Exercise 5. Create a simple select query based on the table Teachers, which should be displayed teachers’ full
names.
1. To create a simple query:
 in the Database window, click the Queries tab;
 in the window that appears, click <Create>;
 in "Search" window, select the A simple query and click <OK>;
 in the window in the row Table/queriesselect the table Teachers (if there is not another created tables
and queries, it will be there in opened list);
 in the "Available fields" move the highlight to the parameter Surname;
 Click the button . Word Full name go to the window "Selected Fields";
 Click <Next>;
 In the parameter line Set the query name, type a new name Positions of teachers;
 Click the <Finish> button. A table with the results will be appeared.

2. Save the query. To save the query:

  Click the button or execute the command File, Save;
 Close the query window.

Exercise 6: Create a select query with a parameter in which there will be displayed names of teachers and
their disciplines, and as a parameter specify the name of the teacher and make the request for the instructor
AbayNargiza.
1. To create a query for a selection with the parameter:
 Create a select query for the following fields of the table Teachers:
"Full name", "Teaching Discipline". The request is created in the same way as in step 1;
 specify the name of the request Disciplines;
 Click the <Finish> button. You will see a table with the results;
 Go to the Design view by clicking on the button or execute the command View Design;
 in a string parameter selection conditions for the fields "Full name", enter a phrase
(brackets also enter): [Type Full name of teacher];
 Run the query by clicking on the button on the toolbar or the command Query, Run;
Note. In the above described way, the query is executed only in the design mode. In order to fulfill the request
from another mode, it is necessary to open the Queries tab, select the desired request and click on the button
<Open>.
 in the window type the name of AbayNargizaand click "OK". You will see a table with information about
the instructor AbayNargiza - her name and teaching discipline;
 Save the query;
 Close the query window.

Exercise 7. Create a query using the Design, which should be displayed names, group number, discipline and
evaluation by discipline:
 From the query creation list, select Design
 Add the desired table(Students, Evaluation,Discipline) choosing them and clicking by button Add.
 Complete the selection by clicking on the button Close.
 Select the field Full name, Group Number from the tableStudent, Evaluation from the table Evaluation,
Discipline name from the tableDiscipline. It's enough to make a double click on the name field. Second option – move
it at Cells request.
 In line Selection condition under Fields Evaluation Put 4 or 5.
 Click the button ! (run)on Panels Tools for representation request.
 Save the query with the name of Progress 1 by clicking the button save.

Tasks for independent work:

2. Create a database ... see the TABLE.
Create the fields yourself for these tables, select the key fields, establish the links between the tables.
Variant The task
No.
1 "Music Album", consisting of three tables "Composer", "Singers", "Songs".
2 "Polyclinic", consisting of three tables "Doctor", "Patient", and “Land".
3 "Class schedule", consisting of three tables "Class", "Teachers", and "Subjects".
4 "Computer salon", consisting of two tables "Assortment of goods", "Buyer".
5 "Participants of the conference", consisting of two tables "List of participants", "Themes of reports".

Control questions:
1. What the main objects ofMicrosoft database Access do you know?
2. What methods of creating objects do you know?
3. What types of data, types of relationships do you know?
4. What are the requirements for creating relationships between tables?
5. What the ways are there to create queries?
6. What types of queries do you know?
7. What operations are used when creating Query with the condition?
Practical class № 12
Subject : «Designing Web applications. Language of creating hypertext documents – HTML»
Purpose: to study the basic language HTML tags and receive initial skills building simple HTML- document
HTML stands for Hyper Text Markup Language, which is the most widely used language on Web to develop web
pages.HTML was created by Berners-Lee in late 1991 but "HTML 2.0" was the first standard HTML specification
which was published in 1995. HTML 4.01 was a major version of HTML and it was published in late 1999. Though
HTML 4.01 version is widely used but currently we are having HTML-5 version which is an extension to HTML
4.01, and this version was published in 2012.
Audience
This tutorial is designed for the aspiring Web Designers and Developers with a need to understand the HTML in
enough detail along with its simple overview, and practical examples. This tutorial will give you enough ingredients
to start with HTML from where you can take yourself at higher level of expertise.
Prerequisites
Before proceeding with this tutorial you should have a basic working knowledge with Windows or Linux operating
system, additionally you must be familiar with:
 Experience with any text editor like notepad, notepad++, or Editplus etc.
 How to create directories and files on your computer.
 How to navigate through different directories.
 How to type content in a file and save them on a computer.
 Understanding about images in different formats like JPEG, PNG format.
All HTML tags begin with the "<" and end with ">". As a rule, there is a start tag and end tag. For example, we
give the title tags that define the text inside the start and end tag and describes the document header:

<TITLE> Document Title </ TITLE>

The final tag looks just like the start, and differs from it by a forward slash before the text inside the angle
brackets. Some tags, such as <P> (tag defines a paragraph), does not require an end tag, but its use is attached to the
original text of the document easier to read and structured.
Create tables:
To represent tables used several types of HTML tags:
• tags TABLE, which frame the entire tabular specification
• optional CAPTION element specifying the title (name) of the table
• tags TR, specifying a table row
• TH tags, which specify the row and column headers
• tag TD, specifying data in the table, i.e. contents of table cells
Basic table structure
Let's start from a very simple example. It is associated with the presentation of the table of numbers 2 2
(single matritsa) without any headers. The HTML code looks like this:
<TABLE>
<TR> <TD> 1 </ TD> <TD> 0 </ TD> </ TR> 10
<TR> <TD> 0 </ TD> <TD> 1 </ TD> </ TR> 01
</ TABLE>
and the browser is usually represented as follows:
Additional properties; typical table with text cells
There are several items that you can add to the one discussed above a simple table model:
• Title (caption The) for the table associated with the table (in addition to the lines of text on the table in the
document).
• Subtitles (headers) (explanation) for table rows and for columns.
• Frames (borders) around the table and each table cell.
Note that the ALIGN and VALIGN attributes can significantly affect the quality of the display, set the
location of the table in relation to the fields of the document. Valid values are: ALIGN = LEFT (left justified), ALIGN
= CENTER (centered), ALIGN = RIGHT (right justified). WIDTH - the width of the table. It can be set in pixels (e.g.,
WIDTH = 400) or as a percentage of the page width (e.g., WIDTH = 80%).
Try HTML Online
Exercise 1.
Create the next HTML- document using text formatting tags
1. Open a text editor Notepad (блокнот). Save the document as Task1.html
2. The very first tag that appears in this document should be tagged <HTML>. This tag tells WEB-browser, that
your document is written using HTML. Therefore, in the first line of our document is typed <HTML>.
3. To enter the window title, then write:
<HEAD>
 <TITLE> Example of work with tags. Formatting
</TITLE>
</HEAD>
4. Now enter our body of the document, ie, that is reflected in our HTML-document. To do this, type the following
line
<BODY BGCOLOR = yellow TEXT = blue>
where BGCOLOR = yellow determines that the document background - yellow, and the TEXT = blue, the text will
be blue.
5. Next, recruit
<H1> This is the title of the first level </H1>
<H2> This is the title of the second level </H2>
those. It defines different levels of headings.
6. Now you will learn how to identify the numbered and unnumbered lists. To do this, enter
<OL> This is an example of numbered list
<LI> First element
<LI> Second element
<LI> The third element
</OL>
<UL TYPE = DISC> This is an example unnumbered list
<LI> First element
<LI> Second element
<LI> The third element
</UL>
7. Next, we format the text, ie, I use a variety of text formats. For this
<I> This is italic </I>
<B> This is bold font </B>
<U> This text is underlined </U>
<SUP> This superscript </SUP>
<SUB> This is the subscript </SUB>
<BR> This is the beginning of a new paragraph.
<BIG> This is large font </BIG>
<SMALL> This is a small text </SMALL>
<STRIKE> This is strikethrough text </STRIKE>
8. At the prompt, type the following line <BR> <BR>. This will mean that we have twice moved the line (press
«Enter» key).
9. Type the following line <MARQUEE> THIS TEXT TICKER </MARQUEE>. This creates a scrolling text.
10. This information reflected in our HTML-document over and you can close the tag <BODY>, typing </BODY>.
11. Now the record of our HTML-document has ended, so you can close the tag <HTML>, typing </HTML>.
12. Close Notepad, and then open your document by double-clicking.

Exercise 2. Change the text from the job site 1: Create a home page with a little information about yourself, using all
given tags, then Save the document as Task2.html
Exercise 3: Now, edit your document. Change the background, putting wallpaper.
1. Copy to your folder the picture with “jpg” format and rename it to image
2. In the folder which your HTML-document saved, click to the file “Task2” and open with Notepad
3. In the window that opens Notepad editor edit our HTML-Code. The tag <BODY> tag instead of the background
color, add BACKGROUND = "image.jpg"

<BODY BACKGROUND = "image.jpg" TEXT = red>

4. Close the Notepad window, save the document.

Exercise 4. Create the next HTML- document using the <IMG> tags and <A HREF>
1. Open a text editor Notepad window. Save the document as Task3.html
2. The first line of our document is typed <HTML>.
3. To enter the window title, then compose:
<HEAD>
<TITLE> Insert picture and hyperlinks
</ TITLE>
</ HEAD>
4. Type <BODY BGCOLOR = pink TEXT = black LINK = blue VLINK = red>.
5. Now insert a picture. To this end, the following line is typed
<IMG SRC = "image.jpg" ALT = "There must be a picture"
HEIGHT = 250 WIDTH = 250 ALIGN = middle ISMAP>
6. In the drawing and the following text will skip three lines. To do this, type
<BR> <BR> <BR>
7. Now, insert a hyperlink to a document of this type to Task1.html
<A HREF="Task1.html"> Go to a hyperlink </A>
8. Close the tag </ BODY>
9. Close the tag </ HTML>

Exercise 5. Create the next HTML- document which will contain the table. Enter the text of the program, save the
document as Task4.html. Learn all the tags associated with the creation of the table.
 Tasks for independent work:

Create a folder on drive D: \ «HTML» Specify the number of the group in this folder create a folder called by
his name, create a «picture» folder where the images are to pages. All pages are stored in a folder.
1. The site must consist of not less than 7 html-pages.
2. All pages must be in the same style.
3. All images must be placed in a «picture» folder.
4. The site should consist of three frames: Title (the name of the site) Contents The main frame that displays by
page.

Variant Task
1 Website " Computer viruses and their classification ."

2 Website of the CD drive ( device and principle of operation , the main technical
characteristics , different types of drives - their advantages and disadvantages ) .
3 The site is about display adapters ( device and principle of operation , the main technical
characteristics , different types of adapters - their advantages and disadvantages ) .
4 Website of the monitors (the device and principle of operation , the main technical
characteristics , different types of monitors - their advantages and disadvantages ) .
5 Website of the printer (the device and principle of operation , the main technical
characteristics , different types of printers - their advantages and disadvantages ) .

Practical class № 13
Subject : «Creation of video files using Windows Movie Maker software».
Purpose: Explore the interface and editing features of the program Windows Movie Maker.
Basics concepts
Windows Movie Maker (codenamed Sundance, formerly known as Windows Live Movie Maker in Windows
7) is a video editing software by Microsoft. It is a part of Windows Essentials software suite and offers the ability to
create and edit videos as well as to publish them on OneDrive, Facebook, Vimeo, YouTube, and Flickr.The first release
of Windows Movie Maker was included with Windows ME in 2000. Unlike other Windows Essentials apps, Movie
Maker has not yet been replaced or succeeded by anything else. The 2012 edition will no longer be available to
download after January 10, 2017, but Microsoft stated a new version in the Windows Store would be available "soon".
The layout consists of a storyboard view and a timeline view, collections for organizing imported video, and
a preview pane. When in Storyboard view, the video project appears as a film strip showing each scene in clips. The
storyboard/timeline consists of one 'Video' (with accompanying 'Audio' bar), one 'Music/Audio' bar, and one
'Titles/Credits' bar. In each bar, clips can be added for editing (e.g., a .WAV music file will belong on the 'Music/Audio'
bar). Still images can also be imported into the timeline and "stretched" to any desired number of frames. The Video
and Music/Audio bars can be "cut" to any number of short segments, which will play together seamlessly, but the
individual segments are isolated editing-wise, so that for example, the music volume can be lowered for just a few
seconds while someone is speaking.
Key features - Windows Movie Maker Software:
 With Windows Movie Maker, it's easy to organize and select the photos and videos you want to use in your
next movie.
 With Windows Movie Maker, you can add text, transitions, effects, and more. Change as much as you
want, or let Movie Maker do it for you.
 Post your movie to your favorite sites, including YouTube, Facebook, Windows Live SkyDrive, and many
others, right from Windows Movie Maker.
What you can do with Windows Movie Maker Software:
 TryanAutoMovietheme
Just pick the photos and videos you want to use, and Movie Maker does the rest.
 Sharewithfriends
Once your movie's done, it's easy to post it on popular social networking and video sharing sites.
 Addyourphotosandvideos
Import photos and videos from your PC or camera into Movie Maker to start making movies.
 Editthevideo
Make your movie look like you want it to, with editing tools that let you easily trim, split, and speed up or
slow down your movie.
 Edittheaudio
Add and edit your movie's sound track. Adjust the volume, fade music in or out, and more.
The main window of the program looks like this:
Create a video using all lower jobs. The name of the theme for the project are as follows:

№ TopicTitle
1 Historyofthecomputer
2 Operating system
3 Information security
4 Multimedia
5 Viruses and anti-virus programs
6 Architectureofthecomputer
7 Processors and motherboards
8 Information system and resources
9 External data carriers and tape recorders
10 Printers and scanners
11 ArchitectureofWindows
12 Monitorsandvideoadapters.

Task 1.Open the program and create a project called the chosen topic
1 Introduction to the program, with the work area and the main menu sections
2 Click on the first extreme Studio button to create a new project, in the list that appears, select "New Project" or hot
keys typed command "CRTL + N".
3 In the open the main menu, select the command "Video and photos" and take the desired data.
4 Click Add, select the command "Add Music" to add music to our new project. You can click on the down arrow is
shown on the icon to:
• Find music on the Internet (Audio Micro, Free Music Archive, Vimeo)
• Add music from your computer.
5 Working with Text.
• Add name. Add a new name to the selected item.
• Add name. Adding text to be displayed on the selected videos or photos.
• Work with subtitles.
6 Selecting AutoMovietheme you want to apply to the entire project.

Task 2. Add animation to our project

1 Open the Animation tab. Selecting a transition to be added between the previous and the selected item
2 Adding the effect of shift and zoom to selected items.
3 You can set the time for the duration of the transition.
 Task 3. Add visual effects
1 Open the tab visual effects. Selecting the effect to be applied to the selected videos or photos.
2 Use the brightness to increase or decrease the brightness level of the photo.

Task 4.Work with the Projects tab and Type

1 Managing audio files and the screen aspect ratio (Widescreen 16: 9, 4: 3 standard)
2 Use the View tab, you can adjust the scaling of the time, thumbnail size, waveform.
3 Look at the project with F11 hot key or Preview function on the entire screen of the View tab.

Task 5. Publication of the finished video

1 Ready to save the video with the help of the hotkey CTRL + S
2 Use the menu to publish the finished film in social networks such as: Facebook, You Tube, Vimeo,
3 Look at the project with F11 hot key or Preview function on the entire screen of the View tab.

Control questions:
1. What is the program? Advantages and disadvantages of this program
2. Describe the basic file extensions that are used in the program
3. What options includes the program?
4. To publish the finished video project?
Practical class № 14
Presentations
Plan of laboratory classes: What is presentation? Open a source file; Use a master slide to place objects; Create
presentation slides; Display a presentation.
Prepare a presentation about yourself in the Power Point program. At least 5 slides, no more than 10. Apply
animations to slide transitions and text, pictures in the presentation. Voice the slides.

Practical class № 15
Subject : «Creation of Google of accounts with use of Google Docs. Use of mobile technologies for receiving
an information access. GPS navigators. GSM a signaling.»

Purpose: The study features a text editor and spreadsheet processor from a set of provided web-Office
Service online technologiesexample of using Google Docs software.
Basics concepts
Google Docs is a free Web-based application in which documents and spreadsheets can be created, edited
and stored online. Files can be accessed from any computer with an Internetconnection and a full-featured Web
browser. Google Docs is a part of a comprehensive package of online applications offered by and associated with
Google.
Users of Google Docs can import, create, edit and update documents and spreadsheets in various fonts and
file formats, combining text with formulas, lists, tables and images. Google Docs is compatible with most presentation
software and word processor applications. Work can be published as a Web page or as a print-ready manuscript. Users
can control who sees their work. Google Docs is ideal for publishing within an enterprise, maintaining blogs or
composing work for viewing by the general public.
Google Docs lends itself to collaborative projects in which multiple authors work together inreal time from
geographically diverse locations. All participants can see who made specific document changes and when those
alterations were done. Because documents are stored online and can also be stored on users' computers, there is no
risk of total data loss as a result of a localized catastrophe. However, the Internet-based nature of Google Docs has
given rise to concerns among some authors that their work may not be private or secure.
A Google Account gives you access to Google products like Gmail, Google+, YouTube, and more with a
single username and password. When you create a Google Account, you can use that same username and password to
sign in to any Google product.
Use of mobile technologies for receiving an information access.
Store your files securely and access them from any device using Google Drive. You can also open and edit
your files from any device.
You automatically get 15 GB of storage for free and you can buy more storage.
Your 15 GB of storage includes:
 GoogleDrive
 GooglePhotos
 Gmail
My Drive is the folder that holds the files and folders you create. To access your files from different devices,
sign in to your Google Account.
A GPS navigation device or GPS receiver, and when used for vehicle navigation commonly referred to
simply as a GPS, is a device that is capable of receiving information from GPS satellites and then to accurately
calculate its geographical location. The Global Positioning System (GPS) is a global navigation satellite system
(GNSS) made up of a network of a minimum of 24, but currently 30
GPS devices may be able to indicate:
 the roads or paths available,
 traffic congestion and alternative routes,
 roads or paths that might be taken to get to the destination,
 if some roads are busy (now or historically) the best route to take,
 The location of food, banks, hotels, fuel, airports or other places of interests,
 the shortest route between the two locations,
 the different options to drive on highway or back roads.
Exercise 1.Create a Google Account
1. To create Google Account, go to the Create your Google
Account (https://accounts.google.com/signup)page.

Picture 1- Create a Google Account

2. Fill in all required fields

3. After you have filled in all the fields, click Next
Note! If you have an account you can use it.
If you can't remember ever signing in and would like to check if you have an account, just enter your email address
on the password-assistance page(https://accounts.google.com/ForgotPasswd). If there's no Google Account associated
with your email address, you'll get a message that says 'No account found with that email address' you entered.
If you forgot your username or password, visit the "Trouble signing in page."
Google Docs is an online word processor that lets you create and format documents and work with other people.
Exercise 2.Create a document
To create a new document:
1. Open the Docs home screen at docs.google.comor on the right side of the window, press the button disk(picture 2).
 Picture 2- Create new document

2. In the top right, under "Start a new spreadsheet," click New(You can also create new documents from the
URL: docs.google.com/create).
3. Write the text on the topic "Astana city of the future" and to issue the document in accordance with the model:
-Set the page settings for 1.5 cm on all sides (File - Settings - Fields);
-Set: main text font - Times New Roman, 12pt; font titles using styles - Times New Roman, 14pt; width
adjustment; one and a half line spacing; Indent the first line 1.25sm(Format-Line spacing);
-Set: title text: blue on blue background, centered, 18pt, Georgia, italic;
-Add header;
-insert picture (Insert - images): the first image (portrait) download by URL, download the second image
from a folder on your computer
-Content section titles using styles;
-insert (Insert - Table of Contents) and format a table of contents.
-Assign The document name in Task1.
4. When you're online, your Google files will save as you type. You don’t need a save button.
If you aren't connected to the Internet, you can set up offline access to save your changes.
Note: On Google Sheets, you need to click outside of the cell you're typing in to save.
Make a copy of a file
 Open Google Docs, Sheets, or Slides.
 Open the file you want to make a copy of.
 In the menu, click File-> Make a copy.
 Type a name and choose where to save it.
 Click Ok.
5.Share files and folders
You can share files and folders with people and choose whether they can view, edit, or comment on them.
Youcansharewith:
 Google Drive, Docs, Sheets, or Slides
 A linkoremailattachment
Note: To edit Microsoft Office files with others, you'll need to convert them to Google Docs, Sheets, or Slides.
Levels of access
When you share a file with other people, you choose what they can do with the file. You can always change your mind
or stop sharing completely. Chooseifothers:
 Can edit: Others can make changes and share a file with others. The default for sharing with specific
people.
 Can comment: Others can view and comment on a file but not make changes. Youcannotcommenton a
folder.
 Can view: Others can open a file but not change it or comment. The default for link sharing.

Share with specific people

1. Go to drive.google.com.
2. From your file list in Google Drive or from an open folder: Select the name of a file or folder. At the
top, click Share .
Tip: You can also right-click and choose Share.
3. Under "People" in the "Share with others" box, type the email address of the person or Google Group you
want to share with.
 Tip: Search for contacts by typing a name in the box.
4. To choose if a person can view, comment, or edit the file, click the Down arrow next to the text box .
5. Click Done. The people you shared with will get an email letting them know you've shared a file or folder.
Share a file or folder publicly
1.On your computer, sign in to Google Drive.
2.Click a file or folder.
 Google Drive: In the top right, click Share .
 Google Docs, Sheets, and Slides: In the top right, click Share.
3. In the top right of the "Share with others" box, click Get shareable link.
4. Next to "Anyone with the link," click the Down arrow .
5. Click More…
6. Select "On - Public on the web". Anyone can open the file on the Internet by searching or using the link.
7.Click Save.
8.Choose what level of access people with the link have: view, comment, or edit.
9.Click Done.
6. Links
You can insert, update, or delete links in Google Docs, Sheets, or Slides.
1. Open a document, spreadsheet, or presentation.
2. Click where you want the link, or highlight the text that you want to link.
3. Click Insert -> Link.
4. In the "Text" field, type the text you want to be linked.
5. In the "Link" field, enter a URL or email address, or search for a website.
6. Click Apply.
Exercise 3. Google Docs Spreadsheet
Create a new spreadsheet document(New- Google Spreadsheet ).
1. Complete the table format in accordance with the model:
 change the dimensions of the cells;
 set the table borders;
 yellow for the cells in the calculations;
 apply alignment for table cells;
 set the cell format: plain - for headings, for numeric cells - Decimal without decimals;
 install a font: name Georgia 14pt bold italic table; Cell name - Georgia 11pt; cells with numbers - Normal
11pt.
2. General view of the formatted table is shown in picture 3

Picture 3- The number of books issued to users

3. Add to Table 1 line: PhD doctors
4. Sort categories of users in alphabetical order(you can find in the section Data).
5. Using the summation function to count the total number of books issued in each quarter, and the total
number of books issued to library users in each category during the year.
6. Apply conditional formatting (Format - Conditional formatting) to the cells containing the number of
books:
-if the book is less than 400, a cell stain blue;
-if the book is from 400 to 700, a cell stain in purple, text, dark red color;
-if more than 700 books, cell dye green.
8. Rename the worksheet, giving it the title of the book.
9. Add another sheet and rename it, giving it the name
Diagram(Insert-Diagram).
Insert a chart (on a sheet of graph), its format:
-chart type - a bar;
-name - the number of books issued, the font Georgia 14pt, color purple;
-legend - right font Georgia 9pt.
 10. Assign a document name Task2.xls.
11. Set permissions for the document: to provide left neighbor and the teacher the ability to read your
document.
12. Get the link to access the document neighbor on the right. Open the document. Try to make changes to
the document. Close it.
13. Protect the sheet from changes in: access to change document is only possible for the owner.
14. Save it in your working folder on your computer.
Exercise 4.Use mobile phone.
There are several ways to use Google Drive. For the most flexibility, get the app for both your computer and
mobile device.
OPTION 1: Using a browser, go to drive.google.com.
OPTION 2: Download the app for Android or iPhone/iPad.
OPTION 3: Download the desktop app to automatically sync files from your computer.
1. Download the app on your mobile phone Google drive;
2. Open the app and click +
3. Click to download and upload a photo of your phone number
4. Show the result of a teacher with a computer
Exercise 4.Work with GSM navigation
1. Download the appYandex Navigateron your mobile;
2. Enter the address of21 Barayev str.;
3. Find a location for a route from your to your destination;
4. Make Route screen and upload using the Google drive in your Google drive;
5. Show the result of the teacher on the computer.
Tasks
1. Write text on given topics.
- To apply headers following formatting options:
-Space before 12 pt, after - 6 pt;
-Font sparse 3 pt.
-The character size - 12 pt
- Make access to several students from your group.
2. Find a location for a route from your to your destination.

Variant Work with Google Docs Work with 2Gis

1 The greatest leader for me 41 Seifullin str.
2 My favorite kind of music 55/2Auezov str.
3 My dream work 33 Auezov str.
4 Education in Kazakhstan 34 Koshkarbayev str.
5 Unhealthy food 4 Imanova str.

Control questions:
1. What is the Online Office? List the advantages and disadvantages of the use of online office.
2. List the file formats that works with a text editorGoogle.
3. List the main features of Google text editor.
4. List and describe possible ways of access to the document to other users. How it can be organized by users
chat while working together on a document?
5. Is there a limit on the size of documents, images and spreadsheets, editing in Google Docs?