BCIS 1305 Fall 2018 - Final Exam Study Guide

This Study Guide is offered to help you prepare for our Final Exam. Our Final Exam will consist of:

• 20 “Multiple Choice/True-False” questions
• 3 Short “Essay” questions

The 20 “Multiple Choice/True-False” will be derived from the following pool of 50 questions. The actual exam questions will not necessarily be worded exactly as the questions you find here.

Microsoft Word

1. What feature must be turned on for you to see paragraph breaks, line breaks, spaces, tabs, and other formatting symbols?
2. Title, Author, Comments, Subject, Company, Created, and Last Modified are examples of what?
3. You want to make it easy for the reader to find related information in another part of your document. What’s the best way to do this?

Windows & File Management

4. To extract a file on a Windows computer you can right-click on the zip file and select which option?
5. Which key do you press to select multiple files that are not adjacent to each other in the file list?

Hardware (Systems Unit and Input/Output)

6. What is the difference between Input and Output?
7. What are the characteristics of the different types of keyboards?
8. How do we determine the size of a monitor (display)?
9. What is another name for the system board?
10. What type of electric current do computers require?
11. What is the system bus?

Microsoft Excel

12. How do we select a subset of cells for printing?
13. What is the difference between “Center Across Selection” and “Merge & Center”In Excel?
14. What are the informational components that are found within the parentheses of an Excel function?
15. What are the similarities and differences between the NOW() and TODAY() functions?
16. What character must always start a formula?
17. What are the differences between Absolute and Relative cell referencing?
18. What advantages does a Chart Style provide?
19. How do Sparklines work?
20. Why would we use a PivotTable?

Privacy, Ethics, and Security

21. What type of program is used to record everything you do on your computer?
22. What are browser “cookies”?
23. What browser feature (or mode) ensures that your browsing activity is not recorded on your hard disk?
24. How does a denial of service (DoS) attack work?
25. How does a dictionary attack work?
26. What is encryption?
27. What is the legal concept that gives content creators the right to control use and distribution of their work?
28. What are the similarities and differences of Identity Theft and Mistaken Identity?
29. How are Biometric Scanning Devices used?

System and Application Software

30. What is the difference between System Software and Application Software?
31. When would you use a Word Processor vs. a Spreadsheet?
32. What are typical examples of application software?
33. What are typical examples of system software?
34. What function does the Operating Software provide?
35. What are the different categories of operating softwares?
36. What is Virtualization?

Microsoft PowerPoint

37. What function and/purpose do Layouts provide?
38. What is a Transition?
39. What is an Animation?
40. What are SmartArt graphics and when would we use them?
41. What is Kiosk-Mode?
42. What is Screencasting?

Databases

43. What is a Table?
44. What is a Record?
45. What are Relationships in a Database?
46. What is a Field?
47. What is a Primary Key Field?
48. What are the different Field Types in Airtable?
49. What are the advantages of using a database?
50. What purpose do Templates serve in Airtable?

Essay Questions

The 3 short “Essay” questions will be taken from the following pool of six questions. The actual exam questions will be worded exactly as the questions you find here.

1. What was your experience in using Slack in our class?
2. Describe the most valuable thing you learned in our class that has changed the way you use technology.
3. How could you use Airtable to help you in your job or as a student today?
4. Describe how a 3D Printer works.
5. How could you use a screencasting software (e.g., Screencast-o-matic.com) to increase your “employability”?
6. How will you update your LinkedIn profile now that you have completed our class?