COMP230 Final Exam

1. (TCO 1) The Windows CLI shell command that is used to display all of the environmental variables and their values is _____. (Points : 5)

2. (TCO 1) Which one of the following Windows AT commands specifies an action that will take place at 3:00 p.m.? (Points : 5)

3. (TCO 1) The Windows CLI command that is used to display the search path for the executable files is _____. (Points : 5)

4. (TCO 1) The Windows CLI command that is used to display the extensions recognized as executable files is _____. (Points : 5)

5. (TCO 2) What is the assignment operator? (Points : 5)

6. (TCO 2) What is the division operator? (Points : 5)

7. (TCO 2) The value of a string constant will _____. (Points : 5)

8. (TCO 2) What is an example of a string constant? (Points : 5)

9. (TCO 2) What is the multiplication operator? (Points : 5)

10. (TCO 6) The following VBScript statement will open a text file

11. (TCO 6) The following VBScript statement will open a text file

12. (TCO 6) The following VBScript statement will open a text file.

13. (TCO 7) The questioning that causes extraction of data from a relational database is known as _____. (Points : 5)

14. (TCO 7) Which one of the following is a correct SELECT clause in a VBScript program for selecting the fields: FirstName and LastName and Age? (Points : 5)

15. (TCO 7) In a VBScript SQL Query statement, what Boolean operator can be used to test a set of conditions whereby all conditions must be true? (Points : 5)

16. (TCO 7) Which field would be suitable as a primary key in a table that contains employee records? (Points : 5)

1. (TCO 5) Intermediate values that are not inputted or displayed should be stored in _____ variables. (Points : 5)

2. (TCO 5) What variable scope will not interfere with other variables of the same name? (Points : 5)

3. (TCO 3) Which of the following is a possible value for a Boolean expression? (Points : 5)

4. (TCO 3) What produces the same result as the following pseudocode?

5. (TCO 3) What VBScript Boolean operator could be used to combine the following decision-making structure into a single If/Then structure? (Points : 5)

6. (TCO 3) Every decision you make in a computer program involves evaluating one or more _____ expression(s). (Points : 5)

7. (TCO 3) What characters can be used to force operator precedence? (Points : 5)

8. (TCO 4) A loop within another loop is imbedded is known as a(n) _____ loop. (Points : 5)

9. (TCO 4) What is the term used to represent individual items in an array? (Points : 5)

10. (TCO 4) The value of array subscripts are always ____. (Points : 5)

11. (TCO 4) What is the term for the numbers used inside parentheses to reference an array element? (Points : 5)

12. (TCO 4) A VBScript array stores a _____ in memory. (Points : 5)

13. (TCO 1) Write the Windows CLI command that will map the network share called PublicData on FileServer1 to the X: drive for the user netuser with a password of netpass. (Points : 10)

14. (TCO 1) Write the NETSH command that will set the IP address of the interface name “NIC” to 192.168.100.10 255.255.255.0 with a default-gateway of 192.168.100.1 and a metric of 1. (Points : 10)

1. (TCO 2) Give the order of precedence for all of the arithmetic operators and the parentheses.(Points : 10)

2. (TCO 3) Given the variables hoursWorked and payRate, write the VBScript code that will calculate grossPay such that all hoursWorked above 40 hours will be paid at time and a half.

3. (TCO 7) Assuming that you are connected to a database table called Computers with the fields Computer, Hostname Room_Num, CPU_Type, Num_CPUs, Bit_Size, Speed, OS_Type, Memory, and HDD_Size. write the SQL Query String sqlStr such that all the fields will be displayed for the records that indicate a speed greater than 2 and a memory value greater than 4. The returned records should be sorted by OS_Type. (Points : 10)

4. (TCO 5) Write a VBScript function called Average(num1,num2) that accepts two numbers and returns the average value of the two numbers.(Points : 10)

MGMT520 Final Exam NEW

1.Farmer Joe Andrews, who owned 350 acres of farm land, was approached by Ajax Oil Company that offered to buy the front 30 acres of his land, which bordered on a four-lane highway, so they could build a gasoline station. Ajax Oil asked Mr. Andrews if he had complete ownership of the land, and he assured them he did. The two parties negotiated on the price and terms of the land sale for several days and finally agreed on a price of $60,000 for the 30 acres and Mr. Andrews signed a Quit Claim Deed transferring ownership to Ajax Oil. Ajax Oil developed the land and built the gasoline station with a typical small grocery store, and a car wash. The gasoline station functioned well for the next eight years, and was very profitable. The State Highway Department contacted Ajax Oil, and told them the state had acquired the right to take the land 30 years ago for expansion of the highway through a Special Warranty Deed from farmer James Barnes, who had owned and operated the farm before Joe Andrews. The issue quickly goes to court with the State Highway Department, Ajax Oil, farmer Joe Andrews, and farmer Barnes’ Heirs, all parties to the legal activity. What issues are involved here in regard transfer of right to land? Who do you think will prevail? (Points : 30)

2.ABC Computers is a manufacturer and seller of personal computers and tablets. ABC entered into agreements with suppliers requiring that such suppliers not sell ABC’s computers below ABC’s suggested minimum retail price and in return, ABC would not sell its products at retail prices in the store owners' territories. ABC decided not to sell any more computers unless an additional software package was purchased. A competitor informed the Office of the Attorney General of this policy, asserting it was illegal. Additionally, the new model of ABC’s computer has caught on fire, causing injuries to consumers. Explain what ABC should do to protect consumers. Also consider whether there have been any violations under the antitrust and related laws and the governmental agencies involved in these types of cases.

3.Prior to the 1935 Case of “McPhearson v. Buick Motors”, manufacturers had little or no liability exposure for malfunctions of their products that lead to injuries or death to individuals from said product failure. What was the specific problem associated with this new Buick Automobile, and what two alternative legal claims did Buick Motors direct Mr. MacPhearson to pursue as opposed to his claim against them? What specific legal liability regarding manufactured products developed from this case, and what is its lasting effect in today’s world of consumer products? (Points : 30)

4.A large old brick building is being torn-down by a large well known contractor, and the bricks are just being thrown in a ditch by the road, apparently for disposal. A builder of small brick buildings on the outskirts of town notices two teenagers sitting in a large pickup truck, eating lunch, and watching the bricks being thrown into the ditch. The builder walks up to the teenagers and says, “if you guys will gather up those bricks being thrown in the ditch, put them in your truck, and deliver to my construction site at 1240 Oak Street, I will give you 6 cents a piece for the bricks”. The teenagers just smile and keep on eating their lunch. The builder leaves and goes back to 1240 Oak Street, where his crew is assembling a small brick building. At 4:00 PM that afternoon, the two teenagers drive up to 1240 Oak Street with their pickup truck loaded with bricks. They go up to the builder and say, “okay we are delivering 8,000 bricks, so at 6 cents per brick, you owe us $480”. The builder laughs and says, “I don’t really need them, you should just take them back and dump them in the ditch”. Do you think the teenagers have a contractual claim against the builder that they can recover on in court? How should they proceed? (Points : 30)

5. Johnson Manufacturing is a publicly held corporation that burns coal to power its plant. Johnson’s received notice today of an immediate rule change by the EPA requiring all coal burning plants to reduce their emissions by 10%. Implementing the technology to comply with this regulation would cost Johnson’s millions of dollars and could put them out of business. The CEO knows that the current emissions standards have been proven safe and acceptable but cannot find any research supporting the new standard.

6. The Federal Government’s prosecution and eventual dissolution of the Standard Oil Trust under the 1890 Sherman Act before the Supreme Court in 1911 was the dominate example of antirust litigation in this country for almost 100 years. The only other Federal attack on a business as a dominate Monopoly to approach the importance of the Standard Oil Trust case was the United States v. Microsoft Corporation case, which was originally filed in 1999 by President Bill Clinton and his Attorney General Janet Reno. The Microsoft Case was resolved at the U.S. Circuit Court of Appeals in 2001 by President George W. Bush and Attorney General John Ashcroft. What was the basis, Federal Statute, for the original complaint against Microsoft? What was the basis of the specific complaint the Federal Government filed against Microsoft? What was the final result of the case, and the lasting impact on the software/computer industry? (Points : 30)

7. Given that only 12 percent of the Business Organizations functioning in the United States are Corporations, what factors of business characteristics and operations result in Corporations generating 89 percent of business revenue? (Points : 30)

8. After Justin graduated from college, he was hired by one of the largest ad agencies in the city. His first assignment involves working on the Budget Burger account. Budget Burger is owned by the daughter of the president of the ad agency (Mr. Johnson) and has three locations throughout the city. Justin’s assignment was to design T-shirts with a catchy slogan to be handed out for free at all Budget Burger locations to celebrate the grand opening of Budget Burger’s fourth location. The T-shirts said “Done your way!” Due to a lack of time, the normal approval process was skipped and the T-shirts were printed and rushed to the Budget Burger locations. Over two thousand T-shirts were handed out the day of the grand opening. The president of the ad agency doesn’t have a chance to see the T-shirts until the end of the day when he notices the customers wearing them. He is furious because their largest account is Burger King and fires Justin on the spot, and calls the head of the legal department to set up an emergency meeting. (Part 1) (10 points) Identify and apply an ethical theory from chapter 8 of our text that you think the ad agency should have applied to this situation with Justin. What should the ad agency do next based upon your analysis? (Part 2) (10 points) Identify and apply a theory of employment law the ad agency could use to justify firing Justin. Do you think it would be successful? Why or why not? (Part 3) (10 points) Identify and apply an intellectual property law theory Burger King could use if it decided to sue the ad agency. Would the theory you chose be successful? Why or why not?(Points : 40)

NETW589 Final Exam New

Final Exam Page 1

1. (TCO A) What is a Barker code? (Points : 25)

2. (TCO A) One common method used in spread spectrum transmissions is frequency hopping. Describe how FHSS works and how it mitigates interference. (Points : 25)

3. (TCO B) Describe how Code Division Multiple Access (CDMA) works. (Points : 25)

4. (TCO B) Explain the differences between the following three types of data flow: simplex, half-duplex, and full-duplex transmission. (Points : 25)

5. (TCO C) Which security standard is compatible with the 802.11i standard and which ones are not? (Points : 10)

6. (TCO C) What are the three generations of wireless security? (Points : 10)

7. (TCO C) What are the primary components of a WLAN? (Points : 10)

8. (TCO C) Describe two attacks commonly used to compromise WLANs. (Points : 10)

9. (TCO C) What frequency band does 802.11a use? (Points : 10)

1. (TCO D) Is WiMax a standard or proprietary? If a standard, which one? (Points : 15)

2. (TCO D) LMDS operates over what frequencies? (Points : 15)

3. (TCO E) What is the main problem with using GEO satellites for data links? (Points : 15)

4. (TCO E) Digital cellular telephones can be used for what common applications? List and explain five of these. (Points : 25)

5. (TCO F) One class of active tags is called "beacons." What does a beacon do? (Points : 15)

6. (TCO F) What are the constraints on the "read distance" of a tag? (Points : 25)

7. (TCO G) AMPS operates in what frequency range? (Points : 15)

8. (TCO G) Discuss three strategic business advantages to wireless systems. (Points : 25)

BIS 155 Final Exam New

1. (TCO 1) Create a payment account for the employees in a supermarket. To do this maintain a record of the employees information, department, wages and include the number of hours of work invested by them individually. Additionally include the wages per hour to calculate the total daily wages of each worker. Perform the following tasks:

Part 1. Describe how to create an Excel workbook for payroll showing employee name, department, number of hours of work for a week taking into account regular hour and overtime hours (paying one and a half time of salary rate and double the rate for more than 55 hours of work (use appropiate formulas for calculations).

Part 2. Describe how to calculate the total wasges for each employee and grand total for all employees using Excel formulas.

Part 3. Describe how to sort the list in descending order of the total wages.

Part 4. Describe how to apply the concept of 3R's in your worksheet.

Part 5. Describe how to create a chart showing the wages per department.

(Points 40)

Question 2. 2. (TCO 3) A retail chain keeps daily data with summaries of the dollar amounts of sales for each of 151 different products sold at 23 retail stores. The daily data is tracked by product and by store. At the end of the day each store sends its data to the sales manager at the corporate office. The data is sent in an Excel spreadsheet. Describe a data consolidation strategy and at least two different types of visualization techniques the sales manager can use to analyze the data received from all stores. Be sure to include formulas that are to be used in the Excel spreadsheet. (Points : 40)

Question 3. 3. (TCO 4) You are an event planner for a large global company. You have been asked to prepare a report on the best time of year to visit one of three different cities: Rome, Miami, and Honolulu. You have researched their temperatures for the entire year and obtained them on a daily basis. You have decided to find the two week period during the year when the temperatures average 72 degrees. Explain in detail how you would develop a spreadsheet to find the average two week temperature and arrange the data so that the two weeks period most close to 72 degrees are presented for each city in the appropriate table. (Points : 40)

Question 4.4 (TCO 5) Michael and Sally own 89 ice shops across the southeastern United States. In efforts to manage sales data collected from these ice cream shops, Michael and Sally currently have several workbooks developed with the same purpose and structure but with so much information, Michael and Sally need help consolidating this data for more efficient decision making. Given the needs of Michael and Sally, describe in detail how you would explain to Michael and Sally how to use Excel to develop and produce summary reports with consolidated sales data displaying periods of weekly, monthly, and quarterly reports along with visual options to trend and compare data across all ice cream shops. Be sure to include sample Excel formulas. Also, explain in detail the benefits of using consolidated summary reports in the decision making process. (Points 40)

5. (TCO 9) Note: This question has three parts:

1. As the Sales Manager of a global company, you would like to use MS Excel to analyze the sales data for the entire company. The first challenge is, the Sales Data System cannot export its data as a MS Excel Workbook. It can however, generate a TXT file. Please explain how you would get the data into Excel for analysis.

2. As the Sales Manager, decide two things you would like to know from the sales data (data available: country, product, price per product, date product was sold, quantity sold, sales person). Then select two features you would use to analyze the data to provide you with the information you desire. Please be clear on what two things you would like to know and how you will use the selected feature to provide that information.

3. With the information now known, please describe how you would present this information to senior management. Please be specific and be sure to consider the audience. (Points 40)

MGMT404 Week 2 Project Selection

Due Week 2: Project Selection

Provide a short, one-paragraph description of your project which will make it very clear to me, your boss, what you are planning. Keep in mind that you will be using this project for all team activities for this session.

For your new project, please develop a project team (create a fictitious team with at least three additional team members) and show how you will manage team dynamics in a project environment.

Be certain to include:

1. How can team leadership be instrumental in ensuring a successful project?

2. Choose from the various organizational formats, including pure project, matrix, and functional structures.

3. How can team dynamics and performance be pivotal in producing deliverables and meeting customers' expectations?

Please put this in proper business writing format. Consider me to be your boss.

MGMT404 Week 3 Scope Statement

MGMT404 Week 4 Work Breakdown Structure and Network Diagram

Due Week 4: Work Breakdown Structure and Network Diagram

According to the PMBOK, "the WBS is a deliverable-oriented hierarchical decomposition of the work to be executed by the project team, to accomplish the project objectives and create the required deliverables." In other words, it lists the tasks, the sub-tasks, the sub-sub-tasks, etc., for the project.

For this phase, you will create a Work Breakdown Structure (WBS) for the project you selected during Phase One. Remember that the WBS starts with your major deliverables (that you stated in your Scope Management Plan) at the highest level. The lower levels have the tasks required to complete those deliverables. You should have at least three tasks under each deliverable, but you may have as many tasks as needed to ensure that the deliverables are complete. Review the textbook (and the PMBOK, if you have it) for some suggestions on how best to create a WBS. From your work breakdown structure, develop a project task list with dependencies. Add durations. Then submit a network diagram (using MS Project) and a project schedule.

Develop the Work Breakdown Structure

· Your WBS should have a minimum of 25-30 tasks and be three subtasks deep.

· Make sure to use verb/object task names (for example, "Develop software").

o Enter tasks in MS Project.

o Create the predecessor relationships to create a network diagram.

o DO NOT LINK SUMMARY TASKS!

o In the Gantt Chart Tools tab, check the box marked "Outline Number" in the Show/Hide group.

Deliverables:

· In MS Project, print the following:

o Gantt Chart Entry Table on no more than threepages [View > Tables > Entry]

§ Include Task Name, Duration, Start, Finish, and Predecessor columns with Gantt Chart.

o Schedule Table on one page [View > Tables > Schedule]

§ Include only the default columns (Task Mode, Task Name, Start, Finish, Late Start, Late Finish, Free Slack, Total Slack) and do not include the Gantt Chart. Make sure that all columns are wide enough to read completely.

o Network Diagram onone page [Task tab > View group > Network Diagram]

§ Highlight Critical Path and Circle Milestones.

§ Justify why you chose your milestones. (Hint: use milestones from the scope statement or look for key merge or burst activities.)

§ Also print out the network diagram on two to three pages so that task information can be read.

o Using the Resource Sheet (View > Resource Sheet) develop and print a list of resources required for your project. Include Max.Units and Costs (Std. Rate, Ovt. Rate, Cost/Use).