Posts

Microsoft Excel - All Notes

            Introduction to Microsoft Excel   Spreadsheet : A spreadsheet is a program that is used to organize, store, and analyze data in a table made of rows and columns. Example: MS-Excel, Google Sheets, LibreOffice Calc, Apple numbers, etc.  What is MS-Excel? MS Excel is a spreadsheet program developed by Microsoft for windows ,Mac OS, Android ,etc. It contains a number of columns and rows, where each intersection of a column and a row is called a cell.                                                      In MS-Excel, we can perform various financial operations, mathematical calculations, text-based operations, sorting & filtering of data, and displays graphs and charts. Important Points: The development of MS-Excel started in 1985, and Microsoft officially launched Excel 2.0 for windows in 1987. The main ...

C Programming Tutorial

Image
                 C Programming Tutorial                        History of  C Programming  ▪︎ C is a procedural Programming language that was invented by Dennis Ritchie at AT & T bell Laboratory in 1972. ▪︎AT & T Stands for American Telegraph and Telecommunications. This Lab is located in USA. ▪︎ It is derived from BCPL(Basic Combined Programming Language) and B Language. ▪︎ This Language were out updated from market due to type Less Language (No data type concept). ▪︎ C is said to be Mother Language because all language are derived from C language. ▪︎ C is written with in Assembly Language. ▪︎ Its main objective is to developed system software, such as Operating System, Compiler, Interpreter, Linker and Loader ,etc. ▪︎ It is most popular due to portability it means c program can be executed on any Operating system, such as Windows, Unix, etc. ▪︎      ...

Define hardware and types

Image
       What is Hardware in Simple words?    Hardware is the Physical Components that we can touch, view and feel.                       It is the physical parts of the computer.       Ex:-  Keyboards,  Mouse, RAM Printer, Speakers, ROM, Hard disk ,etc.         There are Four types of Hardware.  1. Input Device  2. Process Device 3. Output Device  4. Storage Device                What is Input Device?   The device through which we can feed or input the data or instructions into the computer are called Input Device.   Example:-  Keyboard, Mouse, Scanner, Joystick, MICR(Magnetic Ink Character Recognition), OMR(Optical Mark Reader), Digital Camera,  Mike,etc.  Keyboard:  Keyboard is an input device  which is used to enter data or information into the computer by pr...

Computer Memory Unit

Image
            What is Computer Memory? Those unit that provides an area for the processors or any other devices is called memory unit. It is used to store data ,instructions and Information.   Memory unit is the hardware parts of computer. It stores the data or information Temporary or permanently.  How many types of Computer Memory? There are two types of Compute r Memory. 1. Primary Memory  2. Secondary Memory    What is  Primary Memory? Primary memory is the only type memory that is directly accessed by the CPU. from 1954. Magnetic core memory became the dominate technology to we used as primary memory of computers. After that RAM is used as primary Memory. It is the firstly memory that stores the data and instructions. There are two types of Primary Memory.   RAM,(Random Access Memory)  ROM(Read only Memory)         What is  RAM(Random Access Memory) RAM is a volatile storage area withi...

Computer Fundamentals

Image
            Basic Fundamental of Computer.                        What is computer? The word 'Computer' comes from the word 'Compute ',Which means 'to count' or 'to calculate ' . A Computer is an electronic device that takes input from user , process the data and gives the desired result (output). It performs both mathematical and non-mathematical operations.  It follows the principle of GIGO -Garbage In, Garbage Out (If wrong input is given, output will also be wrong).             Characteristics of Computer  1. Speed :-   Computers works very fast.  It can perform millions or billions of instructions in just one second.  What takes humans hours can be done by a computer in seconds or milliseconds. Example: Solving 10,000 math problems in a few seconds. 2.  Accuracy:  A computer is highly accurate. It gives correct results if t...

Computer Language & Programming Techniques.

Image
                            What is  COMPUTER LANGUAGE? ▪︎ A Computer language is the mean by which instructions and data are transmitted to the computer. ▪︎ In other words, computer languages are the interface between a computer and its user .         Categories of Computer Language. The Computer Language can be classified into four categories: 1. First Generation Language (Machine Language) 2. Second Generation Language (Assembly Language) 3. Third Generation Language (High Level Language) 4. Fourth Generation Language (Modern Language   First Generation Language(  Machine Language):- ▪︎ It is the only language that a computer can understand. It is expressed in binary form i.e. '0' and '1'.  ▪︎ Machine Language has the advantage of very high speed and very low memory utilization. But understanding and learning machine language is a tough and tiresome process.  ▪︎ This lan...