OMIS 259 Schedule

Week of…

You MUST be in the Auditorium on the Monday of each week.  Wednesday you may optionally come for extra help, or just work online.

Assignments (due by end of day Friday at the end of the week listed) and Quizzes (given in the Auditorium on the Monday of the week listed)

 

Monday, August 23, 2021

 

Watch Welcome to OMIS 259 (click)

 

Watch What is OM&IS? View the two-minute video (click)

 

Dennis Barsema Welcome

 

OMIS 259:  Class procedures and logistics

 

PowerPoint slides for Class procedures and logistics

 

Begin your Google Web site (see tutorial link in next week’s box)

 

Monday, August 30, 2021

Guest speaker, Monday, end of class: 

Howard Hill, NIU 1980

Mr. Hill’s PowerPoint slides (including his contact information)

 

Introduction to MyITLab:  Purchase and Use MyITLab

 

PowerPoint slides for Introduction to MyITLab

 

 

Create Google Web Site

 

Monday, September 6, 2021

(no class in the Auditorium on Labor Day, Monday Sept. 6.  Attendance Wednesday Sept. 8 is REQUIRED)

 

Watch:  Microsoft Excel Brief Introduction (click)

 

Excel Chapter 1:

·         Read Ebook chapter 1 (within MyITLab)

 

Monday, September 13, 2021

REQUIRED:

Excel Chapter 1:

·         Simulation Training (ST) Excel Chapter 1, 20% of chapter grade, unlimited attempts

·         Simulation Exam (SE) Excel Chapter 1, 80% of chapter grade, 2 attempts

·         (click here to view GPHW video tutorials for this chapter)

 

 

 

OPTIONAL:

·         Grader Project Homework (GPHW), unlimited attempts

·         Grader Project Assessment (GPA), 2 attempts

 

 

Monday, September 20, 2021

 

Monday in the Auditorium, 9:30-10:00:

Quiz 1 (available in Blackboard.  You get one attempt, 30 minutes.  Covers videos, MyITLab Excel Ch. 1, and Web Site assignment)

 

 

REQUIRED:

Excel Chapter 2:

·         Read Ebook Excel chapter 2 (within MyITLab)

·         Simulation Training (ST) Excel Chapter 2, 20% of chapter grade, unlimited attempts

·         (click here to view GPHW video tutorial for this chapter)

 

Watch:  Using the =PMT function for a home loan payment schedule

(video is cut off at the end but it’s basically done)

 

OPTIONAL:

·         Grader Project Homework (GPHW), unlimited attempts

 

Monday, September 27, 2021

 

REQUIRED:

Excel Chapter 2:

·         Simulation Exam (SE) Excel Chapter 2, 80% of chapter grade, 2 attempts

 

 

 

OPTIONAL:

·         Grader Project Assessment (GPA), 2 attempts

 

 

 

Monday, October 4, 2021

 

Monday in the Auditorium, 9:30-10:00:

Quiz 2 (available in Blackboard.  You get one attempt, 30 minutes.  Covers videos, MyITLab Excel Ch. 1 and 2)

 

REQUIRED:

Excel Chapter 3:

·         Read Ebook Excel chapter 3 (within MyITLab)

·         Simulation Training (ST) Excel Chapter 3, 20% of chapter grade, unlimited attempts

·         Simulation Exam (SE) Excel Chapter 3, 80% of chapter grade, 2 attempts

·         (click here to view GPHW video tutorial for this chapter)

 

 

OPTIONAL:

·         Grader Project Homework (GPHW), unlimited attempts

·         Grader Project Assessment (GPA), 2 attempts

 

 

Monday, October 11, 2021

 

Monday in the Auditorium, 9:30-10:00:

Quiz 3 (available in Blackboard.  You get one attempt, 30 minutes.  Covers videos, MyITLab Excel Ch. 3)

 

REQUIRED:

Excel Chapter 4:

·         Read Ebook Excel chapter 4 (within MyITLab)

·         Simulation Training (ST) Excel Chapter 4, 20% of chapter grade, unlimited attempts

·         Simulation Exam (SE) Excel Chapter 4, 80% of chapter grade, 2 attempts

·         (click here to view GPHW video tutorial for this chapter)

 

OPTIONAL:

·         Grader Project Homework (GPHW), unlimited attempts

·         Grader Project Assessment (GPA), 2 attempts

 

 

Monday, October 18, 2021

 

REQUIRED:

Excel Chapter 5:

·         Read Ebook Excel chapter 5 (within MyITLab)

·         Simulation Training (ST) Excel Chapter 5, 20% of chapter grade, unlimited attempts

·         Simulation Exam (SE) Excel Chapter 5, 80% of chapter grade, 2 attempts

·         (click here to view GPHW video tutorial for this chapter)

 

Watch:  Introduction to Data Analytics using Pivot Tables

 

[click here to download data for the Analytics video]

 

OPTIONAL:

·         Grader Project Homework (GPHW), unlimited attempts

·         Grader Project Assessment (GPA), 40% of chapter grade, 2 attempts

 

 

Monday, October 25, 2021

 

REQUIRED:

Excel Chapter 6 (NO chapter grade):

·         Read Ebook Excel chapter 6 (within MyITLab), only Goal Seek parts

·         Simulation Training (ST), only Goal Seek parts (meaning, just Step 10.  Other steps are optional.  Your ST grade will be low, but it is not counting.  You’re doing Goal Seek so you understand it for Quiz 4).

 

 

Monday, November 1, 2021

 

Monday in the Auditorium, 9:30-10:00:

Quiz 4 (available in Blackboard.  You get one attempt, 30 minutes.  Covers videos, MyITLab Excel Ch. 4, 5, and Goal Seek in Ch. 6)

 

REQUIRED:

Watch:  Microsoft Access Brief Introduction (click)

A Word on Referential Integrity

 

Access Chapter 1:

·         Read Ebook Access chapter 1 (within MyITLab)

·         Simulation Training (ST) Access Chapter 1, 20% of chapter grade, unlimited attempts

·         Simulation Exam (SE), 80% of chapter grade, 2 attempts

·         (click here to view GPHW video tutorial for this chapter)

 

OPTIONAL:

·         Grader Project Homework (GPHW), unlimited attempts

·         Grader Project Assessment (GPA), 2 attempts

 

Monday, November 8, 2021

 

REQUIRED:

Access Chapter 2:

·         Read Ebook Access chapter 2 (within MyITLab)

·         Simulation Training (ST) Access Chapter 2, 20% of chapter grade, unlimited attempts

·         Simulation Exam (SE), 80% of chapter grade, 2 attempts

·         (click here to view GPHW video tutorial for this chapter)

 

 

OPTIONAL:

·         Grader Project Homework (GPHW), 10% of chapter grade, unlimited attempts

·         Grader Project Assessment (GPA), 40% of chapter grade, 2 attempts

 

Monday, November 15, 2021

 

Monday in the Auditorium, 9:30-10:00:

Quiz 5 (available in Blackboard.  You get one attempt, 30 minutes.  Covers videos, MyITLab Access Ch. 1 and Ch. 2)

 

REQUIRED:

Access Chapter 3:

·         Read Ebook Access chapter 3 (within MyITLab)

·         Simulation Training (ST) Access Chapter 3, 20% of chapter grade, unlimited attempts

·         Simulation Exam (SE) Access Chapter 3, 80% of chapter grade, 2 attempts

·         (click here to view GPHW video tutorial for this chapter)

 

 

 

OPTIONAL:

·         Grader Project Homework (GPHW), unlimited attempts

·         Grader Project Assessment (GPA), 2 attempts

 

Monday, November 22, 2021

(no Help Session in the Auditorium on Wednesday, Nov. 24 – Thanksgiving Break)

 

Monday in the Auditorium, 9:30-10:00:

Quiz 6 (available in Blackboard.  You get one attempt, 30 minutes.  Covers videos, MyITLab Access Ch. 3)

 

REQUIRED:

Access Chapter 4:

·         Read Ebook Access chapter 4 (within MyITLab)

·         Simulation Training (ST) Access Chapter 4, 20% of chapter grade, unlimited attempts

·         Simulation Exam (SE) Access Chapter 4, 80% of chapter grade, 2 attempts

·         (click here to view GPHW video tutorial for this chapter)

 

 

OPTIONAL:

·         Grader Project Homework (GPHW), unlimited attempts

·         Grader Project Assessment (GPA), 2 attempts

 

Monday, November 29, 2021

 

Monday in the Auditorium, 9:30-10:00:

Quiz 7 (available in Blackboard.  You get one attempt, 30 minutes.  Covers videos, MyITLab Access Ch. 4)

 

COURSE EVALUATIONS.  Done online in class.

 

Review

 

Study review and suggestions for final exam.

Make sure your grade records are accurate in the MyGrades section of Blackboard.  No changes will be made after Friday, Dec. 3 at 5:00 p.m.

 

NO CLASS MONDAY

Wednesday, December 8, 8-9:50 a.m.

Auditorium

 

****FINAL EXAM Wednesday 12/8.

Sorry, no one can take the Final Exam early or late.

If you cannot make the date due to a valid, documented reason (NOT “I’m not ready” / “I need to study more”, etc.), you may take an incomplete in the class, and then take the Final Exam when you return to school next semester, at which point your grade will also be changed.

You must tell me prior to the Final Exam if you cannot make the date.  If you simply do not show up to the Final Exam, you will receive a “0” for the Final Exam.

If you have used the online course option due to COVID concerns, or have or have been exposed to COVID, you may take the exam online through Blackboard, but you MUST take it at the exact same time (8:00-9:50 a.m. with 90 minutes total).