After almost a year of this pandemic, do you believe that your organization is more prepared than before? 

1) What is software engineering? Ch 1
2) What are the fundamental activities that are common to all software
processes? Ch 1
3) List the 5 principles of agile methods. Ch 3
4) What are user requirements and system requirements? Ch 4
5) What is the most important advantage of a client-server architecture?
Ch 6
6) What are the 5 key activities in an object-oriented design process?
Ch 7
7) Briefly describe the idea of open-source development. Ch 7

#GO19_AC_IntegratedB – Taos Welcome 1.0

GO19_AC_IntegratedB – Taos Welcome 1.0

Project Description:

In this Project, you will link and update Excel data in a Word document. You will use Word’s mail merge feature and data stored in an Access database to create individualized memos 

Open the Word file Student_i01B_Welcome_Memo.docx downloaded with this project. Display the rulers   and formatting marks.

Leave   your Word document open, and then from the files downloaded with this   Project, open the Excel file i01B_Taos_Inventory.xlsx.
 

  Select the range A3:B22. On the Home tab, in the Clipboard group, click Copy.

From   the taskbar, display your Word document. Below the paragraph that begins I am pleased to welcome you, click in   the blank paragraph.
 

  On the Home tab, in the Clipboard group, click the Paste button arrow, and   then click Paste Special. In the Paste Special dialog box, click the Paste   button, and then under As, click Microsoft Excel Worksheet Object. Click OK.

Click   in the table to select this object (sizing handles display), and then on the   Home tab, in the Paragraph group, click Center.

Point   to the table, and then double-click to edit the Excel Object.
 

  Click cell B9, type 389.99   and then press ENTER. Click cell B15, type 379.99   and then press ENTER. Click anywhere outside the Excel Object editable window   to close the Excel Object edit view.
 

  Save the Word document to save these changes and leave the document displayed   on your screen.

With   your Word document still displayed, open the Access database downloaded with   this Project Student_1B_All_Associates.accdb   and if necessary, click Enable Content.
 

  In the Navigation Pane, click the Store Location table one time to select it.   On the External Data tab, in the Export group, click More, and then click   Word.
 

  In the Export – RTF File dialog box, click Browse,   navigate to the location where you are storing your files for this Project,   and then as the file name, using your own name, type Lastname_Firstname_1B_Store_Locations   and then click Save.
 

  In the Export – RTF File dialog box, click OK. Be sure   the Save export steps check box is not selected, and then click Close.

From   the taskbar, display your Word document, and then press CTRL+END to move to   the end of the document.
 

  On the Insert tab, in the Text group, click the Object button arrow, and then   click Text from File. In the Insert File dialog box, navigate to your storage   location, and then click your Word file Lastname_Firstname_1B_Store_Locations.   Click Insert.

In   the inserted table, click in the first cell, Store ID, to make the cell the active cell. On the ribbon, under   Table Tools, on the Design tab, in the Table Styles group, click More. In the   Table Styles gallery, scroll down, and then under List Tables, in the third   row, click the third (orange) style—click List Table 3 – Accent 2.

With   the first cell, Store ID, selected,   on the Table Tools Layout tab, in the Rows & Columns group, click Delete.   On the displayed list, click Delete Columns to delete the Store ID column.

On   the Table Tools Layout tab, in the Cell Size group, click AutoFit, and then   click AutoFit Contents.

In   the Table group, click Properties, and then on the Table tab, under   Alignment, click Center. Click OK. Save your Word document.

From   the taskbar, display your Access database. In the Navigation Pane,   double-click the Sales Associates Form.
 

  In the navigation area at the bottom edge of the form, click the New (blank)   record button. In the ID field, type 10-60531   and then press TAB. Type your own first name, press TAB, type your own last   name, and then press TAB. Type Sales Associate   press TAB, type NM52.
 

  Press TAB to accept your record.
 

  In the Navigation Pane, double-click the report Store Associates by Location.   Scroll through the report and be sure that your name displays under NM for   the Taos location. Close Access.

With   your Word document Student_i01B_Welcome_Memo.docx   displayed, click anywhere in the document, and then press CTRL+HOME to move   to the top of the document. On the Mailings tab, in the Start Mail Merge   group, click Select Recipients, and then click Use an Existing List.
 

  In the Select Data Source dialog box, navigate to the location where you are   storing your files for this Project, select your i01B_All_Associates.accdb Access database, and then click Open to   display the Select Table dialog box.

In   the Select Table dialog box, be sure that the Sales Associates table is   selected, and then click OK.

In   the Start Mail Merge group, click Edit Recipient List. In the Mail Merge   Recipients dialog box, in the lower right under Refine recipient list, click   Filter.
 

  In the Filter and Sort dialog box, with the Filter Records tab selected,   click the Field arrow, and then click Store ID. Under Comparison, be sure   that Equal to is selected. In the Compare to box, type NM52.
 

  At the bottom of the Filter and Sort dialog box, click OK to display the   three Taos records—including your record. In the Mail   Merge Recipients dialog box, click OK.

Near   the top of the document, in the heading TO:,   click to position the insertion point to the left of the paragraph mark.
 

  On the Mailings tab, in the Write & Insert Fields group, click the Insert   Merge Field button arrow, and then click Firstname. Press SPACEBAR. Click the   Insert Merge Field button arrow, and then click Lastname.
 

  In the Preview Results group, click Preview Results to display the first   person’s name in the TO: field. In the Preview Results group, click Next   Record two times to preview the three names to whom the memo will be sent.   Your own name will be the third memo.

In   the Preview Results group, click Preview Results to turn off the feature—the   merge fields display in the TO:   field.
 

  In the Finish group, click Finish & Merge, and then click Edit Individual   Documents. In the Merge to New Document dialog box, be sure that the All   option button is selected, and then click OK to display a six-page document   containing three individual two-page memos.

Display   the Save As dialog box, and then navigate to the location where you are   storing your files for this Project. Using your own name, save the newly   merged document as Lastname_Firstname_1B_Taos_Memo.
 

  Press CTRL+A to select the entire document, and then press CTRL+C. From the   taskbar, display your Student_i01B_Welcome_Memo.docx   file. Press CTRL+END, and then CTRL+ENTER to create a new page. Press CTRL+V   to paste the copied merged document.

Save   and close all documents, and then Exit Word. Submit your Student_i01B_Welcome_Memo.docx file for grading.

Part1) Write a Java program which prompts a user for two numerical values as input, does some calculation on them and then print the result along with meaningful message to the console. Use some interesting formula and not a simple summation.

Submit your program as an attached  .java file and post a screen shot to show that you have been able to successfully run that program. Make sure you submission adheres to the SubmissionRequirements document.

Be sure to create a program different from any of the programs already posted by your classmates or the examples in class materials.

Use the web or other resources to research at least two criminal or civil cases in which  recovered files played a significant role in how the case was resolved.

Use your own words and do not copy  the work of another student.

Attach your WORD document here.

Some organizations prohibit workers from bringing certain kinds of devices into the workplace, such as cameras, cell phones, and USB drives. Some businesses require employees to use clear or see-through backpacks when carrying personal items. What other devices might not be allowed in certain facilities, and why would they be restricted? The video on Google’s Data Center may give you some ideas to write about for this assignment.

Your written assignment should consist of 2-3 paragraphs.

 #Exp19_Access_Ch05_Cap_Varmel_Studio_Toys 

 #Exp19_Access_Ch05_Cap_Varmel_Studio_Toys 

 Start Access. Open the file named Exp19_Access_Ch05_Cap_Varmel_Studio_Toys.accdb. Grader has automatically added your last name to the beginning of the filename. 

 You will save the database file with a new name and create a new table that will be the source for a lookup.

Save the database file as Exp19_Access_Ch05_Cap_Varmel_Studio_Toys_LastFirst.accdb. Use Design view to create a new table. Add ItemTypeID as the first field name, with data type AutoNumber; add ItemTypeDescription as the second field name, with data type Short Text and field size 15. 

Ensure ItemTypeID is set as the primary key. Save the table and name it Item Types. Add two records: Action Figure and Poster. Close the table.

884

You will edit the Inventory table design to validate data. You will make two fields required and add a validation rule to a field. You will also make sure you test the validation to make sure the rules work as intended.

Open the Inventory table in Design view. Set the InventoryQty and ItemTypeID fields to Required.

  You are a development officer for a state university. As an officer, you manage a portfolio of important donors who contribute financially to different areas within the university. You categorize the donors based on the college or school for which they want their donations associated. You recently downloaded the portfolio to an Excel workbook. Based on the way the data downloads from the main database, you want to format the text for readability and to make it easier for you to analyze. In addition, you will create an advanced filter to review a list of donors for a particular college or school. Finally, you want to create a look up area to look up data for a specific donor and create a summary section.

2

The first column displays the   name of the college or school (such as ART   or BUSINESS) associated with each.   You want to assign a three-character code for each college and use that code   to attach to existing donor IDs to create a unique field.
 

  In cell B8, insert the LEFT function to extract the first three characters   from the college name in cell A8. Copy the function to the range B9:B35.

3

You now want to combine the college   ID and donor ID.
 

  In cell D8, insert the CONCAT function to combine the college ID in cell B8   with the donor ID in cell C8 with a hyphen between the two text strings. Copy   the function to the range D9:D35.

4

In cell J8, insert a text   function that displays the college name from cell A8 with just the first   letter capitalized, such as Engineering.   Copy the function to the range J9:J35.

5

The Full Name column displays   last and first names of the donors. You want to display last names only in a   separate column.
 

  In cell F8, type Schneider and use Flash Fill to fill in the last names for   the donors in the range F9:F35.

6

The Address column contains   street addresses, city names, and state abbreviations. To manage the address   list better, you will separate the data into three columns.
 

  Select the addresses in the range G8:G35 and convert the text to columns,   separating the data at commas .

7

The top-left section of the   spreadsheet is designed to be able to enter a donor’s ID, such as ENG-15, and   look up that person’s position in the list, display the donor’s full name,   and display the amount donated this year. The first step is to identify the   position number of the donor ID.
 

  In cell B3, insert the MATCH function to look up the donor ID in cell B2,   compare it to the list in the range D8:D35, and then return the donor’s   position within the list.

8

Now you are ready to use the   position number as an argument within the INDEX function.
 

  In cell B4, insert an INDEX function that uses the range D8:K35, looks up the   row position number from the MATCH function result, and then uses the column   position number for Full Name.

9

In cell B5, insert an INDEX   function that uses the range D8:K35, looks up the row position number
  from the MATCH function result, and then uses the column position number for   Donation.

10

You want to format the results   of the INDEX function.
 

  Format the value in cell B5 as Accounting Number Format with zero decimal   places.

11

To analyze the donor records,   you are ready to create criteria and output ranges. You will enter conditions   to find records for donors to the College of Business who donated $1,000 or   more.
 

  Copy the range A7:K7 to cell A38 to create the column labels for the criteria   range. Type Business in cell J39 and >=1000 in cell K39.

12

You are ready to create the   output area and perform the advanced filter.
 

  Copy the column labels to cell A42. Perform the advanced filter by copying   the records to
  the output area.

13

Now that you created a copy of   the records meeting the conditions, you are ready to enter database functions   in the Summary area.
 

  In cell K2, insert the database function to total the value of the donations   for the records that meet the conditions in the criteria range.

14

In cell K3, insert the database   function to calculate the average donation for the records that meet the   conditions in the criteria range.

15

In cell K4, insert the database   function to count the number of records that meet the conditions in the   criteria range.

16

Format the range K2:K3 with   Accounting Number Format with zero decimal places. Format cell K4 with Comma   Style with zero decimal places.

17

You want to use the FORMULATEXT   function to display the functions.
 

  In cell G2, insert the FORMULATEXT function to display the formula stored in   cell B3.
  In cell G3, insert the FORMULATEXT function to display the formula stored in   cell B4.
  In cell G4, insert the FORMULATEXT function to display the formula stored in   cell D8.
  In cell G5, insert the FORMULATEXT function to display the formula stored in   cell K2.

18

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 of the worksheet.

19

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

From our weekly chapter reading, digital preservation can be defined as the long-term, error-free storage of digital information, with means for retrieval and interpretation, for the entire time span the information is required to be retained.  Though this assessment holds true to the authors, business organizations continue to face significant challenges in meeting their LTDP needs, especially those organizations whose primary mission is to preserve and provide access to permanent records.

Looking at your identified industry for your paper, what considerations would have to be made in developing a long-term archival plan for a company within that industry?

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 (for example, an article from the UC Library) 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.

Discussion 4A: Social Commentary

This week, we are delving into how authors use their literary works as social commentary. This can be a general commentary related to what is going on in society such as in Frankenstein; as a means to enact change such as in The Jungle; or as telling of an experience, such as in Persepolis. 

Initial Response

Choose one of the three works used as examples in Module 4 course content (Frankenstein, The Jungle, or Persepolis). Although I am not opposed to you choosing a different work outside of these, I think these three are good representations of three different types of literary criticisms. I provided videos and/or excerpts of each of these works in the course content area of the course. You are welcome to use this excerpt or find another one online (they are easy to find). I do not expect you to read the entire work although you are welcome to!

In your initial response, answer the following:

What literary work did you choose and who is the author?

Provide a brief 2-3 sentence summary of the work in your own words. 

Why is this work considered a social commentary/literary criticism? 

Give at least three examples of literary devices (i.e. theme, symbolism, etc) that support the idea that the author is commenting on. For example, if you chose Frankenstein, the author has many different themes such as the dangers of science, isolation, creation. How does the author convey one of these themes?

Responses to Others

Review two other responses.  How do the authors compare in how they convey their social commentary?