Unformatted text preview: CS1032 – MidTerm Review A 1 Player 2 Patrick Maroon 3 Justin Taylor 4 Jadran Beljo 5 Adam Perry B C D E A 1 Player 2 Patrick Maroon 3 Justin Taylor 4 Jadran Beljo 5 Adam Perry 6 7 Highest # Points B C D E Games Goals Assists Total Points 10 10 4 10 10 6 4 3 11 3 5 7 21 9 9 10 Games Goals Assists Total Points 10 10 4 10 10 10 6 4 3 11 3 5 7 21 9 9 10 Which of the following formulas would be used in E2 to calculate the player’s total points and can be copied to cells E3 to E5. (Total points calculated by adding the player’s Goals & Assists.) A) =C2+D2 B) =C$2+D$2 C)=$C$2+$D$2 D)=$C2+$D2 Which of the following formula would appear in B7, to calculate the highest number of total point scored by a London Knight’s player. A) =max(E2:E5) B) =highest(E2:E5) C)=largest(E2:E5) Using the following spreadsheet, answer the following questions A 1 2 3 4 5 6 7 # Players > 10 total Points Player Patrick Maroon Justin Taylor Jadran Beljo Adam Perry B Games 10 10 4 10 1 C Goals 10 6 4 3 D E Assists Total Points 11 3 5 7 21 9 9 10
(2 marks) Create a formula to be placed in cell B10. This formula will display the message "enough gates" when the number of gates in the terminals exceeds 50. The formula will display the message “not enough gates” otherwise. (2 marks) Create a formula to be placed in cell B11. This formula will display the airport name if the number of gates in the terminals is greater than 40 or the number of runways at the airport is greater than or equal to 10. Display the message "airport not large enough" otherwise. (3 marks) Create a formula to be placed in cell B12. This formula will display the airport name if the number of airlines flying to/from the airport is between 10 and 15 (inclusive) and the number of runways at the airport is between 4 and 8 (inclusive). Display the message "not a mid size airport" otherwise. (4 marks) Create a formula to be placed in cell B13. This formula will display the name of the airport if the total annual number of passengers using the airport is less than 32,000,000. The formula will also display the name of the airport if the number of airlines flying to/from the airport is 11 and the number of runways at the airport is 6. Display the message "wrong airport" otherwise. Which of the following formula would appear in B7, that would calculate the number of London Knight’s players who scored over 10 total points. A. =countif(E2:E5,”>10”) B. =count(E2:E5) C. =countif(E2:E5,>10) The following Questions use the spreadsheet in the screen capture given below. The spreadsheet contains data regarding the number of passengers that traveled through 10 airports in 2003. (1 mark) Create a formula to be placed in cell D17. This formula will compute the average of the numbers in column D rows 5 through 14. This average will be the average number of passengers traveling through the 10 airports. (2 marks) Create a formula to be placed in cell E5 and then copied into cells E6 through E14. This formula will compute the difference between the maximum number of passengers who passed through any of the airports (cell D16) and the number of passengers that passed through the airport represented in the row containing the formula. For example, the value that will be displayed in cell E5 by the formula is 15,599,656 (79,086,792 – 63,487,136). (4 marks) Create a set of formulas that will compute the number of airports with above average numbers of passengers. The number of such airports will be displayed in cell D19. Explain how your set of formulas would be used to solve this problem. Assume that the average number of passengers traveling through the 10 airports is stored in cell D17. (4 marks) Create a formula to be placed in cell D21. This formula will display the number of passengers that passed through an airport. The airport code for the airport in question is stored in cell C21. This formula must use a single call to the VLOOKUP function that looks up the airport code in cell C21 and displays the number of passengers that passed through that airport. The function call must work when any of the codes for the 10 airports are stored in cell C21. Let the cell display the standard “#N/A” error if the airport code in cell C21 is not found among the airports. (3 marks) Create a formula to be placed in cell D23. This formula will display the largest number of passengers to pass through the airports with codes LHR, HND and AMS. Your answer to this question must only use calls to the IF function. You may NOT use the MAX function as part of your answer. You do not have to use the airport codes LHR, HND and AMS in your answer, just use the cell references for the numbers of passengers for these three airports. 1 CS1032 – MidTerm Review (10 Marks) Create an XML Schema definition for a document type that will store data describing a movie shown at a theatre. The document must be able to store the data describing at least one movie. The data describing a movie consists of:
• • • • the name of the movie the release date of the movie consisting of: • the day, month & year the total attendance to date the cast, the details for each cast member are: • the character played by the actor in the movie • the character’s name in the movie • the actor’s real name (10 marks) Create an XML document to store the data given in the following table. This XML document does NOT use the schema definition you created in the previous question.
Movie Movie Zoom Director Hewitt Cast Allen Cox Chase Invincible Core Wahlberg 31.1M 2 Rental $’s 5.29M Awards 1 A movie must have at least one cast member. Use the symbol “<cs>” as a short form for the “<cs>” <xsd:complexType> xsd:complexType> <xsd:sequence> xsd:sequence> tags and the symbol “</cs>” as a short form for the “</cs>” </xsd:sequence> </xsd:sequence> </xsd:complexType> </xsd:complexType> tags in your answer. Your document must group the Cast information for a movie. Image – knights_shield.jpg Heading Level 1 Create an HTML file that would have created this web page Heading Level 3 Link http://www.londonknights.com 2 ...
View
Full Document
 Winter '10
 Various
 XML Schema, Document Type Definition, airport code, Patrick Maroon

Click to edit the document details