1). a). Briefly describe the following terms as applied to a signal highlighting them on a suitable sketch and discuss their significance in communications. Amplitude. Frequency. Period. Phase. b). A sine wave V(t) has an amplitude of 10 V and a frequency of 260 Hz i). Sketch a fully labelled sketch of one cycle of V(t). ii).Give the mathematical expression for V(t). iii). Calculate the value of V(t) for t = 1 s, 0.005 s and 5×10-6 s to three decimal places. iv). Use the Agilent 33500B Function / Arbitrary Waveform Generator to verify the answers to 1). b). i), ii) and iii) include suitable plots in your assignment. v). Give a mathematical expression for the addition of two sine waves with the following parameters Wave 1. Amplitude = 5 V Frequency = 100 Hz Phase = 0 radians. Wave 1. Amplitude = 6 V Frequency = 300 Hz Phase =  radians. COURSEWORK BRIEF: This coursework will assess your abilities with Microsoft Excel, testing a range of skills developed during the course of the lectures and supplementary tutorial activity. This piece of work, being taught simultaneously with Statics for all full time students, will focus on an aspect of this module and using Excel to take in data, process it and produces solutions to the question posed. For any students not taking the Statics module this year, your ability to solve the statics problem is not being assessed and help will be given in this task if difficulties are faced with this aspect of the coursework. The specific question that will be considered is a Structural Analysis problem, as displayed below. The Truss used to support a balcony is subjected to the loading shown. Using the method of joints, determine the force in each member, stating also whether members are in tension or compression. Test Data Set (these values will be varied when marked): P1 = 60kN; P2 = 40kN; X1=4m; X2=4m; Y1=4m Test data results: FAD = 84.9kN (C); FAB = 60.0kN (T); FBD = 40kN (C); FBC = 60kN (T); FDC = 141 kN (T); FDE = 160kN (C) Your task is to produce a spreadsheet capable of collecting values for the five variables and outputting the Forces in each member, as well as whether they are in tension or compression. Before you begin the work, place your student ID in cell A1 of sheet 1; the automated marking system can then assign you the marks I give. In order to assess your abilities in a variety of techniques, several specifications will need to be met. 1. A short introduction should greet the user with appropriate button(s) to respond/clear (i.e. “OK”, “Close”, “Hide”, “Next”) and brief preliminary instructions on how to begin. 2. A region for data input produced that can be easily accessed to enter the five pieces of data. This should allow: a. Entry of data into a clear form every time it is begun b. Correction of one piece of data without need to re-enter all of the others c. Storage of data, automatic calculation of all forces without further intervention from the user and closing/hiding/proceeding from the form when a button/link button is clicked. 3. Forces in all members should be calculated and these inserted into a clearly named sheet of your workbook. 4. A feature should be included within the workbook to analyse how forces would change if P1 and P2 were both changed by the same amount, i.e. both halved or both doubled etc. For this, the results all need to be clearly labelled (i.e. categories, not cell references). These may be shown on the same sheet or generated through the click of a button/link. 5. The results of step four should be used to create an XY scatter plot of “Proportion of force applied” on the x-axis against “Force in member DC / kN” on the y-axis. No gridlines or legend should be present but a trend line with equation should be displayed. This should all be on a new sheet, not present when opening the workbook. 6. Assuming a cross sectional area of member DC to be 0.03m2, calculate the maximum increase in forces before which a failure will result. The compressive strength of steel to be used is 500 x 106 Nm-2 7. Also provided on the worksheet should be facility to erase all stored data (without removing any formulae). 8. All input and calculated values should be exported (hint: mail merge) into Word, to be displayed on an accompanying word document that you will also prepare and submit as part of your coursework. Compressions or tensions in members should be identified beneath the diagram in a simple table. Note: captions for tables should be presented above the table; for figures captions should be presented beneath. 9. No errors should be visible throughout the entire use of the workbook; the workbook should be designed so that nothing vital such as formulae can be overwritten; the user can only input into the cells that you intend. Workbook should have a professional feel. Naming your files: Submit your work as a .zip or .rar file with your, student number, the module code and Excel as the folder name (i.e. 00001234EGR1013MEXCEL.rar). Name the spreadsheet part of the submission as “Structural Analysis Calculator.xlsb” (Note: take care to save the file as a binary workbook, otherwise your work will not be able to be seen or marked. .xlsb also enables macro enabled workbooks to be used in a mail merge in conjunction with MS Word). The filename of the Word report does not matter, as long as it is present within the same .rar or .zip file.