Skip to main content

Homework #1 Available

Friday, August 24, 2018

Homework #1 is now available under the Assignments link.

One thing unique to this assignment is that you're given a sample PDF file of what your solution should look like.  This is just to make sure you're on the right track as you get used to how these assignments are designed.  Always be sure to right-click and save each HW file provided, instead of just opening them.

As you'll find, all HW assignments and exams are just like this - you're given a file with a set of instructions to follow, usually some data to import to start out with and you follow these instructions to end up with a completed project file (or files, later on).  Once you're done, submit your file via the Assignment Submission Tool on our site.

Some assignments have a lot of individual but easy directions.. "format this like this", "set this size equal to that", etc..  I always advise printing it out and just checking off what you've done to be sure you don't miss any minor details that may cost you points.  Also, always work top to bottom.  You'll find that one step may be dependent on a previous step done properly.

As I said, every HW assignment and exam in our course will require you to import some data from an XML file when you begin the assignment.  In the case of HW #1, you start by importing data from the "registrations.XML" file you download (inside the ZIP file you download).  Just to be clear on how to properly import this data, here are instructions on how to do so:

1.  Right-click the "Data" link on the HW1 webpage and save it to your hard-drive.
2.  Using something like Winzip, extract the XML file that is inside of that zip file you downloaded ("registrations.xml").  Familiarizing yourself with a file extraction tool like WinZip is a skill needed to be successful in this class.  It can be found as a free download and is easy to use, just do a quick Google search if you need to.  Hopefully most people are familiar with ZIP files already.  Newer versions of Windows have the ability to extract zip files already built in.
3.  This step may vary depending on your Excel version:  Within a blank Excel workbook, you should then be able to go to "Data" (at the top), "From Other Sources" and choose XML.. browse to the registrations.xml file.

This will communicate with that XML file and will import all of the data into the spreadsheet.