A. SUBJECT INFO & COURSE CONTENTS 1. Title of subject 2. Subject code 3. Status of subject 4. Credit hour Lan’s Credit Hour Equivalent 5. Semester 6. Pre-Requisite 7. Method of delivery 8. Assessment Computer Applications and Programming in Visual Basic PCA 0045 Core 4 4 Trimester 1, Pre-University / Foundation Year None Lectures & Laboratories Quizzes Assignment Project Mid Trimester Final Examination Total 5 % 10 % 15 % 20 % 50 % 100 %
9. Teaching staff
Abdul Malik Abdullah, Nurhayati Yusoff, Khairol Nizat Lajis, Gary Bruce Wright, Mohd Zulfaezal Che Azemin To further enhance understanding and appreciation of computer applications and enable students to apply the working knowledge gained. To introduce students to the programming fundamentals and techniques in Micorsoft Visual Basic. At the completion of the subject, students should be able to: 1. define the term computer and identify its component 2. describe the categories of computers 3. identify the types of software 4. illustrate the concept of networking and identify the types of network 5. explain why database is important and identify the types of database 6. identify the different elements of multimedia and its applications 7. discuss various computer applications in society 8. write programs/applications using Visual Basic Programme Outcomes Strong basic knowledge to pursue degree in IT related disciplines Strong IT, problem solving and analytical skills Good team work, both as a leader and as a team member Highly motivated and capable of continuous selfimprovement and self-development Dedicated, committed, professional and ethical in carrying out duties and responsibilities % of contribution 40 30 10 10 10
10. Objective of subject
11. Learning Outcome
12. Synopsis of subject (BI & BM)
Students will learn concepts of computer systems (software and hardware), basic networking concepts, databases and security issues. Aquire skills in using MS Word, Excel, Powepoint and Access and programming in Microsoft Visual Basic. Pelajar akan belajar konsep sistem komputer (perisian dan perkakasan), konsep asas rangkaian komputer, pengkalan data dan isu keselamatan. Memantapkan kemahiran menggunakan MS Word, Excel, Powerpoint dan Access dan juga pengprograman dalam Microsoft Visual Basic.
13. Details of subject
Contents The History and Basics of Computing History of computing: computer generations, the historical development of PC and software. Basic concept of information processing: input-process-output concept Hardware The Central Processing Unit: What goes on inside the computer: Input and Output; Storage and Multimedia; Classification of computer hardware Software System software. Basic functions of operating system. General purpose application packages : word processors, desktop publishing, spreadsheets and business graphics, database management systems Connectivity and Networking Communications channels and related hardware. Data transmission: speed, directions, methods, bits, bytes, transmission protocol. Network configurations: LAN, WAN, topologies. Distributed and client-server computing. Internet and World Wide Web Database Management and Information Systems Database organizations and DBMS: hierarchical, network, relational, and object-oriented. Management Information Systems (MIS): decision support systems, executive information systems, expert systems Programming and Languages The meaning of programming, the programming process, levels of language, major programming languages, object-oriented languages, visual language Graphics and Multimedia Graphic images, simple image processing, animation, computeraided design, and applications of computer graphics. Introduction to multimedia, multimedia applications, multimedia hardware and software, CD-ROM, desktop publishing. Computer in Society Impact of computer on society: ethics, privacy, security, and computer crimes. Malaysia's MSC and Cyber Law: seven flagship applications and the cyber laws. Total Contact Hours LAN’s Equivalent Credit Hours
Lectures 2
Tutorial
7
4
4
2
4
3
3
29 2.07
14. Main Reference 15. References
Shelly, G. B., Cashman, T.J. Vermaat, M. E. (2007) Discovering Computers 2007: A Gateway to Information Web Enhanced. Thomson Learning, United States 1. Norton, P. (2006). Peter Norton’s Introduction to Computers (6th Ed.). MacGraw Hill Technology, Boston, USA. 2. Shelly, G. B., Cashman, T.J. Vermaat, M. E. (2002) Microsoft Office XP: Introductory Concepts and Techniques. Thomson Learning, United States. 3. Capron, H.L., Johnson, J. A. (2004) Computers, Tools for the Information Age (8th Edition). Prentice Hall, USA 4. Grauer, R.T., Barber, M.(2002) Exploring Microsoft Office XP. Prentice Hall, USA. 5. Pelland, Patrice (2006).Build a Program Now! Visual Basic 2005 Express Edition Microsoft Press, USA 6. Krawitz, Ron (2006) An Introduction to Programming Using the Tool: Visual Basic 2005. Thomson Learning, Clifton Park, New York. 7. Ford, Jerry Lee (2006). An Microsoft Visual Basic 2005 Express Edition Programming for the Absolute Beginner. Thomson Course Technology, Boston, MA. Content Operating System: Windows XP and DOS Features in Windows XP: Window Explorer, My Computer, Recycle Bin The User Interface Windows XP Accessories: Customizing Windows. Basic DOS commands Microsoft Word Introduction to Word, entering and editing text, font formatting, paragraph formatting, automatic text formatting, page formatting, creating tables, clip arts, drawing. Microsoft Excel Introduction to spreadsheet using Excel. Microsoft PowerPoint Introduction to presentation using PowerPoint. Microsoft Access Introduction to databases using Access Programming using Visual Basic Introduction to programming fundamentals, Event driven programming, VB Forms, VB controls, objects, properties , VB data: data types, variables, operators, Program flow: if, if-then-else, for-next loop, do-loop, do-while, do-until, while, select case, VB Functions and procedures, User defined functions, Designing menus and toolbars, VB multimedia applications, VB database applications. Total Contact Hours LAN’s Equivalent Credit Hours Laboratories 4
15. Laboratories
4
4
4
4
36
56 2.00
B: LECTURE PLAN Contents Week 1 Topic 1 : The History and Basics of Computing Lab: Windows XP and DOS
Tutorial Tutorial 1
Assignment/Quiz/Test
2 3 4
Topic 2 : Hardware Lab : MS Word Topic 2 : Hardware Lab : MS PowerPoint Topic 2 : Hardware Lab : MS Excel Topic 3 : Software Lab : MS Access Topic 3: Software Lab : MS Access Topic 4- Connectivity and Networking Lab : Programming using Visual Basic Topic 4- Connectivity and Networking Lab : Programming using Visual Basic Topic 5- Database Management and Information Systems Lab : Programming using Visual Basic Topic 6- Programming and Languages Lab : Programming using Visual Basic Topic 6- Programming and Languages Lab : Programming using Visual Basic Topic 7- Security Lab : Programming using Visual Basic Topic 7 & 8 - Security / Multimedia Lab : Programming using Visual Basic Topic 8 - Multimedia Lab : Programming using Visual Basic
Tutorial 1 Tutorial 2 Tutorial 3
Quiz 1 Assignment 1 Quiz 2 Assignment 2
5 6 7 Break 8 9
Tutorial 4 Assignment 3 Tutorial 3
Midterm Exam Tutorial 4
10 11 12 13 14
Assignment 4 Tutorial 5 Quiz 3 Assignment 5 Tutorial 6 Quiz 4 Project