bai ktra excel

http://www.mediafire.com/download/g5z47wy4xb71gvu/BaiTapExcel-1.pdf

Database Course for MAR

Link to download slides hand out: http://www.mediafire.com/download/0ojvz4y69f72tqz/Database.zip

http://www.mediafire.com/download/gays7h2ja9xh4kd/Slide.7z

Other links to read:
 

1. http://www.cs.umb.edu/cs630/hd1.pdf

2. http://www.iai.uni-bonn.de/III/lehre/vorlesungen/TemporalIS/SS14/

3. http://www.iai.uni-bonn.de/III/lehre/vorlesungen/TemporalIS/SS14/

4. http://www.tutorialspoint.com/sql/sql-syntax.htm

Bài Thực hành Tin học Ứng dụng cho Edu

Link download: http://www.mediafire.com/download/4gh6t96igyoea7i/Bai+tap+W_E.pdf

Bài tập thực hành Tin học Đại cương

Link to download:
www.mediafire.com/download/700etn3wca75p16/Bai+TH+THDC.pdf

Lecture Note for General Informatics

This is link to download file ZIP. Pls unzip to get the slide hand out.
http://www.mediafire.com/download/dgo603zrv7zpx6k/THDC_CLC.zip

CSDL

Link download:
http://www.mediafire.com/?l3p6ib8928b437d
Chương về SQL:
http://www.mediafire.com/view/?qzrs5uica1cuel1
 

Exercise for labs _MAR6

Here is link: http://www.mediafire.com/download/4bgrj3qcbl3lrl1/excel-pivot-tables_for+IS.zip

Master - Chapter 2: Skill building exercises

PV and FV

Skill-Building Problems.

1. A single cash flow of $1,673.48 will be received in 4 periods. For this cash flow, the appropriate

discount rate / period is 7.8%. What is the present value of this single cash flow?

2. A single cash flow of $932.47 is available now (in period 0). For this cash flow, the appropriate

discount rate / period is 3.9%. What is the period 4 future value of this single cash flow?

Annuity

Skill-Building Problems.

1. An annuity pays $142.38 each period for 6 periods. For these cash flows, the appropriate discount

rate / period is 4.5%. What is the present value of this annuity?

2. An annuity pays $63.92 each period for 4 periods. For these cash flows, the appropriate discount

rate / period is 9.1%. What is the period 5 future value of this annuity?

Net Present Value

Skill-Building Problems.

1. A project requires a current investment of $189.32 and yields future expected cash flows of

$45.19, $73.11, $98,54, $72.83, and $58.21 in periods 1 through 5, respectively. All figures are in

thousands of dollars. For these expected cash flows, the appropriate discount rate is 6.3%. What

is the net present value of this project?

2. A project requires a current investment of $54.39 and yields future expected cash flows of

$19.27, $27.33, $34.94, $41.76, and $32.49 in periods 1 through 5, respectively. All figures are in

thousands of dollars. For these expected cash flows, the appropriate discount rate starts at 6.4% in

period 1 and declines to 5.4% in period 5. What is the net present value of this project?

Skill-Building Problems.

1. A project requires a current investment of $117.39 and yields future expected cash flows of

$38.31, $48.53, $72.80, $96.31, and $52.18 in periods 1 through 5, respectively. All figures are in

thousands of dollars. The inflation rate is 2.7%. For these expected cash flows, the appropriate

Real Discount Rate is 8.6%. What is the net present value of this project?

2. A project requires a current investment of $328.47 and yields future expected cash flows of

$87.39, $134.97, $153.28, $174.99, and $86.41 in periods 1 through 5, respectively. All figures

are in thousands of dollars. The forecasted inflation rate starts at 3.4% in period 1 and increases to

4.7% in period 5. For these expected cash flows, the appropriate REAL discount rate starts at

7.8% in period 1 and decreases to 5.4% in period 5. What is the net present value of this project?

PMT and sensitivity EX

Skill-Building Problems.

1. To purchase a house, you take out a 30 year mortgage. The present value (loan amount) of the

mortgage is $217,832. The mortgage charges an interest rate / year of 9.27%. What is the annual

payment required by this mortgage? How much of each year's payment goes to paying interest

and how much reducing the principal balance?

2. In purchasing a house, you need to obtain a mortgage with a present value (loan amount) of

$175,000. You have a choice of: (A) a 30 year mortgage at an interest rate / year of 9.74% or (B)

a 15 year mortgage at an interest rate / year of 9.46%. What is the annual payment required by the

two alternative mortgages? How much of each year's payment goes to paying interest and how

much reducing the principal balance by the two alternative mortgages? Which mortgage would

you prefer?

3. Consider a 30 year mortgage for $442,264 as in the previous section. What would happen if the

interest rate / year dropped from 9.21% to 7.95%. How much of each year's payment goes to

paying interest vs. how much goes to reducing the principal under the two interest rates?

Evaluation Project

1.      Consider about investment project evaluation for the initial investment of $100.000 and the cash flow of $25.000 in each year in 5 years. The discount rate is 9%, and the require period of payback is 4 years. Use NPV, IRR, PBP and PI.

2.      Note the following information on the annual cash flows of two mutually exclusive projects under consideration by Wang Food Markets, Inc.
Year A B
0 $230,000 $260,000
1 10,000 20,000
2 10,000 20,000
3 10,000 20,000
4 10,000 20,000
5 10,000 20,000
Wang requires a 14 percent rate of return on projects of this nature.
a. Compute the NPV of both projects.
b. Compute the internal rate of return on both projects.
c. Compute the profitability index of both projects.
d. Compute the payback period on both projects.
e. Which of the two projects, if either, should Wang accept? Why?

Master topic discussion

Link to download: http://www.mediafire.com/download/72d4khmlfdf9kl3/TOPICS+for+DISCUSSIONs.zip
This is files including theories and exercises for each group.

PTTKHT slides

Link to download: http://www.mediafire.com/download/87bkdu39b4lh5qy/lecture_PTTKHTSlides_In1.pdf

BT SQL server 2005

Retrieve the required information using SQL language.

Part I. Give a database schema for a library management system as the following picture.

1. How many copies of the book titled The Lost Tribe are owned by the library branch whose name is "Sharpstown"?
2. How many copies of the book titled The Lost Tribe are owned by each library branch?
3. Retrieve the names of all borrowers who do not have any books checked out .
4. For each book that is loaned out from the "Sharpstown" branch and whose DueDate is today, retrieve the book title, the borrower's name, and the borrower's address.
5. For each library branch, retrieve the branch name and the total number of books loaned out from that branch.
6. Retrieve the names, addresses, and number of books checked out for all borrowers who have more than five books checked out.
7. For each book authored (or co-authored) by "Stephen King", retrieve the title and the number of copies owned by the library branch whose name is "Central"

Part II Give a database schema of a company as the following picture.

 

 

8. Retrieve the names of employees in department 5 who work more than 10 hours per week on the 'ProductX' project.
9. For each project, list the project name and the total hours per week (by all employees) spent on that project.
10. Retrieve the names of employees who work on every project.
11. Retrieve the names of employees who do not work on any project.
12. Find the names and addresses of employees who work on at least one project located in Houston but whose department has no location in Houston.
13. List the last names of department managers who have no dependents.
14. Find details of those employees whose salary is > the average salary for all employees. Output salary in descending order.
15. Find details of those employees whose salary is > the average salary for all employees in his/her department. Output salary in ascending order.