ICTICT308 ICTSAS410 IT Skills 1

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 ...

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 ...