test out exam practice

6.4.4 Connect a Cable Modem

You are working on a small office/home office (SOHO) network. You have just signed up for cable Internet access for the network. The cable company has installed the line into your home, and given you a preconfigured modem for your network. All connectors on the wall plate are for WAN connections only. You do not have LAN connections inside your home. Your task in this lab is to: Connect the components to make the Internet connection.Add the cable modem to the Workspace.Connect the modem to the WAN connection using an RG-6 coaxial cable.Connect the computer to the cable modem using a 10/100 Mbps Ethernet connection (RJ-45 cable).Use the AC to DC power adapter to plug in the modem. Use the Network & Internet Settings dialog to confirm that the computer is properly connected to the Internet.

4.5.13 Use Microsoft Word

You finished an initial draft of a news article a few days ago. Now you need to open the saved document in Word and do some formatting and editing: Open BatArticle.docx from the Documents folder on your computer. Change the margins of the entire document to Narrow (0.5" on the top, bottom, left, and right). Select all text in the document and change the line spacing to single-spaced. Change the font size of the title (Local Company...) to 20 Change the font size of the subtitle (Employees Say...) to 14. Select all five body paragraphs, beginning with MAPLETON -- and ending with ...bat encounters. Change the layout of these paragraphs to be in two columns, keeping the rest of the paragraphs in one column. Run the spell checker and use the top suggestion to correct the first misspelling. Ignore all other spelling suggestions. Save your changes to the document.

6.4.12 Configure a VPN Connection

You have been asked to add a VPN connection on a laptop computer in your organization. The sales team uses this computer to deliver sales presentations. They need to establish a secure connection to the company network while working on the road. In this lab, your task is to configure and establish a VPN connection on the Office2-Lap using the following information: Add a VPN Connection as follows:VPN provider: Windows (built-in)Connection name: SalesVPNServer name or address: 198.10.20.12VPN type: Secure Socket Tunneling Protocol (SSTP)Type of sign-in info: User name and passwordDon't allow Windows to remember authentication credentials Set VPN security properties to meet the following requirements:VPN type: Secure Socket Tunneling Protocol (SSTP)Authentication: Microsoft: Secured password (EAP-MSCHAP v2) (encryption enabled) Connect to the VPN as follows:Username: VPNUser12Password: Ro@d24#!

10.5.4 Enforce Password Settings

You have been asked to perform administrative tasks for a computer that is not a member of a domain. To increase security and prevent unauthorized access to the computer, you need to configure specific password and account lockout policies. In this lab, your task is to use the Local Security Policy to configure the following password and account lockout policies: Configure password settings so that the user must:Cycle through 8 passwords before reusing an old one.Change the password every 120 days.Keep the password at least 7 days.Create a password at least 10 characters long.Create a password that meets complexity requirements such as using uppercase letters, lowercase letters, numbers, or symbols. Configure the account lockout policy to:Lock out any user who enters four incorrect passwords.Unlock an account automatically after 30 minutes.Configure the number of minutes that must elapse after a failed logon attempt to 15 minutes.

8.5.7 HTML: Add Headings to a Webpage

In this lab, you'll add some structure to your webpage by creating headings. HTML headings come in six levels, from <h1> to <h6>.For this page, you'll make the title at the top into an <h1> and the instructions heading into an <h2>. The ingredients heading is already formatted as an <h2>.To complete this lab: Format Grandma Jacklin's Famous Biscuits as an <h1>. Format Instructions as an <h2>.

8.5.12 CSS: Resize an Image

In this lab, you'll add styles for the picture and its caption. Right now, the width of the picture doesn't match the width of the <div> that contains it. To fix this problem, add a style that resizes it to be the same width as the <div>.The caption is contained inside another <div> tag (highlighted in green in the HTML file). You'll need to add a CSS selector to center the caption underneath the picture. This should not center any other text.To complete this lab: Make the width of the picture match the width of the wrapper <div>. Center the caption text underneath the picture without centering any other text.

8.5.13 CSS: Change a Page's Fonts

In this lab, you'll add styles to the page's text. The title at the top of the page should be OrangeRed, the two subheadings should be DeepSkyBlue, and all text on the page should be in Arial font.Additionally, some of the text is contained in <span> tags (highlighted in green in the HTML file). These tags are often used for styling specific text within a paragraph. For this page, you'll add a style that italicizes text within <span> tags.To complete this lab: Italicize all text contained in <span> tags. Change the color of the top heading to OrangeRed. Change the color of the subheadings to DeepSkyBlue. Change all text in the document to Arial font.

8.5.8 HTML: Create Ordered and Unordered Lists

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.To complete this lab: Format the ingredients as a bulleted list Format the instructions as a numbered list.

4.2.12 Explore iOS

The purpose of this lab is to help you become familiar with a few iOS settings on an iPad. From the iPad home screen, select Settings. Then explore some of the options and answer the following questions: What is the email address of the owner of the iPad? What is the current status of Wi-Fi on the iPad? What is the current status of Bluetooth on the iPad? The General settings show which iOS version is running on the simulated iPad. What iOS version is installed? In Mail settings, how many lines of messages are set to be displayed in the Preview pane? In Safari settings, what is the default Search Engine?

3.3.10 explore the motherboard

The purpose of this lab is to help you become familiar with the motherboard and other internal components such as the power supply and internal hard drives. Begin by opening the Motherboard view of the computer. To help you identify various components, select the motherboard and view its detailed specifications. Then answer the following questions: How much memory is installed in the computer? What is the speed of the installed processor? (To view and select the processor, remove the heat sink and fan.) What type of power supply is installed in the system? How many SATA hard drives are installed? Open the Back view of the computer and examine the motherboard connectors. Notice which devices are currently plugged in. Then answer the following questions: How many additional (unused) USB ports are currently available on the back panel (including black USB 2.0 ports and blue USB 3.0 ports)? What type of video port is currently being used for the monitor?

9.3.9 Use Microsoft Access Reports to Analyze Data

The purpose of this lab is to walk you through some simple data analysis using a Microsoft Access report. In this scenario, you are using an Access database to keep track of sales data. Open the Total Sales by Product report. Then answer the following questions: The restaurant made ________ from selling drinks. The restaurant sold ___________ Double Mapleton Burgers. The restaurant sold a grand total of __________ items.

9.3.7 Use Microsoft Excel Charts to Analyze Data

The purpose of this lab is to walk you through some simple data analysis using a Microsoft Excel chart. In this scenario, you want to analyze the progression in winning times in the women's 100 meter run at the Olympics since 1928. To more easily interpret and analyze the data, perform the following tasks: Insert a new line chart based on the data in A2:B23. Move the chart to a new chart worksheet called Time Progression. Enable the Data Labels option on the chart. Examine the data table on the Gold Medal Winners sheet, along with the chart on the Time Progression sheet. Then answer the following questions: The current Olympic record in the women's 100 meters was set in ________. The current Olympic record holder is ___________. Use the graph to determine how many winning times were tied in subsequent years?

9.3.5 Use Microsoft Excel Tables to Analyze Data

The purpose of this lab is to walk you through some simple data analysis using a Microsoft Excel table. In this scenario, you want to analyze the life expectancy of various countries in the Americas. To more easily interpret and analyze the data, perform the following tasks: Format cells A3:D43 as a table with headers. Add a total row to the table, then adjust the total row to show the average life expectancy for each column. Use the second column of data to sort the table from longest to shortest overall life expectancy. Examine the data in the table. Then answer the following 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?

6.4.9 Manage Mobile Devices

You are the IT administrator for a small corporate network. A new administrative assistant, Tyrell Lewis, uses an iPad to correspond with employees over email. On the device, his email settings are configured to communicate with an IMAP mail server over the unsecure port 143. Tyrell also needs to use the new password to connect to the wireless network named CorpNet. In this lab, your task is to complete the following: Use the Accounts and Passwords option to go to Tyrell Lewis's email account settings and change the advanced configuration to Use SSL to securely communicate with the IMAP server over server port 993. Connect Tyrell to the CorpNet access point through the Wi-Fi configuration using @CorpNetWeRSecure!& as the password.

10.3.10 Configure iPad Access Control and Authentication

You are the IT administrator for a small corporate network. A new administrative assistant, Tyrell Lewis, uses an iPad to correspond with employees over email. You need to help him make the iPad more secure. The current simple passcode is 1542. In this lab, your task is to complete the following: Set a secure passcode on the iPad:Require a passcode: After 15 minutesNew passcode: H@rd2Guess Configure the iPad to erase data after 10 failed passcode attempts.

4.7.4 Manage Applications

You are the IT administrator for a small corporate network. You have several applications that should not start when the system starts up. In addition, you have an application that needs to run on an older operating system. In this lab, your task is to complete the following on Office1: Use Task Manager to prevent the following applications from running at system startup:Compy DVD AppsDIRE Event MonitorinTuneSM66 Win32 Utility Configure compatibility settings for the C:\Program Files (x86)\AccountWizard\AccountWizard.exe application using the following compatibility mode settings:Run in Windows 8 modeRun in 640 x 480 resolutionRun as an administrator every time

5.3.13 Use a Proxy Server

You are the IT administrator for a small corporate network. You need to configure the laptop computer in the Lobby to use the corporate proxy server. The proxy server is used to control access to the internet. In this lab, your task is to configure the proxy server settings as follows: Address: proxy.corpnet.com Port: 9000

4.3.10 Clear CMOS Settings

You are the IT administrator for a small corporate network. You're working on a computer that was assigned to an employee who just left the company. When you try to start it up, it prompts you for a password. You realize that a user password has been set in the BIOS. On the motherboard, you can remove the battery to clear the CMOS settings. If the motherboard does not have a CMOS battery, there will be a reset button on the motherboard. In this lab, your task is to clear the CMOS settings and then make sure the computer boots into Windows.

5.4.8 Copy Files to OneDrive

You are working on a research paper that is due soon in your Latin 101 class. You've been using your desktop system in your dorm room to write the document. However, you need to do some additional research in the library and in the Latin computer lab in order to complete the paper. To do this, you need to be able to work on the document no matter where you are or what computer system you are using. In other words, you need to copy the document to cloud storage. In this lab, you need to copy the ipsum.docx file from the Documents folder on your desktop system to the Documents folder within your Microsoft OneDrive account.

4.4.6 Assign File Permissions

You have been assigned to work on a group project with several other students in your Latin 101 class. As a part of the collaboration process, you need to share a folder on your computer's hard disk drive to make the files within it available to the other members of the project team through the campus network. The other team members need to be able to open, modify, and save changes to the files in the shared folder. The Teaching Assistant (TA) for the class should also have access to the shared folder, but he should not be allowed to make any changes. Your task in this lab is to: Give Sam, Susan and John access to the D:\Latin 101 folder Grant the following permissions to the shared folder:Sam: Read/WriteSusan: Read/WriteJohn (TA): Read Copy the lorem.txt file from the Documents\Latin 101 folder to the D:\Latin 101 shared folder to make the file available to the other team members.

6.3.13 Configure Network Printing

You have connected a printer directly to the Office1 computer. Now you need to share this printer with other users on the network. In this lab, your task is to share the printer on the Office1 computer and then add the shared printer to the Office2 computer as follows: On Office1:Share the HP LaserJet 3050 PCL 6 printer using the share name HPLaser3050 (no space in the name).While sharing the printer:Allow clients to render print jobs on their own computers.List the printer in the directory. On Office2:Add the shared HPLaser3050 printer connected to Office1 to the list of available printers.Make HPLaser3050 the default printer.

4.3.17 Create Virtual Machines

You have installed Hyper-V on ITAdmin. You would like to install a virtual machine to evaluate some software. In this lab, your task is to create a virtual machine named Test1. Use the following settings for the new machine: Virtual machine name: Test1. Virtual machine location: D:\HYPERV. Generation: Generation 2. Startup memory: 2048 MB - Use Dynamic Memory. Networking connection: Internal. Virtual hard disk name: Test1.vhdx. Virtual hard disk location: D:\HYPERV\Virtual Hard Disks. Virtual hard disk size: 200 GB. Operating system will be installed later. Minimum RAM: 1024 MB. Maximum RAM: 8192 MB.

6.4.6 Connect a Cable Modem and WAP

You recently signed up for cable internet access in your home office. The cable company has come and installed the line into your office. You need to configure the network so that wired and wireless computers can share the cable internet connection. In your office, all connectors on the wall plate are for WAN connections only; you do not have LAN connections inside the office. In this lab, your task is to connect the components to make the internet connection. Add the cable modem to the Workspace.Use a coaxial cable to connect the modem to the WAN connection.Plug in the modem. Add the wireless router to the Workspace.Use an RJ-45 cable to connect the yellow internet port on the router to the cable modem.Use another RJ-45 cable to connect the computer to one of the blue LAN ports on the wireless router.Plug in the wireless router.

10.5.14 Use Windows Defender

You recognize that the threat of malware is increasing. As such, you would like to use Windows Virus & Threat Protection to protect your computer from malware. In this lab, your task is to enable and configure Windows Virus & Threat Protection as follows: Add a file exclusion for D:\Graphics\cat.jpg. Add a process exclusion for welcome.scr. Locate the current threat definition version number. Answer Question 1. Check for updates. Answer Question 2. Perform a quick scan.

5.3.10 Configure Browser Settings

You use Google Chrome as your web browser on the desktop computer in your dorm room. Because you're concerned about privacy and security while surfing the Web, you decide to block pop-ups from banner ad companies. However, you still want the computer to accept pop-ups from legitimate sites, such as your bank's website. You also want to block location tracking and third-party cookies in the browser. Your task in this lab is to configure the content settings in Google Chrome as follows: Configure the pop-up blocker to block all pop-ups and redirects. Remove the doctorevilskeylogger.com site that is currently allowed to use pop-ups. Configure a new exception to allow pop-ups from mybank.com. Block all location tracking in the browser. Block third-party websites from saving and reading cookie data. Block the virusclickjacking4u.org and darkwebphishing.org sites that are currently allowed to use cookies.

5.3.8 Clear Browser Cache

You use Google Chrome for your web browser on the desktop computer in your dorm room. You're concerned about privacy and security while surfing the Web. You're particularly concerned about exploits that harvest data from your Chrome browsing history. Your task in this lab is to clear all Chrome browsing data (all time), including: Browsing history Download history Cookies and other site data Cached images and files Passwords and other sign-in data Autofill form data Site settings Hosted app data

4.4.8 Copy Files from a USB Thumb Drive

A friend in your Latin 101 class took notes for you on a day you were absent. She saved them in a Word document named lorem.docx on a removable USB thumb drive. The thumb drive is currently on the shelf. Your task in this lab is to copy the lorem.docx file from the drive to your desktop system. Complete the following steps: Insert the USB thumb drive into a free USB port. Verify that the system detects the device. Copy the lorem.docx file in the Latin 101 folder on the thumb drive to the Latin 101 folder within the Documents folder on your computer. Remove the thumb drive from the USB port. Be sure to stop the device properly in Windows before removing it.

4.6.5 Install and Configure a Local Printer

An HP LaserJet printer was recently shared throughout your network. You need to connect to the new shared printer and prevent Windows from changing the default printer. In this lab, your task is to: Turn off Windows management of the default printer. Add the shared HPLaser2300 printer. Configure the HPLaser2300 printer as the default printer.

5.6.5 Email Etiquette in Microsoft Outlook

As a sales associate at RMK Supplies, you have several new messages in your Outlook Inbox. Use the following instructions to respond to two messages with proper email etiquette: Respond to Gladys Grant's Project Proposal email:Reply to the sender and all other users who received the message.Enter the following text in the body of your reply:Meeting over lunch works well for me!Just below your reply, insert the My Name signature.After including all of the above information, send the email. Respond to Laticia Washington's Important HR Info email:Save the file attachment to your Documents folder.Reply to the sender of the message (Laticia Washington). Do NOT reply to everyone in the company.Since you know James Jordan has the same question, add him as a Cc recipient.Enter the following text to the body of your reply:Hi Laticia,Thanks for the information! Will our FSA plan change?Ima PersonAfter including all of the above information, send the email.

6.5.8 Explore Network Configuration Information

At the command prompt, use the ipconfig command to find the answers to the following questions: What is the IPv4 address of the workstation? What is the subnet mask? What is the default gateway address? Use the ipconfig /all command to find the answers to two more questions: What is the address of the first DNS server that the workstation will use for name resolution? How did the computer get its IP configuration information?

10.4.6 Configure File Encryption

At work, you share a computer with other users. You want to secure the contents of the Finances folder so that unauthorized users cannot view its contents. In this lab, your task is to: Encrypt the D:\Finances folder and all of its contents. Add the Sam user account as an authorized user for the D:\Finances\2019report.xls file.

4.2.8 Explore the Windows 10 OS

In Windows, tools and programs can be accessed in a variety of ways. You need to complete a specific task in each area you visit. Be sure to complete every task for full credit on the lab. In this lab, your task is to explore the features of the Windows 10 user interface as follows: Configure the screen saver settings.Right-click Start and then select Settings.Maximize the window for better viewing.Select Personalization.From the left pane, select Lock screen.From the right pane, select Screen saver settings.Under Screen Saver, use the drop-down to select Photos.Configure the Wait time to 5 minutes.Select On resume, display logon screen.Select OK to close the Screen Saver Settings dialog.In the top left, select Home to return to the Windows Settings page. Enable Remote Desktop.From Windows Settings, select System.From the left pane, select Remote Desktop.From the right pane, under Enable Remote Desktop, slide the switch to ON.Select Confirm. Use File Explorer to create a folder.Right-click Start and then select File Explorer.From the left pane, expand and select This PC > Data (D:) to open this drive.From the right pane, right-click in white space, and then select New > Folder.In the Name field, type Reports and then press Enter.Close File Explorer. Enable a network adapter.From Windows Settings, select Network & Internet.From the right pane, under Change your network settings, select Change adapter options.Right-click Ethernet and select Enable.Close the Network Connections window.In the top left, select Home to return to the Windows Settings page. Select Score Lab.

8.5.6 HTML: Define a Webpage's Head and Body

In the next several labs, you will create a webpage for a recipe blog. Each lab will pick up roughly where the last one left off.To start, you'll need to define your page's <head> and <body>. The <head> is the part of the document that contains metadata, such as the website title, as well as links to other files. The <body> contains the actual content of the webpage.Right now, the <body> contains two paragraphs of text, each of which should be enclosed in <p> tags.To complete this lab: Add opening and closing tags for the <head>. Add opening and closing tags for the <body>. Add a closing tag to the first paragraph. Add an opening tag to the second paragraph.

8.5.15 JavaScript: Make a Webpage Interactive

In this lab you'll explore how a JavaScript file can give functionality to an HTML page. When the code is set up correctly, it will change the background of the webpage to a random color whenever the button is clicked.To complete the lab, you'll need to tell the JavaScript file which elements on the HTML page it needs to store as variables. In the HTML file, notice how the <body> and <button> tags both have id attributes, which is how the JavaScript file will identify them.To complete the lab: Store the id attribute of the <button> tag in the button variable Store the id attribute of the <body> tag in the body variable

8.3.15 JavaScript: Create a For Loop

In this lab, you will create a for loop that uses the variable i to count by fives from 0 to 50.To complete this lab: Add a value to the comparator to make the loop iterate the correct number of times. Add a value to the console.log so the program displays every fifth number from 0 to 50.

8.5.9 HTML: Add Images and Hyperlinks

In this lab, you'll add a picture to the blog page. The picture should display immediately after the two intro paragraphs.Because the image has a Creative Commons license, you'll need to give it a caption that attributes it to the photographer and links to the license page. In HTML, the <a> tag, which stands for "anchor," is used to define a hyperlink from one page to another.To complete this lab: Add the biscuits.jpg image underneath the two paragraphs. Complete the three <a> tags.

4.4.14 Use Windows PowerShell Commands

In this lab, you'll explore the file system using system commands in Windows PowerShell. Your task is to complete the following: Open a Windows PowerShell (Admin) window. Change to the E: drive. Use dir or ls to view the folders on the E: drive. Answer question 1: Which folders are on the E: drive? Use md to create a folder called Graphics on the E: drive. Change to the D: drive. Answer question 2: Which folders are on the D: drive? Use cd to change into the Graphics folder. Use copy to copy cat.jpg to the E:\Graphics folder. Change back to the E: drive and verify that the cat.jpg file was copied. Use chkdsk D: to check the file system on the D: Data volume. Use Task Manager to identify the process ID (PID) for the Language Application, then use taskkill /pid #### to stop that process. From the root (C: drive), use net use P: \\CorpFiles\Personnel to map the P: drive to the Personnel shared folder on CorpFiles. Change to the P: drive and look at the folders on the drive. Answer question 3: Which folders does the P: drive contain?

8.5.14 CSS: Add a Drop Shadow to an Element

In this lab, you'll put the finishing touches on the blog page by adding new styles to the wrapper <div> (highlighted in green in the HTML file).First, you'll need to add 30 pixels of padding to the <div>. Padding adds some whitespace between the border of a container and its content, which makes the text more readable.Then, you'll need to add a drop shadow, which will set the wrapper apart from the background. The drop shadow should be set 0 pixels to the right and 0 pixels down. In other words, it should be exactly centered behind the wrapper. It should also have 10 pixels of blur and a grey color.To complete this lab: Add a key-value pair to the CSS rule that adds 30 pixels of white space to the inside of the wrapper <div>. Add a value to the box-shadow key to make a grey drop shadow with 10 pixels of blur directly behind the wrapper <div>.

8.3.17 JavaScript: Define and Call a Function

In this lab, you're creating a function that will find the difference between two numbers. The function is called three times (lines 1-3) and is defined at the bottom.When complete, the function should subtract the second argument from the first, then log the result to the console.To complete this lab: Add parameters to the function to make it work correctly.

6.7.7 Fix a Network Connection 2

In this lab, your task is to diagnose and fix the problem. Use the following steps to walk through the troubleshooting process: Open Windows PowerShell and use the ipconfig command to check the initial status of the Ethernet adapter. Answer Question 1. In the top navigation tabs, select Support Office and check to see if the workstation is plugged into the network. Answer Question 2. Check to see if the network link light on the back of the computer is turned on. Answer Question 3. Remove the faulty network cable from the computer and the wall outlet. To support 100 Mbps or greater speeds, connect the Cat6a cable on the shelf to the computer and the wall outlet. Return to the operating system view and use ipconfig to verify the status of the Ethernet adapter. Answer Question 4.

8.3.16 JavaScript: Loop Through an Array

In this scenario you're working on a shopping cart for an online store. The prices of each item in the cart are stored in an array called shoppingCart. As the program calculates the total cost of all items in the cart, it displays a running total after each item is added. When all items have been added, it displays the total cost.To complete the lab: Make the code correctly loop through the array and add the cost of each shopping cart item to the total price.

8.3.14 JavaScript: Create a While Loop

In this scenario, you're working on an adventure video game.The program uses two variables to determine when a monster is defeated. The monsterHealth variable stores the current health of the monster. The weaponDamage variable stores the number of health points the monster loses when it gets hit.As long as the monster has any health remaining, the program should continue "hitting" the monster by printing the damage done to it and its current health. If the monster has no remaining health, the program should instead print "You defeated the monster!"

8.3.13 JavaScript: Create an If...Else Statement

In this scenario, you're working on the phone routing system for a small business. When someone calls, they'll be prompted to enter a number to indicate the reason for their call. The number they enter is stored in a variable called dialedNumber. The output of the code depends on the value of the dialedNumber variable.To complete this lab: Set the value of dialedNumber to make the output show the office hours of the Mapleton location.

4.4.16 Use Linux Shell Commands

In this simulation, you use the Linux commands touch, vi, cp, cd, ls, and rm to manage files from the command line. You are currently in the mbrown home directory. In this lab, your task is to: Delete a file as follows:At the prompt, type ls and press Enter to see a listing of the files in the directory.Type rm old_myfile.txt and press Enter.Type Y to remove the file old_myfile.txt.Type ls and press Enter to see that old_myfile.txt is removed from the directory. Add a file as follows:Type touch new_myfile.txt and press Enter to create a new file in the mbrown home directory.Type ls and press Enter to see that the file new_myfile.txt is created. Add a line to a file as follows:Type vi new_myfile.txt and press Enter to use the vi editor to open the file new_myfile.txt for editing.Press the i key to enter insert mode in vi.Type New line for new_myfile.txt.Press the ESC key.Type :wq and press Enter to save and exit the file. Copy a file to a different directory and rename it as follows:Type cp new_myfile.txt /home/mbrown/practice and press Enter to copy the file new_myfile.txt to the practice directory.Type cd /home/mbrown/practice and press Enter to move to the practice directory.Type ls and press Enter to see that new_myfile.txt is in the /home/mbrown/practice directory.

10.3.8 Create a User Account

Libby has been hired by your organization. She will be using the computer named Office1, and she needs a local account. In this lab, your task is to create Libby's local user account using the Windows Setting application. While creating the new account, use the following information: User information:Username: LibbyPassword: tempP@ss# Security questions:

6.3.11 Pair Bluetooth Headphones with a Mobile Device

You recently purchased a set of Bluetooth headphones that you want to connect with your iPad. In this lab, your task is to complete the following: Add the Bluetooth headphones to the Workspace. Place the headphones into pairing mode. Configure your iPad to connect to the headphones:Enable Bluetooth on the iPad.Pair the Bluetooth headphones with the iPad.

8.5.10 HTML: Link a CSS File to an HTML Page

Now that all the page elements are in place, it's time to start adding styles with CSS. We've created a CSS file for you that has styles for two elements. To view the CSS code, select the tab to the right of the HTML code.The first part of the CSS code specifies a linen background color for everything within the <body> tags, which means it affects the entire page. The next part specifies a margin for everything inside the <div> tags that have the .wrapper class attribute (highlighted in green). It also specifies that the background color of everything inside the wrapper should be white.To make these styles appear, you'll need to tell the HTML document where to find the CSS document by using a <link> tag.To complete this lab: Add the CSS file to the href element of the <link> tag.

8.3.9 JS Code Visualizer: For Loop with Array

One of the most common uses of a for loop is to do something to each item in an array. This activity will demonstrate a for loop that iterates through an array. Use the dropdown to experiment with different variations of the loop. In this example, the code uses a loop to display a list of people's names that are stored in an array. The code uses the length of the list to determine when to stop executing the loop. A message is displayed to let us know when the loop has terminated. To score points for this activity, click Questions in the top-right corner of the screen and use the code visualizer to determine the correct answers.

4.3.8 Find BIOS Settings

Restart the computer and press the F2 or Delete key on your keyboard to enter the BIOS setup program. Then explore the current BIOS settings to find the answers to the following questions: Which brand of processor is installed? How much memory is installed in the computer? What is the BIOS version number? How many hard drives are installed? What is the status of the integrated NIC? What is the current status of the USB 3.0 controller?

6.5.10 Configure TCP/IP Settings

The Ethernet 2 adapter in your computer is physically connected to the lab network using a wired connection, as shown in Exhibits. This adapter is currently configured to use DHCP for its IP address assignment. However, a DHCP server has not been implemented on the lab network, so you must assign a static IP address to this adapter. In this lab, your task is to assign the static IPv4 addressing information to the Ethernet 2 adapter in your computer as follows: For the host IP address, use the last valid IP address within the subnet: 192.168.20.62. For the subnet mask, use the same subnet mask configured on the router: 255.255.255.224. Configure the default gateway with the following address: 192.168.20.33. Configure the preferred DNS server address as: 198.12.11.2.

7.4.14 SQL: Add a New Record to a Table

The database in this example includes a table that stores employee records. In addition to first and last names, the people table stores the department and branch where each person works.To complete this lab, create a SQL query that will add a record for the following new employee to the people table. employeeID: 123456 firstName: Jaime lastName: Rigby department: Support branch: West

7.4.15 SQL: Delete a Record from a Table

The database in this example includes a table that stores employee records. In addition to first and last names, the people table stores the department and branch where each person works.To complete this lab: Create a SQL query that deletes Dana Schwartz's record (the top record) from the people table and leaves all other records intact.

7.4.11 SQL: Select All Records in a Table

The database in this example includes a table that stores employee records. In addition to first and last names, the people table stores the department and branch where each person works.To complete this lab: Create a SQL query that selects all fields for all records in the people table.

7.4.13 SQL: Select Records with Multiple Conditions

The database in this example includes a table that stores employee records. In addition to first and last names, the people table stores the department and branch where each person works.To complete this lab: Create a SQL query that selects all the records for Accounting employees at the Central branch and excludes all other employees.

7.4.12 SQL: Select Records with a Single Condition

The database in this example includes a table that stores employee records. In addition to first and last names, the people table stores the department and branch where each person works.To complete this lab: Create a SQL query that selects all the records for employees at the East branch and excludes all other employees

6.7.3 Fix Network Adapter Problems

The new Broadcom network adapter you recently installed is experiencing very slow transfer speeds. In this lab, your task is to use Device Manager to resolve network adapter issues as follows: Disable the Broadcom network adapter until a fix can be found. Enable the RealTek network adapter to take the place of the Broadcom adapter. Update the drivers for the RealTek network adapter using Microsoft Update.

7.4.5 Microsoft Access Queries

The purpose of this lab is to help you become familiar with Microsoft Access queries. In this scenario, you are using an Access database to keep track of sales data. Open various queries in the database and examine their results. Then answer the following questions: The Employee Phone Numbers query selects records from ___________ table(s). The Products Under $2 query uses which of the following SQL keywords? In the Total Sales by Product query, the Number Sold field counts records from the _____________ table.

7.3.9 Database Design in Microsoft Access

The purpose of this lab is to help you become familiar with Microsoft Access tables and relationships. In this scenario, you are using an Access database to keep track of sales data. Open various tables in the database and examine their fields and relationships. Then answer the following questions: The locations field on the Employees table is set to the ______________ data type. Which of the following tables are related to the Orders table? __________________ is a foreign key field in the Products table.

4.4.11 Configure NTFS Permissions

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: Disable permissions inheritance for E:\Marketing Data and E:\Sales Data and convert the existing permissions to explicit permissions. For each of the above folders, remove the Users group from the access control list (ACL). Add the Marketing group to the Marketing Data folder ACL. Add the Sales group to the Sales Data folder ACL. Assign the groups Full Control to their respective folders. Do not change any other permissions assigned to other users or groups.

8.3.11 JS Code Visualizer: Function

This activity will demonstrate a function. Functions make it so the same lines of code can be used and reused without having to be rewritten. Use the dropdown to experiment with different variations of the code. In this example, a simple function is created to square a number, which means to multiply the value of a number by itself. The code creates a variable, assigns it a value, and then passes this number to the "square" function, which returns the value of that number multiplied by itself. Another variable stores and then displays the number that is returned by the function. To score points for this activity, click Questions in the top-right corner of the screen and use the code visualizer to determine the correct answers. Start Lab

8.3.7 JS Code Visualizer: If...Else Statement

This activity will demonstrate if-else logic. This kind of logic is used to make the code execute differently depending on the circumstances. Use the dropdown to experiment with different variations of the code. In this example, the code checks the value of the "score" variable and determines whether a student passed. A message is displayed on the screen to let the student know their score and whether they need to try again. To score points for this activity, click Questions in the top-right corner of the screen and use the code visualizer to determine the correct answers.

8.3.10 JS Code Visualizer: While Loop

This activity will walk you step-by-step through a while loop. Loops are used to do repetitive tasks many times with only a few lines of code. In this example, the loop will go through each item in an array of foods. As long as the food isn't "Beets", the loop will display a message letting us know which food we ate. However, if the food is "Beets", the loop will terminate and move onto the last line of code. Which is good, because beets are gross. To score points for this activity, click Questions in the top-right corner of the screen and use the code visualizer to determine the correct answers.

8.3.8 JS Code Visualizer: For Loop

This activity will walk you through a for loop step by step. Loops are used to do repetitive tasks many times with only a few lines of code. Use the dropdowns to experiment with different variations of the loop. In this example, the code displays the value of the counter variable "i" for each iteration of the loop. When the logical test stated at the beginning of the loop is no longer true, the console displays a message to let us know the loop has stopped executing. To score points for this activity, click Questions in the top-right corner of the screen and use the code visualizer to determine the correct answers.

10.5.8 Configure Remote Wipe

Tyrell Lewis has lost his iPad. He has a lot of sensitive data on the iPad, and he is concerned that it could fall into the wrong hands. He would like you to help him remotely wipe the iPad. In this lab, your task is to assist Tyrell with the remote wipe as follows: Browse to icloud.com and login using the following credentials: Apple ID: [email protected]: thaiGuy891! Using Find iPhone, select his iPad and erase it. Enter a phone number and message to be displayed on the iPad.

6.3.8 Use a Wireless Network

You and your roommates have just set up a wireless router that will serve as a secure wireless access point in your apartment. Since your desktop computer did not come with built-in WiFi, you will need to install a USB wireless adapter before you can connect to your wireless network. To complete this lab, do the following: Drag the USB wireless adapter from the Shelf and connect it to a USB port on the back of your computer. Switch to the operating system and connect to your secure wireless network using the following information.Network Name: Apt-34Connect automatically: EnabledNetwork Security Key: @SecurePlace&!Allow your PC to be discoverable by other PCs and devices on this network: No

6.3.4 Set Up an Ethernet Connection

You are a network technician for a small corporate network. The owner of the company has asked you to connect a new workstation to the network while a new employee is in an orientation meeting. Your task in this lab is to: Connect the workstation in Office 1 to the Ethernet local area network using an RJ-45 twisted pair cable. Confirm that the workstation (named Office1) has a connection to the local network and the Internet.

4.7.6 Repair Programs

You are having problems with the Security Evaluator program on your computer. In this lab, your task is use the Apps option in the Settings app to repair the Security Evaluator program.

6.3.15 Create a Home Wireless Network

You are in the process of setting up a small office/home office (SOHO) network. You recently changed your Internet Service Provider (ISP) and have an existing Ethernet router connected to an RJ45 jack on the wall plate. You have a new laptop and would like to connect this laptop to the internet with a wireless connection. You need to create a wireless network. In this lab, your task is to create a wireless network as follows: Install the wireless access point as follows:Place the 802.11b/g/n wireless access point on the computer desk.Use an RJ-45 cable to connect the wireless access point to a free LAN port on the existing router.Use a power adapter to connect the wireless access point through an outlet on the surge protector or wall plate. Configure the new laptop to connect to the wireless network:Slide the wireless switch on the front of the laptop to the On position. This will enable the integrated wireless network interface card on the laptop.Use the default settings as you connect the laptop to the TrendNet-BGN wireless network. Allow the laptop to be discoverable by other devices on the network.

5.7.5 Configure Smart Devices

You are the IT administrator for a small corporate network. In your office building, you've installed a smart thermostat, smart light switches, smart cameras, and smart door locks. Using the TestOut Home app, you need to create rooms for where you've installed the smart devices and configure the device settings. In this lab, your task is to complete the following: Create the following rooms for the smart devices in the TestOut Home app:LobbyMain HallOffice 1 Configure the devices in the Lobby as follows:Install the Lobby Camera.Install and configure a smart light switch so you can turn the lights on and off from your iPad. Turn the light on.Install and configure a smart lock so you can lock the front door without leaving your office. Lock the door.Install a smart assistant. Configure the device in the Main Hall as follows:Install and configure the thermostat.Set the temperature to 72 degrees. Configure the devices in Office 1 as follows:Install the Office Camera.Install and configure a smart outlet. Turn the outlet on. The following table identifies the pairing codes for the smart devices:

3.6.8 Troubleshoot System Power

You are the IT administrator for a small corporate network. Over the weekend, another employee in the IT department upgraded some components in the Support workstation. When a Support employee came to work this morning, his computer would not start. In this lab, your task is to troubleshoot the problem and take the necessary steps to get the computer to start. Examine the computer to identify possible problems that would prevent it from coming on. Make sure the power cord between the computer and the power strip is plugged in. Make sure the power supply voltage is set to 115V. Make sure the power supply switch is on.

4.3.12 Update Firmware

You are the IT administrator for a small corporate network. Some of your workstations are having issues, and you need to correct them with a firmware update. In this lab, your task is to complete the following: Restart the computer and press F2 to enter the BIOS. Notice which version of BIOS is currently running. Answer Question 1. Exit the BIOS and use the biosupdater.exe program at the root of C: to update the BIOS. Restart the computer and enter the BIOS again. Notice which version of BIOS is running now. Answer Question 2.

3.5.16 Perform Disk Maintenance

You are the IT administrator for a small corporate network. The CEO has complained about slow performance on her computer. You have determined that the hard disk on her computer needs to be cleaned and defragmented. In this lab, your task is to complete the following: Run Disk Cleanup on the C: drive to do the following:Delete setup log files and temporary files.Do not delete thumbnails. Optimize and defragment both the C: drive and D: drive. Configure the C: drive to be optimized and defragmented on a schedule using the following settings:Run the optimization monthly.Choose only the C: drive for automatic optimization.

3.5.12 Create Volumes

You are the IT administrator for a small corporate network. The computer in Office 1 needs additional hard drive space. You have two hard drives available. You need to install the hard drives and create volumes on those hard drives so that they can be used to store data. In this lab, your task is to complete the following: Install two SATA hard drives in the computer:Use the Motherboard view to install the hard drives into free 3.5" drive bays.For each drive, connect one end of a SATA cable to the drive and the other to a SATA port on the motherboard.For each drive, plug in an available 15-pin SATA power connector from the power supply. Turn on the computer and use Disk Management to initialize both disks using the MBR partition style. Create a volume on Disk 1 with the following properties:Volume size: 300000 MBDrive letter: E:File system: NTFSVolume label: Data Create a second volume using the remaining space on Disk 1 and all of the space on Disk 2 as follows:Drive letter: S:File system: NTFSVolume label: Art

6.7.5 Fix a Network Connection 1

You are the IT administrator for a small corporate network. The computer is connected to the network as shown in the Exhibit. One morning, you find that the workstation in Office 1 can no longer connect to the network. In this lab, your task is to diagnose and fix the problem(s). Use the following steps to walk through the troubleshooting process: Open Network & Internet settings to check the initial status of the network. Answer Question 1. Select Change adapter options to get more information. Answer Question 2. In the top navigation tabs, select Office 1 and plug the workstation into the network. Return to the operating system view and check the status of the network. Answer Question 3. Use Network & Internet settings to view and change the properties of the Ethernet adapter. Since the network does not have a DHCP server, you will need to manually change the TCP/IPv4 properties as follows:IP address: 192.168.0.15 (or another valid address)Subnet mask: 255.255.255.0Default gateway: 192.168.0.5Preferred DNS server: 163.128.80.93 (or another valid address) Verify the final status of the network. Answer Question 4.

4.3.15 Enable VT in the BIOS

You are the IT administrator for a small corporate network. The employee in Office 1 will use her computer to run a virtual machine. You need to enable virtualization technology (VT) in the BIOS. In this lab, your task is to complete the following: Restart the computer. As the computer boots, press F2 to enter the BIOS configuration utility. Enable VT. Save your changes. Restart the computer to verify the changes you have made

6.2.11 Install a Network Adapter

You are the IT administrator for a small corporate network. To accommodate specific network communication needs for an upcoming project, you need to upgrade the network connection's speed for the workstation in the Support Office. In this lab, your task is to complete the following on the Support workstation: Select and install the 1000BaseTX PCIe network interface card, which has with the fastest speed to connect to the local network. Select and install the Cat6a cable to connect the computer to the local area network. In Network & Internet settings, confirm that the workstation is connected to the local network and the internet.

3.5.14 Format Drives

You are the IT administrator for a small corporate network. You are working on the computer in Office 1. In this lab, your task is to complete the following: Insert the flash drive into a USB port in the computer. In Windows, use File Explorer to format the flash drive with the FAT32 file system using Quick Format. Open Windows Powershell and use the convert d: /fs:ntfs command to convert the Data (D:) drive to use NTFS instead of FAT32 without destroying any existing data on the disk.

3.4.15 Set Up a Computer

You have just purchased a new computer for your dorm room. Your task in this lab is to set the computer up by doing the following: Plug the power strip into the wall. Plug the computer into the power strip. Connect the following components to the computer:KeyboardMouseSpeakers Add the monitor to the Workspace, then use the appropriate cables to connect it to the computer and to the power strip. Use a network cable to connect the computer to the network port in the wall plate. Use the following tips to complete this lab: Examine the shape and pin pattern for each connector. Match the correct cable connector to the correct computer port. If necessary, zoom in on the back of the computer or device on the Workspace to get a closer look at the connection ports. In some cases, you can match the color of the connector to the color of the port on the computer to identify possible matches. When you are done connecting devices, click the power buttons on the front of the monitor and the computer to verify that the system starts without errors. If you notice problems, recheck all of your connections.

3.4.11 Connect a monitor

You have just purchased a new desktop computer to be used for schoolwork. To finish setting up your new system, you need to connect the monitor to the back of the computer. Complete the following tasks: Add the monitor to the Workspace. Use the HDMI video cable to connect the monitor to the computer. Connect the power cord to the monitor and then plug it in. Turn on the monitor and the computer.

4.5.15 Use Microsoft PowerPoint

You have started preparing a PowerPoint presentation for your fellow sales associates. Open the presentation file, make the following formatting changes, and then run through a slide show: 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.

6.6.12 Configure Windows Update

You need to customize how Windows Update checks for and installs updates on the ITAdmin desktop system in your organization. In this lab, your task is to configure Windows Update to: Install updates for other Microsoft products when Windows is updated. Allow the installation of feature updates to be deferred 60 days. Allow quality updates to be deferred 30 days.

4.3.4 Update Drivers

You need to update the drivers for two devices in your system, the Realtek network adapter and the Mustek scanner. You have downloaded the driver for the network adapter to a USB thumb drive that is currently on the Shelf. In this lab, your task is to update the necessary drivers as follows: Insert the USB thumb drive in a free USB port. Use Device Manager to update the driver for the network adapter using the driver on the USB thumb drive. Use Device Manager to update the driver for the scanner by searching Windows Update for the new driver.

10.4.8 Secure a Home Wireless Network

You recently created a home wireless network to allow your laptop and mobile devices to make a connection to the wired network and the internet. However, without additional configuration, the wireless access point will allow connections from any laptop or mobile device within range. You need to secure the wireless network from unauthorized access. To view and configure the wireless access point: Use Chrome on Home-PC. Go to 192.168.0.254, and use the following default authentication credentials:Username: adminPassword: password In this lab, your task is to secure the wireless network using the following settings: Change the settings on the wireless access point as follows:Use FlyingFirstClass for the SSID. The SSID name is case sensitive.Use WPA2-PSK authentication, with AES for encryption.Configure H@rd2Guess as the pass phrase. The pass phrase is case sensitive. Change the wireless access point's administrator authentication credentials from their defaults as follows:Username: @dm1nPassword: SomethingSecure!Do not save the credentials in Chrome. Return to the Computer Desk and configure the laptop to connect to the wireless network and save the wireless profile with the settings as listed above.

4.5.11 Use Desktop Applications

You recently purchased a desktop computer that you will use to research and write papers for your college courses. Your computer came with a recent version of Microsoft Office pre-installed. You are not familiar with this version of Office, so you decide to spend some time exploring it. Additionally, because you expect to use Word frequently, you want to make it easy to launch. To complete this lab, do the following: Launch the Word 2019 application from the Start Menu. Open the file named ipsum.docx located in the Documents folder on your Computer. Make changes of your choosing in the document. Save your changes to ipsum.docx and then close the file. Pin the Word 2019 application to the Start Menu. Drag an Excel 2019 application shortcut from the Start Menu to the desktop.

4.6.7 Print a Document

You recently purchased a new Canon Inkjet printer and connected it to your desktop computer system, using a USB cable. You now need to use your new printer to print a homework assignment for your Latin 101 class. To complete this lab, you need to do the following: Configure the Canon Inkjet printer to be the default printer. Start Microsoft Word. Open the ipsum.docx file, located in the Documents folder on your Computer, in Microsoft Word. Print ipsum.docx on the Canon Inkjet printer, using the default printing options.

4.2.10 Change Windows Settings

You recently purchased a new monitor for your desktop computer system. Your old monitor used a display resolution of 1280 x 1024. However, your new monitor uses a much higher display resolution. You need to change your display settings in Windows to match what is supported by the monitor. To protect your new monitor, you want the screen saver to come on after the system has been idle for a brief period of time. In addition, you want to require the user to log in before the screen saver will deactivate. Your task in this lab is to: Set the display resolution to 1600 x 900. Set the screensaver to Ribbons. Configure the screensaver to activate after the system has been idle for 10 minutes. Require the user to log on before resuming.

3.4.13 Install Peripherals (USB Devices)

You recently purchased a new mouse, digital video camera, and scanner. You need to connect them to your computer, but it doesn't have enough USB ports. You need to install a USB hub to provide enough connections for these devices. Complete the following tasks: Connect the mouse to the computer. Add the USB hub to the Workspace and then connect it to the computer. Connect the scanner to the USB hub. Connect the video camera to the USB hub.

3.6.14 Troubleshoot SATA Devices

You work at a computer repair store. A customer is having trouble with their hard drives. The computer recognizes the top hard drive, which contains operating system files. But it is not recognizing the bottom drive. In this lab, your task is to diagnose and correct the problem. Use the following steps to walk through the troubleshooting process: Press the power button on the computer, then press Delete to enter the BIOS. Notice how many SATA drives are being detected. Answer Question 1. Turn off the computer and switch to the motherboard view. Verify that the red data cable is properly connected from the bottom hard drive to the motherboard. Answer Question 2. Verify that power is properly connected from the power supply to the bottom hard drive. Answer Question 3. Use the Power Supply Tester on the shelf to verify that the bottom hard drive is receiving adequate power. Drag the tester to the Workspace. Drag the 20+4 pin power supply connector from the motherboard to the main tester port (far right). Then drag the 15-pin SATA power connector from the bottom hard drive to the SATA port on the tester (bottom left). Answer Question 4. Replace the red data cable on the bottom hard drive with a known good cable one the shelf. Press the power button on the computer, then press Delete to enter the BIOS. Answer Question 5. Return to the Bench view and turn off the computer. Disconnect the data and power cables and replace the bottom hard drive with the new drive on the shelf. After reconnecting the cables, turn the computer back on and verify that both drives are detected in the BIOS. Answer Question 6. If you wish, exit the BIOS, wait for Windows to load, and then run Disk Management to verify that Windows recognizes both disks.

3.6.10 Troubleshoot Memory

You work at a computer repair store. A customer reports that his computer will not boot to Windows. You suspect that one or more memory modules might not be working. You've observed that four 2-GB memory modules for a total of 8 GB of memory (8,192 MB) are installed. However, when you boot the computer, the screen is blank, and the computer beeps several times. In this lab, your task is to diagnose and correct the problem as follows: Identify which memory modules work and which are broken. Hint: The computer will not boot if any non-working modules are installed. Place the two non-working memory modules on the Shelf. Install the two working modules (DIMM5 and DIMM6) from the shelf to maximize memory usage using the recommended memory configurations for the motherboard. Boot the computer to Windows and use the System option in the Settings app to verify that all installed memory (8 GB) is detected.

3.3.14 upgrade a video card

You work at a computer repair store. A customer wants to upgrade the video card in his computer to provide more memory, faster processing power, and additional features. He wants to be able to do the following: Use the computer to watch high-definition movies from a Blu-ray player. Connect his monitor to the computer using a connection designed for high-definition content. In this lab, your task is to complete the following: Disconnect the monitor from the current video card and remove the card from the computer. 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 selecting the power supply and then dragging a 6-pin PCIe power connector to the power port on the right side of 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.

3.6.12 Troubleshoot Processor Installation

You work at a computer repair store. You just upgraded the processor in a customer's computer. The customer purchased the latest AMD Phenom II processor, and you installed it in the computer. There is another AMD Phenom II processor on the Shelf. However, the computer will not start now. In this lab, you task is to diagnose and correct the problem. Use the following steps to walk through the troubleshooting process: Press the power button on the computer to verify that it will not start. Select the motherboard and view the specifications to identify the location of the CPU socket and fan power connector. Answer Question 1. Close the motherboard specs and verify that the CPU heat sink and fan assembly is installed. Answer Question 2. Answer Question 3. Based on your findings, you will need to replace the CPU.Temporarily remove the heat sink and fan to the Workspace.Remove the bad CPU and place it on the shelf.Install the new AMD AM3 CPU from the shelf onto the motherboard.Re-install the heat sink and fan onto the CPU socket.Verify that the fan power connector is still connected to the motherboard. Turn on the computer and verify that it boots into Windows.

3.3.12 install memory

You work at a computer repair store. You're building a computer using spare parts. In this lab, your task is to install a DDR4 memory module in the computer. Examine the motherboard and locate the four memory slots near the upper-right corner. If necessary, zoom in or check the motherboard specifications to identify the memory slots. Install a single memory module in the motherboard.

3.5.5 Install SATA Devices

You work part-time at a computer repair store. You're building a new computer. The customer has requested two serial ATA (SATA) hard drives in the computer. In this lab, your task is to complete the following: Install both hard drives in the computer.Read the motherboard documentation to identify the location of the internal SATA connectors.Use the Drive Bays view to install the hard drives into free 3.5" drive bays.For each drive, connect one end of a SATA cable to the drive and the other to a red SATA port on the motherboard.Switch to the Motherboard view to plug in the correct SATA power connector from the power supply for both drives. Boot the computer into the BIOS and verify that both drives are detected. (To enter the BIOS, restart the computer and press F2.)

7.4.7 Create Queries for a School Database

You're an administrator at a small community college. You're building an Access database to keep track of students, courses, and grades. In this scenario, you've already created tables for your data, defined relationships between the tables, and filled the tables with data. Now you're ready to create queries to help you analyze and make sense of your data. Perform the following task: Create a query to show all grades below 70. This query should include the first and last name fields from the Students table, the courseName field from the Courses table, and the Grade field from the Enrollments table. Save this query and name it Grades Under 70.

7.3.11 Tables and Relationships

You're creating a database to keep track of employees and customers in a small company. In this scenario, you'll create a new table for customers, and create a relationship to link the table of employees with the table of employee phone numbers. Perform the following tasks: Create a new table for customers.At the top of the screen, click the Create tab, then click Table Design.In the first row of the grid, set the field name as CustomerID and the data type as Autonumber. Click the Primary Key button at the top-left corner of the screen to make this field the primary key.In the second row of the grid, set the field name as firstName and the data type as Short Text.In the third row of the grid, set the field name as lastName and the data type as Short Text.At the top-left corner of the screen, click the Save icon. Change the name of the table to Customers and click OK. Create a one-to-many relationship to link the Employees table to the PhoneNumbers table.At the top of the screen, click the Database Tools tab, then click Relationships.On the Show Table dialog box, double-click Employees and PhoneNumbers, then click Close.Drag the EmployeeID field from the Employees table (primary key) to the EmployeeID field of the PhoneNumbers table (foreign key).On the Edit Relationships dialog box, check the box next to Enforce Referential Integrity, then click Create.

7.2.7 Explore an Access Database

You've recently created an Access database to keep track of sales data. Now you need to make a few minor record changes, print a report, and modify some other database objects. Perform the following tasks: Delete Ronald Fisher's record (#12) from the Customers table. In the Orders form, change the order for record 11 from Combo #1 to Combo #2. Print the Total Sales by Product report. Change the name of the Sales This Week query to Total Sales This Week. Delete the Products Under $2 query.

4.4.4 Manage Files and Folders

Your major requires you to take Latin 101 during your sophomore year in college. You are using your Windows notebook and Microsoft Office to complete your first homework assignment. In addition to copying and renaming files from your USB thumb drive, you need to delete an unneeded file on your hard drive and restore a file that you accidentally deleted. Complete the following tasks: Create a new folder named Latin 101 in the Documents folder on your PC. Copy the D:\ipsum.docx file to the Latin 101 folder you just created in Documents. Delete the lorem.docx file from the Documents folder. Rename the D:\ipsum(draft).docx file to ipsum_draft.docx. Restore the ipsum2.docx file from the Recycle Bin to the Documents folder. Empty the Recycle Bin.

10.2.15 Recognize Social Engineering Exploits 2

Your roommate Mia has received several suspicious emails that she is not sure about. She has asked for your help to determine what to do with them. In this lab, perform the following tasks: Read each email in her inbox and determine if it is legitimate. Delete any emails that appear to be hoaxes. Delete any emails that appear to contain malicious attachments. Keep any emails that are safe.

10.2.13 Recognize Social Engineering Exploits 1

Your roommate Mia has received several suspicious emails that she is not sure about. She has asked for your help to determine what to do with them. In this lab, perform the following tasks: Read each email in her inbox and determine if it is legitimate. Delete any emails that appear to be phishing or whaling attacks. Keep any emails that are safe.

10.5.18 Configure Windows Firewall

Your roommate showed you an error message on her Windows 10 notebook system indicating that the firewall is turned off. She has asked you to fix the issue for her. Your task in this lab is to configure the Windows Firewall as follows: Turn on the Windows Firewall for the Private network profile. Turn on the Windows Firewall for the Public network profile. Add the Arch98 application to the list of applications allowed to communicate through the firewall for all network types.