All posts by : chebby

I ned both chapter answers in different doc file. The link to the book is: https://software-engineering-book.com/

Assigned Readings:Chapter 12. Contracts and Sales: Performance, Remedies, and Collection.Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

1. Discuss the various defenses in contract formation, stating what is required to establish each individual defense, and providing examples of when the defense may be found valid.
2. Sly Salesperson sells cars.  While selling a car, Sly Salesperson tells the potential buyer that “this is the best car around.  It’s a great car and sips gas.”  The car has an average fuel rating.  Has Sly Salesperson committed a misrepresentation?  Fraud?  Why or why not?  Does the analysis change if Sly Salesperson says the car get 40 miles per gallon, but in fact the car only gets 30 miles per gallon?

Text-

Title: Business 

ISBN: 9780357447642 

Authors: Marianne M. Jennings 

Publication Date: 2021-01-01 

Edition: 12th Edition

Exp19_Excel_Ch06_ML1_Housing_Cost

Exp19 Excel Ch06 ML1 Housing Cost

Excel Chapter 6 Mid-Level 1 – Housing Cost

Project Description:

Your friends, Elijah and Valerie Foglesong, want to build their dream house. They identified tentative costs, but they cannot afford the $414,717 estimated cost. You will use Goal Seek to determine an estimate of the total finished square footage they can afford. To help provide more flexibility in their decision-making, you will create a data table listing various finished square footages and their effects on the base house cost and total cost. Finally, you will create another data table showing combinations of square footages and lot prices to identify total costs.

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

Assign the range names B9 (Base), B15 (Interior), B21 (Exterior), B23 (Lot).

Enter a formula in cell B25 to   calculate the total estimated cost. The total estimated cost is the sum of   the base house price (B9), total interior upgrades (B15), total exterior   upgrades (B21), and lot fee (B23). Be sure to use range names in the formula.

Use Goal Seek to determine the   total finished square footage(B7) to meet the total cost goal of $350,000.

Enter a series of total square   footage ranging from 1,800 to 3,600 in increments of 200 in the range D6:D15. Apply Blue font and Comma Style with   zero decimal places to the series.

Enter a reference to the base   house price in cell E5 and a reference to the total estimated cost in cell   F5.

Complete the single variable   data table in the range D5:F15. Be sure to use total square footage as the   column input. Apply Custom number formats to give appropriate descriptions to   the second and third columns. Apply these formats to the headings: bold,   center, and Blue font color.

Identify the square footage,   base price, and total cost in the data table that comes closest to their   goal. Apply Yellow fill color to those cells.

Copy the square footage   substitution values, range D6:D15 to the range H6:H15 and remove the fill   color. Enter these lot price substitution values in the range I5:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero   decimal places and Blue font color.

Enter the reference to the total   estimated cost in the appropriate location for the second data table. Apply a   custom number format to display Total Sq Ft in that cell. Apply Blue font and bold to that   cell.

Complete the two-variable data   table using total square footage as the Column Input and lot price as the Row   Input. Apply a Custom number format to the reference to the formula cell.   Apply Yellow fill color to the total price in each column that comes closest   to their goal.

Format results in both tables   with Accounting Number Format with zero decimal places.

Create a scenario named Ideal Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 80, 102,675.

Create a scenario named Increased   Costs, using   Base price per square foot and Lot fee (use cell references). Enter these   values for the scenario: 100, 110,000.

Create a scenario named Low Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 60, 80,000.

Generate a scenario summary   report using the cell references for Price per square foot and Lot Fee. Add   the appropriate formatting to the newly created report

Save and close Exp19_Excel_Ch06_ML1_HW-Housing Cost.xlsx.   Exit Excel. Submit the file as directed.

I need help to add some  queries to finish my project 

Part 2

Create a query that shows the following information: you should have 8 queries and 2 tables in your access database. 

8 queries needed

1. How many and which boats can seat more than 9 people
   1. Identify boat id, boat type
2. How many and which boats can sleep more than 5 people
   1. Identify boat id boat type and ……..
3. Which boats are older than 15 years
   1. Identify fields to display
4. How many provide the cheapest boat to rent per day
   1. Identify boat id boat type and cost
5. how many provide the most expense boats to rent per day
   1. Identify boat id boat type and cost
6. Which is the biggest boat?
7. Which is the smallest boat?
8. Which is the oldest boat?

Task 1:

How do you feel blockchain will change the global economy or will it?  Explain your answer.

Please make your initial post and two response posts substantive. A substantive post will do at least two of the following:

• Ask an interesting, thoughtful question pertaining to the topic
• Answer a question (in detail) posted by another student or the instructor
• Provide extensive additional information on the topic
• Explain, define, or analyze the topic in detail
• Share an applicable personal experience
• Provide an outside source that applies to the topic, along with additional information about the topic or the source (please cite properly in APA)
• Make an argument concerning the topic.

At least one scholarly source should be used in the initial discussion thread. Be sure to use information from your readings and other sources from the UC Library. Use proper citations and references in your post.

Task 2:

 Find a peer-reviewed scholarly journal article discussing blockchain technology. Complete a review of the article by writing a 2-3 page overview of the article. This will be a detailed summary of the journal article, including concepts discussed and findings. Additionally, find one other source (it does not have to be a peer-reviewed journal article) that substantiates the findings in the article you are reviewing. You should use the UC library ( https://www.ucumberlands.edu/library) and/or Google Scholar to find these types of articles ( https://scholar.google.com/ )Once you find the article, you will read it and write a review of it.  This is considered a research article review.Your paper should meet these requirements: 

• Be approximately three to four pages in length, not including the required cover page and reference page.
• Follow APA 7 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. The UC Library is a great place to find resources.
• 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.

Note the top five decisions that leadership will have to make with the implementation of the new product

Company: Healthcare Insurance

 Exp22_Word_Ch03_CumulativeAssessment_Academics

Project Description:

As an executive assistant working in the Admissions Office at Carnes State University, you are involved with a research project that is exploring the relationship between student GPA and involvement in academic clubs and scholarly activities. Academic and extracurricular data from a random sample of students in the College of Business has been summarized in a Word table that will be included in a brief memo to others on campus. You edit and format the report, preparing it for final submission.

Start Word. Download and open   the file named Exp22_Word_Ch03_CumulativeAssessment_Academics.docx.   Grader has automatically added your last name to the beginning of the   filename.

Click or move the insertion   point before the blank paragraph mark at the top of page 2. Using Century   Schoolbook font at 20-point size, type Carnes State University and press ENTER. Change the   font size to 16. Type Comparison of Student GPA and Involvement in College   Associations.   (Do not type the period.) Press ENTER. Check the document for spelling and   grammatical errors. All names in the table are correct.

Apply Align Center alignment to   the first row in the table. Click or move the insertion point after the last   entry in the last row, ending in 115.   Press TAB. Type the following data, tabbing between all entries except the   last. Leave cells blank that are marked with dashes. Do not type a dash in   the cell. Do not press TAB after the last item.
 

L0051899 Adams, Mary — — — Accounting 3.67 101
L0055558 Shockney, Maria Yes Yes — CIS 4.00 97 

Right-click any name identified   as misspelled and from the shortcut menu, select Ignore All. Sort the table   by Major in ascending order and then by Name in ascending order, so that the   result is names sorted within each major, all in ascending order.

Indicate that Michael J. Simpson and Andrew Sams are both active in Delta   Mu Delta by typing Yes in the Delta Mu Delta column for each of those students.

Insert a row above the first row   in the table and merge all cells in the newly inserted row. Change the font   size to 16. Type Comparison of GPA and Student Involvement. (Do not type the period.)

Shade the first row in Gold,   Accent 4 (row 1, column 8). Select all text in the third row through the end   of the table, beginning with L0051899   and ending with 98. The table may   span two pages. Bold the selection.

Select the entire table. Select   a Pen Color of Gold, Accent 4 and a line weight of 1 ½ pt. Ensure that a   single line border is shown. Apply the selection to All Borders.

Insert a row below the last row   in the table. Type AVERAGE in the first cell on the new row. Press TAB six times to reach   the CSU Cum GPA column. Include a   formula that averages all values in the column above. 

View the document in Multiple   Pages, noting that the table is split between two pages. Return the view to   100%. Select the first two rows. Click or navigate to the Table Layout tab   and select the option to repeat header rows.

Insert a row between Frederick Davidson and David Stumpe. Click in or move the   insertion point to the first cell of the new row and type the following   record, tabbing between cells. Do not type a dash in a cell. Leave the cell   blank.
 

L00500932 Johns, Lacey —  Yes Yes Computer Science 3.89 130

Update the average in the last   row to reflect the addition of the new record. Insert a caption for the   table, ensuring that the label is Table   and that the caption shows below the table. Type Table 1: GPA and   Student Involvement.   (Do not type the period.)

Press ENTER twice. Insert text   from the file Sponsors.docx.

Select the newly inserted text,   from Sponsor through K177. It does not matter whether you   select the paragraph mark following K177,   but do not select the blank paragraph on the next line. Whether you select   the ending paragraph mark on the last line of the text is irrelevant. Convert   the selection to a table, confirming that the new table will include four   columns and four rows.

Right-click anywhere in the   selected table and from the shortcut menu, select Table Properties. Click or   navigate to the Column tab. Ensure that the Preferred Width check box is   selected and change the width to 2. Click or press OK. Apply a table design of Grid Table 4 –   Accent 4 (row 4, column 5 under Grid Tables). Change the font color of the   first row of the table to Black, Text 1.

Center the table horizontally on   the page. Insert a caption below the table that reads Table 2: Faculty Sponsors. (Do not type the period.)   Increase the indent of the caption by 0.5 inches.

Begin a mail merge for Letters   using Faculty.xlsx as the data   source. You will use the Sheet1$ worksheet. Note, Mac users select the text   file Faculty.csv as a recipient   list, responding affirmatively if asked to confirm any file conversion   activities.

Click or move the insertion   point before the paragraph mark following TO:   on page 1. Insert the merge field of Title.   Press SPACEBAR. Insert the merge field of First_Name. Press SPACEBAR. Insert the   merge field of Last_Name. Click   before the paragraph mark following DATE:   and type April 14, 2023.

Preview results and finish the   merge, editing individual documents and merging all. The merged document   should contain nine pages.

Select all of the merged   document and copy the selection. Display Exp22_Word_Ch03_CumulativeAssessment_Academics.docx,   move the insertion point to the end of the document, and insert a page break.   Paste all copied text, resulting in a 13-page document.

Save and close Exp22_Word_Ch03_CumulativeAssessment_Academics.docx.   Close all other open documents without saving. Submit Exp22_Word_Ch03_CumulativeAssessment_Academics.docx as directed.

Pseudocode  is very important for programmers. It helps to sort out your thoughts  before coding and is for humans (programmers), not machines. Eventually  the pseudocode will need to be converted into an actual program for the  machine to read.

In this assignment, you are required to write a program in pseudocode to accomplish the following tasks:

Identify and display the number of files in the current directory where the file is located.

After you finish the pseudocode, submit it to the SLP 2 Dropbox.

SLP Assignment Expectations

• You are required to apply recursion in the program.
• The program should accomplish all the tasks in the assignment.
• Submit a Word document which has both the program and a screenshot of the output of the program

“See how many of the problems listed below you can solve working by yourself. Use books, manuals, online help, the Internet, and other resources, as necessary. Some of these problems are easier than others, so don’t work too long on a problem that seems difficult. As you work on these tasks, make some brief notes that describe your experience. Do some metacognition about your problem-solving approach.

This is the question to answer:

1. A user running Internet Explorer reports a message, “Internet Explorer cannot display the webpage.”What information about this problem can you provide the user”

Attached photo is a better view of the Case Project

Week 1 Apply Assignment.