The following tasks will be included in the tutorial material for each week. There will be two tasks in five of the first seven weeks. Students are encouraged to keep up with the tasks and not to leave them till the very last minute.The tutorial material is intended to support the students by leading them up to the logbook task solution. Assessment Criteria There are ten marks for each task. The emphasis in the marking is going to be on accuracy of the code and ensuring code which is properly indented, well commented and has meaningful identifiers. Task 1 In a new worksheet place the number 1 in cell A1. Create a formula that will copied to all cells up to L1 that will place the numbers 1 to 12 across the top row. Create a similar function that will be copied into A2 to A12 that will place numbers 1 to 12 down the first column. Create a single formula that can be placed in all cells between B2 and L12 that will evaluate the product of the value at the top of the column and the value at the left edge of the row. i.e. you are making a multiplication table with just three formulas and the number 1. In your logbook I wish to see a) a printout of the multiplication table b) a printout of the table but showing formulas (select all cells then pres ctrl + ` in MS Excel. in OpenOffice Calc Choose Tools - Options - OpenOffice.org Calc - View. Check the Formulas box in the Display area. (Replace Tools – Options with OpenOffice.org – Properties if using a Mac.)) c) no more than 100 words on how the formulas work. Task 2 A module consists of three assessments weighted at 15, 35 and 50 percent. (The final mark will be 15% of the mark for the first assignment, 35% of the mark for the second assignment and 50% of the mark for the third assignment.) All assignment marks are recorded as percentages. Create a spreadsheet that will record the students SID and the percentage for each of the assignments and calculate a final weighted average. Row 1 should have column headings. Row 2 will only have the weightings for each assignment. Results will be added from row 3. SID Ass1 Ass2 Ass3 Average 15% 35% 50% 110123 45 46 57 51.35 Create a worksheet based on the requirements above and enter results for five students to check your formula for the total works. This should be a single formula that can be copied for all the results. In your logbook I wish to see a) a printout of your test worksheet b) a print out showing formulas c) no more than 100 words demonstrating that your formula works Task 3 Cells in an Excel spreadsheet contain email addresses in the general form [email protected]. Write a function to place in a cell that will extract the surname from the email address. Note that the above is a general form of the email address. Your function must work for all of the following In your logbook I wish to see a) a printout showing the function works b) a printout of the function c) no more than 100 words on how the formulas works. Task 4 Write a JavaScript function that will prompt the user for a base and a height then: Display the area of an isosceles triangle. (½ height * base) Display the volume of a square pyramid. (1/3 area of base * height) In your logbook I wish to see a) a printout of well presented and commented code b) a print out of a sample run c) Explain in no more than 100 words what did you do to demonstrate it gives the correct results Task 5 Create a web page with two text boxes and a button. The user enters an email address in the format below into the first text box. The user then clicks the button and the surname will appear in the second text box. The email addresses is in the general form [email protected]. Note that the above is a general form of the email address. Your function must work for all of the following In your logbook I wish to see a) A printout of the results of a test run of your program b) A printout of code. c) No more than 100 words explain how .substring and .indexOf are used to find the surname. Task 6 The Free Space path Loss (FSL) between isotropic antennas can be represented by the formula FSL = (4π/c)2f2d2 Where c is the speed of sound in ms-1, f is the frequency of the signal in MHz and d is the distance between antennas in km. Write a JavaScript code that will prompt the user for f and d and return the FSL. In your logbook I wish to see a) well commented and indented code b) a printout of a sample run c) An explanation of how you verified your results in less than 100 words. Task 7 Write a JavaScript code that will create a random integer number in the range of 1 – 9 inclusive (1 and 9 should be possible). Each number should have equal opportunity of occurring. It will also be necessary to have a 9 element array with each element initially set to 0. The function that returns the random number between 1 and 9 will be called 100 times and each time one of the array elements will be incremented depending on the random number. If the random number is two then element 2 will be incremented. This technique will enable your code to keep track of how many times each of the 9 numbers is returned by the random number routine. When completed display how many times each of the numbers was returned by the routine. In your logbook I wish to see a) Well commented and indented code b) A printout of a sample run c) A comparison of three Math methods that convert a real to an integer. d) An indication of how confident you are that each of the numbers 1 and 9 have equal chance of occurring as 4 or 5. Task 8 Draw a flow chart and write a javaScript function which will use a for loop to prompt for the delay times for three network performance tests and display the average. Code so that this can be done for four sets of tests (Note: two loops should be used) In your logbook I wish to see: a) Flowchart b) Program listing (showing appropriate identifiers, comments and indentation) c) Explanation how you tested the program. Task 9 On the VLE there is a CDLibrary.xml file. This is an extract from my CD Library. Create a JavaScript program to display the performer, title and genre of each CD in the library. Use a table to format the data. In your logbook I wish to see: a. Program listing (showing appropriate identifiers, comments and indentation) b. Screen shot of the displayed CDs Task 10 Create a JavaScript code that will display the title of a cd from the CDLibrary.xml file then all the tracks on the cd. The output could look like the following. In your logbook I wish to see: a. Program listing b. Screen shot for a run Case Study Scenario You have been approached by a company to create a web-based Heraldry application/system that will assist them to keep track of the Blazon armorial records with different attributes entailed, and allowing them to be searched online. This link will help you understand more about the concept of Heraldry. Ultimately it will be a fully featured, highly flexible solution but as you are relatively new to the company and they are not sure of your coding abilities they are looking for an initial proof of concept prototype at this stage. You are to develop the design documentation (assignment 1) and a simple piece of code to try the idea out (assignment 2). In the coding part, you are going to create a simple web page which will display the Blazons you have in a table showing the attributes that are included in the example uploaded on the VLE. Assignment 1: Design Documentation [40%] (To be submitted by 28th November 2014) Tasks to complete based on the case study above Now you are assigned to analyse the procedures given above and produce an analysis and design report for the new web-based computer system. Your report should cover at least the following contents: · The project initiation documents (PID) including a general description of the system to be designed, objectives of the project and feasibility analysis report. · A detailed specification of system requirements collected using one of the requirement gathering techniques introduced in this module. Also, description of five use cases should be provided to show the functional requirements of the system. · Produce a set of DFDs (context, level 1 and level 2) to show the processes and data requirements of the system.