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
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
Storage media: USB device

 
Class Time Tuesday and Thursday, 9:25 to 10:40 AM, Rhoads Hall 141
   
Instructor
Dr. Joe Brownsmith
Office: RBH 220
Office Phone: 232-5164
e-mail: brownsmith@cs.unca.edu
Office hours: T-R 11-12 AM and by appointment


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 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)

E x p l o r i n g

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)


I n t r e p i d

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


How this Class Works

In each class session, your instructor will review recent topics and handle questions. In addition, new topics will be introduced.

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.

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 and, 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 be required to demonstrate your knowledge and skills in a variety of ways, including written 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 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.

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 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.

Teaching/Learning Methodology

Computer Labs

Availability: The Rhoads Hall 141 computer lab is available during the course hours. Additional lab hours are posted 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: During class, assistance is available from our peer tutor, Kyle Anderson. Kyle is available to assist you when you have a technical problem or if you need help understanding an assignment. He will not perform tasks for you on your computer or tell you step-by-step how to complete an assignment. Please treat him with respect - he 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 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. You are encouraged to help other students when asked.

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.

E-mail Communication

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).


CSCI logo Return to the UNCA Computer Science home page