Write an assembly program that will move a character from left to right and then back again across the monitor of the PC a number of times as specified by the user’s input. The user is to be prompted for the character to display and how many times to move it back and forth. An input of ‘?’ and 1 would cause the ‘?’ to move back and forth across the monitor 1 trip.
Your program must only allow entry of numbers from 1 to 4 inclusive. Use a loop that allows an exit only if the value is greater than zero and less than five. If the user enters an illegal value you must remind him/her of the values that are allowed and re-prompt for the numeric value. You do not have to do any error checking on the character as any printable character is fine.
Remember if you have just displayed a character the cursor will be just to the right of it. In order to display the next character you will have to erase the previous character and then display the character in the new location. The backspace character is character number 8 and a space is character number 32. Do not display a character in the 80th position as this will cause the cursor to advance to the next line. All output must be on the same line.
You will also have to write a procedure that will slow the cursor movement across the screen. A Pentium CPU will move the cursor so fast that the user will not see it move. Your delay procedure needs to be a loop that does nothing an appropriate number of times.
Be sure to document your code and use procedures when ever possible in this program.

  

Exp19_Excel_Ch07_CapAssessment_Shipping | Excel Chapter 7 Capassessment Shipping

Dear students if you can not change then send me your downloaded file I will make it perfect for you.

Exp Excel Chapter 7 CapAssessment Shipping

excel ch 7 shipping 

Excel Chapter 7 Capassessment Shipping 

You work for a company that sells cell phone accessories. The company has distribution centers in three states. You want to analyze shipping data for one week in April to determine if shipping times are too long. You will perform other analysis and insert a map. Finally, you will prepare a partial loan amortization table for a new delivery van.

Steps to Perform:

Start   Excel. Download and open the file named Exp19_Excel_Ch07_CapAssessment_Shipping.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

The   Week worksheet contains data for the week of April 5.
 

  In cell D7, insert the appropriate date function to calculate the number of   days between the Date Arrived and Date Ordered. Copy the function to the   range D8:D35.

Next,   you want to display the city names that correspond with the city airport   codes.
 

  In cell F7, insert the SWITCH function to evaluate the airport code in cell   E7. Include mixed cell references to the city names in the range F2:F4. Use   the airport codes as text for the Value arguments. Copy the function to the   range F8:F35.

Now   you want to display the standard shipping costs by city.
 

  In cell H7, insert the IFS function to identify the shipping cost based on   the airport code and the applicable shipping rates in the range G2:G4. Use   relative and mixed references correctly. Copy the function to the range   H8:H35.

Finally,   you want to calculate a partial shipping refund if two conditions are met.
 

  In cell I7, insert an IF function with a nested AND function to determine   shipping refunds. The AND function should ensure both conditions are met:   Total Days is grater than Total Days Delivery Goal (cell C3) and Order Total   is equal to or greater than Order Total Threshold (cell C2). If both   conditions are met, the refund is 50% (cell C4) of the Shipping Cost.   Otherwise, the refund is $0. Use mixed references as needed. Copy the   function to the range I8:I35.

The   Stats worksheet contains similar data. Now you want to enter summary   statistics.
 

  In cell B2, insert the COUNTIF function to count the number of shipments for   Austin (cell B1). Use appropriate mixed references to the range argument to   keep the column letters the same. Copy the function to the range C2:D2.

In   cell B3, insert the SUMIF function to calculate the total orders for Austin   (cell B1). Use appropriate mixed references to the range argument to keep the   column letters the same. Copy the function to the range C3:D3.

In   cell B4, insert the AVERAGEIF function to calculate the average number of   days for shipments from Austin (cell B1). Use appropriate mixed references to   the range argument to keep the column letters the same. Copy the function to   the range C4:D4.

Now   you want to focus on shipments from Houston where the order was greater than   $1,000.
 

  In cell C7, insert the COUNTIFS function to count the number of orders where   the Airport Code is IAH (Cell D1) and the Order Total is greater than $1,000.   

In   cell C8, insert the SUMIFS function to calculate the total orders where the   Airport Code is IAH (Cell D1) and the Order Total is greater than   $1,000. 

In   cell C9, insert the MAXIFS function to return the highest order total where   the Airport Code is IAH (Cell D1) and the Order Total is greater than $1,000.

On   the Map worksheet, insert a map for the states and revenues. Cut and paste   the map in cell C1.

Format   the data series to show only regions with data and show all map labels.

Change   the map title to April 5-9 Gross Revenue.

Use   the Loan worksheet to complete the loan amortization table.
 

  In cell F2, insert the IPMT function to calculate the interest for the first   payment. Copy the function to the range F3:F25. (The results will update   after you complete the other functions and formulas.)

In   cell G2, insert the PPMT function to calculate the principal paid for the   first payment. Copy the function to the range G3:G25.

In   cell H2, insert a formula to calculate the ending principal balance. Copy the   formula to the range H3:H25.

Now   you want to determine how much interest was paid during the first two years.
 

  In cell B10, insert the CUMIPMT function to calculate the cumulative interest   after the first two years. Make sure the result is positive.

In   cell B11, insert the CUMPRINC function to calculate the cumulative principal   paid at the end of the first two years. Make sure the result is positive.

You   want to perform a what-if analysis to determine the rate if the monthly   payment is $1,150 instead of $1,207.87.
 

  In cell B15, insert the RATE function to calculate the necessary monthly rate   given the NPER, proposed monthly payment, and loan. Make sure the result is   positive.

Finally,   you want to convert the monthly rate to an APR.
 

  In cell B16, insert a formula to calculate the APR for the monthly rate in   cell B15.

Insert   a footer on all sheets with your name on the left side, the sheet name code   in the center, and the file name code on the right side.

•  

Objective 

In this lab, students will complete the following objectives. 

• Create a connection to an Access database. 

• Create various SQL queries to extract information from a database. 

• Format extracted data with column headers. 

Element K Network Connections

 

For this lab, we will only need to connect to vlab-PC1. The computer vlab-PC1 is the computer on the left side while vlab-PC2 is on the right. If you leave the cursor on the PC icon for a few seconds, a tool-tip message will appear indicating the hostname of the PC. Open vlab-PC1 and log in as Administrator with the password password.

Lab Overview

Even though we are only using vlab-PC1 to complete our lab assignment, the database we will be accessing (Computers.accdb) is actually located on the computer vlab-PC2 in the directory C:Database. This directory is shared as a ReadOnly network share by vlab-PC2. The Universal Naming Convention (UNC) name for this share is \vlab-PC2Database. Our VBScript program vlab-PC1 will have to open the \vlab-PC2Database share and map it to the local X: drive. The path specified fro the database will then be X:Computers.accdb.

The IT department maintains an Access database on vlab-PC2 that is used to inventory the computers in the various rooms. Fields in the database include: Computer Type, Hostname, Room Number, CPU Type, Number of Bits, Speed, Number of Processors, Operating System, Memory, and Hard Drive Size. We need to query this database to determine upgrades and replacements for existing computers. 

Below (and on the following page) is a listing of the Computers.accdb database contents:

 

 

 

Task 1: Understanding the Net Use Commands in ComputerDatabase.vbs 

• Open Notepad++. Use the menu option File/Open to open the VBScript program: C:ScriptsComputerDatabase.vbs. 

Task 2: Understanding the ADODB.Connection and ADODB.Recordset Objects

• In NotePad++, look at the following code lines.

Line 11 contains the SQL Query String named sqlStr. This is the line you will have to modify to properly query the Computer database. The SQL Query  “SELECT * FROM Computers” will select all fields from the database table Computers.

Lines 12 and 13 uses a string named dataSource to specify the Microsoft Driver and the name and location of the local database: X:Computers.accdb.

Line 14 Creates the “ADODB.Connection” object while line 15 opens the connection to the database.

Line 16 Creates the “ADODB.Recordset” object while line 17 provides access to the records using the SQL Query String and the Connection object. Line 18 moves the objRecordSet pointer to the first record.

 

Task 3: Displaying the Record Headers and Database Records 

• In NotePad++, look at the following lines of the ComputerDatabase.vbs program.

Lines 20–24 display the Database fieldnames as column headers.  Note the use of & to concatenate (add) string values together and _ which is the VBScript line continuation character.

Lines 25–37  are a Do Until loop that sequences through the database looking for records

that match the SQL Query String. The objRecordSet.EOF method checks to see if we have reached the last record in the database. This required because reading past the end of a database will cause an error. recordStr is a string variable initially set to “”. recordStr is used to create a multi-line string that contains the column headers and records that match the SQL query. The WScript.Echo recordStr statement in line 40 displays the column headers and records to the console or desktop windows depending on whether cscript or wscript is used to run the program.

Lines 38 and 39 close the database connections made by the ADODB.Connection and ADODB.Recordset objects. 

The function pad(byVal strText, ByVal len) in lines 44–46 are used to format the field values with added spaces so the tab positions will line up correctly.

Task 4: Write and Run Database Query Program 1 

In this scenario, we need to query the Computer database to determine which computers need to be replaced. Our decision will be based on the CPU speed, Number of Processors, and the size of the Hard Drive.

• Open the ComputerDatabase.vbs program in NotePad++ and Save As the program with the name ComputerReplace.vbs. 

• Modify the SQL Query String (sqlStr) in line 11 to extract the following information from the database.

Fields Displayed from Computers Table (specified by the SELECT clause). 

Computer

Room_Num

Speed

Num_CPUs

OS_Type

HDD_Size

Replacement Criteria (specified by the WHERE clause).

Any computer with a single CPU

Any computer with a CPU speed less than 2.1 GHz

Any Computer with a Hard Disk Drive size less than 300 GBytes

Sort Criteria (specified by the ORDER BY clause).

Sort the extracted records by the “Room_Num” field.

• Modify lines 20–24 to display the correct field headers for the fields being displayed.

• Modify the Do Until loop body to include only the fields being displayed. Use the pad( ) function as needed to make the header and field values line up.

• Press the function key and in the Commands box, type wscript ComputerReplace.vbs. Click OK to run the program and verify correct formatting and query results. 

 

• This query should generate eight records displayed in order by room number. If you have any errors, do not get the correct results or your columns are mis-aligned; modify your program

as required until you get the correct output.

Copy and paste your ComputerReplace.vbs program sourcecode from NotePad++ and the desktop window from your Run into the spaces provided in your  lab-report document. Answer the questions about the Replacement SQL Query in the  lab-report document.

 

Task 5: Write and Run Database Query Program 2

In this scenario, we need to upgrade our company computers based on the Operating System and the amount of memory. We want to ensure that all Fedora 10 machines are upgraded to Fedora 14 and all Windows XP machines are upgraded to Windows 7. If we find any computers with only 2 GB of memory, we will upgrade the memory to 4 GB. 

• Open the ComputerDatabase.vbs program in NotePad++ and Save As the program with the name ComputerUpgrade.vbs. 

• Modify the SQL Query String (sqlStr) in line 11 extract the following information from the database.

Fields Displayed from Computers Table (specified by the SELECT clause). 

Computer

HostName

Room_Num

OS_Type

Memory

Replacement Criteria (specified by the WHERE clause).

Note: String values in fields must be delimited by single quotes.

Any computer with the Fedora 10 Operating System (‘Fedora 10’)

Any computer with the Windows XP Operating System (‘Windows XP’)

Any computer with 2 GB of memory

Sort Criteria (specified by the ORDER BY clause).

Sort the extracted records by the “OS_Type” field.

• Modify lines 20–24 to display the correct field headers for the fields being displayed.

• Modify the Do Until loop body to include only the fields being displayed. Use the pad( ) function as needed to make the header and field values line up.

• Press the function key and in the Commands box, type wscript ComputerUpgrade.vbs. Click OK to run the program and verify correct formatting and query results.

 

• This query should generate 16 records displayed in order by OS_Type. If you have any errors, do not get the correct results, or your columns are mis-aligned; modify your program as required until you get the correct output.

Copy and paste your ComputerUpgrade.vbs program sourcecode from NotePad++ and the desktop window from your Run into the spaces provided in your  lab-report document. Answer the questions about the Upgrade SQL Query in the  lab-report document.

 

Student Name ____________________________  Date _____________

VBScript Database Query Lab Report

Task 4: Write and Run Database Query Program 1 

In this scenario, we need to query the Computer database to determine which computers need to be replaced. Our decision will be based on the CPU speed, Number of Processors and the size of the Hard Drive.

• In the space provided in your Lab Report document, paste your modified VBScript program and the RUN.

In the table cell below, paste your ComputerReplace.vbs Program

 

In the table cell below, paste the desktop RUN from your ComputerReplace.vbs Program

How many Computers will be replaced due only to CPU Speed < 2 GHz?

How many Computers will be replaced due only to Number of CPUs = 1?

How many Computers will be replaced due only to HDD Size < 300?

How many Computers will be replaced due to 2 or more reasons?

 

Task 5: Write and Run Database Query Program 2

In this scenario, we need to upgrade our company computers based on the Operating System and the amount of memory. We want to ensure that all Fedora 10 machines are upgrade to Fedora 14 and all Windows XP machines are upgraded to Windows 7. If we find any computers with only 2 GB of memory, we will upgrade the memory to 4 GB. 

In the table cell below, paste your ComputerUpgrade.vbs Program

 

In the table cell below, paste the desktop RUN from your ComputerUpgrade.vbs Program

How many Fedora 10 Computers will be upgraded?

How many Window 7 Computers will be upgraded due to 2 GB memory?

How many Windows XP Computers will need a Memory and OS upgrade?

 

Excel_2G_Inventory

 

Excel_2G_Inventory

Excel 2G Inventory

Project Description:

In the following project, you will edit a worksheet that summarizes the inventory of bulbs and trees at the Pasadena facility.

Steps to Perform:

Step Instructions Points Possible

1 Open the Excel workbook Student_Excel_2G_Inventory.xlsx downloaded with this project. 0

2 Change the Theme to Slice. Rename Sheet1 as Bulbs and Sheet2 as Trees, and then make the Bulbs sheet the active sheet.

If the theme is not available, click Browse for Themes, navigate to your downloaded files, and select Slice.thmx. 3

3 To the right of column B, insert two new columns to create new  blank columns C and D. By using Flash Fill in the two new columns, split  the data in column B into a column for Item # in column C and Category  in column D.

5

4 Type Item # as the column title in column C and Category as the  column title in column D. Delete column B. By using the Cut and Paste  commands, cut column C—Category—and paste it to column G, and then  delete the empty column C. Apply AutoFit to columns A:F. 1

5 Display the Trees worksheet, and then repeat Steps 3 and 4 on this worksheet. 6

6 Make the following calculations in each of the two worksheets without grouping the sheets:

•In cell B4, enter a function to sum the Quantity in Stock data, and  then apply Comma Style with zero decimal places to the result.

•In cells B5:B8, enter formulas to calculate the Average, Median,  Lowest, and Highest retail prices, and then apply the Accounting Number  Format. 14

7 In each of the two worksheets, make the following calculation without grouping the sheets:

•In cell B10, enter a COUNTIF function to determine how many  different types of Tulips are in stock on the Bulbs sheet and how many  different types of Evergreens are in stock on the Trees worksheet. 4

8 Without grouping the worksheets, complete the following in each worksheet:

•  In cell G14, type Stock Level

•  In cell G15, construct an IF function to determine the items that  must be ordered. If the Quantity in Stock is less than 75 the  Value_if_true is Order. Otherwise the Value_if_false is OK. Fill the  formula down through all the rows. 8

9 Without grouping the worksheets, apply conditional formatting as follows to both worksheets:

•Apply Conditional Formatting to the Stock Level column so that cells  that contain the text Order are formatted with Bold Italic, font color  set to Automatic, and Fill color set to No Color.

•Apply Gradient Fill Blue Data Bars to the Quantity in Stock column. 4

10 In the Bulbs sheet, format the range A14:G42 as a table with  headers and apply Light Orange, Table Style Light 20. If the style isn’t  available, choose another style. Insert a Total Row, filter by Category  for Tulips, and then Sum the Quantity in Stock column. Record the  result in cell B11. 4

11 Select the table, clear the filter, Sort the table on the Item #  column from Smallest to Largest (Ascending) and then remove the Total  Row. On the Page Layout tab, set Print Titles so that row 14 repeats at  the top of each page. 3

12 In the Trees sheet, format the range A14:G42 as a table with  headers and apply Light Green, Table Style Light 19. If the style isn’t  available, choose another style. Insert a Total Row, filter by Category  for Evergreens, and then Sum the Quantity in Stock column. Record the  result in cell B11. 4

13 Select the table, clear the filter, Sort the table on the Item #  column from Smallest to Largest (Ascending), and then remove the Total  Row. On the Page Layout tab, set Print Titles so that row 14 repeats at  the top of each page, and then Save your workbook. 3

14 Group the two worksheets. Merge & Center the title in cell A1  across the range A1:G1 and apply the Title cell style. Merge &  Center the subtitle in cell A2 across the range A2:G2 and apply the  Heading 1 cell style. AutoFit Column A. 5

15 With the worksheets still grouped, center the worksheets  Horizontally, change the Orientation to Landscape, and insert a footer  in the left section with the file name. Display the Print Preview, and  then change the Settings to Fit All Columns on One Page. 

(NOTE: On a Mac, on the Page Layout tab, change the Width to 1 page.)

5

16 Save your workbook and then ungroup the sheets. Make the Trees  sheet the active sheet, and then insert a new worksheet. Change the new  sheet name to Summary and then widen columns A:D to 170 pixels. Move the  Summary sheet so that it is the first sheet in the workbook. 2

17 In cell A1, type Pasadena Inventory Summary. Merge & Center  the title across the range A1:D1, and then apply the Title cell style.  In cell A2, type As of December 31 and then Merge & Center the text  across the range A2:D2. Apply the Heading 1 cell style. 4

18 On the Bulbs sheet, Copy the range A4:A8. Display the Summary  sheet and Paste the selection to cell A5. Apply the Heading 4 cell style  to the selection. 2

19 In the Summary sheet, in cell B4, type Bulbs. In cell C4 type  Trees. In cell D4 type Bulbs/Trees. Center the column titles, and then  apply the Heading 3 cell style. 3

20 In cell B5, enter a formula that references cell B4 in the Bulbs  sheet so that the Bulbs Total Items in Stock displays in B5. Create  similar formulas to enter the Average Price, Median Price, Lowest Price,  and Highest Price from the Bulbs sheet into the Summary sheet in the  range B6:B9. 5

21 Enter formulas in the range C5:C9 that reference the Total Items  in stock and the Average Price, Median Price, Lowest Price, and Highest  Price cells in the Trees worksheet. 5

22 In cells D5, D6, D7, D8, and D9, insert Column sparklines using  the values in the Bulbs and Trees columns. Format each sparkline using  the first five Sparkline styles in the first row. 5

23 To the range B5:C5, apply Comma Style with zero decimal places,  and to the range B6:C9, apply Accounting Number Format. Center the  Summary worksheet Horizontally and change the Orientation to Landscape.  Insert a footer in the left section with the File Name. 5

24 Save and close the file, and then submit for grading. 0

Total Points 100

•  

  From this link read abstract and answer the question https://www.ncjrs.gov/App/Publications/abstract.aspx?ID=246582 Do you think having a simulator for training and readiness would help or hinder the quality of the contingencies? why or why not? 

As a business professional, why does the following difference matter to you? Why does knowing the difference help you avoid some common mistakes?

• Information technology contains three major components: Hardware (such as computers), Software (such as operating systems and office software), and Data (the facts, figures, and numbers collected from the daily activities of the organization).  
• Information systems contain those same components, with two additions: People (such as the employees who work there), and Procedures (such as the step-by-step instructions employees follow to complete a sale).

If you have you been involved with a company doing a redesign of business processes, discuss what went right during the redesign and what went wrong from your perspective. Additionally, provide a discussion on what could have been done better to minimize the risk of failure. If you have not yet been involved with a business process redesign, research a company that has recently completed one and discuss what went wrong, what went right, and how the company could have done a better job minimizing the risk of failure.

paper should meet the following requirements:

Be approximately 2-4 pages in length, not including the required cover page and reference page.

Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.

Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. 

Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

 

There are TWO tasks that you would need to do( they are separate): 

Task 1 (Minimum 300 words): 

 Discuss the ideas that are essential while designing an organization. 

– Minimum two references. 

TASK 2:

Write a reply to the two responses in the attached document ( Response 1 and Response 2) with 150 words for each. 

There should be no plagiarism. Attach a plagiarism report with 0 % similarity index.

 

• What are the benefits and challenges associated with the continued growth of e-commerce and m-commerce?
• What are the key components of a successful e-commerce and m-commerce strategy?
• What are key components of technology infrastructure that must be in place for e-commerce and m-commerce to work?

 Chapter 3 topics:

• Define and describe PaaS.
• List the benefits of PaaS solutions.
• Describe potential disadvantages of PaaS.
• Describe how a cloud-based database management system differs from an on-site database.

 Chapter 4 topics:

• Define and describe IaaS.
• Define and describe system redundancy. Discuss how you might use IaaS to implement a redundancy plan.
• Define and describe load balancing. Discuss how you might use IaaS to implement load balancing.
• Define and describe NAS. Assume you must implement a shared file system within the cloud. What company would you select? Why? What costs should your client expect to pay for cloud-based data on a gigabyte (GB) basis?

 Chapter 5 topics:

• Define and describe SSO.
• Define and describe IDaaS.
• Define SAML and describe its purpose.
• Define and describe provisioning.