Файл: азастан Республикасы Білім жне ылым министрлігі . Жбанов атындаы Атбе ірлік мемлекеттік университеті Физикаматематика факультеті Информатика жне апаратты технологияларкафедрасы Бекітемін.doc

ВУЗ: Не указан

Категория: Не указан

Дисциплина: Не указана

Добавлен: 12.01.2024

Просмотров: 205

Скачиваний: 1

ВНИМАНИЕ! Если данный файл нарушает Ваши авторские права, то обязательно сообщите нам.

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №6

Тақырыбы: Processing of numerical information, editing formulas and creation of charts in spreadsheet editors

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. How do I set the width of a column?

  2. How can I change the format of a cell?

  3. What are the rules for writing formulas?

  4. What is the difference between different types of addressing (absolute, relative, mixed)?

  5. How to insert a standard function into the formula?

  6. What does the chart area include?

  7. How do I add a series of data to a chart?

  8. How do I sort the data by several criteria?

  9. What is the advanced filter used for?

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №7

Тақырыбы: Creation of a simple network configuration. IP addressing. Monitoring of a network. Analysis of traffic. Use of sniffers for the analysis of network packets

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What are the main purposes of monitoring network traffic?

  2. What is the difference between traffic monitoring and filtering?

  3. What is the purpose of the class of sniffer programs?

  4. What are the main functions of sniffers?

  5. Why are Wireshark sniffer filters and capture filters used? What is their difference?

  6. What basic functions of statistical processing of captured packs is the Wireshark sniffer?

  7. What tasks are intended to solve the ARP protocol?

  8. Name the tasks of the ARP protocol.

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №8

Тақырыбы: Use of hardware and software for key generation. Application of the EDS and encoding in case of message exchange by E–mail. Settings of the Firewall program element of the computer network for network traffic monitoring and filtering. Working with the various antivirus programs

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What is EDS?

  2. What is the difference between an open and a private key?

  3. How do I encrypt a message with a digital signature?

  4. How can I decrypt the message?

  5. What software products are used to work with EDS?

  6. What is EDS?

  7. Principle of EDS operation.

  8. What are the keys for?

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №9

Тақырыбы: Data acquisition from the server. Working with WordPress and Joomla web content management systems. Development a website design using Photoshop multifunctional graphic editor and CSS style sheet language. Using of the previously developed MySQL database for the work of the website


Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. How do you understand the concept of "website design"?

  2. What are the requirements for the design of websites?

  3. What are style sheets?

  4. What are the main attributes used to design a web page?

  5. What tools are used to create styles?

  6. Name the types of styles.

  7. What are the main styles of designing Web pages.

  8. The advantage of styles when building a Web site.

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №10

Тақырыбы: Introduction to Google Docs and Microsoft Office Web Apps cloud services. Creation accounts to work with cloud services. Study of operation modes associated with file storage, sharing and processing. Use of mobile technologies for receiving an information access. GPS navigators. GSM a signalling

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What are Internet services?

  2. What Internet services does Google provide? Write out the names of the 15 services and, briefly, the purpose of each.

  3. Learn the rating of using Google services. Of these, the basic: Google Docs, Gmail, Google Translate, Google Calendar, Google Sites, Google Maps, Blogger, YouTube, Google Picasa Web. Select the 5 most popular.

  4. What is an account or account? What is it for?

  5. How do I register an account with Google?

  6. Create your personal account on Google.

  7. How do I open an account with Google?

  8. Name the Internet services.

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №11

Тақырыбы: Creation of video files with use of programs: HyperCam, Adobe Premiere Pro, Windows Movie Maker, etc.

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What kinds of video editing exist? What are their differences?

  2. What is the difference between PAL and NTSC standards?

  3. What are the formats of video files?

  4. What is the frame rate?

  5. What is a video transition?

  6. Basic functions of the audio mixer?

  7. How to adjust the sound level of audio material.

  8. How to create a video file?

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №12

Тақырыбы: Operation with Smart–applications: Smart TV, Smart Hub, etc.

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What is Smart TV?

  2. What is Smart Hub used for?

  3. Describe the main SMART platforms?

  4. How to connect and use Smart TV?

  5. What additional hardware do you need to have to use Smart technology?

  6. What are the advantages of using Smart technologies?

  7. Name the types of Smart TV.

  8. What are the additional benefits that can be added to the TV.

Әдістемелік нұсқау

1. Repetition of theoretical material.



2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №13

Тақырыбы: Operation with services on the website of the electronic government http://​egov.​kz/​cms/​ru/​gov​ernm​ent–​ser​vice​s/​for_​citizen: registration of requests, obtaining counterparts of documents, etc.

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What is e–government?

  2. Why use the e–government portal?

  3. In what ways can you get a "digital signature"?

  4. What types of online services do you know for citizens?

  5. What do I need to receive an EDS?

  6. What services does e–government provide?

  7. How to register in the portal egov.kz?

  8. What are the main services you use?

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №14

Тақырыбы: Development of structure and the maintenance of a lesson in the environment of remote learning: Moodle, eDX, etc.

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What data is stored in the database tables moodle?

  2. Where is the login and password stored for access to the moodle database?

  3. How to transfer the system to another computer / server without installing it from the distribution kit?

  4. How to create tables via xmldb–editor?

  5. How do I write functions for updating tables using xmldb?

  6. How to install a new unit?

  7. How to develop a structural diagram of the discipline?

  8. What is distance learning?

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Практикалық сабақ №15

Тақырыбы: Installation and use of application programs in the professional sphere. Working in the Matlab environment for scientific and technical computing. Working with the Matlab toolboxes for applied problem solving

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What is a distro?

  2. On which groups of programs does the software of the PC share?

  3. List the programs related to the system.

  4. What programs are called applied?

  5. What functions implement the tool programs?

  6. What are utilities? What are the drivers for?

  7. What is the function of the packers?

  8. With the help of which devices the programs are translated into one of the languages comprehensible for a computer?

  9. What is the purpose of testing, control and diagnostics programs?

  10. What programs does the standard subroutine library contain?

Әдістемелік нұсқау

1. Repetition of theoretical material.

2. Acquaintance with methodological instructions.

3. Complete tasks on the topic.

5. Drawing up a report on the work.

6. Preparation of an essay on the topic.

7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

9.3 Зертханалық сабақтар
LABORATORY WORKS
Зертханалық сабақ №1


Тақырыбы: Computation of metrics of productivity of computer system: speed, efficiency, energy expenses, Amdal's law, CPU time

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. The basic principles of building a computer, the structure of J. von Neumann.

  2. The classical architecture of computers and the principles of von Neumann.

  3. Draw a block diagram of the PC, explain the purpose of all components. CPU, the main characteristics. Memory system: composition, purpose. RAM: DRAM: structure, basic parameters. System bus: definition, purpose, parameters.

  4. Bus FSB, Hyper Transport, PCI, PCI–E: purpose, basic parameters, speed.

  5. "North bridge", "South bridge": composition, purpose.

  6. Factors affecting PC performance.

  7. Which devices can connect to which ports?

Әдістемелік нұсқау

  1. Acquaintance with methodological instructions.

  2. Complete the assigned tasks.

  3. Consider the quick reference to the components in sectionExplorer.

  4. Use mode Test to test your ability to assemble a desktop computer from starch. You must still follow the layers of access, however you will not receive any instruction.

  5. Create a report on this work.

  6. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Зертханалық сабақ №2

Тақырыбы: Determination of properties of an operating system. Operation with files and directories

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. Definition of Windows.

  2. The main features of Windows.

  3. Definition of the Desktop, its main elements and their purpose.

  4. Definition and purpose of the Taskbar.

  5. The concept of the context menu, ways to call it.

  6. The concept of Standard Programs, their purpose and loading.

  7. The concept of the file, the path to the file, the full name of the file.

  8. Concepts of a folder and a subfolder.

  9. Concepts of the root, current directory.

  10. Organization of data storage in a computer (hierarchical structure).

Әдістемелік нұсқау

  1. Acquaintance with methodological instructions.

  2. Complete the assigned tasks.

  3. Working with the operating system Windows.

  4. Working with the operating system MS DOS.

  5. Prepare an essay on “Оperating systems”.

  6. Create a report on this work.

  7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Зертханалық сабақ №3

Тақырыбы: Determination of requirements to development "convenient in application" the website

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What is a "tag"?

  2. What is the difference between opening and closing tags?

  3. What is a container?

  4. How many tags can be in a Web document?

  5. What letter and why is used for the hyperlink tag?

  6. What is the name attribute for?

  7. What is the purpose of the href attribute?

  8. What is the title attribute for?

  9. What is the target attribute for?

  10. Give examples of relative references.

Әдістемелік нұсқау

  1. Acquaintance with methodological instructions.

  2. Complete the assigned tasks.

  3. Creating a simple file HTML.

  4. Some special formatting commands.

  5. Emphasize text.

  6. Installation of the headset, and font color.

  7. Placing graphics on the Web–page.

  8. Prepare an essay on “HTML”.

  9. Create a report on this work.

  10. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]


Зертханалық сабақ №4

Тақырыбы: Development of database structure, creation of tables and requests. Working with a MySQL relational database. MySQL database administration using phpMyAdmin. Working with a single–table database

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. The concept of IP, DB, DBMS?

  2. Classification of data models?

  3. DBMS classification?

  4. Market review of modern DBMS?

  5. MS Access, its functions?

  6. Definition of a database, a table, a form, a report, a macro, a module?

  7. What is a data schema?

  8. What are the types of data?

Әдістемелік нұсқау

  1. Acquaintance with methodological instructions.

  2. Complete the assigned tasks.

  3. Creation of databases Task data "Dean's office".

  4. Edit the database. MySQL

  5. Work in the table mode.

  6. My SQL Create table.

  7. Prepare an essay on “MySQL”.

  8. Create a report on this work.

  9. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Зертханалық сабақ №5

Тақырыбы: Design and creation of the presentations of lecture material, scientific reports, etc.

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. What is the Table of Contents for?

  2. Basic elements of management?

  3. Glossary of terms.

  4. What is the Help system for?

  5. What is the Slides?

  6. Name the components of the Microsoft Power Point page.

  7. Name the structure of the presentation.

  8. What are the controls?

Әдістемелік нұсқау

  1. Acquaintance with methodological instructions.

  2. Complete the assigned tasks.

  3. Adding a Clip to the Project.

  4. Playing Clips in Windows Movie Maker

  5. Adding Audio to the Project.

  6. Create a report on this work.

  7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Зертханалық сабақ №6

Тақырыбы: Processing of numerical information, editing formulas and creation of charts in spreadsheet editors

Сағат саны: 1

Тақырыптың негізгі сұрақтары:

  1. How do I set the width of a column?

  2. How can I change the format of a cell?

  3. What are the rules for writing formulas?

  4. What is the difference between different types of addressing (absolute, relative, mixed)?

  5. How to insert a standard function into the formula?

  6. What does the chart area include?

  7. How do I add a series of data to a chart?

  8. How do I sort the data by several criteria?

  9. What is the advanced filter used for?

Әдістемелік нұсқау

  1. Acquaintance with methodological instructions.

  2. Complete the assigned tasks.

  3. Using the data construct a diagram showing the production of basic products of extractive industries..

  4. We need to show changes over time and represent the ratio values.

  5. Prepare an essay on “MS Excel”.

  6. Create a report on this work.

  7. Answers to security questions.

Әдебиет: [ негізгі: 1–2, қосымша 1–17 ]

Зертханалық сабақ №7

Тақырыбы: Creation of a simple network configuration. IP addressing. Monitoring of a network. Analysis of traffic. Use of sniffers for the analysis of network packets

Сағат саны: 1

Тақырыптың негізгі сұрақтары: