Wednesday, April 2, 2014

Lab 1 tips

1.       Due - 10 AM Friday a week after the class, for both sections.

Excel:

2.       Named Variables - don't use spaces. Good practice -- capitalize 1st letter of a word, e.g. MyFirstName. If you need to eliminate an unwanted named variable use Ctrl-F3 shortcut.
3.       Troubles with Excel -- please refer to Excel help and tutorials; it is the best and most effective solution. You can also try the IRT MS Office on-line training.
4.       Remember, Excel is a computational software; it is designed to do computations for you.
5.       Excel allows leaving comments in cells - you can use this feature when you feel a comment may add clarification.
6.       Consult the Post-It-like notes and Instructions attached to question pages for grade tips.

Units and sig figs:

7.       Conversion factors column does not need formulas; it needs conversion factors which are constants. No real rule for conversion factors sig figs.
8.       Units spelling -- refer to literature e.g. , NIST Handbook 44 - 2013 Edition, Appendix C -General Tables of Units of Measurement  OR NIST Special Publication 330, 2008 Edition. International System of Units (SI). Both are by National Institute of Standards and Technology, Washington, DC.
9.       Note:: Some questions have non-conforming unit notations, it is alright to correct them when Excel allows to.
10.   In Question 5 --  BTU/CF-DegF means Btu/ft³∙°F (and similar to it cells).

Memo:

11.   Writing Memo -- consult Prof. Mitchell's blog entry and the links he refers to.
12.   Memo subject -- "Meaningful phrase that announces the topic".
13.   Memos should have a professional tone. Limitations of the lab are not your own personal limitations or struggles but rather specific caveats related to assumptions you had to make in order to complete your calculations (ex: did you actually measure your shoulder width with a ruler?) See the earlier entry on the course blog for additional suggestions.

Misc.:
14.   If you do not have a laptop, please look at the lab prior to class time and come to the class session to ask your questions.
15. If your computer does not have MS Office -- it appears that it is OK to do it in OpenOffice (save as .xls or .xlsx file), or maybe use CADLab machines.

No comments:

Post a Comment