1
Maintain and
configure and administer hardware and network peripheral.
Identify
missing components and failure of the computer.
Create a
documentation based on the following information which you have worked on the
above.
missed components
|
Specification
|
Function
|
Installed
appropriate printer driver and print above document.
Install the
components and test the functionality of each component.
Troubleshot
any problem encountered during assembly and makes the computer operational.
Prepare specification
of the computer. (Note; in your computer application include the identified
components in above & other major ones).
2
Create
appropriate network cable to connect you to the internet by using
hub/switch.
Using the
internet connection available download and install Google chrome internet
browser.
Make Google
chrome as a default browser.
Browse and download
a LAN driver of dell optiplex 780 for windows 7 operating system and bookmark
the vendor’s website.
Configure a
simple local Area Network (LAN) using a hub/switch.
Prepare
appropriate cable connect and configure the two computers provided using the
given hub/switch.
Show
connectivity of the two computers using command line prompt first and by
sharing a file.
Connect and
configure the printer given to you so as to print from the two computers
Open Google
search and find PDF file book about introduction to internet and
download it to my document folder.
Participate
in work place communication
Create email
address by coc_your name (@yahoo.com) or any email provider
Wright email
to coc@yahoo.com and attache the file that you have downloaded in the above
pdf file. And send the email and sign out your email page.
3
Create and
administer data base
Suppose you
are assign to create data base for the department human resource.
Create data
base by the name human resource.
Create the
following two table’s structure under human resource data base.
Department
table
Filed name
|
Data type
|
Description
|
Dep-code
|
Department code
|
|
Dep-name
|
department
|
Determine
data type off the above fields.
Staff
table
Filed name
|
Data type
|
Description
|
Emp-id
|
Employment id
|
|
Emp-name
|
Employment name
|
|
Ep-code
|
Department code
|
|
Sex
|
Sex
|
|
Birth date
|
Birth date
|
|
Salary
|
Salary
|
Determine
data type off the above fields
Assign
proper primary key for each table so that you will not have duplication report.
Create a
validation and validation text for the following fields.
Fields
|
Validation rules
|
Validation text
|
Dep- code
|
To accept only d-001,d-002,
d-003,d-004
|
Pleas type the correct name of dep
-code
|
Sex
|
To accept only F or M
|
Pleas type the correct validation off
sex
|
Define the
possible relationship between two tables.
Enter the
following data for the department and staff table
Department
table
dep-code
|
Dep-name
|
d-001
|
Adminsteration
|
d-002
|
Finance
|
d-003
|
Human resorce
|
d-004
|
Information technology
|
Staff
table
Emp-id
|
Emp-name
|
Sex
|
Birth date
|
Salary
|
Emp-001
|
Ali abde
|
M
|
1980
|
1450
|
Emp-002
|
Lula mekonen
|
F
|
1973
|
1076
|
Emp-003
|
Azeb hayelu
|
M
|
1979
|
2230
|
Emp-004
|
Abel mulu
|
F
|
1982
|
1600
|
Create and save query by the name query one
that contend at fields from both tables
Create report and save by the name report 1
from above query
Or
Creating and
operating a database application.
You are
expected to develop a database for a book store that used to record published books (using Microsoft
office access 2007.)
Create
database by the name book store
Create two
tables in database book store
Author (author-Id, Author-Name, Sex
and Nationality) and
Books (book-Id, book-title,
Publisher-Name and Author-Id)
(Note: Author-Id format, A-01, A-02…,
Book-Id format. B-01, B-02…
And Author Name and book title
should not be blank)
Assign
appropriate primary key and create relationship for the tables.
Create a
data entry form for encoding data to the database.
Create a
query that accepts publisher Name and displays all book information from the
publisher.
Create
Report of all Authors with their published book.