CS 150L - Computing for Business Students Computer Science Department University of New Mexico Fall 2007

Instructor:
Joel Castellanos
Department of Computer Science
e-mail: joel@unm.edu
phone: 505-277-7146

Office: Farris Engineering Center (FEC) 321
     Building #119 in section I-2 of the campus map.

Office hours (Spring 2008):
     Monday & Wednesday: 11:00-noon,
     Tuesday: 8:00 - 9:15 AM and by appointment.

Course Description and Syllabus (pdf)

Lab section schedule, with lab instructor names and e-mail addresses (pdf)

Anderson School of Management: links and deadlines:

• Deadline to be admitted to Anderson for the Fall Semester: June 1
• Deadline to be admitted to Anderson for the Spring Semester: October 1
• Deadline to be admitted to Anderson for the Summer Semester, March 1
• Anderson's home page
• Anderson admissions info
• Anderson BBA program site - which has links to Concentrations
• MANAGEMENT INFORMATION SYSTEMS flyer

Lab Assignments:

• Lab 1: UNM NetID, e-mail, WebCT, Windows XP, Internet Search Engines, and Copy/Paste Power


• Lab 2: Microsoft Word: Auto Correct, Find and Replace, Character, Paragraph, Column, and Section Formatting, Line Spacing, Tabs, Indents, Borders, Shading, Page Setup.


• Lab 3: Blogging


• Lab 4: Microsoft Word: Clip Art, Picture Toolbar, Drawing Toolbar, WordArt, Footnotes, Endnotes, Hyperlinks, Wizards, Templates, Bulleted Lists, Numbered Lists, Multilevel Lists, Tables, Styles, Paragraph and Section Formatting, Header, Footer, Page Numbers, and Table of Contents.


• Lab 5: Microsoft Excel: Row and Columns, Constants, Formula, Functions, Workbooks, Worksheets, Relative and Absolute References, Copy/Paste of Cell Formulas, Borders, Shading, Fonts and Alignment.


• Lab 6: Microsoft Excel: Hyperlinks, Import data from Web Query, Today() function, and Currency Conversion Application, EOMONTH() function, Date Arithmetic, Percent and Balance Calculation.


• Lab 7: Microsoft Excel: Chart Wizard, Bar Charts, Column Charts, 3-D Clustered Column Chart, Pie Charts, Chart Format Customization, Chart Data Customization.


• Lab 8: Microsoft Excel: Annual Percentage Rate (APR), Loan Amortizations, and the PMT( ) function.


• Lab 9: Microsoft Excel: Calculating Future Value of an Annuity and Retirement Income.


• Lab 10: Microsoft Excel: More on Calculating Future Value of an Annuity, Named Cells, Conditional Equations, and Conditional Formatting.

Lab 11: Microsoft Excel: Financial Forecast, Custom Styles, Text Import Wizard, and Auto Filter
• Employee List-A:
• Employee List-B:
• Employee List-C:
• Employee List-D:
• Employee List-E:
• Employee List-F:
• Employee List-G:
• Employee List-H:
• Employee List-I:
• Employee List-J:
• Employee List-K:
• Employee List-L:
• Employee List-M:
• Employee List-N:
• Employee List-O:
• Employee List-P:
• Employee List-Q:
• Employee List-R:
• Employee List-S:
• Employee List-T:
• Employee List-U:
• Employee List-V:
• Employee List-W:
• Employee List-X:
• Employee List-Y:
• Employee List-Z:
Lab 12: Microsoft PowerPoint: Presentation to a Venture Capitalist

Sample Exams:

1. Spring 2008 Microsoft Word Exam with discussion of solutions and common problems.
2. Spring 2008 Microsoft Excel Midterm Exam with discussion of solutions and common problems.
3. Spring 2008 Microsoft Excel Final Exam. A solution with comments is given here: solution