striped line
Department of Civil Engineering
CIVL 1101 - Excel Homework Format
set cell vertical height

Requirements

There are three minimum requirements for each Excel homework assignment. First, a copy of the original homework assignment, printed from the assignment web page, must be included and placed at the beginning of the submission. Second, a printout of each spreadsheet in the assignment, including student information, must be submitted. Third, each student must upload their spreadsheet to the correct dropbox on our Canvas site (click here for details on submiting your spreadsheet electronically). The printouts and copies of the assignment must be stapled together and placed in the assignment box during the first ten minutes of class. The spreadsheet must be uploaded to eCourseware by 1:00 p.m. of the due date. Late assignments will not be graded.

You must use the following file name format to identify your spreadsheets: assignment number followed by your last name. For example, if Pat Smith is submitting a spreadsheet for Assignment 2, the file should have the name

                assignment_02_smith.xlsx

Groups

Unless stated otherwise, homework assignments can be done in groups of any size. Indeed, you are strongly encouraged to work in small groups. Two or three people in a group is an excellent size; each person has an opportunity to contribute and learn. A group of 38 (the current CIVL 1101 enrollment) is a bit of a stretch.

While you may work in groups, each person must complete the spreadsheet exercises and submit the assigned problems to eCourseware.

Format

Your name, course information, and assignment number must be printed by the computer, not by hand, at the top left corner of your assignment. This greatly reduces errors during the grade recording process.

No grade will be given for handwritten names on assignments. This prevents unprepared students from pressuring their friends to add their names to a previously completed assignment.

If your assignment is more than one page long, the pages must be stapled to prevent losing anything. Do not use paper clips; they snag on other people's assignments. 


Cell Formats and Alignment

Most of our assignments will require specific cell formats (e.g., thousands of commas with no decimal point) and alignments (e.g., left justified). Each of the major spreadsheet products allows you to alter these important cosmetic characteristics of your output. Cell formatting is easy to do with Excel. Simply highlight the cells you want to re-format, choose the Format pull-down menu, select Cells, and then choose your desired format (e.g., #,##0). You can also handle some of this formatting with the button bar. (Beware of Excel's Comma button. It adds a couple of blanks to the right of your number. This often fouls up your desired alignment.)

You can use this same approach to change the way dates are displayed. Simply highlight the cells you want to re-format, choose the Format pull-down menu, select Cells, and then choose the Date category within the Number group. Either pick one of the existing format codes or make up your own. For instance, the code mmmm d, yyyy will display the full month and the four-digit year. If you change the four m's to three m's, you will get the three-character abbreviation for the month. If you change it to two m's, you will get the month number (1 to 12). If you change the four y's to two y's, you will not get the century portion of the year.

One glaring indicator of a novice user is misaligned columns. Most spreadsheet products use default cell alignments of left-justified character values and right-justified numeric values. This is fine unless you have a column of numbers with a character column title. The resulting jagged alignment always looks bad. With Excel, you can modify the alignment of a range of cells by simply highlighting them and clicking the appropriate Left, Center, or Right justification button.

Column Widths

Each column has a default width of about ten characters. This is probably wide enough for most of your work. Occasionally, however, you will need to adjust the width of a column to see a cell's entire contents. This is easily done by clicking (and holding) the vertical line separating two column headings. For instance, click the vertical line between the C and D headings if you want to adjust the width of column C. Now, while continuing to hold down the mouse button, you can drag the column to any desired width.

No credit will be given if your column widths are not wide enough to view a cell's contents.

Page Layout

Previewing your output before printing can save time and money. To do this, select the File pull-down menu and then the Print Preview option.

The Page Setup option allows you to adjust the page scaling (e.g., 80%) and change the page orientation from Portrait (8.5 by 11 inches) to Landscape (11 by 8.5 inches). It also allows you to define page labels (e.g., your name, the time, and date), centering, margins, etc.

Late Assignments

All assignments are collected at the beginning of class. Place them in the collection box as you enter the classroom. Do not drop off an assignment at the professor's office, and do not turn in an assignment via e-mail.

To be fair to all class members, no late assignments are accepted without a university-approved excuse. Notification must occur within 24 hours.

Grading

Be careful. Reread the instructions before you turn in your assignment. Points will be deducted for everything you fail to do. Common mistakes are failing to align columns, display numeric values in the specified format, adjust columns to an appropriate width, and list group member names in alphabetic order.

If you have questions about the grading of a homework assignment, immediately direct them to Dr. Camp.


This website was originally developed by Charles Camp for CIVL 1101.
This site is Maintained by the Department of Civil Engineering at the University of Memphis.
Your comments and questions are welcomed.

striped line
Department of Civil Engineering| 104 Engineering Science Bldg. |Memphis, TN 38152 | Phone: 901/678-2746 | Last updated: 08/06/2024