Instructions for Assignment and Paper for Virtual University Students 2011-2012

[Xpert]

View more random threads:

• Midterm paper ended fall 2010
• eng101 midterm paper with mcq's fall 2010 december 4
• FIN623 Taxation Management final term paper solve 2012
• CS101 Introduction to Computing Solve Final Term Papers...
• CLIPS Win software for final term exam for CS607
• Pak301 Pakistan Study Solved paper Fall Semester 23rd...
• MGT401 Financial Accounting II Spring 2014 Current and Past...
• MGT603 Strategic Management Current Midterm Paper spring...
• CS101 Introduction to Computing Solve Paper December...
• CS601 Data Communication final term current paper fall...

You can use Ms excel or Ms Word to solve any question in the assignment or paper. But you have to remember some basic points:


1. Show the complete process to solve the question; otherwise you will not get full marks.
2. If you write only the answer without any process, the question will not be taken as solved properly.
3. If you solve the question on Ms Excel then paste the data on Ms Word after solving the question (Do not take screen shot of whole screen and paste it in exam software). You should also mention the formula separately which you have used to solve the question. If you not mention the formula at least half the marks will be deducted.

e.g.

Question: Marks 05

Calculate the accumulated value if you deposit Rs. 500 at the end of each year for the next 3 years? Assume an interest of 8% compounded annually.

Solution 1:

Rs. 1623.125

Answer correct but no process shown so the marks will be .
Marks 01



Sponsored Links

Solution 2:
Rate of interest =
Number of periods = n = 3

Payment per period = Amount of Annuity = R = 500 Rs.

Accumulated Value =

Answer correct and process shown, full marks will be awarded. Marks 05

Solution 3:

By using Ms Excel


Rate of interest 8%
Number of period 3
Amount of annuity 500


Future value ($1,623.20)



Answer is correct but formula not mentioned so
Marks 01
Solution 4:



Rate of interest 8%
Number of period 3
Amount of annuity 500


Future value ($1,623.20)

=FV(E13,E14,E15,0,0)
Or
=FV(8%, 3, 500, 0, 0)





Answer is correct and formula also mentioned so
Marks 05
Example : 2

Similarly for questions like in the assignment You can solve the question on Ms Excel and mention the formula used and then paste on Ms Word.

MOVING AVERAGES
Period Data Moving Average
Day 1 Morning 170
Afternoon 140 180 =AVERAGE(F140:F142)
Evening 230 182 =AVERAGE(F141:F143)
Day 2 Morning 176 186 =AVERAGE(F142:F144)
Afternoon 152 187 =AVERAGE(F143:F145)
Evening 233 189 =AVERAGE(F144:F146)
Day 3 Morning 182 192 =AVERAGE(F145:F147)
Afternoon 161 195 =AVERAGE(F146:F148)
Evening 242



ACTUAL MINUS TREND
Day Period Data Moving Average = Trend
1 Morning 170
Afternoon 140 180 -40 =F179-I179
Evening 230 182 48 =F180-I180
2 Morning 176 186 -10 =F181-I181
Afternoon 152 187 -35 =F182-I182
Evening 233 189 44 =F183-I183
3 Morning 182 192 -10 =F184-I184
Afternoon 161 195 -34 =F185-I185
Evening 242