Computer studies analysis of questions and answers

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

<<Previous

COMPUTER STUDIES TOPICAL QUESTIONS AND ANSWERS FOR REVISION

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

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:

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.

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

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.

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

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

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.

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

Differentiate between relative cell referencing and absolute cell referencing.

Differentiate between relative cell referencing and absolute cell referencing.

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

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

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?

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.

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

List three paragraph formatting activities in word processing

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

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”

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

Categories

Archives

COMPUTER STUDIES TOPICAL QUESTIONS AND ANSWERS FOR REVISION

​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)

Categories

Archives

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)