 |
¡è͹Í×è¹µéͧ¢Í¡ÅèÒǶ֧ CAI ¡è͹¹èФÃѺ CAI (Computer Assisted Instruction) ¤×Í ¡ÒùÓàÍÒ¤ÍÁ¾ÔÇàµÍÃìà¢éÒÁÒªèÇÂ㹡ÒÃàÃÕ¹ áÅÐ ¡ÒÃÊ͹ ËÃ×Í ÍÂèÒ§ã´ÍÂèҧ˹Öè§¡çáÅéÇáµè ¹Ñ蹤×Í äÁèä´éàÍÒÁѹÁÒÊ͹᷹¤ÃÙ¹èФÃѺ («Öè§ÁÕËÅÒ¤¹à¢éÒ㨼Դä»àÂÍÐ) ... ËÅÒ·èÒ¹¡ç¤§·ÃÒº´ÕÇèÒâ»Ãá¡ÃÁ PowerPoint (¨Ø´ÍÔ·¸ÔÄ·¸Ôì) µÑǹÕé àËÁÒСѺ§Ò¹´éÒ¹»ÃЪÒÊÑÁ¾Ñ¹¸ì ¹Óàʹͧҹ «Ðà»ç¹ÊèǹãËè ¤×Í áººÇèÒÁѹà´Ô¹Ë¹éÒ ¶ÍÂËÅѧä´é ÍéÒÇ! áÅéÇÁѹ¨ÐàÍÒä»·Óà»ç¹ CAI ä´éÂÑ§ä§ ¡çã¹àÁ×èÍàÃ×èͧ¢Í§ ¡ÒÃ·Ó CAI ¹Ñé¹Áѹ¨ÐµéͧÁÕ¡ÒÃâµéµÍº (Interactive) ¡Ñº¼ÙéàÃÕ¹´éÇ áµè PowerPoint Áѹ·ÓäÁèä´é 䩹àŶ֧¨Ð¡ÅéҺѧÍÒ¨ ÁÒ·éÒ·ÒÂâ»Ãá¡ÃÁäÎ⫨Ӿǡ AuthorWare ËÃ×Í Flash ä´éÅèÐ ? ¼Á¢ÍºÍ¡¡è͹ä´éàÅÂÇèÒ µèÍ仡çÍÂèÒä»´Ù¶Ù¡ ËÃ×Í à¼Å͵ÑÇËŧ»ÅèÍÂä¡è ã¹ÊÔè§·Õè¤Ø³ÍÒ¨¨ÐÂѧäÁèÃÙé¨ÃÔ§ ¡ÑºÊÒ¾ѹ¸Øì¢Í§ MicroSoft Office à¢éÒ«ÐÅèÐ.
ºÃÔÉÑ·ÏäÁâ¤Ã«Í¿·ì ä´éÍ͡ẺÀÒÉÒâ»Ãá¡ÃÁÁÒµÑÇ˹Öè§ ·ÕèàÃÕ¡ÇèÒ Visual Basic ÀÒÉÒµÑǹÕé¶Ù¡ºÃèØàÍÒäÇéã¹ Miscrosoft Office ·Ø¡ÃØè¹à¾×èÍãªé㹡ÒþѲ¹Òã¹¢Ñé¹ÊÙ§ ·ÕèàÃÒ¨ÐÃÙé¨Ñ¡¡Ñ¹´Õã¹¹ÒÁ¢Í§ Visual Basic for Application (VBA) Íѹà»ç¹ÀÒÉÒ·Õè¤ÅéÒ¤ÅÖ§¡ÑºÀÒÉÒ Basic áµè¨Ð¹Óä»ãªé§Ò¹áµ¡µèÒ§¡Ñ¹Í͡仵ÒÁâ»Ãá¡ÃÁáµèÅеÑÇ àªè¹ ËÒ¡¹Óä»ãªéã¹ MS Excel ¡ç¨ÐàÃÕ¡¡ÒÃãªé§Ò¹ÃèÇÁ¡Ñº Work Sheet áÅÐã¹ PowerPoint ¡çµéͧàÃÕ¡ãªé§Ò¹ÁѹÃèÇÁ¡Ñº Slide (ã¹ÀÒÉÒ Basic ¨ÃÔ§æ¨ÐäÁèÁÕ) |
 |
Çѵ¶Ø»ÃÐʧ¤ì ... ÊÓËÃѺ§Ò¹¹Õé àÇÅÒ¹Õé ... ¼Á¨ÐäÁè͸ԺÒ¶֧¢Ñ鹵͹¡ÒÃÍ͡Ẻ ËÃ×Í ¡ÒÃà¢Õ¹â¤é´ 㹡ÒÃãªé§Ò¹ VBA ÊÓËÃѺâ»Ãá¡ÃÁ PowerPoint ËÃÍ¡¹èФÃѺ ¨Ø´ÁØè§ËÁÒÂËÅÑ¡æ ¡çà¾×èÍ·Õè¨Ð·ÓãËéàËç¹à»ç¹á¹Ç·Ò§ ¢Í§¡ÒþѲ¹ÒÊ×èÍ¡ÒÃàÃÕ¹/¡ÒÃÊ͹ ã¹ÅѡɳТͧ¡ÒÃâµéµÍº¡Ñº¼ÙéàÃÕ¹ä´é (Interactive) ´éÇÂâ»Ãá¡ÃÁ·ÕèÁѹÍÂÙèã¡ÅéæµÑÇàÃÒàͧ ... «Öè§äÁèÇèҤس¨Ð¾Ñ²¹ÒÊ×èÍ CAI ´éÇÂâ»Ãá¡ÃÁÍÐäáçáÅéÇáµè ËÒ¡äÁè½Ö¡¡ÒÃà¢Õ¹ Script ËÃ×Í ¡ÒÃà¢Õ¹â¤é´áÅéǹÑé¹ ÁѹäÁèÁÕ·Ò§·Õè¨Ð·ÓãËé§Ò¹ÁѹÍÍ¡ÁÒä´é´Ñè§ã¨¹Ö¡ËÃÍ¡¤ÃѺ ... áÅÐäÁèÁÕã¤Ã¨Ð·ÓÍÍ¡ÁÒä´é´Õà·èҡѺ¤¹Ê͹àͧ ¡çà¾ÃÒФ¹Ê͹ã¹àÃ×èͧ¹Ñ鹿ÁÒ¹Ò¹ËÅÒÂ»Õ ¡çÂèÍÁ¨ÐÃÙéÇèÒ´ÕÇèÒ¨ÐÊ×èÍÍÐäÃä»Âѧ¼ÙéàÃÕ¹ä´é ... à¾Õ§áµèËÅÒ·èÒ¹Âѧ¢Ò´¤ÇÒÁÃÙé ¤ÇÒÁà¢éÒã¨ã¹¡ÒÃãªé§Ò¹â»Ãá¡ÃÁ¤ÍÁ¾ÔÇàµÍÃì à·èÒ¹Ñé¹àͧ ... áÅéǨÐãËé·Óà»ç¹ä´éÍÂèÒ§äà ·Ø¡·èÒ¹¡ç¤§ÁդӵͺãËé¡ÑºµÑÇàͧÍÂÙèáÅéÇáËÅФÃѺ
|
ÍèÒ¹ËÅÑ¡¡ÒÃ㹡ÒÃá»Å§àÅ¢°Ò¹ 10 à»ç¹àÅ¢°Ò¹ 2 ´éÇÂÇÔ¸Õ¡ÒÃËÒÃÊÑé¹ (ÊÁÑÂà´ç¡æ¡çÂѧä´é¹ÓÁÒãªé)
 Êèǹ¢Í§ VBAProject 㹡ÒÃÍ͡Ẻ¿ÍÃìÁ áÅÐ à¢Õ¹â¤é´ VBA à¢éÒä»
 ˹éҨ͡ÒÃÍ͡Ẻ¨Ò¡ PowerPoint
 ÅӴѺ¢Ñ鹵͹¡Ò÷ӧҹ µÒÁËÁÒÂàÅ¢ 1 - 4 1. ¤ÅÔê¡àÅ×Í¡à¾×èÍãËé˹éҨͻé͹àÅ¢°Ò¹ 10 áÊ´§¼Å¢Öé¹ÁÒ 2. »é͹µÑÇàÅ¢°Ò¹ 10 à¢éÒä» ... ã¹â¤é´ VBA ¨ÐÁÕ¡ÒÃÅçͤ»ØèÁ à¾×èÍãËé¼ÙéàÃÕ¹¤ÕÂìä´éá¤èµÑÇàÅ¢ 0 - 9 à·èÒ¹Ñ鹤ÃѺ 3. ¤ÅÔê¡»ØèÁà¾×èÍ·Ó¡Òäӹdz¼Å 4. ¨ÐáÊ´§¼ÅÍÍ¡·Ò§Ë¹éÒ¨ÍÀÒ¾ Slide ¢Í§ PowerPoint
VBA ÊÓËÃѺ Slide1 ·ÕèÍÂÙèã¹â»Ãá¡ÃÁ PowerPoint
' à¡Ô´¡ÒäÅÔê¡»ØèÁ à¾×èÍ·Ó¡ÒÃá»Å§¤èÒàÅ¢°Ò¹ 10 à»ç¹àÅ¢°Ò¹ 2
Private Sub cmdDec2Bin_Click()
' áÊ´§¿ÍÃìÁ¡Òûé͹àÅ¢°Ò¹ 10 à¾×èÍ·Ó¡Òäӹdz¼Å
frmConvertDec2Bin.Show vbModal
End Sub
' ¨º¡Ò÷ӧҹ »Ô´ PowerPoint
Private Sub cmdExit_Click()
' ÍéÒ§ÍÔ§ª×èÍä¿Åì
With Application.Presentations("Sample CAI.ppt")
' ÊÑ觺ѹ·Ö¡ (Save) ¡è͹ÍÍ¡
.Saved = True
.Close
End With
End Sub
|
VBA ÊÓËÃѺ UserForm 㹡Òûé͹¤èÒàÅ¢°Ò¹ 10 áÅзӡÒÃá»Å§àÅ¢°Ò¹ (frmConvertDec2Bin)
Private Sub cmdConvertDec2Bin_Click()
' à¡çº¤èҤӵͺ¨Ò¡¡ÒÃàÍÒàÈɢͧàÅ¢°Ò¹ 2
Dim Bit As String
' µÑÇá»Ãà¡çº¤èÒàÅ¢°Ò¹ 10 áÅÐ ·Óä»àÃ×èÍÂæ¨¹¡ÇèҨзÓãËé Dec ÁÕ¤èÒà»ç¹ 0
Dim Dec As Long
' µÃǨÊͺÇèÒÁÕ¡Òûé͹¤èÒµÑÇàÅ¢°Ò¹ 10 ŧ㹠TextBox ËÃ×ÍäÁè
If Trim(txtDecimal.Text) = "" Or Len(Trim(txtDecimal.Text)) = 0 Then
txtDecimal.SetFocus
Exit Sub
End If
' ÃѺ¤èÒàÅ¢°Ò¹ 10 ¨Ò¡ TextBox (txtDecimal)
Dec = CLng(txtDecimal.Text)
' DO WHILE ... à§×è͹ä¢à»ç¹¨ÃÔ§¨ÐǹÃͺ ... à·ç¨àÁ×èÍäËÃè¡ç¨ÐÍÍ¡¨Ò¡ÅÙ»
Do While (Dec > 0)
Bit = (Dec Mod 2) & Bit
Dec = Dec \ 2
Loop
' áÊ´§¼Å¡ÒÃËÒàÅ¢°Ò¹ 2 ŧ㹠Slide1
Slide1.txtBinary.Text = Bit
End Sub
' #######################################################
' ¿Ñ§¤ìªÑè¹µÃǨÊͺ¡Òá´¤ÕÂìãËéÃѺä´é੾ÒФèÒ 0 - 9 (à¾ÃÒÐÁѹàÅ¢°Ò¹ 10 ¹Õè¤ÃѺ ¨Ö§ÃѺµÑÇàÅ¢ä´éá¤è¹Õé)
' #######################################################
Function CheckDecimal(ByVal KeyAscii As Integer)
Select Case KeyAscii
' ASCII Code 48 - 57 ¤×Í µÑÇÍÑ¡¢ÃÐ 0 - 9
Case 48 To 57
' ASCII Code 8 ¤×Í Back Space
' ASCII Code 13 ¤×Í Enter
Case 8, 13
Case Else
KeyAscii = 0
End Select
CheckDecimal = KeyAscii
End Function
Private Sub txtDecimal_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
' ËÒ¡à»ç¹¡Òá´¤ÕÂì Enter (vbKeyReturn ÁÕ¤èÒ ASCII Code = 13)
If KeyAscii = vbKeyReturn Then
KeyAscii = 0
SendKeys "{TAB}"
Else
' 仵ÃǨÊͺ¤èÒ㹿ѧ¤ìªÑ蹡è͹ÇèÒ ÁÕ¡Òá´àÅ¢ 0 - 9 ËÃ×ÍäÁè
KeyAscii = CheckDecimal(KeyAscii)
End If
End Sub
Private Sub UserForm_Initialize()
' ¡ÒõÑé§µÓá˹觢ͧ¿ÍÃìÁ¡Òûé͹¢éÍÁÙÅàÅ¢°Ò¹ 10
With Me
.StartUpPosition = 0
.Top = 10
.Left = Application.Left + Application.Width - Me.Width * 2
End With
End Sub
' ·Ó¡ÒÃâËÅ´¿ÍÃìÁ¡Òûé͹¤èÒ áÅÐ ¡ÒÃá»Å§àÅ¢°Ò¹ 10 ¢Öé¹ÁÒáÊ´§
Private Sub UserForm_Activate()
' à¤ÅÕÂÃì¤èҤӵͺ
Slide1.txtBinary.Text = ""
' à¤ÅÕÂÃì·Õè»é͹¤èÒàÅ¢°Ò¹ 10
txtDecimal.Text = ""
End Sub
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
' ¡è͹»Ô´¿ÍÃìÁ ãËéà¤ÅÕÂÃì¤èÒ TextBox (txtBinary) ãËéà»ç¹¤èÒÇèÒ§
Slide1.txtBinary.Text = ""
End Sub
|
¡ÒÃà»Ô´ä¿ÅìµÑÇÍÂèÒ§¢Öé¹ÁÒ
 ¡ÒÃà»Ô´ä¿Åì PowerPoint µÑÇÍÂèҧ㹵͹àÃÔèÁµé¹ ËÒ¡äÁèÁÕ¡ÒâÖé¹Ë¹éÒ¨ÍẺ¹Õé ãËéà¢éÒä»á¡é䢵ÒÁÀÒ¾·Ò§´éÒ¹ÅèÒ§
 àÅ×Í¡¡ÒÃÃÑ¡ÉÒ¤ÇÒÁ»ÅÍ´ÀÑÂ
 àÅ×Í¡¤ÇÒÁ»ÅÍ´ÀÑ»ҹ¡ÅÒ§ (µÒÁÀÒ¾)
àÇÅÒ·Õèµéͧ¡ÒÃãËé¼ÙéàÃÕ¹ Save ä¿ÅìäÇéà¾×è͹Óä»ÈÖ¡ÉÒ ËÃ×Í ·º·Ç¹º·àÃÕ¹ ¡çá¤èãËéºÑ¹·Ö¡ä¿Åìà»ç¹ PowerPoint Show ·ÕèÁÕ¹ÒÁÊ¡ØÅà»ç¹ PPS à¾×èÍᨡãËé¡Ñº¼ÙéàÃÕ¹ ... ¡çà»ç¹Íѹ¨º¤ÃѺ¼Á (ËÃ×Íãªéâ»Ãá¡ÃÁá»Å§ä¿Åìà»ç¹ EXE à¾×èÍãËé·Ó§Ò¹â´ÂäÁèµéͧ¼èÒ¹â»Ãá¡ÃÁ PowerPoint àÅ¡çä´é)


à»Ô´ÀÒ¾ÁÔµÔÁØÁÁͧãËÁè¢Í§â»Ãá¡ÃÁ PowerPoint ¡Ñº¡Ò÷ÓÊ×èÍ¡ÒÃàÃÕ¹ áÅÐ ¡ÒÃÊ͹ CAI
Conclusion: ¨Ò¡µÑÇÍÂèÒ§·Õè¹ÓÁÒáÊ´§¹Õé ¡çà¾×èÍ·Õè¨ÐãËéËÅÒÂæ¤¹ä´éÃÙé¨Ñ¡¡Ñº¤ÓÇèÒ CAI ÁÒ¡ÂÔè§¢Öé¹ «Öè§äÁèãªèá¤èà¾Õ§¡ÒÃÊÃéÒ§ÁѹÁÒ¨Ò¡â»Ãá¡ÃÁ AuthorWare/Flash ·Õè·ÓÍÍ¡ÁÒãËéà´Ô¹Ë¹éÒ ËÃ×Í ¶ÍÂËÅѧä´é à·èÒ¹Ñé¹àͧ áÅйÑ蹡ç¤×Í ¡ÒÃà¹é¹·Õè¨Ð·ÓãËé CAI ÁÕ»¯ÔÊÑÁ¾Ñ¹¸ì ËÃ×Í ÁÕ¡ÒÃâµéµÍº¡Ñº¼ÙéàÃÕ¹ ã¹ÅѡɳТͧ Dynamic ´Ñ§¹Ñ鹤ÃÙ ÍÒ¨ÒÃÂì ËÃ×Í ¼Ùé·Õè¤Ô´¨Ð¼ÅÔµ CAI ÍÍ¡ÁÒ ¤Çèеéͧ·Ó¤ÇÒÁà¢éÒ㨡Ѻà¹×éÍËÒ·Õè¨ÐÊ͹ÍÂèÒ§ÅÐàÍÕ´ áÅÐ ¤è͹¢éÒ§¨ÐµéͧÁÕ¤ÇÒÁÃÙé ÁÕ¤ÇÒÁàªÕèÂǪÒà»ç¹ÍÂèÒ§Áҡ㹡ÒÃãªéâ»Ãá¡ÃÁ¤ÍÁ¾ÔÇàµÍÃì «Öè§ã¹á¹Ç·Ò§¹Õé àÃÒ¨Ðãªé㹡ÒÃÍ͡Ẻ CAI ã¹ÅѡɳÐÃٻẺ·ÕèàÃÕ¡ÇèÒ CourseWare µèÍ仹Ñè¹àͧ.
|