Level Two COC
Project
1: 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.)
Task 1 Create database by the name book store
Task 2
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 NULL or blank)
Task 3 Assign
appropriate primary key and create relationship for the tables.
Task 4 Create a data entry Form for encoding data to
the database.
Task 5
Create a query that accepts publisher Name and displays all book information from the publisher.
Task 6
Create Report of all Authors with their published book
Project
2: configering
LAN and Accessing internet
Task 2.1
Create appropriate network cable to connect you to the internet by using
hub/switch.
Task 2.2
Using the internet connection available download and install Google chrome internet browser.
Task 2.3
Make Google chrome as a default browser and Google search engine as a defoult home page.
Task 2.4
Browse and download a LAN driver of dell optiplex 780 for windows 7 operating system and bookmark the
vendor’s website.
Task 2.5
Configure a simple local Area Network (LAN) using a hub/switch.
- Task 2.1.1 prepare
an approprate cable for connection the two computer
- Task 2.1.2 Show connectivity of the
two computers using command line prompt first and by sharing a file.
- Task 2.1.3 Connect and configure the
two computer provided using the given hub/switch
show connectivity of the two computer using command line prompt first and by
sharing a file.
- Task 2.1.4 Connect and configure the
printer given to you so as to print from the two computers
- Task 2.6 print
your Database report
Project
3 Maintain and demonstrate computer hardware
components and assembling.
Task 1 Identify missing components and demonstrate the
function of the component by filling the table bellow
Create a documentation based on the following
information which you have worked on the above.
|
NO
|
missed components
|
Specification
|
Function
|
|
1
|
|
|
|
|
2
|
|
|
|
|
...
|
|
|
|
Task 2 Installed appropriate printer driver and
print above document.
Task 3 Install the components and test the
functionality of each component.
Task 4 Troubleshot any problem encountered during
assembly and makes the computer operational.
Task 5 Prepare specification of the computer.
(Note; in your computer application include the identified components in above
& other major ones).
example2: Create and administer data base
Suppose
you are assign to create data base for the department human resource.
Task
1Create data base by the name human resource.
Task
2 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
Task 3 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 name of dep -code
|
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
Project
1: Disassembling and
reassembling a computer (UC 04, 06,
07 & 08)
On this project you should perform disassembling and reassemble tasks.
On this project you should perform disassembling and reassemble tasks.
(Total time for this projects: 40 minutes)
Task 1: Disassemble and reassemble
the CD-ROM, RAM and BIOS battery of your computer (UC 04 & 06)
Under this task, you are provide with a functional computer and you are expected to disassemble the device listed above. following the standard computer maintenance procedure
Under this task, you are provide with a functional computer and you are expected to disassemble the device listed above. following the standard computer maintenance procedure
(Time allotted: 20 minutes)
Task 2:
Reassemble back again (UC 07 & 08)
Under this task you are going to reassemble the dismantled CD-ROM, RAM, and BIOS battery and make them operational again.
Under this task you are going to reassemble the dismantled CD-ROM, RAM, and BIOS battery and make them operational again.
(Time allotted: 20 minutes)
Project
2: Accessing and using an internet
(UC 02 & 05)
On this project, you should access and the internet, browse a specific webpage and bookmark a webpage. You should browse another webpage an d make the webpage as a default home page for the browser. You should also download a file from the internet
On this project, you should access and the internet, browse a specific webpage and bookmark a webpage. You should browse another webpage an d make the webpage as a default home page for the browser. You should also download a file from the internet
(Time allotted: 40 minutes)
Task 1: Browse and Bookmark a webpage (UC 02 and 05)
Under this task you should
Under this task you should
Ø
browse a specific webpage called
"www.erta.gov.et or www.google.com"
Ø
Bookmark this webpage.
(Time allotted: 10 minutes)
(Time allotted: 10 minutes)
Task 2: Make a webpage default home page (UC 02 and 05)
Under this task you should
Under this task you should
Ø
browse a webpage "www.bbc.co.uk"
Ø
make this webpage as default home page.
(Time allotted: 10 minutes)
Task 3: Download a file from the internet (UC 02 and 05)
Under this task you should
Under this task you should
Ø
Download a pdf file "A brief history of the internet" from the internet
Ø
create a folder called internet on the Desktop
Ø
Copy the downloaded pdf file to this folder internet
(Time allotted: 30 minutes)
Project 3: Administrator Network and
Hardware Peripherals (UC 03 and 04)
On this project, you should crimp the given UTP cable with the appropriate crimping color code. Connect each computer to the provided hub/switch with this cable. Configure the computer with the appropriate IP address and add the shared printer from the network and print a file from one of the connected computer.
(Total time for this project: 1 hr)
On this project, you should crimp the given UTP cable with the appropriate crimping color code. Connect each computer to the provided hub/switch with this cable. Configure the computer with the appropriate IP address and add the shared printer from the network and print a file from one of the connected computer.
(Total time for this project: 1 hr)
Task 1: Crimp a give UTP cable and test it (UC 03 and 04)
Under this task you should crimp the UTP cable with the appropriate crimping color code.
Under this task you should crimp the UTP cable with the appropriate crimping color code.
(Time allotted: 30 minutes)
Task 2: Connect computer and hub/switch with those cable (UC 03 and 04)
Under this task you should connect the two computers to the provided hub/switch using the prepared crimped cable.
Under this task you should connect the two computers to the provided hub/switch using the prepared crimped cable.
(Time allotted: 10 minutes)
Task 3: configure the computer with appropriate IP address (UC 04)
Under this task you should
Under this task you should
Ø
configure the two computer with IP address
Ø
set any other appropriate network configuration
so as the two computers communicate each other
(Time allotted: 10 minutes)
Task 4 : Add a shared printer from the network (UC 03 and 04)
Under this task you should
Under this task you should
Ø
Install a printer on one computer and share it
Ø
share the folder "internet" which you already have created on project 2 task 3
Ø
add a shared printer from the network on the
other computer and printer first page of the shared pdf file
(Time allotted: 10 minutes)
Project
4: Operating a Database (UC 01)
On this project, you should create a Database called "ABC Hospital" with the given requirement
On this project, you should create a Database called "ABC Hospital" with the given requirement
(Total time for this project: 1:40 hr )
Requirement
ABC Hospital need a database for maintaining the hospital
detailed information the Hospital need
to maintain patient and Doctor information in separate table.
Patient Table has the following attribute PID as Patient ID, PName as Patient name, Age,
Sex, DID as his/her Doctor ID, DOE
as date of entrance.
Doctor Table has the following attribute DID as Doctor ID, DNAme as Doctor Name, Spn as
a specialization.
Task1: Create a database (01)
Under this task you should create a database called "ABC _Hospital" and save it on Desktop
Under this task you should create a database called "ABC _Hospital" and save it on Desktop
(Time
allotted: 05 minutes)
Task2: Design table of a database and fill the table (UC 01)
Under this task you should design and create two different tables and fill with the provide data
Under this task you should design and create two different tables and fill with the provide data
Ø
Table 1: called Patient, hare below the design of this table as shown.
Ø
Set an appropriate Primary Key
|
Filed name
|
Date type
|
|
PID
|
Text
|
|
PName
|
Text
|
|
Age
|
Number
|
|
Sex
|
Text
|
|
DID
|
Text
|
|
DOE
|
Date/Time
|
Ø
Table 2: called Doctor, here below the design of this table as shown.
Ø
Set an appropriate Primary Key
|
Filed name
|
Data type
|
|
DID
|
Text
|
|
DName
|
Text
|
|
Spn
|
Text
|
Ø
Create relationship between the two tables
Ø
Insert the followingdata in Patient Table
|
PID
|
PName
|
Age
|
Sex
|
DID
|
DOE
|
|
P001
|
Meseret
|
29
|
F
|
D003
|
05/04/2013
|
|
P002
|
Belay
|
42
|
M
|
D001
|
02/28/2013
|
|
P003
|
Aster
|
22
|
F
|
D002
|
10/07/2012
|
Ø
Insert the following data in Doctor Table
|
DID
|
DName
|
Spn
|
|
D001
|
Dr.Yilma
|
Neurologist
|
|
D002
|
Dr. Abiyot
|
Intermits
|
|
D003
|
Dr. Sara
|
Gynecologist
|
(Time allotted: 30 minutes)
Task 3:
Create Form (UC 01)
Under this task you should
Under this task you should
Ø
create a form called "Patient _Form"
Ø
Using this form, fill the following new patient
data into the Patient Table
|
P005
|
Tigist
|
32
|
F
|
D001
|
03/15/2013
|
|
P004
|
Wondosen
|
56
|
M
|
D002
|
12/02/2012
|
(Time allotted: 30 minutes)
Task 4:
Create Query (01)
Under this task you should
Under this task you should
Ø
create a query called "Drs _Patient" The query should select Patients that treated by
a specific doctor. The query should contain the PID, PName, Age, DName and Spn
(Time allotted: 30 minutes
Task 5: Create Report (UC 01)
Under this task you should
Under this task you should
Ø create
a report for query that is create in Task4,
Save the report by the Name "Drs _Patient _Report"