CS 149 - Waiver Exam for CS-150 Department of Computer Science University of New Mexico Fall 2008

Exam Description

Register for CS 149 through LoboWeb as you would for a regular class.

The exams are offered 3 times per year: During the week before the start of the fall semester, during the week before the start of the spring semester, and between the spring semester and summer session. The exam offered just before the start of the fall term is listed in LoboWeb and the Schedule of classes (http://schedule.unm.edu/) along with the regular fall term classes and registration. Likewise, the other two times the exam is offered are each listed along with that semester’s courses.

Special Time Offering:
During the fall 2008 semester, the CS-149 exam will also be offered on Monday, Sept 22 from 8:00 AM- 10:50 AM. Register through LoboWeb: CRN: 33557.

CS-149 and CS-150 have the prerequisite requirement of Math 120 (Intermediate Algebra). Higher math classes such as Math 120, Math 180 and classes from other universities can also be used to fulfill the prerequisite requirement. If you have fulfilled this prerequisite requirement and for some reason LoboWeb does not recognize this, then send e-mail explaining the situation to Lynne Jacobsen (csinfo@cs.unm.edu), the CS department Coordinator of Program Advisement. The subject line of the e-mail should be: CS-149 registration error.

CS-149 has no requirements except to pass the practical exam. A student who passes this exam will have demonstrated mastery of the topics covered in CS-150L (Computing for Business Students) at a level sufficient to meet a CS-150L prerequisite requirement for any class. The exam takes place in a computer lab and includes the use of a word processor, spreadsheet, and the Internet.

CS-149 is offered on a Credit(CR) / No Credit(NC) basis only. An exam score of 80% or better is required for a grade of CR.

Note: Passing the CS-149 exam DOES NOT grant the three credits for having taken CS-150L! Passing the CS-149 exam will, however, fulfill the CS-150L prerequisite for admission to the Anderson School of Management and any other CS-150 prerequisite requirement.

The CS-149 practical exam is a two-and-a-half hour exam that combines the material tested on the three, 50 minute CS-150 exams. Sample exams are given below.

A student who is comfortable with the practical skills tested in the the CS-150 exams posted below should do fine on the CS-149 exam.

A student who has trouble with parts of the exams below can prepare by self-study of last semester’s textbook and labs.

A student who is having trouble with the self-study should take CS-150.

Prerequisite Mathematics Skills for Success in CS-149/CS-150 (pdf)

Sample Exam:

The CS-149 exam will consist of three parts - each corresponding to each of the exams below. Each of the parts will be worth equal weight and cover of the following topics:

• Part 1: Using Microsoft Word to format fonts, paragraphs, nested lists, tables, special characters, headers, and footers. A discussion of common problems that students have with part 1 is included at the end of the exam.


• Part 2: Using Microsoft Excel to format cells, and tables, create and format a chart, and write equations calculating averages and weighted averages that can be filled across or down. A discussion of common problems that students have with part 2 is included at the end of the exam.


• Part 3: Using Microsoft Excel to create both an Annuity Contribution worksheet and a Financial Forecast worksheet. A solution for part 3 with comments is given here: solution

Course Description and Syllabus of CS-150

Lab Assignments from CS-150:

• 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