Modern College of Business and Science Personal Budget Excel Sheet see file attached ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Modern College of Business and Science Personal Budget Excel Sheet see file attached ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Submission Deadline
Marks and Feedback
Before 6pm on:
15 working days after deadline (All Levels)
01/06/2020
Click or tap to enter a date.
Module title & code
Information Technology (IT2) – (FND013-2)
Assignment number and title
Assignment (2A) – Excel sheet + Viva (Alternative Assessment for Final Exam due to COVID-19)
Assessment type
Excel + Viva
Weighting of assessment
50%
Module learning outcomes
1. Understand the spreadsheet processing skills.
2. Gain practical skills in Excel by using the available tools in different tabs (Home, Insert,
Formula, data and view)
3. Gain Communication Skills through presenting the topic
4. Analyzing skills in Viva (Answering Questions)
What am I required to do in this assignment?
Introduction
This is an individual assignment; the student must prepare Excel sheet based on the report that was done on the first assignment.
You should follow all the instructions carefully. You will submit the sheet Online through MOVE page.
Criteria of Presentation:
•
•
•
•
•
Use Microsoft Excel to make a spreadsheet on the following area (Select only one area) :
(Business Budget, Personal Budget, Event Budget, Income expenses, Sales management, Payroll management)
Each student must create his own sheet on the above areas the sheet name should be the area that is
chosen.
The sheet should contain 10 Rows and 5 columns ( Note : Don’t include the functions like Sum,Max …etc)
Viva 3 practical questions will be asked to the student during the Viva
Excel sheet the student should answers the following:
1. Insert appropriate blank rows (1 Row) on top and type the suitable title for your sheet
2. Format the table as Follows:
The title should have the following:
3. Font type: Algerian
4. Font size: 28
5. Fill Color: Purple
6. Font Color: Yellow
7. Merge and Center, Bold
8. Dashed Border with border color – Dark Red
9. Change the Column Width of all columns to ‘15’.
10. Change the Row height of all rows to ‘20’.
11. Select the appropriate border (outline: double line & Inside: dotted) and canter alignment for
the cells.
12. Create your own formula by using a label for that in F2 and the Result in F3 Use any of the main
operators ( * , / , + , – ) Copy the formula to find the result for others columns .
13. Find the Sum label on A13, result in B13 . Copy the formula to find the Sum of other columns.
14. Find the Average label in A 14, result in B14. Copy the formula to find the Average of other
columns.
15. Find the Maximum label in A15, result in B15. Copy the formula to find the Maximum of other
columns.
16. Find the Minimum label in A16, result in B16. Copy the formula to find the Minimum of other
columns.
17. Sort column A in ascending order.
18. Filter any column using text filter (Begins with ).Copy the filtered data to a new sheet and name
it as Filter1.
2
19. Filter any column using number filters greater than or equal to. Copy the filtered data to a new
sheet and name it as Filter2.
20. Filter any column using number filters less than. Copy the filtered data to a new sheet and name
it as filter 3
21. In your main sheet, use Conditional formatting “Data bar” for all the numbers. (Style: Solid Fill –
Red Data Bar).
22. Convert the Sum and Average Row in to three decimal places.
23. Using Advanced Filter, criteria (OR)
24. Using Advanced Filter, criteria (AND)
25. Create a Stacked Area – 3 D Clustered Column Chart to display the sheet Information. Write the
title, the X-axis, and Y-axis.
26. Move the chart to a new sheet and name it “Chart one”.
27. Place the Legend at the top of the Chart.
Assignment Guidelines
•
•
•
•
•
Student should prepare Excel sheet based on one of the areas given.
Student should be creative while designing the sheet.
The student must prepare for the viva after submitting the Excel sheet (Viva will be in week 16, during the class
time)
Each student will have 5 minutes to answer 3 questions.
For Operational Guidelines refer to Student Handbook Section IV: ASSESSMENTS.
Deliverables
Submission
At the time of submission, you need to make sure that the assignment is your own and all the sources have been acknowledged.
1. Excel sheet must be submitted online (through MOVE) on/before the deadline.
Is there a word limit (Number of Words ± 10%)?
3
No word limit is required
What do I need to do to pass? (Threshold Expectations)
•
•
•
•
Make an valuable information inside your sheet.
Submit your work before the deadline
Make sure to prepare the practical by yourself
You should be ready to answer any question related to your sheet in your Viva
How do I produce high quality work that merits a higher grade?
Well-organized Excel sheet, valuable information and data, Practical knowledge during the Viva.
How does assignment relate to what we are doing in scheduled sessions?
•
At the end, students will be equipped with important fundamentals and skills in MS. Excel
4
Report Marking Rubric
How will my assignment be marked?
Your assignment be marked according to the threshold expectations and the criteria on the following page.
You can use them to evaluate your own work and estimate your grade before you submit.
No
Criterion
1
Formatting
2
Formulas
3
Sort & Filter
5
Chart
6
Viva &
Answering
Questions
Weighing
(%)
20%
20%
30%
20%
10%
Sub Standard
/ No Attempt
(0 Marks)
Satisfactory
(40 Marks)
Good
(50 Marks)
Not all
questions are
created, topic
is not related
One formula
written
Questions on
formatting is
without answers
Formatting some
questions where
others is not.
Formatting is
very good few
mistakes
Formatting is
excellent and few
mistakes
Formatting is done
efficiently no mistakes
Wrong
formulas
Some formula is
correct.
Formula is done
correctly with
some error
No mistakes all
formula questions
answered correctly.
No sort & filter
Not all
questions are
prepared in
filter
Student is
trying to solve
one or two
questions
Student solve
some questions
Student solved
most of the
questions
Mostly the answers
for all formulas
correct
Students answers all
the questions with
little mistakes
No chart
inserted
Chart is not
complete
Type of chart is
not selected
Chart is inserted
correctly some
error in
formatting chart
Chart is
organized no
title and Y & X
axis
Chart is organized
with some mistakes
on legend
Chart and title is
selected properly no
mistakes
Gives a demo,
but unable to
explain.
Question not
answered well
and explanation
unsatisfactory.
Questions
answered, but
explanation not
satisfactory.
Questions
answered, but
explanation not
enough.
Questions answered
clearly with full
explanation, but no
examples
Questions answered
clearly with full
explanation with
examples
No Submission
No
Formula
written
Student is not
answering the
question
Poor
(20 Marks)
Very Good
(60 Marks)
Excellent
(70 Marks)
Outstanding
(100 Marks)
Sorting and filters is
done without any
mistake

Purchase answer to see full
attachment