%20(1).png)
GENERAL INSTRUCTIONS;
1. Read all questions carefully
2. This paper consist of FOUR(4) questions
3. Attempt all the questions (use 1:30 HRS to answer questions 1,2,3 and 00:30HRS question 4)
4. Write your examination number on every page of answering paper
5. Cellular phones are NOT ALLOWED in the examination room
6. Entering with unauthorized material(s) in the examination room is strictly prohibited.
FOR EXAMINERS USE ONLY
| QUESTIONS | MARKS | SCORES | |
1 | MS EXCEL | 28 |
| |
2 | MS WORD | 20 |
| |
3 | MS POWER POINT | 37 |
| |
4 | SPOTS | 15 |
| |
TOTAL | 100 |
| ||
[DOWNLOAD HERE]
BANK QUESTIONS AND PAST PAPER [BASIC COMPUTER APPLICATIONS]
DOWNLOAD NOW PDF
QUESTION ONE [28 marks]
a. The data below represents performance of kwae medical school. Create a folder on the desktop and save it CA1.your index number e.g CA1.CAGT.CMLS.15.78 [2 marks]
b. Open a new work book and save it as SCHOOL in the folder you have created [2 marks]
c. Enter the below data in the work book you have saved [8 marks]
| NAME | CA 1 | CA 2 | CA 3 | Final Marks | Total Marks |
1. | Washington, Adam | 80 | 88 | 87 | 94 |
|
2. | Stewart, Olive | 99 | 92 | 96 | 100 |
|
3. | Danforth, Elise | 85 | 99 | 82 | 95 |
|
4. | Elton, Roger | 56 | 76 | 74 | 70 |
|
5. | Banks,Michael | 45 | 35 | 56 | 60 |
|
6. | Chau, Lisa | 100 | 90 | 95 | 100 |
|
7. | McDonald, Wendy | 75 | 88 | 97 | 89 |
|
8. | Renfrew, William | 90 | 90 | 85 | 89 |
|
d. Insert the following data between Elton, Roger and Banks, Michael [2 marks]
1. | Kamba,Yusuf | 78 | 95 | 66 | 45 |
|
2. | Samba, Dino | 69 | 77 | 88 | 66 |
|
e. Using appropriate formula find the total Grade of all the students [5 marks]
f. Sort ascending the names of the students [2 marks]
g. Chart the final marks of each student in a column chart in a new sheet and save it as results chart.
The chart heading should be End of semester and label respective axes [5 marks]
h. Rename the sheet as results and save the changes. [2 marks]
QUESTION TWO [20 marks]
i. Open a new MS Word file and type the following text given below. [5 marks]
while researching school districts in the mororgoro city area, ilearned some openings may occur for the next school year in your distric. I have enclosed a resume for your review and wish to be considered for a middle school math or elementary position. I will graduate from the university of sokoine this may with a Bachelor of science degree inn education and certification in both ares.
I am presently student teaching at fairlane elementary in Ms.roger’s sixth grade classroom. Prior to this semester, I was a site coordinator for adventure Club, a before- and after school child care program in kibaha public schools. My summers between semester have been spent working at various camps and summer school programs. Additional experience has been gained through tutoring, field experiences, and volunteer work.
The morogoro City area is my home and I can think of no better place to begin my career. I have completed an application on both on the REAP system and through successLink. If additional application materials are needed, I would very much appreciate your sending them to me at the above address.
I would like to meet you in person for an interview and discuss possible employment opportunities. I am available at your convenience and look forward to hearing from you. Thank you for your assistance.
ii. Cut the first paragraph and paste it below the third paragraph [3 marks]
iii. Copy the second paragraph and paste below the last paragraph [3 marks]
iv. Find the word morogoro and replace it with Mbeya [3 marks]
v. Change the font of the document to MONOTYPE CORSIVA [2 marks]
vi. Justify the first paragraph [2 marks ]
vii. Save the document in the folder you created on desk top as GOOD YEAR [2 marks]
QUESTION THREE [37 MARKS]
You are supposed to create a presentation file using Microsoft Office Power Point 2003, according to the instructions given below
1. Create a presentation with four blanks slides. [5marks]
2. Modify the presentation as follows.
a) Insert a suitable design template. [2marks]
b) Insert a footer to show your name and your registration No. [2marks]
3. Add content to the title slide (first slide) by following the instruction given below.
a) Type “Tea” as the slide title and it’s format should be [5marks]
Font Type : Arial, Style: Bold, Size:96, Color: Black
b) Type “Wikipedia” as the subtitle [2marks]
4. Add content to the second slide by following the instruction given below
a) Type the slide title as, “Tea & Health effect” and format it as,
Font Type: Arial, Style: Bold, Size:44, Color: Black [2marks]
b) Insert the following content as shown below . [5marks]
Ø Tea is an aromatic beverage.
Ø Here are some of the potential health benefits of tea;
1. Immunity against intestinal disorder
2. Prevention of dental cares.
5. In the third slide , add the following components.
a) Type the slide title as, “Statistics” [1mark]
b) Insert the following table [5marks]
Country | Percentage |
China | 48% |
India | 39% |
Sri Lanka | 13% |
6. In the fourth slide ,add the following components.
a) Type the slide title as, “production as a chart”. [1mark]
b) Draw a pie chart using the tabulated data given in the third slide . [3marks]
7. Add any animation effects to your presentation. [2marks]
8. Save your presentation with the following file name PRESENTATION and save it in the folder you created earlier on the desktop. [2marks]
0 Comments