CS25C03 Essentials of Computing
UNIT - I
Computers: Computer, Characteristics of Computers, History of Computers,
Classification of Computers, Applications of Computers, Basic Organization of a Computer.
Data Representation, Using spread sheets for basic operations on data and visualize the data.
Practical: 1. Office Software for documentation and presentation
2. Spread sheets for calculations and data. Visualization
Computer:
A computer is an electronic device that processes data, following instructions provided
by software programs. It takes input, processes it, stores information, and produces output to
perform various tasks. Essentially, it's a machine designed to handle information and execute
calculations or operations based on pre-defined instructions.
Characteristics of Computers:
Speed
Accuracy
Reliability
Diligence
Memory
Versatility
Automation
No intelligence or feelings
History of Computers:
The history of computers spans thousands of years, from early counting devices to the
powerful systems we use today. Here's an overview of the key milestones in the evolution of
computers:
Classification of Computers:
Computers can be classified in several ways, including by size, type (data processing method),
and purpose.
1. Classification by Size:
Supercomputers:
The most powerful, largest, and fastest computers, used for complex tasks like weather
forecasting, scientific simulations, and large-scale data analysis.
Mainframe computers:
Large, powerful computers capable of handling massive amounts of data and supporting
numerous users simultaneously. Used in large organizations like banks and insurance
companies.
Minicomputers:
Smaller and less powerful than mainframes, often used by small to medium-sized
businesses or as servers.
Microcomputers:
The smallest and most common type, including personal computers (desktops, laptops),
smartphones, and embedded systems.
2. Classification by Functionality:
Digital computers:
The most common type, processing data in discrete, digital form (binary code, 0s and 1s).
Analog computers:
Process data that is continuous and variable, like voltage or temperature.
Hybrid computers:
Combine the features of both digital and analog computers, often used in specialized
applications like process control.
3. Classification by Purpose:
General-purpose computers:
Designed for a wide range of tasks, such as word processing, spreadsheets, and web
browsing.
Specific-purpose computers:
Designed for a particular task or set of tasks, like those used in scientific research or
industrial control.
4. Based on Performance:
Workstations:
Handle demanding tasks.
Servers:
Manage resources and data for multiple users.
5. Based on Data Handling:
Batch processing:
Handles large data sets at scheduled times.
Real-time systems:
Process data instantly as it's received.
Applications of Computers:
Basic Organization of a Computer:
A computer's basic organization consists of five key functional units: the input unit, the
memory unit, the arithmetic logic unit (ALU), the control unit, and the output unit. These units
work together to process data and instructions, enabling the computer to perform various tasks.
1. Input Unit:
This unit is responsible for receiving data and instructions from the outside world,
typically via devices like keyboards, mice, or scanners.
2. Memory Unit:
This unit stores both data and instructions that the computer is actively using. It's
divided into primary storage (RAM) for quick access and secondary storage (hard
drives, SSDs) for long-term storage.
3. Arithmetic Logic Unit (ALU):
The ALU performs arithmetic (addition, subtraction, etc.) and logical (AND, OR, NOT)
operations on data.
4. Control Unit:
This unit acts as the "brain" of the computer, fetching instructions from memory,
decoding them, and coordinating the activities of all other units to execute those instructions.
5. Output Unit:
This unit displays or transmits the results of processing to the user, typically through
devices like monitors, printers, or speakers.
These five units, along with the bus system that connects them, form the fundamental
structure of a computer system. They work together to process information and produce
meaningful results.
Spreadsheets like Microsoft Excel or Google Sheets are widely used tools for data
representation, performing basic operations, and visualizing data.
Data Representation:
Organized Structure:
Data is organized in a grid of rows and columns, with individual cells for specific data
points.
Data Types:
Spreadsheets accommodate various data types, including numbers, text, dates, and
formulas.
Labeling:
Rows and columns are typically labeled to provide context and identify the data they
contain.
Basic Operations:
Data Entry and Editing:
Users can directly input and modify data within cells.
Calculations:
Spreadsheets excel at performing mathematical operations using formulas and functions
(e.g., SUM, AVERAGE, MAX, MIN).
Sorting and Filtering:
Data can be sorted in ascending or descending order based on specific columns, and
filtered to display only relevant data based on criteria.
Conditional Formatting:
Rules can be applied to automatically format cells based on their values, highlighting
trends or outliers.
3. Data Visualization:
Chart Creation:
Spreadsheets offer a wide array of chart types (e.g., bar charts, line graphs, pie charts,
scatter plots) to visually represent data.
Chart Customization:
Charts can be customized with titles, labels, legends, colors, and styles to enhance
clarity and impact.
Dynamic Updates:
Charts automatically update when the underlying data in the spreadsheet is modified.
Visual Analysis:
Charts facilitate the identification of patterns, trends, and relationships within the data
that might not be apparent in raw numerical format.