Monthly Archives: June 2023

  Project Description:

You work for the vice president’s office at a major university. Human Resources provided a list of deans and associate deans, the colleges or schools they represent, and other details. You will use text functions to manipulate text, apply an advanced filter to display selected records, insert database summary statistics, use lookup functions, and display formulas as text.

2

First, you want to combine the   year and number to create a unique ID.
 

  In cell C8, enter 2006-435 and use Flash Fill to complete the IDs for all the deans and   associate deans.

3

Next, you want to create a   three-character abbreviation for the college names.
 

  In cell E8, use the text function to display the first three characters of   the college name stored in the previous column. Copy the function to the   range E9:E28.

4

The college names are hard to   read in all capital letters.
 

  In cell F8, insert the correct text function to display the college name in   upper- and lowercase letters. Copy the function to the range F9:F28.

5

You want to display the names in   this format Last, First.
 

  In cell J8, insert either the CONCAT or TEXTJOIN function to combine the last   name, comma and space, and the first name. Copy the function to the range   J9:J28.

6

Columns K and L combine the   office building number and room with the office phone extension. You want to   separate the office extension.
 

  Select the range K8:K28 and convert the text to columns, separating the data   at commas.

7

You decide to create a criteria   area to perform an advanced filter soon.
 

  Copy the range A7:M7 and paste it starting in cell A30. Enter the criterion Associate Dean in the appropriate cell on row   31.

8

Now you are ready to perform the   advanced filter.
 

  Perform an advanced filter using the range A7:M28 as the data source, the   criteria range you just created, and copying the records to the output area   A34:M34.

9

The top-right section of the   worksheet contains a summary area. You will insert database functions to   provide summary details about the Associate Deans.
 

  In cell L2, insert the database function to calculate the average salary for   Associate Deans.

10

In cell L3, insert the database   function to display the lowest salary for Associate Deans.

11

In cell L4, insert the database   function to display the highest salary for Associate Deans.

12

Finally, you want to calculate   the total salaries for Associate Deans.
 

  In cell L5, insert the database function to calculate the total salary for   Associate Deans. 

13

Format the range L2:L5 with   Accounting Number Format with zero decimal places.

14

The range G1:H5 is designed to   be able to enter an ID to look up that person’s last name and salary.
 

  In cell H3, insert the MATCH function to look up the ID stored in cell H2,   compare it to the IDs in the range C8:C28, and return the position number.

15

Now that you have identified the   location of the ID, you can identify the person’s last name and salary.
 

  In cell H4, insert the INDEX function. Use the position number stored in cell   H3, the range C8:M28 for the array, and the correct column number within the   range. Use mixed references to keep the row numbers from changing. Copy the   function to cell H5 but preserve formatting. In cell H5, edit the column   number to display the salary.

16

In cell D2, insert the function   to display the formula stored in cell F8.
  In cell D3, insert the function to display the formula stored in cell H3.
  In cell D4, insert the function to display the formula stored in cell H4.
  In cell D5, insert the function to display the formula stored in cell L3.

17

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

Compare and evaluate in 500 words or more qualitative v quantitative risk assessment.  

Use at least three sources. Use the Research Databases available from the Danforth Library not Google. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragaphs.   Stand alone quotes will not count toward the 3 required quotes.Copying without attribution or the use of spinbot or other word substitution software will result in a grade of 0. 

Please respond to the following discussion below with 150 words or more relating to relational algebra and its relation to SQL.

As a collection of algebraic structures, relational algebra was  developed at IBM by Edgar F. Codd. It is used to represent data stored  in relational databases, as well as to define queries on that data. An  instance of relational algebra may be described as a procedural query  language that employs unary or binary operators to execute queries.  Users of relational database systems must be able to query database  instances using a query language. Relational algebra or relational  calculus is used to query a relational database system. Recursive  relational algebra is done on a relation, and intermediate outcomes are  also considered relations. For Edgar F. Codd’s relational paradigm, SQL  was one of the first commercially available programming languages.  Despite the fact that they are based on similar principles, their syntax  differs. There are several advantages to relational algebra, including  its closed nature, rigorous basis, and simplicity of semantics. SQL, on  the other hand, is a subset of relational algebra with easy formatting  capabilities, aggregate functions, and a complex semantics. Below is an  example from the course readings that illustrate the difference in  syntax:

SELECT DISTINCT dname
FROM department, course, empcourse, employee WHERE cname = `Further Accounting’

AND course.courseno = empcourse.courseno AND empcourse.empno = employee.empno AND employee.depno = department.depno;

The equivalent relational algebra is

PROJECTdname (department JOINdepno = depno ( PROJECTdepno (employee JOINempno = empno (

PROJECTempno (empcourse JOINcourseno = courseno ( PROJECTcourseno (SELECTcname = `Further Accounting’ course)

)) ))

))

References:

Relational algebra – example. (n.d.). https://web.archive.org/web/20160326123806/http:/db.grussell.org/section011.html.

Relational algebra. (n.d.). https://www.tutorialspoint.com/dbms/relational_algebra.htm.

The final portfolio project is a three- part activity. You will respond to three separate prompts but prepare your paper as one research paper. Be sure to include at least one UC library source per prompt, in addition to your textbook (which means you’ll have at least 4 scholarly sources cited). 

Start your paper with an introductory paragraph.

Prompt 1 “Data Warehouse Architecture” (2-3 pages): Explain the major components of a data warehouse architecture, including the various forms of data transformations needed to prepare data for a data warehouse. Also, describe in your own words current key trends in data warehousing. 

Prompt 2 “Big Data” (1-2 pages): Describe your understanding of big data and give an example of how you’ve seen big data used either personally or professionally. In your view, what demands is big data placing on organizations and data management technology? 

Prompt 3 “Green Computing” (1-2 pages):  One of our topics in Chapter 13 surrounds IT Green Computing. The need for green computing is becoming more obvious considering the amount of power needed to drive our computers, servers, routers, switches, and data centers. Discuss ways in which organizations can make their data centers “green”. In your discussion, find an example of an organization that has already implemented IT green computing strategies successfully. Discuss that organization and share your link. You can find examples in the UC Library.

Conclude your paper with a detailed conclusion section. 

The paper needs to be approximately 5-8 pages long, including both a title page and a references page (for a total of 7-10 pages). Be sure to use proper APA formatting and citations to avoid plagiarism.

Identify the differences between using the two different combinations of data backup techniques. 

Assignment Directions: Briefly discuss the differences between using the two different combinations of data backup techniques.  In a word document, discuss the assigned topic in approximately ten sentences.   

Using the Web or other resources, research an example of Cyber Terrorism.

Write a brief Discussion describing the terrorism attack and it’s aftermath. Comment on ways the attack could have been prevented.

Read and respond to at least two other students Discussions.

Post between 200 and 300 words.

The discussion should have zero percent plagiarism

Please include the references

Based on your experience in the online lab, using the assigned reading and any additional resources in the Library or online, develop three paragraphs describing the malware analysis portion of the forensic analyst portion of the playbook. The paragraphs should include detection, identification, and analysis of possible future malware discoveries.

String Wrapper:

Write a program that inputs a string from keyboard and converts all occurrence of letter t(lowercase t and uppercase t) do letter uppercase case d. The input string can have any combination of letters, digits, lowercase or uppercase.

Example: “Tod AND teachers went to parTy” should be replace with “Dod AND Deachers wenD to parDy”

Network Managment project

Eller Software Services has received contract revenue information in a text file. You import, sort, and filter the data. You also create a PivotTable, prepare a worksheet with subtotals, and format related data as an Excel table.

[Student Learning Outcomes 4.1, 4.3, 4.4, 4.5, 4.6, 4.8]

Files Needed: EllerSoftware-04.xlsx (Available from the Start File link.) and EllerSoftwareText-04.txt (Available from the Resources link.)

Completed Project File Name: [your name]-EllerSoftware-04.xlsx

Skills Covered in This Project

• Import a text file.
• Use AutoFilters.
• Sort data by multiple columns.
• Create a PivotTable.
• Format fields in a PivotTable.
• Use the Subtotal command.
• Format data in an Excel table.
• Sort data in an Excel table.

This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.

1. Open the EllerSoftware-04.xlsx start file. Click the Enable Editing button. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
2. Import the EllerSoftwareText-04.txt file downloaded from the Resources link and load it to begin in cell A4. The text file is tab-delimited.
3. Format the values in column H as Currency with zero decimal places.
4. Click cell G4 and use the AutoFilter arrow to sort by date oldest to newest.
5. Click cell F4 and use the AutoFilter arrow to sort by product/service name in ascending order.
6. Filter the Date column to show only contracts for September using the All Dates in the Period option.
7. Edit the label in cell A2 to display Contract Amounts for September.
8. Select cells A1:H2 and press Ctrl+1 to open the Format Cells dialog box. On the Alignment tab, choose Center Across Selection.
9. Change the font size for cells A1:H2 to 20 pt (Figure 4-102) and close the Queries & Connections pane.Figure 4-102 Imported data sorted and filtered
10. Copy the Contracts sheet to the end and name the copy Data.
11. Clear the date filter.
12. Select cell A5 and click the PivotTable button [Insert tab, Tables group]. The range is identified as the EllerSoftwareText file.
13. Verify that New Worksheet is selected, deselect the Add this data to the Data Model button, and click OK.
14. Name the sheet PivotTable. Close the Queries & Connections pane.
15. Show the Product/Service and Contract fields in the PivotTable.
16. Drag the Contract field from the Choose fields to add to report area below the Sum of Contract field in the Values area so that it appears twice in the report layout and the pane (Figure 4-103).Figure 4-103 “Contract” field appears twice in the report
17. Select cell C4 and click the Field Settings button [PivotTable Analyze tab, Active Field group]. Type Average Contract as the Custom Name, choose Average as the calculation, and set the Number Format to Currency with zero decimal places.
    Select cell C4 and click the Field Settings button [PivotTable Tools Analyze tab, Active Field group]. Type Average Contract as the Custom Name, choose Average as the calculation, and set the Number Format to Currency with zero decimal places.
18. Select cell B4 and set its Custom Name to Total Contracts and the number format to Currency with zero decimal places.
19. Apply Brown, Pivot Style Dark 3.
20. Select the Data sheet tab and copy cells A1:A2. Paste them in cell A1 on the PivotTable sheet.
21. Select Align Left for cells A1:A2 and 16 pt. as the font size. Edit the label in cell A2 to display Contract Amounts, September through December (Figure 4-104).Figure 4-104 Completed PivotTable
22. Copy the Data sheet to the end and name the copy Subtotals.
23. Select cell D5 and sort by City in A to Z order.
24. Select cell A5 and convert the table to a range. Select cells A5:H31 and apply No Fill [Home tab, Font group].
25. Use the Subtotal command to show a SUM for the contract amounts for each city.
26. Edit the label in cell A2 to display Contract Amounts by City.
27. Format the sheet to Landscape orientation, center the page vertically, and scale it to fit one page.
28. Click the Billable Hours sheet tab and select cell A4.
29. Click the Format as Table button [Home tab, Styles group], use Orange, Table Style Medium 10, and remove the data connections.
30. Type 5% Add On in cell E4 and press Enter.
31. Build a formula in cell E5 to multiply cell D5 by 105% and press Enter to copy the formula.
32. Select cells A1:A2 and left align them. Then select cells A1:E2, click the Launcher for the Alignment group [Home tab], and select Center Across Selection from the Horizontal list.
33. Use the AutoFilter arrows to sort by date in oldest to newest order.
34. Save and close the workbook (Figure 4-105).Figure 4-105 Excel 4-4 completed
35. Upload and save your project file.
36. Submit project for grading.