Computer Literacy Centre Alipur

Notes. SirShafiqAhmad/0312-5149916

Q1: Write the basic types of computers?

Ans:

1. Digital computer.
2. Analog computer.
3. Hybrid computer.

Q2: Write the classification of computer?

Ans:

1. Super computer.
2. Main frame computer.
3. Mini computer.
4. Micro computer.
5. Laptop.

Q3: Write the Generation of computer?

Ans:

1. First Generation. 1940 Vacuum Tubes.

2. Second Generation. 1956 Transistor.
3. Third Generation. 1963 Integrated circuit.
4. Fourth Generation. 1970 VLSI (very large-scale integration).
5. Fifth Generation. 1980 Artificial intelligence.

Q4: Write INTEL Corporation?

Ans:
1. Charles Babbage. (Founder of computer)
2. Analytic Engin. (Name of Babbage’s Computer)
3. Lady ADA. (first programmer)
4. ABACUS. (Computing device)

Q1: What is computer?

1. Ans: Computer is an election machine. Which accepts instructions. Commands

and information based on the information process the given information at ultra-high
speed and produces the result on the screen and printer.

Q2: What is DOS?

2. Ans: DOS stand for (disk operating system) dos is a nongraphical single user
operating system. It is called (CLI command line interface) or (CUI command user
interface).

Q3: What is Windows?

3. Ans: Windows includes tools that helps your computer run faster without adding
new hardware windows includes a suite of programs designed to optimize your
computers efficiency especially when used together windows is a graphical
operating [Link] it is called (GUI).

Q4: What is MS Word?

4. Ans: Ms_Word is used for documentation propose. In the program user can create
different files such as (letters, stories, application. English book, English
Composing, or other documents.

Q5: What is Excel?

5. Ans: Excel is used for calculation purpose. Which is used to solve mathematical and
other calculation problems such as mark sheet, pay sheet, utility bills etc.
 Q6: What is power point?

6. Ans: Power point is used for presentation. Slide transition, animation, graphics
designing,
Purpose. It provides more editing control. Support for audio and video better
browsing for achieved broadcasts.

Q7: What is in page?

7. Ans: Urdu in page is used for Urdu application, Urdu letter, Urdu book, Urdu
composing. In page you can also work with many of the language Urdu Arabic,
[Link] Kashmiri, hazaragi, pushtu, etc.

Q8: What is internet?

8. Ans: The internet in simple terms is a network of the interlinked computer

Networking worldwide. Which is accessible to the general public. These
interconnected computers work by transmitting data through a special type of
packet switching which is known as the IP or the internet protocol.
9. An international computer network providing email and information from computers
and educational institutions, government agencies.

Q9: What is software?

10. Ans: Software is collection of computer programs and related data that provides the
instructions for telling a computer what to do and how to do it and how to do it.
Software refers to one or more computer programs and data held in the storage of
the computer for some reasons. In other words. Software is a set of programs,
procedure, algorithms and its documentation concerned with the operation of a
data processing system. Data that has not traditionally been associated with
computers. Such as film, tapes and records.

Q10: What is hardware?

 11. Ans: Hardware refers to the physical parts of a computer system. Some basic
computer hardware includes the motherboard’s, RAM, hardware.

INTERNET

1. Inter connected-network
2. best communication way,
3. save, fast, cheap.
4. Browsing/suffering

Q1: write the Stand for of internet?

Ans:
1. PC (personal computer)
2. NIC (Network interface card)
3. HTTP ( Hypertext Transfer Protocol)
4. WWW (World Wide Web)
5. HTML (Hyper Text Transfer Protocol)

MODEM

Ans: MODEM stands for Modulator De-modulator. The purpose of MODEM is to convert digital
information to analog signals and to convert analog signals back into digital information.

Browser

1. GOOGLE CHROME
2. INTERNET EXPLORE
3. OPERA
4. MOZILLA FIREFOX
5. APPLE SAFARI
 DOS

1. C:/> go to run type CMD press Enter

Open DOS Program
2) C:/>CD.. press Enter
Close Directory
3) C:/>Time Press Enter
Check Time
4) C:/>Date press Enter
Check Date
5) C:/>dir press Enter
Check Directory
6) C:/>Dir/W press Enter
Wirth Wise Directory
7) C:/>Dir/P press Enter
Page Wise Directory
8) C:/>Dir/S/p press Enter
Check All Directory
10) C:/>Exit press Enter
Close Program
11) C:/>CLS press Enter
Clear screen
12) C:/>VOLpress Enter
Volume Serial No
13) C:/>Ver press Enter
Version No

BASIC FORMULAS EXCEL

1. How Many ROWS in Excel Sheet.

Ans: From Excel 2007 onwards (2010, 2016, etc.) we have exactly 1,048,576
rows.
2. How Many Columns in Excel Sheet.
Ans: 16,384 columns
3. How Many Columns in Excel Sheet.
Ans: how many sheets in excel workbook

4. Marks Obtained
 =sum(range)
 =Sum (D23:K23) 
5. Pass/Fail
 =if (M23>=267, “Pass”, “Fail”)
 =Sum (D23:K23) 
6. Average
 =average(range)
 =average (D23:K23) 
7. Percentage (%.)
 =obtained marks×100/Total marks.
 = (M23× 100/400)
8. Position Formula

=IF(LARGE(D$5:D$19,1) =D5,"First”, IF(LARGE(D$5:D$19,2) =D5,"Second”, IF(LARGE(D$5:D$19,3)
=D5,"Third",)))

9. Grade
 =if (%>90, “A+”, if (%>80, “A”, if (%>70, “B”, if (%>60, “C”, if (%>50, “D”, if (%>40, “E”, if
(%>30, “F”, if (%>20, “G”))))))))
 =if(N23>90, “A+”, if(N23>80, “A”, if(N32>70, “B”, if(N23>60, “C”, if(N23>50, “D”,
if(N23>40, “E”, if(N23>30, “F”, if(N23>20, “G”)))))))) 
10. Remarks
 =if (%<20, “Very poor”, if (%<30, “Poor”, if (%<40, “Satisfactory”, if (%<50, “Fair”, if
(%<60, “Good”, if (%<70, “Very good”, if (%<80, “Excellent”, if (%<90, “Exceptional”, if
(%<100, “Zabardast”)))))))))
 =if (N23<20, “Very poor”, if (N23<30, “Poor”, if (N23<40, “Satisfactory”, if (N23<50,
“Fair”, if (N23<60, “Good”, if (N23<70, “Very good”, if (N23<80, “Excellent”, if
(N23<90, “Exceptional”, if (N23<100, “Zabardast”))))))))) 

Formulas for Salary

11. House Rent

 = (Basic Pay×45/100)
 Age Formula
 =DATEDIF (B7, TODAY(),"Y") & " Years, " & DATEDIF (B7, TODAY(),"YM") & " Months, " & DATEDIF (B7, TODAY(),"MD") & "
Days"
date of birth  B75/28/1991

12. Conveyance
13. (BasicAllowancPay
=(C2×15/100)  21. Zakat Formula
14. Medical Allowance =(F10*2.5/100)
  = (Basic Pay×10/100)
 =(C2×10/100) 
15. Special Fund
 = (Basic Pay×5/100)
 =(C2×5/100) 
16. Dress allows
 = (Basic Pay×2/100)
 =(C2×2/100) 
17. Total pay (T.P)
 =Sum (Basic Pay: Special Fund)
 =Sum (C2:G2) 
18. G.P. Fund
 =Basic Pay×3/100.
 =(C2×3/100) 
19. Tax
 =if (T.P>=50000, T. P×10/100, if (T.P>=40000, T. P×8/100, if (T.P>=30000, T. P×5/100, if
(T.P>=20000, T. P×3/100, if (T.P>=10000, T. P×1/100,))))).
 =if(I2>=50000, T. P×10/100, if(I2>=40000, T. P×8/100, if(I2>=30000, T. P×5/100,
if(I2>=20000, T. P×3/100, if(I2>=10000, T. P×1/100,))))) 
20. Net Pay
 = (Total Pay-G.P. Fund-Tax)
 =(I2-J2-K2) 
 In Page

1. A-------------------- 2. b----------------- 3. n----------------------

5. j--------------------- 5. m---------------- 6. W---------------------
6. v--------------------- 7. L------------------ 8. d----------------------

Keyboard Symbols
Bit Byte Table
Short Cut
Computer Literacy Centre AliPur Islamabad / ContactNo: 0312-5149919
[Link] | [Link]