B1 (a)i Insert a new row at the top of the spreadsheet and enter the heading ‘Ski Information 2021’ (2) B1 (a)ii Merge and centre cells A1 to E1 (2) B1 (a)iii Formatting of the heading to font size – 24, font style – serif, font enhancement – bold. (3) B1 (b) Sam wants you to use spreadsheet tools to analyse the data for the information included. Use functions to :-   B1 (b)i Display the cost of Equipment Hire. Use vlookup in C2 in the Members worksheet and the table in Details worksheet A14:B16 (HINT -absolute referencing will be needed for ranges) (4) B1 (b)ii Display the cost of the Ski Pass in D2 that includes a 20% discount if the cost of the Equipment Hire is more than 300€ (3) B1 (b)iii Calculate total cost of the Equipment Hire and the Ski Pass in E2 (1) B1 (b)iv Replicate all functions and formula for all members. (2) B1 (b)v Display the total cost of Equipment Hire in E18 (1) B1 (b)vi Format the MEMBERS worksheet so that currency values show the currency symbol (€) with no decimal places (2)   SAVE the spreadsheet as Task B

SAVE the query as Obergurgl14. TAKE a screenshot of the query design. PASTE a copy of the query design into TASK A1 PASTE a copy of the results into TASK A1 and save

Task A1 Sam has collected information about guests and their ski holiday accommodation. He has saved the information in the database HOLIDAY. The database has three tables. The HOTEL table includes information about the types of accommodation offered. The GUEST table includes information about guests who have booked holidays. The BOOKING table includes information about bookings.

2 Judy is researching online.   2 a List two types of user-generated reference sites Judy could use. (2) 2 b Judy uses a mobile phone to make a voice call. Draw a diagram to show the mobile phone’s input and output devices required to make the call. Label each device you use in your diagram. (3) 2 c Judy sets file permissions on her online documents. Which one of these is a benefit of doing this?     A    Improves encryption     B     Increases storage     C    Quicker backup     D    Secures data (1)       2 d Describe how a CAPTCHA test reduces the function of malware. (2) 2 e Explain one positive impact of cloud-based services on learning. (2) 2 f Describe how mobile broadband can be used to provide access to cloud-based services. (2) 2 g Give one reason why Judy should use mobile broadband. (1) 2 h Explain one benefit of using wired connectivity. (2)    

3 Eunice installs some software on her laptop.   3 a Write the Utility Software and next to it the corresponding correct Purpose all under number 3a.     Utility Software Purpose     compression protect from viruses       create copies of files     backup Blocks IP addresses       reduces size of files     anti-malware converts file types (3) 3 b Which one of these types of devices can have software installed to it?     A    Memory     B    OMR Reader     C    Processor     D    Storage   (1) 3 c Explain one benefit to Eunice of updating her software regularly.   (2) 3 d Eunice is travelling by train. She connects to the Internet using the train’s Wi-Fi connection. Explain why the Wi-Fi provider blocks video streaming.   (2) 3 e The Internet has provided a wider range of entertainment and leisure opportunities. One example is video and audio streaming. State two other examples.   (2) 3 f Eunice changes her laptop’s GPS settings. Which one of these statements is true?     A    GPS is used by all digital devices     B     GPS does not use an Internet connection     C    GPS uses cloud computing     D    GPS is better if opensource software is used   (1) 3 g Eunice writes a blog. Eunice wants visitors to her blog to see posts that are likely to be relevant to them. Describe how cookies can be used to achieve this. (4)    

This is a final upload question in case you had problems. Contact exam connect for help if necessary.

Sam wants to use a form to add extra hotels to the HOTEL table. A1 a Create a form for the HOTEL table. The form must:   A1 (a)i include a suitable title, blue text on light background 3 A1 (a)ii Contain all the fields 1 SAVE the form as HOTEL_FORM   TAKE a screenshot of your form in design view showing the changes in field widths.   PASTE the screenshot into TASK A1 and save  

TAKE a screenshot of the completed form. PASTE the screenshot into TASK A1 and save

3 Eunice installs some software on her laptop.   3 a Write the Utility Software and next to it the corresponding correct Purpose all under number 3a.     Utility Software Purpose     compression protect from viruses       create copies of files     backup Blocks IP addresses       reduces size of files     anti-malware converts file types (3) 3 b Which one of these types of devices can have software installed to it?     A    Memory     B    OMR Reader     C    Processor     D    Storage   (1) 3 c Explain one benefit to Eunice of updating her software regularly.   (2) 3 d Eunice is travelling by train. She connects to the Internet using the train’s Wi-Fi connection. Explain why the Wi-Fi provider blocks video streaming.   (2) 3 e The Internet has provided a wider range of entertainment and leisure opportunities. One example is video and audio streaming. State two other examples.   (2) 3 f Eunice changes her laptop’s GPS settings. Which one of these statements is true?     A    GPS is used by all digital devices     B     GPS does not use an Internet connection     C    GPS uses cloud computing     D    GPS is better if opensource software is used   (1) 3 g Eunice writes a blog. Eunice wants visitors to her blog to see posts that are likely to be relevant to them. Describe how cookies can be used to achieve this. (4)    

Upload question 1 Upload your PDF document here and label it: SURNAME_NAME_GRDS_GR10 E_SBA_008a_NOVEX_PAPER 1_QUESTION 1