Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Grade Point Average (GPA) Transcript Spreadsheet You are the faculty academic advisor. Your Business Administration Major student cumulative GPA required for graduation: 2.250. Replicate the

image text in transcribed

Grade Point Average (GPA) Transcript Spreadsheet You are the faculty academic advisor. Your Business Administration Major student cumulative GPA required for graduation: 2.250. Replicate the provided BUS major with ENTR emphasis sample spreadsheet. Enter courses, letter grades and course credits. Enter function to automatically convert letter grades to numerical grades (VLOOKUP example in MATERIALS CONTENTS in D2L shell) Automatically calculate quality points for each course Automatically calculate major GPA How can this be used to improve efficiency? How can this be used to improve decision-making? What Type of Information System? What's your bottom-line DECISION for the student possessing this transcript? GPA Transcript Spreadsheet BuAd ENTR Letter Grade CREDITS 3 3 3 COURSE Acct 2101 Acct 2102 Acct 3118 BuAd 2220 BuAd 2231 BuAd 2280 BuAd 3223 BuAd 3281 BuAd 3283 BuAd 3351 BuAd 3361 BuAd 3381 BuAd 3371 BuAd 3568 BuAd 4559 BuAd 4600 Econ 2000 Econ 2100 Math 1170 OOO OCUUUUUUUU UI Grade Point Average (GPA) Transcript Spreadsheet You are the faculty academic advisor. Your Business Administration Major student cumulative GPA required for graduation: 2.250. Replicate the provided BUS major with ENTR emphasis sample spreadsheet. Enter courses, letter grades and course credits. Enter function to automatically convert letter grades to numerical grades (VLOOKUP example in MATERIALS CONTENTS in D2L shell) Automatically calculate quality points for each course Automatically calculate major GPA How can this be used to improve efficiency? How can this be used to improve decision-making? What Type of Information System? What's your bottom-line DECISION for the student possessing this transcript? GPA Transcript Spreadsheet BuAd ENTR Letter Grade CREDITS 3 3 3 COURSE Acct 2101 Acct 2102 Acct 3118 BuAd 2220 BuAd 2231 BuAd 2280 BuAd 3223 BuAd 3281 BuAd 3283 BuAd 3351 BuAd 3361 BuAd 3381 BuAd 3371 BuAd 3568 BuAd 4559 BuAd 4600 Econ 2000 Econ 2100 Math 1170 OOO OCUUUUUUUU UI

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions