Tech 3365
 Weekly Assignment Details 

Note that this site is still being updated so you should check back.

Wk 1 2 3 4 5 6 7
8 9 10 11 12 13 14 15

Homework Summary

Last revision: February 17, 2003     

 

Wk Date Topic Read and Study in Text Class Notes Prob.
Pg.		 Practice Problems Homework Problems Submit
    0.0 Using Excel            
 1

  

 1/14 0.1 Excel Basics Section 6.5 Getting Started

Standard Tool Bar

Format Tool Bar		             Note: Exams will cover the readings, the practice problems and the Homework problems.

  
   0.2 Formulas & Functions    Building Formulas

Functions		          
    1.0 Sets and Probability Sections 4.6-4.8                   
 2

  

 1/20  1.1 Sets Section 4.6  Ch. 4 Prob.
 Exp.		 127 1, 5, 6, 9abc,
11ace		 12 a c e Turn in H1 over course conventions by 8 AM on Wednesday

  

  
   1.2 Counting Procedures Section 4.7   134 1 9 11 13 19 8b 16b
3 1/27 1.3 Probability Section 4.8    144 1 3 5 7 8
    2.0  Basic Statistical Concepts Sections 7.1-7.5                
4

  

  

  

 2/03 2.1 Data Presentation Section 7.1  Ch. 7 Prob.
 Exp.

Charts with Excel

Pie w XL

 244 3a 5 4a,  10c    

   

   

   
   2.2 Averages Section 7.2 Analysis Tool Pak*

Des. Stat. - XL		 249 1 3 2a
   2.3 Dispersion Section 7.3 
A B D		    254 1 5b 2a, 6b
   2.4 Frequency Distributions Section 7.4 Histograms with XL*  259     4 - Use XL to construct a histogram
      3.0 Income Statement Analysis Sections 8.1-8.6               
5

  

 

  

 2/09 3.1 Income Statement Items Sections  8.1 &  8.2  Ch. 8 Prob.
 Exp.		 267 A (odds), 
B (odds), 25, 35		  26  

 

  

  
               270 A (odds), 11 23, 27 12, 24
  3.2 Discounts Sections 8.3 & 8.4    278 A (odds), B (odds), 13 12
              281 1 7  19, 23  20
    4.0 Interest and Discounts Sections 9.1-9.5               
6

   

 2/17 4.1 Interest Sections 9.1 & 9.2  Ch. 9 Prob.
 Exp.		 313

317

 A (odds) 11

A (odds), B (odds), 15

 

14

 Turn in H2 over Topics 1, 2 & 3 by 8 AM on Friday

 

 Test 1 Review
                   320 A (odds), 13, 15, 17, 21, 27 16, 28
7 2/24 4.2 Present Value         325 A (odds), 11, 17 12, 15 Test 1 will cover topics: 1, 2, 3, 4
It is on campus.
8 3/03   Study  for Exam 1                      Spring Break
      5.0 Bank Discount & Negotiable Instruments Section 10.1-10.5                   
 9

   

  3/10 5.1 Bank Discount and Negotiable Instruments Section 10.1  Ch. 10 Prob.
 Examples.		 352 A (odds), 11,17  12  

   
    5.2 Negotiable Instruments Section 10.2-10.5     358

362

  1, 3, 11, 13

 1,3, 5

  6

12
      6.0 Compound Interest Section 11.1-11.6, 11.7                    
 10

   

  

   

  

  

  		 3/17  6.1 Computing Compound Interest Section 11.1 & 11.2 Ch. 11 Prob.
 Examples.		 368 A (odds), 9 6  

   

   

   

  

  

    
           Section 11.3     371 A (odds), 13, 15 12
                 375 1, 3 8
    6.2 Present Value & Compound Discount Section 11.4     379 A (odds), 9, 11  10
                 383 A (odds), 9, 11 10
   6.3 Components Section 11.5 & 11.6     388 A (odds), 9, 11, 13  10, 12
               389 A (odds), 9, 11 4, 10
    7.0 Ordinary Annuities Section 13.1-13.7, 13.8                   

 
11

  

   

  

 3/24 7.1 Concept, Classification & Amount Section 13.1 & 13.2  Ch. 13 Prob.
 Exp.		 426 A (odds), 
9, 11		 12 Turn in H3 over Topics 4, 5 & 6 by 8 AM on Friday

  

    

   

  

  

  
   7.2 Present Value Section 13.3 & 13.4     429 A (odds) 8
                   432 A (odds), 
9, 11		 12
                   438 1, 3 4
12

  

  		 3/31 7.3 Periodic Payments & Interest Rates Section 13.5 & 13.6    440 A (odds), 9, 11 10
        Section 13.7    444 A (odds), 9 10
              447 A (odds), 9 10
    8.0 Extinction of Debts Section 15.1, 15.2, 15.4                  
 13

  

 4/07  8.1 Amortization Section 15.1 & 15.2 Ch. 15 Prob.
 Exp.		 509 A (odds), 7 8   

  
   8.2 Sinking Funds Section 15.4     516 A (odds), 7 7
      9.0 Matrices and Linear Programming Sections 5.1-5.6                   
 14

  

  

  

  		 4/14  9.1 Vectors, Matricides, & Determinants Sections 5.1, 5.2, 5.3  Ch. 5 Prob.
 Exp.		 153 A (odds), 
B (odds)		 9, 22, 30

You may use XL Functions to solve many of these.

Test 2 Review
 Exam 2 will emphasize  topics: 5, 6, 7, 8, & 9.
                 157 A (odds), 
B (odds)		 8, 12
   9.2 Inverse of a Square Matrix Section 5.4     162 1, 3, 7 4, 8 
   9.3 Solving Equations by Matrix Algebra Section 5.5     166 1, 3, 7 8
   9.4 Linear Programming Section 5.6     172 1, 3, 7    
15 4/21    Wrap up and review                 

Turn in H4 over Topics 7, 8 & 9 by 8 AM on Fri.

 

Tech 3365
 Homework Summary

The following is to assist you in knowing what to do for your homework assignments and what form to use.

  1. All problems are from your text, Mathematics for Management and Finance by Shao and Shao.
  2. All solutions should be sent in one Excel file. I only check one file. It is not necessary to zip the file.
  3. Do not put solutions in the body of the e-mail. They should all be in the attachment.
  4. The posted solutions provide a good guide for formatting your problems. Important - Show work.
  5. Name your file in accordance with the following policy. If it is not named properly, I will send it back to you to be renamed and this process may result in a late submission.

It is IMPORTANT to use the naming convention for this course to ensure you get credit for the assignment. I have two on-line classes and many assignments are being submitted. 

The convention is:
LASTNAME3365H#

Example: Ms. Smiths file for homework 1 would be:
Smith 3365 H1

6.    The subject of the e-mail should be the same as the file name:    Smith 3365 H1
        If it is not named properly, I will send it back to you to be renamed and this process may result in a late submission.
7.   Submit as a single attachment to: cgoodson@uh.edu

Remember- if you think you have found a mistake in the posted info or the text, let me know. If you're the first and it's validated, you get extra homework points.

Homework Assignment Schedule Summary

Date  Assignment  Page Number
Text (Shao)		 Problems
1/21 H1 over 
8 AM on Tuesday		      Course conventions 
2/21 H2 
8 AM on Friday		 127 
134 
144		 12 a c e
8b 16b
8
    244
249
254
259		 4a,  10c
2a
2, 6b 
4 - Use XL to construct a histogram
    267 
270 
278 
281		 26
12, 24 
12 
20
3/28 H3  
8 AM on Friday		 317 
320 
325 		 14 
16,  28 
12, 15 
    352 
358 
362 		 12 
6
12
    368 
371 
375 
379 
383 
388 
389 		 6 
12 
8 
10 
10 
10, 12
4, 10 
4/25   H4 
  8 AM on Friday		 426 
429 
432 
438 
440 
444 
447 		 12 
8 
12 
4 
10 
10 
10 
      509 
516 		 8 
7 
      153
157 
162 
166 		 9, 22,30 
8, 12
4
8  

 

 

 

Top of Page Home cgoodson@uh.edu

.Monday, February 17, 2003 11:43 PM

Hits: