ICTICT308 ICTSAS410 IT Skills 1

Peripheral Devices A peripheral device is defined as a computer device, such as a keyboard or printer, that is not part of the essential computer (i.e., the memory and microprocessor). These auxiliary devices are intended to be connected to the computer and used. Types of Peripheral Devices  Peripheral devices can be external or internal. Examples of external peripherals include mouse, keyboard, printer, monitor, external Zip drive or scanner. Examples of internal peripherals could include a DVD or CD reader/writer, but there are not very many internal devices that would be considered peripherals these days. Today's new devices, such as tablets, smartphones and wearable computing devices are considered peripherals as they can be connected and used on a computer system. The difference, however, is that these devices can run independently of the computer system, unlike a computer mouse, for example. https://www.webopedia.com/TERM/P/peripheral_device.html External Perip

Introduction This unit is designed to give you the skills and knowledge to troubleshoot hardware and software issues that may arise within an organisation. Before we can do that, we need to understand some of the basics of Hardware and Software. Definition of Hardware and Software -  http://www.computerhope.com/issues/ch000039.htm When you look at the description of any piece of computer hardware, you will see lots of information that is categorised under specifications. Software, including games, will also have minimum specifications of what equipment is required to successfully execute the program. Same goes for some peripheral devices. So what does this all mean? What bits and pieces make up a computer? Computers can generally be categorised into the following: Desktop  – not portable, usually set up on a desk or table with the view that it isn’t moved around much. Desktops come as a main box with separate screen and keyboard/mouse, or it can be one of the  “all-in-one”

Creating a Simple Form Today we will look at how to create a simple Excel data form for entering information into a spreadsheet. A data form can be created using the existing column headings in a table or cell range. For this example, I am using the same spreadsheet as last session - PivotTableDataOnly.xlsx N.B. Before you start, it is best to remove the totals at the bottom of the table as we want out new data to be added there. Before we can create a form, we need to add the Forms Button to the Quick Access Toolbar. Click on the little arrow at the end of the quick access toolbar to display the customise menu. Click on More Commands , then All Commands . Locate the Forms Button and add it to the toolbar. Put your cursor somewhere in the table and click on the form button that you just added.  Excel is clever, as previously mentioned, and usually makes the right assumptions for your spreadsheet and will create the form based on the data that it can see.