Instructor: Irfan Ahmed Ilyas


Recent (New) Announcements (at the BEGINNING)

Old (outdated) Announcements

Announcement Text  Posted On

TIME: 7:30 AM
DATE: June 5, 2005
DAY: Sunday
LOCATION: Gymnasium (Building 11)

Exam Coverage

Old Topics
   -Spreadsheets (Lecture Slides 4 till 10)
   -Databases (Lecture Slides 13 till 20)

New Topics
  -Chapter 8 (Lecture Slides 23 till 26 + All pages in chapter 8)
  - Chapter 14 (Lecture Slides 27 till 28 + Pages 368 -382, 384-386)
  - Chapter 5 (Lecturer Slides 29 + all pages in chapter 5)

Exam Contents

Chapter8...Internet   - 30%         
Chapter14...Progamming  - 40%   (both lec & lab coverage is included)
Chapter5..Input and Output – 20%
Old topics (database  + spreadsheets) – 10% (Database Forms also included)

Number of questions = 80
T/F  = 40 Q
MCQ = 40 Q

16th April
 Major02 Details:  
5th of May ,  1:00pm - 3:00pm, Building 10

Chapter 4 – Complete Chapter

Database Topics – Selected topics from Chapter 2, Chapter 11 & Lecture Notes/ Slides
   * Chapter 2 (page 43 to 45)
   * Chapter 11 (pages 290, 291, 294, 295, 301 - 303)
   * from Lec10 to  Lec21 (all are included)

Database Concepts & Definitions
Data Organization in databases –Files, Records, Fields
Concept of Key Field
Main activities in Database Maintenance
-Defining data
-Creating data
-Manipulating data

Applications of Databases in Businesses

Database Implementation Approaches
-Flat file approach (using a single file)
-Benefits/ Drawbacks
-Integrated file approach (using table relationships) -Benefits/ Drawbacks

Concept of Data Structural Independence & Data Dictionary

Users in a DBMS Environment – DBA, End Users, System Analysts, Database Designer

Example DBMS packages – including ACCESS, ORACLE, SQL SERVER, COREL PARADOC etc.

Introducing Microsoft Access

Details of Access Interface Objects – Brief discussion of Table, Query, Form, Report, Page, Macro, Module

Table Object Functionalities
- Data Definition (Design view)
- Data Manipulation (Datasheet view)
- Data Analysis (Pivot table view)

Data Type Details- -Character/ Number/ DateTime/ YesNo/ Binary Data/ OLE/ Hyperlink etc.

Field Property Details – Indexing/ Validation Rule/ Format/ Input mask (brief discussions)

Use of Filtering and Sorting on Table datasheet view
-Filter by selection
-Filter by form
-Sorting with more than one field

Concepts of Data Integrity
-Single Table Integrity Constraints
-Referential Integrity Constraints

Significance of Table Relationships
-Controlling Referential Integrity
-Building Queries

Referential Integrity Maintenance Approaches
-One-to-One Relationship Maintenance
-One-to-Many Relationship Maintenance

Database Queries
Available Query Types in Microsoft Access
-Data Manipulation Queries
-Data Definition Queries

Creating Queries in Access
-QBE (Query By Example)
-SQL (Structured Query Language)

Working with SELECT Queries
-Single Table / Multiple Table Queries
-Parametric Query
-Field Computation Queries
-Summary Queries
-Use of Groups in Summary Queries

Update Queries
Delete Queries
Crosstab Queries (Brief discussion)
Append Queries (Brief discussion)
Create Table Queries (Brief discussion)

Use of Forms and Reports in Microsoft Access - Brief Discussion


23rd April


IN Lab #6 (Week 6)

Building 24/ 278
*Lab Practices:  #2 to #5 (all topics)
*Home works:  #1 to #5
*Lab Book: Microsoft Excel (Chapter 1 – 4)
14th Mar


Thursday, 17th March, 2005

Building 10
*Lecture Slides:  #2 to #9 (all topics)
*Text Book:  
Chapter 1 (all pages), Chapter 2 (page 28 -42)
14th Mar
In Lecture Session # 9 (5th Week- 1st Lecture)
All lecture slides after (Lec#5 – Lec#8)
Text book (Computing Essentials 2004)
   -Chapter 2 (Contents related to spreadsheets- 3 pages)
4rh Mar
In Lecture Session # 5 (3rd Week- 1st Lecture)
All lecture slides (Lec#2 – Lec#4)
Text book (Computing Essentials 2004)
  -Chapter 1 (all except page 11)
  -Chapter 2 (30 – 41 , except 34 & 35)

Students are advised to bring PENCILS essentially as the quiz will be taken on BUBBLE SHEETS

20th Feb
Class Presentation Schedule: Click here to find the details 20th Feb
Student Group Information Click here to find the details  14th Feb
How to make your WebCT account active?

1. Visit Building 14/ Room 335 (Information Tech. Center) or Call 3916 ( from within the university)

2. Request for an activation of your email account.

3. Your email/ webct user id  will be:  s235433 (where 235433 is your student ID number)

4. Your password for the account will be configured by ITC as you told them.

5. Enjoy you WebCT account by logging at
12th Feb
Exam conflict notification- 
All students are advised to notify the instructor for any possible exam conflict, no later than first two weeks. Any notification after the mentioned deadline will not be entertained.
12th Feb
Book Website from Publishers
 Please check for many interesting features on the web site
12th Feb
WebCT Web Site
Use you WebCT account to keep in touch with discussions, chats with the instructor/ class mates on different course topics.
12th Feb
Instructor's Office Hours Details
Office Location: 24/ 223
SUT  900 - 1045AM
 or     by appointment
13th Feb