Devry Bis 311 Final Exam-2015

In: Other Topics

Submitted By petersun
Words 2312
Pages 10
Devry BIS 311 Final Exam-2015
IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-311-Final-Exam-2015-9309303321.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM
Question
Devry bIS311 final Page 1 Question 1.1. (TCO 1) In the systems development life cycle, the goal of the design activity is to _____. (Points : 5) determine exactly what a new or modified information system should do create a set of detailed plans or blueprints for the system build the application ensure that the application works as desired Question 2.2. (TCO 2) To plan the code for a procedure, _____ uses standardized symbols to show the steps the procedure must follow to reach its goal. (Points : 5) pseudocode a TOE chart a class diagram a flowchart Question 3.3. (TCO 3) Computer memory locations where programmers can temporarily store and change data while an application is running are _____. (Points : 5) classes literals constants variables Question 4.4. (TCO 3) In Visual Basic, which of the following correctly declares a named constant with the name strCOURSE that contains the string value "BIS311"? (Points : 5)
Const strCOURSE As String = "BIS311"
String Constant strCOURSE = "BIS311"
Dim strCOURSE As "BIS311"
Const String "BIS311" As strCOURSE Question 5.5. (TCO 5) A _____ structure is used in an application when a decision needs to be made, followed by an action derived from that decision. (Points : 5) selection sequence repetition interrogative Question 6.6. (TCO 5) If intQty contains 60, what will be the value of intPrice after executing the following code?
Select Case intQty
Case 1 To 50 intPrice = 10
Case 51 To 100 intPrice = 8
Case > 100 intPrice = 6
Case Else intPrice = 0
End Select (Points : 5)
10
8
6
0 Question 7.7. (TCO 6)…...

Similar Documents

Bis 155 Final Exam - Devry

...BIS 155 Final Exam - DeVry IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://www.hwnerd.com/BIS-155-Final-Exam-DeVry-2071.htm?categoryId=-1 If You Face Any Problem E- Mail Us At Contact.Hwnerd@Gmail.Com BIS 155 Final Exam 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly...

Words: 970 - Pages: 4

Bis 155 Final Exam - Devry

...BIS 155 Final Exam - DeVry IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://www.hwnerd.com/BIS-155-Final-Exam-DeVry-2071.htm?categoryId=-1 If You Face Any Problem E- Mail Us At Contact.Hwnerd@Gmail.Com BIS 155 Final Exam 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly...

Words: 970 - Pages: 4

Bis 155 Final Exam - Devry

...BIS 155 Final Exam - DeVry BIS 155 Final Exam Answers Paste the Below Link into Your Browser To Purchase http://www.homeworkarena.com/bis-155-wk-8-final-exam-answers-devry 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within......

Words: 952 - Pages: 4

Bis 155 Final Exam – Devry

...BIS 155 FINAL EXAM – DEVRY To buy this click here http://www.coursehomework.com/product/bis-155-final-exam-devry/ Contact us:+1 315-750-4434 help@coursehomework.com BIS 155 FINAL EXAM - DEVRY BIS 155 Final Exam 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to......

Words: 959 - Pages: 4

Bis 155 Final Exam - Devry

...BIS 155 Final Exam - DeVry BIS 155 Final Exam Answers Paste the Below Link into Your Browser To Purchase http://www.homeworkarena.com/bis-155-wk-8-final-exam-answers-devry 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within......

Words: 952 - Pages: 4

Devry Bis 155 Final Exam-2015 Spring

...Devry BIS 155 Final Exam-2015 Spring IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-155-Final-Exam-2015-Spring-5811235986.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Question 1.1.(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours. Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification. Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 4: Salaried and Exempt employees (Pay Codes E and S) are......

Words: 922 - Pages: 4

Devry Bis 155 Final Exam-2015 August

...Devry BIS 155 Final Exam-2015 AUGUST IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-155-Final-Exam-2015-AUGUST-6785641024.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Question 1.1.(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours. Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification. Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 4: Salaried and Exempt employees (Pay Codes E and S) are......

Words: 924 - Pages: 4

Devry Bis 155 Final Exam-2015 Spring

...Devry BIS 155 Final Exam-2015 Spring IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-155-Final-Exam-2015-Spring-5811235986.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Question 1.1.(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours. Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification. Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 4: Salaried and Exempt employees (Pay Codes E and S) are......

Words: 922 - Pages: 4

Devry Bis 311 Final Exam-2015

...Devry BIS 311 Final Exam-2015 IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-311-Final-Exam-2015-9309303321.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Devry bIS311 final Page 1 Question 1.1. (TCO 1) In the systems development life cycle, the goal of the design activity is to _____. (Points : 5) determine exactly what a new or modified information system should do create a set of detailed plans or blueprints for the system build the application ensure that the application works as desired Question 2.2. (TCO 2) To plan the code for a procedure, _____ uses standardized symbols to show the steps the procedure must follow to reach its goal. (Points : 5) pseudocode a TOE chart a class diagram a flowchart Question 3.3. (TCO 3) Computer memory locations where programmers can temporarily store and change data while an application is running are _____. (Points : 5) classes literals constants variables Question 4.4. (TCO 3) In Visual Basic, which of the following correctly declares a named constant with the name strCOURSE that contains the string value "BIS311"? (Points : 5) Const strCOURSE As String = "BIS311" String Constant strCOURSE = "BIS311" Dim strCOURSE As "BIS311" Const String "BIS311" As strCOURSE Question 5.5. (TCO 5) A _____ structure is used in an application when a decision needs to be made, followed by an action......

Words: 2312 - Pages: 10

Devry Bis 155 Final Exam-2015 August

...Devry BIS 155 Final Exam-2015 AUGUST IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-155-Final-Exam-2015-AUGUST-6785641024.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Question 1.1.(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours. Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification. Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 4: Salaried and Exempt employees (Pay Codes E and S) are......

Words: 924 - Pages: 4

Bis 155 Final Exam – Devry

...BIS 155 FINAL EXAM – DEVRY To purchase this, Click here http://www.activitymode.com/product/bis-155-final-exam-devry/ Contact us at: SUPPORT@ACTIVITYMODE.COM BIS 155 FINAL EXAM – DEVRY BIS 155 Final Exam 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of...

Words: 1911 - Pages: 8

Devry Bis311 Final Exam 2015

...Devry BIS311 Final exam 2015 Click Link Below To Buy: http://hwcampus.com/shop/bis311-final-exm/ Devry bIS311 final Page 1 Question 1.1. (TCO 1) In the systems development life cycle, the goal of the design activity is to _____. (Points : 5) determine exactly what a new or modified information system should do create a set of detailed plans or blueprints for the system build the application ensure that the application works as desired Question 2.2. (TCO 2) To plan the code for a procedure, _____ uses standardized symbols to show the steps the procedure must follow to reach its goal. (Points : 5) pseudocode a TOE chart a class diagram a flowchart Question 3.3. (TCO 3) Computer memory locations where programmers can temporarily store and change data while an application is running are _____. (Points : 5) classes literals constants variables Question 4.4. (TCO 3) In Visual Basic, which of the following correctly declares a named constant with the name strCOURSE that contains the string value "BIS311"? (Points : 5) Const strCOURSE As String = "BIS311" String Constant strCOURSE = "BIS311" Dim strCOURSE As "BIS311" Const String "BIS311" As strCOURSE Question 5.5. (TCO 5) A _____ structure is used in an application when a decision needs to be made, followed by an action derived from that decision. (Points : 5) selection sequence repetition interrogative Question 6.6. (TCO 5) If intQty contains 60, what will be the value of intPrice after executing......

Words: 2279 - Pages: 10

Devry Bis311 Final Exam 2015

...Devry BIS311 Final exam 2015 Click Link Below To Buy: http://hwcampus.com/shop/bis311-final-exm/ Devry bIS311 final Page 1 Question 1.1. (TCO 1) In the systems development life cycle, the goal of the design activity is to _____. (Points : 5) determine exactly what a new or modified information system should do create a set of detailed plans or blueprints for the system build the application ensure that the application works as desired Question 2.2. (TCO 2) To plan the code for a procedure, _____ uses standardized symbols to show the steps the procedure must follow to reach its goal. (Points : 5) pseudocode a TOE chart a class diagram a flowchart Question 3.3. (TCO 3) Computer memory locations where programmers can temporarily store and change data while an application is running are _____. (Points : 5) classes literals constants variables Question 4.4. (TCO 3) In Visual Basic, which of the following correctly declares a named constant with the name strCOURSE that contains the string value "BIS311"? (Points : 5) Const strCOURSE As String = "BIS311" String Constant strCOURSE = "BIS311" Dim strCOURSE As "BIS311" Const String "BIS311" As strCOURSE Question 5.5. (TCO 5) A _____ structure is used in an application when a decision needs to be made, followed by an action derived from that decision. (Points : 5) selection sequence repetition interrogative Question 6.6. (TCO 5) If intQty contains 60, what will be the value of intPrice after executing......

Words: 2279 - Pages: 10

Devry Bis311 Final Exam 2015

...Devry BIS311 Final exam 2015 Click Link Below To Buy: http://hwcampus.com/shop/bis311-final-exm/ Devry bIS311 final Page 1 Question 1.1. (TCO 1) In the systems development life cycle, the goal of the design activity is to _____. (Points : 5) determine exactly what a new or modified information system should do create a set of detailed plans or blueprints for the system build the application ensure that the application works as desired Question 2.2. (TCO 2) To plan the code for a procedure, _____ uses standardized symbols to show the steps the procedure must follow to reach its goal. (Points : 5) pseudocode a TOE chart a class diagram a flowchart Question 3.3. (TCO 3) Computer memory locations where programmers can temporarily store and change data while an application is running are _____. (Points : 5) classes literals constants variables Question 4.4. (TCO 3) In Visual Basic, which of the following correctly declares a named constant with the name strCOURSE that contains the string value "BIS311"? (Points : 5) Const strCOURSE As String = "BIS311" String Constant strCOURSE = "BIS311" Dim strCOURSE As "BIS311" Const String "BIS311" As strCOURSE Question 5.5. (TCO 5) A _____ structure is used in an application when a decision needs to be made, followed by an action derived from that decision. (Points : 5) selection sequence repetition interrogative Question 6.6. (TCO 5) If intQty contains 60, what will be the value of intPrice after executing......

Words: 2279 - Pages: 10

Devry Bis 311 Final Examination Answers

...Devry BIS 311 Final Examination Answers Follow Below Link to Download Tutorial http://homeworklance.com/downloads/devry-bis-311-final-examination-answers/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com Question 1.1. (TCO 1) In the systems development life cycle, the goal of the design activity is to _____. (Points : 5) determine exactly what a new or modified information system should do create a set of detailed plans or blueprints for the system build the application ensure that the application works as desired Question 2.2. (TCO 2) To plan the code for a procedure, _____ uses standardized symbols to show the steps the procedure must follow to reach its goal. (Points : 5) pseudocode a TOE chart a class diagram a flowchart Question 3.3. (TCO 3) Computer memory locations where programmers can temporarily store and change data while an application is running are _____. (Points : 5) classes literals constants variables Question 4.4. (TCO 3) In Visual Basic, which of the following correctly declares a named constant with the name strCOURSE that contains the string value “BIS311”? (Points : 5) Const strCOURSE As String = “BIS311” String Constant strCOURSE = “BIS311” Dim strCOURSE As “BIS311” Const String “BIS311” As......

Words: 1898 - Pages: 8