Prepared Exam
Exploring Microsoft Word 2016, Volume 1

  

City of Floma Audit Report

Your skills with Microsoft Word are highly regarded by the partners in the consulting firm that hired you. You are tasked with finishing the 2018 annual audit report for the City of Floma. The audit report has been completed by consultants and the lead consultant wrote an executive summary. You will insert the executive summary in the report, format the report professionally and prepare a mail merge to the city council members that includes a link to the report.

Document Formatting

a. Open w00_cumexam_data and save it as w00_cumexam_LastFirst.

b. Begin by inserting a cover page which serves as the city’s document standard. Choose the Whisp cover page. Type Fiscal Year 2018 Audit Report in the Document title placeholder. Delete the Document subtitle, Date, and Author placeholders. Type Garcia, Yung & Carter, Auditors in the Company name placeholder.

c. Change the document’s color scheme to Yellow Orange.

d. Delete the first two paragraphs on page two.

e. In the blank paragraph under the heading Executive Summary, insert the text from the document w00_cumexam_exec. Delete the blank paragraph above the heading Introduction.

f. Create a header with Fiscal Year 2018 Audit Report centered and City of Floma right aligned. Create a 3 pt bottom paragraph border in Light Yellow, Background 2, Darker 10%.

g. Insert an Accent Bar 1 Bottom of Page page number. Ensure that the header and footer on the first page are different and have no text in them.

h. Modify the line spacing of the Normal style to 1.5. Add a first line indent of 0.3”.

i. Modify the styles Heading 1 and Heading 2 to remove the first line indent.

Organize Data in Tables

j. Insert a blank paragraph at the end of the document. Select the heading Supporting Tables on page three and the table underneath and move them to the bottom of the document. Insert a page break before the heading Supporting Tables.

k. Select the table under the heading Supporting Tables and apply the style No Spacing.

l. Add a table caption below the table with the text Table 1: Overtime analysis. The label Table 1 is added by Word.

m. Apply the Plain Table 3 table style.

n. Replace the hyphen in Full-time in row 1, column 2 with a non-breaking hyphen.

o. Bottom left align the text in row 1, column 1. Bottom right align the text in all but the first column of row 1.

p. Adjust the width of column 1 so that the words Police Department do no break across two lines. Equally distribute the width of the other columns.

q. Merge the cells in columns 1 through 4 in the bottom row of the table. Type the text Total New Hires: (include the colon) in the merged cell. Right-align the text.

r. Insert a formula in row 4, column 5 to calculate the total new hires. Delete the comment left by Carter.

s. Review the document for spelling and grammar errors. Ignore all occurrences of the word Floma.

Improve Document Structure using References

t. Insert a Table of Contents before the heading Executive Summary. Choose Automatic Table 2. Modify the styles TOC 1 and TOC 2 to remove the first line indent.

u. Insert the following Document From Web site citation before the period ending the sentence The data was reviewed in the second paragraph below the heading Introduction:
Corporate Author: U.S. Government Accountability Office
Name of Web Page: Government Auditing Standards: 2011 Revision
Year: 2011
Month: December
Day: 1
URL: http://www.gao.gov/products/GAO-12-331G

Create a Mail Merge to Send the Executive Summary

v. Share the audit report document online and get a link.

w. Open w00_cumexam_letter and save it as w00_cumexam_letter_LastFirst.

x. Paste the link to the audit report document at the end of the line that starts with You may access.

y. Conduct a mail merge using the City of Floma Council Members sheet of the w00_cumexam_council Excel file as the data source.

z. Delete the word Dear on the first line, and then insert a greeting line using the format Dear Mr. Randall. Match the field Courtesy Title to Salutation. Preview the results.

aa. At the end of the letter, add two blank paragraphs. Leave the first blank. Type JoAnna Carter, CPA, insert a line break, and then type Lead Auditor.

bb. Complete the merge of the document producing a new document with four pages. Save the merged document as w00_cumexam_merged_LastFirst.

cc. Save and close all files. Based on your instructor’s directions, submit the following: w00_cumexam_LastFirst (the audit report)
w00_cumexam_letter_LastFirst (the mail merge document)
w00_cumexam_merged_LastFirst (the merged letters)

  

This assessment aims to develop and gauge student understanding of the key topics covered so far by answering the following questions. Answering these questions will help you build some understanding for the next assessment item as well as for the entire subject. It is expected that answers to the assignment questions be succinct (i.e. precise and concise) with all sources of information fully referenced as per APA referencing style. You have to reference the text book and any additional material you have used in your answers.

Note that the guide for APA referencing is provided in the resources section of Interact site of this subject.

Answers MUST be written in your own words. No marks will be awarded for any answer that contains more than 10% direct quote (referenced or unreferenced). One or two sentence answers will be too short and only receive low marks. Answers longer than 1.5 pages (12 point font, single line spacing) may incur a penalty if too much non-relevant information is stated. For mathematical questions it is expected that you show intermediate steps of your working. Just stating the correct solution will result in low marks, on the other hand if the working is correct and you only made minor mistakes, you will still be awarded marks, even though the final answer is wrong.

Question 1 [3 Marks]

Write functions of each layer of OSI reference model, also differentiate between hardware and software layers. Explain your view; why Network layer of OSI model is called Internet layer in TCP/IP networking model?

Question 2 [3 Marks]

Complete the following Hands-On Projects from the prescribed textbook (Pyles, Carel & Tittel 2017)

Hands-On Project 2-3

Hands-On Project 3.2

In order to complete this activity, students should insert screenshots in the assignment document along with a short description of each step taken to complete the project.

Question 3 [4 Marks]

For any data communication, MAC and IP addresses play very important role, explain why these two types of address are important and what critical role ARP protocol plays in this scenario?

Question 4 Case study task [5 Marks]

In your role as a Solutions Architect at Foreshore IT Solutions, you are leading a team of several system administrators. Foreshore IT Solutions is a large organisation and is currently expanding its operations. The company was using six sites across Brisbane to accommodate its various departments. These departments are interconnected by three routers.

Company’s current network is shown as above, which include following departments at various sites:

  

Site

Department

No of Hosts

 

HQ

Sales

16000

  

Marketing

8000

 

BR1

Advertising

2000

  

Online Sales

4000

 

BR2

Product Support

1000

  

Technical Support

500

Recently, company has experienced huge growth in their business, and need to employ more employees who will need more devices (hosts). Company is expecting 40% growth.

You are required to recalculate IP addressing scheme for this network to accommodate 40% growth, for example; Sales department will grow by 6400 hosts. Also provide subnets for inter router connections which should have subnet mask 255.255.255.252

Use network ID 180.XY.0.0/16 (where XY are last digits of your student ID).

TASK – Write a 800 words (+/- 10%) (Max) report explaining:

• The detailed design of a simple addressing solution      (with diagram(s) and step by step workout of the calculations) that      accommodate for growth, is easy to administer and has the minimum wastage      of available IP address space. [3 Marks]
• Provide IP addresses and Subnet Masks for all LAN and      WAN interfaces. [1 Mark]
• Suppose in further future, this company experience more      growth, which leaves company with no option except upgrading this network      from IPv4 to IPv6, investigate/explore the technical changes you may need      to implement for such upgrade

  

FINAL EXAM

ITEC 630- Information Systems Analysis, Modeling, and Design 

This is an open-book individual examination. Save the file with the questions and your answers as PDF (please label the file Final -YourLastName.pdf ), and post it in your Assignments folder before the deadline. All of your answers, including any charts and diagrams, must be included in this one file. The exam is due 11:59 p.m. Eastern Time, Sunday, April 27, 2019 (no late exams will be accepted).  

Problem I – (15 points)

Al Falfa is meet­ing with his large team of systems analysts to decide on the qualifica­tions that their prospective new team member should possess. Al says, “In fact, they were so excited by the possibility of our team helping to move our company, Marathon, into an ecommerce strategy that they’ve said we should start our search now and not wait until the fall.”

Ginger Rute, another analyst, agrees, saying, “As long as the economy is healthy, the demand for Web site developers is far out­stripping the supply. We should move quickly. I think our new person should be knowledgeable in CASE tools, Visual Basic, and JavaScript, just to name a few.”

Al looks surprised at Ginger’s long list of languages, but then replies, “Well, that’s certainly one way we could go. But I would also like to see a person with some business savvy. Most of the people coming out of school will have solid programming skills, but they should know about accounting, inventory, and distribution of goods and services, too.”

The newest member of the systems analysis group, Vita Minn, finally breaks into the discussion. She says, “One of the reasons I chose to come to work with all of you was that I thought we all got along quite well together. Because I had some other opportunities, I looked very carefully at what the atmosphere was here. From what I’ve seen, we’re a friendly group. Let’s be sure to hire someone who has a good personality and who fits in well with us.”

Al concurs, continuing, “Vita’s right. The new person should be able to communicate well with us, and with business clients, too. We are always communicating in some way, through formal presenta­tions, drawing diagrams, or interviewing users. If they understand decision making, it will make their job easier, too. Also, Marathon is interested in integrating ecommerce into the entire business. We need someone who at least grasps the strategic importance of the Web. Page design is such a small part of it.”

Ginger interjects again with a healthy dose of practicality; saying, “Leave that to management. I still say the new person should be a good programmer.” Then she ponders aloud, “I wonder how important UML will be?”

After listening patiently to everyone’s wish list, one of the senior analysts, Cal Siem, speaks up, joking, “We’d better see if Superman is available!”

As the group shares a laugh, Al sees an opportunity to try for some consensus, saying, “We’ve had a chance to hear a number of differ­ent qualifications. Let’s each take a moment and make a list of the qualifications we personally think are essential for the new ecom­merce development person to possess. We’ll share them and continue discussing until we can describe the person in enough detail to turn a description over to the human resources group for processing.” Be specific and explain your reasoning in answering the following questions:

a) What qualifications should the systems analysis team be looking for when hiring their new ecommerce development team member? (3 points)

b) Is it more important to know specific languages or to have an aptitude for picking up languages and software packages quickly? (3 points)

c) What basic busi­ness skills should the new team member have? (3 points)

d) How should the new team member be different from the existing team members in terms of competencies and skills? (2 points) 

e) What personality or character traits are desirable in a systems analyst who will be working in ecommerce development? (4 points)

Problem II – (20 points)

Use the process of normalization to transform the table below into 3NF. Show the tables in 1NF and 2NF that are created in the process.

  

Business ID

Business Name

Business City

Car Model(s)

 

A100

Weird Autos

Galveston

F15, F35

 

B100

Giant Trucks

San Antonio

F15

 

C100

Heavy Wheelers

Dallas

W100

 

A101

Weird Autos

Galveston

F25

Problem III – (15 points)

Draw an entity-relationship diagram for the following situation: A commercial bakery makes many different products. These products include breads, desserts, specialty cakes, and many other baked goods. Ingredients such as flour, spices, and milk are purchased from vendors. Sometimes an ingredient is purchased from a single vendor, and other times an ingredient is purchased from many vendors. The bakery has commercial customers, such as schools and restaurants, and private customers that regularly place orders for baked goods. Each baked good has a baker assistant that oversees the setup of the bakery operation and inspects the finished product that they are responsible for.

Problem IV – (20 points)

White-N-Wheat Bread Company has asked for your help in comparing its present computer system with a new one its board of directors would like to see implemented. Proposed system and present system costs are as follows:

Year  Proposed System Costs   Present System Costs

Year 1

Equipment Lease  $20,000   $21,500

Salaries   40,000    50,000

Overhead   4,000    13,000

Development   21,000    —

Year 2 

Equipment Lease  $20,000   $10,500

Salaries   40,000    60,000

Overhead   1,000    3,300

Development   12,000    —

Year 3

Equipment Lease  $20,000   $10,500

Salaries   36,000    60,000

Overhead   4,900    3,600

Development   —    —

Year 4

Equipment Lease  $20,000   $10,500

Salaries   39,000    66,000

Overhead   5,500    4,000

Development   —    —

a. Using break-even analysis, determine the year in which White-N-Wheat Bread will break even with these two strategies.

b. Graph the costs and show the break-even point.

Problem V – (15 points)

Eat-Ur-Potatoes is a fast-food restaurant offering all kinds of potatoes. The manager has a 30-second time limit for serving customers. Servers at the counter say they could achieve that limit if the form they must fill out and give to the kitchen were simplified. The information from the completed form is entered into the computer system at the end of the day, when the data entry person enters the kind of potato purchased, additional toppings purchased with their quantities, and the price charged. The current form is difficult for servers to visually scan and fill out quickly.

a. Design and draw a form that lists possible potatoes and toppings in a manner that is easy for counter servers and kitchen crew to visually scan, and can also be used as input to the inventory system that is on the extranet connecting Eat-Ur-Potatoes and Idaho potato growers. Choose a size that is sensible and be sure to indicate the size of the form if it is not drawn at full-scale. You may use MS Word to produce this form if you don’t have any other drawing software available. You won’t be judged on the aesthetics of the form, just the content and layout. Be sure to observe the guidelines for good form design.

b. Design and draw a representation of a display screen that can be used by the servers and clerks to fill in the information captured on the form. Again, you may use MS Word for this purpose.

c. Design and draw a display screen based on your screen in part b. This time it should function as a display that shows a kitchen crew member what to prepare for each order. List three changes to the screen in part b that you made to adapt it to function as an output display. You may use MS Word to show the layout of the screen.

Problem VI – (15 points)

As part of a larger systems project, Capital Bank of Nowhere, Colorado, wants your help in setting up a new monthly reporting form for its checking and savings account customers. The president and vice presidents are very attuned to what customers in the community are saying. They think that their customers want a checking account summary that looks like the one offered by the other three banks in town. They are unwilling, however, to commit to that form without a formal summary of customer feedback that supports their decision. Feedback will not be used to change the prototype form in any way. They want you to send a prototype of one form to one group and to send the old form to another group.

a.  In a paragraph discuss why it probably is not worthwhile to prototype the new form under these circumstances.

b. In a second paragraph discuss a situation under which it would be advisable to prototype a new form.

  

University of Maryland University College

ITEC 625 Final Examination

Instructions

1. This Exam is open book and open notes, but it is an individual assignment that is not to be shared.

2. You do NOT need to include the instructions or the questions in your submitted document. You should simply number your answers as a link to the question.

3. Include at least one reference that is APA compliant.

4. Your exam may be run through Turnitin so do not copy and paste.

5. Save the file with your answers as a MS Word file (please NAME the file MidtermYourLastName_First Initial.doc), and post it in your Assignments folder. The exam is due 11:59 p.m. Eastern Time, Sunday, April 27, 2019 (no late exams will be accepted). 

Exam Questions

1) Describe programmed, interrupt driven, and direct memory access. Provide an example of an I/O device for each access method..

2) List, describe, and analyze the most common data storage systems in terms of size, speed, error handling, and cost. 

3) Describe the functional components of an operating system, including kernels, modules, application program interfaces, and other services. 

4) Compare and contrast a desktop operating system with a mobile operating system.

5) Differentiate between the logical and the physical views of file systems. 

6) Describe the functions and purposes of the file directory.

7) Categorize various file protection systems, and provide a few examples from current operating systems.

8) Describe CPU scheduling; how it works and why we need it.

9) Compare an embedded operating system with desktop operating system.

10) If you were going to architect a computer system for a financial analysts, what computer components would you use and why?

 

This assignment starts with the script, “Week6_business_units.sql” . This script should create a table called “business_unit” and a

table called “Product_BU.” Unfortunately, the metadata descriptions have been lost, so you will need to figure out what you can

from the SQL script. The only thing you know about the metadata is that the company runs several individual strategic business

units, such as “On The Go” and “Snack.” Each of these business units is run under an umbrella designation, such as “Growth” or

“Decline.” The company will run marketing for growth products differently than it would run marketing for products on the decline.

Your boss mentions that recently a number of employees have received calls from individuals who didn’t identify themselves and asked a lot of questions about the company and its computer infrastructure. At first, he thought this was just a computer vendor who was trying to sell your company some new product, but no vendor has approached the company. He also says several strange e-mails requesting personal information have been sent to employees, and quite a few people have been seen searching your company’s trash dumpsters for recyclable containers. Your boss asks what you think about all of these strange incidents. Respond and be sure to provide recommendations on what should be done about the various incidents.