|College||Dubai Women's College|
|Program||Bachelor of Applied Science in e–Business Management|
|Term||Level 4 - Semester 2|
|Course Code||ECOM 270|
|Course Title||Data Analysis and Design|
|Haya Bin Mutlaq Al Gafli||B-41||423||4|
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.
On successful completion of this course, you will be able to:
- Understand data models and database technology.
- Design a relational database to meet user needs.
- Use manipulation and query tools and techniques.
- Implement and test database design.
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.
|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
|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.|
|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|
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.
|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.