Posts in category: Uncategorized

Assignment Content

1. Question 1

In virtually all systems that include DMA modules, DMA to main memory is given higher priority than CPU access to main memory. Why? 

Question 2

When a device interrupt occurs, how does the processor determine which device issued the interrupt? 

Question 3

A system is based on an 8-bit microprocessor and has two I/O devices. 

• The I/O con- trollers for this system use separate control and status registers. 
• Both devices handle data on a 1-byte-at-a-time basis. 
• The first device has two status lines and three control lines. 
• The second device has three status lines and four control lines. 
• How many 8-bit I/O control module registers do we need for status reading and control of each device? 

  ***Explain your reasoning and show your mathematical calculations on how you derived your answer 

• Question 4

  A system is based on an 8-bit microprocessor and has two I/O devices. 

• The I/O con- trollers for this system use separate control and status registers. 
• Both devices handle data on a 1-byte-at-a-time basis. 
• The first device has two status lines and three control lines. 
• The second device has three status lines and four control lines. 
• What is the total number of needed control module registers given that the first device is an output-only device? 

  ***Explain your reasoning and show your mathematical calculations on how you derived your answer 

• Question 5

  A system is based on an 8-bit microprocessor and has two I/O devices. 

• The I/O con- trollers for this system use separate control and status registers. 
• Both devices handle data on a 1-byte-at-a-time basis. 
• The first device has two status lines and three control lines. 
• The second device has three status lines and four control lines. 
• How many distinct addresses are needed to control the two devices? 

  ***Explain your reasoning and show your mathematical calculations on how you derived your answer 

• Question 6

  Consider a microprocessor that has a block I/O transfer instruction such as that found on the Z8000. 

• Following its first execution, such an instruction takes five clock cycles to re-execute.
•  However, if we employ a nonblocking I/O instruction, it takes a total of 20 clock cycles for fetching and execution. 
• Calculate the increase in speed with the block I/O instruction when transferring blocks of 128 bytes. 

  **Explain your reasoning and show your mathematical calculations on how you derived your answer 

• Question 7
• What is the difference between memory-mapped I/O and isolated I/O? 

QUESTION ATTACHED

Exp22_Excel_Ch02_ML1 – Katherine’s Coffee Shop Weekly Payroll

Project Description:

You have been hired as the new manager of Katherine’s Coffee shop. As part of your responsibilities, you will be calculating the weekly payroll. The previous manager developed a partial worksheet, but you will enter the formulas to calculate the regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay. In addition, you want to include total pay columns, calculate some basic statistics, and create an employee lookup section. As you construct formulas, make sure you use absolute, relative, and mixed cell references correctly in formulas.

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

Use IF functions to calculate   the regular pay and overtime pay in columns E and F based on a regular   40-hour workweek. Be sure to use the appropriate absolute or mixed cell   references. Pay overtime only for overtime hours. Note employees receive 1.5   their hourly wage for overtime hours worked. Calculate the gross pay in cell   G5 based on the regular and overtime pay. Spencer’s regular pay is $440. With   five overtime hours, Spencer’s overtime pay is $82.50.

Create a formula in cell H5 to   calculate the taxable pay. Multiply the number of dependents by the deduction   per dependent and subtract that from the gross pay. With two dependents,   Spencer’s taxable pay is $422.50.

Insert a VLOOKUP function in   cell I5 to identify and calculate the federal withholding tax. With a taxable   pay of $422.50, Spencer’s tax rate is 25% and the withholding tax is $105.63.   The VLOOKUP function returns the applicable tax rate, which you must then   multiply by the taxable pay.

Calculate FICA in cell J5 based   on gross pay and the FICA rate, and calculate the net pay in cell K5. Copy   all formulas down their respective columns. Be sure to preserve the existing   formatting in the document. Based on the hours Spencer worked he paid $39.97   to FICA and had a weekly net pay of $376.90

Use Quick Analysis tools to   calculate the total regular pay, overtime pay, gross pay, taxable pay,   withholding tax, FICA, and net pay on row 17. (On a Mac, this step must be   completed using the AutoSum feature on the ribbon.)

Apply Accounting Number Format   to the range C5:C16. Apply Accounting Number Format to the first row of   monetary data and to the total row. Apply the Comma style to the monetary   values for the other employees. 

Insert appropriate functions to   calculate the average, highest, and lowest values in the Summary Statistics   area (the range I24:K26) of the worksheet. Format the # of hours calculations   as Number format with one decimal and the remaining calculations with   Accounting Number Format.

Use the XLOOKUP function to look   up the employee name in cell A20 (Wagner) in the payroll data and return the   specified information in row 20. Ensure the return array includes overtime   pay, gross pay, taxable pay, federal tax, FICA and net pay. 

Save and close the workbook.   Submit the file as directed. 

Discussion: What are the common business problems addressed by Big Data analytics?  In the era of Big Data, are we about to witness the end of data warehousing? Why?

Questions: 

1. What is Big Data? Why is it important? Where does Big Data come from?

2. What do you think the future of Big Data will be? Will it lose its popularity to something else? If so, what will it be?

3. What is Big Data analytics? How does it differ from regular analytics?

4. What are the critical success factors for Big Data analytics?

5. What are the big challenges that one should be mindful of when considering implementation of Big Data analytics?

Steps

Here are the Week 1 Lab Instructions

1. Prepare a Word file with the following elements (program code and screenshot) that follows Parts A, B, and C in the instructions.
2. Create a new C++ console project in Visual Studio.
3. Write, test, and debug your program.
4. Paste your final program code into the Lab Report Template (Links to an external site.).
5. Paste a screenshot of your working program into the Lab Report Template.
6. Zip the folder you created when you created your project in Visual Studio. (Make sure Visual Studio is not open when you attempt to zip the folder.)
7. Submit the Word file and the zip file.

 PowerPoint_1G_Northern_Lights

Open   the file Student_PowerPoint_1G_ Northern_Lights.pptx downloaded with this project.

Replace all occurrences of the   text North with Northern and then change layout of Slide   1 to Title Slide.

Apply the Ion theme with the   second, blue variant to the presentation.

Change the Slide Size to   Widescreen (16:9).

Display Slide 2, open the Reuse   Slides pane, and then from your downloaded files browse for and display the   presentation p01G_Slides.pptx. If   necessary, clear the Keep source formatting check box, and then insert the   last two slides.
  Note, Mac users, after importing the slides, delete Slide 3-Alaska Slides. 

Display Slide 2. In either the   slide pane or in the slide outline, click at the end of the first bullet   point after the word time. Press   SPACEBAR. Add the words for viewing and then in the same slide, increase the list   level of the second and third bullet points.

With Slide 2 still displayed,   select the title and change the Font Size to 32. In the Notes pane, type the   following notes: The lights reach their peak in September and March. Be sure to type the period at   the end of the sentence.

Display Slide 3. Select the   paragraph of text, and then change the Font Color to in the last column, the   third color. Change the Font Size to 16, and then apply Bold.

In the same paragraph, change the Line Spacing to 1.5, and then   center the paragraph and the slide title.

With Slide 3 still displayed,   format the picture with the Soft Edge Rectangle picture style and the Marker   artistic effect.

Display Slide 4. In the content placeholder on the right, from your   downloaded files, insert the picture p01G_Lights.jpg.   Apply the Reflected Rounded Rectangle picture style.

Move Slide 3 between Slides 1   and 2.

Display Slide 4. Insert a New   Slide with the Section Header layout. In the title placeholder, type Visit   Fairbanks and View the Northern Lights! In the text placeholder type With Kodiak   West Travel

Apply the Uncover transition and   change the Effect Options to From Top. Change the Timing by increasing the   Duration to 01.25. Apply the transition effect to all of the slides.

Insert a Header & Footer on   the Notes and Handouts. Include the Date and time updated automatically, the   Page number, a Footer with the text 1G_Northern_Lights and then apply to all the   slides.

Display the Document Properties.   Type northern   lights, Fairbanks   as the Tags.
  Note—Mac users use the Keywords box.

refer to the attached document 

  Research programming languages that are used for animation and select the one you feel is the best.  Be sure to include the name of the program, the source of the program, and the cost.  Explain your reasons for selecting this program. Describe a project that you could create using this program.

 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.

Describe how Interaction design using social and mobile Web technologies influence a user to seek information or purchase products online?