|
|
| (9 промежуточных версий не показаны.) |
| Строка 1: |
Строка 1: |
| | + | <metakeywords>Информатика, класc, урок, на тему, 11 класc, Компьютерный практикум, Работа 7, Реализация сложных запросов, выборка, MS Access, конструктор</metakeywords> |
| | + | |
| | '''[[Гипермаркет знаний - первый в мире!|Гипермаркет знаний]]>>[[Информатика|Информатика]]>>[[Информатика 11 класс|Информатика 11 класс]]>>Информатика: Компьютерный практикум: Работа 7. Реализация сложных запросов''' | | '''[[Гипермаркет знаний - первый в мире!|Гипермаркет знаний]]>>[[Информатика|Информатика]]>>[[Информатика 11 класс|Информатика 11 класс]]>>Информатика: Компьютерный практикум: Работа 7. Реализация сложных запросов''' |
| | | | |
| - | <br> '''<metakeywords>Компьютерный практикум: Работа 7. Реализация сложных запросов</metakeywords>''' <br> | + | <br> '''Компьютерный практикум'''<br><br>'''Работа 7. Реализация сложных запросов'''<br><br><u>Цели работы:</u> |
| | | | |
| - | <meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 11" name="Generator"></meta><meta content="Microsoft Word 11" name="Originator"></meta><link href="file:///C:\Temp\msohtml1\01\clip_filelist.xml" rel="File-List"></link><!--[if gte mso 9]><xml>
| + | • закрепление навыков до созданию и заполнению таблиц;<br> |
| - | <w:WordDocument>
| + | |
| - | <w:View>Normal</w:View>
| + | |
| - | <w:Zoom>0</w:Zoom>
| + | |
| - | <w:PunctuationKerning/>
| + | |
| - | <w:ValidateAgainstSchemas/>
| + | |
| - | <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
| + | |
| - | <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
| + | |
| - | <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
| + | |
| - | <w:Compatibility>
| + | |
| - | <w:BreakWrappedTables/>
| + | |
| - | <w:SnapToGridInCell/>
| + | |
| - | <w:WrapTextWithPunct/>
| + | |
| - | <w:UseAsianBreakRules/>
| + | |
| - | <w:DontGrowAutofit/>
| + | |
| - | </w:Compatibility>
| + | |
| - | <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
| + | |
| - | </w:WordDocument>
| + | |
| - | </xml><![endif]--><!--[if gte mso 9]><xml>
| + | |
| - | <w:LatentStyles DefLockedState="false" LatentStyleCount="156">
| + | |
| - | </w:LatentStyles>
| + | |
| - | </xml><![endif]--><style><!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:204; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:1627421319 -2147483648 8 0 66047 0;} @font-face {font-family:"MS Reference Sans Serif"; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:204; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:536871559 0 0 0 415 0;} @font-face {font-family:"Bookman Old Style"; panose-1:2 5 6 4 5 5 5 2 2 4; mso-font-charset:204; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:647 0 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style3, li.Style3, div.Style3 {mso-style-name:Style3; margin:0cm; margin-bottom:.0001pt; text-align:right; line-height:13.8pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style10, li.Style10, div.Style10 {mso-style-name:Style10; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style25, li.Style25, div.Style25 {mso-style-name:Style25; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:21.6pt; line-height:17.5pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style92, li.Style92, div.Style92 {mso-style-name:Style92; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style112, li.Style112, div.Style112 {mso-style-name:Style112; margin:0cm; margin-bottom:.0001pt; text-align:justify; line-height:15.85pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style113, li.Style113, div.Style113 {mso-style-name:Style113; margin:0cm; margin-bottom:.0001pt; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style121, li.Style121, div.Style121 {mso-style-name:Style121; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style122, li.Style122, div.Style122 {mso-style-name:Style122; margin:0cm; margin-bottom:.0001pt; text-align:justify; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style124, li.Style124, div.Style124 {mso-style-name:Style124; margin:0cm; margin-bottom:.0001pt; text-align:justify; line-height:17.6pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style125, li.Style125, div.Style125 {mso-style-name:Style125; margin:0cm; margin-bottom:.0001pt; text-indent:-16.85pt; line-height:17.6pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style126, li.Style126, div.Style126 {mso-style-name:Style126; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style127, li.Style127, div.Style127 {mso-style-name:Style127; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:22.2pt; line-height:16.1pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style128, li.Style128, div.Style128 {mso-style-name:Style128; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:-22.2pt; line-height:18.75pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style132, li.Style132, div.Style132 {mso-style-name:Style132; margin:0cm; margin-bottom:.0001pt; text-align:center; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} p.Style135, li.Style135, div.Style135 {mso-style-name:Style135; margin:0cm; margin-bottom:.0001pt; text-align:justify; text-indent:-15.7pt; line-height:17.45pt; mso-line-height-rule:exactly; mso-pagination:none; mso-layout-grid-align:none; text-autospace:none; font-size:12.0pt; font-family:"Bookman Old Style"; mso-fareast-font-family:"Times New Roman"; mso-bidi-font-family:"Times New Roman";} span.FontStyle294 {mso-style-name:"Font Style294"; mso-ansi-font-size:15.0pt; mso-bidi-font-size:15.0pt; font-family:"MS Reference Sans Serif"; mso-ascii-font-family:"MS Reference Sans Serif"; mso-hansi-font-family:"MS Reference Sans Serif"; mso-bidi-font-family:"MS Reference Sans Serif"; letter-spacing:.5pt; font-style:italic;} span.FontStyle299 {mso-style-name:"Font Style299"; mso-ansi-font-size:16.0pt; mso-bidi-font-size:16.0pt; font-family:"MS Reference Sans Serif"; mso-ascii-font-family:"MS Reference Sans Serif"; mso-hansi-font-family:"MS Reference Sans Serif"; mso-bidi-font-family:"MS Reference Sans Serif";} span.FontStyle314 {mso-style-name:"Font Style314"; mso-ansi-font-size:18.0pt; mso-bidi-font-size:18.0pt; font-family:Tahoma; mso-ascii-font-family:Tahoma; mso-hansi-font-family:Tahoma; mso-bidi-font-family:Tahoma; letter-spacing:-.5pt; font-weight:bold;} span.FontStyle320 {mso-style-name:"Font Style320"; mso-ansi-font-size:13.0pt; mso-bidi-font-size:13.0pt; font-family:"MS Reference Sans Serif"; mso-ascii-font-family:"MS Reference Sans Serif"; mso-hansi-font-family:"MS Reference Sans Serif"; mso-bidi-font-family:"MS Reference Sans Serif"; letter-spacing:-1.0pt; font-weight:bold;} span.FontStyle331 {mso-style-name:"Font Style331"; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; font-weight:bold;} span.FontStyle336 {mso-style-name:"Font Style336"; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; font-weight:bold;} span.FontStyle340 {mso-style-name:"Font Style340"; mso-ansi-font-size:16.0pt; mso-bidi-font-size:16.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style";} span.FontStyle343 {mso-style-name:"Font Style343"; mso-ansi-font-size:14.0pt; mso-bidi-font-size:14.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; letter-spacing:-.5pt; font-weight:bold;} span.FontStyle345 {mso-style-name:"Font Style345"; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:"Bookman Old Style"; mso-ascii-font-family:"Bookman Old Style"; mso-hansi-font-family:"Bookman Old Style"; mso-bidi-font-family:"Bookman Old Style"; font-weight:bold;} @page Section1 {size:841.85pt 1190.5pt; margin:298.7pt 172.8pt 72.0pt 208.8pt; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} @page Section2 {size:612.0pt 792.0pt; margin:2.0cm 42.5pt 2.0cm 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section2 {page:Section2;} /* List Definitions */ @list l0 {mso-list-id:-2; mso-list-type:simple; mso-list-template-ids:1946826162;} @list l0:level1 {mso-level-start-at:0; mso-level-number-format:bullet; mso-level-text:*; mso-level-tab-stop:none; mso-level-number-position:left; margin-left:0cm; text-indent:0cm;} @list l1 {mso-list-id:1112213927; mso-list-type:simple; mso-list-template-ids:-336688602;} @list l1:level1 {mso-level-text:"%1\)"; mso-level-tab-stop:none; mso-level-number-position:left; mso-level-legacy:yes; mso-level-legacy-indent:22.2pt; mso-level-legacy-space:0cm; margin-left:0cm; text-indent:0cm; font-family:"Bookman Old Style";} @list l0:level1 lfo1 {mso-level-start-at:65535; mso-level-numbering:continue; mso-level-text:•; mso-level-tab-stop:none; mso-level-number-position:left; mso-level-legacy:yes; mso-level-legacy-indent:15.7pt; mso-level-legacy-space:0cm; margin-left:0cm; text-indent:0cm; font-family:"Bookman Old Style";} @list l0:level1 lfo2 {mso-level-start-at:65535; mso-level-numbering:continue; mso-level-text:•; mso-level-tab-stop:none; mso-level-number-position:left; mso-level-legacy:yes; mso-level-legacy-indent:16.85pt; mso-level-legacy-space:0cm; margin-left:0cm; text-indent:0cm; font-family:"Bookman Old Style";} ol {margin-bottom:0cm;} ul {margin-bottom:0cm;} --> </style><!--[if gte mso 10]>
| + | |
| - | <style>
| + | |
| - | /* Style Definitions */
| + | |
| - | table.MsoNormalTable
| + | |
| - | {mso-style-name:"Обычная таблица";
| + | |
| - | mso-tstyle-rowband-size:0;
| + | |
| - | mso-tstyle-colband-size:0;
| + | |
| - | mso-style-noshow:yes;
| + | |
| - | mso-style-parent:"";
| + | |
| - | mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
| + | |
| - | mso-para-margin:0cm;
| + | |
| - | mso-para-margin-bottom:.0001pt;
| + | |
| - | mso-pagination:widow-orphan;
| + | |
| - | font-size:10.0pt;
| + | |
| - | font-family:"Times New Roman";
| + | |
| - | mso-ansi-language:#0400;
| + | |
| - | mso-fareast-language:#0400;
| + | |
| - | mso-bidi-language:#0400;}
| + | |
| - | </style>
| + | |
| - | <![endif]--> <div class="Section1">
| + | |
| - | '''<span class="FontStyle314"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">Компьютерный практикум</span></span>'''<span style="font-size: 11pt; font-family: "Times New Roman";"><o:p>
| + | |
| - | </o:p></span>
| + | |
| | | | |
| - | <span style="font-size: 11pt; font-family: "Times New Roman";"><o:p> </o:p></span>
| + | • отработка приемов реализации сложных запросов на '''[[Компьютерный практикум :Работа 5. Реализация простых запросов на выборку|выборку]]'''; |
| | | | |
| - | <span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">Работа</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | • обучение реализации запросов на удаление, а также использованию вычисляемых полей в запросах. |
| - | </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">7.</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">Реализация</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">сложных</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">запросов<o:p></o:p></span></span>
| + | |
| | | | |
| - | <span style="font-size: 11pt; font-family: "Times New Roman";"><o:p> </o:p></span> | + | <u>Используемые программные средства</u>: '''[[СУБД MS Access|MS Access]]'''<br><br>'''Задание 1''' |
| | | | |
| - | <span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">Цели работы</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">:</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | Создать таблицу «Оценки» и ввести в нее данные, представленные в теме 19 в табл. 1.11. |
| | | | |
| - | ''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style=""> •<span style="font: 7pt "Times New Roman";">
| + | <br>'''Задание 2''' |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">закрепление</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | <span style="letter-spacing: -0.5pt;">навыков</span> <span style="letter-spacing: -0.5pt;">до</span> <span style="letter-spacing: -0.5pt;">созданию</span> <span style="letter-spacing: -0.5pt;">и</span> <span style="letter-spacing: -0.5pt;">заполнению</span> <span style="letter-spacing: -0.5pt;">таблиц;</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| | | | |
| - | ''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style=""> •<span style="font: 7pt "Times New Roman";"> | + | Используя '''[[Конструктор запросов в MS Access|конструктор]]''' запросов MS Access, выполнить все запросы, описанные в теме 20<br><br>'''Задание 3''' |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">отработка</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | <span style="letter-spacing: -0.5pt;">приемов</span> <span style="letter-spacing: -0.5pt;">реализации</span> <span style="letter-spacing: -0.5pt;">сложных</span> <span style="letter-spacing: -0.5pt;">запросов</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">выборку;</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| | | | |
| - | ''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style=""> •<span style="font: 7pt "Times New Roman";">
| + | 1) получить таблицу, содержащую фамилии абитуриентов и средние значения оценок, полученных на экзаменах; |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">обучение</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | <span style="letter-spacing: -0.5pt;">реализации</span> <span style="letter-spacing: -0.5pt;">запросов</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">удаление,</span> <span style="letter-spacing: -0.5pt;">а</span> <span style="letter-spacing: -0.5pt;">также</span> <span style="letter-spacing: -0.5pt;">использованию</span> <span style="letter-spacing: -0.5pt;">вычисляемых</span> <span style="letter-spacing: -0.5pt;">полей</span> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">запросах. Используемые</span> <span style="letter-spacing: -0.5pt;">программные</span> <span style="letter-spacing: -0.5pt;">средства:</span></span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">MS</span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman";"> <span style="letter-spacing: -0.5pt;">Access</span></span></span>''
| + | |
| | | | |
| | + | 2) получить список лишь тех абитуриентов, у которых оценка за первый экзамен больше среднего балла за все экзамены; |
| | | | |
| | + | 3) предположим, что действует следующее правило: на экономический факультет [http://xvatit.com/vuzi/ '''университета'''] |
| | | | |
| - | ''<span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;" /></span></span>''''<span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;" /></span></span><span class="FontStyle340" />''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;"><o:p></o:p></span></span> | + | ''<br> <br>Семакин И.Г., Хеннер Е.К., Информатика и ИКТ, 11'' |
| - | | + | |
| - | '''<span class="FontStyle320"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">Задание 1</span></span>'''<span class="FontStyle320"
| + | |
| - | | + | |
| - | '''''<span style="font-size: 11pt; font-family: "Times New Roman";" />'''''
| + | |
| - | | + | |
| - | ''<span style="font-size: 11pt; font-family: "Times New Roman";"><o:p> </o:p></span>''<span style="font-size: 11pt; font-family: "Times New Roman";"><o:p></o:p></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">Создать</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"> <span style="letter-spacing: -0.5pt;">таблицу</span> <span style="letter-spacing: -0.5pt;">«Оценки»</span> <span style="letter-spacing: -0.5pt;">и</span> <span style="letter-spacing: -0.5pt;">ввести</span> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">нее</span> <span style="letter-spacing: -0.5pt;">данные,</span> <span style="letter-spacing: -0.5pt;">представленные</span> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">теме 19</span></span></span><span class="FontStyle336"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"> </span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">в</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | <span style="letter-spacing: -0.5pt;">табл.</span></span></span><span class="FontStyle336"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">1.11.</span></span>''<span class="FontStyle336"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | '''<span class="FontStyle299"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">Задание</span><span style="font-size: 11pt; font-family: "Times New Roman";"> <span style="letter-spacing: -0.5pt;">2</span></span></span>'''<span class="FontStyle299"><span style="font-size: 11pt; font-family: "Times New Roman";" /></span><span class="FontStyle299"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">Используя</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"> <span style="letter-spacing: -0.5pt;">конструктор</span> <span style="letter-spacing: -0.5pt;">запросов</span></span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">MS</span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | </span></span><span class="FontStyle340"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">Access</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">,</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"> <span style="letter-spacing: -0.5pt;">выполнить все</span> <span style="letter-spacing: -0.5pt;">запросы,</span> <span style="letter-spacing: -0.5pt;">описанные</span> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">§</span> <span style="letter-spacing: -0.5pt;">1.14.</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| - | | + | |
| - | ''<span style="font-size: 11pt; font-family: "Times New Roman";"><o:p> </o:p></span>''<span style="font-size: 11pt; font-family: "Times New Roman";"><o:p></o:p></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle299"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">Задание</span></span><span class="FontStyle299"><span style="font-size: 11pt; font-family: "Times New Roman";"> <span style="letter-spacing: -0.5pt;">3</span></span></span>''<span class="FontStyle299"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">Реализовать</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"> <span style="letter-spacing: -0.5pt;">в</span> <span style="letter-spacing: -0.5pt;">конструкторе</span> <span style="letter-spacing: -0.5pt;">запросов</span> <span style="letter-spacing: -0.5pt;">следующие</span> <span style="letter-spacing: -0.5pt;">задания:</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| - | | + | |
| - | ''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style="">1)<span style="font: 7pt "Times New Roman";">
| + | |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">получить</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | <span style="letter-spacing: -0.5pt;">таблицу,</span> <span style="letter-spacing: -0.5pt;">содержащую</span> <span style="letter-spacing: -0.5pt;">фамилии</span> <span style="letter-spacing: -0.5pt;">абитуриентов</span> <span style="letter-spacing: -0.5pt;">и</span> <span style="letter-spacing: -0.5pt;">средние</span> <span style="letter-spacing: -0.5pt;">значения</span> <span style="letter-spacing: -0.5pt;">оценок,</span> <span style="letter-spacing: -0.5pt;">полученных</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">экзаменах;</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| - | | + | |
| - | ''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style="">2)<span style="font: 7pt "Times New Roman";">
| + | |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">получить</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | <span style="letter-spacing: -0.5pt;">список</span> <span style="letter-spacing: -0.5pt;">лишь</span> <span style="letter-spacing: -0.5pt;">тех</span> <span style="letter-spacing: -0.5pt;">абитуриентов,</span> <span style="letter-spacing: -0.5pt;">у</span> <span style="letter-spacing: -0.5pt;">которых оценка</span> <span style="letter-spacing: -0.5pt;">за</span> <span style="letter-spacing: -0.5pt;">первый</span> <span style="letter-spacing: -0.5pt;">экзамен</span> <span style="letter-spacing: -0.5pt;">больше</span> <span style="letter-spacing: -0.5pt;">среднего</span> <span style="letter-spacing: -0.5pt;">балла</span> <span style="letter-spacing: -0.5pt;">за
| + | |
| - | все</span> <span style="letter-spacing: -0.5pt;">экзамены;</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| - | | + | |
| - | ''<!--[if !supportLists]--><span class="FontStyle340"><span style="font-size: 11pt; letter-spacing: -0.5pt;"><span style="">3)<span style="font: 7pt "Times New Roman";">
| + | |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">предположим,</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | <span style="letter-spacing: -0.5pt;">что</span> <span style="letter-spacing: -0.5pt;">действует</span> <span style="letter-spacing: -0.5pt;">следующее</span> <span style="letter-spacing: -0.5pt;">правило:</span> <span style="letter-spacing: -0.5pt;">на экономический</span> <span style="letter-spacing: -0.5pt;">факультет</span> <span style="letter-spacing: -0.5pt;">университета</span> <span style="letter-spacing: -0.5pt;">принимаются те</span> <span style="letter-spacing: -0.5pt;">абитуриенты,</span> <span style="letter-spacing: -0.5pt;">у</span> <span style="letter-spacing: -0.5pt;">которых</span> <span style="letter-spacing: -0.5pt;">сумма</span> <span style="letter-spacing: -0.5pt;">баллов</span> <span style="letter-spacing: -0.5pt;">за</span> <span style="letter-spacing: -0.5pt;">экзамены
| + | |
| - | не</span> <span style="letter-spacing: -0.5pt;">меньше</span> <span style="letter-spacing: -0.5pt;">14;</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">исторический</span> <span style="letter-spacing: -0.5pt;">факультет</span> <span style="letter-spacing: -0.5pt;">—</span> <span style="letter-spacing: -0.5pt;">не</span> <span style="letter-spacing: -0.5pt;">меньше</span> <span style="letter-spacing: -0.5pt;">13;</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">юридический</span> <span style="letter-spacing: -0.5pt;">факультет</span> <span style="letter-spacing: -0.5pt;">—</span> <span style="letter-spacing: -0.5pt;">не</span> <span style="letter-spacing: -0.5pt;">меньше</span> <span style="letter-spacing: -0.5pt;">12. Получить</span> <span style="letter-spacing: -0.5pt;">список</span> <span style="letter-spacing: -0.5pt;">принятых</span> <span style="letter-spacing: -0.5pt;">на</span> <span style="letter-spacing: -0.5pt;">каждый</span> <span style="letter-spacing: -0.5pt;">факультет»</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">указав</span></span><span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"> <span style="letter-spacing: -0.5pt;">факультеты,</span> <span style="letter-spacing: -0.5pt;">специальности,</span> <span style="letter-spacing: -0.5pt;">фамилии,</span> <span style="letter-spacing: -0.5pt;">имена, отчества.</span> <span style="letter-spacing: -0.5pt;">Отсортировать</span> <span style="letter-spacing: -0.5pt;">список</span> <span style="letter-spacing: -0.5pt;">по</span> <span style="letter-spacing: -0.5pt;">факультету</span> <span style="letter-spacing: -0.5pt;">и</span> <span style="letter-spacing: -0.5pt;">еде*
| + | |
| - | циальеости.</span></span></span>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman";"><span style="letter-spacing: -0.5pt;"><o:p></o:p></span></span></span>
| + | |
| - | </div>''<span class="FontStyle340"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: -0.5pt;">
| + | |
| - | | + | |
| - | </span></span> ''
| + | |
| - | ''<span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">Работа</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">8.</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">Творческое</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">задание</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">на</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";">
| + | |
| - | </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">реализацию</span></span>''<span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">сложных</span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman";"> </span></span><span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;">запросов</span></span>''<span class="FontStyle294"><span style="font-size: 11pt; font-family: "Times New Roman"; letter-spacing: 1pt;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">Цель работы: отработка умения
| + | |
| - | формулировать сложные запросы и реализовывать их с помощью конструктора в </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">MS</span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"> </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">Access</span></span><span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">.</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">Используемые программные средства: </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">MS</span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"> </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">Access</span></span><span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">. Задание</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">Выполнить различные типы запросов
| + | |
| - | к самостоятельно созданной базе данных* Для этого:</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt "Times New Roman";">
| + | |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">придумать общую формулировку не менее, чем пяти запросов
| + | |
| - | на выборку с использованием сложных условий отбора и сортировки;</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt "Times New Roman";">
| + | |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">записать в тетради команды запросов на
| + | |
| - | гипотетическом языке;</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt "Times New Roman";">
| + | |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">реализовать запросы с помощью конструктора в </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">MS</span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"> </span></span><span class="FontStyle343"><span lang="EN-US" style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">Access</span></span><span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">;</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt "Times New Roman";">
| + | |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">придумать и реализовать запросы на удаление записей;</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<!--[if !supportLists]--><span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><span style="">•<span style="font: 7pt "Times New Roman";">
| + | |
| - | </span></span></span></span><!--[endif]--><span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;">придумать и реализовать запросы с использованием вычисляемых
| + | |
| - | полей.</span></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-family: "Times New Roman"; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | ''<span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;" /></span>''<span class="FontStyle343"><span style="font-size: 11pt; font-weight: normal;"><o:p></o:p></span></span>
| + | |
| - | | + | |
| - | | + | |
| - | ''Семакин И.Г., Хеннер Е.К., Информатика и ИКТ, 11''
| + | |
| | | | |
| | ''Отослано читателями из интернет-сайтов''<br><br> | | ''Отослано читателями из интернет-сайтов''<br><br> |
| Строка 159: |
Строка 32: |
| | | | |
| | '''<u>Содержание урока</u>''' | | '''<u>Содержание урока</u>''' |
| - | '''[[Image:1236084776 kr.jpg|10x10px]] конспект урока ''' | + | '''[[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] конспект урока ''' |
| - | [[Image:1236084776 kr.jpg|10x10px]] опорный каркас | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] опорный каркас |
| - | [[Image:1236084776 kr.jpg|10x10px]] презентация урока | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] презентация урока |
| - | [[Image:1236084776 kr.jpg|10x10px]] акселеративные методы | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] акселеративные методы |
| - | [[Image:1236084776 kr.jpg|10x10px]] интерактивные технологии | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] интерактивные технологии |
| | | | |
| | '''<u>Практика</u>''' | | '''<u>Практика</u>''' |
| - | [[Image:1236084776 kr.jpg|10x10px]] задачи и упражнения | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] задачи и упражнения |
| - | [[Image:1236084776 kr.jpg|10x10px]] самопроверка | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] самопроверка |
| - | [[Image:1236084776 kr.jpg|10x10px]] практикумы, тренинги, кейсы, квесты | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] практикумы, тренинги, кейсы, квесты |
| - | [[Image:1236084776 kr.jpg|10x10px]] домашние задания | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] домашние задания |
| - | [[Image:1236084776 kr.jpg|10x10px]] дискуссионные вопросы | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] дискуссионные вопросы |
| - | [[Image:1236084776 kr.jpg|10x10px]] риторические вопросы от учеников | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] риторические вопросы от учеников |
| - |
| + | |
| | '''<u>Иллюстрации</u>''' | | '''<u>Иллюстрации</u>''' |
| - | '''[[Image:1236084776 kr.jpg|10x10px]] аудио-, видеоклипы и мультимедиа ''' | + | '''[[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] аудио-, видеоклипы и мультимедиа ''' |
| - | [[Image:1236084776 kr.jpg|10x10px]] фотографии, картинки | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] фотографии, картинки |
| - | [[Image:1236084776 kr.jpg|10x10px]] графики, таблицы, схемы | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] графики, таблицы, схемы |
| - | [[Image:1236084776 kr.jpg|10x10px]] юмор, анекдоты, приколы, комиксы | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] юмор, анекдоты, приколы, комиксы |
| - | [[Image:1236084776 kr.jpg|10x10px]] притчи, поговорки, кроссворды, цитаты | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] притчи, поговорки, кроссворды, цитаты |
| | | | |
| | '''<u>Дополнения</u>''' | | '''<u>Дополнения</u>''' |
| - | '''[[Image:1236084776 kr.jpg|10x10px]] рефераты''' | + | '''[[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] рефераты''' |
| - | [[Image:1236084776 kr.jpg|10x10px]] статьи | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] статьи |
| - | [[Image:1236084776 kr.jpg|10x10px]] фишки для любознательных | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] фишки для любознательных |
| - | [[Image:1236084776 kr.jpg|10x10px]] шпаргалки | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] шпаргалки |
| - | [[Image:1236084776 kr.jpg|10x10px]] учебники основные и дополнительные | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] учебники основные и дополнительные |
| - | [[Image:1236084776 kr.jpg|10x10px]] словарь терминов | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] словарь терминов |
| - | [[Image:1236084776 kr.jpg|10x10px]] прочие | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] прочие |
| | | | |
| | <u>Совершенствование учебников и уроков | | <u>Совершенствование учебников и уроков |
| - | </u>'''[[Image:1236084776 kr.jpg|10x10px]] исправление ошибок в учебнике''' | + | </u>'''[[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] исправление ошибок в учебнике''' |
| - | [[Image:1236084776 kr.jpg|10x10px]] обновление фрагмента в учебнике | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] обновление фрагмента в учебнике |
| - | [[Image:1236084776 kr.jpg|10x10px]] элементы новаторства на уроке | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] элементы новаторства на уроке |
| - | [[Image:1236084776 kr.jpg|10x10px]] замена устаревших знаний новыми | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] замена устаревших знаний новыми |
| - |
| + | |
| | '''<u>Только для учителей</u>''' | | '''<u>Только для учителей</u>''' |
| - | '''[[Image:1236084776 kr.jpg|10x10px]] идеальные уроки ''' | + | '''[[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] идеальные уроки ''' |
| - | [[Image:1236084776 kr.jpg|10x10px]] календарный план на год | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] календарный план на год |
| - | [[Image:1236084776 kr.jpg|10x10px]] методические рекомендации | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] методические рекомендации |
| - | [[Image:1236084776 kr.jpg|10x10px]] программы | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] программы |
| - | [[Image:1236084776 kr.jpg|10x10px]] обсуждения | + | [[Image:1236084776 kr.jpg|10x10px|1236084776 kr.jpg]] обсуждения |
| | | | |
| | | | |
• обучение реализации запросов на удаление, а также использованию вычисляемых полей в запросах.
Создать таблицу «Оценки» и ввести в нее данные, представленные в теме 19 в табл. 1.11.
1) получить таблицу, содержащую фамилии абитуриентов и средние значения оценок, полученных на экзаменах;
2) получить список лишь тех абитуриентов, у которых оценка за первый экзамен больше среднего балла за все экзамены;
Если вы хотите увидеть другие корректировки и пожелания к урокам, смотрите здесь - Образовательный форум.
