Question: There are three types of test data that can be used to…

Question Answered step-by-step Question: There are three types of test data that can be used to… Question: There are three types of test data that can be used to test a system: normal, abnormal and extreme. Explain what is meant by normal, abnormal and extreme test data 2.The developer is planning to use cloud storage. (i) Describe four advantages to the school of using cloud storage rather than using the SSD.  3.A taxi company tracks the routes their cars have travelled and the current location of each one using a Global Positioning System (GPS). A map showing the route taken and current location of each car is displayed on the office monitor. Describe in detail how this system could work 4.A headteacher is planning to hold a video-conference with headteachers from other schools. The headteachers already have basic internet connected desktop computer systems including a monitor, keyboard and mouse. (a) Identify three pieces of additional hardware they need in order to participate in a videoconference. (b) A technician is setting up the hardware for the video-conference. State three tasks the technician would need to do to set up the hardware for the videoconference. You can assume that the hardware required has already been purchased.  5.Microprocessor-controlled devices in the home have had positive effects on people’s lifestyles. One of the positive effects of using these devices is that we can now set a cooker to switch on whilst we are out so that we arrive home to a cooked meal. Describe the positive effects of using other microprocessor-controlled devices in the home. 6.Tawara Retail is an online store. This online store does not have physical shops. Customers buy products from this store using internet shopping. Describe the advantages to Tawara Retail of offering internet shopping. 7.A manager in a hospital has decided to ask a software company to develop a computer system. The system should allow patients to book all their medical appointments online. (a) Discuss the advantages and disadvantages to both the patients and the medical staff of this type of system (b) The manager of the hospital has purchased an expert system to help diagnose their patients’ illnesses. Name three components of an expert system. 8.Candidate source files:TTSBanner.pngTTSbranches.csvTTSOffer.pngTTSstaff.csvTTSstyle.cssTTtext1.txtTTtext2.txtWallpaper.pngTask 1 – Evidence Document• Form  a document in a word processing application. Make sure your name, centre number andcandidate number will appear on every page by placing these details in the header.• Save the document in your work area with the name Evidence_ followed by your candidatenumber, for example Evidence_9999You will need your Evidence Document during the examination to display images, text and screenshotswhen required.Task 2 – Data Analysis• Open and examine the files TTSstaff.csv and TTSbranches.csv in a spreadsheet application.• Save the file TTSbranches.csv as a spreadsheet with the name TTSanalysis_ followed by yourcentre number and candidate number, for example, TTSanalysis_ZZ999_9999• Save the file TTSstaff.csv as a spreadsheet with the name TTSsales_ followed by your centrenumber and candidate number, for example, TTSsales_ZZ999_9999In your TTSanalysis spreadsheet:• Place your name, centre number and candidate number, centre aligned in the footer of the page.• In cell C1 add the text Branch Sales• Insert a new row above Row 1.• Merge the cells A1 to C1.• In the merged cell add the text TTS sales 2019• Format the merged cell so that:- the text is centre aligned with a red 24-point serif font- it has a green fill- it has a solid black border.• Wrap the text in cells A2 and C2.• Format the cells A2 to C2 as:- bold- centred horizontally and vertically Adjust the cell widths so all data is visible.• Save the TTSanalysis spreadsheet. [11]In your TTSsales spreadsheet:• Place your name, centre number and candidate number, centre aligned in the header of the page.• In cell E1 enter the text Branch• In cell E2 enter a function to use the Branch code to lookup the Branch from the TTSanalysis file.• Replicate this formula for each member of staff.• Save the TTSsales spreadsheet.• Print only the data for the Almere and Amsterdam branches showing the formulae. Make sure:- it is in landscape orientation- the row and column headings are displayed- the contents of all the cells are fully visible.PRINTOUT 1Make sure that you have entered your name, centre number and candidate number on thespreadsheet showing the formulae.[10]• Keeping the data in ascending order of Branch, sort the TTSsales data so that the sales for themembers of staff in the branch are in descending order.• Save the TTSsales spreadsheet.• Print the data for the Naples and Porto branches showing the values. Make sure:- it is in portrait orientation- the row and column headings are not displayed- the contents of all the cells are fully visible.PRINTOUT 2Make sure that you have entered your name, centre number and candidate number on thespreadsheet showing the values.[5]In your TTSanalysis spreadsheet:• Sort the data so that the branches are in ascending order.• In cells C3 to C12 enter functions to calculate the total sales for each branch.• Save the TTSanalysis spreadsheet.  Print the spreadsheet showing the formulae. Make sure:- it is in landscape orientation- row and column headings are displayed- the contents of all the cells are fully visible.PRINTOUT 3Make sure that you have entered your name, centre number and candidate number on thespreadsheet showing the formulae.[5]• Print the spreadsheet showing the values. Make sure:- it is in portrait orientation- row and column headings are not displayed- the contents of all the cells are fully visible- the table is centred horizontally on the page.PRINTOUT 4Make sure that you have entered your name, centre number and candidate number on thespreadsheet showing the table.[4]• Extract only those branches with sales greater than $4 million.• Print the spreadsheet showing the extracted data. Make sure:- it is in portrait orientation- row and column headings are not displayed- the contents of all the cells are fully visible- the table is centred horizontally on the page.PRINTOUT 5Make sure that you have entered your name, centre number and candidate number on thespreadsheet showing the extract.[5]• Create and fully label a chart to compare the data for all of the branches.• Print only the chart.PRINTOUT 6Make sure that you have entered your name, centre number and candidate number on thechart.[5]• In cell B13 add the text Total Sales and format the text as bold.• In cell C13 insert a formula to calculate the total of the branch sales • Format the value as bold.• In cell D2 add the text Target Sales, wrap and centre the text and format it as bold.• In cell D13 insert a formula to increase the value of the Total Sales by a percentage. Use trial anderror to work out the smallest percentage increase necessary to reach a Target Sales value of$50 000 000.• Replicate this formula for all the branches.• Print the spreadsheet showing the formulae. Make sure:- it is in landscape orientation- row and column headings are displayed- the contents of all the cells are fully visible.PRINTOUT 7Make sure that you have entered your name, centre number and candidate number on thespreadsheet showing the formulae.[5]• Print only the data showing the values. Make sure:- it is in portrait orientation- the row and column headings are not displayed- the contents of all the cells are fully visible.PRINTOUT 8Make sure that you have entered your name, centre number and candidate number on thespreadsheet showing the values.Image transcription textAssessment 2.0: Construction historicalcontext For a line or route for whichyou are familiar, undertake… Show more… Show moreImage transcription textAssignment # 3: CompilerConstruction Q1: Create aProgramming language gr… Show more… Show more  Computer Science Engineering & Technology C++ Programming CMPE 257 Share QuestionEmailCopy link Comments (0)