|
NORTH CENTRAL TEXAS COLLEGE
COURSE SYLLABUS
|
|
|
Course Title:
|
Introduction to Database
|
|
Course Prefix & Number:
|
ITSW 1307
|
Section Number:
|
340
|
Semester/Year:
|
2019 SP
|
|
|
Semester Credit Hours:
|
3
|
Lecture Hours:
|
32
|
Lab Hours:
|
32
|
|
|
Course Description (NCTC Catalog):
Introduction to database theory and the practical applications of a database. Emphasis on database design, custom reports, file management, and application creation.
|
|
Course Prerequisite(s):
|
|
Required Course Materials:
(1) REQUIRED - SIMNet eLearning Program – purchased through McGraw Hill
(2) REQUIRED – Voucher for the certification exam – purchased through Certiport.
(3) REQUIRED – Microsoft Access 2016 software – if you don’t have it at home, use computers at NCTC.
(4) OPTIONAL - Textbook: Microsoft Office In Practice - ACCESS 2016 Complete, Easton Nordell, McGraw Hill Education ISBN10: 0078020328 | ISBN13: 9780078020322 OR you can use the online book in SIMNet;
Bookstore has all three of these items together – better pricing versus trying to buy each separately OR Just the SIMNET and Voucher for the certification exam
(5) Recommended – Flash drive 2 GB or larger
|
| |
|
|
|
|
|
|
|
INSTRUCTOR INFORMATION
|
Name of Instructor:
|
Manuel Trevino, Jr
|
|
Campus/Office Location:
|
Corinth Campus – Room 255
|
|
Telephone Number:
|
940 498 6440 x6516
|
|
E-mail Address:
|
mtrevino@nctc.edu
|
OFFICE HOURS
|
Monday
|
Tuesday
|
Wednesday
|
Thursday
|
Friday
|
|
9:00am to 3:00pm
|
9:00am to 3:00pm
|
9:00am to 3:00pm
|
9:00am to 3:00pm
|
By Appointment
|
|
|
|
|
|
|
| |
|
|
|
|
|
* Instructor Response Time - Please allow 24 hours during the week and 48 hours on the weekend for responses
STUDENT LEARNING OUTCOMES (From Academic Course Guide Manual/Workforce Education Course Manual/NCTC Catalog
|
At the successful completion of this course the student will be able to:
|
- Identify database terminology and concepts
|
- Devise and process queries
|
- Plan, define, and design a database
|
- Design and generate tables, forms, and reports
|
|
GRADING CRITERIA
|
# of Graded Course Elements
|
Graded Course Elements
|
|
|
Points Contribution to Overall *
|
|
| |
|
10
|
Start Module, Chapter Simulation, Project and Quizzes
|
|
|
40.30%
|
|
|
4
|
Exams ***
|
|
|
25.40%
|
|
|
4
|
Discussions & Attendance
|
|
|
20.30%
|
|
|
2
|
Projects (Midterm and Final)
|
|
|
14.00%
|
|
|
*Students found plagiarizing in an assignment in this course may receive an "F" for the course along with a report turned into the Dean for Scholastic Dishonesty.
|
|
|
*Students with continued absences and discussion posts that add no value will receive a “0” for the assignment. The class discussion forums and exams will be used to determine regular attendance.
|
|
|
*** Minus one dropped lowest exam grade (MUST complete all four exams for one to be dropped)
|
|
COURSE SUBJECT OUTLINE
|
Chapter 1 - Creating a Database and Tables
|
This chapter covers the basics of working with a relational database and using the Access database management system
|
|
Chapter 2 - Using Design View, Data Validation, and Relationships
|
This chapter covers the basics of creating a table in Design view, using data validation rules to ensure your data is valid, and creating relationships among different tables in a database.
|
|
Chapter 3 - Creating and Using Queries
|
This chapter covers the basics of creating a query, adding criteria to a query, using different query options, integrating calculated fields, and creating summary queries.
|
|
Chapter 4 - Creating and Using Forms and Reports
|
This chapter introduces the Access tools that allow you to create and customize forms and reports.
|
|
Chapter 5 - Templates, Advanced Relationships, and Macros
|
This chapter introduces three important skills.
First, you learn more about creating and modifying databases based on Access templates.
Next, you learn additional skills you can use to create table relationships, including how to
create a many-to-many relationship. Finally, you learn how to create and use macros that
improve the user-friendliness and functionality of your database.
|
|
Chapter 6 - Creating Advanced Queries and Reports
|
This chapter addresses how to create and use action queries and how to create
queries that perform more powerful tasks. In this chapter, you also learn how to use Design
view to create and modify reports, including the use of subreports.
|
|
Chapter 7 - Creating Advanced Forms
|
In this chapter you learn about form properties and using calculated controls on a form. Additionally, you learn how to create more sophisticated forms including a one-to-many form, a navigation form, and a form to capture parameter data.
|
|
Chapter 8 - Integrating Applications
|
This chapter covers the basics of
interfacing with data created and used by these other programs.
|
|
Chapter 9 - Designing and Managing Databases
|
In Chapter 9, you will be exposed to additional techniques you can use to ensure that your tables are well designed. Additionally, you learn how to customize the Navigation Pane and how to use several tools in Access to improve the performance of a database and enhance your database security. Finally, you learn more about SQL and how it defines, manipulates, and retrieves data in databases.
|
|
Chapter 10 - Customizing Access and Using OneDrive and Office Online
|
This chapter explains how you can customize Access settings to personalize your working environment. As an added convenience, Office 2016 integrates "cloud" technology, which allows you to use your Office files in OneDrive and Office Online. These cloud services let your files and Office settings roam with you. With these online features, you are not limited to using Office on only one computer, and you don't have to save your files on a USB drive or portable hard drive to have access to your files.
|
Regular and punctual attendance is expected of all students in all classes for which they have registered. All absences are considered to be unauthorized unless the student is absent due to illness or emergencies as determined by the instructor. It is the student responsibility to provide documentation as to the emergency for approval and judgement by the faculty member. Approved college sponsored activities are the only absences for which a student should not be held liable and only when provided by a college official ahead of the absence. Valid reasons for absence, however, do not relieve the student of the responsibility for making up required work. Students will not be allowed to make up an examination missed due to absence unless they have reasons acceptable to the instructor. A student who is compelled to be absent when a test is given should petition the instructor, in advance if possible, for permission to postpone the exam. Student will be dropped from a class by the Registrar upon recommendation of the instructor who feels the student has been justifiably absent or tardy a sufficient number of times to preclude meeting the course’s objectives. Persistent, unjustified absences from classes or laboratories will be considered sufficient cause for College officials to drop a student from the rolls of the College. From Board Policy FC (LOCAL)
Last day to withdraw from a course with a “W” is April 4, 2019.
DISABILITY SERVICES (Office for Students with Disabilities)
The Office for Students with Disabilities (OSD) provides support services for students with disabilities, students enrolled in technical areas of study, and students who are classified as special populations (i.e. single parents).
Support services for students with disabilities might include appropriate and reasonable accommodations, or they may be in the form of personal counseling, academic counseling, career counseling, etc. Furthermore, OSD Counselors work with students to encourage self-advocacy and promote empowerment. The Counselors also provides resource information, disability-related information, and adaptive technology for students who qualify.
If you feel you have needs for services that the institution provides, please reach out to either Wayne Smith (940) 498-6207 or Yvonne Sandman (940) 668-4321. Alternative students may stop by Room 170 in Corinth or Room 110 in Gainesville.
CORE CURRICULUM FOUNDATIONAL COMPONENT AREA (For classes in the Core)________
o Communication
o Mathematics
o Life and Physical Science
o Language, Philosophy & Culture
o Creative Arts
o American History
o Government/Political Science
o Social and Behavioral Sciences
o Component Area Option
REQUIRED CORE OBJECTIVES (For classes in the Core)
x Critical Thinking
x Communication
x Empirical and Quantitative
x Teamwork
x Personal Responsibility
x Social Responsibility
x Academic General Education Course (from ACGM but not in NCTC Core)
o Academic NCTC Core Curriculum Course
o WECM Course
Students are expected to follow all rules and regulations found in the student handbook and published online.
Scholastic dishonesty shall include, but is not limited to cheating, plagiarism, academic falsification, intellectual property dishonesty, academic dishonesty facilitation and collusion. Faculty members may document and bring charges against a student who is engaged in or is suspected to be engaged in academic dishonesty. See Student Handbook, “Student Rights & Responsibilities: Student Conduct ([FLB(LOCAL)]”.
Consequences for academic dishonesty may include:
- Zero for the work
- Academic suspension
|
QUESTIONS, CONCERNS, or COMPLAINTS
|
Manuel Trevino, Jr
|
|
Office Location:
|
IT Career Connection Center, room 102 (Online office Hours are available by appointment)
|
|
Telephone Number:
|
940 498 6440 x6516
|
|
E-mail Address:
|
mtrevino@nctc.edu
|
|
Name of Chair/Coordinator:
|
Susan Svane
|
|
Office Location:
|
Room 232, Corinth Campus
|
|
Telephone Number:
|
940 498 6292
|
|
E-mail Address:
|
ssavne@nctc.edu
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
STUDENT SUPPORT SERVICES
|
Support Services
Counseling and Testing staff offer a variety of services to current and prospective students, such as College 101, placement testing, academic advising and course registration, transfer assistance, and College Success seminars (Time Management, Study Skills, Test Anxiety, Choosing a Major, Learning Style Strategies, Career Exploration), and much more. http://www.nctc.edu/StudentServices/CounselingTesting.aspx
Student Success offers academic coaching, tutoring, including a Writing Center, a Math Lab, free 24/7 online tutoring through Grade Results and assist new students acclimate to college by providing computer lab services for prospective students. First generation students can also participate in TRIO which offers specialized support services. http://www.nctc.edu/StudentServices/SupportServices.aspx
Financial Aid offers financial resources for students that qualify, visit the financial aid offices for more information. http://www.nctc.edu/FInancialAidHome.aspx
Early Alert and NCTC Cares
The NCTC Early Alert program has been established to assist students who are at risk of failing or withdrawing from a course. Your instructor may refer you to this program if you are missing assignments, failing tests, excessively absent, or have personal circumstances impacting your academic performance. If submitted as an Early Alert you will be notified via your NCTC e-mail address and then contacted by a Counseling and Testing advisor or counselor to discuss possible strategies for completing your course successfully.
The NCTC CARES (Campus Assessment Response Evaluation Services) Team addresses behavior which may be disruptive, harmful or pose a threat to to the health and safety of the NCTC community-such as stalking, harassment, physical or emotional abuse, violent or threatening behavior, or self-harm. As a student, you have the ability to report concerning behavior which could impact your own safety or the safety of another NCTC student. Just click the NCTC CARES Team logo posted on MyNCTC, or send an e-mail to CARESTeam@nctc.edu. As always, if you feel there is an immediate threat to your own safety or welfare (or to another student), please call 911 immediately.
|
|
Tobacco-Free Campus
NCTC restricts the use of all tobacco products including cigarettes, cigars, pipes and smokeless tobacco on campus property.
|
|
NOTICE: Some grades for this course may post in Canvas. Those grades will be correct only relative to the assignments that are graded by instructor. The course average and other numeric computations that show in Canvas may or may not be correct. As college students you should use the above provided format to follow your grade progress. Your final grade is obviously a sum of the ratios of the four component grades. The very best approach is to accumulate as many points as you can as the semester goes along. If you miss an opportunity to earn points for any reason then, those points are lost. Remember to participate in posted assignments during the time frame allowed.
NOTICE: Some assignments required participation on more than one date. Being absent on either date will cause you to NOT get points for the related assignment or activity. Attendance is mandatory. This course operates much like a business with you as the employee who is expected to show up for all work assignments.
|