| Professor Paulson's Home Page |
|---|
|
|
|
|
|
Virtual Classroom
|
|
02
|
001846
|
T Th 11 to 12:20pm
|
Somsen 301
|
|
|
Instructor
|
e-mail
|
Office
|
Office Hours
|
Phone
|
|
Pat Paulson
|
Somsen 303
|
on website
|
457-5581
|
|
|
|
REQUIRED:
This course is designed provide individuals with a complete introduction to database concepts and the relational database model. Topics include QBE (Query By Example), SQL (Structured Query Language), normalization, design methodology, DBMS (DataBase Management System) functions, database administration, and other database management approaches, such as client/server databases, object oriented databases, and data warehouses. At the completion of this course, students should be able to understand a user's database requirements and translates those requirements into a valid database design.
A series of projects will be used to familiarize the students with using software for creating and maintaining database applications and for working with web sites.Class Meetings : You are required to attend all class meetings in Somsen 301 in person. This is NOT an online course. The class recordings, if available, are intended for students to review class proceedings. If you miss a class meeting use the recordings to review the class. It is your responsibility to keep up with class. Office hours are not meant for individual lectures.
Class Participation
You are required to log into the Zoom web conference during every class.
Class participation is useful
to the student as a means of acquiring knowledge and subject matter
clarification.
Class participation is the active engagement in problem solving,
questions and
answers, taking part in analyses of business situations, and
contribution of
comments in class sessions.
Watching a minimum of four (4) hours of LinkedIn Learning material on topics related to this class will be a factor in your Participation grade.
Making use of the D2L "Question and Answer
Forum" counts as class participation. Meaningful class participation,
or lack thereof,
affects your grade.
Professor Paulson supports and encourages diversity-it enriches our lives. If you find yourself in need of resources or support, please see me, or consider making use of the following resources:
Refer to the class syllabus. Students are expected to read the material listed in the "Presentations" column before class. Classwork will consist of discussing the material for the current chapter. Time will also be devoted to doing in class exercises, devising and presenting assignment solutions, discussing how to use the appropriate software programs to solve assignment and general business problems. Students will demonstrate how to solve problems to the class using Zoom web conferencing software.
Refer to the class syllabus. Students are expected to complete
and submit by the D2L due date any assignments in the "Work"
column.
Assignments are completed using Microsoft Access and Visual Studio 2019, publishing to your personal class website, and then submitting to the professor's web database.
Students are responsible for submitting their assignments on time, and to make
sure their information was submitted correctly.
There is a StarID field on each Assignment. This is for your StarID. You can use your last name and StarID to verify the date and time that your assignment was submitted using a form available on the course website.
Hand written, paper or emailed assignments do not look professional and are not acceptable. You will receive none of the possible points for these types of assignment submissions.
If you are having trouble with grammar, spelling or written communications, please seek assistance from the Writing Center.
Project 1: Website at https://classes.winona.edu/ 20233001846/<username> for completing assignments
Project 2: Database connections
Project 3: Business database
Project 4: Internet of Things, database
Students are encouraged to work in groups in this class.
The final consists of true/false, multiple choice and short answer Excel questions. This exam will be open-book, open notes. Use of any instant messaging or email is not allowed. Students cannot share a book during the exam. The exam contains one question per page, and you can view a question only one time-you cannot go back.
If you are having troubles with the class, do not hesitate to email me.
More information about the exam will be made available closer to examination time.
Additional exam time will not be given!
Exams cannot be made up.
You must be in the classroom to take the exam.
Please check the syllabus now and make sure that you are available on the exam date.
If you cannot make an exam you may want to consider dropping the class.
|
7.5%
|
Attendance & meaningful participation, |
|
25%
|
Assignments-Formative, Summative |
|
5%
|
Project 1 |
|
5%
|
Project 2 |
|
10% |
Project 3 |
|
10% |
Project 4 |
|
10%
|
Midterms (based on all points) |
|
10%
|
Final |
| 12.5% | Mindtap Assignments & Exams |
| 5% | LinkedIn Learning |
Grading is done right after it is due (usually Mondays at 7am) to provide prompt feedback. Anything submitted after the due date will receive minimal, if any credit, at the professor's discretion. If you have a situation preventing you from completing course work, you must contact the professor as soon as possible so that a prompt decision can be made.
No extra credit assignments or make-up exams! This is done to be fair to those students who keep up with the material.
You can lose up to 10% of the points on any assignment, exam or project due to poor spelling and or grammar. Make use of the Writing Center.
You may receive an email with feedback for an assignment, or comments in the D2L gradebook.
If the email begins with a smiley emoticon :-) you received full credit for that assignment.
The email may contain an outline of the grading rubric.
The comment "NO SUBMISSION TO WEB DATABASE" means that you did not press the 'SUBMIT' button on your assignment page from while viewing it in a browser.
You are responsible for making sure the links to each assignment are correct, and that any screen shots and required materials are correctly completed.
I reserve the right to correct any grading errors.
Keep any graded work until the end of the course; recording errors may occur.
A - 90% or greater
B - 80 to 89.9%
C - 70 to 79.9%
D - 60 to 69.9%
F - less than 59.9%
A borderline grade is defined as 89.9 to 89.99; 79.9 to 79.99; 69.9 to 69.99 or 59.9 to 59.99
| Professor Paulson's Home Page |
|---|