метод указания информатика
.pdf2003
Hacrb1
VISUALBASIC
M3MKnPOrPAMMHPOBAmDI
TABJIIWHtlHIIPOUECCOPEXCELH
|
|
420015,KaaaHt,MapKca,.K |
|
|
|
xexHOJionr-iecKoro |
|
|
|
na6opaxopna |
|
M3Aaxej]tcxBOKajaHCKororocy^apcxBeHHoroxexHojioriRecKoro |
|||
«C»i |
3aKa3$ |
Tupaac200.3K3 |
3,5.yq-.H3flji |
.Ji.neH.ycn |
3,25 |
Ileuaxb.R1SO |
ByMara.riHcnaa |
OopMax60x84.1/16 |
.200^.5,t?/ |
Bne«iaTS |
|
|
|
Ka020404OT97.03.6.r |
|
KoppeKmop.R.K)Cmpbixapb
lUuzunypoea.fl.r CMUptioea.A.M IIoHKpamoaa.A.C Cocmaeumejiu:KoiuKiina.IO.JI
VISUALBASIC
H>13tIKIlI'OrPAMMHPOBAHIiH
TAEJHPfflUttUPOIJECCOPEXCEL
rocyAapcrBeHHtmTexHononiHecKiiiiyHHBepcHTer POCCHHCKOH
55
54 |
|
COHCOK |
|
|
|
|
KoHTpojibHaapaGoxa |
|
|
42 |
|
|
.3.7MaccHBbi |
|
|
|
.2.7UHKJIcYCJIOBHCM |
|
|
37 |
|
|
1.7 |
|
|
LJ,HKJIHMeCKHeBblMHCJICHUfl |
.7 |
||
|
.6Pa3BeTBJT3ioiMHecdBbiHHCJiHTejibHbienpoueccbi |
|||
|
|
|
|
5 |
|
npoueccbi_ |
|
JlMHCHHbie |
4 |
26 |
|
.312,CraHAapTHbie |
|
|
26 |
|
pesyjibxaroB |
.311.BbiBOfl |
|
24 |
|
|
.10.3 |
|
24 |
HMCHBVisualBasic |
.9.3npaBHJianpMCBOCHHfl |
|
|
24. |
|
.8.3npHOpnTeronepauHH |
|
|
23 |
.7.3O6jiaCTHBHflMMOCTHnepCMCHHblXHKOHCTaHT_ |
|
||
23 |
.6.3O6"baBJieHHenepeMCHHbix |
|
||
|
|
.5.3THHflaHHbix |
|
|
|
4.3riepeMeHHbieHKoncraHTbi |
|
||
|
.3.3OpraHH3auHsinporpaMMbiHaasbiKeExcelVisualBasic |
|
||
|
.2.3flpHHUHnbl06-beKTHO-OpHeHTHpOBaHHOrOnporpaMMHpOBaHHH |
|
||
|
|
|
.1.3Maicpocbi |
|
|
.ExcelHasbiKnporpaMMHpoBaHHflVisualBasic_ |
|||
|
|
.2.2HOHCKpeuieHHa |
|
|
|
iHHHeHHoronporpaMMHpOBaHHa |
.PeineHHC: |
||
|
|
.10.1MaTpHMHbie< |
|
|
|
.9.1Hpoue^ypaFIojiGopnapaMexpa_ |
|
||
|
|
|
.8.1 |
|
|
|
.7.1IlocTpoeHHeAHarpaMM |
|
|
|
.6.1HcnOJlb30BaHH6CTaH/iapTHUX |
|
||
|
.5.1BbiMHCJieHHJiB3JieKTpoHHOHTaSiiHueMicrosoft.Excel |
|
||
|
Ta6jlHUbI |
HM6H |
.4.1 |
|
|
|
|
.3.1 |
|
|
|
|
1.2.OopMaT |
|
|
I.I.OcHOBHbienoHHTHaMicrosoftExcel |
|
||
|
Pa6oTacTaGiiHHHbiMnpoueccopoiuMicrosoft.Excel |
|
KJIHHOB.B.
no |
|
|
|
|
|
|
|
|
|
|
|
|
xnMiinecKOHKn6epHerHKH. |
naxafysjipQ |
|
|
|||||||
|
cneuMajibHocrflM, |
|
TexHO/ioraHecKMM |
no |
|
||||||
AHCBHOH |
H |
saoHHofi |
apia.cryAeHTOB |
CHbi |
|
|
|||||
|
|
|
|
Excel,aTaiotceco3A3HHeMaKpocoB,AHanoroB. |
|||||||
nporpaMMiipoBaHwaVisualBasic,BcrpoeHHoroBaneicrpoHHyi-o |
|||||||||||
aa |
nporpaMM |
cosAaniui |
Bonpocbi |
PaccMorpeHbi |
|
||||||
saicpeiinejHm. |
MiipaicTHHCCiaix3aAaeiMHAnaero |
IHCJIOMMJijiiocipauiii'-i |
L |
||||||||
|
|||||||||||
GOJTMIIHM |
conpOBO5KAaerui |
Marepnan |
TeoperH^ecKHH |
|
|||||||
BcpeAe.Excel |
pa6orbi |
npraeMhi |
KparKOonucaHbiocHOBHfaie |
|
|||||||
|
|
|
|
|
56c. |
KouiKHHa.JL1OHAP-.Kasans,2003 |
|||||
.TCXHOJIyn-r;:.Cocr |
roc. |
.yKaaaiiHH1/.HKasaa |
VisualBasic:MCTOA. |
||||||||
nporpaMMiipoBauHH |
nabiic |
u |
Excel |
nponteccop |
|
|
accHcr..H.FLUarwHypoBa
.CTnpen..A.MCMHpHosa
Aou..A.CIIoHKpaTOBa
CocraBirranH:accHcr..JIIOKouiKHHa
- |
Office |
BnaracaxProgramFiles-Microsoft |
o6bmHOiiaxoAHTCfl |
|
.Office |
- |
exceLexe |
||||
- |
Excel |
-MicrosoftExcelOSHJInporpaMMbi |
KOMaHAbiIlycK-llpoipiiMMbi |
noMombk) |
MCHIOWindowsc |
3anycKExcelocymecrBjiaercanepe3TjiaBHoe |
||||||||||
6jiaroAapfl |
npegeHrauHH |
H |
AOKjiaAU |
BbicrynjieHHa, |
.10noAroraanHBaTb |
|||||||
|
|
|
|
|
|
|
|
|
4>HJBiaJ10B.(J)HpM) |
|
||
o6beAHHarb |
CBSSH(nanpHMep, |
MHorora6jifmHi>ie |
OcyiuecTBJiarb |
.9 |
||||||||
|
|
|
|
|
|
|
|
|
HpHJlOMCeHHHX,H.TIL |
|
||
HanpHMepBcraBJwn,TCKCT,pHcyHKH,raojiHUbi,noAixrroBJieHHbieB |
|
|||||||||||
OcymecmjiaTbHMnopr-,.aKcnopro6M6HAaHHbiMHcapyniMHnporpaMMaMH, |
.8 |
|||||||||||
|
.Office |
pncyHKHcnoMombiorpafJiHHecKoropeAaicropaMicrosoft |
|
|||||||||
|
BBOflHTbHpeAaKTHpOBaTbTCKCTbl,K3KBTCKCTOBOMnpOACCCOpe, |
.7 |
||||||||||
|
HanumHonpeAcraBJWTbAaHHbieBBH#eAnarpaMM.Hrpa^HKOB |
.6 |
||||||||||
TaojiHujbL,cKpbiBarb(npjrrarb)i})parMeHTbiTa6jmubiHJIHBOO.TaGjumy |
|
|||||||||||
HJIHycraHaanHBai-bsammyHCKoropbix(HJIHBCCX) |
BsoAwrbnapojm |
.5 |
||||||||||
|
|
|
|
|
|
(|)HJTbTpaUHK)(OTDOp)H3HanH3.AaHHfclX |
|
|||||
copnipoBKy, |
HOHCK, |
BBOA, |
Aaimbix- |
6a3bi |
4)yHiapn |
PeajiH30Ban> |
.4 |
|||||
|
|
|
|
(nOAAepatKynpHHflTHflpemeHHH)H.onTHMH3au3HK) |
|
|||||||
nporH03HpoB3Hne |
ocymecrBJiirrb |
craTHCTiwecKHHananns, |
.ripoBOAmi |
3. |
||||||||
|
.3KcnepHMeH0ipOBaHHe(^TO6yAer,ecjm?KaKCAenan,,.Hro6bi?) |
|
||||||||||
HHcneHJioe |
H |
MOAeJiHposaHHe |
MareMarHHecKoe |
OcymecTBJWTb |
.2 |
|||||||
.n |
H,pa6orarbcMarpHiiaMHHKOMnneKCHbiMHMHcnaMHHT. |
|
||||||||||
,crpown>rpa4»HKH4)yHKUHH(nanpHMep,sin,cos,tgHAp-)*peiuarb |
|
|||||||||||
MHccjieAOBarb |
|
i |
|
|
|
|
|
|
|
|
|
|
KaKo6bmHbiHKajibKyjurrop),BbmncnffTb3HaieHHa |
|
|||||||||||
PeiiiarbMareManwecKHesaAa^H:BbmojiHarbraSjnwHbjeBLWHcneHHa(BTOM |
1. |
|||||||||||
|
|
|
|
|
|
TaSjiHiHbiHnpou,eccopExcelno3BOJiaer: |
|
|||||
|
H3M6HeHHH3HaH6HHaJIK)6orOKOMOOHeHra.TaOJIHLUbl |
3aBHCHMOCXaMH,npH |
||||||||||
4>opMyjibHbiMH |
cBsoanHbix |
Aawibix, |
scex |
nepecMera |
aBTOMarHHecKOro |
|||||||
B03M03KHOCTbMrHOBCHHOrO |
FjjaBHOeAOCTOHHCTBO3JieKlpOHHOHTaSjIHUbl- |
|
||||||||||
< |
6birbsanwcaHbiAaHHbiepauiHHHbixTWIOB:TCKCT,Aarbi,4ncna,<j)opMyjibi, |
|||||||||||
AJIHnpocJieccHOHanbHOHpa6orbic.aaHHbiMH.BflHemcax(KiieTKax)Ta6jrnuwMOiyr |
||||||||||||
|
cawiaspacnpocrpaHeHHaaHMomwaa |
3jie(crpOHHa3TaSjiHua- |
|
|||||||||
|
|
|
|
|
|
Ho6pa6OTKH3JieKrpOHHbIX.Ta6^H^ |
|
|||||
npeAHasaaqeRHbix |
nporpawM, |
KOMnneKC |
~ |
npoqeccop |
Ta&nuwbiu |
|
||||||
|
-4>opMaopraHH3auHMAaHUbtxnocronSuaMH.crpoKaM |
|
||||||||||
|
.1PaSoTacTa6jiHHHUMnpoueccopoiwMicrosoftExcel |
|
54
|
|
|
|
|
|
|
|
|
|
|
|
|
|
.c |
-AS |
.2001 |
|
KaaaHb, |
AiccsHOBaHAp-- |
.B.A |
KFTY;COCT. |
.yKaa/ |
Excel2000:MBTOA. |
.7 |
|||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
OHTep,.2001-640C.:HJI |
|
||||
CHMOHOBHMH.Ap-:.Cn6 |
.B.C |
HH(t>opMaTHKa:BaaoBbiHKypc/FIoApe^. |
.6 |
||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
CTaTHCTHKa,.2001-256c. |
|
|||||
H |
OwHaucw |
:.M |
.nepepa6- |
,.MSA |
3-e |
-- |
.MaKapoBOH |
B.H. |
peA- |
|
|||||||
MH(j)opMaTHKa:OpatcrHKyMnoxexHouorHHpa6oTbiHaKOMnbKxrepe/OOA |
.5 |
||||||||||||||||
|
|
|
|
|
|
|
|
|
-.768c |
<t>HH3HCbincraTHcTHKa,.1997 |
|
||||||
:.M |
.MaKapoBOH-- |
B.H. |
.npocj) |
peA- |
OOA |
YneSHHK/ |
HH(J)opMaTHKa: |
.4 |
|||||||||
|
|
|
|
|
|
|
|
|
|
|
|
craTHcTHKa,.2002-272c, |
|
||||
H |
OwnaHCbi |
:.M |
- |
.noco6ne |
VHe6Hoe |
Excel: |
Word, |
Windows, |
|
||||||||
PaGoTaB |
.«HH(J)opMaTHKa» |
Kypcy |
no |
IlpaKTHKyw |
.T.B |
EespyMKo |
.3 |
||||||||||
|
|
.KasaHb,2001-48c, |
C,.AnoHKpaToea,A..CCHPOTKHHHAP- |
|
|||||||||||||
|
KFTY;;.COCT |
nporpawMHpoBaHHeBcpe^eExcel:MeroA-yKasaHHa/ |
.2 |
||||||||||||||
|
.Ka3aHb,2001-28.c |
.COCT:C..AnoHKparoBa,A..CCI-IPOTKHHnAp. |
|
||||||||||||||
/KITTY; |
yKajaHHfl |
.MCTOA |
BExcel: |
ManpocoBHAHajioroB |
CosAaHHe |
.1 |
J |
|
s |
|
s |
|
e; |
|
o |
|
U>opiviaT HHCCK |
AitTO tano |
fl1 C
|
o |
|
|
|
|
|
|
|
|
|
|
J2 |
cd' |
|
|
|
|
|
C w |
|
J5- |
S |
|
|
|
|
> |
|
o |
|
|
|
|
|
|
|
|
|
\ |
t^- |
o |
|
|
|
|
°° |
||
cd |
p |
|
o |
|
|
|
— |
^ |
(0 |
p* |
|
|
|
<3 |
|
c |
|
|
|
|
5 |
5" " |
|
|
|
||
" |
S |
03 |
|
|
|
|
™ |
O |
o |
|
|
||
s |
-° |
3: |
|
|
||
m |
E5 |
|
|
|||
bHO |
|
|
o |
g |
|
|
|
|
'S |
i |
|
|
w c
sg d"
|
u- 5 |
I |
r-~ |
|
«
V
V s
5
E
«
=? w
*9
K'-e-
r-i
TT
CN o
&
I
s s V s K 4) o A u s CL,
H
ea K
" cL
. s.
|
o |
|
a. |
|
F |
|
o |
|
Cf |
§ |
|
to |
|
o |
|
o |
O |
g |
Su |
i |
K |
|
§ |
Q. |
s |
Cu |
|
C |
m 5 |
O |
|
|
CN |
t> o
O
G,
C
O
U
X
C-- o
o |
d: |
+= |
*f |
o! |
*— |
« |
"_ |
o a
H
X
> |
II |
X |
|
>o |
|||
rn |
> |
||
O |
|
> "
si > O O"
X X
7 CN- Q^ II
2<£
+M
p.
^?
o"
II=
&
|
|
|
|
X |
|
|
|
|
|
r~; |
II |
|
|
|
|
o |
|
|
|
|
|
N~ |
|
|
|
o |
> |
N= |
|
|
|
i |
<5C |
||
= |
o |
I |
iK |
||
w |
= o |
|
|
||
N |
|] |
> |
If |
|
|
|
N~ |
|
|
|
|
|
to" |
|
|
|
|
|
O |
|
|
|
|
CS
VI
VI fN (N
A
io
«B
£
s CL
a
V |
X |
S3 |
a |
|
A |
V |
|
|
V |
||
|
JD |
-0 |
|
o |
|
X |
|
|
Al |
T |
|
A |
|
CN |
|
X |
|
>^ |
|
|
A |
|
|
|
|
|
£P
+
|
X |
|
?S |
|
|
'c/i |
|
|
V! |
Al |
|
^ |
||
|
+ |
JO |
|
nj |
|
|
S |
|
r- |
r'x x" |
|
+ |
+ c |
|
X |
« |
'^ |
«J |
[^ |
f |
+ |
X |
|
too |
||
|
X |
4-> |
|
50 |
1 |
|
e |
"Jb |
|
« |
~~~f>- |
4 |
|