Cit3 Exer Ans
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Cit3 Exer Ans as PDF for free.
More details
- Words: 839
- Pages: 5
CIT Chapter 3 Integrated Use of Application Software Class 4 (
) Name : _______________________(
)
Part A: New Style Multiple Choice Questions: Complete the followings with WORDS/SENTENCES provided in P. 69 and P. 70 of your text. 1. An auto-run CD-ROM will bring up the installation program and wait for users’ instructions. 2. Saving a file will overwrite the original file 3. The command Save .. As is used for saving but without affecting the existing file 4. When there is a power failure, temporary files will exist on the hard disk 5. A clipboard is a part of the main memory 6. A case insensitive search will treat “Computer” equal to “computer” 7. Paragraph formatting includes centering the text across the page 8. Relative address will change when a formula is copied and pasted to other cells 9. A database is a collection of tables 10. A graphic file may store lines and curves
P.1 of 5
Part B: Conventional Questions: 11. State the major difference between copy-and-paste and cut-and-paste. Copy leaves the original contents unchanged. Cut removes the original contents 12. How does a computer distinguish between different types of data files? It uses the file extension (e.g. doc, xls, txt, dbf, ppt, html,…) 13. State the data files that are involved in mail-merge Main document, data file in table form, merged document 14. Give THREE types of data source that can be used in mail merge. Word document in table form, spreadsheet file, database table(p.55) 15. How many cells are there in each of the following cell range: B4:D7? 12 16. A formula “=A$7+$B8+$C$9+ D6” is created in the cell F5. What would be the new formula when the formula is copied and pasted to the cell (a)
G5 =B$7+$B8+$C$9+ E6
(b)
F6 =A$7+$B9+$C$9+ D7
(c)
H7 =C$7+$B10+$C$9+ F8
17. A database table STUDENT has the following fields: NAME, CLASS, CHIN, ENG, MATH and ADDRESS What is the command to produce (a)
the names of students who have failed in ENG? Select name from STUDENT where ENG < 50
(b)
the names of students who have passed in both CHIN and MATH Select name from STUDENT where CHIN >= 50 and MATH >=50
(c)
the names of students who live in KOWLOON Select name from STUDENT where ADDRESS =“%KOWLOON%”
18. When a word document is export as a text file, what information of the original document are lost? Formatting, graphics and other objects, like spreadsheet table 19. Jessica issues a Find-and-replace command to change the word “girl” with “boys” . However, she finds that the document still contains the words “girl” and “Girl”. What should Jessica do if all the aforesaid words need to be changed using one Find-and-replace command?
P.2 of 5
i)
she should find “ girl” and replace it with “boy”
ii)
she should uncheck the case-sensitive option
20a.Refer to p.71(Q18), write down the formula in cell D2. =A2*B2*C2 b. What will happen if the formula in D2 is copied and pasted to D3? State the result and the new formula. =A3*B3*C3=144 20. How many cells are there in each of the following cell ranges? a.B3:B8 6 b. B4:D7 12 21. A formula “=A$7 +$B8” is created in a cell. What would be the new formula when it is copied and pasted to a cell a.one column to the right? =B$7 +$B8 b.one row below? =A$7+$B9____________________________________________________________ 22. Refer to p.72(21) a. What is the formula in cell B2? =A2 /C$2+D$2 b. Suggest TWO changes in the spreadsheet if the teacher wants to set all the marks above the passing marks of 50. 1. decrease the factor 2. increase the constant 23.In a school, each student has to enroll in one and only one club activity. A database table is designed to store the information as follow: School______________________________________________________________ Student Field
Description
Student-id
A unique code for student records P.3 of 5
Name
Name of student
Class
Class of student
Club_name
Name of a club
Club_tchr
Name of teacher of a club_______________
a) State the disadvantages in the above database design. 1.the club_name is repeated many times. Waste of storage. 2. updating the club information is difficult and prone to errors. b) Redesign the database to address the above disadvantages. The database should consist of two tables: School.Student Field
Description
Student_id
A unique code for student records
Name
Name of student
Club_id
The code for the club involved
School.Club Field
Description
club_id
A unique code for club records
club_name
Name of a club
Club_tchr
Name of the teacher of a club
c) If the school allows a student to join any number of club activities, redesign the database. The database should consists of three tables: School.Student Field
Description
Student_id
A unique code for student records P.4 of 5
Name
Name of student
School.Club Field
Description
club_id
A unique code for club records
club_name
Name of a club
Club_tchr
Name of the teacher of a club
School.Student_Club Field
Description
Student_id
The code for the student
Club_id
The code for the club involved
P.5 of 5
) Name : _______________________(
)
Part A: New Style Multiple Choice Questions: Complete the followings with WORDS/SENTENCES provided in P. 69 and P. 70 of your text. 1. An auto-run CD-ROM will bring up the installation program and wait for users’ instructions. 2. Saving a file will overwrite the original file 3. The command Save .. As is used for saving but without affecting the existing file 4. When there is a power failure, temporary files will exist on the hard disk 5. A clipboard is a part of the main memory 6. A case insensitive search will treat “Computer” equal to “computer” 7. Paragraph formatting includes centering the text across the page 8. Relative address will change when a formula is copied and pasted to other cells 9. A database is a collection of tables 10. A graphic file may store lines and curves
P.1 of 5
Part B: Conventional Questions: 11. State the major difference between copy-and-paste and cut-and-paste. Copy leaves the original contents unchanged. Cut removes the original contents 12. How does a computer distinguish between different types of data files? It uses the file extension (e.g. doc, xls, txt, dbf, ppt, html,…) 13. State the data files that are involved in mail-merge Main document, data file in table form, merged document 14. Give THREE types of data source that can be used in mail merge. Word document in table form, spreadsheet file, database table(p.55) 15. How many cells are there in each of the following cell range: B4:D7? 12 16. A formula “=A$7+$B8+$C$9+ D6” is created in the cell F5. What would be the new formula when the formula is copied and pasted to the cell (a)
G5 =B$7+$B8+$C$9+ E6
(b)
F6 =A$7+$B9+$C$9+ D7
(c)
H7 =C$7+$B10+$C$9+ F8
17. A database table STUDENT has the following fields: NAME, CLASS, CHIN, ENG, MATH and ADDRESS What is the command to produce (a)
the names of students who have failed in ENG? Select name from STUDENT where ENG < 50
(b)
the names of students who have passed in both CHIN and MATH Select name from STUDENT where CHIN >= 50 and MATH >=50
(c)
the names of students who live in KOWLOON Select name from STUDENT where ADDRESS =“%KOWLOON%”
18. When a word document is export as a text file, what information of the original document are lost? Formatting, graphics and other objects, like spreadsheet table 19. Jessica issues a Find-and-replace command to change the word “girl” with “boys” . However, she finds that the document still contains the words “girl” and “Girl”. What should Jessica do if all the aforesaid words need to be changed using one Find-and-replace command?
P.2 of 5
i)
she should find “ girl” and replace it with “boy”
ii)
she should uncheck the case-sensitive option
20a.Refer to p.71(Q18), write down the formula in cell D2. =A2*B2*C2 b. What will happen if the formula in D2 is copied and pasted to D3? State the result and the new formula. =A3*B3*C3=144 20. How many cells are there in each of the following cell ranges? a.B3:B8 6 b. B4:D7 12 21. A formula “=A$7 +$B8” is created in a cell. What would be the new formula when it is copied and pasted to a cell a.one column to the right? =B$7 +$B8 b.one row below? =A$7+$B9____________________________________________________________ 22. Refer to p.72(21) a. What is the formula in cell B2? =A2 /C$2+D$2 b. Suggest TWO changes in the spreadsheet if the teacher wants to set all the marks above the passing marks of 50. 1. decrease the factor 2. increase the constant 23.In a school, each student has to enroll in one and only one club activity. A database table is designed to store the information as follow: School______________________________________________________________ Student Field
Description
Student-id
A unique code for student records P.3 of 5
Name
Name of student
Class
Class of student
Club_name
Name of a club
Club_tchr
Name of teacher of a club_______________
a) State the disadvantages in the above database design. 1.the club_name is repeated many times. Waste of storage. 2. updating the club information is difficult and prone to errors. b) Redesign the database to address the above disadvantages. The database should consist of two tables: School.Student Field
Description
Student_id
A unique code for student records
Name
Name of student
Club_id
The code for the club involved
School.Club Field
Description
club_id
A unique code for club records
club_name
Name of a club
Club_tchr
Name of the teacher of a club
c) If the school allows a student to join any number of club activities, redesign the database. The database should consists of three tables: School.Student Field
Description
Student_id
A unique code for student records P.4 of 5
Name
Name of student
School.Club Field
Description
club_id
A unique code for club records
club_name
Name of a club
Club_tchr
Name of the teacher of a club
School.Student_Club Field
Description
Student_id
The code for the student
Club_id
The code for the club involved
P.5 of 5
Related Documents
Cit3 Exer Ans
November 2019 1
Cit2 Exer Ans
November 2019 2
Exer-fund_i.docx
June 2020 1
Natam Exer
November 2019 1
Graph Exer I
November 2019 1