What is Computer Office Tools

 Office Tools

Application software program that help customers in ordinary workplace jobs like creating, updating and keeping files, managing massive amounts of facts, growing displays, scheduling, and many others. Are referred to as office gear. Using workplace gear saves effort and time and plenty of repetitive tasks may be accomplished without difficulty. Some of the software program that try this are −

Word processors

Spreadsheets

Database systems

Presentation software program

E-mail tools

Let us take a look at some of these in detail.

Word Processor

A software for growing, storing and manipulating textual content files is referred to as word processor. Some commonplace word processors are MS-Word, WordPad, WordPerfect, Google docs, and many others.

Word Processor

A phrase processor permits you to −

Create, store and edit files

Format textual content houses like font, alignment, font coloration, heritage coloration, and so forth.

Check spelling and grammar

Add photos

Add header and footer, set page margins and insert watermarks

Spreadsheet

Spreadsheet is a software program that assists users in processing and analyzing tabular records. It is a automated accounting tool. Data is constantly entered in a mobile (intersection of a row and a column) and formulas and capabilities to system a set of cells is effortlessly available. Some of the popular spreadsheet software encompass MS-Excel, Gnumeric, Google Sheets, and so forth. Here is a list of sports that can be accomplished within a spreadsheet software program −

Simple calculations like addition, common, counting, and so on.

Preparing charts and graphs on a group of associated records

Data entry

Data formatting

Cell formatting

Calculations primarily based on logical comparisons

Spreadsheet

Presentation Tool

Presentation tool allows user to illustrate facts broken down into small chunks and organized on pages known as slides. A series of slides that gift a coherent concept to an target audience is referred to as a presentation. The slides may have textual content, images, tables, audio, video or other multimedia records organized on them. MS-PowerPoint, OpenOffice Impress, Lotus Freelance, and many others. Are some popular presentation tools.

Presentation Tool

Database Management System

Software that manages garage, updating and retrieval of information with the aid of creating databases is known as database control machine. Some famous database control gear are MS-Access, MySQL, Oracle, FoxPro, and so on.

Database Management System 

 

Domain Specific Tools

Depending on its utilization, software can be generic or specific. Generic software is a software that can perform more than one duties in distinct eventualities with out being changed. For instance, a phrase processor software may be used by all of us to create distinct types of documents like record, whitepaper, schooling fabric, etc. Specific software is a software program for a specific software, like railway reservation device, weather forecasting, etc. Let us observe some examples of domain particular gear.

School Management System

School control machine handles the various sports of a school like exam, attendance, admission, students’ expenses, time table, teachers’ education, etc.

School Management

Inventory Management

Managing more than one sports like buy, income, order, delivery, inventory maintenance, etc. Associated with raw or processed items in any enterprise is referred to as stock control. The inventory control software program guarantees that shares are in no way below special limits and buy/deliveries are completed in time.

Payroll Software

Payroll software program handles complete profits calculations of personnel, taking care of go away, bonus, loans, and so on. Payroll software program is mostly a component of HR (human useful resource) management software in mid-sized to huge organizations.

Payroll

Financial Accounting

Financial management software keeps an digital record of all financial transactions of the organization. It has many purposeful heads like account receivables, debts payable, loans, payroll, and so on.

Financial Accounting

Restaurant Management

Restaurant management software helps restaurant managers in preserving music of stock tiers, every day orders, consumer management, worker scheduling, desk bookings, etc.

Restaurant Management

Railway Reservation System

Railway reservation gadget is a software program that handles multiple modules like teach routes, teach control, seat booking, meals reserving, teach preservation, educate status, journey programs, and so forth.

Railway Reservation System

Weather Forecasting System

Weather forecasting gadget is a real-time software program that predicts weather of an area via amassing copious quantity of live information approximately atmospheric temperature, humidity, wind stage, and so forth. It is used to expect predominant failures like earthquakes, hurricanes, tsunamis, and so forth.

Weather forecasting machine 

Number System

The approach to represent and work with numbers is called range gadget. Decimal wide variety gadget is the most not unusual number device. Other famous wide variety systems include binary quantity device, octal range machine, hexadecimal range device, and many others.

Decimal Number System

Decimal variety machine is a base 10 quantity machine having 10 digits from 0 to nine. This way that any numerical amount may be represented the use of those 10 digits. Decimal number gadget is also a positional value system. This way that the fee of digits will depend on its position. Let us take an instance to understand this.

Say we have three numbers – 734, 971 and 207. The fee of seven in all three numbers is specific−

In 734, price of seven is 7 loads or 700 or 7 × one hundred or 7 × 102

In 971, cost of 7 is 7 tens or 70 or 7 × 10 or 7 × 101

In 207, price 0f 7 is 7 units or 7 or 7 × 1 or 7 × one hundred

The weightage of every role can be represented as follows −

Decimal Number System

In digital structures, instructions are given thru electric signals; version is carried out through various the voltage of the signal. Having 10 distinctive voltages to put into effect decimal quantity system in virtual device is hard. So, many number structures which are easier to enforce digitally were advanced. Let’s examine them in detail.

Binary Number System

The simplest way to differ commands thru electric powered alerts is -nation system – on and off. On is represented as 1 and off as 0, even though 0 is not genuinely no signal however signal at a decrease voltage. The quantity machine having just those  digits – zero and 1 – is known as binary variety gadget.

Each binary digit is also called a piece. Binary number machine is likewise positional price device, where each digit has a value expressed in powers of two, as displayed here.

Binary Number System

In any binary wide variety, the rightmost digit is called least sizeable bit (LSB) and leftmost digit is known as maximum significant bit (MSB).

MSB lsb

And decimal equivalent of this quantity is sum of product of every digit with its positional price.

110102 = 1×24 + 1×23 + 0×22 + 1×21 + zero×20

= sixteen + eight + 0 + 2 + zero

= 2610

Computer reminiscence is measured in terms of how many bits it could save. Here is a chart for memory ability conversion.

1 byte (B) = 8 bits

1 Kilobytes (KB) = 1024 bytes

1 Megabyte (MB) = 1024 KB

1 Gigabyte (GB) = 1024 MB

1 Terabyte (TB) = 1024 GB

1 Exabyte (EB) = 1024 PB

1 Zettabyte = 1024 EB

1 Yottabyte (YB) = 1024 ZB

Octal Number System

Octal number device has 8 digits – 0, 1, 2, three, four, 5, 6 and seven. Octal variety machine is also a positional cost gadget with in which each digit has its fee expressed in powers of eight, as proven here −

Octal Number System

Decimal equal of any octal variety is sum of product of each digit with its positional fee.

7268 = 7×eighty two + 2×81 + 6×eighty

= 448 + 16 + 6

= 47010

 

ASCII

Besides numerical records, computer ought to be able to deal with alphabets, punctuation marks, mathematical operators, special symbols, and so on. That form the entire character set of English language. The entire set of characters or symbols are referred to as alphanumeric codes. The complete alphanumeric code commonly includes −

26 higher case letters

26 lower case letters

10 digits

7 punctuation marks

20 to 40 special characters

Now a computer knows simplest numeric values, whatever the range device used. So all characters have to have a numeric equivalent known as the alphanumeric code. The maximum extensively used alphanumeric code is American Standard Code for Information Interchange (ASCII). ASCII is a 7-bit code that has 128 (27) possible codes.

Hexadecimal Number System

Octal quantity system has sixteen symbols – 0 to 9 and A to F where A is equal to 10, B is same to 11 and so forth till F. Hexadecimal range device is likewise a positional cost gadget with where every digit has its fee expressed in powers of 16, as proven right here −

Hexa Number System

Decimal equal of any hexadecimal variety is sum of product of every digit with its positional fee.

27FB16 = 2×163 + 7×162 + 15×161 + 10×one hundred sixty

= 8192 + 1792 + 240 +10

= 1023410

Number System Relationship

The following table depicts the relationship between decimal, binary, octal and hexadecimal range systems.

HEXADECIMAL DECIMAL OCTAL BINARY

0 zero zero 0000

1 1 1 0001

2 2 2 0010

3 3 3 0011

4 four four 0100

5 5 five 0101

6 6 6 0110

7 7 7 0111

8 8 10 1000

9 9 11 1001

A 10 12 1010

B eleven thirteen 1011

C 12 14 1100

D 13 15 1101

E 14 16 1110

F 15 17 1111

ASCII Code

ISCII

ISCII stands for Indian Script Code for Information Interchange. IISCII become advanced to guide Indian languages on pc. Language supported by using IISCI encompass Devanagari, Tamil, Bangla, Gujarati, Gurmukhi, Tamil, Telugu, and many others. IISCI is commonly utilized by government departments and earlier than it could trap on, a brand new standard encoding trendy known as Unicode became delivered.

Unicode

Unicode is an global coding gadget designed to be used with special language scripts. Each person or symbol is assigned a unique numeric value, largely within the framework of ASCII. Earlier, every script had its personal encoding machine, which could battle with every other.

In assessment, that is what Unicode officially goals to do − Unicode provides a unique quantity for each man or woman, regardless of what the platform, irrespective of what the program, regardless of what the language.