COMPUTER STUDIES QUESTIONS WITH ANSWERS
A head teacher keeps the following student details in a database: Name,address, Town, Date of Birth, Marks scored, Fees paid.
i) Name the most appropriate primary key. Give a reason
ii) For each item in the student’s details above, indicate its most appropriate data type as used in the database. iii) Explain why input screens are better data entry designs than entering data directly to a table. b) List two career opportunities associated with databases. c) Distinguish between: i) A table in word-processing application and a table in a database application ii) Mouse pointer and insertion point. d) Outline the steps to be followed in order to merge cells in a word processing table.
RESPONSES
i)Name the most appropriate primary key. Give a reason. Name alone is not unique though it is very rare that two or more students will share the same name. ii)For each item in the student's details above, indicate its most appropriate data type as used in the database.
0 Comments
A computer C directory has folders for form 1, form 2, Form 3 and form 4. Each class has student’s folders labeled according to their number. The students create their own folder for the subject the are studying based on the table shown below
a) Assuming there is one student per class, draw the corresponding directory tree structure.
b) i) a form four student wants to create a folder to store her project. State the path for that project folder. ii) Suggest how the student can ensure that: 1. Work is not lost in case the hard disk fails. 2. The project is not copied by other students. c) i). Other than I/O devices, list other three devices under the control of the operating system. ii) Explain any one of the devices named in C (i) above d) Define the term trouble shooting
RESPONSES
c) i) A form four student wants to create a folder to store to project State the path for flat project folder.
C:\FORM4\STUDNO\ADB\PROJECT ii) Suggest how the student can ensure that: - work is not lost in case the hard disk fails.
e) Define the term trouble shooting
Define the following web related terms: Web browser, Hyperlink ,Hypertext document
Define the following web related terms: Web browser, Hyperlink ,Hypertext document
i) Web browser ii) Hyperlink iii) Hypertext document b) List six activities performed on the web c) An institution has ten stand alone computers i) Suggest with reasons the most appropriate topology required to inter-connect the computers. ii) State the necessary steps required to connect the computers to the internet. d) Below is an email address: Name the parts labeled:
a) Define the following web related terms:
i) Web browser A browser is an application program that provides a way to look at and interact with all the information on the World Wide Web. ii)Hyperlink This is the clickable link in text or graphics on a Web page that takes you to another place on the same page, another page, or whole other site. iii) Hypertext document A document usually web document (file) where the user interacts with the whole document using hyperlinks b) List six activities performed on the web
i) Suggest with reasons the most appropriate topology required to inter-connect the computers. a) Bus Reason: Easy to set up, Low cost in terms of cabling QR b)Star Reason: Speed of data transmission is high, Easy to troubleshoot via central hub or switch ii) State the necessary steps required to connect the computers to the Internet.
ggitau @moest. edu.ke Name the parts labeled:
Study the flowchart below and answer the questions that follow
i) Name the control structures used in the flowchart
ii) Determine the values of M, N, P and Q. M………………………….. N……………………….. P ………………………….. Q ……………………… iii) Write the pseudo code for the flowchart b) List four functions of an assembler
ANSWERS
i) Name the control structures used in the flowchart.
- Selection -Sequencing ii) Determine the values of M, N, P and Q. M………17………………..N……………….17………………….. P………..17………………..Q……………….17…………………. iii) Write the pseudo code for the flowchart Q=N
a) Translate assembly language to machine code. b) Execute assembly language statements. c) Create executable files (.exe) from the assembly language statements. d) Allocate memory for machine code. e) Debug for errors (a) Give three comparisons of the traditional file management method of typing a document on a typewriter against using a word processor ( 6mks)
Word Processor
(a) Identify three public Universities and three National polytechnics in Kenya where further computer training is offered, In case state the highest level of qualification that can be acquired in computer training.(a) (i) What is a computer keyboard? (1mk)
Input device with keys for keying in data in the form of characters
List four types of keys found on a computer keyboard. Give an example of each. (4mks)(a) List five precautions that can be taken to protect data stored in diskettes (5mks)The following flowchart can be used to list the odd numbers between 0 and 100 (a) Write a program segment for the flowchart using a high level language (7mks)List two examples of:Third generation languages and Object oriented languages
i) Third generation languages
ii) Object oriented languages b) Draw a flowchart to compare three non-equal numeric values A, B, C and prints the largest of the three.
(a) List two examples of:
(i) Third generation languages Pascal, basic, c (ii)Object oriented languages VB, Small talk, C++ Suppose an element array A contains the values 9, 12, 17, 7 and 20. Find the value in A after executing the loop below:
Repeat for k= 1 to 4
Set A {k + 1} = A {k} {End of loop} First time A {2}: = 9 Second time A {3}: = 9 Third Time A {4}:= 9 Fourth time A {5}: = 9 (a) In a computer based information system, state the purpose of the following files and give one example where such a file may re required in a school (8mks)(i) Report lifeA summary file from the main file (ii) Backup fileBackup also called a security file – are copies of files kept in case the original master file is damaged or lost and cannot be used. (iii) Reference fileThis is a file with a reasonable amount of permanency. Examples of data used for reference purposes are price list, tables of rate of pay, names and addresses. (iv) Sort fileThis is a temporary file that holds records organized in a particular order State three ways in which computer technology may affect employment patterns in organizations28/12/2020 (a) State three ways in which computer technology may affect employment patterns in organizations
(a) The diagram below represents the essential features of a computer system. Study the diagram and answer the questions that follow:
(i) Name the components: (4mks)
The following car details are to be entered in a database: Make, date of manufacture, colour and cost.
(a) Prepare a suitable database structure showing field names and their field types (5mks)(a) What is meant by each of the following terms:
(b) A program is required to list the first 1000 numbers in the series 2, 4, 6, 8, 10 ……. Draw a flowchart and write a program that can be carry out this task (12mks)
Question Source: KNEC KCSE 1998 Computer Studies
The ‘while…do’ loop is a control structure designed to execute the same block of code again and again until a certain condition is fulfilled. This loop is used if a condition has to be met before the statements within the loop are executed. A firm intends to purchase new software. List three items that should accompany the software26/12/2020 (a) A firm intends to purchase new software. List three items that should accompany the software (3mks)
(a) What are computer viruses?
A computer program designed specifically to damage other programs or cause irregular behaviour.
(b)
|
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;
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.
Related Searches
Categories
All
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2022
Analogue And Digital Systems
Applications Areas Of ICT
Areas Where Computers Are Used
Auxiliary Storage Devices
Basic Computer Set Up And Cabling
Binary Conversion
Booting
CABLES AND PORTS
Career Opportunities In ICT
Classification Of Computers
Coaxial Cables
Coding Schemes
COMPACT DISK
COMPLETE PAPERS
Computer Crimes
Computer Files
Computer Memory
Computer Software
Computer Systems
COMPUTER VIRUS
Dashboard
Database
Data Collection
Data Communication
Data Integrity
Data Processing
Data Representation In A Computer
Data Security And Controls
Definition And Development Of Algorithm
Desktop Publisher
Development-of-computers
DTP
DVD
Electronic Data Processing Modes
Elementary Programming Principles
Errors-in-data-processing
Evolution-of-computer-systems
Fibre Optic Cables
File Management Using An Operating System
File-organization-methods
Flowchart
Form 1 Level
Form 2 Level
Form 3 Level
Form 4 Level
Formatting Features
Hands On Skills
HARDCOPY OUTPUT DEVICES
Hard Disk
Hardware
Impact Of Ict On Society
IMPACT PRINTERS
Information
Input Devices
Internet And Email
Introduction To Computers
Introduction To Networking And Data Communication
ISP
Levels-of-programming-languages
Midterm-exams
Mind-blowing-q-a
Mocks
Network Topologies
Network-topology
NON-IMPACT PRINTERS
Ones And Twos Compliments
Operating Systems
Output Devices
Paper 1
Parts Of A Computer
Practical Hands On Skills
Printers
Processing-devices
Processors
Program-construction
Program-control-structures
Program-design
Program Development
Program-documentation
Protocols
Registers
Review Questions
Revision Kits
Secondary Storage Media
Section A
Section B
Security Threats And Control Measures
Software
Spreadsheets
Stages Of System Development
Storage Devices
Symbolic-representation
System-design
System Development
System-documentation
Term-1
TERM 2
The Computer Laboratory
The CPU
The Keyboard
Types Of Computer Files
Types-of-networks
User Interface
Uses-of-computers
Word Processors
Worksheet-formatting
Archives
December 2024
June 2024
January 2024
December 2023
October 2023
September 2023
July 2023
June 2023
February 2023
November 2022
September 2022
April 2022
January 2022
December 2021
November 2021
July 2021
March 2021
February 2021
January 2021
December 2020
October 2020
April 2020
February 2020
October 2019
August 2019
July 2019
April 2019
March 2019
November 2018
August 2018
July 2018
December 2017
November 2017
October 2017
July 2017
August 2016
June 2016
January 2016
December 2015
November 2015
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
|