Computer studies analysis of questions and answers

Using relevant examples distinguish between a formula and function.

30/4/2022

0 Comments

Using relevant examples distinguish between a formula and function.

Formula is a mathematical expression that creates a relationship between cells to return a new value like = B1+b2+c3
Functions are inbuilt formula that the user can quickly use instead of having to create a new each time a calculation has to be carried out like =sum(c2:c7)

0 Comments

The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

17/11/2021

0 Comments

The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

(a) Describe the basic data types used in this spreadsheet (4mks)

Labels
describing items names
Values
describing units on column B and C

(b) Provide a single formula that would be used to
(i) Count the number of items whose units are equal; to 15 (2mks)

=COUNTIF(B2:B5,15) or =COUNTIF(B2:B5,=15)

(ii) Sum the values of items whole units are equal to 12 (2mks)

=SUMIF(B2:B5,"=12") or =SUMIF(B2:B5,"12")

(c) (i) List and describe four areas of application of spreadsheets (4mks)

Accounting
What IF analysis (forecasting)
Budgeting
Calendars
Expense reports
Forms
Time sheets
Invoices
Purchase Orders
Receipts
Schedules

(ii) Explain data range legend and axis as used in spreadsheet charts (3mks)

Axis

A reference line from \which distances or angles are measured in a coordinate system, such as the X-axis and y-axis in the Cartesian coordinate system

Legend

Brief description accompanying an illustration (chart) also known as a caption

0 Comments

State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

15/1/2021

0 Comments

State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

(a) Number of cells with values in a column.
(b) Mean of values in a range of cells.

a) =Count ()
b) =Average ()

State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

0 Comments

Distinguish between a formula and a function as used in spreadsheets.

12/1/2021

0 Comments

Distinguish between a formula and a function as used in spreadsheets.

A formula is a mathematical expression that creates a relationship between cells to return a new value while a function is an inbuilt predefined formula that the user can quickly use instead of having to create a new one every time they want to do a calculation

0 Comments

Explain two ways in which the use of internet could make reporting of corruption easier

10/1/2021

0 Comments

Explain two ways in which the use of internet could make reporting of corruption easier

(b) Explain two circumstances under which the use of wireless communication would be preferred in data communication.
(c) Figure 2 is an extract of a spreadsheet showing what the students had targeted to score and the actual score in a computer remedial class.

A performance factor is obtained by subtracting the target score from the actual score and dividing the difference by the target score.
Write a formula that uses cell references only that would be entered in cell:
(i) D2 to compute the performance factor.
(ii) E2 to display the statement ‘more remedials’ if the performance factor is less than zero, ‘exempted’ if the factor is greater than zero and ‘optional remedials’ if otherwise.
(iii) D8 to display the best performance factor.

RESPONSES

(a) Ways ¡n which internet makes reporting of corruption easier.

Interactiveness: the internet based technology enables real-time dialogue hence instantaneous reporting of cases;
Outreach: the technology allows the coverage of wide areas/can be reported from anywhere;
Social mobilisation: It is easy to use technology to create a network with people or organisations with similar concerns;
Anonymity: With use of the technology, it has become easy to report corruption cases without being known;
Security: The message sent reaches the destination with less risk of being intruded.

(b) Circumstances when wireless is preferred

When the targetted recipients are many and diverse e.g. different platforms, devices, geographical locations.
When the sender or receiver is mobile and it in practical to use wired media.
When there is no space or it is inconvenient to lay cables e.g in a congested town.
When the distance of travel is very big e.g extraterestial communication.

A performance factor is obtained by subtracting the target score from the actual score and dividing the difference by the target score. Write a formula that uses cell references only that would be entered in cell: (i) D2 to compute the performance factor. (ii) E2 to display the statement ‘more remedials’ if the performance factor is less than zero, ‘exempted’ if the factor is greater than zero and ‘optional remedials’ if otherwise. (iii) D8 to display the best performance factor.

Use of the 1F function
First selection & output
Second selection & output
Last selection & output

(iii) = Max (D2:D7)

0 Comments

The following is an extract from a document created using a wordprocessor.

7/1/2021

0 Comments

The following is an extract from a document created using a wordprocessor.

Identify six formats that have been applied on the extract.
(b) State three tools in a wordprocessor that would help a user to minimize spelling mistakes when creating a document.
(c) The following is an extract of a spreadsheet created to manage sales. Use it to answer the questions that follow.

(i)Write a formula that will compute the number of items whose unit price is more than 10,000.
(ii) If the formula = $R2 * C$2 was placed in cell D2, state the output if it was copied to D3.
(d) A school administers examinations to all students in sciences, humanities and languages. Use the entities; EXAMINATIONS, STUDENTS, SCIENCES,HUMANITIES and LANGUAGES to illustrate a network database model.

RESPONSES

(a) Formats applied

Bold. strikethrough, underline, italics, centre alignment, dropcap, bulleted list, line height / spacing, 2 column paragraph. column break, casing, font type, left alignment, column separator.

(b) Tools for proofreading

Spell checker and grammar/ dictionary;
Autocomplete;
Autocorrect;
Thesaurus.

0 Comments

State three hardware devices that may be required to connect a computer to an existing local area network.

7/1/2021

0 Comments

A) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)

A network adapter/network interface card
Network medium/cable
RJ45 connectors/BNC/ST connector/SC connectors/Fibre local connector
Data points (sockets to plug in the cable)
Switch/Hub
Access point/TP link

B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)

Using digital camera
Scanning the graphics from other sources
Downloading from the internet
Drawing from scratch/Drawing tools
Clip art
Another file

C) Interpret each of the following spreadsheet formula:

(i) = countif(D2:D9, “>“&B4) (2 marks)

(ii) sumif(B3 :B 11, “4M”, D3 :D11) (2 marks)

(i) = Countif (D2 : D9, “>“ & B4)

Count those value in the range D2 :D9 with values greater than the value in cell B4).

(ii) = Sumif (B3 : B11, “4M” D3 : D11)

Sum the values in the cell range D3 : D11 for records whose
corresponding values in cell range B3 : B11 equals to “4M”

(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

product number
product name
price
product description

I. State the appropriate data type for each field. (2 marks)
II. State three properties to be put in place during table design to ensure integrity of the data entered. (3 marks)

I) Product Number — Number/Autonumber/Text

Product Name — Text/string
Price — Currency/Number
Product Description — Memo/Text/String

(II) Properties that can be set in the table design

Data type
Validation/Validation rule
Input mask
Setting required/null value status
Field size
Caption

(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

0 Comments

A retailer uses a spreadsheet program to calculate profits. Figure 1 shows the spreadsheet.

6/1/2021

0 Comments

A retailer uses a spreadsheet program to calculate profits. Figure 1 shows the spreadsheet.

(a) Which row contains labels only?
(b) Write the formula that has been entered in cell F2.

(a) Row 1 or 1
(b) = D2*E2; = product(D2E2)
OR = Product (D2: E2)

0 Comments

Differentiate between relative cell referencing and absolute cell referencing.

5/1/2021

0 Comments

Differentiate between relative cell referencing and absolute cell referencing.

Relative referencing, there is use of a formula whose references keeps on changing automatically depending on their relative position when they are copied from one cell to another.
In Absolute referencing, the cells referenced are specific.

0 Comments

In a spreadsheet the formula =If(AI>10, A1 77, A150) is entered in a cell. Interpret the results

5/1/2021

0 Comments

In a spreadsheet the formula =If(AI>10, A1 77, A150) is entered in a cell. Interpret the results. (3 marks)

=If(A1>10,A1 *77,A1 *50)
Compares the value in cell Al ¡fit is greater than 10, if comparison is True, the results of operations Al * 77 is displayed, if it is False the results of the operations A1 * 50 is displayed.

0 Comments

Explain the function of protect sheet feature in a spreadsheet program

4/1/2021

0 Comments

Explain the function of protect sheet feature in a spreadsheet program. (2 marks)

Function of protect sheet:

It is a feature used to prevent unwanted changes to be made on the data contained in a sheet by limit the ability to make changes.

0 Comments

What is meant by each of the following terms as used in table creation?

4/1/2021

0 Comments

What is meant by each of the following terms as used in table creation?

(a) What is meant by each of the following terms as used in table creation?
(i) cell margin;
(ii) nested table.
(b) State four types of text wrap that can be applied to a graphic.
(c) Distinguish between each of the following:
(i) axis labels and data labels;
(ii) cropping and sizing.
(d) Figure 1 shows a section of a worksheet containing information on household items.
Use it to answer the questions that follow.

(i) Write a formula to calculate the total cost of rice.
(ii) The prices of all items increased by 10% and the value 10% is placed in cell B8. Using cell addresses with absolute referencing only, write a formula to calculate the new unit price of salt.
(iii) Write a function to display the number of cells in which the cost per unit is equal to 110.
(iv) Write a function to display the least total cost for all items.

(a) (i) Cell margin: Its the space between the boundary of the cell and the text/content inside the cell.
(ii) Nested table: is a table created inside another table.
(b) In line with text.

Square
Behind text.
Infront of text.
Tight.
Through.
Top and bottom.
None.
Solution
(c) (i) Axis label: Data corresponding to the vertical or horizontal lines of a given chart whereas the x-axis and y-axis.
Data label: are data that provide additional information about a data marker which represents a single data point on a value that originates from a worksheet cell. .

(ii) Cropping is the process of trimming/cutting/hiding vertical or horizontal edges of an object/picture while sizing is the process of enlarging/expanding or reducing/contracting an object/picture to appropriate dimension.

0 Comments

Distinguish between a formula and a function as used in spreadsheets.

3/1/2021

0 Comments

Distinguish between a formula and a function as used in spreadsheets.

Vertical Divider

Formulae are user designed expressions that create a relationship between cells and return a value in a chosen cell. While a function is an inbuilt predefined (hidden sub-program) that is found in a spreadsheet program.

0 Comments

List three paragraph formatting activities in word processing

2/1/2021

0 Comments

(a) List three paragraph formatting activities in word processing(3 mks)

alignment
Tabs
Indentation
Outline level
Line spacing

0 Comments

The cells K3 to K10 of a worksheet contain remarks on student’s performance such as very good, good, fair and fail depending on the average mark. Write a formula that can be used to count all students who have the remark “very good”

2/1/2021

0 Comments

The cells K3 to K10 of a worksheet contain remarks on student’s performance such as very good, good, fair and fail depending on the average mark. Write a formula that can be used to count all students who have the remark “very good” (3mks)

= countif(K3:K10,”very good”)

0 Comments

A student presented a budget in the form of a worksheet as follows:

1/1/2021

0 Comments

A student presented a budget in the form of a worksheet as follows

The student intends to have spent half the amount by midterm

0 Comments

A computer accessories vendor needs to order supplies. A spreadsheet is used to calculate the order part of which is shown below.

31/12/2020

1 Comment

A computer accessories vendor needs to order supplies. A spreadsheet is used to calculate the order part of which is shown below.

(a)Write the formula that can be used in:
(i)D2
(ii)D5

(b)If a value added tax (VAT) of 16% was charged on each item and the number ordered was decreased by 10%, write a new formula that can be used in D2

1 Comment

A company has decided to computerize their operations. They have decided to purchase packages instead of developing their own programs. Give three advantages and two disadvantages of this approach.

31/12/2020

0 Comments

(a) A company has decided to computerize their operations. They have decided to purchase packages instead of developing their own programs. Give three advantages and two disadvantages of this approach.

Advantages

Saves on programming effort and exposure on the part of the user (client)
The user gets a well- tried and tested program
Relatively quick implementation results from use of package

Disadvantages

Purchaser does not have full control over the packages as would have been if it was developed in house
Package is produced to meet general needs & may not be ideal for a particular customer

0 Comments

Distinguish between labels and formulae with respect to spreadsheet

31/12/2020

0 Comments

(a) Distinguish between labels and formulae with respect to spreadsheet (2mks)

Label
a non- numeric piece of data entered into an electronic spreadsheet cell. Labels are not used for computations. Any cell entry, which begins with a letter or on apostrophe, is a level.
Formulae
Mathematical computations which join other cells’ values with mathematical operators such as +, -, * or /

(b) Consider the entries in the cells below

(c) State the values displayed in cell C14 (2mks)

Error (#value) NB: the = sign is missing in cells C10 and C11

0 Comments

Explain data series, axis and legends as used in spreadsheet charts. Data, Axis and Legend

29/12/2020

0 Comments

Explain data series, axis and legends as used in spreadsheet charts. Data, Axis and Legend

Data Series

The selected range in a worksheet that EXCEL converts into a graphic and displays as a chart (in spreadsheet applications)

Axis

A reference line from \which distances or angles are measured in a coordinate system, such as the X-axis and y-axis in the Cartesian coordinate system

Legend

Brief description accompanying an illustration (chart) also known as a caption

0 Comments

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

29/12/2020

0 Comments

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

b) State one way in which a user may reverse the last action taken in a spreadsheet package.
c) The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, . and A, B, C. respectively

Use the following expressions to answer the questions that follow:

Basic pay = hours worked x pay per hour
Allowances are allocated at 10% of basic pay
Gross pay = basic pay + allowances
Tax deductions are calculated at 20% of gross pay
Net pay = Gross pay – tax deductions.

Write formulae using cell references for the following cells;
i) D2
ii) E4
iii) F10
iv) G7
v) H5
d) i) State three ways of moving round the page in a Desktop Publishing window.
ii) State two ways on how information & Communication Technology (ICT) can be used to reduce the spread of HIV/AIDS

EXPECTED RESPONSES

(a) Distinguish between the following sets of terms as used in spreadsheets
(i) Worksheet and workbook

Worksheet – The working area in an electronic spreadsheet on which a
user enters the spreadsheet data.
Workbook – A spreadsheet file. A workbook can obtain several worksheets

(ii) Filtering and sorting

Data filtering is a way of organizing spreadsheet data for ease of analysis. Often spreadsheet filters are used to “hide” rows of data that do not meet certain specified criteria. This allows you to analyze (e.g. count, observe etc) only certain “Filtering” groups of data.
Data sorting: Is a way of arranging record according to one of the fields in either ascending or descending order.

(b) State one way in which a user may reverse the last action taken in a spreadsheet package
Use the undo command (ctrl + z)
(c)The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, and A, B, C respectively

Use the following expressions to answer the questions that follow

Basic pay- Hours worked x pay per hour
Allowances are allowed at 10% of basic pay
Gross pay- Basic pay + allowances
Tax deductions are calculated at 20% of gross pay
Net pay-= gross pay – tax deductions

Write formulae using cell references for the following cells

(i)D2 = B2 * C2
(ii)E4 = 10% * D4 or 10% * (B4 * C4)
(iii)F10 = D10 + E10
(iv)G7 = 20% * F7
(v)H5 = H5 – G5

(d) (i) State three ways of moving round the page in desktop publishing window

Use cursor keys
use mouse scroller
Use scroll buttons (horizontal and vertical)

(ii)State two ways on how information & communication technology (ICT) can be used to reduce the spread of HIV/ AIDS

Through advertisements on the Internet
Through creation of posters
Through discussion groups on the internet

0 Comments

The Formula = k20 + p $18 was typed in cell L21 and then copied to cell M24 of a spreadsheet. Write the formula as it appears in cell M24 (2mks)

29/12/2020

0 Comments

The Formula = k20 + p $18 was typed in cell L21 and then copied to cell M24 of a spreadsheet. Write the formula as it appears in cell M24 (2mks)

L23 + Q$18

0 Comments

List any four tasks that an electronic spreadsheet should be able to perform other than calculations

27/12/2020

0 Comments

(a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations.

Production of graphs
Automatic recalculation
Projection of growth curves through what-if analysis
Have editing and formatting features that can be used to change appearance of data and make necessary changes.
Have features of a database therefore they can be used to filter, sort, validate data and remove duplicates.
They can import and export data from other programs and platforms.

(b) Explain what is meant by automatic recalculation as used in a spreadsheet.

Feature of electronic spreadsheet system which runs anytime a cell is updated, causing all formulas, functions and macros which depend on that cell to automatically update their computations

0 Comments

The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet.

27/12/2020

0 Comments

The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet. Enter the formulae, as they would appear when copied to the cell M20 of the same spreadsheet.

The first column in the table below contains the formulae as stored into the cell F10 of a spreadsheet

Expected Response

0 Comments

Andrew, Jane, David and Zablon had tea, sausages and bananas for breakfast ...

26/12/2020

0 Comments

Andrew, Jane, David and Zablon had tea, sausages and bananas for breakfast. They took one sausage, two sausages, three sausages and one sausage respectively. In addition, they took a cup of tea and two bananas. Tea, sausages and bananas cost Kshs 10, 15 and 5 respectively.

By naming columns A, B, C … and rows 1, 2, 3 …………….

(a) Construct a worksheet showing the above information (7mks)

0 Comments

<<Previous

​Using relevant examples distinguish between a formula and function.

​The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

​(a) Describe the basic data types used in this spreadsheet (4mks)

​(b) Provide a single formula that would be used to (i) Count the number of items whose units are equal; to 15 (2mks)

​(ii) Sum the values of items whole units are equal to 12 (2mks)

(c) (i) List and describe four areas of application of spreadsheets (4mks)

(ii) Explain data range legend and axis as used in spreadsheet charts (3mks)

State the spreadsheet function that can be used to obtain each of the following values in a worksheet:

(a) Number of cells with values in a column. (b) Mean of values in a range of cells.

Distinguish between a formula and a function as used in spreadsheets.

Explain two ways in which the use of internet could make reporting of corruption easier

The following is an extract from a document created using a wordprocessor.

​A) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)

​B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)

​C) Interpret each of the following spreadsheet formula:

​(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

A retailer uses a spreadsheet program to calculate profits. Figure 1 shows the spreadsheet.

Differentiate between relative cell referencing and absolute cell referencing.

​​In a spreadsheet the formula =If(AI>10, A1 *77, A1*50) is entered in a cell. Interpret the results. (3 marks)

​Explain the function of protect sheet feature in a spreadsheet program. (2 marks)

What is meant by each of the following terms as used in table creation?

Distinguish between a formula and a function as used in spreadsheets.

​(a) List three paragraph formatting activities in word processing(3 mks)

A computer accessories vendor needs to order supplies. A spreadsheet is used to calculate the order part of which is shown below.

(a)Write the formula that can be used in: (i)D2 (ii)D5 ​

​(b)If a value added tax (VAT) of 16% was charged on each item and the number ordered was decreased by 10%, write a new formula that can be used in D2

​(a) A company has decided to computerize their operations. They have decided to purchase packages instead of developing their own programs. Give three advantages and two disadvantages of this approach.

(a) Distinguish between labels and formulae with respect to spreadsheet (2mks)

​(b) Consider the entries in the cells below

​(c) ​State the values displayed in cell C14 (2mks)

Explain data series, axis and legends as used in spreadsheet charts. Data, Axis and Legend

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

​The Formula = k20 + p $18 was typed in cell L21 and then copied to cell M24 of a spreadsheet. Write the formula as it appears in cell M24 (2mks)

​(a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations.

​(b) Explain what is meant by automatic recalculation as used in a spreadsheet.

Expected Response

​(a) Construct a worksheet showing the above information (7mks)

Categories

Archives

Using relevant examples distinguish between a formula and function.

The information below is maintained by the sales lady at the school canteen. Study it and answer the questions that follow.

(a) Describe the basic data types used in this spreadsheet (4mks)

(b) Provide a single formula that would be used to
(i) Count the number of items whose units are equal; to 15 (2mks)

(ii) Sum the values of items whole units are equal to 12 (2mks)

(a) Number of cells with values in a column.
(b) Mean of values in a range of cells.

A) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks)

B) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks)

C) Interpret each of the following spreadsheet formula:

(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:

In a spreadsheet the formula =If(AI>10, A1 77, A150) is entered in a cell. Interpret the results. (3 marks)

Explain the function of protect sheet feature in a spreadsheet program. (2 marks)

(a) List three paragraph formatting activities in word processing(3 mks)

(a)Write the formula that can be used in:
(i)D2
(ii)D5

(b)If a value added tax (VAT) of 16% was charged on each item and the number ordered was decreased by 10%, write a new formula that can be used in D2

(a) A company has decided to computerize their operations. They have decided to purchase packages instead of developing their own programs. Give three advantages and two disadvantages of this approach.

(b) Consider the entries in the cells below

(c) State the values displayed in cell C14 (2mks)

The Formula = k20 + p $18 was typed in cell L21 and then copied to cell M24 of a spreadsheet. Write the formula as it appears in cell M24 (2mks)

(a) List any four tasks that an electronic spreadsheet should be able to perform other than calculations.

(b) Explain what is meant by automatic recalculation as used in a spreadsheet.

(a) Construct a worksheet showing the above information (7mks)