|
CSCI 379:
Databases for Everything Syllabus for Fall Semester 2005 |
||||||
| Course Description |
This course introduces database design and use using a popular database management system (DBMS). Topics include: database terminology, practical use, design, and creation of tables, queries, and reports. Learn to organize and use diverse data collections, e.g., college life info, music, photos, and create/view database web pages, and more, using a database system. This course is a writing intensive course.
"Writing Intensive courses offer students ways to deepen their education in writing and critical thinking
..." From
Integrative Liberal Studies
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
| |||||
| Class Time | Tuesday and Thursday, 9:25 to 10:40 AM, Rhoads Hall 141 |
|||||
| Instructor |
| |||||
| Date | Lesson & Lesson Notes |
Access Database Assignment Information Literacy Assignment |
Writing Assignment |
|---|---|---|---|
| Week 1 August 18 |
Course outline, schedules, procedures |
(Th) Bring your textbook and USB storage device to this class
Read Tutorial Overview Copy Access Data files to your USB storage device Review Computer Lab Policies Pirint UNCA Survival Glossary Complete Information Literacy 1     Exploring Ramsey Library |
|
| Week 2 August 23, 25 |
Tutorial 1 | (Tu) Tutorial Work (Th) Case 1, Case 4, and        Student Services Database Part 1: Discovery.        In-class data sheet creation. |
(Tu)
(Th) Begin "From Data Collection To Database" Review Example of Writing Style Review Grading Rubric |
| Week 3 August 30, September 1 |
Tutorial 2 | (Tu)
Information Literacy 2
    Exploring InfoLit @ Ramsey Tutorial Work (Th) Case 1, Case 4, and        Student Services Database Part 2: Database Creation |
(Tu)
(Th) |
| Week 4 September 6, 8 |
Tutorial 3 | (Tu,Th) Tutorial Work | (Tu) Draft is due (not graded)
(Th) Comments returned to you |
| Week 5 September 13, 15 |
Tutorial 3 | (Tu,Th) Case 1, Case 4
(Th) Information Literacy 3     Finding Articles | (Tu)
(Th) |
| Week 6 September 20, 22 |
Exam | (Tu) Prepare for Exam, (Th) Exam |
(Tu)Turn in final copy for grade
(Th) |
| Date | Lesson & Lesson Notes |
Access Database Assignment Information Literacy Assignment |
Writing Assignment |
|---|---|---|---|
| Week 7 September 27, 29 |
Database of Web links project Tutorial 4 |
(Tu)
Information Literacy 4
     Evaluating Web Information      Personal Web Links Database Part 1&2: Database Design and Implementation (Th) Tutorial Work |
(Tu)
(Th) Begin "Little Known Facts" |
| Week 8 October 4 |
Tutorial 4 | (Tu) Case 1, Case 4
Due today: Personal Web Links Database project | (Tu) |
| Week 9 October 11, 13 |
Tutorial 5 | (Tu)
Information Literacy 5
    Small Group Assignment Begin Tutorial 5 (Th) Tutorial 5 | (Tu)
(Th) |
| Week 10 October 18, 20 |
Tutorial 5 | (Tu,Th) Tutorial Work, Case 1, Case 4 | (Tu) "Little Known Facts" Draft is due (not graded)
(Th) Comments returned to you |
| Week 11 October 25, 27 |
Exam | (Tu) Prepare for Exam, (Th) Exam |
(Tu) Turn in final copy for grade
(Th) |
| Date | Lesson & Lesson Notes |
Access Database Assignment Information Literacy Assignment |
Writing Assignment |
|---|---|---|---|
| Week 12 November 1, 3 |
Leadership Asheville project |
(Tu,Th) Real World Experience Leadership Asheville (LA)
LA sample spreadsheet YLA sample database Database Design Guidelines |
(Tu) Begin:
"Real World Experience"
(Th) |
| Week 13 November 8, 10 |
Leadership Asheville project |
(Tu) Continue with database design and implementation
(Th) Continue with database implementation |
(Tu)
(Th) |
| Week 14 November 15, 17 |
Leadership Asheville project |
(Tu,Th) Continue with database implementation | (Tu)
(Th) |
| Week 15 November 22 |
Tutorial 6 | (Tu)Tutorial Work | (Tu) Draft is due (not graded) |
| Week 16 November 29, December 1 |
Tutorial 6 | (Tu,Th)Tutorial Work and Case 1 | (Tu) Comments returned to you
(Th) Turn in final copy for grade |
| Week 17 December 8 |
Final Exam: 8:00 - 10:30 AM |
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 computer work on your part, your verification that it is correct, and an instructor/tutor "check off" to assign points.
Lab assignment solutions 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 printed and turned in to the peer tutor at the beginning of the next class meeting. 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 and, 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 ion can be 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 5%.
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 can be 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 peer tutor will assign points as you complete parts of the assignment. 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 will not be accepted and receives no points. However, late work can be accepted with the instructor’s prior approval. 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 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 are encouraged to help other students when asked.
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 e-mail 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).