Final Assessment

Final Exam "OL2" Spring 2014

IFSM 201 –Section XXXX

By typing my signature below, I pledge that this is my own work done in accordance with the UMUC policy on academic dishonesty and plagiarism http://www.umuc.edu/policies/academicpolicies/aa15025.cfm . I have not received or given any unauthorized assistance on this assignment/examination

_____________________________________ (Typed signature represents actual signature)

Instructions: Your responses should demonstrate your understanding of the course content and your analysis and critical thinking; you are not expected to just re-iterate what is in the textbook and the course modules, but to integrate the information and apply it to the specific question. Proper APA style must be used for any citations and references that you use. Place your answers within this document directly below each question (add sufficient space/extra lines as needed) and submit to your UMUC Assignments Folder as an attached MS Word document. This exam is worth 15 points towards the final course grade. Filename: yourlastname Final (example: Brown Final)

1. (15%) Alice and Jonathan are both taking classes but have decided to move to the online format instead of face-to-face. Up to this point they shared a desktop system at home for document prep and used the school’s lab equipment for more advanced software application requirements. They checked e-mail and did additional online activities at work. Now they wish to be able to do all these activities at home. The existing desktop system they used to share has an updated operating system and adequate memory. They have purchased two laptops and want to create a wireless network for their home.

a. Design a wireless network for Alice and Jonathan using their existing desktop and 2 laptops.

b. Describe how they could use the home network.

c. What types of hardware, software, connectivity components, etc., would be required to fully implement the home network?

d. Security issues will need to be considered. What are the risks to their network? What will they need to fully protect their home network?

2. (10%) What is social networking? Define at least two of the privacy issues related to participating on social networking sites? For each issue, describe a real example of how this might happen. What kinds of measures can be taken to guard privacy in the use of such sites?

3. (10%) RAM is a temporary storage space that is used to store program instructions and data.  But accessing RAM is inefficient because a CPU runs faster than RAM.  What special storage space (other than RAM) might a computer access that also temporarily stores program instructions and data?  Describe how this storage space works, where it is located in the computer and how the speed compares with other types of storage such as the RAM or hard drive.

4. (10%) People with severe disabilities can be helped to lead independent self-supportive lives with the use of assistive technologies. Because these special technologies can help them communicate their intentions and effectively control their environment, especially to operate a computer, they may be able to find employment in spite of their physical, mental, or social challenges.

Your textbook in Chapter 5 looks at the future of input and output devices. Pick one of the innovations listed there or from “Many Students Wonder” (bottom of pg. 14 in Module 3 in the OLI classroom) and discuss how this innovation might help someone with a physical, mental or social disability. In your discussion, include a description of the person and the disability (create a scenario), the technology to be implemented, and the specific benefits the technology will provide.

5. (10%) Define the term computer-based information systems. In your definition, discuss three types of information systems, the audience or level of management served by each, and how the systems benefit the organization.

6. (10%) List and describe at least four ways in which processor speed can be increased.

The following short answer questions are worth 3.5% each (total 35% for 10 questions).

7. What happens in an Excel spreadsheet if a cell contains numerical data but the column is too narrow to display the value? How can you correct this?

8. What is conditional formatting with Highlight Cells Rules? Give one example of how this feature can be useful in business.

9. What is the difference between a relative cell reference and an absolute cell reference? When would you make a reference absolute? Provide an example of when you would use an absolute cell reference.

10. Think back to your Excel project--the personal budget. What function would you use to find the largest value stored in the monthly entries—January through December--(not the budget, total or average columns) in your worksheet? How would you enter this function (how would you select it and what might the format look like)?

11. Think about the Excel project and Access database project you completed in this class. Why is each Office application appropriate for the tasks that were part of these projects? Could you have used a spreadsheet to store the data you entered into the database? Could you have used a database to complete your personal budget? Explain your response.

12. It is one hour before the due date/time and you have finished your Access project but take a break before submitting it to the Assignment folder. During the break someone accidentally deletes your database file. What MIGHT you have done which would enable you to recover the project without re-doing all your work?

13. You have added a special video from your own files to your Power Point presentation. You send the presentation to your instructor, but he/she indicates that the video does not play when the slide show is run. What might be the problem?

14. Describe how you would apply slide transitions to your PowerPoint presentation. Discuss what you should consider when using transitions timing options.

15. What is the difference between a "table" in Word and a "table" in Access?

16. UMUC has recently conducted an analysis of the costs versus benefits of replacing WebTycho with a new learning management system. Staff, faculty and students were surveyed about their usage habits and opinions on the subject and ultimately the decision was made to purchase the new learning management system from an external vendor. Which three phases of the SDLC are described here?

Save the exam using the filename yourlastname Final (example: Brown Final) and submit your Completed Exam to your Assignment Folder by the deadline specified on your course syllabus schedule. No late exceptions.