![]() ![]() Write your explanation of what you did as if writing to someone not in this course. This should be an overview of how you did this. Explain in paragraph form using complete college appropriate sentences how you created the Excel worksheet you have used for this project.Your answers to these questions will be typed in and submitted in IvyLearn using the link to Project 1. Questions are not cumulative - return to your original spreadsheet values before going on to answer the next question. See the last page of this project description for samples of what poorly written responses and well written responses would look like before you answer the questions below. Make sure to use your spreadsheet to answer the "what if" questions with specific values and provide support for your statements. This should clearly convey your message to a reader who is not taking Math 123. Use proper quantitative reasoning and wording to address the solution. Each short-answer response should be a minimum of 3 sentences and 50 words. Typed Responses in MS Word: Your typed responses for this project will consist of answering the short-answer questions given below. Please limit your use of Excel functions to those used in the course (An 'Excel Reference sheet' can be found in the module) Highlight the final course percentage cell. If a value is changed in your spreadsheet of individual scores, your final course percentage calculation should immediately recalculate. That cell should contain a formula used to calculate the weighted final course percentage. The cell where the final course percentage should be located at the bottom of your grade book calculation table and should be labeled. A final course percentage based on the percent weightings.Category Weights given on the next page used to determine the final weighted percentage for a MATH 123 class.A table to calculate the final course percentage with the following headings: Categories, Category Weights, Category Averages and Category Percentage Points.A data table labeled by Category using the category headings and scores on the next page for a MATH 123 class (DO NOT use any of your own scores).Your name, course name and project name.Your Excel spreadsheet should contain the following: You will be required to CREATE the gradebook from a blank worksheet. You should NOT be using a template for this project. Keep in mind that weighting is involved in determining the final grade. Create an Excel spreadsheet that will be capable of calculating a student's final grade in a given course.In this project you are required to do the following: ![]() Excel documents ONLY should be uploaded (xls or xlsx file extensions only). You will then submit responses to several questions regarding your project in IvyLearn. In this project, you will create an Excel spreadsheet that can calculate a student's final grade in a course. Understanding how weighted averages work will be a very important topic for you in this course, since your grades are determined in this way. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |