Introduction to Information and Computers (ICTS) (GSDR2111)

Higher Institute of Transport and Logistics (HITL)

Semester: First Semester

Level: 200

Year: 2018

School/Faculty: HITL DEPARTMENT: General Studies LECTURER(S): Dr. Dada Jean Pierre
Level: 200 SEMESTER: FIRST Academic Year: 2017/2018
COURSE CODE: TLGS 1111 COURSE TITLE: Introd to Information and computers
DATE: 20/03/2018 HALL: HITL 01 & 02 TIME: 2hrS
Instructions: Answer all questions. Follow the instructions for e ach question
THE UNIVERSITY OF BAMENDA
P.O BOX 39 Bambili
REPUBLIC OF CAMEROON
Peace-Work-Fatherland
0 .
. 17 0
r.
Exercise 1
Type
Speed
Prince
per Ink
cartridge
Pages
printed
per ink
cartridge
Cost
Availability
in the
market
A Laser White
and black
16 pages
per minute
40.000FCFA 10000
pages
100000F Bamenda
B Dot printer 2 pages per
minute
5.000FCFA 4000
pages
120000F Bafoussa
m
C Inkjet printer 8 pages per
minute
16.000FCFA
200 pages 20000F Bamenda
D Laser color 32 pages
per minute
70.000FCFA 20000
pages
200000F Douala
A company is based in Bamenda.
1) What printers do you suggest to the company if it is just to print official letters by the Director?
2) What printers do you suggest to the company to print student transcripts?
3) What printers do you suggest to the company to print exam questions?
4) What printers do you suggest to the company to print electric bills?
5) What printers do you suggest to the company to print draft papers with office automation?
6) After each of these printers have printed 40000 pages. Calculate the cost of printing per page. Let
us consider that a round trip to Bafoussam costs 28000F and 8000F to Douala. A ream of papers
is 2500F
7) What is the cheapest printer per page after you have printed 40000 pages?
8) Give four criteria to be taken into account when an enterprise wants to buy a printer.
Exercise 2: A company’s hard disk has 2 partitions named (C: and D)
1) Where can you store non important files?
2) Where can you store important files
3) Where can you store all the company files
4) Where can you store the Director of the company’s files?
5) If the computer becomes out of order, what files are you going to loose?
6) If the computer becomes out of order, are you going to loose files saved on the desktop?
www.schoolfaqs.net
Exercise 3: To manage studentsmarks, one suggests the following
1) What software has been used to type this figure?
2) List two differences between absolute reference and relative reference
3) We want to fill in cell F4 the sum of all credit values (CV). What formula should we
type?
4) Give the formula to fill cells F7, H7 and H7
5) How will you share those formulas automatically to the other cells F9-F16 for example?
Exercise 4: Here is a figure:
Describe from the windows desktop, how to design this figure (you do not need to assign any
function)
www.schoolfaqs.net