course laboratory activity - buuic course...

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Advanced Computer Utilization Computer Laboratory No. 06

Microsoft Office Word 2010

FOLDERNAME: ACTIVITY NO. 06 FILENAME: activity6 (NicknameStudentNumber)

Example activity6 (Vinrey19)

Save in two file types namely: .dotm (Word Macro-Enabled Document) .docm (Word Macro-Enabled Template)

Basic Visual Basic for Applications in MS Word

Step 1:

Open the Microsoft Office Word 2010. Start creating a New Document by clicking the Menu Bar: File – New.

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Step 2:

Select Options from the File menu list.

Step 3 Choose Customize Ribbon from the Word Options dialog box. Tick the Developer and press OK button.

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Step 4 You will notice that a Developer menu is inserted in the menu bar.

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Step 5 Click the Developer menu and select the Visual Basic (Alt + F11) to open the Visual Basic Editor.

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Step 6 Insert UserForm from the toolbar.

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Step 7

Change the Form caption with COMPUTERIZED QUIZ in the Caption of Properties palette.

Step 8 Start placing controls on the form and follow the layout design shown below with control setting and declaration.

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Step 9 Add three additional forms by clicking Insert and select the UserForm.

Change again the Form caption with COMPUTERIZED QUIZ in the Caption of Properties palette. Hence, your project will contain four user forms.

UserForm No. 2

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

UserForm No. 3

UserForm No. 4

This portion shows the detailed

student examination result.

SCORE:

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Conditions: Percentage Score = (Score/15)*100 Needed Score = 100 – Percentage Score Comment Above 60 Percentage Score = Passed Below 60 Percentage Score = Failed You can change the questions

Additional:

Elsewhere in the form, double click your mouse and you will be prompted to the code window. Before the private sub, provide the following information as project code comments:

' STUDENT NAME:

' STUDENT NICKNAME:

' STUDENT NUMBER:

' COURSE & YEAR LEVEL:

' SUBJECT:

' TEACHER:

' DATE:

Step 10 Debug and run the program by clicking the Menu Bar: Run – Run Sub / User

Form (F5) or directly click this icon .

Double Click

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Alternative procedure in debugging the program.

Step 11 Save your project by clicking the Menu Bar: File – Save Document (Ctrl + S). From Save As dialog box, type the Filename as activity6

(NicknameStudentNumber). Choose .dotm and .docm as file types respectively and press save.

http: / /www.buuic.buu.ac. th

Burapha University International College Prof . Dr . Suchar t Upat ham Bui l d in g 169 Long -Had, Bangsaen Road, Tambon Saensoo k A m p h u r M u a n g , C h o n b u r i 2 0 1 3 1 , T h a i l a n d

Tel. No. : 0-3810-2571 to 2 Fax No.: 0-3874-5856

Jose Bartolome Santos ht tp: / /www. inter jobs jm.com

Final output of the program is shown below. This activity will perform computerized quiz with corresponding result in the end. Other functionality of controls will be discussed in the class.