1 / 69

THIS

THIS. IS. JEPARTY. Your. With. Host. Hayley. Social & Ethical Issues. Database Vocabulary. Bonus Vocabulary. Area of Impact. Spreadsheet Vocabulary. Bonus Vocabulary. 100. 100. 100. 100. 100. 100. 200. 200. 200. 200. 200. 200. 300. 300. 300. 300. 300. 300. 400. 400.

kaia
Download Presentation

THIS

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. THIS IS JEPARTY

  2. Your With Host... Hayley

  3. Social & Ethical Issues Database Vocabulary Bonus Vocabulary Area of Impact Spreadsheet Vocabulary Bonus Vocabulary 100 100 100 100 100 100 200 200 200 200 200 200 300 300 300 300 300 300 400 400 400 400 400 400 500 500 500 500 500 500

  4. to make a request for information from a database A 100

  5. What is a Query? A 100

  6. a collection of programs that enables you to store, modify, and extract information from a database A 200

  7. What is a Database Management System (DMS) A 200

  8. a feature supported by many word processors that enables you to generate form letters A 300

  9. What is Mail Merge? A 300

  10. contains all the information about • a single 'member' of a table; • similar to a row in spreadsheets A 400

  11. What is a Record? A 400

  12. a space allocated for a particular item of information; similar to a column in spreadsheets A 500

  13. What is a Field? A 500

  14. - a set of instructions that can be triggered by a keyboard shortcut, toolbar button or an icon in a spreadsheet • - used to eliminate the need to repeat the steps of common tasks over and over B 100

  15. What is a Macro? B 100

  16. provides better testing and documentation of individual spreadsheets in less time B 200

  17. What is Validation? B 200

  18. “What if I worked this number of hours versus that number in a week, how much would I earn?" is an example of this excel function. B 300

  19. What is a “What If” question? B 300

  20. consists of many worksheets containing related information B 400

  21. What is a Workbook? B 400

  22. an excel function used when you know what answer you want but do not know the exact figure to input for that answer B 500

  23. What is “Goal Seek”? B 500

  24. Janie is a secretary at the local doctor’s office. The office is doing what they can to catch up with technology and switching all the patient’s records over to digital records. What are the possible social and ethical issues involved with this situation that might raise concern among patients? C 100

  25. Integrity of the data that Janie transferred into the digital copy C 100

  26. Referring back to Janie’s situation, what are possible positive outcomes to this switch over? C 200

  27. a. Updating data will faster and easier • b. Costs of paper will decrease • c. Easier and cheaper to transport a patient’s data from one doctor’s office to another • d. Able to utilize charts and graphs to recognize patterns in their patient data C 200

  28. The president of a security company wants to compare the data stored in his spreadsheets. Specifically, he wants compare the past three month’s sales. What is the best way to allow the user to see clearly the comparison of the data? C 300

  29. PivotTable/Chart/Graph C 300

  30. What is one way Security/Integrity/Authenticity issues can be avoided within spreadsheets? C 400

  31. Excel provides its users with the option of setting a password for a workbook. This is one simple option. C 400

  32. If a password is set for an excel sheet, does this also improve the reliability of the workbook? True or False? C 400

  33. True, having a password will allow the user to be sure that only authorized personnel can access it. This, in turn, assures that the information will be reliable. C 500

  34. A major security company needs to search their files for a large buyer they provide services to. They want to use the function of digging through and analyzing enormous sets of data and then extracting the meaning of the data. What is this process called? C 500

  35. Data Logging D 100

  36. What is the name of the function that consists of a function within a function? D 100

  37. Nested Function D 200

  38. This reference has a $ before the column portion of the reference and/or the row portion of the reference. Its main feature is that it does not change when a formula or function is copied and pasted to other cells. D 200

  39. Absolute Reference D 300

  40. This consists of the column letter and row number that intersect at the cell's location D 300

  41. What is a Relative Reference? D 400

  42. This feature in Excel allows the user to specify the exact range of cells to print D 400

  43. Set Print Area D 500

  44. Correct Response Five D D 500

  45. What is a way databases and spreadsheets are affecting the area of health? Give an example. E 100

  46. Ex. Allows doctor’s offices to transfer all paper documents and records into an organizational “digital file cabinet.” E 100

  47. What is a way databases and spreadsheets are affecting the area of politics and government? Give one example. E 200

  48. Allows the poll worker’s to keep each voter’s information in digital form rather than on paper. E 200

  49. What is a way databases and spreadsheets are affecting the area of science and the environment? Give one example E 300

More Related