Home ●  Calendar ●  Print

Course Details

College Dubai Women's College
Department Business
Program Bachelor of Applied Science in e–Business Management
Term Level 4 - Semester 2
Academic Year 2008-2009
Course Code ECOM 270
Course Title Data Analysis and Design

Faculty and Contact Details

Instructors Location Ext Contact Hours
Tridib Chatterji B-03 492 8
Haya Bin Mutlaq Al Gafli B-41 423 4

Course Description

An understanding of databases is fundamental to the development of any significant information system. Database systems are predominant in the world of IT and continue to demand more complex data structures as applications get increasingly sophisticated.

The aim of this course is to provide an essential knowledge of database systems including design principles, practical implementation and development skills for both system designer and software engineer. The importance of structured query languages should be stressed, and once created, databases will be used or demonstrated for a variety of tasks including querying and report writing.

Learning Outcomes

On successful completion of this course, you will be able to:

How you will Learn in this Program

Instructors will encourage active class participation and student centered learning. This will be achieved through class activities, discussion, exercises, homework assignments, project work (individually and in groups), internet and library research. 

Your success will depend on the amount of EFFORT that you contribute to these activities. Your Professional Conduct will also be determined by your level of participation, attendance and adherence to college policies.

Semester Planner:

Learning Activities %
Details Assessment Item Deadline
Netg courses 20 Independent course work - Netg Courses on Internet Security Completion of courses at preset dates NetG Assessment
Database Activity #1 10 Individual Project and work Perfume Company database Week 6
Project - Networking 25 Presentation and Peer training Lesson Plan, Presentation, Quiz Week 16
Project - Store Your Information #1 25 Team Project and work; oral defence (choose #1 or #2) Web-enabling a HCT database Week 18
Project - Store Your Information #2 Team Project and work; oral defence (choose #1 or #2) Web-enabling the Perfume database Week 18
E-Portfolio 10 Online e-portfolio Individual Grade - Website complete and posted on server Week 18
Professional Conduct and Participation 10 Self/Peer Assessment Self assessment and performance evaluation Week 18
Project - Internet Tools (Optional) 15 Presentation and Peer training Presentation Week 16

The assessment schedule in the portal is here

Description of Assessment Items:

Projects and Assessments Overview
NetG As part of the ECOM 270 course this semester you will be required to complete two NetG courses on Access databases. The courses are to be completed individually. You will have to hand in proof that you have completed the course.

You will also have to write a one-page reflection (minimum 500 words) for each course.

Your mark will be determined by your level of mastery in each course and submission of your reflection. Failure to submit the reflection will result in an "F".
Project - Networking Students will learn the details of the fundamental structure of the Internet through research, instructor feedback and presentation
Project - Store Your Information Students will design a variety of databases as a reinforcement of their understanding of databases and database design.
Database Activity #1 Students will use MS Access to create an employee and salary database. They will then run queries and reports to extract meaningful data from the database.
E-Portfolio This is a medium used to showcase all the work done during your course of study in eBusiness. It is also designed to express one’s own reflection of the “learning” that has been achieved over a course of time. The e-Portfolio is a very valuable project as it will be used to showcase your work and skills to potential employers. It is also used to keep track of your accomplishments as a student.
Professional Conduct and Participation Student attendance and quality of effort during class and in submitted work.
Project - Internet Tools (optional) Students will research and present on a variety of commonly used tools, techniques and information.

NetG Assessment Summary

Course Description Course Code Time Due date
Microsoft Access 2003 Fundamentals This course, along with course 75051, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships, how to manipulate tables, and how to create simple and advanced queries. 75050  4 Hours 21st May
Microsoft Access 2003 Proficient User This course, along with course 75050, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. Assuming knowledge of the fundamentals, it teaches how to create forms and reports and how to format controls on both forms and reports. The student is also introduced to importing and exporting data to and from Access. Finally, this course teaches about backing up and compacting and repairing databases. 75051 4 Hours 21st May

Written Assessment Guidelines

All of your written work will use the following guidelines. It is your responsibility as a student to read and understand what is required for each grade level.

Grade Assessment
A Paper has all of the required elements as well as thoughtful and creative analysis. It should look like you spent a great deal of time in thinking and writing the paper. In short, it has to be better than the average.

“A” work is work that is exceptional. “A” work looks both at details and at the larger context, and it synthesizes material to come up with something that is new and original. “A” work has a goal, reaches it, and comes up with something new. “A” work is organized, accurate, and free of mechanical errors
B Paper has all of the required elements analysis is weak. Some spelling and few factual errors.
“B” work is work that is good. “B” work is on the right track to “A” work, but it isn’t as fully articulated and well thought out as “A” work.

Too many signs of carelessness (i.e., mechanical errors, inaccurate citation, etc.) may return an “A” paper into a “B” paper.
C Paper lacks a few of the required elements but it looks like some effort has been made. Some spelling, formatting and factual mistakes.

“C” work is average work. It communicates what has been said in class and makes correct points, but it doesn’t take things any farther. It uses standard structures to say unoriginal things. Or it may say original things, but in such a way to make the reader confused about how the point is being made, or what it is.

Excessive mechanical errors can make a “B” paper a “C” paper because the reader has to spend so much time figuring out what is being said.)
D Paper lacks a few of the required elements but it looks like little effort has been made. Many spelling, formatting and factual mistakes. “D” work misses the point, uses inaccurate information and logic, and shows a lack of thorough thought.

“D” work misspells and mis-attributes names and qualities, and shows little awareness of organization and logic.
F Paper has almost none of the required elements and very little effort as been made in the project. If paper has not been submitted, it will result in an automatic F.

“F” work is work that does not address the problems set forward, does not have a goal, is riddled with errors, and does not communicate anything. Or it is work that uses uncredited sources.

*** Source: Dr. Carolyn Sigler, Kansas State University (1990s)