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
In this course, we will focus on Computer Science information literacy in general, and database literacy in particular.

Prerequisites: none
Offered:  Fall (3)
Who can take this course: Transfer students

   
Knowledge Objectives As a result of taking this course, you will be able to:
  • Develop a working knowledge of a relational database management system.
  • Understand and use guidelines for designing databases and database tables.
  • Develop database objects such as tables, forms, queries, and reports.
  • Develop databases related to UNCA student services and web pages.
  • Relate to real world database application development.
   
Further Objectives
  • Develop effective written communication skills
  • Develop technical writing skills suitable for Computer Science reports.
  • Develop good oral communication skills.
  • Create a sense of community among the students.
  • Increase the student's potential for success by developing responsibility and good study skills.
   
Even Further Objectives
  • Develop effective information literacy skills, such as:
    • Access the needed information effectively and efficiently.
    • Evaluate information and its sources critically.
    • Use information effectively to accomplish a specific purpose.
    • Understand how to access and use information ethically and legally.
Required Textbook and Media

New Perspectives on Microsoft® Access 2003 Introductory, Adamski & Finnegan ISBN 1-4188-3908-6
See: http://www.course.com/catalog/product.cfm?isbn=1-4188-3908-6&CFID=30018458&CFTOKEN=69144877
Storage media: USB device

 
Class Time Tuesday and Thursday, 11:00 AM to 12:10 PM, Rhoades Hall 141
   
Instructor
Dr. Joe Brownsmith
Office: RBH 220
Office Phone: 232-5164
e-mail: brownsmith@cs.unca.edu
Office hours: T-R 10-11 AM and by appointment
Informal availability: M,W afternoon, Rhoades 205
   
Student mentor
Ms Lindsay Thomas


Databases for Everything

This is a tentative schedule. Additional assignment details will be provided as the class progresses.

I n t r o d u c t i o n

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

E x p l o r i n g

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)


I n t r e p i d

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.


How this Class Works

In each class session, your instructor will review recent topics, answer questions, and introduce new topics.

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.

Tutorial Notes

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.

Methods of Evaluation

UNC Asheville is committed to providing you with an educational experience that will aid you in the development of your thinking and technical skills. During the course you will demonstrate your knowledge and skills in a variety of ways such as exams, writing assignments, and projects/lab assignments.

Assessment

Exams 40%
Tutorial, Case Assignments, and Creative Labs 40%
       (For Tutorials 1-7 the number of points for tutorial & case work is: 8, 8, 18, 13, 24, 7, 49)
       (For Creative Labs 1-3 the number of points is: 20, 20, 20)
Writing Assignments 20%

Letter grades are assigned based on the percentage of available points obtained by a student. 100% to 90% is an A, 89% to 80% is a B, and so on. The instructors reserve the option of relaxing the cut-offs for a letter grade in special circumstances. Plus and minus grades will be used for this course.

Attendance

Your attendance at all class sessions is crucial. The class will be driven by your active participation. Attend ALL class sessions, review the materials before class, and complete the weekly assignments on time.

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.

Make-Up Policies

Exams: If you are going to miss an exam, you must inform your instructor 24 hours prior to the exam in order to make up a missed exam. Voice mail and email are available 24 hours a day, 7 days a week; therefore, you will be expected to make this effort.

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.

Teaching/Learning Methodology

Computer Labs

Availability: The Rhoades Hall 141 computer lab is our classroom. This room is also available to you during other hours - see the lab hours posting on the door. Computers are also available for your use in other labs on campus. There are labs in Karen hall and Robinson (006). When you go to these other labs, there may be a class in session. Out of courtesy for your fellow students and their instructors, please do not enter a classroom when a class is in session. Sometimes an instructor will allow you to work in the lab during class. Always ask before the class starts. People wandering in and out during class time are a distraction to students who are enrolled in the course and entitled to that time in the classroom.

Peer Tutor

Lab Assistance: This class is fortunate to have a peer tutor, Lindsay Thomas. She will provide database assistance during class and will help with your orientation to UNC Asheville. For example, she s available to assist you when you have a technical problem, or if you need help understanding an assignment. However, she will not perform tasks for you on your computer or tell you step-by-step how to complete an assignment. Please treat her with respect - she is a student too.

Other Information

Assessment of Writing Assignments

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.

Reporting Format for Writing Assignments

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.

Academic Integrity Policy

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.

In-Class Conduct

You are expected to contribute to the creative learning atmosphere of our classroom.

Team Work

Each student is responsible for completing each assignment individually. However, sharing of knowledge among students in this class is encouraged. For example, if you have completed an assignment, you may help others who have not. If you are having trouble with an assignment, you may ask other students for assistance. This sharing of knowledge and help is expected and is the expected behavior in this class.

Homework

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.

Email Communication

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.


CSCI logo Return to the UNCA Computer Science home page