BOTE 257 – Database Management 3 Credits Course Description: Acquaints students with database design including data entry, storage and retrieval. Prerequisites: none, but previous computer knowledge is preferred. Course Objectives: Students are expected to: Create and manage information using computer technology Organize, distribute, and store information using database software Apply concepts learned to independent challenge problems Interpret and synthesize information resulting in solutions to problems Demonstrate a working knowledge of database software Integrate database records with other business documents correctly and accurately Instructor: Kayla O’Toole Office: Online Office Hours: Use the eMail tool within the online course to communicate with the instructor. Course eMail messages will be checked daily, Monday through Friday. If you have a technical problem, contact the Distance Education office by calling 1-701-228-5479 or 1-888-918-5623 (toll-free). Email: Use online course eMail tool. Class Schedule: Online Textbooks: Rutkosky, Seguin, Rutkosky. Microsoft Office Access 2007 Levels 1 & 2 Windows XP Edition, Benchmark Series with SNAP Bundle. Paradigm. Students will also need to have Microsoft Access 2007. Course Requirements: Independent Practice: Read the chapters in the textbook that are assigned and complete the assignments that are assigned at the end of the chapters. Assignments: Students will have Concepts Check assignments, case study assignments, projects, and discussion questions to complete.Tests: There will be a short quiz after every chapter. Students will also have to complete a midterm and a final exam. Tentative Course Outline: Week 1: Chapter 1 Week 2: Chapter 2 Week 3: Chapter 3 Week 4: Chapter 4, Unit I Project Week 5: Chapter 5 Week 6: Chapter 6 Week 7: Chapter 7 Week 8: Chapter 8, Unit II Project, Midterm Week 9: Level 2, Chapter 1 Week 10: Level 2, Chapter 2 Week 11: Level 2, Chapter 3 Week 12: Level 2, Chapter 4, Level 2 Unit I Project Week 13: Level 2, Chapter 5 Week 14: Level 2, Chapter 6 Week 15: Level 2, Chapter 7 Week 16: Level 2, Chapter 8, Level 2 Unit 2 Project, Final Exam Relationship to Campus Theme: The student will be able to create Microsoft Access databases for situations in everyday life that will pertain to their field of interest, may it be nature, business, health, or science. Databases will be created to store data, run queries, use forms, and to create reports. The Microsoft Access software is a great tool to learn since this technology can be used in a multitude of situations. The 4 projects within the course allow students to create their own functional database to get a hands-on learning experience. The SNAP software also provides a hands-on experience in learning the Access software. Classroom Policies: This course uses a combination of instructional formats including PowerPoint, discussion, and electronic communication. The PowerPoint lectures are not a substitute for reading the text, and all reading assignments need to be completed. Cheating will result in the automatic failure of this course. All assignments will be submitted to the Assignment Dropbox. Assignments that are late will have points deducted accordingly. Incompletes are handled according to the campus policy.Evaluation: Grading Method : Your final grade is determined by totaling the points you earn. Each assignment, Quiz, Test, unit project, and Discussion Post is worth a set number of points. Grading : Grades will be calculated by dividing the points earned by the total points possible. The letter grade is based on the following criteria: A=90-100 B=80-89 C=70-79 D=60-69 Academic Integrity: The academic community is operated on the basis of honesty, integrity and fair play. It is the expectation that all students, as members of the college community, adhere to the highest levels of academic integrity. This means that Students are responsible for submitting their own work. Student work must not be plagiarized Students must not cooperate on oral or written examinations or work together on evaluated assignments without authorization To learn how to avoid plagiarism in your work, review the website from Purdue University, Is It Plagiarism Yet? Violations of academic principles such as cheating, plagiarism or other academic improprieties will be handled using the guidelines outlined in the Student Handbook on pages 18, 19, and 37 Disabilities and Special Needs: If you have a disability for which you need accommodation, contact the Learning Center to request disability support services: phone 701-228-5477 or toll-free