Wird geladen....
|
Drücken und Halten zum Ziehen |
|||
|
Hier klicken, um zu schließen |
|||
Frage 1 Bericht
(a)(i) What is data model?
(ii)State three types of data model
(b)(i) List three approaches to data modeling.
(ii) Explain any one approach listed in1(b)(i)
This question tests knowledge of data models and approaches to data modelling.
(a)(i) Data model. A data model is a way of describing and organising how data is structured, stored and related in a database, defining the data elements, their attributes and the relationships between them.
(a)(ii) Three types of data model.
(The object-oriented model is another acceptable type.)
(b)(i) Three approaches to data modelling.
(b)(ii) Explanation of one approach. Conceptual data modelling gives a high-level, technology-independent picture of the data. It identifies the main entities (such as Student, Course), their key attributes, and the relationships between them, usually drawn as an entity-relationship diagram. It focuses on what data the organisation needs and how items relate, not on how the data will physically be stored, so it is used early in design to agree the requirements with users.
Examination reminder: do not confuse the types of data model (hierarchical, network, relational) with the levels/approaches of modelling (conceptual, logical, physical); this question asks for both.
Antwortdetails
This question tests knowledge of data models and approaches to data modelling.
(a)(i) Data model. A data model is a way of describing and organising how data is structured, stored and related in a database, defining the data elements, their attributes and the relationships between them.
(a)(ii) Three types of data model.
(The object-oriented model is another acceptable type.)
(b)(i) Three approaches to data modelling.
(b)(ii) Explanation of one approach. Conceptual data modelling gives a high-level, technology-independent picture of the data. It identifies the main entities (such as Student, Course), their key attributes, and the relationships between them, usually drawn as an entity-relationship diagram. It focuses on what data the organisation needs and how items relate, not on how the data will physically be stored, so it is used early in design to agree the requirements with users.
Examination reminder: do not confuse the types of data model (hierarchical, network, relational) with the levels/approaches of modelling (conceptual, logical, physical); this question asks for both.
Frage 2 Bericht
(a) Outline the steps involved in printing the first five pages of a word document from the print dialog box on a computer with two printers installed.
(b) Sadiq complained that a pop-up usually appears on the screen of his personal computer thereby disturbing him while using the computer;
(i) What is the possible cause of the pop-up?
(ii) State a possible cause of the element causing the pop-up.
(iii) What measure would be necessary to stop the pop-up from reoccurring?
(c) Mr Aneke is billed to address audience in an auditorium.
(i) What computer application package is suitable to prepare and deliver his speech?
(ii) State the output device that can be used to transmit Mr Aneke's speech note from his computer to a large screen in the auditorium.
(d) Give two types of computer network.
This question tests printing a page range on a multi-printer system, dealing with pop-ups, presentation software, and types of network.
(a) Print the first five pages on a computer with two printers.
(b) The disturbing pop-up.
(c) Mr Aneke's address in an auditorium.
(d) Two types of computer network: LAN (Local Area Network) and WAN (Wide Area Network) (MAN and PAN are also acceptable).
Examination reminder: to print a range, choose "Pages" and type 1-5 (a hyphen means "through"); and remember to pick the correct printer first when more than one is installed.
Antwortdetails
This question tests printing a page range on a multi-printer system, dealing with pop-ups, presentation software, and types of network.
(a) Print the first five pages on a computer with two printers.
(b) The disturbing pop-up.
(c) Mr Aneke's address in an auditorium.
(d) Two types of computer network: LAN (Local Area Network) and WAN (Wide Area Network) (MAN and PAN are also acceptable).
Examination reminder: to print a range, choose "Pages" and type 1-5 (a hyphen means "through"); and remember to pick the correct printer first when more than one is installed.
Frage 3 Bericht
(a) Outline the steps involved in creating the Query By Example (QBE) in figure 1 assuming the table customer exist already.
Figure 1
(b) Write the steps to generate the SQL statement for the action in 4 (a).
(a) Creating the Query By Example (QBE) in Microsoft Access, given that the Customer table already exists.
(b) Generating the SQL statement for the query in 4(a).
Use any one of the following:
Access then displays the equivalent SQL for the query, of the form:
SELECT [Last Name], [First Name], Town FROM tblCustomer WHERE [Last Name] = 'John';
Antwortdetails
(a) Creating the Query By Example (QBE) in Microsoft Access, given that the Customer table already exists.
(b) Generating the SQL statement for the query in 4(a).
Use any one of the following:
Access then displays the equivalent SQL for the query, of the form:
SELECT [Last Name], [First Name], Town FROM tblCustomer WHERE [Last Name] = 'John';
Frage 4 Bericht
(a) Vera a secretary to the manager of her organization is saddled with the responsibility of typing a confidential report. She is also instructed to insert the word "CONFIDENTIAL" diagonally in the background of every page of the report.
(i) State the most suitable application software needed by Vera to produce the report.
(ii) What feature of the application software can be used to insert the word "CONFIDENTIAL" as instructed?
(iii) Mention one measure that can be taken to ensure the confidentiality of the soft copy of the report in the computer.
(b) Explain the following terms;
(i) Icon
(ii) Browser
This question tests choice of application software, a document feature, information security, and two general computing terms.
(a)(i) Most suitable application software. A word processor (for example Microsoft Word) is best for typing and formatting the confidential report.
(a)(ii) Feature to insert "CONFIDENTIAL" diagonally in the background of every page. The Watermark feature (a diagonal text watermark) places the faint word across the background of every page.
(a)(iii) One measure to keep the soft copy confidential. Protect the file with a password (encrypt the document) so that only authorised persons can open it. (Restricting access rights or storing it in a secure/encrypted folder is also acceptable.)
(b) Terms.
Examination reminder: the diagonal faint text behind every page is specifically a watermark, a word-processor feature; do not confuse it with a header, footer or text box.
Antwortdetails
This question tests choice of application software, a document feature, information security, and two general computing terms.
(a)(i) Most suitable application software. A word processor (for example Microsoft Word) is best for typing and formatting the confidential report.
(a)(ii) Feature to insert "CONFIDENTIAL" diagonally in the background of every page. The Watermark feature (a diagonal text watermark) places the faint word across the background of every page.
(a)(iii) One measure to keep the soft copy confidential. Protect the file with a password (encrypt the document) so that only authorised persons can open it. (Restricting access rights or storing it in a secure/encrypted folder is also acceptable.)
(b) Terms.
Examination reminder: the diagonal faint text behind every page is specifically a watermark, a word-processor feature; do not confuse it with a header, footer or text box.
Frage 5 Bericht
(a) Figure 3 is created using a Word processor. Use the figure to answer question 6(a)
Figure 3
(a)(i) What is the name given to the feature on the first character in the document in figure 3?
(ii) Highlight the step to;
I. Achieve the feature on the first character in 6(a)(i)
II. Obtain the two columns as shown in figure 3.
(b) Give two objects that can be placed on a document using the "insert menu" on MS Word application.
(c) Outline the steps to perform the following actions in CorelDraw application;
(i) inserting a circular shape
(ii) adding the caption "Happy Birthday"
(iiI) changing the colour of the caption to Red
(iv) fitting the caption around the circular object.
(a)(i) Name of the feature on the first character
It is a Drop Cap: an enlarged first letter of a paragraph that drops down and occupies two or more lines of text to decorate the start of the document.
(a)(ii) I. Steps to achieve the Drop Cap
(a)(ii) II. Steps to obtain the two columns
(b) Two objects that can be placed using the Insert menu in MS Word
(Other acceptable answers include chart, shape, clip art, header, footer, page number, symbol, text box, equation, hyperlink and word art.)
(c) Steps in CorelDRAW
(i) Insert a circular shape
(ii) Add the caption "Happy Birthday"
(iii) Change the colour of the caption to red
(iv) Fit the caption around the circular object
Antwortdetails
(a)(i) Name of the feature on the first character
It is a Drop Cap: an enlarged first letter of a paragraph that drops down and occupies two or more lines of text to decorate the start of the document.
(a)(ii) I. Steps to achieve the Drop Cap
(a)(ii) II. Steps to obtain the two columns
(b) Two objects that can be placed using the Insert menu in MS Word
(Other acceptable answers include chart, shape, clip art, header, footer, page number, symbol, text box, equation, hyperlink and word art.)
(c) Steps in CorelDRAW
(i) Insert a circular shape
(ii) Add the caption "Happy Birthday"
(iii) Change the colour of the caption to red
(iv) Fit the caption around the circular object
Frage 6 Bericht
(a) Itoro was tasked with the responsibility of producing the report of hi group project He is to submit both the soft and hard copies of the report to his form teacher. The soft copy must be submitted to the email; form teacher@school.edu.ng
(i) List two;
I. Applications required to carry out the task
II. Hardware required to carry out the task
(ii) Identify two conditions to be satisfied by Itoro to submit the electronic copy of the report.
(iii) On the first attemot to send the soft copy of the report, Itoro observed a "spinning wait cursor"/"spinning disc pointer" on the screen for a long time.
Identify three possible reasons for this observation.
(iv) State one output device that can be used to produce the hard copy report.
Figure 2 is an interface of an application software. Use the figure to answer question 5(b)
Figure 2
(b)(i) Name the type of application software represented in figure 2.
(ii) List three examples of the application in 5(b)(i)
(iii) Given that the application in figure 2 is running on a computer that has internet access, outline the steps to follow in creating an email address/account.
(a)(i) I. Two applications required
(a)(i) II. Two hardware items required
(a)(ii) Two conditions to be satisfied to submit the electronic copy
(a)(iii) Three possible reasons for the long spinning wait cursor
(a)(iv) One output device for the hard copy
A printer.
(b)(i) Type of application software in Figure 2
A web browser.
(b)(ii) Three examples
(b)(iii) Steps to create an email address/account
Antwortdetails
(a)(i) I. Two applications required
(a)(i) II. Two hardware items required
(a)(ii) Two conditions to be satisfied to submit the electronic copy
(a)(iii) Three possible reasons for the long spinning wait cursor
(a)(iv) One output device for the hard copy
A printer.
(b)(i) Type of application software in Figure 2
A web browser.
(b)(ii) Three examples
(b)(iii) Steps to create an email address/account
Möchten Sie mit dieser Aktion fortfahren?