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.

The research project is a research-based paper on a current topic in the area of Cyberlaw. You MUST prepare  your paper on the topic that you chose in Module 1.You will develop your research project in stages throughout the course, including selecting a topic, submitting an abstract for instructor review and feedback (this was completed in Module 1), and submitting -your final project (paper) for evaluation here.You must support your materials by using at least five (5) appropriate, properly cited sources in APA Style in addition to your course textbook.You must write your paper on the topic that you chose in Module 1.

1. Wireless (Mobile) Networks

Your project paper will comprise 2000-2500 words, or 7 to 10 pages double spaced (not including title and reference pages). Your project paper must be formatted according to APA guidelines, double spaced, Times New Roman, 12-font, with one-inch margins.

 

respond to peer based on the peers post : There are numerous factors to take into account when organizing a PowerPoint presentation, but if I had to pick just one, it would be how to organize and connect each slide to the others. The PowerPoint presentation’s material should be concise, to the point, and related to the slide’s title. Each slide should also include pertinent data, visual aids, explanations, etc. When preparing a Powerpoint presentation, this should be considered, especially if a large audience will be attending.

There are many distinctions and benefits between creating slide shows from scratch and those using themes and templates. In PowerPoint, templates are used to organize various types of information on each slide, whereas themes give your presentations a professional appearance by including one or more slide layouts with matching colors, backgrounds, fonts, and effects. A template serves as the basis for each presentation. Each presentation inherits the template from which it was based for its colors, styles, fonts, and slide layouts (the blank presentation gets its design from a simple, bare-bones template). The ability to select the pictures, layouts, and text you want to use on your Powerpoint slide would be yours if you created a slide show from scratch.

PowerPoint presentations are a widely used, but are a crucial tool that can be utilized for both personal and business purposes. When presenting your proposal, business plan, financial information, reports, or projects in a professional setting, you may always use PowerPoint presentations. In business or when working for a company, informational presentations are helpful for reporting on research or providing a project update. They may also be utilized in education. PowerPoint presentations can be used when we need to make a presentation to a sizable audience, clients, panels, business partners, or our boss and management. Personally, you may make your own album, project, task, etc. using Powerpoint presentations. You can make a presentation of images with your friends, a presentation of items you want to give to your family, a particular group of people, or even to your relatives, among many other things. Since you may use it yourself, you can pick your own design, themes, add animations, and more.