Welcome once again to Armstrong Computers College, where vision meets excellence in digital education and training. In this blog post, we bring you a comprehensive study resource based on the November/December 2020 Level One NVTI Examination for Application Skills. This paper covers:
- Fundamentals of Computing
- Word Processing
- Spreadsheet Management
- Database Management
Use these questions and tasks to revise and prepare effectively for exams. Try answering before checking the solutions!
SECTION A – Fundamentals of Computing (Multiple Choice)
1. The collection of tangible parts of a computer is called…
a. Hardware
2. What is a computer?
a. Electronic device
3. Which of the following is a search engine?
b. Google
4. A spreadsheet software is made up of…
c. Cells
5. Clip art is a…
b. Picture
6. To boot a computer is the same as…
c. Start the computer
7. Word Processing is mainly used by…
c. Secretaries
8. Auxiliary storage devices are also…
c. Secondary storage devices
9. A collection of related records is called…
c. File
10. How many bits make a byte?
b. 8
11. A device used to convert digital to analog signals…
c. Modem
12. LAN stands for…
c. Local Area Network
13. WWW stands for…
c. World Wide Web
14. Which is not a Microsoft application package?
c. MS Word Pad
15. The primary purpose of a computer is to convert data into…
c. Information
16. Two output devices are…
c. Printers and monitors
17. Used for softcopy output…
d. Monitor
18. RAM stands for…
b. Random Access Memory
19. Not a part of the mouse…
d. Mouse pointer
20. Not true about the hard disk…
c. Volatile storage media
SECTION B1 – Spreadsheet Management
- Difference between rows and columns: Rows are horizontal (numbered), Columns are vertical (labeled with letters).
- Two advantages of spreadsheets:
- Automates calculations using formulas
- Easy to visualize data with charts
SECTION B2 – Database Management
- What is a database? A database is a collection of organized data that can be easily accessed, managed, and updated.
- Two database software:
- Microsoft Access
- MySQL
- Minimizes data redundancy
- Enables data integrity and fast retrieval
SECTION B3 – Word Processing Practical (Compulsory)
Instructions: Reproduce the following letter in Microsoft Word using the specified formatting guidelines.
PRIVATE MAIL BAG
ASHANTI NEW TOWN
KUMASI
6th June 2019
Seth Larsey
c/o Sylvia Ankrah
Goodison Camp
Abokobi
DEAR SETH
INTERNET
I have received your letter since 10th October 2008. Thanks a lot for it.
I have not been able to write this time because I had to travel to Menka in the North
for some hectic assignment in about two weeks' time. In the interim, I am just
having some time off duty.
I may contact you on the internet to see how best we can store with those cables.
I believe the sales representative is making all efforts to get us more market.
Please expect to hear from me soon.
Yours faithfully,
……………………………
Mariam Senyo Wool (Mrs)
(Business Partner)
Apply the following formatting in Microsoft Word:
- Set left and right margins to 1.5 inches
- Use font size 14
- Bold and italicize the heading and type it in capitals
- Save as STELLA
- Print the document
