{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Multiple Choice Questions","ResultsWAM"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Multiple Choice Questions","index":0,"n_rows":162,"n_cols":3,"rows_kept":162,"cut":false,"hidden":false,"merged":[[131,2,135,2],[137,2,141,2],[143,2,147,2],[149,2,153,2],[155,2,159,2],[125,2,129,2],[59,2,63,2],[65,2,69,2],[71,2,75,2],[77,2,81,2],[83,2,87,2],[89,2,93,2],[95,2,99,2],[101,2,105,2],[107,2,111,2],[113,2,117,2],[119,2,123,2],[0,0,0,2],[4,2,8,2],[10,2,14,2],[16,2,20,2],[22,2,26,2],[28,2,32,2],[34,2,38,2],[40,2,44,2],[46,2,50,2],[52,2,56,2]]}
["COMP1000 Sample Exam 2013s1 - Section 1 - Multiple-Choice Questions"]
[]
[null,"Each question has a best answer. Type your multiple choice answers to Q1 - Q30 in the boxes in column C. When you finish: (a) switch to the other worksheets and do the practical Excel questions. Detailed instructions for the practical Excel questions are on the printed question paper. You also need to complete. (b) Complete the Access question (also on the printed question paper). (c) Complete the HTML question (also on the printed question paper).\nMultiple Choice Q 1-5: HTML, CSS, and Javascript\nMultiple Choice Q 6-10: Excel\nMultiple Choice Q 11-30: Access","Answer"]
[]
["Q0","Example. If I forget to save and submit my worksheet, HTML file and Access database in this exam:","A"]
["(A)","My test answers will be lost and unable to be retrieved"]
["(B)","The lecturer will be able to retrieve the worksheet after the exam, using magic"]
["(C)","I will be fined more than $205 by the NSW police"]
["(D)","The lecturer will automatically give me full marks"]
[null,"During the test, you have no Z-drive access. You must save & submit your answers! You can save & submit them as many times as you like, so Save and Submit frequently."]
["Q1","Which of the following is NOT true about a <textarea> element in standard HTML?"]
["(A)","It can be used both for input of data and for displaying results."]
["(B)","It must be enclosed in a <form> element in order to work."]
["(C)","It must have a \"method=...\" parameter in order to work."]
["(D)","It is only used for sending data back to a server for processing."]
[]
["Q2","The value of an ONCLICK element in an HTML form button"]
["(A)","is the URL of the page that the button will take the user to."]
["(B)","specifes in HTML what will happen if the button is clicked."]
["(C)","is the name of another HTML element within the <form>."]
["(D)","consists of Javascript code to specify the required action."]
[]
["Q3","The <hr> HTML element:"]
["(A)","causes a new line to be started when the web page is displayed by a browser."]
["(B)","may be ignored if it is not preceded by the character code &nbsp;"]
["(C)","causes a horizontal line to appear when the page is displayed by a browser."]
["(D)","causes a heavy robust font style to be used inside the element."]
[]
["Q4","A <span> HTML element:"]
["(A)","inserts a CSS in-line style specification into an HTML document"]
["(B)","cause a row in an HTML table to span 2 or more of the rows below it"]
["(C)","causes the text inside the element to go right across the web page"]
["(D)","causes an HTML error, since this element is now illegal in HTML"]
[]
["Q5","If you use the same attribute  \"name=r1\"  for several different HTML radio buttons:"]
["(A)","the browser will ignore all the buttons"]
["(B)","the browser will treat the buttons as a cluster of alternatives"]
["(C)","the browser will only display the first button"]
["(D)","the browser will give a \"403 Button Not Found\" error message"]
[]
["Q6","The strength of an Excel PivotTable lies in its"]
["(A)","ease of use."]
["(B)","one-point access."]
["(C)","complexity."]
["(D)","ability to easily and quickly rearrange data."]
[]
["Q7","Which Excel What-If Analysis tool would be best at comparing the combined effects of various interest rates and down payments?"]
["(A)","Scenario Manager"]
["(B)","Goal Seek"]
["(C)","One-variable data table"]
["(D)","Two-variable data table"]
[]
["Q8","Which of the following is a valid worksheet reference to a sheet named Year 3?"]
["(A)","F8!'Year 3'"]
["(B)","Year 3!F8"]
["(C)","F8:'Year 3'"]
["(D)","'Year 3'!F8"]
[]
[]
["Q09","The ________ view in Access looks similar to an Excel Spreadsheet."]
["(A)","report"]
["(B)","spreadsheet"]
["(C)","datasheet"]
["(D)","Excel"]
[]
["Q10","You can create or modify a table's field names and data types in ________ view"]
["(A)","report"]
["(B)","form"]
["(C)","datasheet"]
["(D)","design"]
[]
["Q11","Which of the following statements is true about a primary key?"]
["(A)","The primary key value may appear multiple times, in related tables."]
["(B)","It must consist of a single field of the table."]
["(C)","It must be produced by an autonumber field, to ensure uniqueness."]
["(D)","It is unnecessary, if a secondary key occurs in the table. "]
[]
["Q12"," ________ is a special character that is used to represent one or more characters in the criterion of a query."]
["(A)","The concatenation operator '&'"]
["(B)","A wildcard"]
["(C)","A string"]
["(D)","A delimiter"]
[]
["Q13","When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT if"]
["(A)","you require multiple tables to manage data."]
["(B)","you are managing a large quantity of data."]
["(C)","you need to create complex charts or graphs."]
["(D)","multiple users need to work with data simultaneously.."]
[]
["Q14","All of the following are valid statements in reference to the IIf function EXCEPT:"]
["(A)","IIf functions can only be used when a condition will evaluate to either true or false"]
["(B)","IIf functions can be nested to enable testing of more than one condition in evaluating an expression"]
["(C)","IIf functions can contain other functions as arguments"]
["(D)","IIf functions work only with numeric values and not with text"]
[]
["Q15","The ________ displays form fields in a vertical column, and displays one record at a time."]
["(A)","stacked layout"]
["(B)","form view"]
["(C)","tabular layout"]
["(D)","SQL view"]
[]
["Q16","Each object you place on a form is called a(n) ________."]
["(A)","index"]
["(B)","label"]
["(C)","text box"]
["(D)","control"]
[]
["Q17","In a hospital database that has a table for medical specialists and a table for patients, the relationship between the two tables would be:"]
["(A)","one-to-many"]
["(B)","many-to-one"]
["(C)","many-to-many"]
["(D)","one-to-one"]
[]
["Q18","Which of the following statements accurately describes a split form?"]
["(A)","Split forms combine two different views of two different record sources."]
["(B)","A Split form contains a subform."]
["(C)","Split forms combine two different views of the same record source."]
["(D)","You cannot edit records in a Split form, as this would introduce anomalies."]
[]
["Q19","As a precaution, before running an action query in Access, you should:"]
["(A)","compact and repair the database."]
["(B)","save changes to the database, and then convert the query to a Select query."]
["(C)","back up the database."]
["(D)","convert the query to a Select query, and then back up the database."]
[]
["Q20","Which statement is true about action queries in Access?"]
["(A)","An append query is usually run after an update query"]
["(B)","A delete query is usually run before an append query"]
["(C)","A delete query is usually run after an append query"]
["(D)","Make table queries are usually constructed from an update query"]
[]
["Q21","When a Make Table query is run, field properties:"]
["(A)","need to be set by the user."]
["(B)","are inherited from the selected fields."]
["(C)","use the Access defaults."]
["(D)","are left blank."]
[]
["Q22","A Crosstabs query:"]
["(A)","is an Action query used to move records across from one table to another."]
["(B)","is a precaution taken to prevent data loss, before a Make Table query."]
["(C)","produces a summary of data from an existing table."]
["(D)","lists records with field values found in one table but not in another."]
[]
["Q23","A foreign key in a table:"]
["(A)","may be found in multiple records in the table."]
["(B)","means that the data has been accidentally or maliciously compromised."]
["(C)","may only be found in one record in the table."]
["(D)","consists of at least two table fields, which together act as a key."]
[]
["Q24","All of the following are benefits of normalization EXCEPT:"]
["(A)","minimizing data redundancy."]
["(B)","ease of data maintenance."]
["(C)","improving management of referential integrity."]
["(D)","fewer tables."]
[]
["Q25","If a table in a database satisfies second normal form then:"]
["(A)","no field is dependent on just one part of a concatenated key."]
["(B)","there are no dependencies on non-key attributes."]
["(C)","tuples do not contain repeating groups of similar data."]
["(D)","it does not have a concatenated key."]
[]
[null,"When you have finished these multiple choice questions, read the printed instructions, and do the practical Excel, HTML, and Access questions. The worksheets for the Excel are in this workbook. You need to download the HTML template file, and the Access database, separately. "]

{"sheet":"ResultsWAM","index":1,"n_rows":130,"n_cols":4,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
["Program","WAM","Course A","Course B"]
[3726,59.832999999999998,68,73]
[3982,72.534000000000006,92,65]
[3703,71.417000000000002,75,62]
[3978,75.332999999999998,83,71]
[3711,63.417000000000002,55,65]
[3978,65.332999999999998,68,52]
[3648,63.2,66,70]
[3978,84.832999999999998,96,97]
[3648,77.909000000000006,84,93]
[3978,89.082999999999998,96,96]
[3978,72.917000000000002,82,87]
[3978,54.4,21,50]
[3529,82.667000000000002,97,89]
[3728,66.614999999999995,68,51]
[3982,63.3,57,55]
[3982,61.845999999999997,63,55]
[3725,67.75,83,71]
[3648,82.174000000000007,96,92]
[3648,52.548000000000002,76,65]
[3711,84.667000000000002,78,83]
[3978,53.110999999999997,50,50]
[3978,85.375,83,91]
[3978,65.647000000000006,65,51]
[3982,66.75,67,50]
[3711,81.230999999999995,82,79]
[3970,45.609000000000002,56,50]
[3982,66.832999999999998,42,50]
[3653,78.52,83,76]
[3978,81.972999999999999,88,97]
[3648,66.19,84,67]
[3648,70.87,97,83]
[3978,72,82,68]
[3648,62.134999999999998,54,59]
[3652,63.113999999999997,65,23]
[3978,75.555999999999997,89,80]
[3978,78.667000000000002,78,90]
[3725,83.332999999999998,87,92]
[3978,34.688000000000002,60,50]
[3978,88.332999999999998,91,98]
[3645,78.832999999999998,92,83]
[3648,66,62,65]
[3968,65.167000000000002,72,71]
[3982,63.8,65,71]
[3653,72.043000000000006,52,85]
[3648,64.304000000000002,62,59]
[3978,78,84,77]
[3978,70.832999999999998,77,82]
[3648,58.929000000000002,64,50]
[3042,70.406999999999996,71,93]
[3529,75.417000000000002,78,74]
[3982,60.636000000000003,40,68]
[3978,70.167000000000002,75,70]
[3652,47.08,42,50]
[3982,69.917000000000002,72,67]
[3523,83.2,77,89]
[3728,65.45,66,54]
[3658,71.400000000000006,83,71]
[3715,68.667000000000002,75,55]
[3648,70.272999999999996,76,73]
[3982,65.076999999999998,58,74]
[3978,80,59,93]
[3648,64.319999999999993,71,50]
[3648,68.477999999999994,62,78]
[3978,72.417000000000002,74,65]
[3749,63.933,71,52]
[3978,37.845999999999997,48,50]
[3725,64.417000000000002,70,80]
[3982,54.075000000000003,56,55]
[3978,55,58,53]
[3651,81.760000000000005,86,89]
[3451,66.527000000000001,68,53]
[3645,47.15,13,51]
[3725,53.6,42,46]
[3728,68.182000000000002,60,57]
[3715,76.25,72,79]
[3648,59.783000000000001,70,51]
[3978,81.082999999999998,93,95]
[3978,52.332999999999998,69,59]
[3978,67.917000000000002,68,59]
[3978,67.286000000000001,65,54]
[3725,89.317999999999998,81,82]
[3653,60.545000000000002,76,65]
[3653,50.316000000000003,60,70]
[3978,61.545000000000002,63,50]
[3978,78.707999999999998,80,90]
[3648,63.087000000000003,56,71]
[3755,45.167000000000002,64,55]
[3982,74.417000000000002,77,69]
[3983,82.667000000000002,91,70]
[3757,58.35,51,50]
[3970,39.75,64,50]
[3978,59.570999999999998,46,55]
[3725,76.643000000000001,78,70]
[3725,80.75,87,73]
[3653,69.36,55,65]
[3982,52.555999999999997,58,52]
[3982,63.817999999999998,55,40]
[3726,59.8,62,58]
[3648,66.28,74,69]
[3640,86.917000000000002,93,88]
[3726,80.5,95,86]
[3711,85.667000000000002,87,85]
[3978,46.332999999999998,13,67]
[3648,66.92,65,70]
[3525,78.082999999999998,63,69]
[3978,70.667000000000002,60,59]
[3648,73.695999999999998,74,54]
[3978,66.182000000000002,67,58]
[3647,62.5,50,50]
[3648,73.92,73,70]
[3645,61.619,58,70]
[3726,52.363999999999997,64,57]
[3715,81.582999999999998,69,57]
[3978,61.95,78,81]
[3978,83,85,96]
[3653,76.48,70,62]
[3653,68.56,40,52]
[3978,59.667000000000002,65,50]
[3648,58.704000000000001,77,55]
[3645,69.832999999999998,82,65]
[3982,59.4,58,50]
[3978,40.429000000000002,71,61]
[3655,75.353999999999999,67,54]
[3983,44.082999999999998,20,59]
[3978,70.058999999999997,59,54]
[3711,50.25,36,59]
[3978,86.832999999999998,94,93]
[3968,49.475999999999999,50,51]
[3978,45.276000000000003,58,50]