VB
06036044 Visual Programming
A special workshop in Information technology aims to make the experience of software development and bring the student to create a graduate project. After studying, you can know how to debug and develop application software with Visual Basic.
The objective of this course is to study the command and syntax of Visual Basic, to be able to make a small application to solve a business problem and to understand object-oriented programming concepts and how to apply them in an application.
Schedule
Week
Date
Topic
Download
1
17-Jan
History of VB, VBA, and VB.NET
Variable
Mathematics symbols
Button component
component property
Dev: Hello world
Dev: Counter
Dev: Cross component setting
Dev: Radius to Area
Slide
VIDEO
2
24-Jan
Conditions (if-else, switch case)
Debugging
Global and local variable
Textbox component
Label component
String to value conversion
Dev: Feet to Meter
Dev: Radius to Area with value limitation
Dev: Word length
Dev: Floating point with precision limited
Quiz1
Slide
VIDEO
3
31-Jan
Loop (for, while, do-while)
Debugging with break-point setting
Listbox component
Dev: Count-up to N
Dev: Count-down to N
Dev: Slow display counter
Quiz2
Slide
VIDEO
4
7-Feb
Nest Loops
Message box dialog
Progress bar component
Loop with conditions
Dev: Counter-up with skipping sum values
Dev: Sum of value skipping sum values
Quiz3
Slide
VIDEO
5
14-Feb
Single dimensional array
Debugging array value
Input box dialog
Dev: 100data collects into a box
Dev: 100data sorting
Dev: String reversal
Quiz4
Slide
VIDEO
6
21-Feb
Multidimensional array
Debugging multidimensional array
Dev: Calculate a determinant of a 2x2 matrix
Dev: Transpose 2x2 matrix
Quiz5
Slide
VIDEO
7
28-Feb
Multidimensional array collected string
Dev: 100 words English-Thai dictionary
Quiz6
Slide Source
8
7-13-Mar
Midterm examination week in this course does not take the midterm exam.
9
21-Mar
User-defined function and Sub
Passing by value and passing by reference
Combo box component
Protection from unconscious closing application
Dev: improvement 100 words English-Thai dictionary by spiting the code to make functions
Slide
10
28-Mar
Single structure
Debugging structure
Dev: ID card collected data in a structure
Dev: Switch two structure displays on the dialog
Quiz7
Slide
11
4-Apr
Class
Difference between class and structure
Dev: Class
Dev: Shared
Dev: Interactive components
Quiz8
Slide
12
25-Apr
Write a text message to a text file
The open text file and display
Dev: Write text to file and open it
Quiz9
Slide
13
27-Apr
Makeup class
Image open and save
Image rotation, mirror, and invert color
Quiz10
Slide
14
15
16
2-May
Presentation student project
17
Score and evaluation
80% Quiz every week
20% Final examination
References
[1] Diane Zak, Programming with Microsoft Visual Basic 2010, Fifth Edition. Course Technology, Cengage Learning, 2012, ISBN 13: 978-1-1115-2943-7.
[2] Michael Halvorson, “Microsoft® Visual Basic ® 2008 Step by Step”, Microsoft Press, Redmond, Washington, 2008, ISBN- 978-0-735-62537-2, Page546
[3] Thearon Willis, Bryan Newsome, “Beginning Microsoft® Visual Basic® 2008”, Wiley Publishing, Inc., 2008, ISBN 978-0-470-19134-7, QA76.73.B3W4556
[4] VBA Automation for Excel 2019 Cookbook, Packt
Related website