IT

Task 1: Microsoft Excel
(40 marks)
Assessment Task
  Traffic Fine
As from the Royal Police of Oman is providing the list of those traffic violators who are exceeding the speed limit mentioned on the roads. You are required to prepare a file of minimum 10 violators along-with several number of fines on different locations (as sample) by using Microsoft Excel for the calculation of Fine amount against each violator.
The task should contain the following:
Task 1 (a):
i. Create a COMPLETE worksheet with appropriate labels for the above-mentioned scenario.
ii. Calculate the Grand Total against each Violator by multiplying the Fine Amount with Number
of fines by using the appropriate formula.
iii. Calculate the Payment Method against each violator with the following condition:
IF, Grand Total is less than or equal to 20, Payment would be in “Cash” otherwise it would be through “Visa Card”.
Task 1 (b)
Also, provide the following statistical data:
i. Count “Number of Violators” given in the table.
ii. Calculations of “Highest amount of fine” committed by a violator.
iii. Calculations of “Lowest amount of fine” committed by a violator.
iv. Counttheremarks“Cash”from“PaymentMethod”column.
v. Count the remark “Visa Card” from “Payment Method” column.
Task 1 (c)
Draw a “Pie chart” that will show the Total amount of fine against each Violator and save the
spreadsheet as Task1_ID_MS Excel.
  Pg. 4 Version 1

Task 2: Microsoft PowerPoint (20 marks)
Use the statistical data given in “Task 1” and prepare five PowerPoint slides Presentation. The Slides should be arranged as follows:
1. Introduction (Slide 1)
2. Comprehensive Information along-with Pie chart (Slides 2, 3 and 4)
3. Overall insight and outcome of the presentation (Slide 5)
Note:
Use more than one different slide layouts and save the presentation as Task2-ID-MS PowerPoint.
Task 3: Microsoft Access (40 marks)
Create a table related to the “Task 1” in Microsoft Access by using different field data types that will show the status of those Traffic Violators who exceeded the speed limit mentioned on the roads. You are also required to generate a report for those Violators who paid their fine by using “Visa Card” and save with a filename Task3-ID-MS Access
Guideline to the Students:
• Check that all the data has been entered accurately
• Use formatting features to make sure the spreadsheet is easy to read and looks professional
• Use suitable layout
• Use suitable font
• Use correct capitalization
• Use correct formulas and functions
• Header (Student Name and Student ID)
• Footer (write the Module name and Module code)
• Font – Calibri, Font Size – 12 (body), font size heading – 14
• Apply background colour in table header and those columns with formulas
• Border line should be strictly observed
Note: Complete your file(s) by keeping in mind that your document(s) should look professional and submit the original files of each task i.e. (Task 1 – Microsoft Excel and Task 2 & 3 – Microsoft PowerPoint & Microsoft Access that also contains the information/data of Microsoft Access task (as an evidence) to the concerned link on Turnitin accordingly.
    Moreover, It is to be further advised that
Turnitin doesn’t have any link for Microsoft Access.
as
transfer (copy and paste) the data / information from
  Microsoft Access (Table and Report) to the same file of Microsoft PowerPoint along-with the
appropriate headings of Task 3 after the completion of Task 2 and upload to the Turnitin
 Pg. 5 Version 1
***END OF ASSIGNMENT TASK***

  Question Number
   Criteria for Rubrics
   Description
   Marks Allocated
  Task 1 (Microsoft Excel)
       Task 1(a)
Task 1(b) Task 1(c)
Task 2
Introduction-1 i. ii. Knowledge-1 iii.
Marking Scheme
Complete contents and headings of the table. Calculation of Grand Total
Calculation of Payment Method:
Calculation of Statistical data
Pie Chart
5
5
5
4 x 5 = 20 5
3
3 + 3 =6 3
3
5
2 x 6 = 12 4
2
3 x 4 = 12 10 100
GCO4009 – Business Applications AY: 2019-2020 / 2nd Semester
         Analysis-1
Introduction-2 Knowledge-2 Analysis-2
Conclusion-2
Introduction-3
iv. v.
                                 Task 3
Task 2 (Microsoft PowerPoint)
i. First slide (Brief Introduction):
ii. Second and Third slide include information
iii. Fourth slide include Description and Pie Chart iv. Last slide with Conclusion / Summary (outcome
of presentation)
v. Overall creativity of presentation
Task 3 (Microsoft Access)
i. Creation of Table with all fields
ii. Complete information mentioned in the table
iii. Alignment of data
Using different data types applied on the fields of the table
   Knowledge-3 iv.
Analysis-3 v. Correct and comprehensive report
       TOTAL MARKS

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 15% with the discount code SUCCESS