M02 connect hardware peripherals
Assemble and Disassemble
M03 operate personal computer
1. Start the computer
2. Change background of the computer and screen saver & its rotation type is seesaw font is times new roman bold & italic
3. Show desktop icons display only computer and control panel and change computer icons
4. Change taskbar location to left
5. Create application and folder shortcut
6. Create folder by your name in desktop and in your name create the following folders
computer
hardware software
input output application system
operating
keyboard monitor
system
7. Move the keyboard to output folder
8. Copy monitor and paste it into input folder
9. Tis abay college is a private college which gives:-
masters
degree
TVET programs in regular, extension and distance.
In TVET program the college gives:-
Database
accounting
Marketing
ጢስ አባይ ኮሌጅ ከሚሰጣቸዉ የትምህርት አይነቶች ዉስጥ የተወሰኑት የሚከተሉት ናቸዉ፡፡
ማኔጅመንት
አካዉንቲንግ
ዌብዲቨሎፕመንትናዳታቤዝአድሚኒስትሬሽን
Font =28, nyala, bold, italic, underline and the color is red for Tis abay college
Print the above word documents
Delete your name and restore it
10. Empty recycle bin
11. How to get online help
12. Shut down computer(what is the difference between shutdown and restart)
M04 Install software
1. Download some application
2. Install application
3. Uninstall application
M05 protect application and system software
1. Install & Use Kaspersky Antivirus
A. Scan your storage drive
2. Turn on your Windows Defender Firewall
A. Auto Scan Schedule – Weekly every Monday at 4:00 AM
3. Turn on User Account Control
A. notify me only when application try to make change my computer and don’t notify me when I make changes to window
settings
4. Create email and access them
M06 Word
1. Type the following text on first page (5 points)
Word processing software
You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick
Styles gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a
choice of using the look from the current theme or using a format that you specify directly.
To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in
the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Styles gallery
provide reset commands so that you can always restore the look of your document to the original contained in your current template.
2. To prepared the above document using the following font formatting
1. font type=Times New romans
2. Font size=10
3. the title is (font size=14, font color =red underline by double line)
4. add word drop cap on “Y” alphabet
5. justify all whole document
6. water mark=”practice exam”
7. Set to 1.5 line spacing.
8. Change the page orientation to landscape.
9. Change the page size toA4.
10. Change the margin as below: Top= 1”, Bottom=1”, Left= 1.5”, Right=1.5”
11. Find the word gallery and replace it with photo.
12. Create three copy of the above paragraphs on black page
13. Insert page Number at the bottom of the page in center alignment.
14. Insert page header Word Practice Exam, page footer your full name.
15. Insert page border for first page only
16. Insert the following auto shapes on new page
3. Create the following on new page
Output
Printer
Monitor
Speaker
Input
Keyboard
Light pen
Mouse
4. Create a table on which you can enter the following information
Day Periods
Period 1 Period 2 Period 3 Period 4 Period 5
Tuesday Mathes Chemistry Database Sport Database
Monday English Biology Java Biology Java
Wednesday Civics Physics Php Mathes Network
Saturday Sport English Electronics English Electronics
Friday Database Sport Mathes Civics Mathes
Thursday Biology Civics Chemistry Physics Sport
1. The title of the table is Exam schedules
2. Sort the list alphabetically by Day.
3. Select the exams in the period 4 column and green shade the column.
4. Bold the exams in the period 1 column.
5. Delete the Exam on Thursday Rows
6. Delete Period 3 Columns
7. Insert Additional Rows Above andBelowthe Friday
8. Insert Columns To The Right And The Left Of Period 2
9. Save it on desktop by your first name only
5. Print the document
Open the above prepared document then follow the necessary preview and print document steps to print document. Using
(select printer name, number of copies=10, orientation=landscape page per sheet=8 and custom margin=Normal)
M07Excell
1. Create the above table in excel
2. Calculate pension, tax, total deduction and net salary
3. Create bar graph, pie chart, column graph and line graph based on the above table
empID emp full name gross pension tax total net
salary deduction salary
001 BeletechAsrat 5500
002 BetelhemTarekegn 600
003 BiruktawitTsegaye 3900
004 DesalegnTesfahun 4000
005 FentayeFekade 8500
006 HibstieMelkamu 15000
007 KalkidanWendosen 500
008 MameyGared 6000
009 MarituAndargie 6500
010 MastewalMulat 11000
011 SelamawitAbebe 35200
012 YichalemBirara 8000
013 ZenaAlemie 8500
014 YeneagerMiskir 21000
015 SosinaSitotaw 9500
የግልመረጃ የትምህርትአይነት ዉጤት
ተ.ቁ ሙሉስም ፆታ እድሜ Biology Physics Amharic English Sport Chemistry Min Max Sum Average Grade Rank
1 አማረ ተሰማ ወ 25 87 98 78 65 91 98
2 አስቴር አወቀ ሴ 19 56 82 98 99 100 87
3 መላኩ ባለዉ ወ 27 98 78 78 90 63 98
4 ሲሳይ በዜ ወ 32 42 95 58 88 96 87
5 የሽዋስ ዘላለም ወ 41 99 65 45 89 59 68
6 ዘዉዲቱ ባለዉ ሴ 20 76 87 96 73 59 99
7 ተዋቸዉ ማሩ ወ 17 70 36 92 85 91 55
8 ማስተዋል ሲሳይ ሴ 23 89 84 82 45 98 89
9 ቦሰና አምላኩ ሴ 21 97 52 84 98 77 97
10 ወለላ ሙላት ሴ 18 100 66 88 100 87 68
1. Create the above table in excel sheet 2 with formatting
The font size of the first line is 14 and the other is all 12
2. Calculate min, max, sum, average, grade and rank
3. Sort the first name by descending order
4. Create sheet 3 hide it and unhide it
M08 Access Database application lab exam
Task 1
1. Create a new database, save it on the desktop and name it “Database”
2. Create a Table in the Database with the following
Field Name Data Type Field Size or Format
ID Number Short Text 10
Full Name Short Text 15
Telephone Number Number Long Integer
Date of Birth Date/Time Medium Date
Salary Currency Currency
Task 2
1. Make the “ID Number” Field as the Primary Key.
2. Save the table as “Student’s Table”
Task 3
1. Open the “Students Table” and enter 5 complete records.
2. Sort the table in ascending order by Full Name
3. Move the Date of Birth and Telephone Number fields so that the Date of Birth field is now directly after the Full Name field.
4. Delete the last Record you have entered
5. Change the field size of the Full Name to 20
6. Create query
7. Create form
8. Create report
