Preparing Your Homework, SP16

Preparing your Homework

This webpage tells you everything you need to know about preparing the textbook homework that you will place in our Shared Dropbox Folder, and it includes information on the publisher’s free preexisting homework files.  If you have not yet prepared our Shared Dropbox Folder, click on DROPBOX INFORMATION at the top of this page and take care of that ASAP.  Then come back here.

As explained in the “Getting the Publisher’s Homework Files” page on this website, many of the homework assignments you must complete require you to use preexisting files that the publisher has prepared for you.  Although you can download these files from the publisher’s website, it’s easier to just get them from me using Dropbox.  AFTER you have established your Dropbox account and our shared Dropbox folder, click on the Getting Publisher’s Homework Files link at the top of this web page.  Once you have downloaded all the files, come back here.

Deadlines for Submitted Homework

This section applies to textbook homework that you submit via the online Dropbox system.  It is not related to Exams or to online training.

The due dates for your Dropbox homework submissions are listed in the Class Schedule.  You can put completed homework assignments in the shared Dropbox folder any time you want to, but I will be checking (and granting credit for on-time submissions) on or shortly after the due dates in the Class Schedule.  You’ll see that there are only two times that you submit using this system.

All required work must be submitted ON TIME.  “Late” means after the upload date/time limit but still uploaded within one week of the limit.  Late-submitted homework is worth only 50% of the on-time value.  Anything submitted after “late” is not eligible for credit.

Textbook Chapter Organization and What to Do

In your textbook, there are two “chapters” that precede the actual Excel chapters.  One is about Windows 8, and the other is about Office 365.  Then come the real Excel chapters.  Excel chapters are labeled like this:  Excel Chapter 1, Excel Chapter 2, etc.  The homework that you submit comes only from the real Excel chapters.

Every regular Excel chapter has the same sequence of sections.  You will only be submitting part of the work from some of the sections, as detailed in the Do This column in the table below.  Stated differently:  You will not be doing every section in every assigned chapter.

Every row in the table below that says you must submit something needs to have ONE AND ONLY ONE file included in your Dropbox shared folder.  Even if  textbook exercise seems to require that you create several products, submit ONLY the last, most advanced one.

The textbook often will often tell you to “print” a file.  Well, you won’t be printing it; you will just be saving it to your computer and including it in our shared Dropbox folder.  If you want to print it for your own edification, of course that would be fine.

When doing your assigned textbook homework, in most cases you will be creating some kind of product.  It might be a worksheet, a workbook, a graphic, or something else.  What you put into the Dropbox to prove that you did that exercise will be the product of a given homework exercise.  This is usually something the textbook directs you to print or save at the end of the exercise.

Sometimes the book may not direct you to “print,” so you’ll wonder what file to put into the Dropbox to represent that assignment.  Easy.  Save a file that shows that you did the work (usually the last version of the file you’re working on), label it using the scheme I’ll show you below, and you’ll be okay.

Sometimes the book may say something should be “… as specified by your instructor.”  With one exception, the only things I’m specifying are on this SachsAcademics website.  The exception is that I might put up an Etudes Announcement from time to time adjusting in some way what you need to do for homework.  To learn more about Etudes and its Announcements, see the Syllabus on this website.

“Consider This”

This section of this webpage will make much more sense when you have the textbook with you.  You might want to read through it a second time once you have the book in your hands.

Your textbook has two general types of pages.  Some are white; these are the “regular” textbook pages.  Some are yellow.  These are the Study Guide for the book.  Each individual chapter has its own “regular” (white) pages and Study Guide (yellow) pages.  Just to help you find the yellow ones, note that the Study Guide yellow pages also have a green, vertical rectangle near the top, outside edge of the page.

Throughout the textbook (including in some of the book’s homework instructions), you may see a special “Consider This” symbol, which looks like a green circle with a white asterisk (*) inside of it.  These are very meaningful devices that help you think about the software and some of its applications and nuances.  Of course, when working in the main body (white pages) of the book, although you definitely should consider these “Consider This” sections, you will not be submitting anything to me related to them.

In the assigned homework from the Study Guide (yellow pages), though, it’s different.  There are two different “Consider This” types in these yellow pages.  First:  Each chapter has a main “Consider This:  Your Turn” section near the end of the yellow pages.  You will see how to deal with these entire sections in the Table below.  Second:  But wait, there’s more!  You can earn extra credit by creating a document file (I prefer it in Microsoft Word) with your answers to the small “Consider This” instructions that you encounter in the yellow pages’ assigned homework over the course of the semester.  To submit these answers for extra credit, attach your document file to a PM addressed to me in Etudes ONLY during the week that precedes the Final Exam.  Identify each one with its Chapter Number, Exercise Title, and Step Number.  An example would be:  “Chapter 2, Apply Your Knowledge, Cost of Analysis Worksheet, Instruction 9.”  Take a look at that one (it appears on page EX 120) and it should be obvious what I mean here.  NB:  I have only had two students do this in the past.  Both earned the credit.  Maybe you’ll want to make a note about this Extra Credit opportunity now.

The Individual Textbook Sections

Here is a list, in order, of each section that appears in every chapter and what to do with each one.  Read the stuff BELOW THE TABLE to learn how to name the files you submit.  You must name them correctly, or you will lose credit.

Chapter Section Do This
Main body of the chapter (white pages) Read and do absolutely everything, in the order that it appears in the chapter.  Don’t skip anything, even if you feel you know all the subject matter. And don’t do the stuff out of order.The white pages of the chapter will have you work on documents, and it will even suggest that you print and/or turn them in to me.  Don’t turn them in.  They do NOT belong in the Shared Dropbox Folder. Do all of the white page work.  Although you will NOT be submitting to me anything from the main body (white pages) of the chapter, it is critical that you do all of it without skipping anything.  This is a major part of our educational process.
The rows below are for sections in the Student Assignments part at the end of each chapter (What I’m calling the Study Guide: the yellow pages).  When I say, “include,” “do,” or “submit,” I mean include them in our Shared Dropbox Folder.  See instructions below on how to label each file.
Apply Your Knowledge Do and submit it all.  This is the easiest part of the textbook homework.  Ensure that you include whatever the product will be.
Extend Your Knowledge DO NOT submit this part.  It is a very good part of the chapter, and you should do it when you have time.  It would make a good review section to do before any exam that includes this chapter.
Analyze, Correct, Improve Do and submit it all.  Ensure that you include whatever the product will be.
In the Labs Do and submit Lab 2 ONLY.  This section requires more brain work than the earlier sections.  Ensure that you include whatever the product will be.
Consider This:  Your Turn Do and submit the first section (identified by a blue title).  Ensure that you include whatever the product will be.  Do (but do not include in Dropbox) Cases 2 and 3 only if you have extra time to invest in your Excel knowledge to get closer to expert level.
Learn Online Student Companion Site:  Do it all, but don’t submit any of it.  This is an EXCELLENT way to help learn the material!SAM:  Follow the instructions in the Syllabus and in the Your SAM Account section of this website.  (All your work in SAM is submitted to me automatically.)  IMPORTANT:  Note that parts of the Learn Online may have been disabled by the publisher, so don’t get too flustered if you try to get something that has been pulled.  At least you’re not submitting any of this.


Apply Your Knowledge (everything in that section); then

Analyze, Correct, Improve (everything in that section); then

In the Labs (#2 only); then

Consider This: Your Turn (first section only).


How to Name the Files that You will Put into Your Shared Dropbox Folder

Do NOT follow the file naming instructions in the textbook on how to name the files.  Use these instructions instead:  Name each section EXACTLY as described below, with NO EXCEPTIONS.    If you make a mistake in naming the files, you will earn no more than half credit, and sometimes zero credit, for the entire Dropbox submission.  Ensure that there is one and only one space between each name element.  Notice that there are NO COMMAS, including no comma between your last name and your first name.  (The file extension [the stuff after the “dot” or “period,” such as .xlsx for Excel or .docx for Word] will be put on the file automatically by the software, so don’t add that yourself.)

Each file should be named like this:

Lname Fname CAOTclassnumber Chapternumber Exercisetype

Lname means your last name; Fname means your first name; CAOTclassnumber is the class you’re taking (example:  If you’re taking CAOT 85, then it is 85); Chapternumber is just the chapter number as an Arabic numeral; and Exercisetype requires that you use the following abbreviations EXACTLY:

APPLY for Apply Your Knowledge;

ANALYZE for Analyze, Correct, Improve;

LAB for In the Labs, Lab 2 (Did you notice?  There’s no “2” in the name);

CONSIDER for Consider This: Your Turn, first one.

Please don’t make up your own abbreviations.  If you make up your own abbreviations, you WILL LOSE CREDIT.


If you are in CAOT 085, your name is Lisa Munchausen, and you are submitting Chapter 2’s Analyze, Correct, Improve, then the NAME OF THE FILE in the shared Dropbox folder must be:

Munchausen Lisa 85 2 ANALYZE.

Did you notice that there’s no “0” before the 85?  And there’s no “CAOT?”


If you are in CAOT 85, your name is Esticle Prunehowe, and you are submitting Chapter 3’s Lab 2, then the NAME OF THE FILE in the shared Dropbox folder must be:

Prunehowe Esticle 85 3 LAB.

Did you notice that there’s no “2?”


Oh, Please Don’t Put in Extra Stuff

The ONLY things that are permitted in the shared Dropbox folder are the Apply, Analyze, Lab (2), and Consider (first section) files for assigned chapters.

Although there is an infinite number of things that must not be included in our Dropbox shared folder, here are some things that people have included in the past that must NOT be included.  Students who put these things in LOST CREDIT because they included them:

  • Any non-assigned homework files, whether completed or partially completed
  • Other Labs (like Lab 3)
  • Cute cover pages
  • Other Considers (like the second or third one)
  • Any folders (the Dropbox should have only the individual Apply, Right, Lab, and Case files and NOTHING ELSE).  The Shared Dropbox needs to have FILES in it, but no separate FOLDERS.
  • Do NOT include your untouched, downloaded publisher’s homework-file-containing folders.  Keep them somewhere else on your computer, please.
  • Although you can put stuff into your Shared Dropbox Folder any time you complete it, the only two times that it matters are the two submission deadline dates (see the Class Schedule).  After the first submission deadline has passed and after you see your credit (I’ll publish it in Etudes), CLEAR OUT EVERYTHING in the Shared Dropbox Folder.  The second time I check it, it must have ONLY stuff due after the first submission date.
  • You will not be able to earn full credit if you include anything extra in the shared Dropbox folder.  It’s really not hard to get full credit if you follow the instructions.

rev 12152015|1349