OFFICE AUTOMATION
UNIT –I
Introductory concepts: Memory unit– CPU-Input Devices: Key board, Mouse and Scanner.
Output devices: Monitor, Printer. Introduction to Operating systems & its features: DOS–
UNIX–Windows. Introduction to Programming Languages.
UNIT -II
Word Processing: Open, Save and close word document; Editing text – tools, formatting,
bullets; SpellChecker - Document formatting – Paragraph alignment, indentation, headers and
footers, numbering; printing– Preview, options, merge.
UNIT -III
Spreadsheets: Excel– opening, entering text and data, formatting, navigating; Formulas–
entering, handling and copying; Charts–creating, formatting and printing, analysis tables,
preparation of financial statements, introduction to data analytics. Printing, analysis tables
preparation of financial statements, introduction to data analytics.
UNIT -IV
Database Concepts: The concept of data base management system; Data field, records, and files,
Sorting and indexing data; Searching records. Designing queries, and reports; Linking of data
files; Understanding Programming environment in DBMS; Developing menu drive applications
in query language(MS–Access).
UNIT-V
Power point: Introduction to Power point - Features –Understanding slide typecasting &viewing
slides – creating slide shows. Applying special object – including objects & pictures –Slide
transition–Animation effects, audio inclusion, timers.
, UNIT –I
INTRODUCTORY CONCEPTS
Memory Units
A memory unit is an integral component of a computer system that stores data, instructions, and
information.
It is the work area for the Central Processing Unit (CPU), where data and instructions are stored for
quick access.
The capacity of a memory unit is typically measured in bytes, and it comes in various sizes depending
on the requirements of the system.
Importance of Memory Units
1) Speed: Memory units make it possible to store and retrieve instructions and data quickly, which
reduces processing instances and boosts overall system performance.
2) Temporary storage: Memory units serve as temporary storage for data and programs that are
currently in use, allowing users to quickly move between programs and files without waiting for data
to be loaded from a storage device.
3) Multitasking: Memory units allow computer systems and different digital devices to do many tasks
simultaneously because they can store and retrieve data for multiple programs simultaneously.
4) Reliability: Memory devices are extremely reliable because they're made to resist normal wear and
tear. They are a strong and reliable storage option because they are less vulnerable to damage from
outside forces like shock or vibration.
5) Accessibility: Memory units are readily available and can be quickly updated or changed.
6) Energy efficiency: Memory units use less power than standard hard drives, resulting in lower heat
generation and reduced cooling requirements.
Types of memory units
1. RAM (Random access memory): It is a volatile memory. The internal memory of the CPU for
storing data, program, and program result. It is a read/write memory which stores data until the
machine is working. As soon as the machine is switched off, data is erased.
2. ROM (read-only memory): It is a non-volatile memory. The memory from which we can only read
but cannot write on it. The information is stored permanently in such memories during manufacture.
The records in ROM cannot be modified, so it is secure and reliable.
3. Cache Memory: Cache memory is a volatile memory used to store data or often accessed
instructions.
4. Virtual Memory: Virtual memory is a method of increasing available memory by utilizing hard drive
space.
5. Flash Memory: Flash memory is a non-volatile memory frequently appearing in solid-nation drives,
USB drives, and memory cards.
OFFICE AUTOMATION Page 1
, 6. Registers: Registers are small, quick memory units found on the CPU. They can temporarily store
data during processing, like computation results or the content of certain memory addresses.
Measurements of memory units
Memory units are used to measure and represent data.
Computer - CPU(Central Processing Unit)
The CPU consists of the following features:
CPU is considered as the brain of the computer.
CPU performs all types of data processing operations.
It stores data, intermediate results, and instructions (program).
It controls the operation of all parts of the computer.
OFFICE AUTOMATION Page 2
, CPU itself has following three components.
Memory or Storage Unit
Control Unit
ALU(Arithmetic Logic Unit)
Memory or Storage Unit
This unit can store instructions, data, and intermediate results. It is also known as internal storage unit or
the main memory or the primary storage or Random Access Memory (RAM).
It stores all the data and the instructions required for processing.
It stores intermediate results of processing.
All inputs and outputs are transmitted through the main memory.
Control Unit
This unit controls the operations of all parts of the computer but does not carry out any actual data
processing operations.
Functions of this unit are:
It manages and coordinates all the units of the computer.
It obtains the instructions from the memory, interprets them, and directs the operation of the computer.
It communicates with Input/Output devices for transfer of data or results from storage.
It does not process or store data.
ALU (Arithmetic Logic Unit)
This unit consists of two subsections namely,
Arithmetic Section
Logic Section
Arithmetic Section
Function of arithmetic section is to perform arithmetic operations like addition, subtraction, multiplication,
and division.
OFFICE AUTOMATION Page 3
UNIT –I
Introductory concepts: Memory unit– CPU-Input Devices: Key board, Mouse and Scanner.
Output devices: Monitor, Printer. Introduction to Operating systems & its features: DOS–
UNIX–Windows. Introduction to Programming Languages.
UNIT -II
Word Processing: Open, Save and close word document; Editing text – tools, formatting,
bullets; SpellChecker - Document formatting – Paragraph alignment, indentation, headers and
footers, numbering; printing– Preview, options, merge.
UNIT -III
Spreadsheets: Excel– opening, entering text and data, formatting, navigating; Formulas–
entering, handling and copying; Charts–creating, formatting and printing, analysis tables,
preparation of financial statements, introduction to data analytics. Printing, analysis tables
preparation of financial statements, introduction to data analytics.
UNIT -IV
Database Concepts: The concept of data base management system; Data field, records, and files,
Sorting and indexing data; Searching records. Designing queries, and reports; Linking of data
files; Understanding Programming environment in DBMS; Developing menu drive applications
in query language(MS–Access).
UNIT-V
Power point: Introduction to Power point - Features –Understanding slide typecasting &viewing
slides – creating slide shows. Applying special object – including objects & pictures –Slide
transition–Animation effects, audio inclusion, timers.
, UNIT –I
INTRODUCTORY CONCEPTS
Memory Units
A memory unit is an integral component of a computer system that stores data, instructions, and
information.
It is the work area for the Central Processing Unit (CPU), where data and instructions are stored for
quick access.
The capacity of a memory unit is typically measured in bytes, and it comes in various sizes depending
on the requirements of the system.
Importance of Memory Units
1) Speed: Memory units make it possible to store and retrieve instructions and data quickly, which
reduces processing instances and boosts overall system performance.
2) Temporary storage: Memory units serve as temporary storage for data and programs that are
currently in use, allowing users to quickly move between programs and files without waiting for data
to be loaded from a storage device.
3) Multitasking: Memory units allow computer systems and different digital devices to do many tasks
simultaneously because they can store and retrieve data for multiple programs simultaneously.
4) Reliability: Memory devices are extremely reliable because they're made to resist normal wear and
tear. They are a strong and reliable storage option because they are less vulnerable to damage from
outside forces like shock or vibration.
5) Accessibility: Memory units are readily available and can be quickly updated or changed.
6) Energy efficiency: Memory units use less power than standard hard drives, resulting in lower heat
generation and reduced cooling requirements.
Types of memory units
1. RAM (Random access memory): It is a volatile memory. The internal memory of the CPU for
storing data, program, and program result. It is a read/write memory which stores data until the
machine is working. As soon as the machine is switched off, data is erased.
2. ROM (read-only memory): It is a non-volatile memory. The memory from which we can only read
but cannot write on it. The information is stored permanently in such memories during manufacture.
The records in ROM cannot be modified, so it is secure and reliable.
3. Cache Memory: Cache memory is a volatile memory used to store data or often accessed
instructions.
4. Virtual Memory: Virtual memory is a method of increasing available memory by utilizing hard drive
space.
5. Flash Memory: Flash memory is a non-volatile memory frequently appearing in solid-nation drives,
USB drives, and memory cards.
OFFICE AUTOMATION Page 1
, 6. Registers: Registers are small, quick memory units found on the CPU. They can temporarily store
data during processing, like computation results or the content of certain memory addresses.
Measurements of memory units
Memory units are used to measure and represent data.
Computer - CPU(Central Processing Unit)
The CPU consists of the following features:
CPU is considered as the brain of the computer.
CPU performs all types of data processing operations.
It stores data, intermediate results, and instructions (program).
It controls the operation of all parts of the computer.
OFFICE AUTOMATION Page 2
, CPU itself has following three components.
Memory or Storage Unit
Control Unit
ALU(Arithmetic Logic Unit)
Memory or Storage Unit
This unit can store instructions, data, and intermediate results. It is also known as internal storage unit or
the main memory or the primary storage or Random Access Memory (RAM).
It stores all the data and the instructions required for processing.
It stores intermediate results of processing.
All inputs and outputs are transmitted through the main memory.
Control Unit
This unit controls the operations of all parts of the computer but does not carry out any actual data
processing operations.
Functions of this unit are:
It manages and coordinates all the units of the computer.
It obtains the instructions from the memory, interprets them, and directs the operation of the computer.
It communicates with Input/Output devices for transfer of data or results from storage.
It does not process or store data.
ALU (Arithmetic Logic Unit)
This unit consists of two subsections namely,
Arithmetic Section
Logic Section
Arithmetic Section
Function of arithmetic section is to perform arithmetic operations like addition, subtraction, multiplication,
and division.
OFFICE AUTOMATION Page 3
