COMPUTER STUDIES QUESTIONS WITH ANSWERS
State three reasons why it is important to define datatypes of fields in a database correctly.8/1/2021 State three reasons why it is important to define datatypes of fields in a database correctly.
Reasons for defining datatypes in databases
0 Comments
A computer technician found it necessary to disable a firewall when working on a computer system. State two reasons that may have necessitated disabling of the firewall.
When firewall is disabled
Write the acronym MODEM in full.
Explain the purpose of a modem when connecting to the internet.
Figure 1 shows relationships between tables in a database.
Identify two primary and two foreign keys used in the relationship.
Primary keys
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
State two ways in which hardware failure is a threat to data security.
State two items that an electronic mail should have for it to be sent.
Items that an email must have:
A student typed a letter in a wordprocessor and the last line of the letter flowed to the second page. State three ways in which the student could have adjusted the letter to fit on one page without changing the paper size.
Ways of adjusting a document to fit a page
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:(i) = countif(D2:D9, “>“&B4) (2 marks) (ii) sumif(B3 :B 11, “4M”, D3 :D11) (2 marks) (i) = Countif (D2 : D9, “>“ & B4)
(D) The following are the fields of products table in a database created to store records of products manufactured in a factory:
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
Distinguish between a page break and a column break as used in a word processor. (3 marks)
State the function of each of the following features of an email software: Inbox and Draft7/1/2021 State the function of each of the following features of an email software:
|
Categories
All
Archives
December 2024
|
We Would Love to Have You Visit Soon! |
Hours24 HR Service
|
Telephone0728 450425
|
|
8-4-4 materialsLevels
Subjects
|
cbc materialsE.C.D.E
Lower Primary
Upper Primary
Lower Secondary
Upper Secondary
|
teacher support
Other Blogs
|