Reference no: EM131442004
Excel Assignment
Create a spreadsheet that your instructor could use to calculate final averages and letter grades for this class (INFS 3100). Use the point values from the syllabus for discussion questions, Excel assignments and quizzes. The spreadsheet should use the design and all features of the spreadsheet created in your Excel tutorial for assignment 2. More specifically, the following requirements must met:
1. Each student record should be on one row and each grade item or calculated value should be in one column similar to the tutorial
2. A table that includes cutoff's for each grade level, i.e. 90 for A, 80 for B, etc.
3. Column Headings
4. A minimum of 5 fictitious student records with grades entered for each student.
5. Columns for total points in each category of grades (discussion, Excel and quiz).
6. A calculated final average.
7. A final letter grade. Use an IF statement and absolute cell referencing for grade cutoff's from the table created in 1.a. above (similar to what was done in assignment 2 tutorials).
8. A class average for each individual grade item, combined grade categories (discussion, Excel, and quiz), and final average.
9. The highest (max) grade for each individual grade item, combined grade categories, and final average.
10. The lowest (min) grade for each individual grade item, combined grade categories, and final average.
11. Center all column headings
12. Bold columns for total discussion points, total Excel assignment points, total quiz points, final average, and letter grade.
13. Format all calculated values (not individual scores) as number with one decimal point.
14. Put your name at the top of the spreadsheet.
15. Upload your completed assignment to the Dropbox for assignment 2 in D2L by the due date. Verify that you assignment is uploaded correctly. This can be accomplished by opening the uploaded file to verify the file opens properly.
This is an individual assignment and you should create this spreadsheet on your own. Keep in mind that the tutorial is a learning tool and completion of the tutorial is not the assignment. You should start with a blank spreadsheet and build the assignment from scratch.
Attachment:- student_grade_worksheet.rar
|
Testing of advertising commercials
: Marketing research has been around for more than a century. In the early days, marketing research was little more than a spin-off of the Census Bureau data. AfterWorld War II, psychology began to play a more integral role in marketing research, an..
|
|
What is the present value of any coupon
: Bond A has a coupon rate of 15.81 percent, a yield-to-maturity of 12.55 percent, and a face value of 1,000 dollars; matures in 16 years; and pays coupons annually with the next coupon expected in 1 year.
|
|
How has the technology been received accepted or rejected
: How has this technology been received, accepted, or rejected? Why? Is it feared or favored? What is the attitude toward change? How are the developers trying to sell the technology to the general public?
|
|
Good practices for organizations
: Describe the criteria you used to select the organization and discuss how your organization met your selection criteria. Select three or four factors that you can generalize as good practices for organizations with virtual project teams.
|
|
Create a spreadsheet that your instructor could use
: Create a spreadsheet that your instructor could use to calculate final averages and letter grades for this class (INFS 3100). Use the point values from the syllabus for discussion questions, Excel assignments and quizzes. The spreadsheet should u..
|
|
Create a new product that would appeal to market
: Choose the target market for your product, and describe your target market in detail. Create a new product that would appeal to your market.
|
|
By what percent will price of the bonds increase in maturity
: Lance Whittingham IV specializes in buying deep di. Lance Whittingham IV specializes in buying deep discount bonds. These represent bonds that are trading at well below par value.
|
|
How the internet may affect public opinion in a positive way
: Write a paper that summarizes how Internet may affect public opinion in a positive or negative way with regards to brand reputation. Select a well-known brand and discuss the current state of public opinion using the Internet as your research tool..
|
|
Management has a number of components
: Effective performance management has a number of components beginning with a performance-focused organizational culture. Describe a performance-focused culture and its relationship with employee training and development. (provide at least one cit..
|