ITSW 1407 - Introduction to Database Course Syllabus

Download as PDF

ITSW 1407:

Description
Introduction to relational and non-relational database theory and the practical applications of contemporary databases. Topics may adapt to changes in industry practices.
Credits 4 Lecture Hours 3 Lab Hours 3
Extended Hours
0
Contact Hours
96
State Approval Code
11.0802
Instructor Name
Denise Wilkins
Semester/Year
Fall 2024
Meeting Time and Location
Online--students are expected to spend at least 6 hours per week reading, reviewing, and participating in assigned activities for successful completion of this course.
Alternate Operations During Campus Closure

In the event of an emergency or announced campus closure due to a natural disaster or pandemic, it may be necessary for Panola College to move to altered operations. During this time, Panola College may opt to continue delivery of instruction through methods that include, but are not limited to: online learning management system (CANVAS), online conferencing, email messaging, and/or an alternate schedule. It is the responsibility of the student to monitor Panola College's website (www.panola.edu) for instructions about continuing courses remotely, CANVAS for each class for course-specific communication, and Panola College email for important general information.

Class Attendance

Regular and punctual attendance of classes and laboratories is required of all students. When a student has been ill or absent from class for approved extracurricular activities, he or she should be allowed, as far as possible, to make up for the missed work. If a student has not actively participated by the census date, they will be dropped by the instructor for non-attendance. This policy applies to courses that are in-person, online, hybrid, and hyflex.

Attendance in online courses is determined by submission of an assignment or participation in an activity. According to federal guidelines, simply logging into a distance learning course without participating in an academic assignment does not constitute attendance. Distance learning is defined as when a majority (more than 50%) of instruction occurs when the instructor and students are in separate physical locations. Students must engage in an academic activity prior to the course census date. 

When an instructor feels that a student has been absent to such a degree as to invalidate the learning experience, the instructor may recommend to the Vice President of Instruction that the student be withdrawn from the course. Instructors may seek to withdraw students for non-attendance after they have accumulated the following number of absences: 

Fall or spring semesters: 

3 or more class meeting times per week - 5 absences

2 class meeting times per week - 3 absences

1 class meeting per week -  2 absences

The student is responsible for seeing that he or she has been officially withdrawn from a class. A student who stops attendance in a class without officially withdrawing from that class will be given a failing grade; consequently, the student must follow official withdrawal procedures in the Admissions/Records Office.

Please note: Health Science and Cosmetology courses may require more stringent attendance policies based on their accreditation agencies. Please see the addendum and/or program handbook for further information concerning attendance.  

Pregnant/Parenting Policy

Panola College welcomes pregnant and parenting students as a part of the student body. This institution is committed to providing support and adaptations for a successful educational experience for pregnant and parenting students. Students experiencing a need for accommodations related to pregnancy or parenting will find a Pregnancy and Parenting Accommodations Request form in the Student Handbook or may request the form from the course instructor.

Instructional Goals and Purposes

Panola College's instructional goals include 1) creating an academic atmosphere in which students may develop their intellects and skills and 2) providing courses so students may receive a certificate/an associate degree or transfer to a senior institution that offers baccalaureate degrees.

The purpose of this course is to: 1) fulfill academic requirements of an Associate of Applied Science degree or a technical certificate at Panola College, 2) provide learners with a foundation of database concepts and terms, and 3) provide learners with fundamental skills necessary to use current database application software.

Learning Outcomes
  1. Identify database terminology and concepts.
  2. Plan, define, and design a database.
  3. Design and generate tables.
  4. Design and generate forms
  5. Design and generate reports.
  6. Devise and process queries.
Specific Course Objectives (includes SCANS)

After studying all materials and resources presented in the course, the student should be able to complete all objectives listed below with a minimum competency of 70% on assignments and exams.

  1. Introduction to Microsoft Access 2019 (1a-i, 1a-ii, 1b- ii, 1b-v, 1c-i, 2a-iii, 2c-i, 2c-ii, 2c-iv, 2e-ii)
    1. Identify Good Database Design
    2. Create a Table and Define Fields in a Blank Desktop Database
    3. Change the Structure of Tables and Add a Second Table
    4. Create a Query, Form, and Report
    5. Close a Database and Close Access
    6. Use a Template to Create a database
    7. Organize Objects in the Navigation Pane
    8. Create a New Table in a Database Created with a Template
    9. Print a Report and a Table
  2. Sort and Query a Database (1a-i, 1a-ii, 1b- ii, 1b-v, 1c-i, 2a-iii, 2c-i, 2c-ii, 2c-iv, 2e-ii)
    1. Open and Save an Existing Database
    2. Create Table Relationships
    3. Sort Records in a Table
    4. Create a Query in Design View
    5. Create a New Query From an Existing query
    6. Sort Query Results
    7. Specify Criteria in a Query
    8. Specify Numeric Criteria in a Query
    9. Use Compound Criteria in a Query
    10. Create a query Based on More Than One Table
    11. Use Wildcards in a Query
    12. Create Calculated Fields in a Query
    13. Calculate Statistics and Group Data in a Query
    14. Create a Crosstab Query
    15. Create a Parameter Query
  3. Forms, Filters, and Reports (1a-i, 1a-ii, 1b- ii, 1b-v, 1c-i, 2a-iii, 2c-i, 2c-ii, 2c-iv, 2e-ii)
    1. Create and Use a Form to Add and Delete Records
    2. Filter Records
    3. Create a Form by Using the Form Wizard
    4. Modify a Form in Layout View and in Design View
    5. Create a Report by Using the Report Tool and Modify the Report in Layout View
    6. Create a Report by Using the Report Wizard
    7. Modify the Design of a Report
    8. Keep Grouped Data Together in a Printed Report
  4. Enhancing Tables (1a-i, 1a-ii, 1b- ii, 1b-v, 1c-i, 2a-iii, 2c-i, 2c-ii, 2c-iv, 2e-ii)
    1. Manage Existing Tables
    2. Modify Existing Tables
    3. Change Data Types
    4. Attach Files to Records
    5. Create a Table in Design View
    6. Create a Lookup Field
    7. Set Field Properties
    8. Create Data Validation Rules and Validation Text
  5. Enhancing Queries (1a-i, 1a-ii, 1b- ii, 1b-v, 1c-i, 2a-iii, 2c-i, 2c-ii, 2c-iv, 2e-ii)
    1. Create Calculated Fields in a Query
    2. Use Aggregate Functions in a Query
    3. Create a Crosstab Query
    4. Find Duplicate and Unmatched Records
    5. Create a Parameter Query
    6. Create a Make Table Query
    7. Create an Append Query
    8. Create a Delete Query
    9. Create an Update Query
    10. Modify the Join Type
  6. Customizing Forms and Reports (1a-i, 1a-ii, 1b- ii, 1b-v, 1c-i, 2a-iii, 2c-i, 2c-ii, 2c-iv, 2e-ii)
    1. Create a Form in Design View
    2. Change and Add Controls
    3. Format a Form
    4. Make a Form User Friendly
    5. Create a Report in a Query Using a Wizard
    6. Create a Report in Design View
    7. Add Controls to a Report
    8. Group, Sort, Total Records in Design View
  7. Other topics as necessary.
Course Content

A general description of lecture/discussion topics included in the course are listed in the Learning Objective / Specific Course Objectives section of this syllabus.

Students in all sections of this course will be required to do the following:

  1. Complete reading activities.
  2. Complete terms and concepts quizzes
  3. Complete simulation training.
  4. Complete simulation assessment quizzes.
  5. Complete skills projects homework.
  6. Complete skill projects assessment quizzes.
  7. Complete a MINIMUM of two proctored exams.
  8. Complete a Final exam.
Methods of Instruction/Course Format/Delivery

Learners in the traditional class, hybrid class, and online class will have access to this course via the current Learning Management System. Learners in the traditional class and hybrid class will meet regularly for discussion on the new material. Learners in the online class will only be required to meet with the instructor or the proctor in a verified testing center for exams. Details will be posted in the Learning Management System.

All assignments will be completed and submitted via the current Learning Management System or the MYITLAB Web site.

Learners may complete the following using the MYITLAB site: a) A MINIMUM of two proctored exams; b) Skills training and quizzes; c) Graded project homework and assessment quizzes; d) Concepts

Learners in both the traditional and Internet classes should use the messaging (email) component of the current Learning Management System to communicate with the instructor and others in the learning community. If you are unable to contact the instructor using this method, you may use the instructor’s Panola College email address. Panola College instructors attempt to respond to all email within 24 hours when on campus or during virtual office hours. Always include a subject line and your name in your email.

Course Grade

The grading scale for this course is as follows:

Major Exams 60%
Other Activities 40%
90 and above A
80 – 89 B
70 – 79 C
60 – 69 D
Under 60 F

Major Assignments/Assessments

The following items are assigned and assessed during the semester and used to calculate the student's final grade.
Other
SCANS Criteria
  1. Foundation skills are defined in three areas: basic skills, thinking skills, and personal qualities.
    1. Basic Skills: A worker must read, write, perform arithmetic and mathematical operations, listen, and speak effectively. These skills include:
      1. Reading: locate, understand, and interpret written information in prose and in documents such as manuals, graphs, and schedules.
      2. Writing: communicate thoughts, ideas, information, and messages in writing, and create documents such as letters, directions, manuals, reports, graphs, and flow charts. 
      3. Arithmetic and Mathematical Operations: perform basic computations and approach practical problems by choosing appropriately from a variety of mathematical techniques.
      4. Listening: receive, attend to, interpret, and respond to verbal messages and other cues.
      5. Speaking: Organize ideas and communicate orally.
    2. Thinking Skills: A worker must think creatively, make decisions, solve problems, visualize, know how to learn, and reason effectively. These skills include:
      1. Creative Thinking: generate new ideas.
      2. Decision Making: specify goals and constraints, generate alternatives, consider risks, and evaluate and choose the best alternative.
      3. Problem Solving: recognize problems and devise and implement plan of action.
      4. Visualize ("Seeing Things in the Mind's Eye"): organize and process symbols, pictures, graphs, objects, and other information.
      5. Knowing How to Learn: use efficient learning techniques to acquire and apply new knowledge and skills.
      6. Reasoning: discover a rule or principle underlying the relationship between two or more objects and apply it when solving a problem.
    3. Personal Qualities: A worker must display responsibility, self-esteem, sociability, self management, integrity, and honesty.
      1. Responsibility: exert a high level of effort and persevere toward goal attainment.
      2. Self-Esteem: believe in one's own self-worth and maintain a positive view of oneself.
      3. Sociability: demonstrate understanding, friendliness, adaptability, empathy, and politeness in group settings.
      4. Self-Management: assess oneself accurately, set personal goals, monitor progress, and exhibit self-control.
      5. Integrity and Honesty: choose ethical courses of action.
  2. Workplace competencies are defined in five areas: resources, interpersonal skills, information, systems, and technology.
    1. Resources: A worker must identify, organize, plan, and allocate resources effectively.
      1. Time: select goal-relevant activities, rank them, allocate time, and prepare and follow schedules.
      2. Money: Use or prepare budgets, make forecasts, keep records, and make adjustments to meet objectives.
      3. Material and Facilities: Acquire, store, allocate, and use materials or space efficiently. Examples: construct a decision timeline chart; use computer software to plan a project; prepare a budget; conduct a cost/benefits analysis; design an RFP process; write a job description; develop a staffing plan.
    2. Interpersonal Skills: A worker must work with others effectively.
      1. Participate as a Member of a Team: contribute to group effort.
      2. Teach Others New Skills.
      3. Serve Clients/Customers: work to satisfy customer's expectations.
      4. Exercise Leadership: communicate ideas to justify position, persuade and convince others, responsibly challenge existing procedures and policies.
      5. Negotiate: work toward agreements involving exchange of resources, resolve divergent interests.
      6. Work with Diversity: work well with men and women from diverse backgrounds. Examples: collaborate with a group member to solve a problem; work through a group conflict situation, train a colleague; deal with a dissatisfied customer in person; select and use appropriate leadership styles; use effective delegation techniques; conduct an individual or team negotiation; demonstrate an understanding of how people from different cultural backgrounds might behave in various situations.
    3. Information: A worker must be able to acquire and use information.
      1. Acquire and Evaluate Information.
      2. Organize and Maintain Information.
      3. Interpret and Communicate Information.
      4. Use Computers to Process Information. Examples: research and collect data from various sources; develop a form to collect data; develop an inventory record-keeping system; produce a report using graphics; make an oral presentation using various media; use on-line computer databases to research a report; use a computer spreadsheet to develop a budget.
    4. Systems: A worker must understand complex interrelationships.
      1. Understand Systems: know how social, organizational, and technological systems work and operate effectively with them.
      2. Monitor and Correct Performance: distinguish trends, predict impacts on system operations, diagnose deviations in systems' performance and correct malfunctions.
      3. Improve or Design Systems: suggest modifications to existing systems and develop new or alternative systems to improve performance. Examples: draw and interpret an organizational chart; develop a monitoring process; choose a situation needing improvement, break it down, examine it, propose an improvement, and implement it.
    5. Technology: A worker must be able to work with a variety of technologies.
      1. Select Technology: choose procedures, tools or equipment including computers and related technologies.
      2. Apply Technologies to Task: understand overall intent and proper procedures for setup and operation of equipment.
      3. Maintain and Troubleshoot Equipment: Prevent, identify, or solve problems with equipment, including computers and other technologies. Examples: read equipment descriptions and technical specifications to select equipment to meet needs; set up and assemble appropriate equipment from instructions; read and follow directions for troubleshooting and repairing equipment.