Quizzes, Tests, and Final Exam
There will be a Take-Home and an In-Class Excel exam as well as a Take-Home and an In-Class Access exam. If a student receives a higher grade on the In-Class exam than on the Take-Home exam, then the Take-Home exam grade will be raised to match the In-class exam grade. The Take-Home exam grade will never be lowered. A higher grade on the Take-Home exam never replaces the In-Class exam grade. The make-up exam does not replace the Take-Home grade but will replace the In-Class exam grade.There are two optional make-up exams, one for Excel and one for Access. They are administered in-class during Reading Day. The dates of the makeup exams will be announced halfway through the semester. The grade on the make-up exam replaces the grade on the exam even if it is lower. If a student misses the in-class exam, then the grade of the make-up exam will be substituted. A student can take one or both of the make-up exams. For example, if a student misses the Excel in-class exam she can then take the Excel make-up exam which will replace her 0 for the in-class Excel exam.
The gradebook on Blackboard will always reflect the actual grade you earned on an assessment but the replaced grade will be used in the grade calculation.
Rules for Quizzes and Tests
What is permitted:- You may bring one double sided cheat sheet
- You may have exactly ONE browser tab open and that MUST point to the Blackboard page where you obtain the test data and where you submit your solution.
- You may have the program open (Excel, Access) that you must use to construct your test solution.
- You may NOT access online resources of any kind: previous homework, online tutorials, etc.
- You may NOT open any other internet resource such as e-mail.
- You may NOT e-mail your completed test to yourself or to anyone else.
- You may NOT open any program installed on the machine other than the browser to Blackboard and the program that you are using to construct your test solution.
- You may NOT use any digital device to bring information or data into or out of the lab.
- You may NOT use a cell phone or other communication device while in the lab.
- You may NOT talk to another student while in the lab. If you have a question about the test or a technical problem with your computer, speak to the instructor.
Testing Procedures
To create a fair testing environment for all students, the following test procedures are generally observed:- Students are assigned to work stations or seats at random by the instructor
- Students may be moved to different work stations or seats at the discretion of the instructor
- Students may receive different assessments, tests, or work instructions
- Students may be asked to use a lock-down browser or to log into a specific user account with reduced network access privileges
Syllabus Quiz
All students must take the syllabus quiz and earn a score of 90% in order to pass the course. The syllabus quiz does not count towards a student's grade. The quiz can be taken as often as needed to pass with a score of 90%. The quiz is administered through Blackboard.Topic Quizzes
Topic Quizzes are located in each topic in Blackboard. Topic Quizzes will count for 5% of the overall grade and the lowest quiz score will be dropped. These will help you to assess the degree to which you understand the lecture content.Grading
In-Class exams (30% for Excel In-Class and 30% for Access In-Class) will count for a total of 60 of your overall grade, take-home exams will count for 10% (5% for the Excel Take home and 5% for the Access Take Home exam) . Topic quizzes count for 5% and the assigned labs will count for 14%. The course project will count for 7% of your final grade.There will be a Take-Home and an In-Class Excel exam as well as a Take-Home and an In-Class Access exam. If a student receives a higher grade on the In-Class exam than on the Take-Home exam, then the Take-Home exam grade will be raised to match the In-class exam grade. The Take-Home exam grade will never be lowered. A higher grade on the Take-Home exam never replaces the In-Class exam grade. The make-up exam does not replace the Take-Home grade but will replace the In-Class exam grade.
There are two optional make-up exams, one for Excel and one for Access. They are administered in-class during Reading Day. The dates of the makeup exams will be announced halfway through the semester. The grade on the make-up exam replaces the grade on the exam even if it is lower. If a student misses the in-class exam, then the grade of the make-up exam will be substituted. A student can take one or both of the make-up exams. For example, if a student misses the Excel in-class exam she can then take the Excel make-up exam which will replace her 0 for the in-class Excel exam.
Late Submissions
No Late and email submissions acceptedGrading Scale
Final semester letter grades will be awarded according to the scale below, where X is the final numerical grade:
X >= 94 A
91 <= X < 94 A-
87 <= X < 91 B+
83 <= X < 87 B
80 <= X < 83 B-
77 <= X < 80 C+
73 <= X < 77 C
70 <= X < 73 C-
67 <= X < 70 D+
63 <= X < 67 D
60 <= X < 63 D-
X < 60 F