CIS 101 - Introduction to Computer Information Systems -  
Online Class
Example lab submission format

Example of On Online Excel lab submission.

There are two method for preparing a lab for submission for an online section.  Review the attached files to see an example submission.

The example for this submission.  You will be asked to prepare a simple spreadsheet, next add a graph, next display the formulas, and finally set a print area.  There are 4 components to be submitted.

Method 1

• In this method you will create 1 file containing a separate worksheet for each part of the lab submission.  It will have 4 worksheets..  For each component of the lab you copy and paste the previous component on to another worksheet in the file, then do the modification requested.  So there would be a 4 worksheet file.
• For example: Labs/Case 1-2 Quarterly Personal Budget.xls

Method 2

• Prepare a new file for eachcomponent for this lab as it is being developed.
• For example you were asked to create a lab with 4 components.
• Prepare a simple spreadsheet, same the file and place a 1 at the end of the file name. For example: Labs/Case 1-2 Quarterly Personal Budget1.xls
• Next you are asked to change the spreadsheet and add a graph.  Save this version and place a 2 at the end of the file name.  For example: Labs/Case 1-2 Quarterly Personal Budget2.xls
• Next you were asked to display the formula version of the revised spreadsheet.  Save this version and place a 3 at the end of the file name.  For example: Labs/Case 1-2 Quarterly Personal Budget3.xls
• Last you were asked to set a print area.  Save this version and place a 4 at the end of the file name.  To check that a print area has been set you would Click File, Print and then the print preview button and only the print area would display.  For example: Labs/Case 1-2 Quarterly Personal Budget4.xls

Creating a ZIP file to simplify your submission process.  (optional)

• Alternately you can create 1 or more file for any lab and then zip all the files into on file with a .zip extension.  Then you will only upload the zipped file.  I will unzip the file and evaluate all the component files/worksheets.

(C101_onlineExcel_Lab.htm)
 last update:  06/02/2006