In this assignment, you need to reflect on key learned concepts from the course and discuss future IT trends. 

You will write a short reflection report describing the key learning from the course and future trends in IT. This report will be organized as follows:

1. Description – Describe up to 3 key learning points(like security, ERP system, process planning)
2. Analysis – Connect the learnings described in the previous section with the real-world. Analyze how these learnings are applicable in the real business world. Highlight 2 takeaways from your learnings.
3. Future trends – Discuss what you envision in the future. You can discuss the role of new IT systems that will revolutionize business.

The report should not be more than 500 words.

Write a program that generates a set of random numbers and writes them to a file specified by the user. The program will prompt the user to enter the number of random numbers to generate and the full path of the file they wish to save the numbers to. Then the program will generate the random numbers and write them one by one to the file.

 The random numbers should be separated by a new line character. The random numbers should be in the range of 0-100 inclusive. 

Many organizations store all documents, such as medical records, engineering data, and patents, as digital files. 

identify commercial software products that support this form of data storage. 

• Examine the differences between these products and more traditional data storage approaches. 
• Concentrate on efficient use of storage space, internal data representation, and methods of data search and retrieval. 
• What unique capabilities are possible with image-based storage and retrieval? 
• What additional costs and hardware capabilities are required? 
• Examine sites such as     www.databankimx.com, www.intelex.com, and www.xerox.com.

1. Convert the following decimal number to binary:

The number 2618 can be expressed as:

2. Convert the following binary numbers to decimal:

a. The number 1101110101 represents:

b. The number 1011010.011 represents:

3. Convert the following binary number to hexadecimal:

110110110011010

Starting on the right, divide the binary number into sets of 4 digits. Add leading zeros . as needed.

4. Convert the following hexadecimal number to decimal:

C87B

Exp22_Excel_Ch01_Cumulative_Medical

Project Description:

You track your medical expenses each month. You developed a worksheet that contains dates, descriptions, amount billed, and applicable copayments. Your health insurance provider details the amount not covered and how much was covered by insurance. You want to create formulas, format the worksheet to improve readability, and copy the worksheet to use as a template for the next month.

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

You notice that the 3/21/2024   Vision expense on Row 10 is a duplicate of the expense on Row 8. You will   delete the duplicate row.
 

  Select and delete row 10 that contains the duplicate 3/21/2024 Vision data.

You want to move the 3/2/2024   Pharmacy expense to be listed in chronological order.
 

  Select and cut row 11 that contains the 3/2/2024 Pharmacy expense and insert   cut cells on row 5.

You decide to insert a column   for additional data.
 

  Insert a new column A and type Expense # in cell A3.

In the new column, you want to   create a coding system consisting of the year, month, and sequential   numbering for the expenses.
 

  Type 2024-03-001 in cell A4 and use Auto Fill to   complete the expense numbers to the range A5:A11.

After filling in the expense   numbers, you will increase the column width to display the data.
 

  Change the width of column A to 12.

The worksheet should have a   title above the data.
 

  Type March   2024 Medical Expenses   in cell A1 and merge and center the title over the range A1:J1.

The title would look more   professional with some formatting.
 

  Apply bold, Green font color, and 14-pt font size to the title in cell A1.

You decide to replace Lab with   Laboratory to provide a more descriptive expense name.
 

  Find all occurrences of Lab and replace them with Laboratory.

The worksheet contains spelling   errors that need to be identified and corrected.
 

  Check the spelling in the worksheet and correct all spelling errors.

You are ready to enter the first   formula to calculate the adjusted rate.
 

  Calculate the Adjusted Bill in cell F4 by subtracting the Amt Not Covered   from the Amount Billed. Copy the formula to the range F5:F11.

Next, you will calculate the   amount owed.
 

  Calculate the Amount Owed in cell I4 by subtracting the Insurance Paid and   Copay from the Adjusted Bill. Copy the formula to the range I5:I11.

Finally, you will calculate the   percentage paid of the adjusted bill.
 

  Calculate the % Pd of Adj Bill in cell J4 by adding the Copay and Amount Owed   and then dividing that amount by the Adjusted Bill. Copy the formula to the   range J5:J11.

The first row of monetary values   should be formatted with dollar signs.
 

  Apply Accounting Number Format to the range D4:I4.

For the remaining rows of   monetary values, you decide to apply Comma Style.
 

  Apply Comma Style to the range D5:I11.

The percentage paid column needs   to be formatted with percent signs.
 

  Apply Percent Style with one decimal place to the range J4:J11.

Formatting the column headings   on the third row will provide a professional appearance.
 

  Wrap text, bold, and horizontally center the labels in the range A3:J3.

You want to continue formatting   the column headings.
 

  Apply Green fill and apply Thick Bottom Border to the range A3:J3.

You will apply a cell style for   the last three columns that represent your costs.
 

  Apply the Good cell style to the range H4:J11.

For the last column, you want to   format the percentages below the column heading.
 

  Apply Align Right and indent once the data in the range J4:J11.

Changing the page orientation   will enable the data to better fit on a printout.
 

  Select landscape orientation.

Next, you are ready to set the   top margin and center data on the page.
 

  Set a 1-inch top margin and center the worksheet horizontally between the   left and right margins.

To make the data easier to read,   you will increase the scaling.
 

  Set 110% scaling.

Insert a footer with the text Exploring   Series on the   left side, the sheet name code in the center, and the file name code on the   right side of the worksheet.

You will rename the sheet tab   and copy the worksheet to start creating a template for the next month.
 

  Rename Sheet1 as March. Copy the worksheet, place the duplicate to the right, and then   rename it as April.

You will make some changes on   the April worksheet so that it will be ready for data entry.
 

  Change the title to April 2024 Medical Expenses in the April worksheet. Delete   data in ranges A4:E11 and G4:H11. The formula results in column J display   #DIV/0! because you deleted the data, which generates a divide by zero error.   Type 1 in cell D4 and copy the value   to the range D5:D11 as placeholder values to avoid displaying the error   results

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

Question 1(10 Points)

What are the advantages of using a glass substrate for a magnetic disk? 

Question 2 (10 Points)

Explain serpentine recording. 

3.Explain the difference between a simple CAV system and a multiple zone recording system. 

4.What differences between a CD and a DVD account for the larger capacity of the 

DVD? 

5.Consider a single-platter disk with the following parameters:

• Rotation speed: 7200 rpm; 
• Number of tracks on one side of platter: 30,000
• Number of sectors per track: 600; 
• Seek time: one ms for every hundred tracks traversed. 
• Assumption: Let the disk receive a request to access a random sector on a random track and assume the disk head starts at track 0.

 What is the average seek time? 

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

6.Consider a single-platter disk with the following parameters:

• Rotation speed: 7200 rpm; 
• Number of tracks on one side of platter: 30,000
• Number of sectors per track: 600; 
• Seek time: one ms for every hundred tracks traversed. 
• Assumption: Let the disk receive a request to access a random sector on a random track and assume the disk head starts at track 0.

What is the average rotational latency?

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

7.Consider a single-platter disk with the following parameters:

• Rotation speed: 7200 rpm; 
• Number of tracks on one side of platter: 30,000
• Number of sectors per track: 600; 
• Seek time: one ms for every hundred tracks traversed. 
• Assumption: Let the disk receive a request to access a random sector on a random track and assume the disk head starts at track 0.

What is the transfer time for a sector?

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

8.Consider a single-platter disk with the following parameters:

• Rotation speed: 7200 rpm; 
• Number of tracks on one side of platter: 30,000
• Number of sectors per track: 600; 
• Seek time: one ms for every hundred tracks traversed. 
• Assumption: Let the disk receive a request to access a random sector on a random track and assume the disk head starts at track 0.

What is the total average time to satisfy a request? 

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

9.Consider a magnetic disk drive with 8 surfaces, 512 tracks per surface, and 64 sectors per track. 

• Sector size = 1 kB. 
• Average seek time = 8 ms, 
• Track-to-track access time = 1.5 ms, 
• Drive rotates at 3600 rpm. 
• Successive tracks in a cylinder can be read without head movement. 

What is the disk capacity?

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

10.Consider a magnetic disk drive with 8 surfaces, 512 tracks per surface, and 64 sectors per track. 

• Sector size = 1 kB. 
• Average seek time = 8 ms, 
• Track-to-track access time = 1.5 ms, 
• Drive rotates at 3600 rpm. 
• Successive tracks in a cylinder can be read without head movement. 
• What is the average access time?
  **Explain your reasoning and show your mathematical calculations on how you derived your answer  

11. Consider a magnetic disk drive with 8 surfaces, 512 tracks per surface, and 64 sectors per track. 

• Sector size = 1 kB. 
• Average seek time = 8 ms, 
• Track-to-track access time = 1.5 ms, 
• Drive rotates at 3600 rpm. 
• Successive tracks in a cylinder can be read without head movement. 

Assume this file is stored in successive sectors & tracks of successive cylinders, starting at sector 0, track 0, of cylinder i. 

Estimate the time required to transfer a 5-MB file.

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

12. Consider a magnetic disk drive with 8 surfaces, 512 tracks per surface, and 64 sectors per track. 

• Sector size = 1 kB. 
• Average seek time = 8 ms, 
• Track-to-track access time = 1.5 ms, 
• Drive rotates at 3600 rpm. 
• Successive tracks in a cylinder can be read without head movement. 

What is the burst transfer rate? 

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

GO19_AC_CH01_GRADER_1E_HW – Kiosk Inventory 1.0

GO19_AC_CH01_GRADER_1E_HW – Kiosk Inventory 1.0

Project Description:

In this project, you will create database objects to track the inventory of items for sale in a kiosk located in a college snack bar. You will create a table and import data from Excel to create a second table. You will create a simple query, a form, and a report.

Start Access. Open the file Student_Access_1E_Kiosk_Inventory.accdb downloaded with this   project. Create a new table in Datasheet view.

Beginning   in the second column of the table and using the specified data types, create   the following fields (in this order):
 

Item (Short Text), Category (Short Text), Campus (Short Text), Storage Location (Short Text), Price (Currency), Quantity in Stock (Number).

Change   the data type of the ID field to Short Text, rename the ID field to Item ID, and change the field size to 10 Save the table as 1E Inventory.

Add   the following three records to the 1E Inventory table and then close the   table.

Item ID

Item

Category

Campus

Storage Location

Price

Quantity in Stock

C-1

Chocolate Bar

Candy

Southeast

SE100A

.89

250

C-2

Lollipop

Candy

Southeast

SE100A

.5

500

T-1

T-shirt

Clothing

Southeast

SE100B

17.5

100

Append   the records from the downloaded Excel file a01E_Inventory.xlsx to the 1E Inventory table and then open the   table in Datasheet view (the table has 17 records).

Switch   to Design view and delete the Campus field. For the Category field, enter a   description of Enter the category of   the item   and then change the field size to 25.   Save the table.

Switch   to Datasheet view, apply Best Fit to all of the fields in the table, save the   table, and then close the table.

Import   the records from the downloaded Excel file a01E_Inventory_Storage.xlsx into the database as a new table   named 1E Inventory Storage. Designate the first row as column   headings and the Category field as the primary key. Open the Inventory   Storage table in Datasheet view (the table has five records).

Switch   to Design view. For the Location Detail field, change the field size to 35, enter a description of Room and bin number or alternate location of inventory item,   and then save the table.

Switch   to Datasheet view, apply Best Fit to all of the fields in the table, save the   table, and then close the table.

Based   on your 1E Inventory table, use the Query Wizard to create a simple query.   Include only the three fields that will answer the question, For all items, what is the storage   location and quantity in stock?. Keep the default name of 1E Inventory   Query, click Finish to display the query results, and then close the   query.

Based   on your 1E Inventory table, use the Form tool to create a form for the table.   Save the form as 1E Inventory Form, display the form in Form view, and   then close the form.

Based   on your 1E Inventory table, use the Report tool to create a report. Delete   the Category and Price fields from the report. Save the report as 1E Inventory Report.

Sort   the Item ID field in ascending order. Set the width of the Item ID field to 0.75 inch. Set the width of the Storage   Location field to 1.5   inches. Delete the page number from the report, save the report, and then   close the report.

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

Please complete the Lab and follow the detailed below. 

You need to submit a detailed lab report, with screenshots, to describe what you have done and what you have observed. You also need to provide explanation to the observations that are interesting or surprising. Please also list the important code snippets followed by explanation. Simply attaching code without any explanation will not receive credits. 

Assignment:
Provide a reflection on Artificial Intelligence at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. 

Requirements:

• Provide a 500 word (or 2 pages double spaced) minimum reflection.
• Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.
• Share a personal connection that identifies specific knowledge and theories from this course.
• Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. 
• You should not provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.

Demonstrating a simple device driver with Hard IRQ ISR and Tasklet.

In this experiment, we will create a simple device driver for the keyboard.

Create a kernel module that will be our driver.
Call it driver.c

On inserting this driver, an ISR will be attached to the interrupt number associated with our keyboard.
The ISR, whenever executed should schedule a tasklet to be run later on.
The ISR should print ‘Your Name: Caught the IRQ. Urgent work Muhaha’ to dmesg
The tasklet function should print ‘Your Name: Doing the hackey pending work Muhaha’ to dmesg

The end result is that when this module is loaded, from then on pressing any key on your keyboard should print the two messages in dmesg.

Steps to create the handlers inside the module.

You should have two functions that are your ‘work’ – urgent and deferred

static irqreturn_t irq_handler_isr(int, void *);
void tasklet_fn(unsigned long); 

The irq_handler_isr function should print the required message and then create a tasklet_struct, init it and schedule it.

In your module’s init function you should call request_irq() and register the irq_handler_isr function as the ISR for the keyboard’s interrupt number

You can figure out the interrupt numbers that devices are using from the file /procs/interrupts

In your module’s exit function, you should call free_irq() and deregister the irq_handler_isr function.

Create a suitable Makefile, compile your module, insmod the module and enjoy!