|Class Location/Time: This is a three-credit distance education class [call # 55210] that is offered as a series of 15 lessons between January 21 and May 15. Internet access is required for homework submission, quizzes and final exams. Each lesson must be completed by the announced due date in order to receive full points. Students may choose to work from an IBM personal computer of their choice including computers in a few of the campus computer labs (contact instructor for participating computer labs).|
|Catalog Description: Basic concepts of data modeling and relational database design. Hands-on learning of Structured Query Language. Prerequisite: IS 115 or equivalent programming experience or permission of instructor.|
Course Objectives: This course will provide you with a solid understanding of the relational model and of the theory behind SQL. Furthermore, it will address the needs of both the user and the developer. From the user's standpoint you will become proficient at translating information needs into appropriate SQL statements. From the developer's standpoint you will gain experience in designing databases which conform to the relational model. Specifically, when you successfully complete the course, you will be able to
Software: Although SQL and database concepts covered in this class can be applied to all RDBMS environments (PC, mini, mainframe and web-based) and vendor products, our lab work will be done using the popular and newest version of Microsoft SQL Server: 2008. You will download and install the free SQL Server 2008 Express with Tools edition. Instructions on how to correctly install this software will be provided when the class starts. Students who do not have the necessary platform for a successful install need to use one of the available CSN Computer Labs in order to complete most assignments. Check with the lab assistants to find out on which pods SQL Server 2008 is installed. Time permitting, you will also have the opportunity to use SQL with other vendor products.
WebCT Access: A WebCT "classroom" has been set up to guide the learning activities and to facilitate communication between students and instructor. All assignments are posted in the appropriate WebCT discussion board. A requirement of this course is that all students must check this location for messages frequently, turn in lab assignments and take quizzes using WebCT. From the college home page (www.ccsn.edu) select Web Campus and follow the logon instructions. Some assignments will require additional Internet access.
|Grading Policy: Points are divided somewhat equally between lab work and multiple-choice tests. The following are requirements of the course, their weights and the minimum accumulated points for letter grades:|
|COURSE ACTIVITIES: In order to facilitate your success in learning this highly technical application, your lessons will be structured around the following activities:|
|Instructor's introduction and examples: These will introduce new topics and might provide some lab examples to help students master the material.|
|Textbook readings: For most assignments, students demonstrate that they have read the assigned textbook pages by providing short answers to questions about the material and by repeating SQL examples demonstrated by the author.|
|SQL Homework: Additional SQL lab assignments are provided to reinforce the instructor's comments and the reading assignments.|
|Quizzes: These are posted on WebCT and are available for retake if students need to improve their scores. They are based on textbook readings, instructor postings, and lab work. The focus of each quiz will be on the work of the most recent two-week period, but there is no way in a subject like SQL that the material covered earlier in the semester can be totally ignored. Most quizzes consist of 20 multiple choice or true/false questions randomly generated from a database of approximately 100 questions on each of our major topics. Quizzes are timed tests (usually 15 minutes) and once the time limit has been exceeded, no more answers can be recorded. You will see your results immediately after finishing the quiz.|
|Discussion Postings: There will be two mandatory class discussions on pre-announced topics.|
|Examinations: At the end of the semester there will be a comprehensive final examination covering all assigned material. The exam will have two equal parts: an objective (multiple choice, true or false) test and a practical SQL lab test that will follow the same format as the lab assignments.|
|Course activity and due dates: Assignments are released sequentially, a few lessons at a time. Lab grades are usually posted 4 days after the due date. If you have submitted your assignment early, the grade will not be posted until 2-4 days after the close of the assignment. All lab homework assignments are built on the work of prior weeks. Under no circumstances should you skip doing an assignment. Work turned in late will lose one point for each day it is late. The calendar shown below summarizes all due dates.|
|Course Policies: The instructor will not assign a grade of W (withdraw) or I (incomplete) to the student. Students must initiate a request with the CSN Records and Admissions Office to change status or drop courses. The number of points accumulated by the end of the semester will determine the grade earned.|
|Changes to the syllabus and/or calendar: Many things could happen in the course of a semester that would require changes to the initial plan and the instructor reserves the right to make those changes on an as-needed basis. Any changes will be broadcast to the students through a WebCT bulletin board posting. If in doubt, the student should check the date and time at the end of this document with any they have printed earlier.|
|Academic dishonesty: According to the Schedule of Classes, "CSN
demands a high level of academic behavior. Acts of academic dishonesty
including plagiarism and cheating, are regarded as very serious offenses." Any student commits an academic
irregularity when one or more of the following or similar situations is
1. Copying another student's work or program.
2. Copying answers from another student, or use of unauthorized notes or books during an examination.
3. Theft or unauthorized possession of an examination.
4. Use of another person's file or diskette.
5. Allowing another person to have access to your file or diskette.
There is a big difference between working together on an assignment and turning in the same homework file. In this class all academic irregularities will result in a grade of ZERO for that test/assignment and will be reported to the Vice President for Student Services.
|Attendance policy: Each student's date of last attendance, should it be required for financial aid or court reporting, will be determined by the last homework assignment submitted or last quiz completed - whichever is last.|
|Disability Resource Centers: If you have a documented disability that may require assistance, you will need to contact the Disability Resource Center (DRC) for coordination of your academic accommodations. The DRC is located in Student Service Center on each campus. For Cheyenne campus the number is 651-4045, for West Charleston campus the number is 651-5089, and for Henderson campus the number is 651-3086. For those students that would like to perform community service or earn a little extra cash, stop by the DRC to fill out a job interest card. This office hires students as note takers, proctors, scribes and research assistants as needed.|
|Last updated 10-Nov-08, 6:50 PM. For more information contact J.Fightmaster.|