Core Module 1 - Lab Manual.pdf

Activity 5 Aim: Crimp CAT 6 cables using crimping tool Learning outcome: Able to use basic PC hand tools effectively. Duration: 0.5 hour List of Hardware/Software requirements: 1. CAT 6 Cables 2. Crimping Tool 3. Connectors Code/Program/Procedure (with comments): Step 1 This procedure...

Activity 5 Aim: Crimp CAT 6 cables using crimping tool Learning outcome: Able to use basic PC hand tools effectively. Duration: 0.5 hour List of Hardware/Software requirements: 1. CAT 6 Cables 2. Crimping Tool 3. Connectors Code/Program/Procedure (with comments): Step 1 This procedure generally applies to Cat 6 RJ45 connectors. An alternate method is given for connectors utilizing a "load bar". Step 2 Cut the cable to the length needed. If you plan to use snag less boots, this would be a good time to slide them on. Be sure the boots will be facing "out" towards the connector. © © Edunet Foundation. All rights reserved. 14  Snaggle boots Step 3 Strip back the cable jacket approximately 1 inch. Use the cutter provided with the crimping tool or strip by hand. Be careful not to nick the individual wires. Un-twist each of the 4 pairs and straighten each wire as much as possible between the fingers. Step 4 Use the 568-B wiring scheme on both ends for a standard patch cable. © © Edunet Foundation. All rights reserved. 15 Step 5 Bring all of the wires together as closely as possible. Hold the grouped (and sorted) wires together tightly between the thumb, and the forefinger. Cut all of the wires at a perfect 90-degree angle from the cable, 1/2 inch from the end of the cable jacket. Use a sharp cutting tool so as not to "squash" the wire ends. Step 6 With the connector pins facing up, carefully insert the wires into the connector. Apply a moderate amount of force in order to properly seat the wires against the contacts in the connector. Alternate for "load bar" Type Connectors A. Note that the load bar has slots on one side with a flanged edge on one end. The slotted side should face the pins inside the connector. The wires are inserted into the flanged end. B. Hold the grouped (and sorted) wires together tightly, between the thumb, and forefinger. Cut all of the wires at a sharp angle from the cable. Use a sharp cutting tool so as not to "squash" the wire ends. © © Edunet Foundation. All rights reserved. 16 C. Hold the load bar so the staggered holes face toward the cable. Insert the wires through the load bar, one at a time, carefully observing the orientation. Slide the load bar as far down as possible. D. Cut off the excess wire ends with a straight cut about 0.25" past the load bar. With the connector pins facing up, slide the load bar assembly into the connector. Ensure that the wires are firmly seated to the end of the connector. The brown pair wires should be on the right side. Step 7 Observe the tip of the connector to confirm that all the wires are fully inserted. The end of each wire you should be in full view. There should be enough of the cable jacket inside the connector to crimp against. Tip: Slide the load bar forward as necessary to provide the ideal placement. © © Edunet Foundation. All rights reserved. 17 Step 8 Place the connector into the crimp tool, and squeeze hard so that the handle reaches its full swing. Step 9 Repeat the process on the other end using the desired wiring scheme. Be sure to slide the snag less boots snugly over the connectors when finished. Before Crimping After Crimping Step 10 Always use a cable tester to check for continuity, opens and shorts. © © Edunet Foundation. All rights reserved. 18 Step 11 Building patch cables takes practice so keep at it until you master your technique! Output/Results snippet: References: https://www.warehousecables.com/how-to-make-a-cat6-patch-cable http://watcherprotect.net/wp-content/uploads/2016/02/Crimping-Guide.pdf © © Edunet Foundation. All rights reserved. 19 Activity 1 Aim: Prepare Hard disk for OS installation by making partitions Duration: 2 hours 1. Reboot your computer with the OS installation disc inserted into a USB slot or DVD drive. 2. Click “Next” on the “Install…” screen after selecting the appropriate localization options. 3. Select a “Custom” install from the next screen and click "Next." 4. Select “Drive Options” on the “Custom Install” screen and click "Next." 5. Select the Partition you wish to format and click "Next." 6. Select either a full or quick format. A quick format marks all data as cleared, but does not eliminate the data. A full format overwrites existing data on the drive with blank "data." Windows 10 and 11 To create a partition from unpartitioned space follow these steps: 1. Right-click This PC and select Manage. 2. Open Disk Management 3. Select the disk from which you want to make a partition. 4. Right-click the Unpartitioned space in the bottom pane and select New Simple Volume. 5. Enter the size and click next, and you are done. Windows 8 and 8.1 To create a partition from unpartitioned space follow these steps: 1. Hold the Windows key on your keyboard and press R. 2. This launches the Run the utility. Type diskmgmt.msc inside the text box and press Enter. This opens the Windows Disk Management utility. 3. To create unallocated space, you need to shrink your hard drive. When you shrink your hard disk, the remaining space becomes unallocated. 4. To do this, right-click your main drive and select Shrink Volume 5. Now you need to enter the amount you want to shrink the hard disk by in megabytes 6. After the Shrink is done, you will then see the region of unallocated space (shaded black). Remember, this space is not yet usable. © © Edunet Foundation. All rights reserved. 77 7. Right-click the region of unallocated space and select New Simple Volume. 8. This launches the New Simple Volume Wizard. This guides you through the installation process. 9. Assign the disk a drive letter. You can choose any drive letter that is not currently in use. 10. Select a file system for the disk. The file system is basically the type of format or foundation “the storage device has. If you plan on installing a Windows operating system to the partition select the NTFS file system. 11. Name the partition in the Volume Label text box. You can choose any name for your partition. 12. Now click Finish to create the new partition. © © Edunet Foundation. All rights reserved. 78 Activity 2 Aim: Install Operating System Windows and Linux in two different partitions Duration: 2 hours Install Windows. If you haven't already done so, you should install Windows before installing any other operating systems. Other operating systems, such as Linux are designed so they can work alongside Windows. If you have not installed an operating system on your PC, make sure you install Windows first. The exception is if you are trying to dual-boot Windows alongside macOS on a Mac. Macs are built a little different than most standard PCs and generally come with macOS already installed. © © Edunet Foundation. All rights reserved. 79 2 Navigate to https://rufus.ie/ in a web browser. This is the web page to download Rufus which is a tool used to create a USB install drive that you can use to install an operating system on your computer. You can also use an official install CD or DVD. 3 Download and install Rufus. Use the following steps to download and install Rufus from the download page. Scroll down and click Rufus 3.8 Run the "Rufus-3.8.exe" from within your web browser or Downloads folder. 4 Download a disk image (ISO) for the operating system you want to install. A disk image is data that goes on an install disk, DVD or USB drive. You will need to go to the website of the operating system you want to download and download the ISO file from that website. The following links contain operating system ISO images you can download: © © Edunet Foundation. All rights reserved. 80  Windows 10 Windows 8 Windows 7 Ubuntu Linux Mint Debian Installing macOS on a non-Apple computer is more complicated than installing other operating systems, but it is possible. 5 Insert a blank USB flash drive. Make sure the USB drive has enough space for the operating system you want to install. Also, make sure the USB drive you use doesn't have any important data that you don't want to lose. Insert the USB drive into an open USB port on your computer. 6 Open Rufus. It has an icon that resembles a USB flash drive. Click the Rufus icon in your Windows Start menu to open Rufus. © © Edunet Foundation. All rights reserved. 81 7 Select your USB flash drive. Use the drop-down menu below "Devices" to select your USB flash drive. 8 Click Select. It's the button to the right of "Boot Selection" in Rufus. This opens a file browser you can use to select the ISO file for the operating system you want to install. © © Edunet Foundation. All rights reserved. 82 9 Select the operating system ISO file and click Open. This loads the ISO file into Rufus. 10 Click Start. It's at the bottom of Rufus on the right. This starts the process of righting the ISO file to the USB drive. This may take a while to complete. Part2 Creating a Disk Partition © © Edunet Foundation. All rights reserved. 83 1 Make a backup of any important data files. You can usually partition a disk drive and install a new operating system without losing any important data. However, it's a good idea to backup any important data on your disk drive before you start partitioning and installing a new operating. 2 Right-click the Windows Start menu. It's the icon with the Windows logo. By default, it's in the lower-left corner in the taskbar. © © Edunet Foundation. All rights reserved. 84 3 Click Disk Management. It's in the menu that appears when you right-click on the Windows Start menu. This opens the Disk Management window. 4 Right-click your Windows installation drive. This is the drive that Windows is installed on. Usually, this is the "C:" drive. © © Edunet Foundation. All rights reserved. 85 5 Click Shrink Volume. It's in the window the menu that pops up when you right-click on a disk drive in Disk Management. 6 Enter the amount of space you want to allocate to the new operating system installation. Type the number of megabytes (MB) you want to partition from the disk drive in the field next to "Enter the amount of space to shrink in MB". Make sure you enter the minimum space required to install the new operating system. To convert GB to MB, simply multiply by 1000. For example, 40 GB is equivalent to 40,000 MB. © © Edunet Foundation. All rights reserved. 86 7 Click Shrink. This creates a new partition of unallocated space on your hard drive. Part3 Preparing Your Computer 1 Turn off Fast Boot. The following steps allow you to turn off Fast Boot on Windows. Click the Windows Start menu. Type Control Panel and click the Control Panel icon Type Power Options in the search bar in the upper-right corner. Click "Choose what the power button does". Click "Change settings that are currently unavailable". Make sure the box that says "Turn on fast startup (Recommended)" at the bottom is not checked. Click Save changes. © © Edunet Foundation. All rights reserved. 87 2 Enter your computer BIOS. You'll need to make some changes to the BIOS in order to install a second operating system. The method for entering the BIOS is different from one computer make and model to the next. On some computers, you can enter the BIOS by pressing one of the functions keys (F1, F2, F9, F12), Esc, or Delete while your computer boots up. You can also use the following steps to reboot into the BIOS from within Windows: Click the Windows Start menu. Click the Power icon. Hold "Shift" and click Restart. Click Troubleshoot. Click Advanced Options: UEFI Firmware Settings Click Restart. © © Edunet Foundation. All rights reserved. 88 3 Disable Secure Boot. The BIOS menu is different from one computer make and model to the next. Use the arrow keys on your keyboard to navigate the BIOS menu. Secure Boot is usually found in the Security, Boot, or Authentication menu. Locate Secure Boot and set it to "Disabled". 4 Set the Boot order to boot from a USB drive first. This is usually found in the Boot menu. Locate the boot order menu and set it so it boots from a USB drive first. If you are using an install CD or DVD, set it to install from the CD/DVD-Rom 5 Save your settings. After making the necessary changes to your BIOS system, locate the option to save your settings. Select the option to save and exit the BIOS to save and reboot your computer. Part4 Installing a Second Operating System © © Edunet Foundation. All rights reserved. 89 1 Insert the install disk. If you used Rufus to create a USB install disk, insert the USB flash drive into an open USB port on your computer. If you are using a CD or DVD install disk, insert it into your CD/DVD Rom drive. 2 Restart your computer. If your computer is powered on, go ahead and restart it. Otherwise, press the power button on your computer so that it boots from the install disk. © © Edunet Foundation. All rights reserved. 90 3 Wait for the setup program to load. If your computer properly boots from the Install disk, you should see the setup program for the operating system. 4 Select your language and keyboard layout. The setup program for each operating system is a little different. Generally, you will start by selecting your language and keyboard layout. © © Edunet Foundation. All rights reserved. 91 5 Enter the CD Key or serial number (if needed). Some operating systems, such as Ubuntu are free to install. Other operating systems, such as Windows, require you to purchase a CD key or serial number. If asked to enter a serial number or CD key, enter the numbers in the space provided. 6 Select the "Custom" or "Other" installation option. When selecting the installation type, select "Custom", "Other", "Something Else" or similar. Selecting a standard installation may overwrite your current operating system. © © Edunet Foundation. All rights reserved. 92 7 Format the drive you want to install the operating system on. When installing a new operating system, you will be asked to select which drive you want to install it on and format the drive. Select the unallocated space you partitioned earlier. If you are installing Linux you will need to format the drive as Ext4 If you are installing Ubuntu, you will also need to format a section of the unallocated space as a swap area. This area should be equivalent to the amount of RAM you have installed on your computer. 8 Follow the instructions to complete the installation. You will most likely be asked to create a username and password for your new operating system as well as set your time & date settings. Follow the instructions to complete the installation. © © Edunet Foundation. All rights reserved. 93 9 Reboot to switch between operating systems. Once you install two or more operating systems on your computer, you will see a menu asking which operating system you want to load when you boot up your PC. Restart your computer to switch between operating systems. References : https://www.wikihow.com/Install-Two-Operating-Systems-on-One-Computer © © Edunet Foundation. All rights reserved. 94 Activity 4 Aim: Install/Uninstall Application software (Office, Multimedia and Antivirus) Duration: 2 hours Install Office 1. Depending on your browser, select Run (in Microsoft Edge or Internet Explorer), Setup (in Chrome), or Save File (in Firefox). If you see the User Account Control prompt that says, Do you want to allow this app to make changes to your device? select Yes. The install begins. 2. Your install is finished when you see the phrase, "You're all set! Office is installed now" and an animation plays to show you where to find Office applications on your computer. Select Close. Installation or sign in issues? Tip: You can download and install the Microsoft Support and Recovery Assistant to help with Microsoft 365 installation issues on a PC. For more information, see About the Microsoft Support and Recovery Assistant. © © Edunet Foundation. All rights reserved. 98 If you're having an installation issue such as Office taking long to install, try Need help? for a list of common issues. Activate Office 1. To open an Office app, select the Start button (lower-left corner of your screen) and type the name of an Office app, like Word. If you have Windows 8.1 or 8.0, type the name of an Office app on the Start screen. Can't find your Office apps? 2. To open the Office app, select its icon in the search results. 3. When the Office app opens, accept the license agreement. Office is activated and ready to use. If you have a Click-to-Run or an MSI installation, uninstall Office using the Control Panel or download the uninstall support tool. Option 1 - Uninstall Office from the Control Panel 1. Open the Control Panel. Tip: If you installed the Office apps as part of a suite, such as Office Home and Student or Microsoft 365, search for the suite name. For stand-alone apps search by the app name, such as Project or Visio. In most cases you can't uninstall an individual app if it's included in your Office suite. The only way to uninstall an individual app is if you purchased it as a stand-alone app. How you open the Control Panel depends on your version of Windows. Windows 10 a. In the search box on the task bar, type control panel, then select Control Panel. b. Select Programs > Programs and Features, then right-click your Microsoft Office product, and choose Uninstall. Windows 8.1 or 8 c. Right-click the Start button (lower-left corner), and choose Control Panel. d. Select Programs and Features, then right-click your Office product, and choose Uninstall. Windows 7 e. Click Start > Control Panel. f. Click Programs > Programs and Features. © © Edunet Foundation. All rights reserved. 99  g. Right-click the Office application you want to remove, and then click Uninstall. 2. Follow the prompts to complete the uninstall. Note: If Office isn't listed in the Control Panel you could have a Microsoft Store installation type. Select the Microsoft Store tab above and follow those uninstall steps instead. 3. To reinstall Office, select the version you want to reinstall and follow those steps. Option 2 - Completely uninstall Office with the uninstall support tool 1. Select the button below to download the Office uninstall support tool. Download 2. Follow the steps to open the download according to your browser, and when you're prompted in the Application Install window, select Install, and then I agree for the Microsoft Services Agreement. Tip: The tool may take a few minutes to download and install. After completing the installation, the Uninstall Office products window will open. Edge or Chrome o In the lower-lower left corner right-click SetupProd_OffScrub.exe > Open. Edge (older) o At the bottom of the browser window, select Run to launch the SetupProd_OffScrub.exe. Firefox o In the pop-up window, select Save File and then from the upper-right browser window, select the downloads arrow > SetupProd_OffScrub.exe. © © Edunet Foundation. All rights reserved. 100  3. From the Uninstall Office products window, select the version of Office you want to uninstall, and then select Next. 4. Follow the prompts on the remaining screens and when prompted, restart your computer. After you restart your computer, the uninstall tool automatically re-opens to complete the final step of the uninstall process. Follow the remaining prompts. 5. If you want to reinstall Office, select the steps for the version you want and follow those steps. Close the uninstall tool. Install the antivirus program To install an antivirus program on your computer, follow the steps below. 1. If you purchased the antivirus program from a retail store, insert the CD or DVD into the computer's disc drive. The installation process should start automatically, with a window opening to help guide you through the install process. 2. If you downloaded the antivirus program on the Internet, find the downloaded file on your computer. If the downloaded file is a zip file, unzip the file to extract and access the installation files. Look for a file named setup.exe, install.exe, or something similar, then double-click that file. The installation process should start, with a window opening to help guide you through the install process. 3. In the installation process window, follow the steps provided to install the antivirus program. The install process provides recommended options so the antivirus program will function properly, which in most cases can be accepted as is. The one exception is if the install process recommends to install any toolbars for Internet browsers or other helpful programs for your computer. If prompted to install other software with the antivirus program, uncheck all boxes or decline the install of those extra programs. No additional programs should be needed for the antivirus program to install and run successfully on your computer. 4. When the install process is complete, close out of the install window. © © Edunet Foundation. All rights reserved. 101  5. If used, remove the CD or DVD from the computer's disc drive. The antivirus program is now installed and ready to use. While it may not be required, we recommend restarting your computer so that any modified settings in the operating system can take effect correctly. Update the antivirus program after installation Out of the box, antivirus programs are not up-to-date and are missing the latest virus and spyware definitions. Without the latest definitions, the antivirus program will not know about the most recently created viruses and spyware, making your computer vulnerable to an infection. After installing the antivirus program, we highly recommend you update it with the latest virus and spyware definitions. The updates allow the antivirus program to protect your computer from all viruses and spyware. In many cases, the antivirus program automatically checks for and installs the latest updates. If prompted to do so, select Yes to update the antivirus program. If it does not prompt you to update immediately. Enable automatic updates for the antivirus program By default, most antivirus programs enable the automatic update feature. We strongly recommend automatic updates be enabled to keep the antivirus program up-to-date at all times. To check if automatic updates are enabled in your antivirus program, follow the general steps below. 1. Open the antivirus program. 2. Look for a Settings or Advanced Settings button or link in the antivirus program window. If you do not see either option, look for an option like Updates or something similar. 3. In the Settings or Updates window, look for an option like Automatically download and apply updates. It may also refer to virus definitions instead of updates. 4. For the automatic updates option, check the box for that option, if not already checked. 5. Click the Save or Apply button to save the settings change. Uninstall through the Start menu First, try utilizing the built-in uninstall feature of the program by finding the folder for the antivirus program in your Windows Start menu. To do this, click Start, All Programs, and look for the antivirus program in the list of programs. © © Edunet Foundation. All rights reserved. 102 When you find the antivirus program in the list, locate the uninstall option, which should be in the same folder. If this is available, click the uninstall option and follow the prompts to complete the uninstallation of the antivirus. Uninstall through Add or Remove programs The second way is to utilize Add or Remove Programs. Windows Vista, 7, 8, and 10 users. Windows XP users. Windows Vista, 7, 8, and 10 users 1. Open the Add or Remove Programs utility. 2. In the list of installed programs, find the antivirus program and select it by clicking it once with the left mouse button. Once the antivirus program is selected, above the column headers, click the Uninstall option as shown in the picture below to initiate the uninstall process. Note Some antivirus programs may be listed several times in the list of programs. Make sure you've uninstalled all associated parts of the antivirus before rebooting the computer or installing another antivirus. If you're unable to uninstall the antivirus through Add or Remove Programs because of an error, skip to uninstalling from Safe Mode. If the antivirus program is not listed in the Add or Remove Programs, you may have a bad antivirus install or a rogue antivirus. Windows XP users 1. Open the Add or Remove Programs. © © Edunet Foundation. All rights reserved. 103  2. In the list of installed programs, find the antivirus program and select it by clicking it once with the left mouse button. To the right of the program name, click the Change/Remove or Uninstall button to initiate the uninstall process. Note Some antivirus programs may be listed several times in the list of programs. Make sure you've uninstalled all associated parts of the antivirus before rebooting the computer or installing another antivirus. If you're unable to uninstall the antivirus through Add or Remove Programs because of an error, skip to uninstalling from Safe Mode. If the antivirus program is not listed in the Add or Remove Programs, you may have a bad antivirus install or a rogue antivirus. Uninstalling from Safe Mode In some cases, the uninstall process may not be able to proceed because the antivirus program is currently loaded and running in Windows. If the program cannot be disabled, uninstall the antivirus in Windows Safe Mode. In Safe Mode, the antivirus program is not loaded and running, making it possible to uninstall using either method mentioned earlier. How to open Safe Mode. References https://support.microsoft.com/en-us/office/download-and-install-or-reinstall-microsoft- 365-or-office-2021-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658 https://www.computerhope.com/issues/ch001922.htm https://www.computerhope.com/issues/ch001402.htm © © Edunet Foundation. All rights reserved. 104 Activity 4 Aim: Create magazine using columns page borders, header footers (2 Hrs) Learning outcome: Able to create document spread sheet and make presentation using open office Duration: 2 hour List of Hardware/Software requirements: 1. Computer Desktop/Laptop 2. Windows Operating System 3. Open Office Code/Program/Procedure (with comments): we will insert a header in the Default pages using manual formatting. Select from the main menu Insert > Header > [Page Style]. The submenu contains as many entries as page styles used in your document. In addition the submenu includes the entry All, which activates headers on all the pages of the document. Similarly, to insert a footer, choose Insert > Footer. Depending on which option you choose, an area will appear at the top or bottom of the page. In this area you can enter text and graphics that will appear on every page. Items such as document titles, chapter titles, and page numbers, which often go into headers and footers, are best added as fields. That way, if something changes, the headers and footers are all updated automatically. Output/Results snippet: © © Edunet Foundation. All rights reserved. 119 References: https://www.linuxtopia.org/online_books/office_guides/openoffice_3_writer_user_guide/ openoffice_writer_Creating_headers_and_footers.html © © Edunet Foundation. All rights reserved. 120 Activity 6 Aim: Create marksheet using spreadsheet with data validation. Learning outcome: Able to create document, spread sheets and make presentations using open office. Duration: 2 hours List of Hardware/Software requirements: 1. Computer Desktop/Laptop 2. Windows Operating system 3. Open Office Code/Program/Procedure (with comments): 1. First open OpenOffice Spreadsheet from start menu in all programs. 2. Click on new from file menu to create a new spreadsheet. 3. Fill the data/information in various rows and columns by selecting the rows and columns one by one. 4. If we need to find sum, average then enter various entries in columns and rows. 5. To find sum enter syntax [=sum] and select the cells of which we need to find sum. 6. Similarly for average we use syntax[=average] and the starting cell separated by colon and ending cell. This will find the average of cells. 7. After creating the worksheet, we need to save it by clicking on file tab and save option in it. 8. Type the name we want to give to sheet and click on save button. 9. In this way we create a marksheet in spreadsheet. Output/Results snippet: © © Edunet Foundation. All rights reserved. 123 References: https://www.youtube.com/watch?v=UD9CLxT1i78. © © Edunet Foundation. All rights reserved. 124 Activity 8 Aim: Create Pay slip using functions and formulae Learning outcome: Able to create document, spread sheets and make presentations using open office. Duration: 3 hours List of Hardware/Software requirements: 1. Computer Desktop/Laptop 2. Windows Operating system 3. Open Office Code/Program/Procedure (with comments): Step 1: Open a new blank spreadsheet. Go to Search Box. Type “OpenOffice” and click on “Spreadsheet”. Step 2: Save the file on the location you want your payroll to be saved so that it does not get lost and you will always have it with you. Step 3: In this newly created file where all your employee payroll information would be stored, therefore, create some column with names which can hold the values for the certain parameters/variables. Enter the column names in the following hierarchy. Employee Name (column A): Contains your employee name. Pay/Hour (column B): Contains per hour pay rate to the employee without any currency symbol. Total Hours Worked (column C): Contains total hours worked by an employee in a day. Overtime/Hour (column D): Overtime rate per hour without any currency symbol. Total Overtime Hours (Column E): Number of hours employees’ overtime in a day. Gross Pay (column F): Payable amount to the employee without any deductibles. Income Tax (column G): Tax payable on Gross Pay. Other Deductibles (If Any) (column H): Deductibles other than Income Tax. Net Pay (column I): Payment the employee will receive in hand after all the deductions. Step 4: Add the details column-wise like Employee Name in column A, a number of hours worked and hourly paying rate, etc. I will say input the fields with no formula (From column A to column E). See the screenshot below for better understanding. In this example, if you can see the Total Hours Worked and Total Overtime Hours are considered on a monthly basis (because we pay the employee on a monthly basis, right?). © © Edunet Foundation. All rights reserved. 127 Therefore 160 means total hours worked during the month. Same is the case with total hours overtimed. Also, the Pay/Hour and Overtime/Hour are in USD. Step 5: Formulate Gross Pay. Gross Pay is nothing but the sum of the product of Pay/Hour, Total Worked Hours and Overtime/Hour, Total Overtime Hours. (Pay/Hour * Total Hours Worked) + (Overtime/Hour * Total Overtime Hours). In the payroll sheet, it can be formulated under cell F4 as =(B2*C2)+(D2*E2). It’s a simple formula anyway. However, you can see the screenshot below for a better understanding. Step 6: In order to calculate the Income Tax, you need to check how much percentage of tax your employee pays on the total gross pay. Income Tax is always calculated on Gross Pay. In this case, we will consider 15% of Income-tax on all the Gross Pay. The formula for Income Tax, therefore, becomes as – 0.15 * Gross Pay. Step 7: You have to mention other deductibles if any for a particular employee. These deductibles may contain the premium of health/life insurance, professional taxes, EMI amount if any loan is taken from an organization, etc. add these amount values under column H. If there is no other deductible for a particular employee, you can set the value under column H for that employee to zero. Step 8: Now, finally we come towards Net Pay. Net Pay is nothing but the amount that gets credited into your employee’s bank account after all the deductions from Gross Pay. Therefore, in this case, we will deduct (subtract) Income Tax (column G) and Other Deductibles (Column H) which can be formulated under cell I2 as =F2-(G2+H2). Here, Income Tax and Other Deductibles are summed up and then subtracted from Gross Pay. See the screenshot below for better understanding. Step 9: Add all the employee names working for you in this payroll one by one and set their total worked hours, overtimed hours, deductibles and charges accordingly. For Gross Pay, Income Tax and Net Pay, just drag the 4th cell of respective columns to have the details formulated. Also, add some formatting to the cells and add total at the end of the sheet. Output/Results snippet: © © Edunet Foundation. All rights reserved. 128 References: https://www.educba.com/payroll-in-excel/ © © Edunet Foundation. All rights reserved. 129 Activity 3 Aim: Install and Configure FTP Services. Learning outcome: Able to configure different protocol services Duration: 3 hour List of Hardware/Software requirements: 1. Windows Server 2012 R2 2. VMWare Workstation 3. Computer with 8GB RAM/500 GB HD Code/Program/Procedure (with comments): 1. Open the Windows Server Control Panel and find the Add roles and features. 2. As the installation type, specify Role-based or feature-based installation. 3. Select your server from the server pool. 4. In the next window, check the IIS web server 5. In the window that opens, click Add features. 6. In the next window Features do not select anything. Next in the Role services window, check the FTP server. 7. Install all selected features on the server using the Install button. Creating an FTP site on a Windows server 8. Open IIS Manager. 9. Right-click on Sites and select Add FTP Site from the menu. 10. Enter the site name and path to the directory. 11. Next, select your IP address in the drop-down list. For encryption, check No SSL. 12. In the next window, select Basic for authentication. Authorization - Specified roles or groups, enter the name of the group of FTP users (example of creation below). Check the desired read and write permissions and click the Finish button.  13. Your website will appear in the tree structure of the Windows web server Create user group 14. Creating a Windows group is necessary to determine the users who will have access to the ftp server. Open Computer Management. In the menu on the right, select Groups. Use the right mouse button to create a new group (New Group).  15. In the window that opens, enter the name of the group, a description if necessary. To add a user, click Add. 16. Enter a name in the input field, to check it, click Check Names. If Windows users exist, click Ok. User isolation 17. In order for each user to get to his own directory and not have access to other files after connecting to the server, it is necessary to set up isolation. To do this, open your ftp site settings and select FTP User Isolation. 18. Select the User name directory and click Apply. 19. Then, using the right mouse button, open the menu of your ftp site and select Add Virtual Directory. 20. In the Alias field, enter a nickname or name, in the path field enter the path to the user directory, to do this, create a subdirectory in the ftp site directory on your Windows server. Click Ok. 21. To configure permissions in IIS Manager, expand the hierarchical structure of your ftp server. Using the right mouse button, open the Windows virtual directory menu and select Edit Permission. 22. Click the Security tab and click the Advanced button. 23. In the window that opens, click the Disable inheritance button, select the first option in the new window, and then click Apply - Ok. 24. Return to the Security tab and click the Edit button. 25. Select the Users group in which all users are located and click the Remove button. This is necessary so that only the owner of the directory has access to it. 26. Now add a Windows user who will have full access to the directory. Click the Add button. 27. Enter the username of the virtual directory in the input field, to check it, click Check Names. If users exist, click Ok. 28. Next you need to add rights for complete control of the directory. Select the created user and check all fields Allow (Permissions). 29. Next, click Apply - Ok. Firewall Setup 30. For an external connection to the ftp server, you must configure the firewall. To do this, open Windows Firewall with Advanced Security. In the vertical menu on the left, select Inbound rules, then in the vertical menu on the right New Rule. 31. In the window that opens, check the Predefined type and select FTP Server from the drop-down list. Click Next. 32. Select and Mark all the lines and click Next. 33. In the next step, select Allow the connection and click Finish. For these rules to take effect - restart the server. Connect to an FTP server 34. You can connect to an FTP server in several ways, for example, through the standard Windows utility - Explorer, or through the FileZilla program. Consider connecting through Explorer. In the address bar, enter: ftp://ipaddress For example, ftp://83.166.245.89 35. The login and password input window will open, specify the connection data from the server control panel. Output: As a result, you will see the contents of the FTP server folder: References: https://neoserver.site/help/setting-ftp-server-windows-server-2016 Activity 4 Aim: Install and Configure HTTP Services Learning outcome: Able to configure different protocol services Duration: 2 hour List of Hardware/Software requirements: 1. Windows Server 2012 R2 2. VMWare Workstation 3. Computer with 8GB RAM/500 GB HD Code/Program/Procedure (with comments): 1. Download the Apache Software form https://www.apachelounge.com/download/ and select the Operating system type 32-bit or 64-bit. 2. Go to Downloads and extract the ZIP file to the root of the C: drive 3. Open ” C:/Apache24/conf “and select httpd.conf and open with notepad. If there is no any other web services running on your machine then keep “Listen 80” otherwise change it to “Listen 81”. 4. Test your installation open command prompt and type C:\Apache24\bin press  enter and Next-> type httpd –t in command prompt. 5. To Start Apache in the command prompt type: httpd.exe 6. We can test your installation by opening up your Browser and typing in the address: http://localhost 7. To stop the apache service press Ctrl+C in Command Propmpt. 8. To install as a service. Open command prompt as Administrator and type: >httpd.exe -k install  9. we can start/stop the service with the command: >services.msc Output: Reference: https://www.sitepoint.com/how-to-install-apache-on-windows/ Activity 3 Aim: Connect remote Desktop using RemoteAssistance. Learning outcome: Able to configure and perform remote accessing & routing. Duration: 5 hour List of Hardware/Software requirements: 1. Any kind of Laptop / Desktop with internet connection 2. Windows 8 OS Code/Program/Procedure (with comments): 1 - On the Computer That the user Wants To CONNECT TO Open the Windows 8 System folder. In Windows 8, swipe in from the right edge of the screen. Tap Search. Image: Desktop 2. Type remote in the Search Text Box field. 3. Click Settings, located on the right. 4. Click Allow Remote Access to your computer, located on the left Image: Settings 5. Enter the system Admin Password or confirm your Choice, if requested. 6. Select the checkbox - Allow users to connect remotely to this computer, located in the lower section. 7. Uncheck the checkbox option, allow connection only from computers running Remote Desktop with Network Level Authentication (recommended). 8. Click the Select Users button of the window. (FWindow Remote Assistance) 9. Add your PAWS ID and any other users that need access to remotely connect to your computer using Remote Desktop. 10. Click the OK button to save your changes that have added all necessary Remote Desktop Users. Output/Results snippet: The connection will now be established. According to the Quick Assist dialog, it may take a few minutes before the devices connect, so you may have to be patient. References: http://www.ctimls.com/Support/KB/How%20To/Use_Windows_Remote_Ass istance.htm Activity 4 Aim: Connect Remote Desktop using Telnet Learning outcome: Able to configure and perform remote accessing & routing. Duration: 3 hour List of Hardware/Software requirements: 1. Any kind of Laptop / Desktop with internet connection 2. Windows 8 OS Code/Program/Procedure (with comments): Step 1: Press Windows- X and select the search from the context menu and enter the control panel in the search field. Step 2: Click the Programs and features and then click Turn Windows Features On or Off. Step 3: Select the Telnet Client checkbox and then click OK to install telnet to Windows 8.  It may take some time to install telnet. Step 4: Enter cmd in the search field and click Command Prompt from the context menu. Step 5: Type the command- telnet [IP Address or host name] [port-number] Determine the IP Address or hostname of the server and the TCP port number required to establish a connection and press enter. Step 6: Type the username and password, if applicable, to log in to the computer. Output/Results snippet: The connection will now be established. The telnet screen appears as follows: References: https://yourbusiness.azcentral.com/reset-zebra-printer-dhcp-11665.html https://support.na.sage.com/selfservice/viewContent.do?externalId=11120&sli ceId=1 Activity 5 Aim: Connect Remote Desktop using HyperTerminal Learning outcome: Able to configure and perform remote accessing & routing. Duration: 2 hour List of Hardware/Software requirements: 1. Any kind of Laptop / Desktop with internet connection 2. Windows XP OS Code/Program/Procedure (with comments): Step 1: Open HyperTerminal by clicking the Windows Start button, clicking "All Programs," clicking "Accessories," clicking "Communications" and clicking "HyperTerminal." Step 2: Create a connection by clicking the "File" menu, selecting "New Connection" and entering your connection information. Open an existing connection by clicking the File menu and selecting "Open." Step 3: Connect to the remote computer by clicking the "Call" icon. Alternatively, wait for the remote computer to call you by clicking the Call menu and selecting the "Wait for a Call" option. Step 4: Send a file to the remote computer by clicking the Transfer menu and selecting the "Send File..." option. This opens the Send File window. Click the "Browse..." button to select a file, choose a transfer protocol and click the "Send" button. Step 5: Click the "Transfer" menu and select the "Receive File..." option to receive a file from the remote computer. Click the "Browse..." button and select a location to which you want to save the file. Select the same receiving protocol that the remote computer is using to send the file and click the "Receive" button. References: https://smallbusiness.chron.com/transferring-files-trillian-33270.html  http://tutorial.wmlcloud.com/windows_xp/Using-HyperTerminal-for-Modem-to- Modem-Connections---Connecting-to-a-Remote-System---Performing-File- Transfers.aspx Activity 6 Aim: Connect Remote Desktop using Teamviewer Learning outcome: Able to configure and perform remote accessing & routing. Duration: 5 hour List of Hardware/Software requirements: 1. Any kind of Laptop/ Desktop with internet connection 2. Windows 8 OS 3. Teamviewer Software Code/Program/Procedure (with comments): Step 1 First, install the team viewer software. Just open this team viewer page. Select Download Now button. It will automatically download the software for the particular user OS. Step 2 After downloaded, install it and click on the run which appears as a pop-up window to start the setup program. Step 3 The setup window will open and select the necessary option and click the Accept- finish button. Image: Accept to Finish Setup Step 4 Finally installing is done and Wait for the setup to finish downloading the files on your C: drive. Then, TeamViewer will automatically generate a random ID and password to be used to connect to other computers.  Image:Connect to other Computer Step 5 It will take some time to connect and the screen blurs. After the while, the user can be able to see your panner screen, and the user can make changes to it as well.  Step 6 Share a file remotely by using a team viewer. Just tick on “file transfer” instead of “remote control” and then connect to the partner by using his/her ID and Password. Just drag the files which are to be referred. Step 7 And can have a conversation with the partner by using the simple chat box at the bottom of the right side. Once connected to the partner, the user can use chat effectively. Step 8 And even allowed to adjust the visuals of the screen by heading over to the “view” which is at the top of the screen Step 9 And the user may feel better to add some recorded videos of that team viewer session and it provides it too. Output/Results snippet: References: https://www.techrepublic.com/article/how-to-remotely-access-any-pc-using- teamviewer/ https://www.wikihow.com/Use-Remote-Desktop-With-TeamViewer /