IT Labs 22

In this lab, you'll create two lists - one for the ingredients and one for the instructions. HTML supports two types of lists: <ol> for ordered lists, where each item is given a number, and <ul> for unordered lists, where each item is given a generic bullet. With both types of lists, each list item should be enclosed in <li> tags.

<ul> </ul> <ol> </ol>

In this lab, your task is to install DDR4 memory in the computer. All DDR4 memory have a single notch on the bottom, the DDR being the farthest from the middle.

Above the computer, select Motherboard to switch to the motherboard view. Zoom in to identify the memory slots near the upper-right corner the motherboard. On the Shelf, expand Memory Modules. Drag the DDR4 RAM from the Shelf to one of the four DDR4 memory slots on the motherboard.

There are two groups of users who access the Office1 computer, Marketing and Sales. Each group has a corresponding folder: E:\Marketing Data E:\Sales Data In this lab, your task is to:

At the bottom of the screen, click the File Explorer icon. In the File Explorer window, in the left Navigation pane, click This PC. In the right pane, scroll down and double-click the Data (D:) volume. Right-click the Latin 101 folder, and then select Give access to > Specific people.... In the drop-down list, select the user named Sam and then click Add. For the Sam user, change the Permission Level to Read/Write (click the permission level dropdown arrow next to Sam, then select Read/Write). Repeat this process to add the Susan user and give her Read/Write access. In the drop-down list, select the user named John and then click Add. For the John user, make sure the Permission Level is set to Read. Click Share. When prompted that the Latin 101 folder has been shared, click Done. In File Explorer, in the left Navigation pane, scroll up and click the Documents folder. In the right pane double-click the Latin 101 folder. Right-click the lorem.txt file and then click Copy. In the left Navigation pane, scroll back down, expand Data (D:) and then select the Latin 101 folder. Right-click anywhere within the Latin 101 folder and then click Paste.

Disconnect the monitor from the onboard video card. Install the video card with the HDMI connection. HDMI is an interface used by monitors and digital televisions for high-definition content. Provide power to the video card by connecting a 6-pin PCIe power connector from the power supply to the video card. Connect the computer to the monitor using an HDMI cable. In Windows, configure a resolution of 1920x1080 for full HD content. Even though the monitor supports a higher resolution, this is the resolution for HD content.

Disconnect the monitor from the current video card as follows: Above the computer, select Back to switch to the back view of the computer. Above the monitor, select Back to switch to the back view of the monitor. Drag the DB-15 Connector from the computer to the Workspace area. Drag the DB-15 Connector from the monitor to the Shelf. Remove the current video card from the computer as follows: Above the computer, select Motherboard to switch to the motherboard view of the computer. Drag the VGA Video Adapter from the computer to the Shelf. Install a new video card as follows: For each video card on the Shelf, select Details. Select Connectors for the video card to find the one with the HDMI connection. Close the Details window. Drag the HDMI video adapter from the Shelf to an open PCI Express slot on the motherboard. Provide power to the new video card as follows: Select the power supply to provide power to the video card. The video card requires an additional PCIe power connection. Under Selected Component, drag a 6-pin PCIe power connector to the power port on the right side of the video card. Connect the computer to the monitor as follows: Above the computer, select Back to switch to the back view of the computer. On the Shelf, expand Cables. Select the HDMI cable. Under Selected Component, drag an HDMI Connector to the HDMI port on the video card. Under Selected Component, drag an HDMI Connector to the HDMI port on the monitor. Above the computer, select Front to switch to the front view of the computer. Above the monitor, select Front to switch to the front view of the monitor. Click the power button for the computer. Modify the screen resolution as follows: After Windows loads, right-click the desktop and select Display settings. Under Resolution, select 1920x1080. Select Keep changes.

In this lab, you will analyze data in a Microsoft Excel data table. You will then answer several questions: The country with the longest overall life expectancy is ________. The country with the shortest overall life expectancy is ___________. In the Americas, how many more years does the average female live than the average male?

Format cells A3:D43 as a table with headers. Select cells A3 through D43 by clicking and dragging over the cells. On the Insert tab, in the Tables group, click Table. Click OK. Add a total row to the table, showing average life expectancy numbers for each column. Select a cell in the table. On the Table Tools Design tab, in the Table Style Options group, select Total Row. Select B44. Click the arrow button that appears and choose Average. Repeat step three for C44 and D44. Sort the table from longest to shortest overall life expectancy. Click the dropdown arrow next to the Overall Life Expectancy header in B3. Select Sort Largest to Smallest. Analyze the data to determine which country has the longest overall life expectancy: Make sure the rows in the table are sorted from longest to shortest overall life expectancy. Notice the country at the top of the table. Answer Question 1. Determine which country has the shortest overall life expectancy: Make sure the rows in the table are sorted from longest to shortest overall life expectancy. Notice the country at the bottom of the table. Answer Question 2. Use the table to calculate how many more years the average female lives than the average male: Make sure the table includes a total row showing the average life expectancy number for each column. Subtract the value

Open the SalesTraining.pptx file from the Documents folder on your computer. Add a new Title and Content slide at the end of the presentation. Add the title Sales Goals to the new slide. Change the theme of the presentation to Metropolitan. On slide 3, change the chart type to Clustered Bar. Add a Push transition to all slides. Save your changes to the presentation. Run a slide show from the beginning to the end of the presentation, then exit the slide show. REFERENCES

Open SalesTraining.pptx. Click File > Open > This PC. Under the Documents folder, select the SalesTraining.pptx file. Add a new Title and Content slide at the end of the presentation. In the left pane, select the sixth and last slide. On the Home tab, in the Slides group, open the New Slide dropdown. From the New Slide dropdown, select Title and Content. Add the title Sales Goals to the new slide. With the new slide selected, click inside the Click to add title box in the right pane. Type Sales Goals inside the box. Change the theme of the presentation to Metropolitan. On the Design tab, in the Themes group, select the Metropolitan option. On slide 3, change the chart type to Clustered Bar. In the left pane, click the third slide to select it. Select the chart in the right pane. On the Chart Tools Design tab, in the Type group, select Change Chart Type. In the Change Chart Type dialog box, select Bar on the left side of the window. Click OK. Add a Push transition to all slides. In the left pane, click the first slide to select it. On the Transitions tab, in the Transition to This Slide group, select the Push option. In the Timing group, select Apply to All. Save your changes to the presentation. In the upper-left corner of the window, click the Save button. Run a slide show from the beginning to the end of the presentation. In the upper-left portion of the window, click the Start from Beginning button. Click to advance through the slides one at a time. Click one more time to exit the slide show.

How much memory is installed in the computer? What is the speed of the installed processor? What type of power supply is installed in the system? How many SATA hard drives are installed? How many unused USB ports are currently available? What type of video port is currently being used for the monitor? Replace any internal components you have removed and then turn on the computer.

View the detailed motherboard specifications: Above the computer, select Motherboard to switch to the motherboard. Select an area on the motherboard that does not include an installed component such as a power supply cable or memory module. Under Selected Component, open the Details window and then select the Specifications tab. Study the Component Overview diagram to become familiar with the location of various motherboard components. Close the motherboard details window and refer back to it when you need help identifying components. Determine how much memory is installed in the computer: Select one of the two memory modules near the upper-right corner of the motherboard. Under Selected Component, notice that it is an 8 GB memory module. Select the other memory module and notice that it is also 8 GB. Answer Question 1. Determine the speed of the processor: Click and drag the heat sink and fan that is currently on top of the processor to an open area on the workspace. Select the processor. Under Selected Component, notice that the Intel i5 processor has a base frequency of 3.60 GHz. Click and drag the heat sink and fan back on top of the processor. Answer Question 2. Determine the type of power supply in the system: Select the power supply that is directly beneath the motherboard. Under Selected Component, notice that the power supply is ATX. Answer Question 3. Determine the number of installed SATA hard drives: Select one of the three internal hard drives near the bottom-right corner of the system case. Under Selected Component, notice that the hard drive is SATA. Select another hard drive and notice that it is also SATA. Select the last hard drive and notice that it is also SATA. Answer Question 4. Determine the number of available (unused) USB ports: Above the computer, select Back to examine the motherboard connectors. In the upper-left corner of the system case, select the cable connector that is nearest to the top. Notice that these two USB ports are being used. Just to the right of the lower USB cable connector, notice the unused black USB 2.0 port. Just below the lower USB cable connector, notice the two unused blue USB 3.0 ports. To verify that these are USB ports, you may wish to drag one of the installed USB connectors into the other ports. Answer Question 5. Determine the type of video port that is currently being used for the monitor: In the upper-left corner of the system case, select the large cable connector. Under Selected Component, notice that it is a DVI-D connector. Answer Question 6.