Instructions to the Mini Case - business Productivity Software - IT Assignment Help

Assignment Task:

Task:

Purpose of Assignment
The purpose of this assignment is to give you the chance to solve a realistic business problem, using business productivity software and knowledge that you would have learned from the course.

Your submission will require:
1) A word document that contains the steps (elaborated) you took to solve the problem
(Analysis Steps) and the final decision based on your analysis
2) An Excel file that contains the data set and the analysis steps you followed including the manipulation of the data in the data set

NB: To submit your assignment, you will need to zip all your files into a zip folder Name the zipped folder with your first name, last name, and assignment name - for example if you name is john doe and submitting assignment 1, then the file should be names: johndoeassignment1.zip

Grading breakdown
Your grade will be based on the content of your word file which should include all figures and tables and text created in excel, access, etc... (What is to be included is up to you. The goal of the word file is that it integrates all information necessary from identifying the problem to the solution graphs and figures and interpretation).

Problem Description
In the email, you find the following problem description of your client:

Dear John,
We are happy that you will be our portfolio manager and excited to work with you on a number of business-related problems that will help our managers and executives make more data- supported decisions for the continued growth of our company and satisfaction of our clients. We have a large amount of data that we continue to capture and which we are interested in analyzing. Professor Duberrie is a new lecture for University du Quebec a Montreal (UQAM). Due to his PHD thesis, he has lost track of time and forgot to submit his student final grades to the department. He heard about our consulting company that specialized in data analytics through a colleague and decided to see if we can help him. He asked the chair of his department for an extension for the grades submission and contacted us right away.
To submit the final grades, he needs:
1) all his student grades to be sorted in alphabetical order (last name or first name),
2) compute the weighted total for each student,
3) compute the grade of each student as follows:

Grade total
A+ 90 - 100
A

A-
B+

B

B-
C

85 - 90-
80 - 85
77 - 80
73 - 77
70 - 73
60 - 70
F 60-

4) He also asked if you could provide a statistical distribution of the student grades for his class.

This IT Assignment has been solved by our IT Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.