- •1. Сұрақ: Give definition to information and communication technologies
- •2. Сұрақ: Describe computer systems
- •3. Сұрақ: Give definition to Operating system.
- •4. Сұрақ: Give definition to Software
- •5. Сұрақ: Describe Multimediacontents
- •6. Сұрақ: Describe Archiving of data
- •7. Сұрақ: Give definition to User interface
- •8. Сұрақ: Describe Databases systems
- •9. Сұрақ: Give definition to Computer networks
- •10. Сұрақ: Describe Browsers and search engines, domains
- •Examples of Database Applications
- •11. Сұрақ: Describe ip addressing
- •12. Сұрақ: Give definition to information security
- •13. Сұрақ: Give definition to Computer viruses
- •Best Antivirus Programs: nod32; Kaspersky; Norton; Avast; Eset, and etc.
- •14. Сұрақ: Describe Web technologies
- •15. Сұрақ: Describe Cloud computing
- •16. Сұрақ: Give definition to Main terms of Smart technology
- •17. Сұрақ: Give definition to e-learning
- •18. Сұрақ: Describe a free software
- •19. Сұрақ: Give definition to Main terms of mobile technologies
- •30 Баллдық емтихан сұрақ
- •1. Сұрақ: Explain Evolution of ict
- •2. Сұрақ: Explain the standards in the field of ict
- •35.020 Information technology (it) in general
- •Information technology.
- •3. Сұрақ: Explain development of necessary infrastructure of electronic payments and logistics
- •4. Сұрақ: Explain the architecture of computer systems
- •5. Сұрақ: Explain types of software, purposes and characteristics.
- •6. Сұрақ: Explain the basic concepts of os
- •7. Сұрақ: Explain the evolution of os
- •8. Сұрақ: Explain the classification of os
- •9. Сұрақ: Explain the types of interfaces: command line interface, text interface, graphic interface.
- •10. Сұрақ: Explain and give examples of electronic government services
- •11. Сұрақ: Explain development stages of the user interface.
- •-Designing -Implementing -Testing
- •12. Сұрақ: Explain the main concepts, characteristics and architecture of database systems
- •The picture below demonstrates the three Level Database Architecture
- •13. Explain the main forms of electronic education
- •14. Explain and give examples of electronic business
- •15. Explain the methods of design and development of databases
- •16. Сұрақ: Explain the methods of collection, classification, prediction, analysis and manage of data
- •18. Сұрақ: Explain the basic concepts of Internet
- •19. Сұрақ: Explain the principles of cloud technology
- •20. Сұрақ: Explain and give examples of multimedia technologies
- •Major uses of multimedia systems
- •50 Баллдық емтихан сұрақ (қолданады)
- •1. Сұрақ: Establish connection: ict and key sectors of society development.
- •2. Specify components of computer systems.
- •3. Specify evolution of operating systems.
- •4. Specify human-computer of interaction.
- •-Designing -Implementing -Testing
- •5.Design and development of database.
- •6. Specify local and wide area networks.
- •8. Specify End devices, data transfer devices, transmission medium.
- •Specify Cyber security and control of the Internet
- •10. Describe Internet protocols: ip, tcp, dmp
- •11.Specify web service in a cloud technology
- •12. Specify design and organization of e-learning
- •12.Specify Design and organization of e-learning.
- •13. Elements of information infrastructure of electronic business.
- •14. Design and implementation of the electronic government.
- •Describe the modern it trends in the professional sphere.
- •16. Exchange of information in office programs.
- •17. Specify the data representation stages in computer systems.
- •18. Specify concepts of mobile technologies.
- •19.Specify information processing in tabular processor
- •Entering Excel Formulas and Formatting Data
- •AutoSum
- •Perform Advanced Mathematical Calculations
- •Copy, Cut, Paste, and Cell Addressing
- •20. Show properties of operating systems.
- •20. Properties of os
- •Multitasking
- •Spooling
18. Specify concepts of mobile technologies.
In the computer world, the term mobile device refers to any electronic device that be easily moved from one location to another. Overtime, this category has expanded to include cell phones, laptops, smartphones, smartwatches, and other portable devices. The picture shows an example of one of the most common mobile devices today: the tablet computer.
Mobile device history.
Laptops became one of the first mobile computing devices by eliminating the wires between the computer and its peripherals; then integrating them in to one unit. Today, mobile device usually refers to any hand-held computer capable of running applications that can connect to the Internet wirelessly. However, even by today's more scrupulous standards, the category keeps expanding with new inventions. As is true in any branch of computing, our mobile devices continue to offer more advanced functions while reducing size and weight.
Mobile technology is the technology used for cellular communication. Mobile code division multiple access (CDMA) technology has evolved rapidly over the past few years. Since the start of this millennium, a standard mobile device has gone from being no more than a simple two-way pager to being a mobile phone, GPS navigation device, an embedded web browser and instant messaging client, and a handheld game console. Many experts argue that the future of computer technology rests in mobile computing with wireless networking. Mobile computing by way of tablet computers are becoming more popular. Tablets are available on the 3G and 4G networks.
One of the most important features in the 4G mobile networks is the domination of high speed packet transmission or brust traffic chanells. The same codes used to in the 2G 3G networks are applied to 4G mobile or wireless networks.
19.Specify information processing in tabular processor
Microsoft Excel 2007 is an electronic spreadsheet software package that allows you to organize data in a tabular format, perform mathematical calculations, and analyze data. This software includes functions, formulas, and charts. It is commonly used in business, engineering, mathematics, and statistics.
In the upper-left corner of the Excel 2007 window is the Microsoft Office button. When you click the button, a menu appears. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks.
Microsoft Excel consists of worksheets. Each worksheet contains columns and rows. The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the rows are numbered 1 to 1,048,576. The number of columns and rows you can have in a worksheet is limited by your computer memory and your system resources.
Creating a New Workbook
It is easy to create a new workbook! Simply, click on Office Button – New and click on Blank Workbook to create a new workbook.
Creating a New Worksheet
Creating a new worksheet is just as easy. By default, each Excel workbook contains three worksheets. Three tabs displaying Sheet 1, Sheet 2, and Sheet 3 will be displayed at the bottom of the workbook to indicate the separate sheets. To add a new worksheet, simply click on the tab after the tab that says Sheet 3.
The combination of a column coordinate and a row coordinate make up a cell address. For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10. You enter your data into the cells on the worksheet.. The cell address is visible in the Name Box. Place your cursor in the first cell, A1. The formula bar will display the cell address in the Name Box on the left side of the Formula bar. Notice that the address changes as you move around the sheet. You can easily move from cell to cell by pressing tab or using the arrow keys.
