Print

Syllabus

Database I
IS201

YEAR:

2023-2024

CREDIT HOURS:

1.00

PREREQUISITES:

None

COREQUISITES:

None

COURSE NOTES:

Repeatable once for graduation credit if using a different software package.Students must be able use computer independently (understand general computer concepts, terminology, and operations).

CATALOG COURSE DESCRIPTION:

Introduction to relational database concepts and terminology; basic database skills including creating, using and modifying tables, queries, forms and reports.

HutchCC INSTITUTION-WIDE OUTCOMES:

  1. Demonstrate the ability to think critically and make reasonable judgments by acquiring, analyzing, combining, and evaluating information.
  2. Demonstrate the skills necessary to access and manipulate information through various technological and traditional methods.
  3. Demonstrate effective communication through reading, writing, listening, and speaking.
  4. Demonstrate effective interpersonal and collaborative skills.
  5. Demonstrate effective quantitative-reasoning and computational skills.

AREA OR PROGRAM OUTCOMES

  1. Demonstrate professional attitude and work ethic including collaboration and communication skills.
  2. Evaluate current operating systems, application programs, hardware, networking, security and troubleshooting techniques.
  3. Develop and apply specialized computer technology skills, in a hands-on industry setting.
  4. Distinguish and appropriately apply industry terminology and standards in computer technology.
  5. Research and obtain appropriate information, evaluate alternative solutions and make decisions as applied to computer technology.

COURSE OUTCOMES AND COMPETENCIES:

  1. Define database software and database terminology and plan a database.
    1. Define database software
    2. Identify the parts of a database window
    3. Explain the advantages of using database software
    4. Identify a field
    5. Identify a record
    6. Identify a table
    7. Identify a database object
    8. Determine the purpose of a database
    9. Determine what reports you want the database to produce
    10. Collect the raw data that will be stored in a database
    11. Sketch the structure of each table, including field names and data types
    12. Choose an appropriate data type for each field
  2. Plan, create, modify, and format tables.
    1. Open the Microsoft Access program
    2. Close the Microsoft Access program
    3. Save a database object (file) using the save command
    4. Open the task pane
    5. Open a file from the menu bar
    6. Open a file from the task pane
    7. Identify parts of the database window
    8. Navigate through a datasheet using the tab key
    9. Navigate through a datasheet using the enter key
    10. Navigate through a datasheet using the arrow keys
    11. Navigate to a record using the navigation buttons
    12. Navigate through a datasheet using the keyboard shortcuts
    13. Identify the differences between navigation mode and edit mode
    14. Add a new record to a datasheet
    15. Move a datasheet column
    16. Edit a record
    17. Use the edit mode keyboard shortcuts
    18. Resize datasheet columns
    19. Use the Undo button
    20. Identify the limitations of the Undo button
    21. Delete a record
    22. Use the Print Preview button to preview a datasheet
    23. Change the margins of a datasheet
    24. Change the headers and footers of a datasheet
    25. Change the page orientation from portrait to landscape
    26. Print a datasheet
    27. Hide/unhide fields in a datasheet before printing
    28. Access the Help files
    29. Close a database object
    30. Create a table from the Blank Database link on the task pane
    31. Create a table using the wizard
    32. Add fields to a table
    33. Delete fields in a table
    34. Move fields in a table
    35. Add a description to a field
    36. Add or modify field properties
    37. Modify the format of a datasheet by changing the font
    38. Modify the format of a datasheet by changing the color of font or gridlines
    39. Modify the format of a datasheet by changing the gridlines
    40. Add an Input Mask to specific fields to provide a visual guide for users as they enter data
    41. Add a Validation Rule to specific fields to help prevent users from entering incorrect data
    42. Create a Lookup field using the Lookup Wizard
    43. Create a PivotTable
    44. Create a PivotChart to graphically present the data in the PivotTable
  3. Plan, create, modify, and format queries.
    1. Define a query
    2. Create a Select query using a wizard
    3. Create a Select query using Query Design View
    4. Describe the differences between a query and a filter
    5. Add fields to a query
    6. Move fields in a query
    7. Add Or Criteria to a query field
    8. Add And Criteria to a query field
    9. Describe the differences between Or Criteria and And Criteria
    10. Sort a query on multiple fields
    11. Specify a sort order different from the field order in the datasheet
    12. Create an And Query
    13. Create an Or Query
    14. Create a calculated field in a query
    15. Create a Crosstab Query
  4. Sort records, find data, and filter records.
    1. Sort records based on a selected field in ascending order
    2. Sort records based on a selected field in descending order
    3. Filter records based on selected data and hide records that do not match
    4. Filter records based on more than one selection criteria by using the Filter by Form window
    5. Remove a filter
    6. Use the Find feature to search for a string of characters
    7. Use the wildcard characters (I?#) as substitutes for characters when using the Find feature
    8. Use comparison operators to filter for comparative data
  5. Plan, create, modify, and format forms.
    1. Determine the overall purpose of a form
    2. Determine the underlying record source of a form
    3. Determine the best type of control to use for each item on the form
    4. Describe the differences between bound and unbound controls
    5. Create a form by using the Form Wizard
    6. Create a form using Form Design View
    7. Sort records in a form
    8. Filter records in a form
    9. Edit records in a form
    10. Create a form using the AutoForm feature
    11. Navigate to a specific record by using the Record Navigation buttons
    12. Resize a control on a form
    13. Move a control on a form
    14. Move a control one pixel at a time by pressing the Ctrl and arrow keys
    15. Describe the mouse pointer shapes and the actions that each perform
    16. Modify a label by directly editing it in Form Design View
    17. Modify a label by using the Properties sheet
    18. Align controls on a form
    19. Align the text within a control on a form
    20. Add a control to a form using the Toolbox buttons
    21. Sdd a calculated control to a form
    22. Modify the tab order on a form
    23. Identify the 3 form sections in Design View
    24. Enter a new record using a form
    25. Gind a record using the Find button
    26. Felete a record using the Delete Record button on the Form View toolbar
    27. Insert an image on a form
    28. Tun the Spelling Checker on a form
    29. Print a single record using the form
    30. Describe the purpose of a subform control
    31. Create a subform using the Form Wizard
    32. Create a subform using the Form Design View
    33. Link the main form and subform
    34. Modify the subform
    35. Add or change a List Box control on a form
    36. Add or change a Combo Box control on a form
    37. Add or change an Option Group control on a form
    38. Add a command button to a form
  6. Plan, create, modify, and format reports.
    1. Determine the information that the report will show
    2. Determine how the fields should be organized on the report
    3. Determine how the records should be sorted and/or grouped within the report
    4. Identify the sections of a report
    5. Create a report by using the wizard
    6. Group records in a report using the Sorting and Grouping button
    7. Change a reports grouping and sorting fields in Report Design View
    8. Add a calculated control to a report using the Toolbox button
    9. Sort records in a report
    10. Add a field from an underlying table or query object to a report
    11. Copy and paste items within or between the Microsoft Office applications
    12. Align the text within controls on a report
    13. Align the edges of controls on a report
    14. Format a report by modifying the font
    15. Format a report by modifying the font size
    16. Format a report by modifying the font/fore color
    17. Format a report by modifying the fill/back color
    18. Format a report by modifying the line/border color
    19. Print a report
    20. Create mailing labels using the Label Wizard
    21. Print mailing labels
  7. Examine relational databases and plan and create related tables.
    1. Define a relational database
    2. Explain the purpose of a relational database
    3. Diagram how tables in the same database should be related through a common field
    4. Diagram a one-to many relationship between tables in the same database
    5. Explain the purpose of a junction table
    6. Diagram a many-to-many relationship which is joined by a junction table
    7. Explain the difference between a primary key and a foreign key
    8. Created related tables
    9. Set the primary key field in each table
    10. Link the tables with a one-to-many relationship
    11. Enforce the referential integrity when linking the tables
    12. Print a Relationship report

COURSE ASSESSMENT AND EVALUATION:

1. Study guides 2. Exercises 3. Problems 4. Quizzes 5. Examinations 6. Individual/group projects 7. Homework 8. Assignments

ACCOMMODATIONS STATEMENT:

Any student who has a documented disability and wishes to access academic accommodations (per the 1973 Rehabilitation Act and Americans with Disability Act) must contact the HCC Coordinator of Disability Services, at 620-665-3554, or the Student Success Center, Parker Student Union. The student must have appropriate documentation on file before accommodations can be provided.

ACADEMIC HONESTY:

Education requires integrity and respect for HutchCC's institutional values. HutchCC students are required to maintain honesty through a "responsible acquisition, discovery, and application of knowledge" in all academic pursuits. Preserving and upholding academic honesty is the responsibility of Hut chCC students, faculty, administrators and staff.

I. Student Responsibilities

All HutchCC students are required to:

  • Submit all work in all courses without cheating, fabrication, plagiarism, dissimulation, forgery, sabotage, or academic dishonesty as defined below.
  • Provide all academic records such as transcripts and test scores that are free of forgery.
  • Refrain from participating in the academic dishonesty of any person.
  • Use only authorized notes and student aids.
  • Use technology appropriately, including refraining from submitting AI (Artificial Intelligence)-generated work without express written consent from your instructor.
  • Protect the security of passwords/login/privacy/electronic files, and maintain sole individual access for any online course information.

II. Definition of Academic Dishonesty

  • Academic dishonesty is any intentional act, or attempted act, of cheating, fabrication, plagiarism, dissimulation, forgery, or sabotage in academic work.
  • Cheating includes using unauthorized materials of any kind, whether hard copies, online, or electronic, such as unapproved study aids in any academic work, copying another student's work, using an unauthorized "cheat sheet" or device, or purchasing or acquiring an essay online or from another student.
  • Fabrica tion is the invention or falsification of any information or citation in any academic work, such as making up a source, providing an incorrect citation, or misquoting a source.
  • Plagiarism is the representation of words, ideas and other works that are not the student's own as being original to the student. A no n-inclusive list of examples includes work completed by someone else, work generated by an external entity (such as AI), omitting a citation for work used from another source, or borrowing the sequence of ideas, arrangement of material, and/or pattern of thought of work not produced by the student, even though it may be expressed in the student's own words.
  • Dissimulation is the obscuring of a student's own actions with the intention of deceiving others in any academic work, such as fabricating excuses for absences or missed assignments, or feigning attendance.
  • Forgery of academic documents is the unauthorized altering, falsification, misrepresentation, or construction of any academic document, such as changing transcripts, changing grades on papers or on exams which have been returned, forging signatures, manipulating a digital file of academic work, or plagiarizing a translation.
  • Sabotage is any obstruction or attempted obstruction of the academic work of another student, such as impersonating another student, stealing or ruining another student's academic work.
  • Aiding and abetting academic dishonesty is considered as knowingly facilitating any act defined above.
  • Academic honesty violations can also include the omission or falsification of any information on an application for any HutchCC academic program.

III. Sanctions for Academic Dishonesty

Students who violate the Academic Honesty Policy may be subject to academic or administrative consequences.

Instructor Sanctions for Violation:

Students suspected of violating the Academic Honesty Policy may be charged in writing by their instructor and any of the following may apply:

  • Assign Avoiding Plagiarism Bridge Module
  • Receiving written warning that could lead to more severe sanction if a second offense occurs
  • Revising the assignment/work in question for partial credit
  • Voiding work in question without opportunity for make-up
  • Reducing the grade for work in question
  • Lowering the final course grade
  • Failing the work in question

Institutional Sanctions for Violation:

Students charged with academic dishonesty, particularly in instances of repeated violations, may further be subjected to an investigation and any of the following may apply:

  • Instructor recommendation to the Vice President of Academic Affairs (VPAA) to dismiss the student from the course in which the dishonesty occurs
  • Instructor recommendation to the VPAA to dismiss student from the course in which the dishonesty occurs with a grade of 'F." Student will not be allowed to take a 'W' for the course
  • Instructor recommendation to the VPAA that the student be suspended and/or dismissed from the program
  • Student barred from course/program for a set period of time or permanently
  • May be recommended by the instructor (after documented repeated offenses) to the VP AA that the student be placed on probation, suspended and/or dismissed from the institution.

IV. Procedure

  • Instructor will communicate in writing via the student's HutchCC email account and/or LearningZone email account to the student suspected of violating the Academic Honesty Policy.  That communication may include sanction(s). Department Chair will notify the student's academic advisor upon receipt of the Academic Honesty Violation Form.
  • For each violation, the instructor will submit a completed Academic Honesty Violation Form to the Department Chair. Department Chair will notify the student's academic advisor upon receipt of the Academic Honesty Violation form.
  • Should the instructor choose to pursue institutional sanctions, the instruct or shall notify the student in writing via the student's HutchCC email account.  Instructor shall also submit a completed Academic Honesty Violation Form and all prior completed forms regarding said student to the Department Chair and the office of the VPAA with recommendation to proceed with specific Institutional Sanctions. Department Chair will notify the student's academic advisor upon receipt of the Academic Honesty Violation Form.
  • The decision of the VPAA on Institutional Sanction is final. The VPAA will notify the student's academic advisor of any institutional sanctions.

V. Due Process Rights

Students charged with violations of academic honesty have the right of appeal and are assured of due process through the Academic Honesty Appeal process.

Academic Honesty Appeal Process

I. Due Process Rights: Students charged with violations of academic honesty have the right of appeal and are assured of due process through the Academic Honesty Appeal process.

  • If an instructor has recommended course or program dismissal, the student may continue in coursework (provi ding there are no threatening or security behavioral issues) until appeal processes are concluded. However, if an issue has been documented at a partnership location (e.g., clinical sites, secondary institutions, correctional or military facilities), then the student is no longer eligible to continue participation in internships, apprenticeships, and/or clinical-based practice. For clinical sites, this sanction is immediate.

II. Process

If the student disagrees with the charge of a violation of academic honesty, the student has the right to due process as described in the Academic Honesty Appeal process below:

  • If the matter is not resolved upon communicating with the instructor about the violation, the student shall, within five business days of the issuance of the written notice of violation, submit a completed Academic Honesty Appeal Form and supporting documentation to the appropriate department chairperson to initiate an Academic Honesty Appeal.
  • Within two business days of receiving the student's completed Academic Honesty Appeal Form, the Department Chair and VPAA will review and the VPAA will render a decision.
  • Within two business days, a response will be sent to the student's HutchCC email address. The VPAA's decision is final.

INCOMPLETE GRADE:

Instructors may give a student a grade of Incomplete (I) under the following conditions:

  1. The student must initiate the request prior to the time final course grades are submitted to Records.
  2. The request must be made because of an emergency, illness or otherwise unavoidable life-event.
  3. The instructor must agree to the request before a grade of Incomplete can be submitted.
  4. A written contract between the instructor and student, signed by both, will document the work required and date needed to complete course work.
  5. If a student does not complete the course requirements within the time frame established by the instructor, a grade of "F" will be recorded on the student's transcript at the end of the next semester.

HLC ACCREDITATION:

Hutchinson Community College is accredited by the Higher Learning Commission (HLC). The Higher Learning Commission is one of six regional institutional accreditors recognized by the US Department of Education and the Council on Higher Education Accreditation (CHEA).