Інформатика 7 клас. Казанцева О.П.

004(075.3) 32.9772

14

(

20.07.2015 . 777)

.

: ..,

, ,

..,

.., -

..

. . 14 : 7 . . .

. / .. , .. , .. . : - , 2015. 176 . : .

978-966-10-4114-0 004(075.3)

32.9772

, . - .

.., .., .., 2015

- , 2015ISBN 978-966-10-4114-0

, | ' ( | , :

http:||www.bohdan-digitalxom|edu.

! .

. , - ( FILES). . , , . Scratch. . . .

1 4 .

:

,

Excel .? .

1. ?2.

? , ?

7,

. , - ( . 4.27 2016 ).

,

20

. . . : , .

,

7 \ ]

@

.

, -, -,

, , .

(^ )

.

?

. 1965 .

1

...

1.

1

. .

! , . , . .

(). , -,

-. (Google), (Facebook, - ), , , (YouTube), .

. . , . : Skype, ICQ.

(FTP). . , (, ).

, .

, . , , . (, , ), . , , , ,

$ ic q

6

, . . 1.1.

1.

1.1.

1. 1.

2. 2.

3.

4. 3. '

5. 4.

, , . , . . , . .

LEOANTSUKft.NET

; .

, . , , .

-----------------------------------------------------------------------\[email protected] = [email protected]

^ ^

7

mailto:[email protected]:[email protected]

1.

1.2 .

. (. 1.1).

(), ( ), , . .

, , .

. , , , , , .

, , , , : , , .

(. 1.2) , .

.

1965 , ARPANET, . , . , , .

8

1.

1.2.

,

. -, . - , .

- -, , . , - (. 1.2).

.

. 1.2. Ukr.net

9

1.

(, Outlook, Mozilla Thunderbird, The Bat!, Opera Mail .). , ' .

1.3.

, , , . (. 1.3).

. 1.3.

[email protected], [email protected]. , , (school.edu univer.org). . , ( ) school.edu . , univer.org. , univer.org , , , , . ( ), , .

10


1.

, , . , , . , . .

0

.

. 1.4.

,:

(2 ;

.

* \

, .

(, , ) ( , , ) .

@ .

, .

- -, , . , .

11

1.

1. , ? .

2*. petro_oliynik@ukr. net [email protected], ? .

**. , ? ?

mailto:[email protected]

2.

2

2 .1.

, . , - . , .

-, , Ukr.net (http://www.ukr. net/), (http://www.meta.ua/), (http://www. online.ua/), I.UA (http://www.maiU.ua/).

Gmail (http://gmail.com/) Outlook.com (http://outlook.com/). , , -, ( , ).

ukr.net - !

online:-) ua

G M a i lby Google

fls Outlook2 .2 .

- , .

13

http://www.ukrhttp://www.meta.ua/http://wwwhttp://www.maiU.ua/http://gmail.com/http://outlook.com/

1.

'

?

. 1.5. Ukr.net

Ukr.net. , - (www.ukr.net) (. 1.5).

, (. 1.6). :

(); ; ,

.

, , , , .

@ kr.net 4 .

super 7klass @u kr.net

01 - 1999

0987654321

email ( )

, - , .

20

. 1.6. Ukr.net

( , ) ( ).

14

http://www.ukr.net

2.

, , , . , , . ( ). - .

.

1

. Ukr.net.

1. Ukr.net (www.ukr.net).2.

(. 1.5).3. (. 1.7).

51_ (gukr.net

|_^____ | ~ [ 1999 |

0987654321

| ( )

, - , .

* * * * * * 7 0

. 1.7. Ukr.net

4. ( , ; ).

5. ( ' , ; ).

15

http://www.ukr.net

1.

-

, & ", ' " - .

. 1.8. Ukr.net6. ', .7. , ()

( ).

8. (, ).9. .

, , ' . , .

kkk_kkk_@ ukr.net

, , , [email protected].

:

[email protected] ukr.net-

ro4Ta@ ukr.net ukr.net

,

4.

. 1.9. Ukr.net ' ,

.

16

mailto:[email protected]:[email protected]:[email protected]:[email protected]

2.

2.3. -

- . (. 1.10) , , (), (), , , , . , , .

. ^ ukr.net [email protected] | | ! | * *

() 26 2012

[email protected] NNM-Club.ru 6 2012 21

0 8 5 2012

( 2 1 5 2012 2

(21 13 2012

(21 () 13 2012

1 | ! * -

. 1.10. - Ukr.net ( )

. , , , , , !, .

- , , () , .

, (, ) - (), , . , ( Ukr.net), () (. 1.11).

[email protected]

'

?

. 1.11. Ukr.net

mailto:[email protected]:[email protected]:[email protected]

1.

- , .1. ,

. , . 1.12.

2. .3. (

).4.

, .

5. .6. ,

( , ) , .

7. (). .

FREEMAIL

: ""

: |0 super_7klass@ ukr.net

: '[email protected]

"" < leoniks@ ukr.net>

:

: eDiska

! . , .

fFN day . 5

. 1.12. - Ukr.net

, ( ).

- , (, Gmail) .,

18

mailto:[email protected]:[email protected]:[email protected]

2.

. , , , , . .

2.5. .

, (. . 1.10). , . .

, . (. 1.13).

FREEMAIL^

ukr.net eDisk [email protected]

2

1

0

0

- >; ! -

!!!

! ! ,

eDisk

day.jp-g55 ~

4- 4

19 2014, 19:45:15

. 1.13. Ukr.net

. , Gmail Outlook - .

, , , .

19


1.

, -, . , .

, .

- , .

, , .

, .

.............. ..................... ...................................................................................................

1. -? ?2.

.3. ?

?4*. ?5. -

?6*. , ,

?>. ........................ ............................................ ................................................................

1*. ?

2. . !

3. .

3 .

3.1.

. , , . .

-, . , , , (. 1.14).

. 1.14. ,

. , , ( ), , . , . .

, .

, - , , . , (, , ).

:

"" < leoniks@ ukr.net>

: "" < Iiliy76@ ukr.net>-

21


, , (. 1.15). , .

1.

'

E-mail

1

-

--

3.2.

. 1.15. Ukr.net

, , . 10 25? , , , ? , . :

1. (, , 7-, ).

2. . .

3. .

3. , .

4. , .

3 .3 .

. , , , , , . , , , .

(. spam) , .

.

, :

;

, , .

. , . , , , , ( ).

23

1.

, , , , . , .

. .

. , , .

. , , .

, , . , .

. , , .

. .

. -, , -, .

. , .

. .

. .

24

3. .

, . ( , smile ) .

, , ( , 90 ). :-), . , , , . , , , :). . 1.3.

1.3.

:) 8-)

:(

;) 0:-)

:-| -*

:-> :-0

:-

:-D |-(

(. 1.16).

^ ( S ) ( ^ @ >

1.

-, . - , , .

. , .

, : ; .

: , , , .

- .............. . .................................................................... ..........

---- ------- --------------------

1. ? ?

2. ? ?*.

.4. ? ?5. ?6. ? .

------------

1*. , ?

2. ?

3. .

1

-.

. , - . , , , .

1. ,

.

) Ukr.net , ' (. 1.9). , (. 1.17).

. 1.17. Ukr.net

) , , .

) . , , ( ), , (. 1.18) .

_7 .

'

?

1.

FREEMAIL

* " " *

: ( 0

:

; eDisk'a

J "5? : 5

, :- ;- ;-

. 1.18. Ukr.net

) . , :

.

2. , .

) , . . . , ( . 1.19 1, 11). ?: , .

28

3. .

| ukr.net sev72iaiukr.net * | ! | * | *

19:07 21 ; 19

4 0 !!! 19 76 ; ( ) 19 119 0 ! 19 79 0 0 ( ) 26 2 012 1 0 [email protected] NNM-Club.ru 6 2012 2 1 0 8 5 2012 1

0 5 2012 2 >; 132012 1 1 () 13 2012 1

| | ! * | *

. 1.19. Ukr.net

) , . .

) , . , , :, .

) , , (. 1.20).

.^

uta.net super_7Kiass.eiuKr.net

: " ' *

: " "

: :

$

0 * 7 * ^ }= = ^

1

! , , !

20 2014, 19 32 28. $ . >

.

. 1.20. Ukr.net


1.

) - , (, , 1 ).

) , -.

3. - , .) , - ,

.) .

.) , -

, .) .

. .

, .

4. , .

) .) , ,

. (. 1.21).

!!.

ukr.net [email protected]

. 1.21. Ukr.net

) ( ).

. .


2.

4

/ \

( . , ) .

. (, , .) (, , .).

, , , , , . (). . , , . : , , .

, .

.

(, ) . , , . . . , .

, , , .

32

4.

( . modulus , , ) , , .

, , . .

, ?

:1.

(, , ).

. 2.1. () ()

2 . , , (, ).

) )

. 2.2. () ()

33

2.

3. , - , ( , ).

. 2.3. () ()

)4.

( , - ).

. 2.4. () ()

)

5. . , , , , ( , ).

6)

. 2.5. () ( ), () ( )

34

4.

6. , (, , ).

. 2.6. () ()

7. ( ).

. 2.7. () ()

: ( ,

, , ); ( , ); ,

( ); ( ); ( , ).

, .

35

2.

. , , , .

1. , - . , , .

0 .

. 2.8. , , , ,

2. . , , , , , , .

36

4.

, . , , . , , , , . , , , .

, - .

, : ; ; . (. 2.10)

.

. 2.10.

37

2.

: ,

; (),

.

. () .

. , -. . , , , , , , .

, . , .

(, ) .

: ( ); (, , ); (, , , ); (, ); (, , , ); ( , ).

2

. V2.pptx FILES . . V2.pptx.

4.

,

. ,

, .

. ,

. : ,

, .

, , -, .

.

. ,

, -.

, ...................................... .................................................................................................

- . . . 1. ?2. ? .3. ?4. ?5. ?

.6. ?

.> ............................. ...... ................................... .... .............................................................

**"**'*..*..**..

1*. ?2. ?**. ?

.

2.

5

5.1.

, . , , .

- , . , , , -, .

, , , , , , .

? ,

. . . . , , , .

. 2.11.

40

5.

(. 2.11):

; ; ; ,

; ., . 2.1,

. 2.1.

85

45

, ', , -, ,

12

.

, , , . ,

2.

. , , , . . , , , . .

. , . , , .

. 2.12.

. 2.12.

(, ) , , . , , .

5.

. 2.13.

.

, . (, , , , ). , : 5 = ( + ) / 2.

, S

= V t -. 2.14.

, . , , - . .

Kyiv Metro Map

K ey t o lines a n d sy m b o ls 1 Line 1 2 Line 2 3 Line 3

City Train Interchange Stations

Central Railway Terminal

Suburban Railway Terminals 1 Kyiv River Port

* 'Ollmpllskyr National Sports Complex, Stations under construction

You are here, 0 Stations that equipped with lifts and elevators for disabled persons

. 2.15.

43

2.

.

# 8

* ^ ^

% *

, , , .

, , , .

, . , . , : . , , . , , : , /

, . (6 - ). 6, 8(6 - ). , 40 , :

6 + 8(6 - ) = 40.

. :

6 + 48 - 8 = 402 = 8 = 4 ;6 - 4 = 2 .

, , 4, 2.

, , , . .

44

5.

, .

. Paint.

1. : .

2. .

9

6 ( 9 )

3

5 3,5

5 3,5

3. Paint.

4. _..

4

. MS PowerPoint MS Word.

1. .

2. , ( 3).

3. MS PowerPoint (MS Word).

4. 4_.

45

2.

5

. - .

MS Word

MS Word

MS PowerPoint

' Paint

MS Word

. V5.doc, FILES . , .

5.

. ( ).

1

Paint

2

MS Word

3

MS Word

4

MS PowerPoint

1. (

).

2. ' .

47

2.

( ). 4 3.

1.

(, , , ' .)

(, )

2. ( , , ).

3. ( -.)

-

'

5.

3. .

) 1 Paint , . 2_1_..

) 2 MS Word , . 2_2_..

) 3 Pr2.doc, FILES . , , . 2 . 2_3_..

) 4 , ', . 2 . ( -, ' ). 2_4_.

2.

6* ( )

..

, , . , , , , . , .

60- XX , . -: , , -, . , . , , , -.

, . () , , .

, ,

"

'

!

'

. 2.16.

50

6*. ( )

( . mind , ) , , , .

, , , () .

, () . , , , . . , , , .

, , , , , , .

, :

: , , ;

: , , , ;

, , , , ;

; ; . : () ; , ,

; ; ()

, ; (); ,

.

2.

: ( , ,

, , , );

(, ) ( );

( ), , .

. 2.17.

, . , , , - . , , , .

. , , ,

6*. ( )

-. , , , :

Edraw , MS Office 2007; FreeMind ,

; PersonalBrain ,

; XMind - .

-. Bubbl.us -

. . .

MindMeister , FreeMind;

Mind42 , Google, Yahoo, Flickr.

Mindomo , . .

!/=\

3 XMind

mini meister

0 Edraw

.

. . FREEMIND

FreeMind .

:

html-; ; ; ,

; , ; RTF (MS WordPad,

MS Word, MS Outlook ); , ,

.: FreeMind ; .

F reeM in dO f.

53

2.

. , - FreeMind.

1. FreeMind. ' .

2. ' .

) ', .

) , 16 ;

) .

3. .

) Insert.

) . 14 .) (. 2.18),

.

4. ' , ', . ( , . 3.)

) Insert.

) .) (. 2.19)

. ( Enter).

. 2.18

]

. 2.19

6*. ( )

5. ', (. 2.20). ' . -> .

. 2.20

6. : , , ', . ', , .

7. 6_.. -> PNG... File

name (' ) '. ( , -> , .mm).

MINDOMO

- , .

: ,

; ; ; .

. , , , , .

: ; ; .: ,

; , , 7.

2.

7

^55^ . , - .

1. www.mindomo.com.

Mindomo

,

. 2.21

2. ( ).

3. , , ', .

4. , , .

5. - , Student (, ) Submit.

Please choose your account type.

Submit. 2.22

http://www.mindomo.com

6*. ( )

6. ().

7. , Blank Mind (). , .

8. .

) (. 2.23), , [, . .

= F ] , > I . T o p ic ?

| _

T o p ic I jro p ic

Topic I Topic

. 2.23

) [>] (. 2.23) .

9. .

) ( ). .

) (. 2.24).

10. .

) (), (. 2.25).

) , Google, Enter.

57

2.

) , , , .

. 2.26

11. ' , ', .

) ( ). , .

) .) ,

.

. 2.27

12. . . 2.28 . . 10 .

6*. ( )

. 2.28

13. : , , ', . ', , .

14. 7_..

) ... (...)

(.png).

png.png .) 7_.

png . . -

, (, ) .

,

.

8

. , - . 9

. , - .. : . : , , . , . : , , , .

.

59

2.

^

1. ( )?

2. ?

*. ? .

4*. ?

...

Scratch

3.

7

. . , . Scratch, , . . Scratch, .

, . . , , . , , .

: , - (), .

- :

, . , . 3.1 - , .

. ,

, .

7.1.

7.

, . , , , . .

, . .

, .

( . script ) , .

= =

Scratch , . , , -, . -- . Scratch , . , ( Scratch -- , Lego), - , . , Scratch, , . 3.2.

.

.

. 3.1. -

. 3.2

63

3.

1. Scratch :

;. 3.3 * 2 ;

70 ; ; 1 ; 50 ; .

1. , . 3.3.

2. - (

), ,

, , .

2. - . 3.4.1. , , ( Octopus1-a Animals Scratch).

2. , . 3.5.

, Scratch .

. 3.4

3. 1, , . ( , ' ' ).

4. 10_.

7.

, . :

(); ; .

. , , . , - .

. 3.6.

, , . , , , .

. . , , , . . .

.

65

3.

, , , , . . 3.7 - .

. 3.7. . 3.8.

. , , , . , , .

, , (). , , . . 3.8 - .

. Scratch. , , . , .

66

7.

11

. , - .

1. Scratch -, , , .

2. , . 3.9, , .

. 3.9 , ?

. , ( ), Enter.

3. , , . 3.10. , ?

. 3.10

4. 11_.

67

3.

, . , , .

-: , -, .

: (), , .

, , , .

.

, , .

, , ().

, , .

8. .

8 .

, , .

. . . , , .

, Scratch, , . . , Scratch . . 3.11 - Scratch-. .

. , . Scratch , : , .

- , N ( ) 1, 0. . 3.12 Scratch-.

.

1 =

. 3.11. - Scratch-

69

3.

. 3.13

. 3.12. - -

, .

, , . 3.13.

16 , .

, , .

. 3.1 .

3.1. Scratch

Scratch

> .....................

/S//S

45

......... . , |

/

70

8. .

90

45

90

. - , , , , , . .

. .

71

3.

12

. , .

^ ,

1. Scratch.

2. , . 3.14.

. 3.14 2 , , .

. , () ( ).

3. 1 . , . 3.15. ( , , , ).

, , , ( ). , , : , 2. (. 3.16).

,

_______J

. 3.15

4. , 1 1 0,1 (. 3.17).

5. .

6. 12_.

72

8. .

0 1

0 ]

, |

0

0

. 3.18

13

. (. 3.18), .

1. , , .

2. , .

3. , .

4. 13_.

. , , .

, . .

, , , .

1. ?2. ?3. ?

73

3.

9

, , . .

, , , , . , .

. 3.19. - -

, . . 3.20, - , , - .

. 3.20. - -

9.

, Scratch (. . 3.2).

3.2.

Scratch

3

,

14

. , :) ;) , .

1. .

2. _8^_14 \_1 \_2, \_3, \_4.

3. , 0,3 , . .

4. , , ? , . 3.21, . 3.22.

.

0 . 3

. 3.21

3.

. 3.22

5. 14_.

15

. , .1. -

. , , .

2. , . 3.23.

. 3.23

. ? . , , .

76

9.

3. , .

4. 15_.

16

. (. 3.24), . 16_.

. 3.24

, .

L-----------------------------------------------, ,

, . ,

.

1. .

2. Scratch ?

3. , ?

77

3.

3

1. , , ' .

1. ^ . __1 __2 (. 3.25).

2. __1, __2 __1. __1, , , __2.

3. 1 .

) 2 2 ^ .) _8/.) .

4. , 2, 3, 4, 5, 6, 7, 8, 9. ( . 2 .)

78

9.

5. . . 3.26.

, . 1 . , .

6. 1 1 . . 3.27. 11

1.

7. , 1 , ' (. 3.28). 8 ,

. 1 9 8 .

. 3.27

0

. 3.28

. , ' . (. 3.29).

10 , . .

9. .

10. _.

11. , .

12. _.

er 2. - ( ), .

1. Spotlight-stage Indoors, People Breakdancer-1 , '.

3.

. 3.30

2. : Breakdancer-2, Breakdancer-3, Breakdancer-4.

3. ' , , .)

Music Loops HipHop.) ,

HipHop .) ,

, .

4. , . 3.31, .

80

9.

5. cassy-dancing-1 People.

6. , . -.

. , ' .

7. ( , ).

. . ... , ', . . . - , . 3.32.

9. -, . 3.33.

. , . , . , .

10. _.

. 3.32

. 3.33

81

3.

10 .

10.1. , .

, .

. . .

, .

10.2 .

. , . : .

, , : .

, .

. ,

, .

, (). , .

. .

SCRATCH

.

10. .

. , , 0 1 ( ). . Scratch . , , , . Scratch- , , , , , . Scratch , :

, .

;

;

;

, :

, ( );

^ , ( );

( ).

Scratch, -

, . . 3.34 .

?

. 3.34. Scratch

3.

17

. Scratch , , .

1. Ghostl Fantasy , (Ghost2-a Ghost2-b) - .

2. , . 3.36.

? ?

. 3.36

3. , . , , .

4. 17_. , .

84

10. .

18

. , .

L ,

. . ,

, . ,

(). , .

1. ?2. ?

.3. ?

.4*. Scratch.

85

3.

11

, , .

, , , . .

, . (. if) ( ) ( ).

Scratch . . 3.37 - Scratch. () , , ( ) -; , .

. 3.37. - - Scratch

Scratch

_______ (.. 3.3).

86

1

3.3.

,

. , ( )

, , ( )

, ( )

, ( ) - ? 3 ( )

( )

,

, -

, . ,

.

19

. , , .

1. ( 1- - ) (. 3.38).

2. -.

. 3.38

3. , . 3.39.

4. .

3.

J

: ?

1

J

1 1 Q

(

. 3.39. - Scratch

5. , ' . . , , . , , , . , , (.3.40).

=

. 3.406. 19_.

11.2.

Scratch . . 3.41 - -.

88

11.

1

2

. 3.41. - - Scratch

, , . .

(. 3.42) . , , , . -.

''

: ?

! [

. 3.42. - Scratch ,

, (. 3.43).

, .

Scratch , - .

. 3.43

3.

20

. ' . . : , .

' . < 90, , = 90 , > 90 . - ' (. 3.44).

. 3.44

1. , -- , Scratch (. 3.45).

2. 20_.

90

. 3.45

11.

21

. Scratch ' , - . 3.46. 21_. . , (, ).

. 3.46

. Scratch ' , . , .

20 , ( 1 179). 21 , , 14. .

91

3.

22

. - Scratch , . 22_1_, 22_2_ ... .

1. 1, 2, 3, 4, 5, 6, 7, 8, 9. .

2. . , : , (, , ).

3. . (, 1 ).

4. . , (, 1 , 6 ).

5. . , (, , ).

, , , , .

.

.

, . Scratch .

............................... ............................ ...................... ............ ............................................./

^ ' ' 1 '1. ?2. ?3. .4. .5. Scratch? 6*. ?

Scratch?

11.

4

. , , () , .

. 3.47 - , , , , . Scratch , .

1. , ( ). ( FILES^nP4 .)

2. . , .

3. , , ' . . 3.48 .

J

. 3.47

93

3.

. 3.484. .

5. ' . -, (. . 3.49).

. 3.49

6. , , .

7. , , 4_.

12.

12 Scratch

, .

. Scratch- , , , .

.

. 3.50. - ,

. 3.51. - ,

95

3.

, Scratch . , . Scratch ,

. - , ( . 3.52 ).

, .

Scratch (. 3.53).

-----------------------------

____________________

. 3.53. -

, , Scratch , (. 3.54).

. 3.54. -

. 3.52

12.

, . . , , .

,

. ^

23

. .

1. . 3.55.

. 3.55

2. (. 3.56) .

3. .

) , , .

) , , , 1 . 0.1. . 3.56

4. .

5. , , ( ).

6. 23_.

3.

24

. , .

1. Rotating Transportation. ( , ).

2. , .

25

^ . , .

1. Drawing Pancil Things.

2. , .

3. .

26

. , .

1. Scratch, ( Fish1-a Fish1-b Animals).

2. Scratch : , .

3. , . 3.57.

98

12.

4. , . 3.58.

5. , - .

6. 26_.

27

. , 4 . ' . - . 3.59.

. 3.58

. 3.59

3.

1. (. 3.60), .

. 3.60

2. , (. 3.61).

. 3.61

3. . .

4. , .

5. 27_.

100

12.

28

. , 1,2, , ... , .1.

.

2. 1:

) 1 ? ( 1 ? . 1 , ...);

) 25 (. 3.62).

. 3.62

3. , (. 3.63).

? 1

______ . 3.63

4. (. 3.64).

5. 2, 3, ... ( 2 , 3 . .)

6. 28_.. 3.64

101

3.

29

. , . trafific lights_1, trafific lights_2, trafific lights_3 Scratch ( FILES^Bnpaea_29 ). , , , 2 , 0,5 . ^ ( ). 29_.

L Scratch

. .

Scratch- , , , .

, Scratch , , .

Scratch . , , .

1.

?2.

Scratch?3.

?4.

?

12.

5

1. , , . 2, 4 5 , .

1. Scratch Automat, Scratch ( FILES^flPS ).

2. , , (. 3.65). . 3.65

3. .

4.

2, 4, 5.

5. 5_1_.

2. , , , .

1. Fantasy13, Fantasy.

2. , .

) ?.

) , ( ).

103

3.

) , ( '). , . 3.66.

]

0

. 3.66

3. , ( , ' ).

4. 5_2_.

104

4.

13

MICROSOFT EXCEL

. . , , .

, .

, , . , , .

13.1.

Microsoft Excel, Microsoft Office.

/ v

Excel . executable cells, .

, 1961 . Budgeting Models anc[ System Simulation.

Excel: , ; ; ( ,

, , );

; (

, ). ,

: Microsoft Office Microsoft Office Excel 2010.

. , Microsoft Word Microsoft PowerPoint.

106

13.

. 4.1. Microsoft Excel

Excel . , , , . Excel . , ; , . . - .

, . (, , , D ), (1, 2, 3, 4 ).

- . .

, , . , 5, F12, 5.

, Excel, .xls, .xlsx.

2

107

4.

Excel, , . . , . ( ), . .

, , . , .

, , .

. 4.2 , , 2 3, 5.

. 4.2

. . 4.3 . 4.4 , , :, , 1 :5 2:5.

, . - , : X ^

D

1

2

3

4

5

5

. 4.4

Enter . , Esc .

108

13.

, , , , .

255 . , .

, .

, , (. 4.5).

, .1 . .

^ ( ).

2 . . (. 4.6), .

-*' 1

. 4.5

. 4.6

4.

13.2.

1 1

234567391011

. 4.7

, . , , .

, , . , (. 4.7), (. 4.8).

, , . , , (. 4.9).

| | .|

4 5| . 4.9

, , (. 4.10).

12345 . 4.10

13.

. , . 4.11.

D

1 2 (. )3 1 4,874 2 125 3 12,7566 4 6,677 5 143,768 6 120,429 7 51,3

10 8 49,511

1. Excel.

2. 1 . Enter.

3. .

) 2, Enter.

) Enter.

) (. ) .

4. :10 1 8. Enter, |.

5. :10 .

6. :10 .

7. ' _ ( , ).

4.

Q .......... ............N

, , .

, , .

Microsoft Excel, Microsoft Office.

MS Excel , .

, . , .

- . , , . - , , .

. ,

; . , , . , Ctrl .

1*. , Excel.

2*. Z?

14.

14

14.1.

, , . Word.

, -

,

, , , .

, ^ - . Excel :

; .

31

. , . 4.12.

D1

2

(. )

3 1 4,874 2 125 3 12,7566 4 6,677 5 143,768 6 120,429 7 51,310 8 49,511

1. _ ' 31_ .

113

4.

2. , 1:1 ( 1 , , 1) - .

3. . , . , 14 .

4. .

) 2:2 ^ .

) * .) ,

5. .

) 2 ^ .

) : , . , .

6. . ( 2:10),

7. , (+.

32

. , .

0 , . 2 17 3 9,9 . 4 9,6 5 9,4 . 6 8,5 . 7 7,7 8 3,3

114

14.

1. Excel.

2. , . 4.13, .

3. 1, 1, 1, D1 .

4. .

5. ' 32_.

14.2.

, , .Excel , . , .

, , . , , (. 4.14).

.

115

4.

Excel . 4.1.

4.1.

10,25; 7,000

( 2010 )

10, $12,23

12.03.14; 12.03.14 16:15

17:30; 17:30:25

( 1 100%)

12,5%; 50%

, , , (. 4.15).

. 4.15

, ( , % ) . , . , 35,50 8, ( , 2, 8 ). 35,5.

\ /

-

* _ - % ^

"

(0) . . . , , . .

*

116

14.

, / ( ). , . / ( ) ( ) , .

33

. , . 4.16.

D

1

,

, %

2 1 .. 01.12.10 4 750S 20%

3 2 .. 12.03.11 2500

4 3 .. 17.01.11 4 900S 15%

5 4 .. 1. 09 .09 3 700 10%

.. 01.07.0 6500 25%

7 .. 24.01.06 3 220 10%

7 .. 09.10.10 4 050

9 .. 11 .11 .1 1 3 015 20%

. 4.161. Excel.

2. .

3. 2:9 :

2:9; ; ; .

4. D2:D9 , .

5. 2:9 . , .

4.

6. ( , , , ).

7. ' _.

, , , ? , :

; ()

; +.

: ; ^ ; +.

, , :

;

; Ctrl+V.

D F1 1 2 1 22 3 4 3 434 . 4.17

. , Esc.

, , *$*, , .

118

14.

, (.

- , .

/ \

1 .

V )

L

, Microsoft Word. ,

.Excel

, . ,

. .

1. MS Excel?2.

.

/ ^

MS Word MS Excel?

119

4.

15

Excel .

. , ( , ) (. 4.18). .

34

^ . , . 4.19.

1. Excel.

2. 1, 2, .

3. 2: (. 4.20).

4. 9, .

5. ' 34_.. 4.19

35

. , . 4.21. ) MS Office, . 4.21. ) .

)

. 4.21

, , .

1 2 3 4 5 7

1 2 3 4 5 ' 7

1 2 13 24 -+

. 4.20

1 2 13 24 35 4 57 8 7 8

1

1 12 '+

. 4.18

120

15.

1. .

2. 1 ( ).

3. 1, , 7.

4. ' 35_.

() . , , . , Excel . () , , . , , , (. 4.22).

34 , 1 . - , . :

1 ) 2, 4, 6,8 . . . ;2) 25, 20, 15, 10, 5 ...;3 ) 0,3; 0,5; 0,7; 0,9; 1,1 ... . :1.

, ;2. ;3.

(. 4.23);4. ()

, (. 4.24).

1 2

34

. 4.22

. 4.23

1 22 43 4 5 10 7

. 4.24

4.

. 4.25 .

. 4.25

36

. , .12345

67 910 11 12 13

0

""

""

" "

1 100 50 1502 150 75 1703 200 100 1904 250 125 2105 300 150 2306 350 175 2507 400 200 270 450 225 2909 500 250 310

10 550 275 33011 600 300 35012 650 325 370

. 4.26

1. .

2. (. 4.26). , 2:13, 02:013 2:13 .

3. , .

4. ' 36_.

15.

Excel , .

1. ?2. ?

/ ^

1. ?

2*. , ?1 1

6

,

. , ( . 4.27 2016 ).

D F G 1 J L N R S U V W X Y Z AD AF AG AJ AL1 2 1 2 3 4 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 2122 23 24 25 26 27 28 29 313 1 2 3 4 5 8 9 101112 15 16 17 18 19 22 23 24 25 26 294 1 2 3 4 5 6 7 8 9 1011 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 315 1 4 5 7 8 11 12 13 14 15 18 19 20 2122 25 26 27 28 29 1 2 3 4 5 7 8 9 10111213 14 15 16 17 18 19 2021 22 23 24 25 26 27 28 29 317 1 2 3 7 8 9 10 13 14 15 16 17 20 2122 23 24 27 28 29 8 1 2 3 4 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 2122 23 24 25 26 27 28 29 319 1 2 3 4 5 8 9 101112 15 16 17 18 19 22 23 24 25 26 29 3110 1 2 3 4 5 7 8 9 10 11 12 13 14 15 16 17 18 19 2021 22 23 24 25 26 27 28 29 11 3 4 5 7 10 1112 13 14 17 18 19 2021 24 25 26 27 28 3112 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 13 1 2 5 7 8 9 12 13 14 15 16 19 2021 22 23 26 27 28 29

. 4.27

1. .

2. .

3. ' 6_.

123

4.

16

. ( , *, /,

, . . , , . 4.2.

4.2.

+ 3

- 3* 2

/ 2

1

, - Excel =!

-: (, =12+45-9); (, =1+2); (, = SUM(A2:A5)). ,

. ,

, .

37

. MS Excel:1)25:5 + 4-2;2) 72 - 4 3;3) (30-10)

4 - 2

124

16.

1. Excel .

2. 1 Excel: =25/5+4*2. Enter. 1 13.

3. 2 : =72-4*3. 2 37.

4. : =(30-10)/(4-2). 10.

5. ' 37_.

, . . . -, , , , . -, .

, , , . , , , .

, =+2, : =; ; +; 2; Enter.

38

@ . , . 4.28, 8 .

4.

D1 S2 1 2 83 2 4 64 3 5 9

5 4 8 12 . 4.28

1. Excel .

2. . .

3. D2 : =2*2.) D2.) = .) 2.) *.) 2.) Enter.

(. 4.29).

D1 S2 1 2 8 =2*2345

2 4 6 3 5 9 4 8 12 . 4.29

4. 02 03:05, (. 4.30).

) 02.) 02

, , 05.

D1 S2 1 2 8 163 2 4 64 3 5 95 4 8 12. . 4.30

16.

5. 2 2 5 , . .

6. ' 38_.

(. 4.31).

1 2 1 2 8 16

3 2 4 6 244 3 5 9 45

5 4 8 12 96

, .

1 2 1 2 8 =2*2

3 2 4 6 =*4 3 5 9 =4*4

5 4 8 12 =5*5

. 4.32, =2*2 1 ( 2 , 2 ). 2 2 .. - (, , , ). . . 4.33 =05 , , .

=02=03=04

=5 =5 =5 = 0 5 =5 =5 =65==07=8 . 4.33

4.

39

. , - ^ ,

.

1. 36_.8 V39.xls, FILES .

2. , . 4.34.

D F

1 " "

" "

" "

2 1 100 50 150

3 2 150 75 170

4 3 200 100 190

5 4 250 125 210

6 5 300 150 230

7 6 350 175 250

S 7 400 200 270

9 3 450 225 290

10 9 500 250 310

11 10 550 275 330

12 11 600 300 350

13 12 650 325 370

. 4 .3 4

, , .

3. 2 , .

4. :13, .

5. ' 39_.

40

. , (. 4.35). , .

128

16.

1. V40.xls, FILES , 40_.

2. D5 =54.) =.) 5, 8, (

).) 4, 2, Enter.

3. .

4. , Ctrl+S.

41

. , . , (. 4.36).

12345678910 11

4,2

2,7 2,1 02

0,18 2,4 0,87

'

'

. 4.36

1. V41.xls, FILES , 41_.

2. .

3. , Ctrl+S.

129

4.

Q

- Excel =. :

+ , - , * , / , .

-: ; . , .

- ........................ ............................................ ..............................................................

1. ?2. ?3.

?4*. ?

1. , =?

2. ?

16

16.

16.1.

, , .

, .

, (. 4.37). 12 .

D F G 2 / 5 7 12 , 125| 15 3 17 38| 14 101 . 4.37

, 12 :

=125+15+3+17+38+14+101. ,

. :

=B2+C2+D2+E2+F2+G2+H2. -

. , , , .

Excel , .

, 2 * (). , (. 4.38), 2 =SUM(B2:H2).

4.

) F F 1 *

. 4.51. / . 4.51 , ,

. , . 6 7 .

18.2. :1. .2. . . - .4. .5. ( ,

, ).

.

.1. , . 4.52.

18.

3.4.

5.

2. 2:8 ( , ). .

*4 ().

: . . 1 4

(. 4.53).

, 10000

/ V / . 4.53 ,

.

. ... . (, ,), .

.

18.3.

. , , : . , . 4.54.

4.

. Excel , .

, , , , , .

- 1 - i l l iliil #]# * TiVntw

- # 0

' :

. 4.55 ,

. :

(. 4.56) .

11 77

-

.

. 4.56 .

. , .

, :

1. .2. .

18.

3. : . , .

18.4. ()

- , .

, , , , .

, . 4.67.

, 2 .

44. , . 4.58. .

. .

1 /9 ./

~ 13.0

1. .

2. . 4.59.

4.

200 1140

1040 ! 1040 1 1240 1040 00.0 00.0 00.0

20.0 0.0 . 4.59

) 1 :5.) .

^ ().

.

3. .

) , . .

) , ( , ).

) . .

. ( ).

. .

) . .

* ( ).

, , ) . . .

.

18.

.) . ( ).

( ). .

. . .

.4. . 4.60.

) 1 :5.) .

().

.5. .

) , .

) . .

1 ( ).

, .

. (. 4.61). ,

.) (

).

4.

) ( ).

6. ' 44_.

Q

. ,

; .

, , , ' Microsoft Excel.

1. ?2. ?3. ?4. . . .

18.

1*. , ?

2 \ , ?

. ?

9

. 1. 1 . 4.62. , , 15%. , . . , , , .

- 38003 23001 035 1530 ~N 230

---- 1

.

2. . 4.63. : 1) ; 2) . , , ( . ).

0

, *

1 50 35 35 124 * 20* * 13 35

. 4.63

4.

3. (. 4.64) (. 4.65).

1

2 Mersedes 10 83 Opel 8 1?4 Fiat 9 6'j Audi 4 / . 4.64

. 4.65

5. '

19 . '

, , , . , ; ; , , .

:

, , , , , , ;

, ;

, , , , , ;

(, , , ) ;

- -;

.

' , . : .

, , .

19. . '

1

4 12

. , (, , , ). . 5.1.

5.1.

3 4

3

, 3

.

5. '

, , , , ' . ^ '.

1. , , .

2. , ' .

3. .

4. .

5. , .

6. .

7. .

8. , .

9. .

10. .

11. .

12. .

13. .

14. . 5.2.

19. . '

5.2.

2

, 1

, ,

2

2

. .

3

-

, 3

, . . (, . ),

3

,

2

2

20

2

.

155

5. '

( ) . . 5.3.

5.3.

12 , 5

( )

2

(, , , , , , )

,

'

, ,

' . , , , , .

19. . '

1. .

2. .

3. , .

4. .

5. .

6. .

7. .

. ^

5. '

8. , .

9. .

10. .

11. . 5.4.

5.4.

2

2

. ( ). , ,

4

'

'

2

. '

2

,

2

2

'

2

2

20

20 .

, , , , , .

,

, , . , .

( . ) , . -.

, (, , , , ).

, :

, ;

;

. :

( ) ( , , , )

9 (1859-1952) , 88 . ^

1. -

, ( , , ).

2. . ).

160

20.

3. ( , ).

4. ( , , , ).

. , ( , ).

, .

'

1. .2. .3. (

, -, , ).4. .5. .6. .7. '.8. .9. .

Scratch, , (, , ).

1. .

: Scratch- .

2. .

, .

3. .

, . Q

- . 6.1.

. 6.1. / -

161

4. .

http://kazky.org.ua. http://www.Ienagold.ru

yandex google., png gif

.

. 6.2.

. 6.3.

5. .

Scratch, .

6. .

. 6.1. Scratch.

162

http://kazky.org.uahttp://www.Ienagold.ru

2 0 .

6.1. Scratch

1. . .

, . ,

. 2 . : ! ! 2 , . 4 .

, 2 4 ,

2.

< ~

: , , , , , , . 6

3.

164

20 .

:1111 - 0 -1 2 0 -*#? '

0 1 2 0

2 - . . '- - - - ' .-.

5 , , .

4.

/ < * *

1

, , . . ,

, : , , '!, 16

165

5.

_____________ _ -

?

6.

-

: [7\*

7.

1 V *- 5 *~'~'

1

2 0 .

8. '

- : ' . -

*- . |

2

7. .

.

1)

( ' ).2) .3) :

; (--

. , , ) ; (

, , . , +\/);

( , ).

1) ,

, , .

167

2) : .

3) , , .

8. .

, .

1) . ,

20.

3) ' .

: -;

. 6.6.

, : , , ;

Caum u

h ttp :

http://Ww% lenity oh), ru

yatu/r.x rigM gfc, *4;

. 6.7. 4

Scratch, :

169

http://Ww%25%d1%81

. 6.8. & 5

- .

'

. ^

. 6.9. 6

4) . -.

5) {, ). :

; ; ; -.

20.

/* *4

/?-* *-04*

. 6.10. 76) . , , ,

, 12.

9. . .

, . 6.2.

. )

6.2.

- 2

, 1

, ,

2

2

2

171

. (, ).

66

:- :- (, , , );- (, , , , , , , );-

2

2

43

2

40

172

2 0 .

( , , ).

( , , , , , , ).

( , (, , ), ).

IX - XI ,- ( , , , , , ).

: (, , )* ( , , , , ); ()* ( , , , , , ).

- ( , , , ' , ).

173

120 7 21 13 62

- 86- 89- 86

- () 65- () 66, 69

- 9, L7 62 82

- 82- 82- 82

141,142- 142- () M2

108 6 106 8

- 7- 7

152 51 107 142 14 83 63 35

- 32 33

- 38 - 37- 43- 43- 37- 37- 38. 40

- 44- 38- 37- - 37 - 42- 38

' 32 137 7,13 32 160

- 160- 161- 161- - 160- 161

33 53 107 107 M2 108

63 89 63 23 106

- M icrosoft Excel 106 69

38 115 113 L24 131,133

- 71- 69 - 71- 74- 74- 73

174

1. _________ ____..._........................5 ....... ................................... ............ ________________ 6

1.1. - .... ------ -----------------61. ----------- -----------------81 3 . .....---------------------10

...... ............ ............ ...... ............ ...........13

2.1. ---------------------------------------------------- 132.2. ------------- ----- -----------13

2.3. - ---------- ------------- ----- -----------172.4. ----- -------- ------------- ----- -----------182.5. .

...................................................~.......... ...... 19

. ____________________________ ____...21

3.1. --------- ----- -------------------------- ------------------------ ....213.2. ----- ...223.3. ----------------------------------------------------------------------- 233.4. ---------------------------------------------- 243.5. ---------------- 25

N*1 -. ______________ ___________ ___ __ _____ ............ _..27

2. . .. _____

4.1. ----------4.2. .......................4.3. ................4.4. . ....................4.5. .......... .........

2_.................. ........................................

.32

.32

.33

.35

.36

.37

.38

... 40

5.1. 405.2. -------------------------------------------- ----42

3----- --------------------------------------- ----------------------------- ----45

5----- ------------------ -------- ---------------------------------- ------- 46

____________ _____________ 47

( )______________________________50

6.1. ----------- 506.2. ---------------------------------------------------------- 5263 . ....---- 53

6____ 546. ----------- 55

7..---------------------------------- ------------- ---------------- -----...56 8. ------------- 59 9. ^------------------------------------------------------------- 59

_______________________________ __60

3. . ...61 --------------- ............ ............................_.62

7.1. ........................ .......................... ...........62 10........... - ..........- ............ ............... .......................- ...........64

73 . ............ ............ ...................................... . ...........65 11........... ........................ ..................................................67

______ ________________ ____________ 69

8.1. . ----- -------------- ----- ...........69 12 -------------------------------------------- ..........................72 13 --------------------------------------- ----- ..........................73

8.2. .... ... _.................... ........ . ........... . . .... ......73

16. ------------------------- -------------------------- -----...77

N>4 , ... 78

10

. ____ ________ 82

9.1. , ------------- ----- ....829.2. scratch---------------------- ----- ....82

17......... ...... ......... . .......... - ........... ................. . .......... 84 18. ......... . .......... - ........... ................. - .......... . 85

___ _____________. _____ ________...86

10.1. ....... ..................86 19...... ........ ........... .......... ........... ...... ....... 87

10.2. .......... ................. ..................88 20................... ........... ........... .......... ........... ...... ....... 90 21. .......... ...... ........... ........... ...... ....... 91 22. .......... ...... ........... ........... ...... ....... 92

N*5 ............ .......... ........... .................... .........

...____________________

.93

.95

23-------------------------------------- ----- ------------------------- 24-------------------------------------- ----- ------------------------- 25------------------------------ --------------------------------------- 26------------------------ --------------------------- ----- ----------- 27--------------------------------------------------------------------- 28. --------------------------------- ----- ----------- 29. ------------------- ----- -------------------------

N>6 ....... ......___________________ 103

_______97_______98_______ 98_______ 98_______99________ 101________102

4. ___________ ________5 ........ ........... .............106

12.1. Microsoft Excel....... ........... ............. 10612.2. -------------------------------- -------- -------- ----------- 110

....... ----- ----------------------------------------- - .......... .............. 111

_____________11313.1. ......------------- 113

31............. ............... ............... ............... ............... ..............113 32......................... ----- -------- ------------- ----- .......... ........114

13.2. ---------------------------------------------------------- ----------- 115 33_____________________________________________ 117

133. ----------------------------------------------------------- 118

_______________________________ _____ _____ ..120

34----- .............120 35--------------------------------------------------------------- .......... ..120 36... ------ .......... ..122

, .................. ................- ..........123

................. ............. .......... .................... 124

37.................... ...... ..... ....................... ..... ...... 124 38.................... ...... .............................. ...... ......125 39.................... ...... ..... ....................... ..... ...... 128 40.................... ........... .................................. ........... ...... 128 41.................... ........... ............... .................... ........... ......129

__________________________131

16.1. ---------- --------------------------- --------------------------- ---13116.2. ------------------------------------- 13216.3. --------------- -------------------------- ---133

42------------------------------------------------------------ 134_____ 43-------------------- 134

\ ...__________________ ___________ 137

. ------------------------ ----- ------------138

........... ........... ............................... ......................... 141

18.1. ......... -------------- ----- ------- 14118.2. .... ...... ................................. .......... ......... 142183. ------------------ -------- ------------------------------- 14318.4. () ... ----- -------- ----- ------- 145

44--------------------------------------------------------------------------------145

. ---------- 149

5. ' .................151

' ________________ 152

1. .................. -------- -----153 2. ----------------------------------------------------------------------------155

______ 59 ________ 159

. 174

1

7 1

* 14.01.20L5. 70100'16. . ^ \VinfX5BT. * *. . .. 14.58. . - . 58,32.

5.1 (71> .*! .1 - * .!

. . 1 ^' 4221 07.12.2011.

- , . . , 34. V*. ., 46002 1 , 0,4: .529, . 40008

(0352)52-06-07; 52-10-66; 52-05-48{$... -.'.^

Інформатика 7 клас. Казанцева О.П.

Education

Transcript of Інформатика 7 клас. Казанцева О.П.