|
CSCI 379:
Databases for Everything Syllabus for Fall Semester 2007 |
|||||||
| Course Description |
Databases are a tool for thinking about and organizing data. Databases are widely used in industry, government, universities - organizations large and small, here and abroad. Databases are important, essential, relevant, and useful. We will learn many things about databases using a popular database management system. Databases are a great tool for organizing diverse data collections such as college life info, music, photos, and more. This course is offered in a computer laboratory setting. This course is a writing intensive course. Writing Intensive courses offer students ways to deepen their education in writing and critical thinking. (For general background information on the ILS program, see ILS Requirements and ILS). In this course we will undertake technical writing assignments appropriate to the discipline of Computer Science in general, and related to database in particular. This course is also an information literacy intensive course.
"Acquiring, evaluating, and using information is increasingly important in a complex society.
To develop these important skills, students are required to take two Information Literacy Intensive courses...".
From InfoLit @ Ramsey
Prerequisites: none
|
||||||
| Knowledge Objectives |
As a result of taking this course, you will be able to:
|
||||||
| Further Objectives |
|
||||||
| Even Further Objectives |
|
||||||
| Required Textbook and Media |
New Perspectives on Microsoft® Access 2003 Introductory, Adamski & Finnegan
ISBN 1-4188-3908-6
| ||||||
| Class Time | Tuesday and Thursday, 11:00 AM to 12:10 PM, Rhoades Hall 141 |
||||||
| Instructor |
| ||||||
| Student mentor |
| ||||||
| Date | Lesson & Lesson Notes |
Access Database Assignment Information Literacy Assignment |
Writing Assignment |
|---|---|---|---|
| Week 1 August 21, 23 |
Course outline, schedules, procedures Tutorial 1 Notes Powerpoints |
(Tu) Bring your textbook and USB storage device to the Tuesday class Review Computer Lab Policies Print UNCA Survival Glossary (Th) Tutorial 1 Tutorial Work Read Tutorial Overview Copy Access Data files to your USB storage device |
|
| Week 2 August 28, 30 |
Tutorial 1 Notes
Powerpoints |
(Tu) Case 1, Case 4, and
       Student Services Database Part 1: Discovery.        In-class data sheet creation. (Th) Tutorial 2 Tutorial Work |
(Tu)
(Th) Begin "From Data Collection To Database" Review Example of Writing Style Review Grading Rubric |
| Week 3 September 4, 6 |
Tutorial 2 Notes
Tutorial 3 Notes Powerpoints |
(Tu) Case 1 & 4 of Tutorial 2, and        Student Services Database Part 2: Database Creation (Th) Tutorial 3 Tutorial work |
(Tu)
Complete Information Literacy 1
    Exploring Ramsey Library (Th) |
| Week 4 September 11, 13 |
Tutorial 3 Notes | (Tu) Tutorial 3 work and Case 1
(Th) Tutorial 3 work and Case 1 | (Tu) Writing Draft is due (not graded)
(Th) Comments returned to you |
| Week 5 September 18, 20 |
(Tu) Case 4 of Tutorial 3 ,
Information Literacy 2     Exploring InfoLit @ Ramsey Information Literacy 3     Finding Articles (Th) Prepare for Exam |
(Tu)
(Th)Turn in final copy for grade |
| Date | Lesson & Lesson Notes |
Access Database Assignment Information Literacy Assignment |
Writing Assignment |
|---|---|---|---|
| Week 6 September 25 ,27 |
Database of Web links project Tutorial 4 Notes Powerpoints |
(Tu)Exam
     Personal Web Links Database: Database Design and Implementation (Th) Information Literacy 4      Evaluating Web Information Tutorial Work |
(Tu)
(Th) Begin "Little Known Facts" |
| Week 7 October 2, 4 |
Tutorial 4 Notes | (Tu) Tutorial Work
(Th) Case 1, Case 4 | (Th) Continue "Little Known Facts" |
| Week 8 October 11 |
Tutorial 5 Notes
Powerpoints |
(Th)
Information Literacy 5
    Small Group Assignment | (Th) |
| Week 9 October 16, 18 |
Tutorial 5 Notes | (Tu) Tutorial 5
Due today: Personal Web Links Database project (Th) Tutorial Work, Case 1 |
(Tu) "Little Known Facts" Draft is due (not graded)
(Th) Comments returned to you |
| Week 10 October 23, 25 |
Tutorial 5 Notes | (Tu) Case 4
(Th) Prepare for exam |
(Tu) Turn in final copy of database and
writing for grade |
| Week 11 October 30, November 1 |
Exam | (Tu) Exam,
(Th) Database design concepts Appendix A and CityState.mdb.jdb and ClientVetPet.xls |
(Tu)
(Th) |
| Date | Lesson & Lesson Notes |
Access Database Assignment Information Literacy Assignment |
Writing Assignment |
|---|---|---|---|
| Week 12 November 6, 8 |
HWP Project |
(Tu) Prof. K. Garbe, Health and Wellness Department
HWP.Internship database.09.12.2007.xls (Th) HWP database table design and implementation HWP PowerPoints |
(Tu) Journal writing
(Th) Journal writing |
| Week 13 November 13, 15 |
HWP Project |
(Tu) Continue with HWP database implementation - queries and reports (Th) |
(Tu) Journal writing
(Th) Journal writing |
| Week 14 November 20, 22 |
HWP Project |
(Tu) Finish HWP database implementation
HWP.FormProblemSolution.11.18.2007.doc (Th) No class. Thanksgiving break |
(Tu) Journal writing |
| Week 15 November 27, 29 |
(Monday)Demo of our database work at HWP Internship Event. Highsmith - 4:30 to 6 PM HWPNov26Internship_SHOW.v3.ppt (Tu) Complete the HWP project (Th) Course wrap up and prepare for exam. |
(Tu) Journal writing | |
| Week 16 December 5-11 |
Final Exam: |
(Th) Thursday December 6, 11:30 - 2:00 PM
Exam emphasizes database table design, queries, forms, and reports |
(Th) Turn in your journal writing assignment
with your exam. |
You will spend most of the in-class time working on the assigned Tutorial and Case material from the text book. Your instructor and peer tutor will provide any help you need during this time. Each Tutorial and "Case" involves:
Solutions to the lab assignments are available for you to check your work prior to the instructor check off. Therefore, your work will either be correct or incorrect. You will typically receive one point per printout per assignment or as noted in the Tutorial Notes.
Tutorial and Case assignments that are not completed in class are completed outside class (as "homework"). Before the next class, complete and print the assignment. At the beginning of the next class meeting turn in the printed work to the instructor or peer tutor. Make sure all work clearly identifies you and the assignment. Staple multiple printouts together by assignment and in the order printed.
If you complete the assignments and have additional time in class, feel free to explore the unassigned exercises. This is not extra credit.
You are provided with a "Tutorial Note" for each of the textbook Tutorials. These will help you succeed with the lesson and are based on prior class teaching with this textbook. These tutorial notes also indicate what you need to present for grading and the number of points available. Read the notes before starting the lesson. As the lesson proceeds, check off the items for grading.
You are asked to make a commitment to arrive in class on-time. Important information is typically given at the beginning of class and we would not want you to miss it.
You will have two personal days for absence should you need it. (This is equivalent to missing an entire week of class). For each additional class period missed, if it is an unexcused absence, your course grade will be reduced by 4%.
You are responsible for all material, assignments, and notes handed out or assigned during any class, whether or not you are present. Check with another student in the class; class content can't be summarized via an email or a phone conversation.
Writing Assignments: Late work may only be accepted with the instructor’s approval. Assignments will not be accepted once the exam for that material has been administered.
Lab Assignments: Lab assignments are divided into three categories: "in-class", "due", and "late". IN-CLASS: All lab assignments will be started in-class and may be completed during the class period. Your instructor or peer tutor will assign points as you complete parts of the assignment in class. DUE: Lab assignments that have not been completed in class are not late. They are due at the beginning of the next class period. (It is expected that you will need extra time to complete a lab. There is no penalty for this.) If a "due" assignment is not submitted at the beginning of the next class period, it is late. You are responsible for submitting a "due" assignment whether or not you attend the class period. LATE: Late work is work that has not been completed in class and not turned in at the beginning of the next class period. Late work will not be accepted and receives no points without prior approval of the instructor. Assignments will not be accepted once the exam for that material has been administered.
Evaluation of each assignment will use the specific criteria discussed in this syllabus and discussed in class. The following rubric will be used to evaluate the semester project as well as the papers (i.e., one page reflections and retrospectives) that are assigned:
An Outstanding Project/Paper (grade of A) is a well organized paper that can be understood without explanation from the author, is well-written, clearly conceptualized, addresses all stated criteria, reflects a great deal of time investment in the assignment, is carefully crafted, and adds at least one additional criteria.
A Good Project/Paper (grade of B) is well organized, can be understood without explanation from the author, is well written and clearly conceptualized, and addresses all the stated criteria.
A Satisfactory Project/Paper (grade of C) is organized but not especially well organized, can be understood only with some effort or explanation from the author, addresses most or all the stated criteria. If your assignment merely meets the requirements you will receive a C.
Poor Project/Paper (grade of D or below) is unorganized, poorly written/conceptualized, is missing criteria.
In order to encourage the development of good communication skills which are essential in the business environment, sloppy or incorrect English in any assignment will adversely affect your grade.
Writing assignment requirements: typed, at least 4 pages in length, 1" margins, 8.5x11" paper, Times New Roman 11 point font, double spaced. Note: There should be at least 4 pages of text. This does not include the figures, graphs, tables, reports, etc. Since you final report will have these figures, etc., your final report will be longer than 4 pages.
Absolutely no form of cheating or plagiarism, electronic or otherwise, will be tolerated in any aspect of this course. A grade of 0 will be given on the assignment or exam. See Student Responsibilities - Academic Honesty at http://www.unca.edu/catalog/academicregs.html#grading.
You are expected to contribute to the creative learning atmosphere of our classroom.
You should budget at least 4 hours outside of class per week for completing assignments, study and reading for this course. Use these 4 hours to complete any "due" assignments, scan the material to be covered during the next class, and work on the writing assignment.
Your instructor may need to communicate with you through email to your bulldog account (yourName@bulldog.unca.edu). You should frequently (daily) check this e-mail for messages, and to insure that new messages can be received (i.e., that your mailbox is not full). You may email your instructor as needed for course-related questions - see my email address in the "Instructor" section.