1 / 78

CIS-250 Final Exam Review

Get ready for your CIS-250 final exam with this comprehensive review guide. Covers IT concepts, Excel and Access material, study tips, and more.

villagomez
Download Presentation

CIS-250 Final Exam Review

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CIS-250Final Exam Review Spring Semester 2019

  2. Before we begin…

  3. The Easy Stuff • When is my Final Exam? • Check the last page of your Course Schedule for details or take a look at the next slide in this presentation • Meet in DA 304 lab at the officially scheduled date/time • What if I have a scheduling issue? • You should have already sent an email to your instructor explaining the nature of the extenuating circumstance • Offer a couple of alternative times when you can take it • Await an email reply from your CIS-250 instructor • DRC students should have a date / time scheduled

  4. Final Exam Schedule

  5. The Easy Stuff • Where do I go? • Davidson Rm 304 (lab) unless otherwise specified • Take MyITLab Capstone Exam on a wired link • How long will it take? • Most students will finish in less than two hours • But, make full use of the entire time - 2.5 hours • What will I need? • Pen or pencil and possibly a basic calculator • instructor will provide you with scratch paper! • Be sure you can access Virtual Lab & Blackboard

  6. The Easy Stuff • Is there a Study Guide? • No, but some guidance was provided in class • REACH published a set of technology terms • And, this presentation has some good stuff • Can I use Microsoft Excel 2016? • Yes, it will definitelyhelp you out! • Remember to copy formulas or values obtained from Excel over to Blackboard in order to avoid typographical errors • You can copy data and any possible answers from the Final Examinto an Excel worksheet CTRL+V

  7. Coverage - I.T. Concepts Stuff • Applies to all CIS-250 sectionsregardless of the instructor or record • Technology in Action (TiA) • Ch 9: Securing Your System • Ch 11: Databases and Information Systems • Review the sub-folder at the bottom of the Course Documents folder for additional study information, including terms document created by REACH/CRC

  8. Coverage - ExcelStuff • Excel 2016 material will be cumulative • Be sure to complete all of the Sample Tests • Final Exam will be taken via Blackboard • Excel Ch 1-4 Capstone Exam in MyITLab • Does not include PivotTables (Ch 5) • Will take at least an hour to complete • Many Excel questions will be “recycled” from prior Quizzes, Tests, and Assignments

  9. Coverage - AccessStuff • Access 2016 material is cumulative, but will largely be conceptual rather than practical application • Access • Introduction to Access (Ch 1) • Tables and Queries (Ch 2) • Forms and Reports (Ch 4) Check Assignment the Due Dates worksheet for the due dates/times of all remaining assignments and assessments in Blackboard and MyITLab

  10. Coverage - Extra Credit • Follow specific guidance from your instructor: • Will likely include a few questions fromTiA Appendix B: Careers in I.T. • Also a couple of challenging Excel problems • Possibly some others from in-class discussions • Worth up to 10 additional points on Final Exam

  11. Study Tips • Most of these tips are from students who have scored well on previous CIS-250 assessments • Organize all of your study material, including the textbooks, presentation slides, lecture notes, study guides, any other references • If you choose to study in a group, only study with others who are serious about the test • Don't study any later than the time that you usually check for light leaks in the eyelids

  12. Study Tips • Find a quiet and comfortable place to study, with good lighting and few distractions • Create a study plan with specific time blocks - start out by studying the most important info • Make sure that you understand the material, don't just try to memorize everything • Don’t wait until the last day or two to study, but rather spread the time over a few days since you will learn more than cramming CRAM

  13. Study Tips

  14. Study Priorities

  15. What to Expect • Excel material will cover basic concepts and functions through more advanced topics (filtering, sorting, Pivots) • Format will be very similar to Tests 2 & 3, with the degree of difficulty between Test 1 & Tests 2 & 3 • Many of the Excel questions will be variations of what you have seen on previous Tests and Quizzes • Most of the questions are likely to be multiple choice, true/false, matching, and fill-in-the-blank • Total number of questions is estimated between 70-90, depending on instructor and use of fill in multiple blank

  16. Blackboard Reminders • Open a browser window using ChromeorFirefox • Use Excel, but not Respondus LockDown Browser • May be one or two parts depending on instructor • Read all instructions thoroughly before you begin • Find an easy question, answer it, then Save once • Use Edit > Find in browser to search for terms • Definitely make use of Microsoft Excel 2016 • Consider using split windows to stack side-by-side • Right click, then left click to enter formulas or values • Let instructor know immediately about any issues

  17. Test-Taking Tips • Read the test directions and the wording for each question carefully to avoid careless errors (not to mention costly points!) • Take note of underlined, bold or italicized text and key words that will help you solve problem • Answer the easy questions on the first pass to build confidence, accrue points, and orient yourself to the test format and content • Focus on Excel or TiAonly on the initial pass • Skip past any questions that you can’t answer • Avoid spending more than a few seconds on each

  18. Test-Taking Tips • On the second pass, answer the set of remaining questions that you didn’t answer on the initial pass • Focus on those that have higher points values • Avoid spending more than a minute on any one • Be sure to leave at least 10 minutes to make a final pass on the Final Exam • Eliminate those answers you know are either incorrect or don’t appear to match the question at hand • Take a best guess on any unanswered questions • Be careful guessing more than once on any questions that use the multiple answer format

  19. Test-Taking Tips • Resist the urge to leave the lab as soon as you finish • Make sure you have answered all of the questions • Carefully examine all formulas to ensure you did not make any mistakes with commas, parenthesis, quote marks, equal signs, etc. • Only change your original answer to a given question if you either: • Clearly made a mistake • Misread the question • Found a useful piece of information elsewhere

  20. Excel - Common Issues • Read problem before you start clicking or typing answer • Differentiate cell display from the actual contents • Be careful with cell references - absolute, relative, and mixed (column vs. row) • Don’t forget to begin all formulas with an equal sign ('=‘) • Watch parenthesis, commas, and dollar signs • Be sure you put your answer in the proper format • Students leave a few questions unanswered - take a “best guess” for possible credit if you don’t know

  21. Excel - Nested IF Functions • Read problem thoroughly • Look for key words (all, either, and, or, not, etc.) • Determine how many rules are specified (n-1) • Solve in sequence or specify low and high first • Use paired quotation marks for all text strings • Be careful with commas and new arguments • Ensure that parenthesis are properly balanced • Count open (L => R) and then close (R => L) to ensure the number of each matches identically • Then look at the positioning from an inside-out perspective for proper balancing

  22. Excel - Nested IF Functions • To debug a given formula: • Click on formula bar and take a look at the colors • Use the powerful Evaluate Formula feature in Excel to fully explore the execution steps performed • More useful Web references for specifically for IF and nested IF functions: • http://www.excelfunctions.net/excel-nested-if.html • http://www.techonthenet.com/excel/formulas/if_nested.php • https://www.youtube.com/watch?v=gYxpnmjoQds • https://www.youtube.com/watch?v=SONKJaUEDpI • https://www.youtube.com/watch?v=CZmeTkkrGg4

  23. Final Exam - Details • MyITLab features a Capstone Exam (Excel Ch 1-4) • It’s a “take home” test that will take about an hour • Worth 100 points towards final score in MyITLab • Avoid wireless access and use a high-speed link • Blackboard portion combines Database Conceptsquestions with problem-solving in Microsoft Exceland more than a dozen Access 2016 questions • It’s worth 150 points towards your final grade • Expect about 60-90 questions total (about 2 hrs) • Again, plan to stay the entire time that is allotted!

  24. Final Exam - Details • Estimated breakdown by content: • Information Security (about a 12-15 questions) • Excel (around 20 questions) - several will be Fill in the Blank • Many of these will be variations of commonly-missed questions from past Tests and Quizzes this semester • Database Concepts (around 15-20 questions) • Access (around 15 questions) • Many of these will be commonly-missed questions • Extra Credit (several questions) - worth up to 10 points • Your instructor will give you specific guidance • Likely a couple more challenging Excel questions • Still working on questions for Final Exam - please send your instructor some for consideration!!!

  25. Any Questions

  26. Practice Question #1 • At Dale's Discount Department Store in Looneyville, the owner sells the furniture at twice the wholesale cost plus $100 to cover shipping, handling, and delivery per order. Assume that a customer purchases a leather sofa and a matching love seat from Dale's which have wholesale costs of $400 and $250, respectively. In turn, they successfully bargain with Dale and obtain a discount of 20% off the retail price for these items. All customers must then pay a sales tax of five percent (5%) on this sub-total, excluding the delivery fee, which should not be taxed in the State of Confusion in which they currently live. What is the final price that you will pay for the matching sofa and love seat, delivered to their home?

  27. Practice Question #1 • At Dale's Discount Department Store in Looneyville, the owner sells the furniture at twice the wholesale cost plus $100 to cover shipping, handling, and delivery per order. Assume that a customer purchases a leather sofa and a matching love seat from Dale's which have wholesale costs of $400 and $250, respectively. In turn, they successfully bargain with Dale and obtain a discount of 20% off the retail price for these items. All customers must then pay a sales tax of five percent (5%) on this sub-total, excluding the delivery fee, which should not be taxed in the State of Confusion in which they currently live. What is the final price that you will pay for the matching sofa and love seat, delivered to their home? Answer: $1192

  28. Practice Question #2 Assume that office space on the northeast side of Louisville costs $40 per sq. ft. per month to lease. Create a formula that will determine the lease expense for the first year on a 5,000 sqft floor of an office building?

  29. Practice Question #2 •  Assume that office space on the northeast side of Louisville costs $40 per sq. ft. per month to lease. Create a formula that will determine the lease expense for the first year on a 5,000 sqft floor of an office building? • Answer: • =40*12*5000

  30. Practice Question #3 The Body Mass Index (BMI) is often used by health care professionals to determine whether a person is overweight or underweight. The BMI is calculated using the following sequence of steps: 1) Multiply the person's body weight in pounds by 0.45. 2) Multiply the person's height in inches by 0.025. 3) Square the answer from Step 2. 4) Divide the answer from Step 1 by the answer to Step 3. 5) Round the result of Step 4 to the nearest whole number. Determine the BMI of a person with a weight of 225 pounds and a height of precisely six feet three inches to the nearest whole number and then enter the resulting two-digitvalue into the answer space below.

  31. Practice Question #3 The Body Mass Index (BMI) is often used by health care professionals to determine whether a person is overweight or underweight. The BMI is calculated using the following sequence of steps: 1) Multiply the person's body weight in pounds by 0.45. 2) Multiply the person's height in inches by 0.025. 3) Square the answer from Step 2. 4) Divide the answer from Step 1 by the answer to Step 3. 5) Round the result of Step 4 to the nearest whole number. Determine the BMI of a person with a weight of 225 pounds and a height of precisely six feet three inches to the nearest whole number and then enter the resulting two-digitvalue into the answer space below. Answer: 29

  32. Practice Question #4 • The Cardinal Internet Cafe awards Bonus Dollars to customers based on total monthly expenditures at the cafe. The Bonus structure is as follows: A Level 1 Super Bonus of 5% applies if monthly totals are greater than $75 but less than $120. Cell K19. • A Level 2 Super Bonus of 10% applies if the monthly total is at least $120. Cell K20. • Refer to the accompanying image and then respond to the following question: • What formula should be placed in cell I12 and then copied down the column to properly calculate the appropriate Super Bonus for the customers?

  33. Practice Question #4 • The Cardinal Internet Cafe awards Bonus Dollars to customers based on total monthly expenditures at the cafe. The Bonus structure is as follows: A Level 1 Super Bonus of 5% applies if monthly totals are greater than $75 but less than $120. Cell K19. • A Level 2 Super Bonus of 10% applies if the monthly total is at least $120. Cell K20. • Refer to the accompanying image and then respond to the following question: • What formula should be placed in cell I12 and then copied down the column to properly calculate the appropriate Super Bonus for the customers? Answer =IF(G12>=120,G12*$K$20,IF(G12>75,G12*$K$19,0)

  34. Question #5 Closely examine the accompanying worksheet image. What formula was used in cell E3, which is then copied down the column, to determine (specifically with a Boolean TRUE or FALSE result - not a text string) if a specific item was within the stated budget amount?

  35. Question #5 Closely examine the accompanying worksheet image. What formula was used in cell E3, which is then copied down the column, to determine (specifically with a Boolean TRUE or FALSE result - not a text string) if a specific item was within the stated budget amount? Answers: =D3<=C3 =C3>=D3 =IF(D3<=C3,TRUE,FALSE)

  36. Question #6 An interstate tollway plaza is offering a discount on all fuel pumped based on the total quantity purchased. Which of the formulas below calculates the correct total price to charge a customer for the fuel they have pumped based on the following conditions: no discount (zero dollars off the total amount due) if a person purchases less than 20 gallons of fuel a 3% discount on all fuel purchased if the person dispenses at least 20 gallons of fuel into their tankAssume that cell A1 shows the total quantity (in gallons) of fuel purchased and cell B1 is the price per gallon. The correct formula will calculate the total amount that a person should pay, after the discount (if any) has been applied. • =A1*B1*IF(A1<20, 1, 0.97) • =IF(A1<20, A1*B1, A1*B1*3%) • =IF(A1>=20, A1*B1*3%, A1*B1) • =A1*IF(A1<=20, B1, B1*0.97)

  37. Question #6 An interstate tollway plaza is offering a discount on all fuel pumped based on the total quantity purchased. Which of the formulas below calculates the correct total price to charge a customer for the fuel they have pumped based on the following conditions: no discount (zero dollars off the total amount due) if a person purchases less than 20 gallons of fuel a 3% discount on all fuel purchased if the person dispenses at least 20 gallons of fuel into their tankAssume that cell A1 shows the total quantity (in gallons) of fuel purchased and cell B1 is the price per gallon. The correct formula will calculate the total amount that a person should pay, after the discount (if any) has been applied. • =A1*B1*IF(A1<20, 1, 0.97) • =IF(A1<20, A1*B1, A1*B1*3%) • =IF(A1>=20, A1*B1*3%, A1*B1) • =A1*IF(A1<=20, B1, B1*0.97)

  38. Question #7 • Review the accompanying spreadsheet image below. In cells C5:C14 of this worksheet, you have a column containing the total number of cases of Mountain Dew sold for each fiscal year in a local convenience store. In column D, you want to keep a running total of these sales, starting with 1998. What formula should be placed in cell D5 that will show the correct running total for the entire column?  (select two answers)   1) =SUM($C$5:$C$5) 2) =SUM($C5+$D4) 3) =$C5+$D4 4) =SUM(C$5:$C5) 5) =SUM($D4,$C5) 6) =SUM(C$5,D$4

  39. Question #7 • Review the accompanying spreadsheet image below. In cells C5:C14 of this worksheet, you have a column containing the total number of cases of Mountain Dew sold for each fiscal year in a local convenience store. In column D, you want to keep a running total of these sales, starting with 1998. What formula should be placed in cell D5 that will show the correct running total for the entire column?  (select two answers)   1) =SUM($C$5:$C$5) 2) =SUM($C5+$D4) 3) =$C5+$D4 4) =SUM(C$5:$C5) 5) =SUM($D4,$C5) 6) =SUM(C$5,D$4

  40. Question #8 Review the spreadsheet template below and closely examine the table of names for property owners and the respective value of their principal residence. (2 points each) A) What formula can be used to determine the value of the fourth most expensive home in the list? B) If the result of the formula above was placed in cell A16, what formula would you use to round that specific cell reference to the nearest ten thousand dollars?

  41. Question #8 Review the spreadsheet template below and closely examine the table of names for property owners and the respective value of their principal residence. (2 points each) A) What formula can be used to determine the value of the fourth most expensive home in the list? B) If the result of the formula above was placed in cell A16, what formula would you use to round that specific cell reference to the nearest ten thousand dollars? Part A: =LARGE(A3:A15,4) Part B: =ROUND(A16,-4)

  42. Question #9 Which of the following is the result of the formula: =NOT(B3<>C3) where cell B3 contains the current date and cell C3 contains your date of birth? • TRUE • Selected • FALSE • #NUM! • #VALUE! • syntax error

  43. Question #9 Which of the following is the result of the formula: =NOT(B3<>C3) where cell B3 contains the current date and cell C3 contains your date of birth? • TRUE • Selected • FALSE←← • #NUM! • #VALUE! • syntax error

  44. Question #10 • Read each of the following questions and provide a response in the format requested.  (1 point each)A) What is the calendar date represented by serial number 24680 in a given worksheet? [PartA]B) What is the internal serialnumber assigned for the date that is exactly 999 days in the future from New Year's Day of 2020? [PartB]C) What day of the week was President Obama supposedly born on? (Hint: His birth date was August 4, 1961.) [PartC]

  45. Question #10 • Read each of the following questions and provide a response in the format requested.  (1 point each)A) What is the calendar date represented by serial number 24680 in a given worksheet?B) What is the internal serialnumber assigned for the date that is exactly 999 days in the future from New Year's Day of 2020?C) What day of the week was President Obama supposedly born on? (Hint: His birth date was August 4, 1961.) • 7/27/67; July 27th, 1967; etc….. • 44830 • Friday

  46. Question 11 A customer applies for a 30-year mortgage at their employer-sponsored credit union, which offers borrowing terms based on the customer's "FICO" (which has been set-up as a defined name in a worksheet) credit score. Write a formula to determine the rate an applicant is charged based on the four conditions stated. The formula should also output the text "Denied" if the applicant doesn't qualify for credit. Mortgage application "denied" if score is less than 600 Interest rate of 6% if score is 600-699 Interest rate of 5% if score is 700-799 Interest rate of 4% if score is 800 or more

  47. Question 11 A customer applies for a 30-year mortgage at their employer-sponsored credit union, which offers borrowing terms based on the customer's "FICO" (which has been set-up as a defined name in a worksheet) credit score. Write a formula to determine the rate an applicant is charged based on the four conditions stated. The formula should also output the text "Denied" if the applicant doesn't qualify for credit. Mortgage application "denied" if score is less than 600 Interest rate of 6% if score is 600-699 Interest rate of 5% if score is 700-799 Interest rate of 4% if score is 800 or more Answer: =IF(FICO>=800,4%,IF(FICO>=700,5%,IF(FICO>=600,6%,"Denied")))

  48. Question #12 Review the accompanying worksheet image containing employee information and then provide an answer in the blank space below. Salespeople who have been employed for more than six years and have annual sales of more than $22,000 are to be assigned a job level code of 2. All other employees should be assigned a job level code of 1. Using two different logical functions (AND, OR, NOT, IF - not nested IF statements), create a formula in cell E2 that will assign an appropriate job level for Linda. The formula must then be copied down the entire column so that it will work for all of the other employees.

  49. Question #12 Review the accompanying workheet image containing employee information and then provide an answer in the blank space below. Salespeople who have been employed for more than six years and have annual sales of more than $22,000 are to be assigned a job level code of 2. All other employees should be assigned a job level code of 1. Using two different logical functions (AND, OR, NOT, IF - not nested IF statements), create a formula in cell E2 that will assign an appropriate job level for Linda. The formula must then be copied down the entire column so that it will work for all of the other employees. Answer=IF(AND(C2>22000,D2>6),2,1)

  50. Question #13 Employees of the city of Mayberry are eligilble to retire if they have at least 30 years of service, regardless of age. They are also eligible to retire when they reach at least 65 years of age, regardless of years of service. What formula should go in cell D3, to be copied down the column, to display "Yes" if eligible to retire and "No" if not.  The quotes should not display.  Hint: You will need to use a IF function as well as another logical function within thelogical_test.

More Related