Excel_BP4_StudentsGrades

Excel_BP4_StudentsGrades - Professors M. Rossin and R. Saad...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Professors M. Rossin and R. Saadé Fundamentals of IT and Business Productivity
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Purpose The purpose of this assignment it to have Excel calculate the requirements automatically through formulas and/or functions. You need to enter as much of the above information as you can in an Excel spreadsheet and create formulas and/or functions that will automatically calculate the results. *Be resourceful. Use the textbook if you need help and you can also research the web for ideas. *Try your best. This is not a math course and we will not answer math related questions. You may, within reason , add your own assumptions and make small changes to some of the variables to make it easier for you to work with. We are interested in your ability to create a logical spreadsheet and use formulas and/or functions to have Excel calculate the requirements. Requirements 1 . Sort the students in alphabetical order 2 . Compute the weighted total for each student 3. Compute the grades of each student as follows
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Excel_BP4_StudentsGrades - Professors M. Rossin and R. Saad...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online