ITS332

Introduction
Introduction ITS332

Class & Lab Materials
[1] Lesson Plan
[2] Notes ITS332
Chapter 01 – Intro to SAD
Chapter 02 – Analyzing the Biz Case
Chapter 03 – Requirements Modelling
Chapter 04 – Data & Process Modeling
DFD Examples
Chapter 05 – Development Strategies
Chapter 06 – Output & User Interface Design
Chapter 07 – System Implementation
Chapter 08 – System Operation & Support
[3] Lab Introduction
Lab 01
Lab 02
Lab 0Lab 023
Lab Workshop
[4] Test PHP Folders

Mini Project || 40%
[1] Assignment Cover
[2] SoftwareDevelopmentPlan||BLUE||4%|| 19/06/2014
[3] SoftwareRequirementSpecification||LIGHT PINK||4%||09/07/2014
[4] SoftwareDesignDocumentation||LIGHT PURPLE||4%||23/07/2014
[5] SoftwareTestingRequirement||LIGHT YELLOW||4%||17/09/2014
[6] UserManual||LIGHT ORANGE||4%|| 17/09/2014
[7] Final Project Report ||WHITE||10%||21/09/2014
[8] Project Submission Guideline
[9] Final Project Presentation Guideline
[10] GroupPresentationRubric
[11] System Application Evaluation Rubric (Technical)

Test || 20%
[1] Test 1 || Chapter 1 – Chapter 4|| 13/08/2014
[2] Test 2 || Chapter 5 – Chapter 8|| 11/09/2014

CSC134

Introduction
CSC134 Introduction Slide

Notes
[01] Chapter 1: Introduction
[02] Chapter 2: The System Unit
[03] Chapter 3: Input & Output
[04] Chapter 4: Secondary Storage
[05] Chapter 5: System Software
[06] Chapter 6: Application Software
[07] Chapter 7: Internet & Web
[08] Chapter 8: Communications & Networking
[09] Chapter 9: Privacy, Security, Ethics and Ergonomic

Laboratory Modules
Laboratory Modules are as attached below. Please do revision (teks books, google) to strengthen your knowledge + understanding.

[01] Ms Word 2007 || Lesson 2
[02] Ms PowerPoint 2007 ||
[03] Ms Excel 2007 ||  Lesson 1 || Lesson 2

Lab Assignment:
[01] Lab Assignment 1 || 09/06/2014
[02] Lab Assignment 2 || 14/07/2014
[03] Lab Assignment 3 || 03/08/2014
[04] Lab Assignment 4 ||

Theory Assignment:
[01] Theory Assignment 1 || 03/08/2014
[02] Theory Assignment 2 ||
[03] Theory Assignment 3 ||

Quiz:
[01] Quiz 1 || 13/07/2014
[02] Quiz 2 ||

Test:
[01] Test 1 || Chapter 1 Chapter 4 || 21/07/2014
[02] Test 2 ||

**Puan Suhailah Yusof will take over the class from 3 August until end of the semester.        Submit your Lab Assign 3 + Theory Assign 1 @my office.Your Lab Assign 3 + Theory Assign 1 + Test 1 will be return asp. Pls submit your MC for June & July to me before 14th August 2014 as I will key in your data in i-StAbS (Student Absence System). All da best in this subject 

ITS232

Notes are as attached below. Please do revision (teks books, google) to strengthen your knowledge + understanding.

ITS232 Syllabus

[1] Chapter1: Database Concepts
[2] Chapter2: Data Models
[3] Chapter3: The Relational Model
[4] Chapter4: Entity Relationship (E-R) Modeling
[5] Chapter5: Normalization -part1
[5] Chapter5: Normalizations -part2
[6] Chapter6: Database Design
[7] Chapter7: SQL: Part 1
[7] Chapter7: SQL: Part 2
[7] Chapter7: SQL: Simple SQL Queries
[7] Chapter7: SQL: Retrieving Data From Multiple Tables

Mini Project

[1] Surat Kebenaran Untuk Organisasi
[2] Proposal Form || 30/06/2014
[3] Proposal || 17/07/2014
[4] Proposal Overview
[5] Proposal Front Page
[6] ITS232MINIrubric
[7] Final Project Report || 14 September 2014 
[8] Final Project Presentation || 16 & 17 September 2014 

Mini Project Topic
[1] Newspaper Collection | Aimi, Liyana, Syazwani |
[2] Booking Books | Karmiela, Emma, Farhana |
[3] Cakes Mngt Sys | Idris, Syafiq, Danish |
[4] Cinema | Fatin, Eliena, Mashitah |
[5] Fitness Center | Nazirul, Marwan, Imaduddin |

Lab Modules

[1] StudentManual_IBM DB2
[2] DB2 Installation

Lab Exercises

[1] Ex1-Simple SQL Queries
[2] Ex2-Retrieving Data From Multiple Tables
[3] Ex3-Scalar Functions and Arithmetic
[4] Ex4-Column Functions and Grouping
[5] Ex5-UNION
[6] Ex6-Using Subqueries
[7] Ex7-Maintaining Data

Tutoriol

[1] Tutorial 1: Database Concepts || 02/07/2014
[2] Tutorial 2: ERD || ERD 2-2 || 
[3] Tutorial 3: Normalization || NZ 3-1
[4] Tutorial 4: SQL || SQL 4-1 || SQL 4-2

Test

[1] Test 1  || Chapter 1 – Chapter 4 ||12/08/2014
[2] Test 2 || Chapter 4 – Chapter 7 || 10/09/2014