House Bill 2504 Fall 2012 Course Syllabus ITSW-1307-01 - Introduction to Databases
Fall 2012 Course Syllabus
ITSW-1307-01 - Introduction to Databases
|Instructor||Cammack, James E.|
|MyLamarPA||Be sure to check your campus E-mail and Course Homepage using MyLamarPA campus web portal (My.LamarPA.edu). When you’ve logged in, click the email icon in the upper right-hand corner to check email, or click on the “My Courses” tab to get to your Course Homepage. Click the link to your course and review the information presented. It is important that you check your email and Course Homepage regularly. You can also access your grades, transcripts, and determine who you academic advisor is by using MyLamarPA.|
|Course Description||Introduction to database theory and the practical applications of a database.|
|Course Prerequisites||POFI 1201 or keyboarding and mousing skills or consent of instructor.|
Text: Benchmark Series: Microsoft Access 2010 Levels 1 and 2 - Text with data files CD
ISBN: 978-0-76384-305-2, Author(s): Nita Rutkosky, Denise Seguin, Audrey Rutkosky Roggenkamp
Software: Access 2010 (software is provided in classroom and in open lab facilities in Gates library and a 180-day free trial CD is included with the text)
Student ID a valid Student ID is required in order to use open lab facilities available on the campus and to gain Internet access for outside class assignments. For Password and Login help call Kenneth Lisby, 984-6150
Data Storage You will need to store your data and programs and be able to access them both in the classroom and outside of class. You should purchase a minimum 2GB flash drive for this purpose or you may use online data storage services, such as Google Drive or Dropbox.
|Attendance Policy||Research has shown a cause and effect relationship between attendance and college success. Should a student be absent for an exam, he/she will be required to take a makeup exam at the instructor convenience. It is the student’s responsibility to schedule the makeup exam. Should a student miss a class, it will be his/her responsibility to make up the work on his/her own time. All projects are due on the date assigned, even if the student is absent that day or prior to the assignment. Late work will not be accepted.|
|Course Grading Scale||90 - 100 = A 80 - 89 = B 70 - 79 = C 60 - 69 = D Below 59 = F|
|Determination of Final Grade||
Assignments/Quizzes 30%, Exams 70%
NOTE: You must have a minimum of a 70 average on Assignments in order to pass this class. The instructor will determine which assignments are to be graded. Not every project or class assignment turned in will necessarily be recorded for a grade. Quizzes are counted as an Assignment grade.
|Final Exam Date||December 10, 2012 - 10:00 AM|
1 Managing and Creating Tables.
2 Creating Relationships between Tables.
3. Performing Queries
4. Creating and Modifying Tables in Design View
5. Creating Forms
6. Creating Reports and Mailing Labels
7. Modifying, Filtering, and Viewing Data
8. Importing and Exporting Data.
|Calendar of Lecture Topics and Major Assignment Due Dates||
Classes will not meet on following days:
• Monday, 9/3/12 Labor Day
• Thursday, 11/22/12 Thanksgiving
• Friday, 11/23/12 Thanksgiving
***All assignments for each chapter are due by 11:59 p.m. on Sunday***
Week 1 08/27/2012 - 09/02/2012 Course introduction; syllabus review; Using Windows 7. Browsing the Internet Using Internet Explorer 8.0. (this is assumed to be prerequisite knowledge for this class and so will not be covered in class). Chapter 1 Managing and Creating Tables.
Week 2 09/03/2012 - 09/09/2012 Chapter 1 Managing and Creating Tables.
Week 3 09/10/2012 - 09/16/2012 Chapter 2 Creating Relationships between Tables
Week 4 09/17/2012 - 09/23/2012 Chapter 2 Creating Relationships between Tables
Week 5 09/24/2012 - 09/30/2012 Exam Chapter 1 & 2; Chapter 3. Performing Queries
Week 6 10/01/2012 - 10/07/2012 Chapter 3. Performing Queries
Week 7 10/08/2012 - 10/14/2012 Chapter 4. Creating and Modifying Tables in Design View
Week 8 10/15/2012 - 10/21/2012 Chapter 4. Creating and Modifying Tables in Design View
Week 9 10/22/2012 - 10/28/2012 Exam Chapter 3& 4; Chapter 5. Creating Forms
Week 10 10/29/2012 - 11/04/2012 Chapter 5. Creating Forms
Week 11 11/05/2012 - 11/11/2012 Chapter 6. Creating Reports and Mailing Labels
Week 12 11/12/2012 - 11/18/2012 Chapter 6. Creating Reports and Mailing Labels
Week 13 11/19/2012 - 11/25/2012 Exam Chapter 5 & 6; Chapter 7. Modifying, Filtering, and Viewing Data
Week 14 11/26/2012 - 12/02/2012 Chapter 7. Modifying, Filtering, and Viewing Data
Week 15 12/03/2012 - 12/05/2012 Chapter 8. Importing and Exporting Data.
Final Monday Dec. 10, 2012 10:00 AM-12:30 PM Chapter 7 & 8;
|General Education/Core Curriculum Student Learning Outcomes||
|Program Student Learning Outcomes||
1. Utilizes basic software development terminology and concepts.
2. Applies a software-development process to develop and troubleshoot a software product.
3. Creates computer graphics for inclusion into a software product.
4. Demonstrates ethics and professionalism within the computer field
5. PSLO ALPHA: Reading skills - Demonstrates comprehension of content-area reading material.
|Course Student Learning Outcomes||
1. Students will identify database terminology and concepts.
2. Students will plan, define, and design a database.
3. Students will design and generate tables, forms, and reports.
4. Students will construct and process queries.
5. The student will demonstrate ethics and professionalism.
6. PSLO ALPHA: Reading skills - Demonstrates comprehension of content-area reading material.
|Academic Honesty||Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSC-PA policies (Section IX, subsection A, in the Faculty Handbook) for consequences of academic dishonesty.|
|ADA Considerations||The Americans with Disabilities Act (ADA) is a federal anti-discrimination statue that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Special Populations Coordinator, Room 210D, in the Madison Monroe Building. The phone number is (409) 984-6251.|
Some material in this course may be copyrighted. They may be used only for instructional purposes this semester,
by students enrolled in this course. These materials are being used fairly and legally.
No one may distribute or share these copyrighted materials in any medium or format with anyone outside this class,
including publishing essays with copyrighted material, uploading copyrighted material to Facebook or YouTube, or
painting or performing copyrighted material for public display.
Copyright violation is not the same thing as plagiarism. Plagiarism is intellectual dishonesty. Offenses of plagiarism result in lower grades or failing scores, and professors and the college strictly enforce plagiarism rules. There is never any acceptable use of plagiarism. Copyright violation is a legal offense, punishable by large fines and penalties.
Copyrighted material can be used if permission from the material’s creator is obtained, or if its use meets the standards of fair use in an educational setting. For example, a student can quote a line from Shakespeare’s Hamlet in a report without violating copyright but still be guilty of plagiarism if the quotation is not properly documented.
If you are in doubt about what material can be freely used, ask your professor or contact the Dean of Library Services, at (409) 984-6216.
Assessment is a process by which LSCPA can help you learn better and gauge the level of progress you have made to
attain knowledge, skills, beliefs, and values. It also helps your professors understand how to improve teaching
and testing methods in your classes, and it helps each department understand and improve degree and certificate
Periodically LSC-PA will collect assessment data for research and reporting purposes, including statistical data and sometimes copies of your work. Be assured that all material the college uses for assessment purposes will be kept confidential. To ensure anonymity, your name will be removed from any material we use for assessment purposes, including video-recorded performances, speeches, and projects.
If you object to allowing LSC-PA to use your material for assessment purposes, submit a letter stating so to your professor by the 12th class day. You will still be required to participate in whatever assessments are being done; we just won’t use your data.
What’s the difference between assessment and grades? The grades you get on papers, projects, speeches, and assignments are specific types of focused assessment. LSC-PA’s assessment efforts include class grades, surveys, standardized tests, and other tools.
Federal privacy laws apply to college students. This means that college employees, including instructors, cannot
divulge information to third parties, including parents and legal guardians of students. Even if the students are
minors, information about their college work cannot be shared with anyone except in very limited circumstances.
Anyone requesting information about a student should be referred to the Registrar. Instructors will be notified in writing by that Office about what information may be released and to whom.
Please remember that releasing private information about a student, however innocuous it may seem, can be a violation of federal law, with very serious consequences.
Circumstances under which information may be released:
An adult student may submit, to the Registrar, a handwritten, signed note granting permission for release of
information. The note must specify what information may be divulged, and it must specify the name of the person
to whom the information may be given.
The Registrar’s office is located in the Student Center room 303B, and can be reached at (409) 984-6165.
This course helps add to the students’ overall collegiate experience in the following ways:
|Degree Plan Evaluation||
A Degree Plan Evaluation will help you determine which classes you need to complete your program.
All of the classes that you have taken that apply to your declared major will be listed on the right. If you have a class that still needs to be completed, a “NO” will be listed on the right next to the required class.
|HB 2504||This syllabus is part of LSC-PA’s efforts to comply with Texas House Bill 2504.|
Copyright ©2011 Lamar State College - Port Arthur. All Rights Reserved.