Instructor: Irfan Ahmed Ilyas


Recent (New) Announcements (at the BEGINNING)

Old (outdated) Announcements

Announcement Text  Posted On
Lab Exam 3
 Sec01 - Sat, 1st Jan 2005 (3:00pm)
 Sec02 - Sun, 2nd Jan 2005 (5:30pm)
 Sec03 - Web, 29th Dec 2004 (12:50pm)
  Creating Microsoft Access Form Objects
  Creating Macros
  Create Visual Basic Programs
  Lab Practices 11, 13, 14, 15
25th Dec
Quiz#5 (Chapter 14)
 Sec01 - 1st Jan, 2005
 Sec02 - 04 - 2nd Jan, 2005
  Lecture 27 - 28
25th Dec

TIME: 7:30 AM
DATE: January 5, 2005
DAY: Wednesday
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%   (covered in both lec & lab)
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

25th Dec
20th - 21st Dec
Chapter 8
MIS105 Major Exam 02
Date: 9th December, 2004
Location: Building 10
Time: 7:30am (Morning)

Question Composition:
  80 Questions

 Chapter 4 -  Complete chapter
 Databases -
   * Chapter 2 (page 43 to 45)
   * Chapter 11 (pages 290, 291, 294, 295, 301 - 303)
   * from Lec11 to  Lec22 (all are included)

* Database Topics (as follows)
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
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 report in Access  - Brief Discussion

22nd Nov
Quiz03 Schedule:
Sec01 - 22nd Nov, 2004
                 Sec02, 03, 04 - 23rd Nov, 2004
    Contents:  Lecture Slides from Lec11 to Lec14 (all included).
2nd Nov
MIS105 Quiz02

Sunday, 17th Oct, Sec02, 03, 04
Monday, 18th Oct,  Sec01

Contents:   Topics covered in Lectures 5, 6, 8, 9 (Spreadsheets only)
10th Oct
MIS105 Major Exam Date

MAJOR 01 (Revised)- 21st October, 2004 in Building 10 at 1:00pm (Afternoon)

Contents of Exam
 - Lecture Slides  (from Lecture 02  till Lecture 10)

Book Page Numbers
 -Chapter 1 (all pages)
 -Chapter 2 (pages 28,29,30,31,36,37,38,39,40,41,42)

3rd Oct/ 10th Oct
Change in Lab Time & Location For Sec02

New Time:  Sunday, 5:15pm - 7:15pm
Location:  Room 278

21 Sep
MIS105 Quiz01

Sunday, 26th Sep, Sec02, 03, 04
Monday, 27th Sep,  Sec01

Contents:   Topics covered in first 4 Lectures
20th Sep
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.
11th Sep
Book Website from Publishers
 Please check for many interesting features on the web site
11th Sep
Instructor's Office Hours Details
Office Location: 24/ 223
SM  800 - 900AM
U     1000 - 1100AM
 or     by appointment
13th Sep