Computer Hardware Note: The following specifications for a laptop computer are to be used to answer Parts (a) and (b): 1 1 11th Generation Intel® Corei7-11390H Processor Windows 10 Pro (64bit) English • Intel® Iris® Xe Graphics with shared graphics memory 15

Subject:Computer SciencePrice:9.86 Bought7

Share With

Computer Hardware Note: The following specifications for a laptop computer are to be used to answer Parts (a) and (b): 1 1 11th Generation Intel® Corei7-11390H Processor Windows 10 Pro (64bit) English • Intel® Iris® Xe Graphics with shared graphics memory 15.6-inch FHD (1920 x 1080) Anti-glare LED Backlight Non-Touch Narrow Border WVA Display 16GB DDR4 3200MHz 512GB M.2 PCIe NVMe Solid State Drive • 2 USB 3.2 Gen 1 Type-A 1 USB 3.2 Gen 2 Type-C™ 1 Headset Jack • 1 HDMI 1.4a 1 power-adapter Intel® Wi-Fi 6 2x2 (Gig+) and Bluetooth 5.1 1 (a) [4 marks] How much primary memory does the computer described above have? Type your answer in here: (b) [6 marks] (b) [6 marks] Cite 3 types of physical ports you can find in the computer specifications described above. Type your answer in here: 2 Publishing Online What makes wikis different from classic websites? Cite one advantage and one disadvantage of successful wikis such as Wikipedia. Type your answer in here: Maximum marks: 5 3 Modem The name "modem" is a contraction of "modulation" and "demodulation". What is the role of the modem in the Internet network? Briefly explain the modulation and demodulation process carried out by the modem. Type your answer in here: Maximum marks: 5 4 Uniform Resource Locators Consider the following Uniform Resource Locator (URL): https://www.auckland.ac.nz/en/study/study-options/postgraduate-study-options.html What are the protocol, the domain, the path to the server and the resource components of this URL? Type your answer in here: Maximum marks: 5 5 Google Search you are living in New Zealand and your friend is living in the USA, are you likely to get the same set of results as your friend if you both do a Google search for the word "restaurant"? Why? Type your answer in here: Maximum marks: 5 6 Binary Arithmetic What is the result of the following binary calculation? 1101012 - 11012 The result must be expressed in binary. Show all your working. Type your answer in here: Maximum marks: 5 3 7 Binary Conversion Convert 26810 to binary. Show all your working. Type your answer in here: Maximum marks: 5 8 8 Turing Machines A universal Turing machine can simulate any computer we may currently have. With this in mind, is it plausible to envision a world where Turing machines are used to the same effect as we use computers? Briefly justify your answer. Type your answer in here: Maximum marks: 5 9 Ada Lovelace Lady Ada Lovelace hypothesized that Charles Babbage's Analytical Engine (which was essentially akin to a type of calculator) could manipulate symbols other than numbers, and consequently perform tasks other than numerical calculations. Briefly state the significance of this claim. Give one example of this phenomenon in the current world. Type your answer in here: Maximum marks: 5 10 Malware Your friend's computer was infected by a type of malware after he downloaded software that he thought was legitimate. What kind of malware did the computer get infected with? What advice would you give to your friend to protect his computer in the future? Type your answer in here: Maximum marks: 5 3 11 Tor When using the Tor Browser, are you still likely to receive targeted advertising? Briefly explain why. Type your answer in here: Maximum marks: 5 12 Health After a long day of work in front of your computer, you start feeling muscle discomfort and numbness. What is the name of the syndrome you are experiencing? Describe some actions you could take from a personal perspective to prevent this from happening. Type your answer in here: Maximum marks: 5 (a) [4 marks) Column C contains the points value for each student's COMPSCI 000 Grade. The points value is obtained from the Grade Points Table in Rows 13 to 24. What is the best formula to use in Cell C5 to display the points value for the COMPSCI 000 grade obtained by the student in Row 5? NOTE: You must use a VLOOKUP function, and your formula must be able to be filled down correctly from C5 to C10. Write your formula in here: (b) [3 marks] Column F contains each student's Summer School Grade Point Average (GPA). This is the average of the student's COMPSCI 000 points and their COMPSCI 999 points. What is the best formula to use in Cell F5 to display the GPA for the student in Row 5? Your formula must be able to be filled down correctly from F5 to F10. Write your formula in here: (c) [4 marks] Column G contains the grade that corresponds to the GPA in Column F. What is the best formula to use in Cell G5 to display the grade that corresponds to the GPA in Cell F5? NOTE: You must use a VLOOKUP function, and your formula must be able to be filled down correctly from G5 to G10. Write your formula in here: (d) [3 marks] Column H indicates whether the GPA for the student is greater than 6. What is the best formula to use in Cell H5 to display "Yes" if Cell G5 is greater than 6 and "No" otherwise? Your formula must be able to be filled down correctly from H5 to H10. Write your formula in here: (e) [4 marks] Cell H12 contains the number of students who obtained a GPA that is greater than 6. What is the best formula to use in Cell H12? Write your formula in here: 14 LaTeX The following LaTeX commands have been included as a reference. You will not need to use all of these commands. Normal commands Environments Math mode commands \usepackage{graphicx} itemize $ \section{} enumerate \sqrt{} \subsection{} verbatim \frac{}{} \title{} flushright \leq lauthor{} center \sum_{}^{} \date{} quote \theta \maketitle displaymath \alpha \item equation \textbf{} quotation Ndots Neft \includegraphics \right) \footnotet \pi A Complete the LaTeX code that will produce the document below. Note: The image is named Figure ShotPut.png and is in the same folder as the LaTeX code. The image should be centred with a width of 7cm. Units (e.g. m) and symbols (e.g. R) must be entered in mathematical mode. Shot put International Olympic Committee September 2021 Write your LaTeX code in here: