Basic Computer Course

CHAPTER I
Application Software
Application software consists of programs created to perform a specific user's task. It
allows a user to prepare a document, design a financial worksheet or create a useful
database.
The Basic application Software are
 Word Processing Software (MS Word)
 Spreadsheet Software (MS Excel)
 Presentation Software (MS PowerPoint)

1.1 Introduction to Word Processing Software (Microsoft Word)

Creating Word Document
You may have a shortcut to Word on your desktop, if so double click the icon and Word
will open. If not follow the steps below:
 Press window icon on keyboard
 Search MS Word Application in start screen
 Click on the MSWord icon

Create a New Document

1. Click the File tab and then
click New.
2. Under Available Templates, click Blank Document.
3. Click Create.

1
Option Description
Save If an existing document is opened, it would be saved as is, otherwise
it will display a dialogue box asking for document name.
Save As A dialogue box will be displayed asking for document name and
document type, by default it will save in word 2010 format with
extension .docx.
Open This option will be used to open an existing word document.
Close This option will be used to close an opened document.
Info This option will display information about the opened document.
Recent This option will list down all the recently opened documents
New This option will be used to open a new document.
Print This option will be used to print an opened document.
Save & Send This option will save an opened document and will display options to
send the document using email etc.
Help You can use this option to get required help about word 2010.
Options Use this option to set various option related to word 2010.
Exit Use this option to close the document and exit.
Save a Document
To save a document, do the following:
1. Click the File tab.
2. Click Save As.
3. In the File name box, enter a name for your document.
4. Click Save.

Open an Existing Document

1. Click the File tab, and then click Open.
2. In the left pane of the Open dialog box, click the drive or folder that contains the
document.
2. In the right pane of the Open dialog box, open the folder that contains the document
that you want.
3. Click the document and then click Open.

Cut, Copy the Text

1. Simply highlight the text and go to the Home tab in the Clipboard group.
2. Click Cut or Copy.
You can also right click on your mouse and select Cut
or Copy.

Pasting Text
2
If you Copy text, you typically need to Paste it somewhere. When you paste content,
the Paste Options button provides different options, depending on the source of the
content. Keep Source

Undo
The Quick Access Toolbar holds a variety of commands right at you finger tips. It is
located in the top left of the document above the File and Home tab.
You can add or remove command by clicking on the arrow to the right of the Quick
Access Toolbar.
If you make an error in your document click on the Undo command and it will remove
the last thing you did.
Quick Access Toolbar

Using different types of fonts and colors

The Font Group allows you to change your text
font style, size, color and many other elements.
1. Highlight the text you would like to modify.
2. Click on the drop down arrow of font style and font size and select the changes you
would like to make.
3. While text is highlighted you can also click on the color, bold, italics or underline
commands to modify the text even more.

Change Text Case

You can change the case of selected text
in a document by clicking a single button called Change Case on the ribbon.
1. Highlight the text for which you want to change the case.
2. On the Home tab, in the Font group, click Change Case.
3. Choose an option from the dropdown list, which includes
Sentence case, lowercase, UPPERCASE, Capitalize Each Word, and tOGGLE cASE.

3
 MS WORD EXERCISES
Exercise No.1

Type the following text in the MS Word new document.

“The more you know, the more you realize you know nothing.”
— Socrates
“Tell me and I forget. Teach me and I remember. Involve me and I learn.”
— Benjamin Franklin
“Real knowledge is to know the extent of one’s ignorance.”
— Confucius
1. Add the title "Famous Quote" . Bold the title.
2. Change to center alignment to title.
3. Change title font size to 16. Italicize and underline the Name
4. Increase the font size to 14. Change the font style to (your choic).
5. Adjust the line spacing to 1.5 lines.
6. Save your document at the specific Folder (MyExercises) and name it
(FamousQuote).

Exercise No.2

Normal This is an example text of Normal .

Bold This is an example text of Bold. ( Ctrl + B )
Italic This is an example text of Italic. ( Ctrl + I )
Underline This is an example text of Underline.( Ctrl + U )
Strikethrough This is an example text of Strikethrough
All Capital THIS IS AN EXAMPLE TEXT OF ALL CAPITAL.
Superscript This is an example text of Superscript.
(eg- 8th February 2000, 23 + X3)
Subscript This is an example text of Subscript. (eg- H 2O, H2 SO4)

Exercise No.3

Type the following text.

Heading 1
On the Insert tab, the galleries include items that are designed to coordinate
with the overall look of your document. You can use these galleries to insert
tables, headers, footers, lists, cover pages, and other document building blocks.
When you create pictures, charts, or diagrams, they also coordinate with your
current document look.
Heading 2
On the Insert tab, the galleries include items that are designed to coordinate
with the overall look of your document. You can use these galleries to insert
tables, headers, footers, lists, cover pages, and other document building blocks.
4
When you create pictures, charts, or diagrams, they also coordinate with your
current document look.
Heading 3
On the Insert tab, the galleries include items that are designed to coordinate
with the overall look of your document. You can use these galleries to insert
tables, headers, footers, lists, cover pages, and other document building blocks.
When you create pictures, charts, or diagrams, they also coordinate with your
current document look.

Exercise No 2
by
Your Name
Your Department
Task
1. After typing the first paragraph (Heading 1), copy and paste for the Heading 2
and Heading 3.
2. Font size 14, bold for all headings.
3. Change Body paragraph of Heading 1 to lowercase.
4. Heading 2 is in center alignment. Change the title to Heading 2 Exercise.
5. Change Heading 2 body paragraph to UPPERCASE.
6. Heading 3 is Right alignment, UPPER CASE
7. Change all paragraphs to different font style.
8. Insert the Paragraph title to "Copy and Paste Exercise", font size 14 and bold.
9. Under the last paragraph, type "Exercise No, your name and your
department".
10. Save your document at the specific Folder (MyExercises) and name it
(CopyPasteEx).
Exercise No 4.
Type the following letter as shown in the format.
Font - "Pyidaungsu" font size=11

ရန်ကုန်တက္ကသိုလ်
ကွန်ပျူတာသိပ္ပံပညာဌာန
စာအမှတ်၊ ရကပ /သင်တန်း/၀၃၂/၂၀၂၁
ရက်စွဲ၊ ၂၀၂၁ခုနှစ်၊ ဒီဇင်ဘာလ (၁၆ ) ရက်
အကြောင်းအရာ။ Credit Seminar ဖိတ်ကြားခြင်း။

ရန်ကုန်တက္ကသိုလ် ၊ ကွန်ပျူတာသိပ္ပံပညာဌာနတွင် ၂၀၂၁-၂၀၂၂ ပညာသင်

နှစ်အတွက် ကွန်ပျူတာသိပ္ပံ၊ ပါရဂူသင်တန်းသား/သူများ၏ Credit Seminar ကို
အောက်ဖော်ပြပါ အစီအစဉ်အတိုင်း ကျင်းပပြုလုပ်မည် ဖြစ်ပါ၍ ကြွရောက်စစ်ဆေး
ပေးပါရန် လေးစားစွာ ဖိတ်ကြားအပ်ပါသည်။
(၁) ကျင်းပမည့်နေ့ရက် - ၂၂-၁၂-၂၀၂၁ (ဗုဒ္ဓဟူးနေ့)
(၂) ကျင်းပမည့်အချိန် -(၁၀:၃၀) နာရီ
(၃) ကျင်းပမည့်နေရာ - Seminar Room, Dept. of Computer Studies,
University Yangon

ဒေါက်တာစိုးမြမြအေး
ပါမောက္ခ၊ ဌာနမှူး
ကွန်ပျူတာသိပ္ပံပညာဌာန

5
Tasks
1. Spacing before =0 After=0, Line spacing – Multiple 1.3
2. Save your document at the specific Folder (MyExercises) and name it
(MyanmarFontExercise).

Exercise No 5
Open Exercise No 1.
Task
1. In the Insert Tab, choose Header.
2. Select appropriate Header style.
3. Add footer to the document.
4. Save this document with the name "Header Footer Exercise". (Note that
use Save As to save this document with different file name)

Exercise No 6

အမည် အမျိုးအစား‌ဈေးနှုန်း အရေအတွက်စုစုပေါင်းတန်ဖိုး

ဦးလှ Laptop 1000.25$ 5 5001.25$
[Link] printer 525.50$ 8 4204 $
မမြ Camera 202.50$ 5 1012.5 $

Exercise No 7
1. Cover – Times New Roman,(All are Capital Letter) Font 16 Size, Bold,
Center
2. All Titles – Times New Roman, Font 14 Size, Bold, Center
3. All Sub –Titles - Times New Roman, Font 12 Size, Bold, Left
4. All Body Text- Times New Roman, Font 12 Size, Line Spacing -1.5, Justified,
Paper –A4

6
7
Exercise No 8
APPLICATION FORM

1. NAME :.................................................

2. FATHER'S NAME :.................................................

3. FATHER'S EMPLOYMENT : ...............................................

4. NATIONAL REGISTRATION NO :.................................................

5. NATIONAL ITY :.................................................

6. RELIGION :.................................................

7. DATE OF BIRTH / (AGE) :.................................................

8. EDUCATIONAL QUALIFICATION : ...............................................

9. OTHER QUALIFICATION : ................................................

10. PREVIOUS EMPLOYMENT : ...............................................

11. EXPECTED SERVICE PERIOD :.................................................

12. MARITAL STATUS :.................................................

13. PHONE :.................................................

14. RESIDENTAL ADDRESS :.................................................

: ..................................................

DATE: SIGNATURE

8
 1.2 Introduction to Spreadsheet Software (Microsoft Excel)
A first look at Excel
You may have a shortcut to Excel on your desktop, if so double click the icon and Word
will open. If not follow the steps below:
 Press window icon on keyboard
 Search MS Excel Application in start screen
 Click on the MSExcel icon

Rows & Columns in Excel

Worksheet

Active Cell
Column

Row

Active Sheet

9
Understanding Workbooks and Worksheets
A workbook is a collection of worksheets stored in a single file. A workbook is useful for
grouping a single’s worksheets together. A workbook holds one or more worksheets. A
workbook can contain several worksheets.

Cell Movement Action

Left on cell Press [ ] or [Shift]+[Tab]
Right on cell Press [ ] or [Tab]
Up on cell Press [ ] or [Shift]+[Enter]
Down on cell Press [ ] or [Enter]
Left one column or right one Click the left arrow or right arrow on
column the horizontal scroll bar

Up one row or down one row Click the up arrow or down arrow on
the vertical scroll bar
Up one screen or down one Press [Page Up] or [Page Down]
screen
Left one screen or right one Press [Alt]+[Page Up] or
screen [Alt]+[Page Down]

Go to cell A1 [Ctrl]+[Home]
Go to column A in current row [Home]

Formatting text and numbers in a Cell

The most formatting options are found on the Home Tab.

Format Cell Format Number

Formatting Number
1. Select the cell or give range.
2. Click format dialog launcher or more option on Number
button group.
3. Format cells dialog box will open, select Number tab.
4. Select the numeric format in the Category.
5. Click OK. More options
button

Format Cells Dialog Box

Formatting Text
Alignment

10
 1. Select the cell you want to change.
2. Click Format dialog box launcher on the Alignment button group
3. In Orientation box, you can change the Degrees in order to change the text
format.
4. Click OK.
Formatting Font
1. Click on font dialog box launcher
2. Choose appropriate Font Style list, font size, bold, italic
and underline etc.
3. The result can see in the Preview box.
4. Click OK.

Working with Excel sheet

Exercise:
Open new excel work book and type the table as shown
in following figure. Format the table with appropriate
style.

11
 MS EXCEL EXERCISES
Exercise No 1
Fill the duplicate data-
(a) Fill Number (20) in 50 cells.
(b)Fill number ( 20,10 ) in 50 cells.

Exercise No 2
Fill the series of-
(a) Month (January to December)
(b)Numbers (1 to 100)
(c) Days (Monday to Sunday)
(d)Weeks (Week 1 to Week 50)
(e) Save Exercise No 1 and No 2 in the appropriate folder.

Exercise No 3
Type the following table in Excel
sheet1. Fill the appropriate
information in the blank cells.

Tasks
1. Insert two rows above the Row
1.
2. Type the table title at (A1) cell with Font= "Pyidaungsu" font size="12"
font style="Bold"
" အခြေခံကွန်ပျူတာသင်တန်းတက်ရောက်သူ
များစာရင်း"
3. Type the table title at (A2) Cell "Batch
1/2022"
4. Make "Merge and Center" for both title.
5. Check in Print preview to fit with page. If
the table do not fit with page, set the
appropriate page set up and adjust the cell
width and height.

Formaular သင်မှာထည့်ရန်

Exercise No 5
Type the following table in Excel sheet.

Tasks

1. Set appropriate format to this table.

12
 2. Type the formula in the cell (K4) "=D4+E4+H4+I4+J4" and press Enter.
3. Type the formula in the cell (L4) " =K4/5" and press Enter.
4. Fill all cells with those formula at column K and L.
5. Save this worksheet.

Exercise – 4

Roll No. Name Myan English Maths Science Arts Total Result
N-0001 Aung Win 45 54 95 45 82
N-0002 Tun Tun 65 62 85 65 80
N-0003 Myint Ohn 25 60 84 55 84
N-0004 Naing Tun 85 32 75 66 81
N-0005 Kyaw Kyee 35 23 52 63 65
N-0006 Hnin Hnin 45 40 62 75 45
N-0007 Wint War 65 50 35 85 53
N-0008 Wai Wai 78 55 86 95 87

1. Fill the above data into worksheet. Calculate the total.

2. At last column, fill the Result field. (Passed or Fail)
3. Save your worksheet with new filename. ([Link])
4. Sort your database record by first key as result marks and second key as
total.

Exercise – 5
SRNO. NAME RANK SALARY DEPARTMENT UNIVERSITY

1. DAW HLA HLA A.L 1650 MATHS YANGON

2. U MYA MG A.L 1625 PHYS MANDALAY
3. U MYA A.L 1650 CHEM MANDALAY
4. DAW SU SU A.P 1750 MATHS YANGON
5. DAW HLA L 1500 CHEM YANGON
6. DAW YEE YEE L 1550 MATHS YANGON
7. U YE AUNG L 1525 PHYS MANDALAY
8. U KYAW AYE TUTOR 1250 PHYS YANGON
9. DAW AYE TUTOR 1225 CHEM YANGON
10. DAW NYO TUTOR 1275 MATHS MANDALAY
11. DAW MYA DEMO 1175 MATHS YANGON
12. DAW SEIN DEMO 1150 CHEM YANGON
13. U AUNG A.P 1700 CHEM YANGON
14. U SOE MYINT DEMO 1200 MATHS MANDALAY
15. DAW WIN WIN DEMO 1150 PHYS YANGON

1. Fill the data into worksheet.

2. Extract the record which met the following condition.
(a) University Yangon.
(b) Rank A.L
(c) Rank Tutor and Department Chemistry.
(d) Rank A.P or L
(e) University Yangon and Department Physics

13
(f) Rank Lecturer or Salary greater than 1300.
(g) First Name start with “U”
3. Save your worksheet. ([Link])

Exercise - 6 Actual Budget for the Five Sales Areas

Area Budget Actual Actual as A% Budget
Bagan 1,200 1,185
Meiktila 3,000 2,770
Kalaw 600 760
Bago 2400 1,860
Pyay 2800 2,880
Total
Maximum
Average

Fill the data into the worksheet and find the required questions.
Actual as A% of budget = Actual value devided by Budget.

14
 1.3 Introduction to Presentation Software (Microsoft PowerPoint)
Introduction to power point and its tools and options
Microsoft PowerPoint is a presentation tool that supports text, shapes, graphics, pictures
and multimedia. By default, documents saved in PowerPoint 2010 are saved with
the .pptx extension whereas; the file extension of the prior PowerPoint versions is .ppt.

File Tab (Backstage View) Title bar

Home Ribbon

Quick
access Slide Area
toolbar

Ribbon

Slide Tab
Slide view

Create a new PowerPoint presentation

1. Click on the PowerPoint Shortcut button on Desktop
Or
2. Click on the PowerPoint icon on Start window
Or
3. Click File Tab Newblank presentationCreate

Add a new slide in presentation

1. Select on the slide in a slide tab and press ENTER.
Or
2. Right click on the slide in a slide tab and choose new slide
Or
3. Click New slide on the Home tab.

15
Adding Text to the slide
In the first slide, we should type the presentation title and presenter name or group
name.

Slide
Layout
1. Right
click on anywhere on the slide area or slide tab
and select Layout on the pop up menu.
Or
2. Select the slide you want to set layout, and click on
the Layout button on Home Tab.

Deleting the slide

1. Right click on the slide that you want to
delete and select delete slide on the
pop up menu.
Or
2. Select the slide to be deleted, press
Delete button on keyboard.

Rearranging the slide (Slide sorter view)

1. Click the slide sorter view icon at the bottom of
the PowerPoint window.
2. Select the slide to be moved.
3. Click on the slide and drag it to the position in
the sequence where you want to place it.
PowerPoint will indicate the insert position
with a line in-between existing slides.

Insert Position

Inserting
Clip Art 1

16
Clip Art includes pictures, sounds and videos. There are two ways to initiate inserting
Clip Art depending on where you would like the graphic to be located.
1. Click the clip art on the Insert tab
2. Click the click art icon in the slide.
The Clip Art task pane will then open on the right.
Type a keyword in the Search for box that suggests
the type of clips you may want. Use the Results
should be drop down to select the media type to
search in then click Go.
3 Clips that fit the keyword will appear in the box
2 below. Click on the clip that you would like on your
slide and it will be automatically appear.
Starting a Slide Show
The best way to view your slides as a show, whether you are previewing your
documents or presenting to an audience, go to the Slide Show tab on the Ribbon.

17
 MS POWERPOINT EXERCISES
Exercise No 1
Open a blank PowerPoint presentation to start.
Tasks
Prepare the PowerPoint as shown in figure.

Slide No 1 Slide No 2 1. new

slide

Slide No 3 Slide No 4

Slide No 5 Slide No 6

Add the new slide, type

"Thank You for your attention"

between slide no 5 and slide no 6

2. Click to add title "Laptop"
3. Click "Insert" tab and click "Clip Art"
4. Type "computer" at search area and click "Go". Add appropriate clipart to the
slide.
5. Click the "slide sorter view" and "normal" view to learn how the view changes.
Test move the slide.

18
 6. Click on the
"Design"
tab, and
select the
appropriate
design.
7. Save the PowerPoint at the appropriate folder, name "Computer".
8. Click "Slide Show" tab, click the "From the Beginning" button to see slide show.

************************************************************************

[1.] [Link]

19
 CHAPTER II
Typing Practice
English Keyboard Layout

Pyidaungsu Keyboard Layout (Reference [Link] )

ပါဌ်ဆင့်များရိုက်နည်း
ပါဌ်ဆင့်ပြုလုပ်လိုလျှင်အသတ်နေရာ၌ (Shift+f) ရိုက်ပေးရမည်။ (Shift+f) ရိုက်ပြီး
ဗျည်းထပ်ရိုက် သောအခါပါဌ်ဆင့်စာများဖြစ်ပေါ်လာမည်။ ထူးခြားသောပါဌ်ဆင့်များမှာ
ရိုက်နည်းနမူနာအချို့ကို လေ့လာ နိုင်ပါသည်။
စာလုံး English
စာလုံးပေါင်းပုံ
ပုံ key

ဋ္ဌ ဋ + ္‌+ ဌ # + F‌+ X လေ့ကျင့်ရန်-

သီဟိုဠ်မှ ဉာဏ်ကြီးရှင်သည်
ဏ္ဌ ဏ + ္‌+ ဌ P + F‌+ X အာယုဝုဍ္ဎန ဆေးညွှန်းစာကို
ဇလွန်ဈေးဘေး ဗာဒံပင် ထက်
ဍ္ဎ ဍ + ္‌+ ဎ ! + F‌+ ~ အဓိဋ္ဌာန်လျက် ဂလိဃနဏ ဖတ်
ခဲ့သည်။
ဏ္ဍ ဏ + ္‌+ ဍ P + F‌+ !

အာယုဝဍ္
အာယုဝဍ (shift F) ဎ န
ဎန

အဓိဋ္ဌာ
အဓိဋ (shift F) ဌာန်
န်
မတူကွဲပြားသော အက္ခရာများ
1. သုည ‘၀’ [key ‘0’] နှင့် ဝလုံး ‘ဝ’ [key ‘W’] မတူပါ
2. စလုံးရပင့် ‘စျ’ နှင့် ဇမြင်ဆွဲ ‘ဈ’ [key ‘Q’] မတူပါ
3. ညလေး ‘ဉ ‘ [key ‘N’] နှင့် အက္ခရာအု ‘ဥ’ [key ‘U’] မတူပါ
4. သရရစ် ‘သြ’ နှင့် အက္ခရာအော ‘ဩ’ [key ‘]’] မတူပါ

20
နမူနာပြ စာရိုက်နည်း
စာလုံးအချို့ကို နမူနာအဖြစ် အောက်ပါဇယားတွင် ရိုက်နှိပ်ပုံအဆင့်ဆင့်ကို ဖေါ်ပြအပ်ပါသည်။
ိ ုဗျည်းနောက်မှ
ု ံ ံ ့ ရိုက်ရပါမည်။ ိ ု ၊ ု ံ ၊ ံ ့ ကဲ့သိုသော အပေါ်အောက် စာလုံးများကို
နှစ်သက်ရာ အရင်ရိုက်နိုင်ပါသည်။ ၎င်းအစီအစဉ်များကို တမျိုးတည်း ဖြစ်စေရန် အလို
လျောက် ပြင်ဆင်ပေးပါလိမ့်မည်။
စာ
လုံး စာလုံးပေါင်းပုံ အင်္ဂလိပ်ကီးခလုတ်
ပုံ

ကျော
ေ+က+ျ+ာ+င+ ်+ း a+u+s+m+i+f+;
င်း

v+d+r+F+a+r+m
လ + ိ + မ + ္ + ‌ေ + မ + ာ + ်
လိမ္ + f(or)
(သို့)
မော် v+d+a+r+F+r+m
လ+ ိ +‌ေ + မ + ္ + မ + ာ + ်
+f

သင်္
သ + င + ် + ္ + ‌ေ + ဘ + ာ o+i+f+F+a+b+m
ဘော

ဥက္က O+u+F+u+#+F+
ဥ+က+္+က+ဋ+္+ဌ
ဋ္ဌ X

ဂုဏဝု *+k+P+W+k+!+F
ဂ + ု+ ဏ+ ဝ + ု+ ဍ + ္ + ဎ + ိ
ဍ္ဎိ +~+d

သဏ္ဌာ
သ+ဏ+္+ဌ+ာ+န+် o+P+F+X+m+e+f
န်

ဘဏ္ဍာ ဘ+ဏ+္+ဍ+ာ b+P+F+!+m

ဣန္
ဒြေ ဣ + န + ္ + ေ + ဒ + ြ (သို့) E + e + F + a + K + j (or)
ဣန္ ဣ+ေ+န+္+ဒ+ြ E+a+e+F+K+j
ဒြေ

ခြင်္ c+j+i+f+F+a+o+
ခ+ြ+င+်+္+ေ+သ+့
သေ့ h

သိင်္
သ+ိ+င+်+္+ဂ+ီ o+d+i+f+F+*+D
ဂီ

သင်္
သ+င+်+္+ဂ+ြ+ိ+ု+ o+i+f+F+*+j+d+
ဂြို
ဟ+် k+[+f
ဟ်

သင်္
သ+င+်+္+ခ+ျ+ိ+င+ o+i+f+F+c+s+d
ချိ
်+း + i + f;
င်း

21