Wednesday, March 10, 2021

Computer Fundamental, Types of Computer:

 Types of Computer:

Work:

1. Analog computer – Physical quantity, it handles the continuous data/signal. E.g. Speedometer, thermometer, weather forecasting, scientific calculation, pressure and ala etc.

2. Digital computer: 0, 1 (digital form), it is work on counting system. E.g. IBM 1401, HP, Acer, Dell, Samsung etc.

3. Hybrid Computer: Analog + digital (both counting and measure). E.g. Jet Plane, Control planet, Modem, Simulation, Petrol pump, ECG etc.

Size: 

1. Mainframe computer: Very large/ huge size of computer. Speed grather than 100 MHz

2. Super computer: Fastest and most powerful computer, 16-20 processor used, 64 bit word length, 1 TB RAM, storage minimum more than PB, capacity is more than 10 GHz

3. Minicomputer: Mid-range computer, smaller than mainframe, super and larger than microcomputer, support hundred user/network.

4. Microcomputer: Smallest computers than other, cheap computer. E.g. Desktop, laptop computer.

Purpose:

1. General purpose

2. Special purpose

Brand: 

1. IBM PC

2. IBM compatible

3. Apple/ Macintosh/Mac

Model: 

1. XT Computer (Extended Technology) , speed is 4.77 MHz, slow/cannot support advance software.(In 1983 developed by IBM)

2. AT computer (Advance Technology), faster than XT computer, run latest version software, speed is 100 MHz, made in 1985 GUI used windows.

3. PS/2 computer (Personal System), high storage capacity than AT.

Operating:

1. Client server

2. Peer to peer (p2p)

Application of computer:

The information may be presented to you in the form of text, images, video clips etc.

Application areas:

1. Education

2. Entertainment

3. Sports

4. Advertising

5. Medicine

6. Science and Engineering

7. Office

8. Home

Computer Fundamental, Generation of Computer:

 Generation of Computer:

1. FIRST GENERATION (1945-1956)

Technology – Vacuum Tube

Speed – Millisecond

Language – Machine Language

Memory – Primary (Magnetic core memory), secondary (Magnetic drum, Magnetic tape)

Input – Punched card

Output – Paper

Example: Harvard Mark 1, Whirlwind, ENIAC, EDSAC, UNIVAC I, UNIVAC II, UNIVAC 1101, RCA BIZMAC, NCR CRC 102A, NCR CRC 102 D, HONEYWELL DATAMATIC 1000, IBM (604,650,701,702,704,705,709).

2. SECOND GENERATION (1956-1965)

Technology – Transistor

Speed – Microsecond

Language – Assembly language

Memory – Primary (Magnetic core), Secondary (Magnetic drum)

Input – Punched card

Output – Paper

Example: IBM 1401, IBM1400, IBM1794, IBM 1620, IBM 7094, CDC 164, CDC 1604, CDC 3600, UNIVAC 1108, LEO MARK III, RCA 501


3. THIRD GENERATION (1966-1975)

Technology – Integrated Circuit (IC), LSI

Speed – Nanosecond

Language – HLL (High Level Language), like FORTAN, COBOL, PASCAL, C, C++ etc.

Memory – Primary (Semiconductor memory), Secondary (Magnetic tape, Magnetic disk, like floppy disk, hard disk)

Input – Keyboard

Output – Monitor

Example: IBM SYSTEM (360, 3, 7, 370, 108), UNIVAC 900, ICL 9000 SERIES, HONEYWELL 200, PDP-8, MINICOMPUTER, TDC 316.

4. FOURTH GENERATION (1975 – PRESENT)

Technology – VLSI, Microprocessor

Speed – Pico second

Language – HLL, problem oriented language

Memory – Primary (semi- conductor memory), Secondary (Magnetic tape, Magnetic disk, Optical memory, CD/DVD, Flash memory (pen drive, memory card)

Input – Keyboard, Mouse, Scanner, digitizers

Output – Monitor, Plotter, Printer

Example: IBM System 370, HP-3000, AMD Athelon, Pentium, PDP 11, Accer, Dell, Samsung, IBM desktop PC, Mac book.

5. FIFTH GENERATION COMPUTERS (PRESENT – FUTURE)

Technology – AI (artificial intelligence), Bio chips, organic chips

It is called future generation.

Parallel processing/voice/ data integration.

Voice recognition system.

Neural network/Natural language can understand used.

Prolog programming language used.

Large storage capacity.

Multi point input/output system.

Computer Fundamental, History of computer

 History: 

1. 3000 BC – Abacus – Chinese people – China – Earliest counting and calculating device (First mechanical calculating device).

2. 1617AD – Napier’s bones – John Napier – The invention was used for multiplying, dividing, and taking square roots and cube roots with Napier’s bones were multiplication tables written on strips of wood or bones.

3. 1622 – Slide rule – William Oughtred – The slide rule also known as mechanical analog computer.

4. 1642 – Pascaline – Blaise Pascal – invented a mechanical calculator add and sub.

5. 1673 – Leibniz’s calculator – Wilhelm Von Leibniz – improved version of Pascal calculator add, sub, multiply, divide and roots.

6. 1801- Punch card- Joseph Marie Jacquard – invents a mechanical loom.

7. 1821 - Charles Xavier Thomas de Colmar - first commercially successful digital mechanical calculator – Arithmometer.

8. 1822 – Difference Engines – Charles Babbage – Father of computer.

9. 1837 – Analytical Engine – Charles Babbage.

10. 1840 – Boolean algebra – George Boole.

11. 1843 – Machine algorithm – Ada Lovelace – First computer programmer.

12. 1890 – Tabulating Machine – Hermann Hollerith – invented the tabulating machine an electrical device, used punch card.

13. 1904 – Fleming Valve or vacuum tube diode – John Ambrose Fleming.

14. 1906 – Triode – Lee de forest.

15. 1927 – Analog Computer – Vannevar Bush and his 2 colleagues.

16. 1936 – German engineer – Konrad Zuse – Z1 computer – first freely programmable computer. 

17. 1942 – Electronic digital computer (ABC) – John Atanasoff & Berry – first electronic special purpose digital computer ABC started being developed by Atansoff and Cliff berry in 1937-1942.

18. 1943 – Colossus – Tommy Flowers & Allen Coombs.

19. 1944 – Harvard Mark I – Howard Aiken & Grace Hopper.

20. 1946 – ENIAC – John Mauchly and John Presper Eckert.

21. 1947 – Transistor – William Shockely, John Bardeen & Walter Brattain.

22. 1949 – Magnetic core – Wang – Magnetic core memory.

23. 1949 – EDSAC – Maurice Wilkes – first stored program computer was built.

24. 1951 – UNIVAC 1 – J. Presper Eckert and John Mauchly – first commercial computer in the US.

25. 1956 – Hard disk – IBM team led by Reynolds Johnson – father of disk drive – used in IBM 305 computers.

26. 1957 – PC – IBM (John Lentz) – the first PC was built IBM-610 for office use.

27. 1958 – Integrated circuit (IC) – Jack St. Clair Kilby & Robert Noyce – commercially available since 1961.

28. 1964 – Mouse and Windows – Douglas engelbart – developed the GUI and pointing device.

29. Compact Disk – James Russell.

30. 1965 – Minicomputer – Kenneth H. Olsen – first minicomputer 12-bit PDP-8.

31. 1970 – Bubble memory – Andrew Bobeck.

32. 1971 - Floppy disk - IBM engineers led by Alen Shugart - first 8-inch floppy disk was used in IBM 3330 computer.

33. 1971 - Intel 4004 - Intel (Federico Faggin, Ted Hoff, and Stan Mazor) - first single chip 4-bit microprocessor.

34. 1973 - Intel 8008 - Intel - first commercial assembly computer.

35. 1975 - Microcomputer - Ed Roberts - father of microcomputer.

36. 1975 - Microsoft - Bill Gates and Allen - manufacture of computer software and hardware.

37. 1976 - Seymour Cray - Cray 1 - first super computer.

38. 1979 - Laptop - William Moggridge - England.

39. 1981 - DOS - Microsoft - MSDOS operating system - IBM PC - Intel - 8088 microprocessor.

40. 1985 - MS Windows - Microsoft - first GUI for IBM Computer.

41. 2009 - Microsoft - Windows 7.

42. 2011 - Google - Google chrome OS.

43. 2015 - Microsoft - Windows 10.

History of computer in Nepal

1. 2018 BS FACIT - used for census.

2. 2028 BS - IBM 1401 - second generation mainframe computer used for census.

3. 2031 BS - NCC established.

4. 2038 BS - ICL 2950/10 second generation mainframe computer used for census.


Computer Fundamental, Computer definition:

 Computer is an electronic data processing device which accepts and stores data as input processes the data and generates the output in a required format.

Note: (“Computer” comes from the Latin word “compute” or   “computare”, which means to calculate.)

Saturday, May 2, 2020

Computer hardware setup

COMPUTER HARDWARE

1. What is Computer?
 Ans: Device which store data, process data, access data according to users need.
Computer = Hardware + Software

2. What is Hardware?
Ans: Physical components of computers.

3. What is Software?
Ans: Logical components of computers.

4. How Computer works?
Input Devices
Process Devices
Output Devices
Keyboard
Mother Board
Monitor
Mouse
Memory
Printer

5. SMPS (Switch Mode Power Supply)
-          It can call as a power house of computer.
-          It reduces the amount of voltage. (220VAC to 12VDC)
(AC = Alternate Current / DC = Direct Current)

6. Mother Board / Logic Board / System Board
-          Mother Board gets the power supply from SMPS.
-          Other devices get the power supply from mother board.
-          Mother Board contents other devices.

7. CPU (Central Processing Unit)
-          Brain of the Computer
-          It Control all devices.

8. Ports and Connectors

i) VGA Port: - 15 pin port arranged in 3 rows to connect monitor (CRT- Cathode Ray Tube Monitor)
15 Pin VGA Port
 
         


ii) DVI Port: - 24 pin port arranged in 3 rows to connect LCD monitors (LCD – liquid Crystal Display – Lab top Monitor)
24 Pin DVI Port
 


iii) PS2/Port –
-          Used to connect PS/2 mouse and PS/2 keyboard                                                             
6 Pin PS/2 Port
 
                                                                                                                                                                           

iv) Serial Port / COM Ports: -                                                                                       
-          9 pin connector is used to connect serial mouse and 25 pin connector is used to connect serial printer, scanner & external devices.                                      
-          Port which allow only one bit at a time.                                               
-          Used to connect communication device. (COM Port – Communication Port)

v) USB Port –
-          It supports 127 devices can be connect in to the USB port. Basically there two USB ports. They are: -
a.       USB 1.1 – speed is 12mbps
b.       USB 2.0 – speed is 480mbps
USB Port
 
 


vi) Parallel Port / Printer Port / LPT Port (LPT = Line Printer) –
-          Port which allow one byte at a time.
-          25 pin female port to connect printer, scanner & external devices.

25 Pin Parallel Ports (Female)
 
               
vii) Game Port –
-          15 pin female connector arranged in 2 rows to connect joystick.
15 Pin Game Ports (Female)
 
 

               
viii) Key Board Port –
-          5 Pin DIN Connector

5 Pin DIN Connector
 
                 


9. Opening BIOS (Basic Input Output System)
®     Immediately after power on press the associated key.
Desktop PC:        F2, F2+DELETE
Laptop: F1, F2, CTRL+ESC, F2+DELETE
®     Import BIOS setting

1. Date and time: - If date and time is always shown incorrectly it means we need to change CMOS battery.

2. Integrated Ports: - If necessary we can enable/disable any built in ports of motherboard. Example: Audio, LAN, USB, Serial, and Parallel.

3. Drive setting: - After connecting hard drives, CD/DVD drives BIOS will auto-detect them. After assembling a new computer we need to confirm whether these devices are shown in BIOS.

4. Boot sequence/ Boot device priority
·         This is the order in which BIOS will search for a boot device to load OS
·         When installing fresh OS we need to set 1st boot device as DVD/Pen drive and second boot device as hard disk.
5. Security Password:
                a. Supervisor password: - BIOS only
                b. User password: - Full security
®     To reset password
Method 1: - Switch off system, remove all power cables and remove battery for a few seconds and reconnect. All BIOS settings will be reset.
Method 2: - Switch off replace BIOS jumper on motherboard from normal to recovery and switch on.
-          BIOS will auto open and we can set new password
-          Save and switch off replace jumper to normal
6. Save and Exit (F10)
7. Exit without Saving (ESC)
v  Date and time: - standard BIOS features
v  Integrated peripherals – enable/disable
v  Boot device priority >Advance BIOS features -1st boot device – enable/disable
v  BIOS Security: - Load fails defaults -> Automatic setting. And Load optical
10. Operating System installation (Vista, 7, 8, 10)
Step1. Go to BIOS and set first boot device CD/DVD, Pen drive and second boot device Hard disk.
Step2. Press any key to boot (5 second)
-          Language
-          Time and currently
-          Keyboard (US)
-          Click next
-          Select window edition (Home, Pro, enterprise etc.)
Step3: Window KO lagi minimum 10 GB compulsory.
-          Create required number of partitions
-          Select C: drive and next.
-          Use expression setting.
11. Device driver Installation: -
®     After installing OS we need to install device drivers.
®     To check driver status > right click on computer icon and select manage from list select device manager
®     If a device name shows yellow exclamation mark it means we need to install its driver. (Drive pack solutions)
®     Driver manager
®     Setting Export mode.
12. Ultra ISO:
®     This is used to create copies of CD/DVDs
®     This image can later disk’s
®     Before burning we can also add extra files
Step to make Image
Step1: Insert original DVD
Step2: Open ultra ISO
Step3: Select making CD/DVD image
Step4: Select location to save file.
Step5: select type of image file (recommended ISO)
Step6: Click on make.
Steps to burn Images
Step1: Insert blank CD/DVD
Step2: Open Ultra ISO
Step3: Select file > Open > Open Image file to burn
Ste4: If necessary add files
Step5: select tools > burn CD/DVD Image
Step6: Select speed > click on burn.
12. Download RUFUS 2.5 Pen drive bootable:
13. VMWARE: -
®     This is used to create virtual computers
®     A virtual computer is a logical computer that run’s within a host OS
®     A virtual computer can be installed with any OS as required by user.
®     It can be used for many purposes such as application testing, network testing, to make multiple server is a single computer, easy multi booting software: - Virtual 1Box, Virtual PC, Hyper V.
Steps of create Virtual machine:
Step1: Create a new virtual machine
Step2: Typical select >Next >
Step3: Select installer disk Image > click on browser > Select image file > Open > Next.
Step4: Give a name and select location to save.
Step5: Give size for hard disk (Minimum 10 GB)
               Store virtual disk as a single file
Step 6: Finished
                (One window to another window to free the mouse CTRL+ALT key press)
Online drive installation:-
Google Search > Online drp
Website: http://drp.su/
14. System Properties: - write click on my computer select properties
®     It will display general information about system such as OS version, CPU, RAM and windows activation status.
®     Select advanced system setting
®     a) computer name tab
®     Here we can see the current name of computer
®     We can set a description about use of computer.
®     To give a new name > click on change > give a name > ok> ok> restart on a computer.
®     B) Hardware: -
®     This will allow us to open device manager
®     Also we can set automatic driver installation.
®     C) Remote: -
®     Here we can enable or disable remote desktop and remote assistance
®     D) advanced tab
®     Here we can set settings for performance.
®     We can also change virtual memory setting.
®     Virtual Memory: -
®     This is a file in hard disk that will function like RAM
®     When settings virtual memory minimum size = physical Memory *1.5
®     Max size = Physical memory*3
®     Only one virtual memory is required.

15. System protection: -
®     This is used to create system restore point
®     Restore point will create a backup of all current system settings and it can be later used to restore computer to a working state setting > copy

16. Computer Management: -
1. Task scheduler
®     This can be used to run selected programs automatically at the set date and time.
Step1: Create basic Task
Step2: Given name > Mohan > Next
Step3: select required timing
Step4: Start program
Step5: Windows system32 calc.exe > next > finish.

17. Local users and groups: -
1. Local users:-
®     Here we can create user accounts and user groups User accounts
®     It is a combination of a name and password used for security
Three types of users exist in windows: -
i. Administrator
ii. Standard
iii. Guest
®     to create a standard user right click on users folder > new user
®     give a user name, full name and description
®     give password and confirm it
®     set my required account option
®     click on create
®     To make user as administrator
Step1: open properties of user account
Step2: select member of tab
Step3: click on Add > type administrators > Ok
Step4: select users from list and remove >ok
 2. Users groups: -
®     It is used to organize users according to department
®     Also allows us to easily apply security settings
®     Right click on groups > new group > give name
®     Click on add > type username to make member > Ok > create.

18. Disk management: -
®     This can be used to create/ delete/ format divers
®     To create a new drive there must be a free space
®     Also we can change drive letter names
®     We can also create mounted volumes

19. Command Prompt DOS (Disk Operating System)
GUI (Graphical User Interface)
CUI (Character User Interface)
CCI (Command Line Interface)
Run>cmd>Enter.
1. dir: - this is used to view all items in current location
Syntax: dir >Enter
to view in page wise order
Syntax: dir/p>Enter
to view according to name
Syntax: dir_w*>Enter
to search according to file extension
Syntax: dir_*.exe
to view hidden items
Syntax: dir/ah>Enter
cls>Enter – clean screen
2. cd (change directory)
This is used to open or close folders
Syntax: cd_foldername>Enter
To close folder
Syntax: cd…>Enter
To close all open folders at once syntax: cd\ [enter]
3. md
Used to create new folders
Syntax: md_ “foldername” [enter]
4. copy con
This is used to create new text files but can’t be used to edit
Syntax: copy_con_name.txt [Enter]
To save press F6 [Enter]
5. type
This is used to open and view text files
Syntax: type_filename [Enter]
6. edit command
This can be used to create new text files and also to edit them
Syntax: edit_filename.text
7.ren
It is used to rename file or folder
Syntax: ren_current name_new name
8. del
It is used to delete files only
Syntax: del_file name
9.rd
It is used to delete folders only
Syntax: rd_file name
Is a folder has files inside
Syntax: rd_filename_/s
10. move
Used to cut/paste from one location to another location
Syntax: move_filename_location
11. attrib
This is used to change file attributes
+ Means enable
-          Means disable
H – hidden, S – system, R  read only
To make file (folder as hidden
Syntax: attribute_th_filename
To unhide
Syntax: attrib_ -h-filename
13. +h+s file name -> hidden files
14. Shutdown
r-restart, l – logoff, S – shutdown
syntax: shutdown=s
shutdown cancle – a
15. help
This will display list of DOS command
16. Exit,date, time, color, format
Syntax: format_drive
e.g.: format_drive
17. ./?
This will display help for specific commands
20. Group Policy: -
Run > gpedit.msc > [Enter]
-          This can used to lock certain parts of OS from users.
1. hiding drivers: -
-          Open administrative templates folder.
-          Open windows components
-          Select file explorer folder or window explorer
-          From list open hide list these specified in my computer.
-          Select enabled > select drive >Enter.
2. lock drives in my computer
-          Prevent access to drives from my computers
-          Enabled select C: drive > Enter.
        3. disabling DOS
-          Admin >system > prevent access to command prompt >Enter
-          Select enable click >Enter
4. Control panel lock
-          Control panel >pronibit access to control panel and PC setting
-          Select enabled click ok.
5. Desktop lock.
-          Admin > desktop> hide an disable all items on the desktop.
-          Select enabled > Ok.
6. Disable Run command
-          Admin > start menu and taskbar
-          Remove run menu from start menu.
-          Select enabled > ok.
7. Disabling task manager
-          System > CTRL+ALT+DEL
-          Remove task manager
-          Select enabled >Ok.
8. RSOP(resultant set of policy
-          This will show all enabled group policy settings
-          Run>rsop.msc>ok.

21. NTFS (New Technology File System) Features: -

1. Compression (WinZip, winrer, 7zip):
Steps:
A: open properties of file /folder
B: select advanced
C: select option to compress> ok>ok
Note: don’t compress C: drive, because then OS will not load.

2. Encryption: -
-          This is used to lock our files/folders
-          Only the user who has locked it can open it
Note: administrator user can decrypt any users file /folder
Steps
A: open properties of file/folder
B: select advanced
C: select option to encrypt> ok> ok

3. Disk quota: -
-          This is used to limit the amount of free space that users can access in a drive.
-          Open properties of drive
-          Select quota> show quota setting
-          Enable quota management
-          Deny disk space to users exceeding quota limit.
-          Select default quota limit for new users.

4. NTFS file/folder permissions: -
®     Permissions have a allow and deny setting
®     Permissions can be assigned to users or groups
®     Permission can be set by administrator and owner of file/folder

Types of permissions:
a. Read: - this will only allow user to open and view. User cannot edit or delete.
b. read and execute: - this will allow user to open and run program only. User cannot delete.
c. write: - User can create new files and edit them. User cannot edit or delete files which belong to other users.
d. modify: - User can create, edit and delete all files/folders. User cannot change permissions.
e. Full control: - this will allow user to perform all actions and also user can also change permissions.
f. list folder contents (folder only): - this will allow user to browse into subfolders only. Always negative takes over positive setting. Any permission given to applied to all subsystem also in case of folders.
Steps:-
1. Open properties of folder and file.
2. Select security tab >Edit
3. Click on add type user name or group name.
4. Set required permission.
5. System tools: -

1. Task management: - [CTRL+SHIFT+ESC]
- This can be used to view currently running programs and we can also manage them.
- We can set CPU affinity to control how many cores of CPU will run a program (temporary).
- We can check system performance CPU usage and RAM usage.
- We can manage startup programs.

2. Disk management tools: -
a. Check disk: - This sill scan file system trouble for errors and it will automatically repair them.
b. defragmenter: - This will try to arrange fragmented files in hard disk to speed up read process. It is recommended to run this at least once a month.
3. Disk cleanup: - This is used to search and delete unnecessary files include temporary installation files temporary internet files, etc.
Start > Programs> Accuracies >tools – search box [disk cleanup]
4. PSR (Problem Screen Recorder): -
Run > PSR
5. WinRAR: - (3rd part application): - this is used to compress files/foldeers.
Steps:
1. Right click and file /folder and select add to archive automatic
2. Select compression method. (Fast, normal, best)
3. Lock to archive
4. Free from create 5FX archive
5. Password set > Advanced >set password >ok.
21. System maintenance: -
1. Registry editor: - This will allow us to backup and restore windows registry.
                Open Run > type regedit >ok.
2. Backup file: -
- Select file menu.
- Select location give a name > Save.
- Backup copy > Import.
3. System protection: -
                Right click on the computer icon to select properties >ok.
4. Backup and restore: - This will create a full image of C: drive which will contain all files of the drive. This will allow us to restore OS, drivers, applications and users filed in one step.
Steps:
1. Open control panel.
2. Select backup and restore
3. Create a system image
4. Select location to Save and click next >ok.

22. Hiren Boot 15.2

1. Image backup: -
®     Open mini windows.
®     Open HBCD menu.
®     Open program > Backup > Ghost > Ghost32
®     Select local > part ion > To Image
®     Select system reserve drive and C: drive.
®     Select location to save Image.
             
             2. Password reset: -
®     Open mini windows
®     Open HBCD menu.
®     Select program > password/keys >Active password changes.
®     Select next > next > User name > Save.
                
            3. Driver backup: -
®     Open windows
®     Insert hiren boot DVD
®     Open DVD
®     Open HBCD menu.cmd
®     Programs > Device driver > Double driver (Backup)
®     Select Backup
®     Scan current system
®     Backup now
®     Select location > ok.

Microsoft Excel

Limitation of Excel: Maximum number of Row: 65,536(office 2003) and 1048576(office 2007) Maximum number of column: 256 (office 2003) and 163...