A+=4.33 A=4.0 A-=3.67 B+=3.33 B=3 B-=2.67 C+=2.33 C=2 F=0 etc

weighted homework 24% final exam 30% team assignments 29% participation 17%

. A Using the data below and create a Microsoft Excel spreadsheet that will: o Upon entering a student letter (e.g., H), the spreadsheet should compute the GPA (both numeric and letter grade) for that student o The spreadsheet should compute the grade to date (both numeric and letter grade)for a given student using the grade computation section of the syllabus (as well as assignment weightings that appear in various sections) for this class for a given student as well as factor in ALL class assignments whether graded or ungraded. The spreadsheet should compute the grade (both numeric and letter grade) that a student would receive if they received F's on all the uncompleted/ungraded assignments The spreadsheet should determine the grade that is needed on ungraded assignments to earn an A-in the class. o The spreadsheet should factor in that one homework assignment can be dropped. The spreadsheet should compute the average grade per category using the SUMIF (you can ignore dropped homework grade). Note extra credits are not included. O Provide appropriate labels, instructions, ease of use features and formatting -all affect your grade. Your name (last name, first name) and section #must appear at the top of your spreadsheet. Save the Excel file as 2020-08-BMGT326-0X01-Final-PartD-LastName-FirstName.xlsx and submit via Canvas. Your spreadsheet solution will be graded on completeness, correctness, and style. Student / Graded Assignment Category BC DEFG Individual HW 1: System Documentation - DFD Individual HW AB+C+ A+ A+ A Individual HW 2: System Documentation - FC Individual HW A-A-AF A+ AA- A- Individual HW 3: Database Modeling - ERD Individual HW B C+ C+C CB C+ B- Individual HW 4: Access Query Individual HW A+ A+ C F A A+ A A+ Individual HW 5: Cybersecurity Individual HW A+ A+ A+ A+ A+ A+ A+ Individual HW 6: Accounting Software Individual HW A+ A+C A+ A+ A+ A+ A+ Individual HW 7: XBRL Individual HW A- A+B+ A+ A+ A+ A+ A+ Team Assignment 1: Part A - Revenue Team Assignment A+ A+ A+ A+ A+ A+ A+ A+ Team Assignment 1: Part B - Expenditures Team Assignment A+ A+A AB B A+ Team Assignment 1: Part C- Quick Books Team Assignment A+ A+ A+ A+ A+ A+ A+ Team Assignment 2: Part A - Flowchart Team Assignment C B- CB B B Team Assignment 2: Part B -Internal Control Team Assignment B B B+B+B+ B B+ Forum Participation Forum Participation F B-F A+ F A+ A+ Team Participation Assignment 1-Part A Team Participation A+ A+ A+ A+ Team Participation-Assignment 1-Part B Team Participation A+ A+ A+ A+ A+ A+ Team Participation Assignment 1-Part C Team Participation A+ A+ A+ A+ A+ A+ Team Participation Assignment 2-Part A-FC Team Participation A+ A+ A+ A+ A+ Team Participation Assignment 2-Part A-IC Team Participation A A+ A+ A+ A+ A+ A+ A+ B- B+ A+ A+ A+ A+ A+ A+ A+ A+ A A+ A A A+ . A Using the data below and create a Microsoft Excel spreadsheet that will: o Upon entering a student letter (e.g., H), the spreadsheet should compute the GPA (both numeric and letter grade) for that student o The spreadsheet should compute the grade to date (both numeric and letter grade)for a given student using the grade computation section of the syllabus (as well as assignment weightings that appear in various sections) for this class for a given student as well as factor in ALL class assignments whether graded or ungraded. The spreadsheet should compute the grade (both numeric and letter grade) that a student would receive if they received F's on all the uncompleted/ungraded assignments The spreadsheet should determine the grade that is needed on ungraded assignments to earn an A-in the class. o The spreadsheet should factor in that one homework assignment can be dropped. The spreadsheet should compute the average grade per category using the SUMIF (you can ignore dropped homework grade). Note extra credits are not included. O Provide appropriate labels, instructions, ease of use features and formatting -all affect your grade. Your name (last name, first name) and section #must appear at the top of your spreadsheet. Save the Excel file as 2020-08-BMGT326-0X01-Final-PartD-LastName-FirstName.xlsx and submit via Canvas. Your spreadsheet solution will be graded on completeness, correctness, and style. Student / Graded Assignment Category BC DEFG Individual HW 1: System Documentation - DFD Individual HW AB+C+ A+ A+ A Individual HW 2: System Documentation - FC Individual HW A-A-AF A+ AA- A- Individual HW 3: Database Modeling - ERD Individual HW B C+ C+C CB C+ B- Individual HW 4: Access Query Individual HW A+ A+ C F A A+ A A+ Individual HW 5: Cybersecurity Individual HW A+ A+ A+ A+ A+ A+ A+ Individual HW 6: Accounting Software Individual HW A+ A+C A+ A+ A+ A+ A+ Individual HW 7: XBRL Individual HW A- A+B+ A+ A+ A+ A+ A+ Team Assignment 1: Part A - Revenue Team Assignment A+ A+ A+ A+ A+ A+ A+ A+ Team Assignment 1: Part B - Expenditures Team Assignment A+ A+A AB B A+ Team Assignment 1: Part C- Quick Books Team Assignment A+ A+ A+ A+ A+ A+ A+ Team Assignment 2: Part A - Flowchart Team Assignment C B- CB B B Team Assignment 2: Part B -Internal Control Team Assignment B B B+B+B+ B B+ Forum Participation Forum Participation F B-F A+ F A+ A+ Team Participation Assignment 1-Part A Team Participation A+ A+ A+ A+ Team Participation-Assignment 1-Part B Team Participation A+ A+ A+ A+ A+ A+ Team Participation Assignment 1-Part C Team Participation A+ A+ A+ A+ A+ A+ Team Participation Assignment 2-Part A-FC Team Participation A+ A+ A+ A+ A+ Team Participation Assignment 2-Part A-IC Team Participation A A+ A+ A+ A+ A+ A+ A+ B- B+ A+ A+ A+ A+ A+ A+ A+ A+ A A+ A A A+