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

[Xpert]

View more random threads:

• ACC311- Fundamentals of Auditing final term paper 2012...
• ENG201 Business and Technical English Short Notes Final...
• Midterm paper ended fall 2010
• CS101 Introduction to Computing Solve Final Term Papers 2013
• CS301 Data Structures Short Notes Final term Fall Semester...
• MTH101 Calculus And Analytical Geometry Solve Final Term...
• MGT 101 Solve Past Final term Papers Fall 2013
• CS101 Introduction to Computing Solve Paper December 2012
• ISL201 Islamic Studies Short Solved Paper December 2012-2013
• MGT111 Introduction to Public Solve All Past Final Term...

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

Sponsored Links

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