Геометрическая прогрессия в экономике с помощью электронных таблиц MS Excel
Автор: Бутко Ольга Александровна (учитель математики и информатики, МКОУ Поповская СОШ Россошанского муниципального района Воронежской области)
Тип документа: Конспект. Аудитория: Учащиеся 9 классов. Дата публикации: 20.03.2015
Описание: Интегрированный урок математики и информатики с применением ИКТ основывается на изучении геометрической прогрессии с представлением прикладного характера в экономической сфере.

MKOY flonoBcKan COIX
l-eoruerpytt{ecKaf nporpeccul B aKoHoMhKe c
noMolJ4bp ?neKrpoHHblx ra6n4q MS Excel
l4umeepupoeauuafi ypoK no onee6pe u uuSopuromuKe c npuMeHeHueM
u n Q o p Mo t ltt o H H o- Ko M My H u Ko tttu o H H bt x m exH on oe u il
flenoBaf, urpa
I 6 Knacc
Vqrrenu MareMarur.vt t
raHQopMarilxn Eyrxo Onura
AnencaHApoBHa
[ear ypoxa:
O6yvaoqan:
- noMor{b y'{au{uMcfl qenocrHo npeAcraBhrb npnxaa4Hofi xapaKrep reomerpuuecxofi
nporpecchh B gKoHoMl4qecxofi cQepe c nprMeHeHreM hKT,
Pa3BrBa|oqxe:
- o6ecnequrb pa3Blrrhe y uxonbHhKoB yr,nenri Qoprvrynnpoaaru npo6nennu,
npeA/|ararb nYru nx peuleHhn;
- co3Aarb VcnoBuA MA pasluruf, ynaenuil atannsupoBarb npohcxoAnl4ue h3MeHeHhf, B
3KOHOMU Ke CTpa H bl, CpaBH 14BaTb, BblcKa3blBarb npeAnoroxeH rf, ;
- co4eficreoBarb pa3Bhrhrc raopvecxofi AenrenbHocrl4 B npol{ecce KoHcrpyr4poBaHhf,
MareMarhrlecxofi ruoAenr;
- coAeficreoBarb pa3Br4rl4ro y 4ereil ynnerufi ocyqecrB/trrb aAeKBarHyK, caMooqeHKy
npr eur6ope ypoBHn rpyAHocrh caMocrorre/rbuofi pa6orur, caMoaHa/rh3 yre6nofi
AeSTeIbHOCT]4
Bocnrrarea*ras:
- BocnuraHre gKoHoMt4qecxofi xynuryput yqaqxxcs.
O6opy4oearre:
MynbrxMe4hanpoeKTop, KoMnborepbr, paa4arornurfi Marepxa/t (pasHoypoexeeute sa4avu),
ra6anqa Anf, KaxAofi rpynnbt yqaqlrxcf, B g/teKrpoHHoM Bt4Ae, AeHexHbte Kynopbl (20 000
py6.), ronranxa, MoHerbr.
Xo4 ypora
l. OpraHueaurn Krlacca.
fl pueercreue. Opra rt raaqun BH uMaHllfl yqau{hxcf .
ll. Bcrynrrenuxoe cnoao vqrrenn.
- Haue 3aHflrue xorerocb 6ut naqaru c MyApblx cnoa [uqepona:
"HedOCmOmOqUO AnOdemA npeUydpOCmag' HyrnHo mqrcr1e yMemb nonog1eamaca eP"
(cnoild 1)._ Ha4erccu, pe6nra, anu tafi4enn BMecTe c BaMu noATBeplKAeHhe 3ThM CnOBaM.
- HaaepHoe, Hl/rKro 143 BaC He npeAcraBIRer ce[oAHslllHKtK) xIsHu 6es geHer. Ky4a Hr
nocMorpl,l, Be3Ae HyxHbl AeHbrr: e xaQe, B Kl4Ho, B Tearpe h r'A'
- Bonpoc: Kaxre eu4ut AeHer BaM hseecrHut?
- Oraer: Hanrqnue r 6egnaluqnute.
Pa6oma no cxeMe I (cnoild 2) .
- o6r4an cyMMa Hanhi{Hurx u 6eguaat4qHbrx AeHexHblx cpeAcrB Bcex rpaH{AaH crpaHbl
cocTaBrfeT AeHex(HyKr maccy. Ecau peqb hAer o 6esHaan.lHulx AeHbrax, ro 4aeafire
HeMHOro no3HaKoMl4Mcfl C pa6orofi coBpeMeHHblx 6aHxoe'
Coenecmuan pa6omo no cxeMe ll (cnoild 3).
flphMepxue eonpocut vqhteaR h orgetut [erefi x cxet$e ll:
- lfux ew dynaeme"'teM 3crH,lMqemcf, Ll6 Poccuu?
(oraer: Pyxoeo4ur pa6orofi KoMMepqecKrx 6aHxoa, ocyqecrBnnerAeHeXHyK' amnccrrc).
Kqxuyn ofipaeoM oH ocyq,ecmennem pyKoeodcmeo?
(Oraer: flyrena ycranoB/leHufl qragxh o6RgarerbHblx peaepeoe)'
- c t<Exoii qenbg, tl,6 ofiazyem nep4tucnnmb xaxcdafi Ko66epqecKuil 6sux qqcma
nocmynaKr,4ux x ueuY denez?
(orser: fl4n aaulrarut BMaAr{xKoB npra 6anxporcrBe KoMMepqecxrx 6aHxoe)'
l4raK, noABeAeM rror cKa3aHHoMyt [enrpaau6utfi 6anx Poccru (45) pyxoeoanr pa6oroil
BCeX KOMMepqecKhx 6aHros, Koropbte nprHuMa|oT AeHbrh y HaceneH|/|fl' 0up|t,
o6te4r,rneHufi h f.A., a raKxe BbtAapT KpeAhrbl. flo aaxouy o 6aHxax xax4utfi
KOMMepqecKhi 6aHx o6ssaH qacTb nocrynapullrx K HeMy AeHer xpaH1arb e [6, xoropuril rnnr
pacnopf,xaercn. 9ro TaK Ha3btBaeMble o6Rgareaunute pe3epBbl 6auxa. Oxr
ycTaHaBIUBapTcR KaK OnpeAeneHHblil npoqeHT OT CyMMbl BKnaAa' nocTynaK,l4ero B 6aHK'
ocranuHutr,ih AeHbraMu - ceo6o4xutltlr pe3ep8aMu - 6anx pacnopf xaeTcfl caMocTofTe/lbHo:
Moxer BbrAarb hx B KpeAur, Moxer Ha Hhx Kynurb qeHHble 6ymarra u r'4'
3aKonnqeq{BoMAeHerBcTpaHeTaKXec,reAhrt]6.oxMoXeT.yBenhquTbBelhqhHy
4exexHOi Maccbt, neqaTaF Ha cTaHKax AononHxTenbHble Kyn|opbl. Ho 6naro4apn
coepemenHofi6aHxoecxoilgrpyKrype,yBenxqxTbAeHeXHyloMaccyMoxHo,HeneqaTaf
Aono/l Ht4TenbHblx AeHer Ha craHKe'
Cero4nn
neqarafHaM npeAcTouT BblfcHurb,
AononHhTe/lbHblx Kynlop vlKaK npohcxo4vtr
He qeKaHf MOHer,yBenhqeHhe AeHelKHolZ Maccbl' He
c KaKhM noHflTheM B anre6Pe 3To
cBf3aHo h KaK MolKHo cQopnynhpoBaTb TeMy Hauero ypoKa'
Vcnoarn urPut:
- Pe6nra, fl npeglarao eam paa6rrucn na 4 rpynnbl' Kax4an rpynna 6y4er
npeAcTaBnsTbKoMMepqecKxfi6aHx.Brax4oru6arrxeeur6rapaercn4rpexrop,l
Kaccltp, ocra/lbHble - corpyAHhKl4 6anxa' fl 6y4y npe4craerareaenn 45'
B xonnnbpTepe Ha pa6oLleM cTone y Bac hMeeTcR
HaxOAt4TCf nporpaMryl3 tr3/leKTpOHHble Taflnnu'bl)),nanKa noA Ha3BaHheM 6anK, B 3TOil nanKe
KOTOpble Mbl 6ygeru c BaMh 3anonHflTb no
xoAy coBMecrHofi pa6orut (cnaild 4)'
Tq6nuqa I
Ceo6o4Hbte Pe3ePBbl
KpeAerrbr (py6)O6ngaren bH ble Pe3ePBbl
(20%l
(2ooo0-4ooo) L6000 (20000*0,2) 4ooo
(16000-3200) 12800 (16000*0,2) 3200
(L2800-2s60) LO24O (12800*0,2) 2560
(LO24O-2048) 8192 (10240* o,2l 2048
l4roro: 47232
,[,onyctuto, qro '{eroBeK A npuHec e l4Hronl6aHx 20000 py6nefi' hxxoru6aHK B KaqecrBe
o6ngareauHurx pe3epBoB orAacr tlE 4oo0 py6nefi (2o%or 20000 py6.), 3Haqhr, KpeAhroB oH
Moxer BbtAarb Ha cyMMy 16000 py6nefi r{enoBeKy 6 . Ha arr AeHbrr4 i{e.noBeK 5 npuo6peraer
y xeroropoil Qrapmu "PoBecHrK" neo6xo4Unnute eMy ToBapbl. Ilonyvexlute 15000 py6aeil
Qraprvra nepeBo4t4r e lleprvr6axx. flepn6aHx 3200 py6aefi (2O%l orqacr U6' a e KaqecrBe
cgo6oAHbtx pe3epeoB y Hero ocraHeTcfl 12800 py6., Koropble oH BblAacr B Bl4Ae KpeAura
64xeHry C. Kauenr C nprao6pen Heo6xoAl4Mbte eMy roBapbl y QnpMbl "lnopua". flonyvexnule
AeHb14 oHa nepeqhc/rur B ypan6aHx. flo raKoil )Ke cxeMe cBo6oAHbte pe3epBbt Vpan6arxa
yxoAnr B KoMMepq6aHK.
Burqncnrrra cyMMapHbtfi o6beM KpeAhroB, BbrAaHHbrx paccMarpxBaeMofi cxcreMofi 6artxoa.
A4R arorO AOCTaTOqHO C/toXt4Tb qhc.na, CTofllque B npaBoM cror6qe Ta6n. l. llOny,rennan
cyMMa cocTaBw 47232 py6nt, T.e. Ha raKyp cyMMy yBenxqu.flacb AeHexHaR Macca cTpaHbl, lr
3aMerbre, He nph6eran K neqaTHoMy cTaHKy.
A ecnu e cucmeMe 6ydem ne 4 6auxa, o 50, unu n-oe Konw4ecmeo, mo KoK 6btmb e ?moM
CnY'lOe?
Coctagnexre MareMarttqecKofi MoAerttt.
Burnuurenn cBo6oAHbte pe3epBbt - KpeArru (cnaild 5/: 16000; t28OO; 7O24O; 8792; ...
- llonytunu nocreAoBare/tbHocrb qucer. flaaafire BblflcHl4M, 6y4er nt 3ra
nocneAoBare/tbHocrb rBltflTbcn apraQnnernr{ecKofi wn4 reoMerphr{ecxofi nporpeccueia.
- Vvau4necn caMocrof,TenbHo Aenaor BblBoAbl tt Qopmynrpyor reMy ypoKa:
"feoMerpugecKafl nporpeccun B 3KoHoM14Ke" (cnoild 6)'
- 3anncuteaor B TerpaAh..
- Hana h3BecrHa Qopruyna AnR Haxox4eHur cyMMbr KoHeqHoro qxcna nepBblx q/leHoB
reoMerprqecKofi nporpecoa n (cnaild 7).
- fl,aaafire npoBepuM no erofi Qoprvryae Hau orBer (47232 p.) (cnafig 8).
- Taxrrvr O6paaOm, Mbt MOlxeM yCKOpl4Tb Onepaqhp nOACt{eTa CyMMbl BblAaHHblX
KpeAhroB.
V. 3axpenaexre. CamocronrenuxaR pa6ora (c nocneavpqef, cawronposepxofi).
YvaqurracR npeA.nafaercn 3 paanoypoeneoble 3aAat{h (na or.leHxy "3", "4" A Ha "5" (anild 9ll.
HeO6xoAumO eut6paru oAHy 143 3rl4x 3aAaq h peuhrb ee, Icno/lb3yn AaHHylo Qoptuyny npu
STOM COCTa BnfrA pacqer B 3neKTpOHHblX n6nhLlax
3a4ava 1. l4meercR ct4greMa, cocTof,l4afl uz 2 6anxoe Ct n C2, Ceo6o4Hure peeepeut 6arxa
C1 cocraeanlor 85000 py6aefi, a o6nlareabHbre pe3epBbt, ycraHoB/lernute LleurparbHblM
6axxonn - LO%. Burqrcanru Benuqr4Hy KpeAhroB, Koropbte BMecre Moryr npeAocraBurb
6auxnCLuC2.
3a4a,ra 2. ChcreMa cocrohr h3 rpex 6axxoe AL, A2, A3. B nepeulfi 6anx A1 BHeceH BMaA
4000 py6nefi. flpoqenrHaf, craBKa o6fl3are.nbHbrx pe3epBoB cocraBrfler 25%. Kaxoea
MaKchManbHafl cyMMa KpeAhToB, KoTopylo Molxer BblAaTb 3Ta chcreMa?
3a4ava 3. B 6anx 81 crqrenaul KoMmepqecKllx 6aHroe BHeceH BMaA B pa3Mepe 100 0004o4.
O6naareaunure pe3epBbt, ycraHoB/reHHbre l-leHTpanbHbrM 6aHKoM, cocra Brnrclr 2O%o. Cxonaxo
6aHxoa B orofi cxcreM e, eclu oHh npeAocra Bunvl KpeAuroB Ha cyMMy 236 160 4or?
f'f poeepxa caruocronrenuxofi pa6orul (cnoild 10).
3a4ava t.
Oreer: L61500 p.
3a4ava 2.
Oreer: 6937,5 p.
3a4,aua 3.
Oreer: 4 6aHxa.
Vl. Iloruauxee aaaante.
B raqecrae hHAxBl4AyanbHoro 3aAaHufl Ha AoM Kax{4oMy yqeHtaKy npeAlaraercn:
y' npraAymaru chcreMy, cocrofll4ylo u3 nArvt 6axxoe;
y' HasHa,.rnru cyMMy, nocrynlrBuylo a nepaurfi 6axr cucrenaut;
y' HagHaqutu npoqeHTHyo craexy o6naarenbHblx pe3epBoB;
y' aarquutntusn - cyrrntuapny]o Benilqr4Hy KpeAuroB, KoTopble Moxer npe4loxurU Bauta
chcreMa 6aHxoe.
Vll. floaeeaerre rroroe. OueHraaxre.
Bonpoc yqxrern: Kaxrrrn o6parona npro6pereHHbre 3HaHrf, no MareMarl4xe naoryr 6utru
ucno/rb3oBaHbr 4rlf, peueHxf, Bar(Hblx 3aAaq coBpeMenHoft oxoxotunxu?
(OrAer: OxaSUteaetCR, qTO TaKlte, ra nepeutfi ASrAn4 6eCnOle3Hble Bonpocbl, KaK q,neHbl
reoMerphqecxofi nporpecoax x cyMMa nepBbrx t{/reHoB reoMerphqecKofi nporpeccu14, l,tMeor
ray6oxrafi aKoHoM14t{ecKuil ovrurca).
Bonpoc: Kax su cqrraere, npaB nn6un [ra4epon? (
Oreer: ,Q,a, He4ocraroqHo npocro 3Harb, HyxHo yMerb ncnonb3oBaru ranQoprvrar4raro).
Cnaoa6o 3a ypox!