BSIT-2K12 5th Semester Course Contents

BSIT-2K12 5th Semester Course Contents


Visual Programming


Course Title: Visual Programming
Course Code: ITEC 510-511
Degree Program: BS (Information Technology) P-III (5th Semester)
Course rating: 3 credit hours (Theory) and 1 credit hour (Practical)
Pre-requisites: Data Structures, Object Oriented Programming

Course Objectives:

To equip the graduates with the knowledge of using the components and rules of the chosen programming language (i.e. Visual Basic 6.0) to implement a working version of a software product that meets typical quality standards.

Syllabus Outline:

  • Introduction: Introduction of Visual Programming, Event Driven Programming, Object Based Language and Visual Basic.

  • Creating Simple Interfaces: Form Basics, Setting Form Properties, Defining the Startup Form, Adding Controls to a Form, Pacing Controls on a Form, Setting Control Properties, Events, Writing Code for an Event, Accessing the Code Editor, Running the Application.

  • Using Variables & Constants: Variables, Understanding the Common Type System, Declaring & Using Variables, Naming Requirements, Option Explicit, Assignment, Scope, Using Constants, Type Conversion, Structures, and Arrays.

  • Using Procedures: Procedure basics, Creating & calling Sub Procedures, Creating & calling Function Procedures, Using Arguments, Passing Standard Arguments, Passing ByRef, Passing Arrays, Optional Arguments, Overloading, Using Built-in Functions and Using the Sub Main.

  • Operators & Expressions: Operators, Building Expressions, Using Strings

  • Control of Flow Logic: Using the If...Then Structure, Using the Select Case Structure, Using the Do...Loop Structure, Using the For...Next Structure and Using the For Each...Next Structure

  • Working with Forms: Creating Form Instances, Working with Multiple Forms, Drag & Drop

  • Windows Controls: Overview of Windows Controls, Label, TextBox, Button, CheckBox, RadioButton & GroupBox, PictureBox, Panel, ListBox, CheckedListBox, ComboBox, TabControl, DateTimePicker, MonthCalendar, Timer, ImageList, Splitter, DomainUpDown, NumericUpDown, ToolTip, ContextMenu, ToolBar, StatusBar, ErrorProvider and NotifyIcon

  • Using Dialogs: MessageBox, InputBox, Common Dialogs, Creating Custom Dialog Forms

  • Multiple Document Interface: Why MDI, Creating MDI Windows, MDI & Menus, Cascade & Tile

  • File IO: Directory & DirectoryInfo Classes, File & FileInfo Classes, Stream Classes, StreamReader & StreamWriter Classes, StringReader & StringWriter Classes.

  • Database Connection: Types of database connectivities in Visual Basic

Learning Material/References:

* Visual Basic 6.0. HOW TO PROGRAM by Deitel & Deitel, T. R. Nieto

* Mastering Visual Basic 6.0 by Evangelos Petroutsos




Introduction to Software Development


Course Title: Introduction to Software Development
Course Code: ITEC 512-513
Degree Program: BS (Information Technology) P-III (5th Semester)
Course rating: 2 credit hours (Theory) and 1 credit hour (Practical)
Pre-requisites: System Analysis & Design

Course Objectives:

This course covers some topics related to managing and improving the software development processes.

Syllabus Outline:

  • Introduction: Software development life cycle, Identifying software development roles, Matching roles to activities, Gathering software requirements, Eliciting requirements from users, Developing software iterations.

  • Analyzing User and System Requirements: Creating use case diagrams, Identifying actors and use cases, Representing user-system interactions, Capturing user stories, Describing system functionality from the user perspective, Recognizing viable user stories, Detailing use cases, Elaborating on complex system behaviors, Scripting user and system conversations, Documenting non-functional and system requirements.

  • Designing User Interfaces (UI): Refining the use case analysis based on user feedback, Analyzing the use case to determine system functional requirements, Sketching a UI mock-up, Transferring your UI mock-up into a prototype, Leveraging a prototyping tool, Laying out screens and controls, Setting form and control properties.

  • Programming Fundamentals: Handling and manipulating program data, Declaring variables, Defining data types, Handling events and event-driven programming, Structuring application behavior, controlling code execution with conditional logic, Organizing code inside functions, Passing arguments to functions, Calling and returning data with functions.

  • Crafting an Object-Oriented Class Hierarchy: Refactoring code to improve design, Applying the Single Responsibility Principle (SRP), Dividing functionality into classes, Modeling applications with UML class diagram, Simplifying UI code with the Model View Controller (MVC) pattern, Separating UI and application logic, Designing controller classes, Improving code maintainability with inheritance, Removing code duplication, Disentangling complex conditional logic.

  • Coding with Classes and Objects: Constructing classes, Defining fields and methods, Encapsulating and accessing object data, Maximizing program flexibility with inheritance and polymorphism, Creating and realizing base classes, Defining virtual and abstract methods, Overriding base class behavior, Reusing code at runtime, Instantiating classes and executing object behavior, Sending messages from objects using events, Throwing and catching object exceptions.

  • Saving Data to Storage: Defining data requirements, Drawing UML data models, Representing data relationships and multiplicities, Programming entity classes, Creating and accessing relational databases.

  • Testing and Deploying an Application: Creating test plans, Scripting user acceptance tests, Automating unit tests, Testing non-functional requirements, Delivering a first iteration software project

Learning Material/References:

* Software Engineering: A practitioner's approach, fifth edition By Roger S Pressman (Pressman)




Database Systems


Course Title: Database Systems
Course Code: ITEC 514-515
Degree Program: BS (Information Technology) P-III (5th Semester)
Course rating: 3 credit hours (Theory) and 1 credit hour (Practical)
Pre-requisites: Data Structures

Course Objectives:

The course introduces the theoretical and practical concepts used to develop and implement relational database applications for business. Special emphasis is placed on data modeling, database design and normalization, and relational database querying through SQL.

Syllabus Outline:

  • Databases and Database Users: Introduction, Characteristics of Database Approach, Advantages and Disadvantages of Using DBMS.

  • Database System Concepts and Architecture: Data Models, Schemas and Instances, DBMS Architecture and Data Independence, Database Language and Interfaces, Classification of Database Management Systems.

  • Data Modeling Using The Entity Relationship Model: Entity Types, Entity Sets, Attributes And Keys, Relationships, Relationship Types, Roles, And Structural Constrains, Weak Entity Types, ER Diagrams, Naming Conventions And Design Issues.

  • The Relational Data Model, Relational Constrains & Relational Algebra: Relational Model, Relational Constraints And Relational Database Schema, Update Operations And Dealing With Constraint Violations, Basic Relational Algebra Operations.

  • Writing Basic SQL Select Statements: SQL SELECT Statement, Basic SELECT Statement, Selecting Columns, Arithmetic Expressions, Defining Null Value, Column Alias, Concatenation Operator, Literal Character Strings, Overview of iSQL*Plus.

  • Restricting and Sorting Data: Using where clause, Comparison Conditions, Between, IN, LIKE, NULL, Logical Conditions, Order By Clause.

  • Displaying Data From Multiple Tables: Cartesian Products, Equi Join, Non-equi Join, Outer Join, Self Join, Natural Join

  • Group Functions: AVG, SUM, MIN, MAX, COUNT, Group By & Having Clause Subqueries: Using a subquuery, Single row subquery, Multiple Row Subquery.

  • Manipulating Data: Introduction to DML, INSERT, UPDATE, DELETE, Creating and Managing Tables: Database Objects, Create Table Statement, Data types, Alter Table Statement, Dropping a table, adding comments to a table.

  • Including Constraints: Defining Constraints, NOT NULL Constraint, UNIQUE Constraint, PRIMARY KEY Constraint, FOREIGN KEY Constraint, CHECK Constraint.

  • Views: Creating View, Querying a View, Rules for Performing DML operations on the view, Removing Views.

  • Functional Dependencies and Normalization for Relational Databases: Informal Design Guidelines for Relation Schemas, Functional Dependencies, Normal Forms Based on Primary Keys, General Definitions of Second and Third Normal Forms.

Learning Material/References:

* Database Systems: A Practical Approach to Design, implementation, and Management' 3ed, Connely and Begg (Addison Wesley, 1999)

* 'An Introduction to Database System' 7ed, CJ Date (Addison Wesley, 2000)




Computer Communication & Networks


Course Title: Computer Communication & Networks
Course Code: ITEC 516-517
Degree Program: BS (Information Technology) P-III (1st Semester)
Course rating: 2 credit hours (Theory) and 1 credit hour (Practical)
Pre-requisites: Telecommunication Systems

Course Objectives:

The aim of this course is to help students to gain an understanding of terminology and standards in modern day computer networks. To make the students gain an understanding of communication basics, networking and network technologies, emphasizing data and computer communication within the framework of the OSI and TCP/IP protocol architectures, internet and internetworking and how to apply these in design and analysis of networks.

Syllabus Outline:

  • Computer Network Architectures and Models: A Communication model, Data Communication and Networking, Protocol Architecture, A Simple Protocol Architecture, OSI Model, Standardization with in the OSI Framework, Services Primitives and Parameters, The OSI Layers, TCP/IP Protocol Architecture, The TCP/IP Layers, TCP and UDP, Operation of TCP/IP.

  • Communication Concept and Terminology: Transmission Terminology, Frequency, Spectrum and Bandwidth, Analogue and Digital Data, Analogue and Digital Signals, Analogue and Digital Transmission, Transmission Impairment, Attenuation, Delay Distortion, Noise, Channel Capacity, Nyquist Bandwidth, Shannon Capacity.

  • Guided and Wireless Transmission Guided: Transmission Media, Twisted pair, Coaxial Cable, Optical Fibre, Wireless Transmission, Antennas, Terrestrial Microwave, Satellite Microwave, Broadcast Radio, Infrared, Wireless Propagation, Line-of-Sight Transmission.

  • Signal Encoding Techniques: Digital Data Nonretrun to Zero, Multilevel Binary, Biphase, and Modulation Rate.

  • Digital Data Communication: Asynchronous and Synchronous Transmission, Types of Error, Error Detection, Line Configuration, Interfacing.

  • Data Link Control, Flow Control: Stop and Wait, Sliding Window, Error Control, Stop and Wait ARQ, Go Back N ARQ, HDLC, Basic Characteristics, Frame Structure and Operation.

  • Multiplexing: FDM, TDM, ADSL, xDSL.

  • Circuit and Packet Switching: Switched Communication Networks, Circuit Switching Concepts, Control Signalling, Soft switch Architecture, Packet Switching Principles X.25, Frame Relay.

  • ATM:  ATM Logical Connection, ATM Cell, Transmission of ATM Cell, ATM Layers.

  • Routing in Switched Network: Routing in Circuit Switching Networks, Routing in Packet Switching Networks, Least Cost Algorithm, Dijkstra's Algorithm.

  • Congestion Control Effects of Congestion, Congestion Control, Traffic Management.

  • LAN Systems Background: Topologies and Transmission Media, LAN Protocol Architecture, Bridges, Layer 2 and Layer 3 Switches.

  • High-Speed LANs: Emergence of High Speed LANs, Ethernet, Token Ring, Fibre Channel.

  • Wireless Networks, Overview, Wireless LAN Technologies, IEEE 802.11 Architecture and Services.

  • Internetworking and Routing: Basic Protocol Function's, Principle of Internetworking, Connectionless Internetworking, Internet Protocol, IPv6, Internetworking Operations, Multicasting, Routing Protocols, Autonomous System, RIP, BGP, OSPF.

  • TCP and UDP Protocols, Connection-Oriented Transport Protocol Mechanism, TCP Services, TCP Header Format, TCP Mechanism, TCP Conjunction Control, UDP.

  • Network Security, Security Requirements and Attacks, Confidentiality, Public and Privet Key Algorithm.

  • Network Applications, SMTP, MIME, HTTP, SNMP.

Learning Material/References:

* Data Communications & Networking by Behroz Forouzan

* Data and Computer Communications by William Stallings

* Computer Networks, 4th Edition by Andrew S Tanenbaum


Web Engineering


Course Title: Web Engineering
Course Code: ITEC 518
Degree Program: BS (Information Technology) P-III (5th Semester)
Course rating: 3 credit hours (Theory) and 1 credit hour (Practical)
Pre-requisites: None

Course Objectives:

This course aims to provide the skills of Designing and implementation of web based applications. It includes Basic and advanced Internet programming and their implementation in html, Java scripts and VB scripts & active server pages, design & implementation of commercial web pages, design & management of electronic commerce related objectives.

Syllabus Outline:


  • Introduction to Internet Programming: Client Server model, Web Browsers, HTTP

  • Basic HTML: headers, body, basic html tags, tables, Unordered and Ordered Lists

  • HTML Form Processing: Building a form, Text fields and value, size, maxlength, html buttons, radio, checkboxes, prechecked, Selection lists Action and Method - GET and POST. Client Side Scripting Languages: Basics of JavaScript and VBScript

  • Web Servers: Introduction to some popular Web Servers (Apache, IIS, etc)

  • CGI: Introduction to CGI scripting, html form interface with CGI scripts, automating processing such as info forms and email, Programming CGI interfacing via forms.

  • Server Side Scripting Engines: Introduction to Active Server Pages and Java Server Pages

  • Servlets: Introduction to Java Servlets API File and Database Connectivity


Learning Material/References:

* Internet & World Wide Web How to Program 3rd Edition) by Harvey M. Deitel, Paul   J. Deitel and Andrew B. Goldberg.

* Web enabled Commercial Application Development Using…HTML, DHTML,

Like this post?? Share with your friends.
 
Top