Showing posts with label Tutorials. Show all posts
Showing posts with label Tutorials. Show all posts

Fixed Rows And Columns Headings In Pivot Table

Problem: You want to show some data in excel pivot table in which you want to fix row headings and column headings of your pivot table.

 

Let’s have a real world scenario here to understand the pivot table easily.

 

You need to show the value of Sales Opportunities in a pivot table with Months as column headings and the Sales Managers names as rows.

 

Where there is data in the underlying database (spreadsheet is linked to a SQL server database) then there is no problem. However if there is no data for a given month then of course by default the Pivot Table doesn't supply that month as a column.

 

Is there anyway to force a Pivot Table to show column headings in a non-dynamic form. So if there is no data for May the column is still there. This will make readability for my boss a lot easier.

 

On a similar subject is there also anyway I could fix the rows so that all Sales Managers show up even if there is no data.

 

Solution:

Locate your data in excel and make a pivot table with it. Select any column heading or row heading of your pivot table and right click on it. Select Field Settings from right click menu after that goto layout & Print and select Show items with no data. That’s it!!

 

 

For you help I am also attaching the snap shots. Hope this tutorial will work for you!!


Input Devices Of Computer

Input Devices

The input unit is formed by the input devices attached to the computer. Ex - Keyboard, Microphone etc. An input unit takes the input & converts it into binary form so that it can be understood by the computer.

Keyboard

This is most commonly used device which acts as input device. Its structure is like typewriter.It contains no. of  keys which have some specific ASCII values. Like ‘A’ has ASCII value 65. When this is pressed , it is converted into 65 & this 65 is sent to CPU in the form of Binary language (i.e. 1000001). Then operations are done on this data.

Most common and very popular input device is keyboard. The keyboard helps in inputting the data to the computer.The layout of the keyboard is like that of traditional typewriter, although there are some additional keys provided for performing some additional functions.

 

Keyboard are of two sizes 84 keys or 101/102 keys, but now 104 keys or 108 keys keyboard is also available for Windows and Internet.

Mouse

This is a pointing device which contains a roller in its base. When the mouse is moved on any surface, the pointer on the screen is also moved. It contains a potentiometer coupled with the roller. This potentiometer senses the motion of mouse & convert it into digital value. A mouse may contain two or three buttons.

Mouse is most popular Pointing device. It is a very famous cursor-control device. It is a small palm size box with a round ball at its base which senses the movement of mouse and sends corresponding signals to CPU on pressing the buttons.

 

Generally it has two buttons called left and right button and scroll bar is present at the mid. Mouse can be used to control the position of cursor on screen, but it cannot be used to enter text into the computer.

Now a day's optical mouse are very popular.

Bar Code Reader

It is a device which is used to read the code from the products which are usually in the form of Bars. It contains a light sensitive detector which identifies the values of the bars on the product & converts them into numeric code.

 

These Bar readers are used in Shopping malls in a very large scale.

Bar Code Reader is a device used for reading bar coded data (data in form of light and dark lines). Bar coded data is generally used in labelling goods, numbering the books etc. It may be a hand held scanner or may be embedded in a stationary scanner.

 

Bar Code Reader scans a bar code image, converts it into an alphanumeric value which is then fed to the computer to which bar code reader is connected.

Digital Camera

As the name specifies, these camera stores the data digitally, which then can be stored in the computer & can be stored for a long time. But it has very limited storage capacity. These are very popular because of less expensive photographs & Speed.

Light Pen

It is a pointing device which contains a photocell mounted at its tip. It senses the light from the screen when it becomes closer to the screen, & generates a pulse. So for identifying a particular location on the screen these light pens are very useful. But this is not in very much use these days.

Light pen is a pointing device which is similar to a pen. It is used to select a displayed menu item or draw pictures on the monitor screen.It consists of a photocell and an optical system placed in a small tube.

 

When light pen's tip is moved over the monitor screen and pen button is pressed, its photocell sensing element detects the screen location and sends the corresponding signal to the CPU.

Scanner

The scanner is an input device like the photocopier machine which makes the electronic copy of the picture or document which can be further edited.

Scanner is an input device which works more like a photocopy machine. It is used when some information is available on a paper and it is to be transferred to the hard disc of the computer for further manipulation.

 

Scanner captures images from the source which are then converted into the digital form that can be stored on the disc.These images can be edited before they are printed.

Mic's OR Microphones

The scanner is an input device like the photocopier machine which makes the electronic copy of the picture or document which can be further edited.

 

Microphone is an input device to input sound that is then stored in digital form. The microphone is used for various applications like adding sound to a multimedia presentation or for mixing music.

 

Magnetic Ink Card Reader(MICR)

MICR input device is generally used in banks because of a large number of cheques to be processed every day. The bank's code number and cheque number are printed on the cheques with a special type of ink that contains particles of magnetic material that are machine readable.

 

This reading process is called Magnetic Ink Character Recognition(MICR). The main advantages of MICR is that it is fast and less error prone.

 

Optical Character Reader(OCR)

OCR is an input device used to read a printed text. OCR scans text optically character by character, converts them into a machine readable code and stores the text on the system memory.

 

Optical Mark Reader(OMR)

OMR is a special type of optical scanner used to recognize the type of mark made by pen or pencil. It is used where one out of a few alternatives is to be selected and marked. It is specially used for checking the answer sheets of examinations having multiple choice questions.


Top University: Yale University

Summary

Yale University is a private institution that was founded in 1701. It has a total undergraduate enrollment of 5,349, its setting is city, and the campus size is 315 acres. It utilizes a semester-based academic calendar. Yale University's ranking in the 2013 edition of Best Colleges is National Universities, 3. Its tuition and fees are $42,300 (2012-13).

 

 

Yale University, located in New Haven, Conn., is known for its excellent drama and music programs, which reach outside the classroom with student organizations such as the Yale Whiffenpoofs, a famous a capella group, and the Yale Dramatic Association. The Yale Bulldogs compete in the Ivy League and are well known for their rivalry with Harvard. Students are assigned to live in one of 12 residential colleges during their time at Yale. Each college has a master and dean who live in the college and eat with students in the dining halls. Cultural houses provide a space for students to build a sense of cultural identity on campus.

 

Yale is comprised of the College, the Graduate School of Arts and Sciences, and 13 professional schools. Included in the professional schools are the top ranked Law School and highly ranked School of Management, School of Medicine , School of Art, and School of Nursing. The School of Drama, School of Forestry and Environmental Studies, and Divinity School are also well-regarded graduate programs. The "Yale Record" is the oldest college humor magazine in the nation. Dwight Hall is an independent umbrella organization that fosters student service and activism in the local New Haven community. Yale is well known for its secret societies, the most famous of which are the Skull and Bone Society, which boasts members such as George W. Bush and John Kerry, and the Scroll and Key Society. Distinguished Yale alumni include actress Meryl Streep, Washington Post reporter Bob Woodward, and actor Edward Norton.

 

Yale is both a small college and a large research university. The College is surrounded by thirteen distinguished graduate and professional schools, and...

Applying

When applying to Yale University, it's important to note the application deadline is December 31, and the early action deadline is November 1. Scores for either the ACT or SAT test are due March 1. The application fee at Yale University is $75. It is most selective, with an acceptance rate of 7.7 percent.

 

 

Academic Life

The student-faculty ratio at Yale University is 5:1, and the school has 77.2 percent of its classes with fewer than 20 students. The most popular majors at Yale University include: Political Science and Government, General; Economics, General; History, General; Psychology, General; and Biology/Biological Sciences, General. The average freshman retention rate, an indicator of student satisfaction, is 99.0 percent.

 

Student Life

Yale University has a total undergraduate enrollment of 5,349, with a gender distribution of 49.9 percent male students and 50.1 percent female students. At this school, 88.0 percent of the students live in college-owned, -operated, or -affiliated housing and 12.0 percent of students live off campus. Yale University is part of the NCAA I athletic conference.

 

Campus Info & Services

Yale University offers a number of student services including nonremedial tutoring, women's center, placement service, health service, and health insurance. Yale University also offers campus safety and security services like 24-hour foot and vehicle patrols, late night transport/escort service, 24-hour emergency telephones, lighted pathways/sidewalks, and controlled dormitory access (key, security card, etc). Of the students at Yale University, 5 percent have cars on campus. Alcohol is permitted for students of legal age at Yale University.

 

Paying for School

At Yale University, 56.0 percent of full-time undergraduates receive some kind of need-based financial aid and the average need-based scholarship or grant award is $40,894.

Paying for college doesn't have to be difficult or devastating. Go to the Paying for College knowledge center to get advice on raising cash and reducing costs.


Top University: Princeton University

Summary

Princeton University is a private institution that was founded in 1746. It has a total undergraduate enrollment of 5,249, its setting is suburban, and the campus size is 600 acres. It utilizes a semester-based academic calendar. Princeton University's ranking in the 2013 edition of Best Colleges is National Universities, 1. Its tuition and fees are $38,650 (2012-13).

 

 

Princeton, the fourth-oldest college in the United States, is located in the quiet town of Princeton, N.J. Within the walls of its historic ivy-covered campus, Princeton offers a number of events, activities, and organizations. The Princeton Tigers, members of the Ivy League, are well known for their consistently strong men’s and women’s lacrosse teams. Students live in one of six residential colleges that provide a residential community as well as dining services but have the option to join one of the 12 eating clubs for their junior and senior years. The eating clubs serve as social and dining organizations for the students who join them. Princeton’s unofficial motto, "In the Nation’s Service and in the Service of All Nations," speaks to the university’s commitment to community service.

 

Princeton includes highly ranked graduate programs through the Woodrow Wilson School of Public and International Affairs and School of Engineering and Applied Sciences. Princeton, along with Harvard and the University of Virginia, eliminated its early decision program in 2006 in an attempt to create a more equal opportunity admissions process for applicants of all socioeconomic backgrounds. One unique aspect of Princeton’s academic program is that all undergraduate students are required to write a senior thesis. Notable alumni include U.S. President Woodrow Wilson; John Forbes Nash, subject of the 2001 film A Beautiful Mind; model/actress Brooke Shields; and First Lady Michelle Obama. According to Princeton legend, if a student exits campus through FitzRandolph Gate prior to graduation, he or she may be cursed never to graduate.

 

Princeton University is unique in combining the strengths of a major research university with the qualities of an outstanding liberal arts college. Whether...

Applying

When applying to Princeton University, it's important to note the application deadline is January 1, and the early action deadline is November 1. Scores for either the ACT or SAT test are due January 1. The application fee at Princeton University is $65. It is most selective, with an acceptance rate of 8.5 percent.

 

Academic Life

The student-faculty ratio at Princeton University is 6:1, and the school has 70.6 percent of its classes with fewer than 20 students. The most popular majors at Princeton University include: Economics, General; Political Science and Government, General; History, General; Public Policy Analysis, General; and Operations Research. The average freshman retention rate, an indicator of student satisfaction, is 98.0 percent.

 

Student Life

Princeton University has a total undergraduate enrollment of 5,249, with a gender distribution of 50.5 percent male students and 49.5 percent female students. At this school, 97.0 percent of the students live in college-owned, -operated, or -affiliated housing and 2.0 percent of students live off campus. Princeton University is part of the NCAA I athletic conference.

 

Campus Info & Services

Princeton University offers a number of student services including nonremedial tutoring, women's center, health service, and health insurance. Princeton University also offers campus safety and security services like 24-hour foot and vehicle patrols, late night transport/escort service, 24-hour emergency telephones, lighted pathways/sidewalks, and controlled dormitory access (key, security card, etc). Alcohol is permitted for students of legal age at Princeton University.

 

Paying for School

At Princeton University, 59.4 percent of full-time undergraduates receive some kind of need-based financial aid and the average need-based scholarship or grant award is $35,654.

 

Paying for college doesn't have to be difficult or devastating. Go to the Paying for College knowledge center to get advice on raising cash and reducing costs.


Find Age Of A Person Based On DOB In Excel

Today, I am going to share with you an interesting set of formula which can be used to find the exact age of a person based on DOB.

 

You can used below excel formula exactly on your excel sheet to find the age of a person.

 

 

=TEXT((NOW()-B2)&""," yy ""Years"" m ""Months"" dd ""Days""")

 

In above example you can assume that you have mentioned your DOB in B2 column. To enter current date in your excel sheet you can use CTRL+; shortcut key. It will insert current date in system format after that you change this date in your DOB.


Top 25 Very Useful Excel Keyboard Shortcuts 2013

 

1. To format any selected object, press ctrl+1
2. To insert current date, press ctrl+;
3. To insert current time, press ctrl+shift+;
4. To repeat last action, press F4
5. To edit a cell comment, press shift + F2
6. To autosum selected cells, press alt + =
7. To see the suggest drop-down in a cell, press alt + down arrow
8. To enter multiple lines in a cell, press alt+enter
9. To insert a new sheet, press shift + F11
10. To edit active cell, press F2 (places cursor in the end)
11. To hide current row, press ctrl+9
12. To hide current column, press ctrl+0
13. To unhide rows in selected range, press ctrl+shift+9
14. To unhide columns in selected range, press ctrl+shift+0
15. To recalculate formulas, press F9
16. To select data in current region, press ctrl+shift+8
17. To see formulas in the worksheet, press ctrl+shift+` (ctrl+~)
18. While editing formulas to change the reference type from absolute to relative vice versa, press F4
19. To format a number as currency, press ctrl+shift+4 (ctrl+$)
20. To apply outline border around selected cells, press ctrl+shift+7
21. To open the macros dialog box, press alt+F8
22. To copy value from above cell, press ctrl+’
23. To format current cell with comma formats, press ctrl+shift+1
24. To go to the next worksheet, press ctrl+shift+pg down
25. To go to the previous worksheet, press ctrl+shift+pg up


Top University: Harvard University

Summary


Harvard University is a private institution that was founded in 1636. It has a total undergraduate enrollment of 6,657 and its setting is city. It utilizes a semester-based academic calendar. Harvard University's ranking in the 2013 edition of Best Colleges is National Universities, 1. Its tuition and fees are $40,866 (2012-13).


Harvard is located in Cambridge, Mass., just outside of Boston. Harvard’s extensive library system houses the oldest collection in the United States and the largest private collection in the world. There is more to the school than endless stacks, though: Harvard’s athletic teams compete in the Ivy League, and every football season ends with "The Game," an annual matchup between storied rivals Harvard and Yale. At Harvard, on—campus residential housing is an integral part of student life. Freshmen live around the Harvard Yard at the center of campus, after which they are placed in one of 12 undergraduate houses for their remaining three years. Although they are no longer recognized by the university as official student groups, the eight all-male "final clubs" serve as social organizations for some undergraduate students; Harvard also has five female clubs.

In addition to the College, Harvard is comprised of 13 other schools and institutes, including the top-ranked Business School and Medical School and the highly ranked Graduate Education School, School of Engineering and Applied Sciences, Law School, and John F. Kennedy School of Government. Eight U.S. presidents graduated from Harvard College, including Franklin Delano Roosevelt and John F. Kennedy. Other notable alumni include Henry David Thoreau, Helen Keller, Yo-Yo Ma, and Tommy Lee Jones. In 1977, Harvard signed an agreement with sister institute Radcliffe College, uniting them in an educational partnership serving male and female students, although they did not officially merge until 1999. Harvard also has the largest endowment of any school in the world.

Applying

When applying to Harvard University, it's important to note the application deadline is January 1, and the early action deadline is November 1. Scores for either the ACT or SAT test are due March 6. The application fee at Harvard University is $75. It is most selective, with an acceptance rate of 6.3 percent.

Academic Life

The student-faculty ratio at Harvard University is 7:1, and the school has 78.0 percent of its classes with fewer than 20 students. The most popular majors at Harvard University include: Economics, General; Political Science and Government, General; Psychology, General; English Language and Literature/Letters, Other; and Social Sciences, General. The average freshman retention rate, an indicator of student satisfaction, is 97.5 percent.

Student Life

Harvard University has a total undergraduate enrollment of 6,657, with a gender distribution of 50.1 percent male students and 49.9 percent female students. At this school, 98.0 percent of the students live in college-owned, -operated, or -affiliated housing and 2.0 percent of students live off campus. Harvard University is part of the NCAA I athletic conference.

Campus Info & Services

Harvard University offers a number of student services including nonremedial tutoring, women's center, placement service, health service, and health insurance. Harvard University also offers campus safety and security services like 24-hour foot and vehicle patrols, late night transport/escort service, 24-hour emergency telephones, lighted pathways/sidewalks, student patrols, and controlled dormitory access (key, security card, etc). Alcohol is permitted for students of legal age at Harvard University.

Paying for School

At Harvard University, 60.1 percent of full-time undergraduates receive some kind of need-based financial aid and the average need-based scholarship or grant award is $41,507.

Paying for college doesn't have to be difficult or devastating. Go to the Paying for College knowledge center to get advice on raising cash and reducing costs.

Booting-Up Your Computer Fast

Does your Windows computer take really long to start-up?

 

Well, you are not alone with this problem but fortunately, with some minor tweaks, you can get your sluggish Windows to start much faster without re-installing Windows or adding any new hardware.

 

The logic is fairly simple. Your computer loads quite a few software programs and services during start-up (look at all the icons in your Windows System tray). If you can trim this list, your computer’s boot time will decrease.

 

I have been testing a free utility called Soluto and it helped reduce the start-up time of my Windows computer from 3.15 minutes to around 1.25 minutes. All this with a few easy clicks and without confusing the user with any technical jargon.

 

 

After you install Soluto, it sorts your start-up programs list into three categories:

 

  • No-brainer – remove these programs from start-up with giving a second thought.
  • Potentially removable – another list of start-up programs that may also be removed provided you know what these programs do.
  • Required – Certain programs and services are required to run Windows properly and therefore should not be removed.

 

Depending upon the software app, you may then either choose “Pause” to completely remove that app from the start-up queue or choose “Delay” when you want the app to run automatically but not immediately at start-up. Soluto will launch the “delayed” app once the boot up is over and your system is idle.

 

You can also hover the mouse over any program name and Soluto will display the number of seconds that the app adds to the start-up time. And don’t bother about making mistakes because Soluto has a useful “Undo all” feature that will restore the start-up list to the original state with a click.

 

 

Once you are done classifying your start-up programs list, reboot the computer and you should notice a difference between the start-up time.

 

Where to download Soluto?

The official site for Soluto is soluto.com but in order to download the program, you should head over to mysoluto.com.


What Is Input And Output Devices Of Computer?

Input And Output Devices Of Computer
Input And Output Devices Of Computer
In computing, input/output or I/O is the communication between an information processing system (such as a computer) and the outside world, possibly a human or another information processing system. Inputs are the signals or data received by the system, and outputs are the signals or data sent from it. The term can also be used as part of an action; to "perform I/O" is to perform an input or output operation. I/O devices are used by a person (or other system) to communicate with a computer. For instance, a keyboard or a mouse may be an input device for a computer, while monitors and printers are considered output devices for a computer. Devices for communication between computers, such as modems and network cards, typically serve for both input and output.

Note that the designation of a device as either input or output depends on the perspective. Mouse and keyboards take as input physical movement that the human user outputs and convert it into signals that a computer can understand. The output from these devices is input for the computer. Similarly, printers and monitors take as input signals that a computer outputs. They then convert these signals into representations that human users can see or read. For a human user the process of reading or seeing these representations is receiving input. These interactions between computers and humans is studied in a field called human–computer interaction.

In computer architecture, the combination of the CPU and main memory (i.e. memory that the CPU can read and write to directly, with individual instructions) is considered the brain of a computer, and from that point of view any transfer of information from or to that combination, for example to or from a disk drive, is considered I/O. The CPU and its supporting circuitry provide memory-mapped I/O that is used in low-level computer programming, such as the implementation of device drivers. An I/O algorithm is one designed to exploit locality and perform efficiently when data reside on secondary storage, such as a disk drive

Interface
An I/O interface is required whenever the I/O device is driven by the processor. The interface must have necessary logic to interpret the device address generated by the processor. Handshaking should be implemented by the interface using appropriate commands (like BUSY, READY, and WAIT), and the processor can communicate with an I/O device through the interface. If different data formats are being exchanged, the interface must be able to convert serial data to parallel form and vice-versa. There must be provision for generating interrupts and the corresponding type numbers for further processing by the processor if required.

A computer that uses memory-mapped I/O accesses hardware by reading and writing to specific memory locations, using the same assembly language instructions that computer would normally use to access memory.

Higher-level implementation
Higher-level operating system and programming facilities employ separate, more abstract I/O concepts and primitives. For example, most operating systems provide application programs with the concept of files. The C and C++ programming languages, and operating systems in the Unix family, traditionally abstract files and devices as streams, which can be read or written, or sometimes both. The C standard library provides functions for manipulating streams for input and output.

In the context of the ALGOL 68 programming language, the input and output facilities are collectively referred to as transput. The ALGOL 68 transput library recognizes the following standard files/devices: stand in, stand out, stand errors and stand back.

An alternative to special primitive functions is the I/O monad, which permits programs to just describe I/O, and the actions are carried out outside the program. This is notable because the I/O functions would introduce side-effects to any programming language, but this allows purely functional programming to be practical.

Port-mapped I/O
Port-mapped I/O requires the use of instructions which are specifically designed to perform I/O operations.

Choosing The Right RAM For Computer

We’ve looked at the relationship between CPU speed and overall PC speed. Basically, the faster the CPU, the faster the PC will run applications. Think of your CPU like a car engine. The bigger the engine, the more power the car will have.When the PC isn’t working very hard, you might not notice this extra CPU power (you don’t notice that a car has a big engine when you are driving at 30 mph, but you do notice it when the going gets tough).

If CPU power is analogous to the size of an engine in a car, then RAM is comparable to the overall size of a vehicle. In much the same way that you can get more people into a big car, if you have more RAM you can run more programs simultaneously. Engine size is still important if the vehicle is going to drive smoothly under a heavy load.


In this chapter, we are going to be looking at RAM, different RAM types, and how much RAM you should install into your PC.

Understanding RAM

RAM (an acronym for random access memory) is a working memory space that PCs use to load data and programs that are regularly accessed. The data stored in RAM can be accessed in any order (hence the word “random”) as opposed to, say, data stored on magnetic tapes, which has to be read sequentially (this format is uncommon nowadays other than for backups). The “random” in the name is a historical throwback much like the terms “hard” drive and “floppy” drive (early floppy disks were made of soft material and were floppy).

The main reason for loading data into RAM as opposed to accessing data directly off the hard drive is that it’s much faster to access data from RAM than it is from a hard drive.To give you an idea of just how different the access speeds are, data access speeds from a hard drive are measured in milliseconds (thousands of a second); RAM access speeds are measured in nanoseconds (billionth of a second).

There’s another crucial difference between RAM and hard drives.While there’s no doubt that RAM is much faster than hard drives, hard drives have the upper hand when it comes to capacity.While hard drives can now be measured in hundreds of gigabytes, RAM modules are at mostly around 1 GB. Commonly used RAM modules sizes range from 128 MB to 512 MB. RAM comes in the form of memory modules (or chips) mounted on circuit boards. These circuit boards are fitted onto the motherboard via the RAM module slots on the board, known as banks.


It used to be that RAM modules had to be installed in pairs of similar modules, so if you wanted a PC that had 64 MB of RAM you had to install two 32 MB modules. Three drawbacks of this system were that:

You always needed two modules instead of one, which meant that manufacturers had to keep a larger inventory of modules. An upgrade sometimes meant throwing away two modules.There was twice the chance of being affected by a faulty memory module when adding new RAM modules. 

Technology has progressed and now modules can be installed singly, which is both cheaper and less hassle overall. However, be aware that you might get better performance from having RAM in both banks because the motherboard makes use of a technology known as “dual-channel.”

Types of RAM

A number of different types (or styles) of RAM are available. These different types come about from advances in technology as older types are replaced by newer, faster technologies. Here you’ll take a tour of the RAM types supported by current motherboards. This means that if you are using this book to help you upgrade a current system, the RAM you have may not be mentioned here.

DDR

Currently, the most popular type of RAM in use is called DDR RAM. DDR stands for “Double Data Rate” and the “double” comes from the fact that it utilizes technology that makes it twice as fast as regular SDRAM (Synchronous Dynamic Random Access Memory) upon which it was based.

DDR does this amazing trick of being able to transfer data at twice the standard operating speed of the RAM by transferring data on every rising edge and falling edge of the clock pulse. This is a huge advantage compared to SDRAM. For example, if you assume a clock speed of 100 MHz, SDRAM will transfer data only on every rising edge of the clock pulse, thus having an effective transfer rate of 100 MHz. DDR, being able to transfer data at the rising and falling edge of the clock pulse, has an effective transfer rate of 200 MHz.

Keeping everything else equal, this doubling of the transfer rate alone represents a huge gain in performance. However, as with most things, more was demanded from RAM.

DDR2

The “2” in DDR2 refers to the fact that this new technology again represents a doubling of the data transfer rate when compared to DDR. This additional doubling of the speed of the RAM is due to improvements made on the chip rather than additional transfers made per clock cycle.

DDR2 also requires less power than DDR and SDRAM, reducing system power consumption and heat generated (making it handy in laptops).

Deciding How Much RAM to Install

After you know what kind of RAM your system needs (or you decide to use a vendor to supply the right RAM), you come to the question of how much RAM to install.

Modern motherboards can all take in excess of 1 GB of RAM, while the smallest RAM module you can buy these days is 128 MB.Typical motherboard limits are somewhere around 1 to 3 GB. Don’t try to exceed this figure because things will go wrong (at the very least your system won’t recognize any amount over the limit, the worst case scenario being that it won’t boot up at all).

So, your motherboard maximum is one ceiling to bear in mind. However, there’s another memory limit, and that is the one imposed by the operating system you plan to install.

Conclusion

In this tutorial, we’ve looked at RAM and its function in a PC. We’ve also looked at the different types of RAM available (DDR and DDR2) and what these differences mean. We’ve seen how to ensure compatibility between motherboard and RAM modules and how you can get the right amount of RAM for your new system.

Choosing A Perfect CPU And Motherboard?

If there is one thing that keeps people from even considering building their own PCs, it’s the confusion that exists over CPUs (central processing units, also known as processors) and motherboards. As you will see, there is a whole raft of considerations to take into account, so people often come away from looking in stores or catalogs with the feeling that it’s easy to make a costly mistake by buying something wrong.
 

In this tutorial, I will lift this veil of confusion and explain what all the different technologies and options really mean.

CPUs and Motherboards: The Brain and Nervous System of Your Computer
The CPU is the brain of the PC. This is the component where the data processing is carried out and where all the instructions are interpreted. This single component is at the heart of everything a PC does.

If the CPU is the brain, then the motherboard is the nervous system, responsible for carrying data to and from other devices in the PC and connected to it. The CPU fits into the motherboard via a socket called a ZIF socket. (ZIF stands for Zero Insertion Force, and the hundreds of pins on the base of the CPU are designed to slip effortlessly into the socket.)

The motherboard provides the circuitry that forms the pathways between the CPU and the RAM, hard drives, optical drives (CD/DVD drives), expansion cards, and other devices. As well as carrying data to and from other components, the motherboard is responsible for carrying power to these devices.
 
Both of these components are crucial to a PC and getting the right components will make the difference between an excellent PC, a good PC, and a poor PC.

CPU Terminology: The Roots of Confusion
Give people a set of choices and, rather than giving them options, you just end up confusing them! When it comes to choosing a CPU, a flurry of questions spring into mind, and these aren’t readily answered:
  1. Why is there more than one option?
  2. What’s the difference?
  3. What are the pros and cons of each?
  4. Which is best for me?
CPUs are one area that causes people a lot of confusion and frustration. Basically, there are two major corporations competing in the PC arena. These are:
  1. AMD
  2. Intel
Both AMD and Intel make world class CPUs. Both make CPUs that cover the whole consumer spectrum: budget CPUs, low-power consumption CPUs for mobile devices, midrange CPUs, and high-performance CPUs. Both manufacturers are very popular.
So what’s the difference?

The Difference between CPU Manufacturers
The bottom line is that there’s in fact very little difference between CPU manufacturers. Just as there are dozens of car companies all selling cars, the same is true of CPUs, but instead of there being dozens of companies manufacturing and selling CPUs, there are only two companies making and selling CPUs for the PC market: AMD and Intel. In fact, it’s quite possible that if there were half a dozen or so CPU manufacturers, consumers would be more comfortable with the idea that AMD and Intel are competing manufacturers as opposed to making products that work differently.

One of the reasons that consumers are confused by the difference between Intel and AMD products and have a belief that the CPUs are very different comes from the fact that the Apple Macintosh computers are so fundamentally different from the PC—so different that the Windows operating system won’t run on a Macintosh. (However, Apple has now recently announced a shift from CPUs made by IBM to CPUs made by Intel, so things are bound to change.)

Choices, Choices, Choices . . .
From a point of view of performance and power, a case can be argued for both AMD and Intel CPUs.Take a look at computer magazines or surf the web for info, and you’ll come across reams of reports and tests and comparisons—some independent, some not. Some will conclude that AMD CPUs (or more specifically, a particular AMD CPU) are better than Intel CPUs and that consumers looking for a good deal should choose AMD. Then within minutes, you’ll come across another report or test that says that an Intel CPU is best and that’s the CPU of choice and everyone should go for an Intel CPU.

Opinions are everywhere. The media, web, magazines, and newspapers fill their pages with them. And most are just that—opinions.

The truth is that both companies make powerful and reliable CPUs.Take two PCs of similar specification, and it’s impossible to tell the difference without actually looking at the CPU or using software to tell you what it is.

For the purposes of this book, we are going to assume that there are no performance or power differences between AMD and Intel CPUs. For the project in the book, we will be using an AMD CPU, but you are free to choose either AMD or Intel for the PC you build. No matter which you choose, you’ll get a high-quality CPU.

The Real Difference Is . . .
The real differences between AMD and Intel CPUs are in the underlying architecture of the CPU. This is the inner circuitry of the CPU, what makes it work.

A modern CPU is a mind-bogglingly complicated piece of engineering, and it crams a lot of sophisticated technology into a small space. Just as a Ford and Ferrari both have four wheels, have seats, and use an internal combustion engine to take people from A to B and back to A again, AMD and Intel do the same thing, but in different ways.

You can’t take an engine out of a Ford and expect it to fit directly into a Ferrari, and the same is true of AMD and Intel CPUs. One of the main differences between the two manufacturers is that each CPU requires a specific motherboard.

What This Means to You
This means that no matter which CPU brand you choose, you need to make sure that the motherboard is designed to support the CPU. (That brand is, for example, whether you choose an Intel CPU or an AMD one. Each manufacturer will have a number of CPUs available covering the whole range, from budget to high performance.) And not only do you need to get a motherboard that’s compatible with the CPU manufacturer you’ll need a motherboard that’s compatible with the type of CPU that you want.

If you want to use an Intel CPU then you need an Intel-compatible motherboard. If you go the AMD route, then you’ll have to have an AMD-compatible board. There’s no point buying a CPU and then buying a random motherboard—there’s a good chance it won’t be compatible. After you know that your CPU brand is compatible with your motherboard, you need to make sure that your CPU model works with your motherboard. This is where things begin to get a little complicated, and you have to be careful so as not to make a mistake that could cost you money. Motherboards are designed to support a particular range of  CPUs and no others. This is very specific, and it’s important to get it right. Generally, it’s not possible to fit an incompatible CPU onto a motherboard, but this doesn’t stop people trying and then damaging the CPU, motherboard or both in the process. The main controlling factor is the CPU socket type.

Motherboards and CPUs are closely linked, and this makes future upgrading of a CPU or motherboard difficult. CPUs change regularly, and every year or so new ones will replace the old and the manufacturers quickly stop making the old model, preferring to sell the newer technology. This means that as a general rule of thumb, if you try to upgrade a PC that is more than a year old, any upgrade involving the CPU or motherboard will be difficult because you will need to change both for them to be compatible (and there’s a good chance that you’ll need to swap out the RAM too at the same time).

RAM upgrades are much easier because manufacturers continue making old types of RAM long after the technology has been superseded.

Both Intel and AMD make motherboards, but don’t be restricted by thinking that they are the only ones—there are half a dozen or so good motherboard manufacturers. Just a few of the names to look out for are:
  1. ASUS
  2. Abit
  3. Gigabyte
  4. Microstar
  5. MSI
  6. Tyan
  7. DFI
So, you either have to choose a CPU and get a motherboard to match or choose a motherboard and get a matching CPU.We recommend that you choose the CPU first because there are more considerations to take into account when buying a CPU than there are when buying a matching motherboard. Because of this we’re now going to move on to examining how to choose the right CPU for you.
 
The Important Differences between CPUs
Let’s take a look at some of the differences between CPUs that actually make a difference. These include:
  1. Speed
  2. Socket types
  3. Cache (built-in memory)
  4. Dual-core/hyper-threading/64-bit processors
CPU Speed
The most significant difference among CPUs is the speed. That is, how fast it can process instructions? The faster it can process instructions, the faster we perceive the PC to be.
Every PC is regulated by an internal clock. This clock regulates the rate at which instructions are processed by the CPU. This is known as clock cycles, and it determines the interval between successive instructions. The smaller the interval, the faster the CPU can process instructions and the faster the perceived speed.
 
CPU Sockets
Remember how we said that the socket the CPU fits into determines the type of motherboard you can use? The reason for this is because CPUs fit onto the motherboard via a socket. The pins on the CPU have to fit into a specific socket on the motherboard. Different CPUs have different pin configurations and, therefore, need to be fitted into a different socket.
Cache
When looking through specifications on CPUs, you will undoubtedly come across mention of “cache,” “on-board cache,” “on-die cache,” or “L1” and “L2” cache. These terms all refer to the amount of memory built into the CPU. The more memory that is built into the CPU, the faster the CPU and the better the performance.

The size of the cache varies for different CPUs, from 256 KB for the lower performance budget CPUs to 1 MB for high-performance CPUs such as the AMD Athlon 64.

Dual-Core/Hyper-Threading/64-Bit Processors
AMD and Intel both have a range of processors called “dual-core,” which basically means two CPUs in one that offer greater power. Intel on the other hand has Hyper-Threading Technology; this allows the CPU to run some applications faster because it can run multiple computer instructions in parallel, which increases speed.

Motherboard Features
Now that you’ve looked at the different kinds of CPU available and looked at the terminology that cloaks them, it’s time to take a look at the motherboard.
 

There are two types of motherboard features—standard features that are found on every motherboard and additional features only found on some motherboards.

Standard Motherboard Features
Standard motherboard features include:
  1. CPU socket
  2. RAM slots
  3. Chipset
  4. PCI expansion card slots
  5. AGP/PCI Express expansion slot (for video adaptor)
  6. Hard drive/optical drive connectors (IDE/SATA)
  7. Floppy drive connector
  8. Power connectors (to accept power from the PSU)
  9. Connectors for CPU and case fans
  10. Keyboard socket
  11. Mouse port
  12. Serial/parallel port
  13. USB ports
Most people wonder what the battery on the motherboard does. This battery serves two purposes: it powers the PC system clock that keeps track of the date and time, and it also provides power to the CMOS (complimentary metal oxide semiconductor) to store the BIOS (basic input/output system) settings.

These batteries are very reliable and will last for many years.

Optional Motherboard Features
Additional features that may or may not be present on a motherboard (depending on price and quality) include:

On-board video adapter: Buying a motherboard with an on-board video adaptor saves on your having to purchase a separate video adaptor. On-board video adaptors are usually poorer quality and provide less power than a separate video adaptor, but they are ideal for office PCs or PCs that play low-specification games.

On-board video adaptors use a portion of system RAM for graphics processing (usually between 8 and 64 MB, the more RAM they use, the better they perform) so you might want to purchase additional RAM for the system. (See Chapter 5, “Choosing the Right RAM.”)

On-board modem: For those who still use a modem or connect to the web or send faxes, this can save on having to buy a separate modem.

On-board network adapter: More and more PCs connect to a network nowadays, and an on-board network card can be a useful feature.

Additional USB ports: With so many USB devices you can’t get enough USB ports!

FireWire ports: Some devices (especially video cameras and external hard drives/optical drives) either require a FireWire port or can make use of either a USB or FireWire port. Having a couple of FireWire ports on a system is handy in case they are needed in the future.