Explain the methods of collection, classification, prediction, analysis and manage of data

Data analysis is the process of developing answers to questions through the examination and interpretation of data. 

The Excel - one of the most popular data analysis tools, to help visualize and gain insights from your data.

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.

Microsoft Excel records cell addresses in formulas in three different ways, called absolute, relative, and mixed.

Excel has to offer to analyze data.

1 Sort:

2 Filter:

3. Conditional Formatting:

4 Charts:

5 Pivot Tables:

6 Tables:  

7 What-If Analysis:

8 Solver:  

Analysis ToolPak:                    

Explain the main security risks of information and their classifications

Risk: A possibility that a threat exploits a vulnerability in an asset and causes damage or loss to the asset.

Explain the basic concepts of Internet

The Internet is a collection of computers, networked together throughout the world, and communicating with each other through a common language called TCP/IP (Transfer Control Protocol/Internet Protocol).

The various programs you use recognize TCP/IP, and if everything is set up correctly, and the computer is correctly connected to the Internet, all sorts of things can be done, including:

· Web Crossing

· email

· the World Wide Web (WWW)

· FTP

· Internet news

· All sorts of other services

IP Addresses

In order to identify all the computers and other devices (printers and other networked peripherals) on the Internet, each connected machine has a unique number, called an " IP address". IP stands for " Internet Protocol, " the common language used by machines on the Internet to share information.

An IP address is written as a set of 4 numbers, separated by periods, as in

203.183.184.10

This representation is sometimes referred to as dotted-octet representation of an IP address.

Here is some simple mathematics you should know! Each number in this four-number address can range from 0 through 255. So there are 256 different possible numbers for each part.

Since there are four parts, so there are a possible 256 X 256 X 256 X 256 = 256 to the 4th power = 4, 294, 967, 296 different possible machine numbers - over four billion different possible machine numbers.

This sounds like more than enough addresses to go around, but IP addresses are beginning to run out.
One single network, for example, might typically have all the IP addresses starting with 203.183.184 (203.183.184.0 through 203.183.184.255). This has been a customary way of distributing IP numbers - in chunks of 256 addresses. This is referred to as a " Class C" network. If numbers are distributed as Class C networks it means there are only a possible 256 to the 3rd power different networks - or just 16 million networks - in the whole world.

When you say it like that it doesn't sound like so many networks, because every office and many offices within offices have their separate network of computers.

To make matters worse, many networks don't even use all the 256 IP addresses available to them, which means that although the IP addresses are reserved by them they are going to waste.
To help solve this problem, networks have started being assigned with just 8 or 16 IP addresses. Some special techniques using local IP addresses that aren't visible to the outside world are also helping alleviate the strain.

But basically you should understand that you need a fixed, predefined IP address assigned to each machine that acts as a server to the outside world. You can get an IP address assignment from your network administrator, who receives them in turn from your network's Internet provider.

⇐ Предыдущая123

Поделиться: