Extension Name of Some Files

A Website Window To Focus Upon Complete Computer Education

Windows Operating System

A Website Window To Focus Upon Complete Computer Education

Data Communication

A Website Window To Focus Upon Complete Computer Education

Some Abbreviations In Computer

A Website Window To Focus Upon Complete Computer Education

What Is The Internet

A Website Window To Focus Upon Complete Computer Education

Dec 13, 2012

POWER SUPPLY UNIT

POWER SUPPLY UNIT
SMPS(switch mode power supply): The power supply supplies power to every single part of the PC. The main function of the power supply is to convert them
230 volt AC into 3.3 volts, 5 volt and 12 volt DC power that the system requires for the operations. In addition to supplying power to run the system, the power supply also ensures that the system does not run unless the power supplied is sufficient to operate the system properly. The power supply completes internal checks and tests before allowing the system to start. If the tests are successful, the power supply sends a special signal to the motherboard called power_good. If this signal is not present continuously, the computer does not run. Therefore, when the AC voltage dips and the power supply becomes stressed or overheated, the power_good signal goes down and forces a system reset or complete shutdown.


SMPS



features of SMPS

* Receive up to 230-volt ac.
* Step down the power.
* Convert AC to DC.
* Supply power to a different device of the computer system.
* Low working temperature.
* Ultra compact open frame switching power supply.
* Universal input.


Types os SMPS:
1.AT(Advanced Technology)SMPS:
AT stands for Advanced Technology. These are all old SMPS. They have 12 pin power connector, this is called AT power connector. They were used in Pentium-I, Pentium-II, Pentium-III and Pentium MMX CPUs.

2.ATX(Advanced Technology Extended):
ATX stands for Advanced Technology Extended. They have 20 pin power connector, this is called as the ATX power connector. They were used in Pentium-III, Pentium-IV and AMD CPUs.

3.BTX(Balanced Technology Extended):
BTX stands for Balanced Technology Extended. They have 24 pin power connector, this is also called as the ATX power connector. It has 15 pins SATA power connectors. They are used in Dual Core, Core2duo, Quad Core, I-3, I-5, I-7 and latest AMD CPUs.

  

Dec 5, 2012

WHAT IS THE INTERNET

WHAT IS INTERNET:
The internet sometimes called simply "the net".The Internet is a huge number of computers that are worldwide connected to each other.these computers are situated in many different countries and are connected through telephone lines, cables in the ground and even satellites in space. 

                           On a lot of these computers, people have published information, pages with text and pictures. These pages are called 'websites'.These are millions of websites on the internet, with an enormous amount of information which you can view and use for your reading, research or fun.



Internet




SOME USES OF INTERNET:
1. Get information online about a university, college, and school.
2. Download games, videos, pictures, computer programs and other files.
3. Send instant messages.
4. Look information about a place.
5. Pay bills online.
6. Look for information on Wikipedia.
7. Look religious or spiritual information.
8. Play online games.
9. Listen to music online.
10. Search for information about someone you know or might meet.
11. Share files from own computer with others.
12. Participate in an online auction.
13. Chat in a chat room or in an online discussion.
14. Make a donation to a charity online.
15. View live images online of a remote location or person, using a webcam.
16. Use an online social networking site like Facebook, Myspace, Orkut etc.
17. Sell something online.
18. Visit an adult website.
19. Take a class online for higher education.
20. Make a phone call online.
21. Sell or buy bonds, stocks or mutual funds.
22. Go to a dating website or other site where you can meet people online.
23. Sending or reading email.
24. Use a search engine to find information.
25. Search for a map or driving directions.
26. Check the weather.
27. Get news, health, medical and travel information.
28. Make or buy a reservation for travel.
29. Look up phone number or address.
30. Do any banking online.
31. Do any types of research for your job.
32. Look online for information about a job.
33. Get sports scores and information online.  

DOMAIN CATEGORIES:

 .com for commercial organizations.
 .org for non-profit organizations.
 .net for network access provider.
 .mil for military installations.
 .gov for government agencies.
 .edu for educational institutions.
 .name for personal sites.
 .info for commercial and personal.
 .biz for commercial and personal.
 .int for organizations established by international treaty.

WORLD WIDE WEB:

The term WWW refers to the world wide web or simply the web. The world wide web consists of all the public websites connected to the internet worldwide, including the client devices that access web content. The WWW is just one of many applications of the internet and computer networks.

The world wide web is based on three technologies ...

a> HTML(hypertext markup language)
b> HTTP(hypertext transfer protocol)
c> web servers and web browsers

Researcher Tim Berners-Lee led the development of the original world wide web in the late 1980s and early 1990s. He helped build prototypes of the above web technologies and coined the term "WWW". Websites and web browsing explode in popularity during the mid-1990s.


URL:

Every web page or internet resource accessible through the WWW has a unique name, this is URL(uniform resource locator). The URL identifies and locates a resource so that a web browser can access it directly. A URL is a type of internet address.

           URL strings consist of three parts ......
a. Network protocol.
b. Hostname or address.
c. File or resource location.

INTERNET SERVICE PROVIDER:

An internet service provider is an organization that maintains a high-speed network of cables connected to the internet. This organization usually owns more than one powerful computer that is directly connected to the network forming the internet.

BROWSER:

It is basically a program that runs on an internet connected computer and provides access to WWW resources.

BROWSING:

The process of navigating among the document is called browsing. The users need to have client software such as Netscape Navigator to actually retrieve and browse the information on the WWW. WWW supports many kinds of documents such as text, pictures, video, and audio. Sometimes it is referred to as net surfing.

HOME PAGE:

A Homepage is a document that serves as the initial point of entry to a web of related documents. It contains introductory information, hyperlinks to related resources and navigation buttons to help users find their way among the various documents.

CLIENT:

The computer that is requesting for some service from another computer is called the client.

WEB SERVER:

A web server is a program that accepts requests for information framed according to the hypertext transport protocol (http). The server processes these requests and sends the requested document. when you can access a WWW server, the document is transferred to your computer and then the connection is terminated. This reduces network traffic by not having to hold on to a line, which you read a document.

WEB:

A collection of documents inter-linked by hyperlinks is called the web. A web page is synonymous with web documents. It is not the same as a page on your screen. It is also defined a hypertext information system.

HYPERLINK:

A hyperlink allows you to view information without using complex commands and without even knowing the source of the information. A hyperlink includes within it all the information needed to retrieve information or connect to a specific internet resource. Much of the excitement about the world wide web is due to its extensive use of hyperlinks.

PROTOCOL:

Is a formal definition of a language that two computers use to communicate. This definition describes acceptable messages and outlines the rules that two computers must follow to exchange those messages.

HYPERTEXT:

When a hyperlink is attached to text, it is called hypertext. Hypertext is a method of preparing and publishing the text in which users can choose their own paths for the material. The text is broken into small units such as single pages called nodes. Then hyperlinks are embedded into the text. Typically the users have a GUI on which he clicks a button to navigate through the different pages.

HYPERTEXT MARKUP LANGUAGE(HTML):

A markup language is a set of formatting codes that effects that the way preset information will be displayed. It is used to create hypertext markup language documents. It is not a programming language. Only the presentation, but not the contents. The information remains static all the documents that you view on the WWW are created using HTML.












Dec 3, 2012

EXCEL SHORTCUT KEY

keyboard shortcuts:

F2                                   = Edit the selected cell.
F5                                   = Go to a specific cell.
F7                                   = Spell check selected text and document.
F11                                 = Create chart.
ctrl+A                             = Select all.
ctrl+B                             = Bold.
ctrl+C                             = Copy.
ctrl+F                              = Find.
ctrl+G                             = Go to.
ctrl+H                             = Replace. 
ctrl+I                              = Italic.
ctrl+K                            = Insert link.
ctrl+N                            = New workbook.
ctrl+O                            = Open workbook.
ctrl+P                            = Print dialog.
ctrl+S                            = Save.
ctrl+U                           = Underline.
ctrl+V                           = Paste.
ctrl+Z                           = Undo.
ctrl+Y                           = Redo.
ctrl+X                           = Cut.
ctrl+5                            = Strikethrough text.
ctrl+F3                          = Define name.
ctrl+F4                          = Exit excel.
ctrl+F6                          = Switch between open workbooks.
ctrl+F9                          = Minimize current window.
ctrl+F10                        = Maximize current window.
shift+F1                        = Activate help on item.
shift+F2                        = Insert comments.
shift+F3                        = Insert function.
ctrl+shift+;                   = Enter the current time.
ctrl+;                            = Enter the current date.
ctrl+page down            = Move to next worksheet.
ctrl+page up                 = Move to previous worksheet.
ctrl+shift+#                  = Number format:date.
ctrl+shift+@                = Number format:time.
ctrl+shift+!                  = Number format:commas.
ctrl+shift+$                 = Number format:currency.
ctrl+shift+%                = Number format:percentage.
ctrl+shift+^                 = Number format:scientific.
ctrl+space                   = Select entire column.
shift+space                  = Select entire row.
ctrl+arrow key            = Move to next section.


MS Excel



MOUSE SHORTCUTS:


double-click on a cell                           = Edit the cell contents.
double click on a row/column divider = Adjust height/width to autofit.
 click on row/column divider then drag = Adjust height/width of the row/column.

ctrl+mouse wheel                              = Zooms in or zooms out of the document.


hold shift+click the cells                  = Select multiple cells.


triple click                                        = Select the entire contents of the cell.

Share

Twitter Facebook Digg Stumbleupon Favorites More