Xpert
01-24-2011, 06:10 PM
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
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
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
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