- •Ict subject and its objectives.
- •Ict Standards.
- •State standards of the Republic of Kazakhstan in the field of Informational technologies
- •List of recommended references
- •Introduction to the computer system.
- •Memory unit. The computer will have memory that can hold both data and also the program processing that data. In modern computers this memory is ram.
- •Input – Output. This architecture allows for the idea that a person needs to interact with the machine. Whatever values that are passed to and forth are stored once again in some internal registers.
- •Human-computer interaction
- •Interface Usability.
- •Common accessibility features
- •Advantages of a dbms
- •Types of databases
- •Data Analysis
- •The main methods of representations and processing of charts
- •Electronic spreadsheet ms Excel
- •Ms Excel functions for calculation
- •The main methods of representations and processing of charts
- •Intermediary Devices and their Role on the Network
- •Internetwork
- •Intranet
- •Internetwork Protocol:
- •Internet Connections
- •Ip stands for Internet Protocol
- •Definition of a communication device
- •Augmentative communication devices
- •Long distance communication devices
- •Voip based communication devices
- •Satellite phone communication devices
- •Related pages
- •Computer Network
- •Local and Wide Area Networks
- •Intranets and Extranets
- •The Internet
- •The Telephone Network in Computing
- •Industry cyber security.
- •Cyber Terrorism
- •Cyber Warfare
- •Cyber Espionage
- •Threats classification
- •Methods for Protection against Dangerous Electromagnetic Emissions
- •Dangerous Signals
- •Etsi Cyber Security Technical Committee (tc cyber)
- •Legal System of Kazakhstan
- •Electronic signature
- •Used literature
- •What is the web?
- •What is the function of server software / programs?
- •How does the web surfer find a web site?
- •Registering your domain name
- •What is the Internet?
- •What is the Web?
- •How does the Internet work?
- •Google accounts
- •Gmail features
- •Get to know the Gmail interface
- •What is the World Wide Web (www)?
- •Basic www Concepts
- •Domain Names and ip Addresses
- •Dns Servers
- •Security Concerns
- •Browsers
- •Programming Languages
- •Frameworks
- •Libraries
- •Databases
- •Data formats
- •What are smtp, pop3 and imap?
- •Examples
- •Cloud an d mobile technologies
- •Virtualization technologies.
- •Virtualization technologies
- •Isolation
- •Web Services and Cloud Computing
- •Cloud Computing Definition nist Definition of Cloud Computing
- •Cloud Computing Explained a Convergence of Technologies
- •Any Organization Can Use Cloud Computing
- •Blurring of Services
- •4G Networking[edit]
- •Operating systems[edit]
- •Channel hogging and file sharing[edit]
- •Future of smartphone[edit]
- •Comparison table[edit]
- •Internet of Things.
- •Smartphones
- •Smart Services
- •Big data
- •Teleconference Teleconference
- •Telemedicine
- •Information e-business infrastructure
- •Information technology in the professional sphere. Industrial ict.
- •Search Engines What is a search engine?
- •Why use a search engine?
- •How do I know when I should use a search engine and when I should use a database?
- •The prospects of ict development
- •Globalization Of App Developer Opportunities
Electronic spreadsheet ms Excel
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.
Microsoft Excel is one of the most used software applications of all time. Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations.
1 Range: A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.
2 Formulas and Functions: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
This section is for users with no knowledge of Excel.
1 Sort: You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order.
2 Filter: Filter your Excel data if you only want to display records that meet certain criteria.
3 Conditonal Formatting: Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
4 Charts: A simple Excel chart can say more than a sheet full of numbers. As you'll see, creating charts is very easy.
5 Pivot Tables: Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.
6 Tables: Tables allow you to analyze your data in Excel quickly and easily.
7 What-If Analysis: What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.
8 Solver: Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
9 Analysis ToolPak: The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.
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.
Microsoft Excel records cell addresses in formulas in three different ways, called absolute, relative, and mixed.