ADVANTAGES OF ELECTRONIC SPREADSHEETS OVER TYPEWRITERS

1/4/2019

WHAT ARE ELECTRONIC SPREADSHEETS?

An electronic spreadsheet is a software with worksheets made of cells that can save, edit. format and manipulate numeric values automatically.

WHAT ARE TYPEWRITERS?

A typewriter is an analogous machine with keys for producing characters, numerals and symbols on a piece of paper.

WHAT ARE THE MERITS OF SPREADSHEETS OVER TYPEWRITERS?

Electronic spreadsheets have inbuilt formula and functions that enhances accuracy and efficiency. Typewrites don't
Electronic spreadsheets produces neat work because all editing is done on the screen before the final copy is printed.
Electronic spreadsheets have inbuilt formatting features such as:
1. change color
2. bolding
3. underline
4. italics
5. font size etc.
Electronic spreadsheets special editing features such as:
1. alignment
2. spacing
3. spelling and grammar checkers
4. page layout
5. background appearance etc.
Electronic spreadsheets allow users to work with graphics and images to represent data.
Electronic spreadsheets can be transmitted from one place to another quickly and electronically
Electronic spreadsheets have inbuilt security and privacy measures to protect data
Electronic spreadsheets can be reprogrammed to meet certain demands and standards of an organization.
Electronic spreadsheets can be imported or exported between machines. This allows the user to share sheets in multiple software packages of the same type or different types
Electronic spreadsheets have special pre-edited sheets called templates that makes user's work easier.
Electronic spreadsheets are empowered with database features that lets the user search, sort and manipulate data easily. such as:
1. find and select
2. sorting
3. filtering
4. automatic recalculations (forecasting)
Electronic spreadsheets allow users to insert comments such as users instructions and help
Electronic spreadsheets allow users to create, save, retrieve and print worksheets

Images courtesy of Pinterest

0 Comments

What is a cell in relation to Spreadsheets?

6/11/2018

0 Comments

Briefly explain the following terms: Cell, Range, Label, Value, Function

Expected Response

A cell is an editable area of a spreadsheet where a column meets a row. Editable in this case means where the user can enter text.
Contents in a cell can either be values, labels or formula/function

a Value is a figure which can be mathematically manipulated
labels are not mathematically manipulated
Formula/Functions are instructions used to manipulate values and return a feedback
- However a function is in-built while a formula is user defined.
A group of two or more cells make up a range.

0 Comments

Students sat for a test in computer studies

6/11/2018

0 Comments

Students sat for a test in computer studies. The table gives the marks obtained and the number of students obtaining the marks. Write a program in a structured high-level language to calculate the mean of the result. The formula for the mean is given below.

Marks obtained (x)	Number of students (f)
10	1
15	2
20	6
25	5
30	10
35	6
40	4
45	2
50	1
55	1

EXPECTED RESPONSE;

Program mean;
Var
Sumxf,sumf:integer
Mean:real;
Begin
Sumxf:=(10*1)+(15*2)+(20*6)+(25*5)+(30*10)+(35*6)+(40*4)+(45*2)+(50*1)+(55*1);
Sumf:=1+2+3+4+10+6+4+2+1+1;
Mean:= sumxf/sumf;
Writeln(mean);
Readln;
End.

State two requirements of computer programming testing.

23/8/2018

0 Comments

Testing of a program should not be miscued with system implementation and testing of SDLC stages.
Testing of a program is also called debugging and its done by programmers unlike system testing phase done by Quality assurance professionals.

Expected Response

For debugging to take place, the programmer needs the following tools.

Debugging software
Compiler/code interpreter

STATE TWO REQUIREMENTS OF COMPUTER PROGRAMMING TESTING.

0 Comments

Explain the difference between Random Access Memory (RAM) and Read Only Memory (ROM).

19/8/2018

0 Comments

EXPLAIN THE DIFFERENCE BETWEEN A SYSTEM SOFTWARE AND APPLICATION PROGRAMS - kcse computer studies analysis of questions

16/8/2018

0 Comments

To effectively establish the difference between system software and application programs, we should define the two.

0 Comments

previously: USING A PROGRAM FLOWCHART, EXPLAIN THE “WHILE...DO” INTERACTION CONSTRUCTION

Functions of the UPS (Uninterruptible Power Supply)

POWER SUPPLY UNIT

Definition of UPS

The power supply unit (UPS) also called the fly wheel backup, is an electric gadget that regulates power as it enters into the computer's physical parts such as the chassis and the monitor.

Uses of UPS

It regulates/stabilizes/filters/cleans power as it enters into the computer to avoid damaging the computer.
Has a battery that temporarily holds power (approximately 15-45 minutes for desktops) which can be used if the mains power fails to allow the user to save his/her work.
Alerts the user when the mains power fails. This helps the user to quickly save her/his work.

Related gadgets

Automatic Voltage Switcher [AVS]
Powerguard
AC Adaptors

explain_2_uses_of_uninterruptible_power_supply_unit.pdf
File Size:	114 kb
File Type:	pdf

ANALYSIS OF KCSE COMPUTER STUDIES TOPICAL QUESTIONS & REVISION KITS

ADVANTAGES OF ELECTRONIC SPREADSHEETS OVER TYPEWRITERS

WHAT ARE ELECTRONIC SPREADSHEETS?

WHAT ARE TYPEWRITERS?

WHAT ARE THE MERITS OF SPREADSHEETS OVER TYPEWRITERS?

What is a cell in relation to Spreadsheets?

Briefly explain the following terms: Cell, Range, Label, Value, Function

Expected Response

Students sat for a test in computer studies

Students sat for a test in computer studies. The table gives the marks obtained and the number of students obtaining the marks. Write a program in a structured high-level language to calculate the mean of the result. The formula for the mean is given below.

Marks obtained (x)

Number of students (f)

EXPECTED RESPONSE;

Related Searches

State two requirements of computer programming testing.

Expected Response

Explain the difference between Random Access Memory (RAM) and Read Only Memory (ROM).

EXPLAIN THE DIFFERENCE BETWEEN A SYSTEM SOFTWARE AND APPLICATION PROGRAMS - kcse computer studies analysis of questions

State a situation where real-time processing would be appropriate - kcse computer studies questions and answers

STATE TWO TYPES OF COMPUTER OUTPUT DEVICES

State three functions of database management system.

Define a primary key field

STATE TWO ROLES OF A SYSTEM ANALYST

State two advantages of electronic spreadsheets over manual worksheets

Explain the meaning of backup

explain 2 uses of uninterruptible power supply unit (ups)

Functions of the UPS (Uninterruptible Power Supply)

Definition of UPS

Uses of UPS

Related gadgets

reader's digest

Categories

Archives

ANALYSIS OF KCSE COMPUTER STUDIES TOPICAL QUESTIONS & REVISION KITS

WHAT ARE ELECTRONIC SPREADSHEETS?

WHAT ARE TYPEWRITERS?

WHAT ARE THE MERITS OF SPREADSHEETS OVER TYPEWRITERS?

Briefly explain the following terms: Cell, Range, Label, Value, Function

Expected Response

​Students sat for a test in computer studies. The table gives the marks obtained and the number of students obtaining the marks. Write a program in a structured high-level language to calculate the mean of the result. The formula for the mean is given below.

Marks obtained (x)

Number of students (f)

​EXPECTED RESPONSE;

Related Searches

Expected Response

Functions of the UPS (Uninterruptible Power Supply)

Definition of UPS

​Uses of UPS

Related gadgets

reader's digest

Categories

Archives

Students sat for a test in computer studies. The table gives the marks obtained and the number of students obtaining the marks. Write a program in a structured high-level language to calculate the mean of the result. The formula for the mean is given below.

EXPECTED RESPONSE;

Uses of UPS