Information Systems Management 271

Introduction to DataBase Application Development using VB.NET and SQL Server

Syllabus

Updated 9/12/08

 

General Information

Course Description and Objectives

Course Topics

Grading

Attendance and Participation

Academic Dishonesty Policy

 

General Information

  • Instructor

Alec J. Engebretson
Professor of Information Science and Technology

Doane College
Crete, NE 68333
Phone: (402)826-8216 (office)
Phone: (402)826-9541 (cell)
Email: alec.engebretson@doane.edu

  • Schedule

Wednesday, October 22, 2008 - Wednesday, December 17, 2008
Class: Wednesday, 6:00-10:30
Office hours: a half hour before and after class 

  • Text/Reference

Database Concepts 3/e, Kroenke and Auer, Pearson Prentice Hall Publishing
Other handouts/web resources will be developed/provided as supplements to the text 

Back to top


Course Description and Objectives

In today's IT environment, database management systems (DBMS) are at the heart of many applications with data requirements. This course provides students with the fundamental knowledge and skills to develop database applications.

Specifically, this course has the following objectives:

  • Provide the ability to effectively design a database and utilize a database management system to develop a database application.
  • Gain experience in related topics that are of current interest including developing database applications using VB.NET, ADO.NET, SQL, SQL Server, and Visual Studio.NET.
  • Develop the skills necessary to be an effective member of a development team including planning skills, problem-solving skills, and communication skills.
  • Apply all of the skills outlined to complete a database application for a user.

Back to top


Course Topics (subject to change)

 

Session

Date

Topic(s)

 

 

 

Week 1

October 22

Course overview
Project overview
Training: VB.NET - In-class example
Training: VB.NET - In-class project #1
Assignment/Skills checkpoint #1: VB.NET fundamentals

Week 2

October 29

Review Skills checkpoint #1
Training: ADO.NET/SQL/SQL Server Part I - In-class example
Training: ADO.NET/SQL/SQL Server Part I - In-class project #2
Assignment/Skills checkpoint #2: ADO.NET/SQL/SQL Server Part I fundamentals

Week 3

November 5

Review Skills checkpoint #2
Training: ADO.NET/SQL/SQL Server  Part II - In-class example
Training: ADO.NET/SQL/SQL Server Part II - In-class project #3
Assignment/Skills checkpoint #3: VB.NET w/ ADO.NET/SQL/SQL Part II Server fundamentals

Week 4

November 12

Review Skills checkpoint #3
Training: ADO.NET/SQL/SQL Server  Part III - In-class example
Training: ADO.NET/SQL/SQL Server Part III - In-class project #4
Assignment/Skills checkpoint #4: VB.NET w/ ADO.NET/SQL/SQL Part III Server fundamentals

Week 5

November 19

Review Skills checkpoint #4

Seminar: Project methodology
Class workshop: Recognize - Sample problem description
Team workshop: Analyze - Interview goals/questions
Analyze - User interview
Team workshop: Design
Implementation: Work time

 

November 26

No class

Week 6

December 3

Implementation: Work time

Week 7

December 10

Implementation: Alpha testing
Initial applications (v 0.5) demonstrated and binders reviewed
Implementation: Work time

Week 8

December 17

Implementation: Beta testing
Implementation: Work time
V1.0 of application with full documentation due
User demonstrations and reaction

 

 Back to top


Grading


Basic Skills Assessment
Each student must successfully demonstrate basic skills associated with database application design and development. The skills include normalizing data, creating tables/relationships, creating queries, creating CRUD forms, creating reports, creating a simple VB.NET application, and coding with ADO.NET and SQL. These skills will be demonstrated by successfully completing four skills checkpoints. For the checkpoints, students must work alone with no help from anyone. Students will be able to use all reference materials. Successfully completing all four checkpoints is a condition of passing the course.  The checkpoints are not a factor in determining the final letter grade for the course.

Grade

A grading rubric developed using the RADIS problem-solving framework will be used to determine the course grade. The rubric will be discussed in class on April 24.

Scale

A+

A

A-

B+

B

B-

C+

C

C-

D+

D

D-

F

100-98

97-94

93-91

90-88

87-84

83-81

80-78

77-74

73-71

70-68

67-64

63-61

<=60

 

Back to top


Attendance and Participation Policy

In order to maximize the benefit from this course, full attendance to and participation in all classes is necessary and therefore expected.

Attendance will be noted each class session and will be a part of the grading rubric. Extreme cases, such as a lengthy illness will be considered on an individual basis.
 

Back to top


Academic Dishonesty Policy

In accordance with Doane's academic dishonesty policy which articulates the college's stance on honesty in the classroom, any act of dishonesty in pursuing the work of this course will be penalized.

First confirmed act of dishonesty

  • Report to Academic Affairs as required by college policy.
  • Receipt of a zero (0) for the activity.

Second and subsequent confirmed acts of dishonesty will be forwarded to and handled by the Vice President for Academic Affairs in accordance with policy guidelines.

Remember, collaboration among classmates is necessary and expected as an integral part of the education process. Copying will not be tolerated!
 

Back to top