Fall2022 MIS342 Advanced Business Computer Applications


  Professor Paulson's Home Page

This is a WSU PC laptop required course!

Course ID
Class Times
Virtual Classroom
T Th 11 to 12:20pm
Somsen 301

Office Hours
Pat Paulson
Somsen  303
on website

Syllabus Check periodically for updates
course files are at \\store\classes\20233001846\ReadOnly

Textbooks and Course Materials


  1. Cengage Unlimited / MindTap - Microsoft Access Materials, New Perspectives Collection, Microsoft Office 365, 1e

Reference Materials

  1. LinkeIn Learning for Microsoft Access, SQL Server and other video Tutorials (no charge)
  2. Earbuds with microphones (for listening to training videos and participating in web conferences)


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:

Inclusive Excellence


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.


Attendance & meaningful participation,
Assignments-Formative, Summative
Project 1
Project 2


Project 3


Project 4
Midterms (based on all points)
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