All posts by : chebby

The parameters are as follows:

Please click on the link on the menu to your left that is specific to your program. Here-you will find a Case Study labeled “Case Study Analysis # 1”

• You will provide a case study analysis report.
• It must be a minimum of 3,000 words (excluding title page and references).
• It must include a separate title page.
• It must include a separate reference page.
  • It must include a minimum of eight scholarly or professional citations written within the last five years.
  • At least four of the eight references must originate from peer-reviewed journals.
  • Use of the Southwestern College Deets Library is required.
• APA format is required for the case study analysis report.
  • There are excellent APA resources available via the SC Writing Center in Academic Resources in this Blackboard course.

*Please review the writing assignment grading rubric for additional expectations.

Create a User Interface for a New Application

Synopsis: An aerospace company has decided to update their technology to something more modern and efficient. The segment of the task that requires your attention is in regard to the inventory system. This system will need to collect information and store it into a database for each aircraft. This particular segment focuses on the wheel assembly.

Description: An aerospace company, called AAC, is restructuring its internal technology processes. AAC is a large corporation that develops and assembles airplanes and cutting-edge craft for several markets, including commercial and defense. These craft include large passenger jets, attack aircraft, as well as spaceflight technologies.

The company has chosen to create a new database system to manage its incredibly large and complex parts inventory.

You work as an application software designer for an international corporation that has received the contract to create the system, IBN. You are the primary designer and business interface between IBN and AAC. You will design the User Interfaces that will be implemented.

IBN’s specialists have already determined which software language and database that the application will be created with. In addition, they have determined the first two modules that will be implemented – Aircraft Information Entry and Wheel Assembly Subsystems.

Aircraft Basic Information Entry: These screens will allow for creating and editing of a new aircraft. It will include the aircraft name, first assembly date, chief designer, description of use, the primary customer, and a list of parts suppliers.

Wheel Assembly Subsystems: These screens will allow for the entry of all parts required for the assembly, the number on-hand, the price for the part, and a description of the part.

As the designer of the user interface, you will need to consider the natural flow of information, screen structures that allow for efficiency, ease of use, and logical grouping of controls and related data.

These two modules will have a minimum of six screens. Effective designs may have more, if determined to be beneficial to end users. Note that research will be required to determine more specific content of the screens. Expert sources from Deets Library and other professional credible sources will be required to complete this assignment. Therefore, the sources will need to be cited to acknowledge credit for their contributions for concepts, ideas, and facts. The minimum screens are as follows:

1. Control Panel

2. Aircraft Search Screen

3. Add/Update Aircraft Information Screen

4. Add/Update Wheel Assembly Subsystems

5. List All Aircraft

6. List All Wheel Assembly Parts per Aircraft

Deliverables:

1. Brainstorming and sketching: you will need to sketch out your designs by hand. Add notes as necessarily to illustrate the thought process to the LPG Technology Committee.

2. Create a User Flow Diagram to illustrate how a user will interact with your system.

3. Once you have chosen a style for the UI, create a preview of each using a wireframe for each of the seven screens.

4. Finally, create a mockup of the seven screens. These can be static or a clickable prototype. The mockups can be in either PowerPoint or Word, or even submitted in HTML, as you so choose.

Please submit all files as a compressed (*.zip) file via the designated Unit 2 assignment in Blackboard.

Excel_10G_Pharmacy_Supplies

Project Description:

In the following Project, you will import data about pharmacy suppliers. You will edit a worksheet for Pat Shepard, Vice President of Operations, detailing the current inventory of two pharmacy supply types—Hospital and Physician’s Clinic. You will also use the DAVERAGE, the DSUM, and the MAXIFS functions and add alt text to an image.

Open   the file Excel_10G_Pharmacy_Supplies.xlsx downloaded with this project.

Be sure the Pharmacy Suppliers   Info worksheet is active. Click cell A2. From the Data tab, click Get Data,   and then locate and click the command to get data From Microsoft Access   Database. In the Import Data dialog box, navigate to the files downloaded   with this Project. Click the Access file e10G_Pharmacy_Suppliers.accdb,   and then click Import. Select the 10G Pharmacy Suppliers table, and then use   the Load To command to import the data into the Existing worksheet. Close the   Queries & Connections pane.
  Mac Users: Use the file
e10g_Pharmacy_Suppliers_CSV_for_Mac_users.csv,   select the imported data, and on the Insert tab, click Table. Apply Table   Style, Medium 7.

Display the Pharmacy Staff   worksheet. In cell B18, insert a DAVERAGE function using the range A3:F16 as   the database, that calculates the average Hourly Wage for pharmacists and using the   criteria in the range C18:C19. Apply Accounting Number Format to your result   in cell B18.

In cell B21, insert a DSUM   function using the range A3:F16 as the database, that calculates the Wage per   Shift for   pharmacy technicians using the criteria in cells C21:D22. Apply Accounting   Number Format to your result in cell B21.

In cell E18 type Maximum   Pharmacist Hourly Wage   and then use Format Painter to copy the format from cell C18 to cell E18.   Widen column E to 75 pixels.

In cell E19, begin the MAXIFS   function by typing =maxifs( and then as the max range, select the range representing the Hourly Wage of the Pharmacy Staff.   Type a comma, and then as the criteria range, select the range representing   the Status of the Pharmacy Staff.   Type a comma, and then as the criteria, click cell C19. Press ENTER. Apply   Accounting Number Format to your result.

Display the Pharmacy Supplies   Inventory worksheet. Insert a table in the range A7:E42.

Display the Physician’s Clinic   worksheet and copy the range A1:E32. Display the Pharmacy Supplies Inventory   worksheet, and then paste the data into cell F6.

Insert a table in the range   F7:J37 and apply Table Style Medium 7. Apply AutoFit to columns H:I.

Sort both tables by Model # A to   Z and then by Purchase Price Largest to Smallest.

Apply conditional formatting to   the range E8:E42 using the 3 Traffic Lights (Rimmed) icon set.

Apply the same conditional   formatting to the range J8:J37.

In the range C8:C42 create a new   conditional formatting rule using the formula =c8=”Pharmacy spill kit” and setting the format to Bold   Italic with the Red font color.

Delete the Physician’s Clinic   worksheet.

Check the workbook for   Accessibility. On the Pharmacogenomics worksheet, select the image on the   right, and then add the following alt text: Pharmacy supplies Close the Accessibility panes.

Group the four worksheets. From   Page Layout view, insert a header in the right section that displays the   Sheet Name. Go to the footer, and then insert the File Name in the left   section of the footer. Return to Normal view. Press CTRL + HOME to make cell A1   the active cell.

Center the sheets horizontally   on the page. Set the Orientation to Landscape. Set the Width to 1 page and   the Height to 1 page.

Display the document properties.   As the Tags/Keywords, type pharmacy supplies In the Subject box, type your course name and   section number.

On the left, click Print to   display the Print Preview. Scroll through the four worksheets. On the left,   click Save to save your workbook and return to the workbook window.

Save and close the file, and then   submit for grading.

 You are the IT manager of a large corporation. You are planning to use Python to develop statistical models to aid in analyzing your sales data. You are preparing a report for management. Here are the basic requirements for your report:

• Prepare in APA format
• Include references
• Report length: 500 – 700 words
• Briefly describe your company
• Briefly describe Python
• Give overview of Machine Learning
• Report on:’
  • Implementation plans
  • Technical training
  • Python libraries required
  • How Python will be used
  • Types of reports that will be produced

 Exp22_Excel_Ch04_HOE – Toy Store 1.1 

 Exp22 Excel Ch04 HOE – Toy Store 1.1

 Excel Chapter 4 Hands-On Exercise – Toy Store 

Project Description:

You work for the owner of Trinkets Toys & Games LLC. All merchandise is categorized into one of five departments for inventory records and sales. Along with the owner, there are three sales representatives. The sales system tracks which sales representative processed each transaction. The business has grown rapidly and you want to analyze the sales data to increase future profits. You downloaded June 2024 data from the sales system into an Excel workbook. Because the dataset is large, you will convert the data into a table, sort, filter, and utilize conditional formatting to complete your analysis.

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

You would like to set page   breaks on the June Totals worksheet to allow the document to print without   splitting transactions dates.
 

  Modify the existing page breaks to ensure the 6/13 and 6/24 transaction dates   print on the same page.

Create a copy of the June Totals   worksheet and name it June 1st Totals.

Return to the June Totals   worksheet. When printed you would like the titles to be preserved.
 

  Set the titles in row 5 and columns A:B to repeat when printed. Additionally   set the print order to print over then down.

You would like to convert the   dataset to a table in order to add aggregation, structured references, and   table style.
 

  Convert the range A5:K110 to a table. Be sure to include column labels. Name   the table Totals and apply the table style Light Yellow, Table Style Light 19.

You don’t need the Sales_First   column. To reduce the size of the dataset you will remove the column.
 

  Delete the Sales_First column from the table.

You need to document the rebate   information and total purchase price. To do so you will add two new columns   to the data.
 

  Type Rebate in cell K5 and   in cell L5.   Set the width of columns I:J to autofit.

You notice you are missing   records 2024-068 and 2024-105. You will manually add the records back to the   table.
 

  Insert a row in the table at row 73 and row 112. Enter the following records.
  Row 72 – 2024-068, 6/22/2024, Shah, Collectibles, 1014, Mattel,   Store Credit, Standard, 4, $16.99
 

  Row 112 – 2024-105, 6/30/2024, McGowan, Action Figures, 1015,   Mattel, Store Credit, Promotion, 1, $13.49

You notice there are duplicate   values in the table that need to be removed.
 

  Remove all duplicate values from the Totals table.

To calculate rebate amount you   will create an IF function with structured references in column K.
 

Enter an IF statement in cell K6 to   determine the customers rebate. If the value in cell H6 = Promotion the   customer receives a 10% rebate on the total purchase (Purchase Price *   Quantity*Rebate) if they are not eligible the function should return 0. Be   sure to use the appropriate structured references and then use the fill   handle to copy the function down completing the column.

To calculate the total owed you   will create a formula in column L using structured references.
 

  Enter a formula using structured references in cell L6 to calculate the total   owed. The total owed is the purchase price * quantity – rebate. 

You would like to focus a portion   of the report on June sales.
 

  Add a total row to the existing table and set the Rebate and Quantity   subtotals to Sum.

Sort the June Totals worksheet   by Pay_Type A to Z, then by Trans_Type A to Z, and Owed largest to smallest.   For the last level of the sort add a custom list for the department column.   The list should use the following order Electronics, Collectibles, Infants,   Action Figures, and Board Games.

Apply a filter to the table to   only display only electronics department sales from sales rep Radomanski.

Apply a filter to the table to   only display transaction amounts of $300 or more.

Apply a filter to the table to   only display transaction dates between 6/16/2024 and 6/30/2024.

You would like to use   conditional formatting to highlight several key performance indicators in the   June Individual worksheet.
 

  Make the June Individual worksheet active. Create a new conditional   formatting rule to highlight the name Rodriguez in column C with Green Fill   with Dark Green Text.

Create a new conditional   formatting rule to highlight the top 3 sales amounts in column L with light   red fill and dark red text.

Add Blue Data Bars conditional   formatting to column K.

Create a conditional formatting   rule that highlights any transaction in column A that is completed by the   sales rep Rodriguez with a value over $500. Ensure the formatting applies   Bold font with Orange Accent 2 background color. 

Filter column A based on color.

Save and close Exp22_Excel_Ch04_HOE_ToyStore.xlsx.   Exit Excel. 

 Now that you have defined an emerging technology “Nanotechnology” concept,  Write at least 3 pages discussing the following information. 

1.Define the term Nanotechnology concept

2. Strengths and weaknesses; 

3. How the concept is being or could be used in a business setting;

4. A product that has evolved from the concept. 

(Note: 3 different sources APA 7th gen format)

 Describe how you can convert a FASTQ file to a FASTA file. Provide an example algorithm in pseudocode or in bash, python, or R. Show an example of the input as well as the output 

 What are some things you can do to make your worksheet easier for others to read and understand?

describe the strengths and weaknesses of RC4.  When and why was its use discontinued?  What algorithms replaced RC4?. You must use at least 2 scholarly resource.   Every discussion posting must be properly APA formatted. (250 words)

Week 2 Discussion

Week 2 DiscussionConsider, in 500 words or more, how business processes as services can improve efficiency. This discussion is about business process as a service and security. 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. Write in essay format not in bulleted, numbered or other list format.  

Week Two Assignment

Do a bit of research on-line. Find a criminal case that involved Digital Forensics. 
Using WORD, write an ORIGINAL brief essay of 300 words or more describing the case and the how digital forensics were used  in the investigation. Safe Assign is software that verifies the originality of your work against on-line sources and other students. 

Respond to the following in a minimum of 175 words:

• Discuss the differences between the systems development life cycle (SDLC) and the security life cycle.
• Include in your discussion both management and non-management IT security positions that perform security life cycle steps and briefly describe their role.