Skip to main content

Scott Warden

Section 7D1

Welcome to the website for CS101 Section 7D1. This is an online course section.

You should plan to check your MIX e-mail account and visit this webpage daily to remain up-to-date on important information in the course.

New to the course?

Get started with Computer Science 101 by visiting the Start Here page. Learn out about your instructor on the Instructor Welcome & Contact Information page.


Excel Exam Review Sessions

There will be two review sessions given for the Excel exam, if anyone is interested in attending.  Here are the times and locations:

Exam #1 Coming Soon!

On Tuesday/Wednesday 9/26-27/2017, our first exam will be given.  I will email exam instructions to your proctor, for those that are using that option for taking exams.  For you, the exam can be taken anytime between 8AM Tuesday and 10PM Wednesday (needs to be finished and submitted by 11PM).  I'll let you all know in another Announcement after I've sent the email to the proctors, as it's very important to ensure they received it.  This will most likely occur Monday evening, 9/25/2017.

For those taking the exam in the Open Lab (Armstrong Hall 219), the instructor when you go will have the instructions for you.  Please see the Open Lab schedule linked on this page under "Help" for times when you can take it. Please be sure to bring a photo ID with you to the exam - either your WVU ID or driver's license.  It's not necessary to let me know what time you plan to go there.

For everyone, you will get 50 minutes to work on the exam.  Note this time period includes any break you may take.  Think of it as being in a normal classroom where there is no extra time given beyond the end of class.  Every semester there are cases where someone takes too long on an exam (someone using an off campus proctor).  Please be aware this is very easy to detect and you will be penalized points (best case) and possibly lose all credit for the exam (worst case for a first offense).
As you'll find, exams are very similar to HW assignments - you'll be given a set of instructions to follow, probably some data to import and will create a finished project to submit (on our course website, just as you submit HW files).  Exams are closed book, closed notes, etc.  The only help you can use is the Help function within the application at hand (Excel in this case).

One commonly missed fundamental part of Excel is using different cell reference types.  Please be sure you review the different type (relative, absolute, mixed) before the exam.  Here is a brief refresher:

This is a relative reference: C5
This is an absolute reference: $C$5
This is a column absolute mixed (note $ in front of only the column letter): $C5
This is a row absolute mixed (note the $ in front of only the row number): C$5

Just remember that "absolute" means "$". That "$" tells that column letter or row number "stay put and don't shift around if I copy you to other cells".

Finally, for anyone who still hasn't taken the Exam Proctors & Policy Acknowledgement Survey, you can do so from this link.  Failure to complete this survey will force you to (1) only take exams on campus and (2) have a hold remaining on your account, which means you can't view your grades and will receive a failing grade for the semester.

If you have any questions about the exam, please let me know.

Assignment Availability

Assignments in this class will be configured well ahead of time to give you plenty of time to work on them.  I encourage working ahead!

Grade Availability

You can expect to look for your grades according to these guidelines: