All posts by : chebby

 Exp19_Excel_Ch11_HOEAssessment_Accountants

 Project Description:

You work for a tax accounting firm that has offices in San Diego, Dallas, Miami, and Albany. Previously, you downloaded data from the employee database. Now you will use text, database, and lookup functions to obtain the results you want.

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

Your first step is to create a   unique ID for each accountant using the year hired, date hired, and number.
 

  In cell D2, enter 2007-1018-10 and use Flash Fill to complete the pattern to   create the remaining IDs in the range D3:D26.

The accountants’ full names are   located in column E. You want to separate the first and last names.
 

  Select the range E2:E26 and convert text to columns using the space as the   delimiter. Change cell E1 to First Name.

Next, you want to display the   accountants’ names with the last name and first name, separated by a comma.
 

  In cell G2, insert the TEXTJOIN function to join the last name and first name   for the first accountant, using a comma and space as the delimiter. The name   should display as Adams, Camille.   Copy the function to the range G3:G26.

Column J contains the phone   numbers. You want to extract the area codes.
 

  In cell K2, use the MID function to extract the area code for the phone   number for the first employee. The Start_num argument should be the position   of the first digit in the area code to avoid including the opening   parenthesis. Make sure the function extracts the three-digit area code. Copy   the function to the range K3:K26.

The Location column displays the   city names in all capital letters. Because this is hard to read, you will use   a text function to display the cities in upper and lowercase.
 

  In cell M2, use the PROPER function to display the first city name in upper   and lowercase. Copy the function to the range M3:M26.

You want to create a criteria   range to perform an advanced filter. The criteria are (1) Tax Accountants in   Miami and (2) Tax Accountants in San Diego.
 

  Copy the range A1:M1 and paste it in the range A28:M28. Enter Tax Accountant and Miami in the respective cells on row 29. Enter Tax   Accountant and San Diego in the respective cells on row   30.

Now you are ready to perform the   advanced filter by copying the data below the criteria range.
 

  Click within the dataset. Select A1:M26 as the list, the criteria range you   defined in the previous step, and A32:M32.

Next you want to calculate the   total salaries for all Tax Accountants in Miami and San Diego.
 

  In cell P2, insert the DSUM function using the dataset, column heading Salary, and the defined criteria   range.

Next, you will calculate the   average salary for Tax Accountants in Miami and San Diego.
 

  In cell P3, insert the DAVERAGE function to calculate the average salary   using the column heading Salary.

You want to identify the highest   salary for Tax Accountants in Miami and San Diego.
 

  In cell P4, insert the DMAX function.

Next, you want to identify the   lowest salary of Tax Accountants in Miami and San Diego.
 

  In cell P5, insert the DMIN function.

Finally, you want to count the   number of Tax Accountants in Miami and San Diego.
 

  In cell P6, insert the DCOUNT function.

The range O8:P9 contains a new   set of criteria to identify the one Senior Accountant in San Diego. You want   to obtain that person’s salary.
 

  In cell P11, insert the DGET function.

The range O13:P16 is designed to   look up a person’s name to return the position number and salary for that   person. First, you will look up the person’s location within the dataset.
 

  In cell P15, insert the MATCH function to look up the name in cell P14 and   return that person’s position within the Last Name column. Use only the range   containing the actual last names in the argument.

Now that you have the position   number for the accountant, you are ready to identify that person’s salary.
 

  In cell P16, insert the INDEX function using the range F2:M26 as the range   and the position number identified by the MATCH function.

In cell O19, insert the   FORMULATEXT function to display the formula that is stored in cell P15. Copy   the function to cell O20.

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

Save and close Exp19_Excel_Ch11_HOEAssessment_Accountants.xlsx.   Exit Excel. Submit the file as directed.

Your completed assignment should be saved as Word document and submitted to your WebTycho assignment area no later than the due date listed in the syllabus. Your document should be neat, well-written with minimal grammatical and spelling errors. Your name should be clearly listed on the first page along with the class/section, professor and due date. Your document should contain page numbers at the bottom of each page. Single or double space line formatting is acceptable. 

You should name the file yournamehw4.docx (or yournamehw4.doc). So if my name was Julie Smith, I would name my document juliesmithhw4.docx. 

An example HW4.doc template file containing the required sections is included in the available resources. You should use this document to start your writing and fill in all of the details required. 

Final Project- (30%)
Your final project will be to analyze, design, and document a simple program that utilizes a good design process and incorporates sequential, selection and repetitive programming statements as well as at least one function call and the use of at least one array.  The specific problem you need to solve for the final project is:  Design a program that will allow a user to Input a list of your family members along with their age and state where they reside. Determine and print the average age of your family and print the names of anyone who live in Texas. 

Final Project Deliverables:
There are two deliveries for this project. The first delivery is the project plan which provides your problem statements, problem analysis, and how it will comply with the project specifications. The project plan is worth 10% of your grade. The final delivery will be your completed project design along with your code comments and comprehensive test plan. The final delivery is worth 20% of your grade. 

Your project plan is due in week 7 by midnight EST, on the specific date posted in the class schedule. The final delivery is due no later than the last day of class. Your instructor’s policy on late projects applies to this project. 

Example Project Plan and Final Project template files, containing the required sections are included in the available resources. You should use this document to start your writing and fill in all of the details required. 

Format: 

Project plan format and length: 

The documentation describing your analysis and test plan should be written using Microsoft Word. The font size should be 12 point. The page margins should be 1 inch. The paragraphs should be formatted with double line or single line spacing. Any figures, tables, equations should be neatly labeled. All references should use APA style.  

Final Project Grading:
This activity is awarded 30% of the total grade in the course. The project elements are assessed as follows: 

1. Problem definition: Design a program that will allow a user to Input a list of your family members along with their age and state where they reside. Determine and print the average age of your family and print the names of anyone who live in Texas.

 A. Problem Analysis – Following the directions in the assignment, clearly write up your problem analysis in this section. 

Note: Your Design, code comments and test cases will be submitted next week.

Problem Statement:

Design a program that will allow a user to Input a list of your family members along with their age and state where they reside. Determine and print the average age of your family and print the names of anyone who live in Texas. Family contains ten members. 

Problem Analysis – Following the directions in the assignment, clearly write up your problem analysis in this section. 

• The program is to calculate the total      average of the family age wise and determine their location with only      printing out those members that are from Texas. The program will take      inputs from the user who will input the name, age and location of each      family member. The program will take the years of all members entered and      add them all together and then take the total of members entered (10) and      divide the total coming up with the average age. The program will also      calculate and identify each state of each person entered and using the      defined input identifies those people from Texas and prints their names      out only. The output of the program is three fold. The total average age      of all family entries, identify who is from Texas and print their name      out.

· Required input – Name of person

· Required input – Age of person

· Required input – State of where person came from

· Required output – average age of all persons entered

· Required output – printed name of person(s) from Texas ONLY

a. The program will take inputs and calculate the average of all of the ages entered, identify which persons are from Texas and print their name out.

b. An array will be used to hold the data for calculating who comes from Texas

c. The program will do the following:

i. Declare name, age and state arrays for those members

ii. Array will be up to the user entered values.

iii. It will take user input for name age and state in a loop

iv. It will calculate average age and identify who live in Texas 

v. Final function will print out average age, identify people’s names from Texas and print it out. 

For this program, user will be asked for name, age and state of their family members, one by one, until the user decides to stop entering this information. To achieve the given task (printing average family age and identifying residents of Texas), following modules need to be created:

– Main module: This module will be the one running on program startup. It will be responsible to get user input and call appropriate modules to calculate and display average family age and display family members those are residents of Texas

– calcAverageAge module: This module will take family ages as input and count of family members as input and calculate and display average family age. This module will be called from within Main module.

– printTexans module: This module will take family names as input and will print names of the family members from Texas. This module will be called from main module.

see attached for question

Exp19_Excel_Ch09_Cap_Housecleaning_Service 

Exp19 Excel Ch09 Cap Housecleaning Service 

Excel Chapter 9 Capstone – Housecleaning Service

Project Description:

You manage a housecleaning service. As manager, you schedule the cleaners with clients, provide cleaning supplies, and insure the cleaners. You pay the cleaners for their time and mileage reimbursement. You set up a monthly workbook with one worksheet per week to enter the dates, mileage to each house, and start and stop times. You then calculate the hours worked. You are ready to calculate weekly totals and the monthly totals.

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

The title and column labels in   the Week 1 worksheet are formatted with cell styles. You want to apply this   formatting.
 

  Group the Week 1, Week 2, Week 3, and Week 4 worksheets. Select the range   A1:B1 on Week 1 and fill formats only across the other weekly worksheets.

Now you want to fill the   formatting and contents to the other worksheets.
 

  With the four weekly worksheets still grouped, select the range A11:E11 and fill   both content and formatting across the other weekly worksheets.

You want to unlock the   data-entry cells on the weekly worksheets.
 

  With the worksheets still grouped, select the range A12:D40 and unlock the   cells.

You want to create a data   validation rule to control data entry.
 

  Ungroup the weekly sheets, select the range D12:D40 in the Week 1 sheet, and   then create a data validation rule with these specifications:
  • Allow Time greater than cell C12.
  • Enter the input message title: End Time.
  • Enter the input message: Enter the end time. (including the period).
  • Select the Stop error alert style.
  • Enter the error alert title: Incorrect End Time.
  • Enter the error message: The end time must be later than the start time. (including the period).

You want to duplicate the data   validation rule on the other worksheets.
 

  Select the range D12:D40 (if needed) and click Copy. Click the Week 2 sheet   tab and group Week 2, Week 3, and Week 4 sheets. Select the range D12:D40,   click the Paste arrow on the Home tab, select Paste Special, click Validation   in the Paste Special dialog box, and then click OK. Ungroup the sheets.
 

  Note: Paste Special validation is not available on Excel for Mac. Excel for   Mac users need to repeat Step 5 to create validations on the Week 2, Week 3,   and Week 4 worksheets.

Display the Week 2 sheet and   insert a split bar between rows 22 and 23.

Although the data validation   will prevent future errors in data entry, it did not correct errors in the   existing data.
 

  Display the Week 1 sheet. Circle invalid data to identify cells containing   invalid end times. Display the Month sheet. In cells H4 and H5, indicate the   name of the cells (e.g., A1) that contained the errors (do not enter a   formula). Display the Week 1 sheet again. Change the first incorrect end time   to 11:00   AM. Change the   second end time to 4:15 PM.

The hourly rate you charge   clients, the hourly wage you pay your housecleaners, and the mileage   allowance are stored in a separate workbook. You will create links to those   inputs to perform calculations in the weekly worksheets.
 

  Open Exp19_Excel_Ch09_Cap_HouseInput.xlsx.   Arrange the two open workbooks vertically to display both workbooks at the   same time. Display the Exp_Excel_Ch09_Cap_HouseCleaners   workbook and group the four weekly worksheets. In cell B5, multiply the Total   Hours that is stored in cell B4 by the Customer Cost per Hour that is stored   in cell B3 in the Exp_Excel_Ch09_CapHouseInput   workbook.

In cell B6, multiply the Total   Hours that is stored in cell B4 by the Cleaner’s Pay per Hour that is stored   in cell B4 in the Exp_Excel_Ch09_Cap_HouseInput   workbook.

In cell B7, multiply the Mileage   that is stored in cell B3 by the Cleaner’s Mileage Reimbursement that is   stored in cell B5 in the Exp_Excel_Ch09_CapHouseInput   workbook.
 

  Ungroup the worksheets, close Exp19_Excel_Ch09_Cap_HouseInput,   and maximize Exp19_Excel_Ch09_Cap_HouseCleaners.

The Month worksheet was created   to calculate the totals for the month. You will insert functions with 3-D   references to add data from each worksheet.
 

  Display the Month worksheet. In cell B3, insert a SUM function that uses a   3-D reference to add the mileage from the four weekly worksheets.

Copy the function from cell B3   to the range B4:B8. Use the Auto Fill button to Fill Without Formatting to   preserve the original formatting in the range.

Now you are ready to calculate   the weekly charge for Week 1.
 

  In cell E3 in the Month worksheet, create a formula with a 3-D reference to   display the contents of cell B5 from the Week 1 worksheet.

You are ready to enter similar   formulas with 3-D references to display the total weekly charges for the   other three weeks.
 

  In cell E4 in the Month worksheet, insert a formula with a 3-D reference to   display the contents of cell B5 from the Week 2 worksheet.
 

  In cell E5 in the Month worksheet, insert a formula with a 3-D reference to   display the contents of cell B5 from the Week 3 worksheet.
 

  In cell E6 in the Month worksheet, insert a formula with a 3-D reference to   display the contents of cell B5 from the Week 4 worksheet.

You want to create hyperlinks   from the Month sheet to the cells containing the total weekly client charge   for each week.
 

  In cell D3 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 1 sheet. Include   the ScreenTip text: Total client charges for Week 1 (no period).
 

Now you will insert hyperlinks   to the second weekly worksheet.
 

  In cell D4 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 2 sheet. Include   the ScreenTip text: Total client charges for Week 2 (no period).

Now you will insert hyperlinks   to the third weekly worksheet.
 

  In cell D5 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 3 sheet. Include   the ScreenTip text: Total client charges for Week 3 (no period).

You are ready to insert the last   hyperlink.
 

  In cell D6 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 4 sheet. Include the ScreenTip text: Total client   charges for Week 4   (no period).

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

Protect each worksheet so that   others can select the default cells but not make any changes.

Mark the Workbook as Final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

Save and close Exp19_Excel_Ch09_Cap_HouseCleaners.xlsx.   Exit Excel. Submit the file as directed.

Note : At least 12 Pages

Literature Survey: Restaurant Automation 

The second most important aspect of this course will be a literature review of case studies for projects centered around a software engineering topic. The software engineering topic is centered around Restaurant Automation. This is an individual project and should not be completed as a group assignment. Given the time constraints and limitations of the Team Project as well as difficulties arising from face-to-face meeting due to the on-going COVID-19 pandemic, the topic of this term paper will be centered around a literature review covering the same subject area as your team project. 

Some helpful tutorials on how to write and format your literature review may be found at the following links:

https://libguides.asu.edu/engineeringlitreview/whatis 

http://advice.writing.utoronto.ca/types-of-writing/literature-review/ 

https://www.lib.ncsu.edu/tutorials/lit-review 

Your term paper should include references to at least 5 scholarly sources. These sources should comprise published scientific books, journal articles, conference papers, published technical reports and/or summaries, or any sources posted inside any of the respected scholarly databases. Note that Wikipedia does not count as a legitimate source of scholarly work so please avoid using it. This literature review is meant to briefly summarize, analyze, evaluate, and critique your sources around the same subject area covered by your own team project. The length of the literature survey should between a minimum of 7 to a maximum of 15 pages (double-spaced, left-aligned, Times New Roman) that includes a title page, a table of contents, the report body of your literature survey neatly organized into appropriately formatted and named sections, and a References page organized in MLA format.

SQL Programming
 

4. Create an INVOICE_2 table from the INVOICE table using a select statement.
 

5. Rename the INVOICE_2 table to INVOICE_3.
 

6. Add a comment to the INVOICE_3 table definitions describing the tables.
 

7. Drop the ITEMID column from the INVOICE table.
 

8. Create an INVOICE_4 table using a subquery based on the structure of the INVOICE table. Include only the ORDID, DESCRIPTION, PRODID and QTY columns. Name the columns in your new table INV ID, DESCRIPT, PROD ID and QUANTITY, respectively.
 

9. Add a first row of data to the INVOICE table with data of your own choosing. Do not list the columns in the INSERT clause.
 

10. Populate the INVOICE table with the sample data. You are to create the values to enter into the table. This time, list the columns explicitly in the INSERT clause.
 

ORDID, DESCRIPTION, ITEMID, ACTUALPRICE, QTY, ITEMTOT, PRODID
 

11. Create a script named LOAD_DATA_(your initials).sql to load rows into the INVOICE table interactively. Prompt the user for the values . Specify a default value for the QTY.
 

12. Populate the table with the four rows of sample data by running the script that you created.
 

13. Change the value for one of the DESCRIPTIONS.
 

14. Create a PRIMARY KEY constraint on the INVOICE table using the ORDID column. The constraint should be named at creation as a named table level constraint.
 

15. Add a named table level foreign key reference on the INVOICE table that will ensure that the PRODID is not assigned to a nonexistent PRODUCT.
 

16. Modify the INVOICE_3 table. Add an ORD_DATE column of DATE datatype.
 

17. Modify the INVOICE table. Add a CHECK constraint to prevent any ACTUALPRICE greater than what you think is a reasonable level.
 

18. Modify the INVOICE table by making one of the columns NOT NULL.
 

19. Create a view called INVOICE_View based on four columns in the INVOICE table. Use SQL*PLUS formatting commands to create column headings for the four columns.
 

20. Using your view INVOICE_View, enter a query to display values for three of the four columns included in the view.
 

21. Create a view named INV_VIEW_QUERY that does not allow an invoice DESCRIPTION to be changed through the view.
 

22. Create a sequence to be used with the primary key column of the INVOICE table. The sequence should start at 1000 and have a maximum value of 2000. Have your sequence increment by a single number. Name the sequence INVOICE_SEQ. Do not allow the sequence to cycle or cache.
 

23. Write an interactive script to insert a row into the INVOICE table. Name your script
Be sure to use the sequence that you created for the primary key column. Create a customized prompt to enter the DESCRIPTION. Execute your script.
 

24. Create a synonym for the INVOICE table.
 

25. Write a query to display the three columns of data for all employees with the same MANAGER_ID as Grant .
 

26. Create a query to display the employee number, last name and hire date for all employees who have a salary greater than the average salary. Sort the results in descending order of salary.
 

27. Create a report containing the employee name, address, city, and each employee’s salary. Label the columns with a different name than the column name. Break on the individual department numbers. Create a spool file for this problem.

Software development Cycle

 Relate any incident you have been involved with that relates to a security issue. 

Initial Postings: Your initial post should be based upon the assigned reading for the week, so the textbook must be the only source utilized and listed in your reference section (and properly cited within the body of the text). Other sources are not required and are a waste of time to search and utilize. Only use the textbook.

Do not provide a Reflection or Chapter Overview. Provide only a graduate-level response to each of the following questions:

1. What are some common reasons for project failure?
2. Who should be involved in identifying potential projects?
3. What is a charter? Describe what an effective charter should accomplish. Explain how a charter helps secure both formal and informal commitment.
4. What is scope? What is scope creep and how can it be prevented?

Your post must be substantive and demonstrate insight gained from the course material. Postings must be in the student’s own words – do not provide quotes!

Text

Title: Contemporary Project Management 

ISBN: 9781337406451 

Authors: Timothy Kloppenborg, Vittal S. Anantatmula, Kathryn Wells 

Publisher: Cengage Learning 

Publication Date: 2018-02-08 

Edition: 4th

Compute the running time T(N) for the following codes for any n > 0: Show all (a) int sum(int n) { int sum=0: for (int i = n: i < 0: i++) { for(int j = 0: j < n: j++) { sum=sum + 1: } } return sum: } (b) int sum (int n) { int sum = 0: for (int i = 0: i < n: i++) { for(int j = i: j < n: j++) { sum=sum + 1: } } return sum: }