Question 110 marks
Question
• Open the file N219READING.rtf • The page setup is set to A4, portrait orientation with 2 centimetre margins. Do not make any changes to these settings. • Save the document in your work area, in the format of the software you are using, with the file name EBOOKS EVIDENCE 1 Place in your Evidence Document a screenshot to show this file has been saved. Make sure there is evidence of the file type. [1] 2 • Place in the header: • automated page numbers left aligned • automated date field to display today’s date, right aligned. • Place your name, centre number and candidate number right aligned in the footer. • Make sure that: • all the alignments match the page margins • no other text or placeholders are included in the header and footer areas • headers and footers are displayed on all pages. [2] 3 • Create and store the following styles, basing each on the default paragraph style: House style specifications Font size (points) Enhancement Space Before Line spacing Space After Style name Alignment Font style (points) (points) DB-Subtitle sans-serif 16 right italic single 0 0 DB-Subhead serif 14 centre bold, all capitals single 0 6 DB-Body sans-serif 10 justified none single 0 6 DB-Table serif 11 left italic single 0 0 EVIDENCE 2 Take a screenshot to show that the style settings have been defined for the DB-Subhead style. Make sure there is evidence that this is based on the default paragraph style. Place this in your Evidence Document. [3] 4 • The style name DB-Title has already been created, stored and applied to the title text. • Modify the DB-Title style so only the following formatting is applied: Font size (points) Enhancement Space Before Line spacing Space After Style name Alignment Font style (points) (points) DB-Title sans-serif 32 centre bold, underline single 0 6 EVIDENCE 3 Take a screenshot of the style settings for the DB-Title style to show that these have been changed. Place this in your Evidence Document. [2] 5 • Display these custom style names as a list in the style manager/organiser. Provide screenshot evidence of this list. EVIDENCE 4 Place this screenshot in your Evidence Document. [1] 6 • Below the title add the subtitle: Report by: and add your name [1] 7 • Apply the DB-Subtitle style to this text. [1] 8 • Apply the DB-Body style to the rest of the document. [1] 9 • Change the page layout so that the subheading History of Digital Books and all following text is displayed in two columns of equal width with a 1 centimetre space between the columns. [2] 10 • Apply square shaped bullets to the list from: dedicated e-readers such as… to … including the Notepad • Make sure that: • the bullets are indented 1 centimetre from the left margin • the list is in single line spacing with no space before or after each line • there is a 6 point space after the last item in the list. [2] 11 • Identify the 7 subheadings in the document and apply the DB-Subhead style to each one. [1] 12 • Open the file N219EREADER.csv and insert the contents as a table after the text … devices over the years: [1] 13 • Delete the entire row and contents for Maxi Reader [1] 14 • Sort the data in the table into ascending order of Year. [1] 15 • Insert a new row in the correct position according to the sort order. • Enter the following details: Tawara Phablet Digital Tawara 2007 [2] 16 • Apply the DB-Table style to the table. • Make sure that: • no text is wrapped within the table • all internal and external gridlines are displayed when printed • the borders and all data fit within the column width • there is a 6 point space after the table. [2] 17 • Format the first row of the table to be: • bold and centre aligned over the three columns • shaded with a light grey background (20–40%). [2] 18 • Import the image N219IMAGE.jpg and place this below the subheading The Future [1] 19 • Reflect the image so the e-reader is on the right. It must look like this: [1] 20 • Format the image so that: • it is re-sized to a width of 3 centimetres with the aspect ratio maintained • it is aligned to the left margin of the second column and the top of the paragraph starting Many consumers have embraced… • the text wraps round the image. [2] 21 • Spell check and proofread the document. • Make sure that: • lists and tables are not split over columns or pages • there are no widows or orphans • there are no blank pages • the house style specification has been followed and the correct styles applied as instructed • spacing is consistent between all items. • Save the document using the same file name and format used in Step 1. • Print the document. PRINTOUT 1 Make sure your name, centre number and candidate number are on your report [1] 22 • Many book stores sell books online through the internet. • Discuss the advantages and disadvantages to customers of buying books through internet shopping. EVIDENCE 5 Type your answer into your Evidence Document using no more than 100 words. [4] [Total: 35] Task 3 – Database You are now going to prepare some reports. Make sure all currency values display the same currency symbol and are set to 2 decimal places. 23 • Using a suitable database package, import the file N219BOOKS.csv • Use these field names and data types: Field Name Data Type Format Author Text Title Text Book_Ref Text Publisher Text Format_Code Text Release_Year Number Integer Price Number/Currency No_Items Number Integer Pages Number Integer Available Boolean/Logical To display as Yes/No • Set Book_Ref field as a primary key. • Save the data. EVIDENCE 6 Place in your Evidence Document screenshot evidence showing the field names and data types used in the table. [2] 24 • Import the file N219FORMAT.csv as a new table in your database. • Set Type_Code field as a primary key. • Create a one-to-many relationship between Format_Code in the books table and the Type_Code in the format table. EVIDENCE 7 Place in your Evidence Document screenshot evidence showing the relationship between the two tables. [1] 25 • Add the following as a new record in the books table: Author Anne Rice Title Wolf Gift Book_Ref B0501 Publisher Quiver Format_Code BP02 Release_Year 2015 Price 8.49 No_Items 1 Pages 416 Available Yes [1] 26 • Using fields from the books table, produce a tabular report that: • selects the records where: – Release_Year is 2014 or 2015 – Price is 5.00 or more – Available is Yes • shows only the fields Title, Author, Price, Release_Year and Available in this order with data and labels displayed in full. Do not group the data • sorts the data into descending order of Price • has a page orientation of portrait • fits on a single page • includes only the text Book Releases 2014/2015 as a title displayed in a larger font size at the top of the page • calculates the average Price and positions this under the Price column • displays this average price value to 2 decimal places with the same currency symbol as the Price field • has a label Average book price to the left of this value • does not display a page number when printed • has your name, centre number and candidate number at the bottom of the report. • Save and print your report. PRINTOUT 2 Make sure that you have entered your name, centre number and candidate number on your report. EVIDENCE 8 Place in your Evidence Document a screenshot showing the database formula used to calculate the average price. [10] 27 • Using fields from both tables produce a tabular report that: • selects the records where: – Publisher includes the word Digital – Release_Year is later than 2011 • contains a new field called Book_Tax which is calculated at run-time and displayed with the same currency formatting as the Price field. This field will calculate the Price plus 10% of the price • shows only the fields Book_Ref, Publisher, Title, Author, Book_Type, Release_Year, Price and Book_Tax in this order with data and labels displayed in full. Do not group the data • sorts the data into ascending order of Book_Type and then descending order of Release_Year • has a page orientation of landscape • fits on a single page wide • includes only the text Digital Publishing as a title displayed in a larger font size at the top of the page • has your name, centre number and candidate number in the footer of the report so it displays on every page. • Save and print your report. PRINTOUT 3 Make sure that you have entered your name, centre number and candidate number on your report. [10] 28 • Answer the following questions and record your answers in your Evidence Document: (a) Describe the difference between hardware and software. [2] (b) Give one example of hardware. [1] (c) Give one example of software. [1] EVIDENCE 9 Type your answers into your Evidence Document using no more than 50 words [Total: 28] Task 4 – Mail merge You are required to carry out a mail merge. 29 • Create a mail merge letter using the file N219CLUB.rtf as the master document and N219MEMBERS.csv as your data source file. • Replace <Date> with a field to display today’s date in the format dd-MMM-yy EVIDENCE 10 Take screenshot evidence of the date field code showing the format used. Place this screenshot in your Evidence Document. [1] 30 • Replace the text and chevrons in the master document with the merge fields from the data source file as follows: Text and chevrons to replace Replace with field <GRP> Group <MTH> Month <BK> Book <AUT> Author <DY> Day <DT> Date <TM> Time <VEN> Venue <NTS> Notes • Make sure the spacing, punctuation and alignment in the original master document are maintained. [3] 31 • Replace the text Candidate Name with your name. • Include your centre number and candidate number in the footer of the document. • Save and print the master document with the merge fields displayed. PRINTOUT 4 Make sure you have entered your name, centre number and candidate number on your master document. [1] 32 • Set an automated filter to select the books chosen for the month of December EVIDENCE 11 Place in your Evidence Document screenshot evidence to show the use of an automated selection method. [1] 33 • Merge and print the letters for December only. • Save and close the files. PRINTOUT 5 Print the result of the merge. Make sure you have entered your name, centre number and candidate number on your letters. [1] [Total: 7] Task 5 – Presentation You are going to create a short presentation. All slides must have a consistent layout and formatting. Unless otherwise instructed, slides should be formatted to display a title and bulleted list. 34 • Create a presentation of 6 slides using the file N219PRES.rtf [1] 35 • Format slide 1 so that: • a title slide layout is applied • the title and subtitle are centred in the middle of the slide • your name appears after the text Produced by: [1] 36 • Use a master slide to display the following features on all slides: • your name, centre number and candidate number • automatic slide numbers. [1] 37 • Use the data in the file N219SALES.csv to create a vertical bar chart to compare only the physical and digital book sales for all years. [1] 38 • Label the chart with the following: • title UK BOOK SALES • value axis title £M [1] 39 • Display the values as data labels on each bar. • Display a legend. [1] 40 • Format the value axis scale to display: • a minimum value of 0 • a maximum value of 3600 • increments of 600 [2] 41 • Place the chart to the left of the bullets on the slide with the title Comparison of Physical and Digital Sales [1] 42 • Save the presentation. • Print the presentation as a handout with 6 slides to the page. • Print only the slide with the title Comparison of Physical and Digital Sales as a full page slide in landscape orientation. PRINTOUT 6 Print these slides. Make sure your name, centre number and candidate number are on all slides. [1] [Total: 10] Task 6 – Printing the Evidence Document 43 • Print your Evidence Document. PRINTOUT 7 Make sure that you have entered your name, centre number and candidate number on your Evidence Document.
Mark scheme
02/12/2019 The World of Digital Books DB-Title modification correct in EV3 with attributes Report by: Candidate name Digital books and e-readers have become applied - sans-serif 32pt, centre aligned, bold, a significant part of our reading culture and changed the publishing world. The popularity of e-books underline, 6pt after (0pt before) has grown significantly 1 mark over recent years, mainly due to increased content availability and improved technology. An e-reader is a mobile electronic device that is designed primarily for the purpose of reading e-books and Subtitle entered accurately with candidate name 1 mark digital magazines. It is small and portable and can store thousands of books. An electronic book, or e-book, is a DB-Subtitle seen in EV4 list and applied 1 mark publication made available in digital form and formatted so it can be read on a screen. Some e-books are an (sans-serif, 16pt, italic, right aligned, 0pt before and after electronic version of a printed book but many are now being developed exclusively for the sc reen without a printed equivalent. HISTORY OF DIGITAL BOOKS audio and video coverage. Further reading on the Subheadings same or related(7) topics could easily be accessed The first electronic book document was produced DB-Subhead style matches style defined in EV2, using search engines. in 1971 by Michael S. Hart who is tho ught by applied consistently to all 1 mark many to be the inventor of the electronic book. He Digital publishing became mainst ream in 1997. adapted the United States Declaration of Online publishing became a cheaper option than Independence into an electronic document by printed books for educational, academic and Columns scientific publications. It also enabled regular typing itbreak, Section into acorrect computer in plain position, text. From there applied he launched Project Gutenberg. His mission updates to include the latest information without to correct text 1 markwas waiting for a new printed edition. Some universities to make as many literary 2 columns, 1 cm column spacing works in the public 1 mark domain as possible freely available, in electronic began to create their own textbooks online with format, for the education of as many people as papers and comments from professors. possible. He planned to establish an electronic public library of 10,000 books (this goal was DIGITAL READING reached in October 2003) created using plain text The emerging market of online bookstores selling to make them as easy as possible to download only digital books took off in 2003. It took a while to and view on devices. He has devoted his entire life convince publishers that books should be to this project. simultaneously published as a print book and a digital book. For the first time last year publishers Project Gutenberg is the oldest producer of free earned more from digital book sales than from books on the internet. Books in the public domain Table traditional bookstores. wereComplete keyed by volunteers table imported and by August in correct 1989 position, no changes to data 1 mark Project Maxi Gutenberg Reader row hadeleted completed its 10th e-book. In the early1 mark days reading e-books was not a ThisSorted was boosted ascending by ontheYear invention of the web in relaxing, recreational 1 mark activity. E-books were 1990Newwhich row initially in correcthad 250,000 position internet (above Knook) users. typically limited to being read on desktop computer 1 mark The Correct first webdatabrowser Mosaic Phablet entry – Tawara was released | Digital in Tawara |screens 2007 normally 1 mark located in an office environment. November Top row 1993 whichcentred merged, used hyperlinks to connect This changed in 1998 when small, dedicated 1 mark documents Top rowand textpages thus grey bold, light making the web shading easier applied electronic r 1eading mark devices were launched. These to use. As a result the internet could now be All fits within column, data on one line, gridlines used printedearly devices were expensive and had a limited 1 mark by DB-table anyone style and seen internet use spread quickly in EV4 list, applied to complete table number of e-books available. As a result growth worldwide. This italic, (serif, 11pt, made left, it easier to recruit no space after volunteers each row) was slow and initial responses were mixed with 1 mark and circulate e-texts. In August 1997 Project many people doubting there was a marketplace for Gutenberg had 1,000 e-books with an average e-books. The following table shows the release of output of 36 books per month. Ten years later it some e-reader devices over the years: had over 20,000 e-books in 50 languages with a production rate of 340 new books each month, 40 e-Readers mirror sites worldwide, and tens of thousands of Reader Company Year books being downloaded every day. RockICT e-book DecoMedia 1998 The first electronic versions of print newspapers CloseBook CloseBook 1999 and magazines began to appear in 1996 with Pearlstar e-book Pearlstar 2000 partial or full versions of the latest issues available freely or through subscription. Online versions Litre 1500-EP Sonny 2004 provided a wealth of additional information to help Sonny Reader Sonny 2006 readers understand the issues with links to maps, Tawara Phablet Digital Tawara 2007 political and economic data, photographs, and Footer Name, centre number, candidate number right aligned 1 mark Name, centre number, candidate number PUBLISHED 2019 Knook Bambi Publishing 2009 for all e-books so that a wide range of reading devices could display the same publication. Cabbage Notepad Cabbage 2010 Hobo e-reader Rasputen Hobo 2010 THE EPUB FORMAT Following the successive failures of first generation In September 1999 the first version of Open e- e-readers, the devices were expected to disappear book (OeB) was released with the aim of providing from the market. However, the advent of E-ink a single source document which all book-reading technology transformed the quality of the reading software and hardware platforms could handle. In screens. New generation e-readers were released April 2005 OeB format was replaced with ePub with improved E-ink technology screens which (electronic publication format). The ePub format provided a reading experience similar to the makes the text adapt to the screen size so it is traditional printed book. With the price of reading easier for a range of devices to display readable devices and e-books significantly reduced, more text. Books in e-pub format can be downloaded to content available and better retail distribution, the a computer, phone, tablet, e-reader or read in a e-reader was given a new lease of life. web browser and is becoming the publishing industry standard format for e-books. In 2007 Tawara launched a dedicated e-reader called the Phablet which became the most PDF FORMAT successful electronic reading device and transformed this digital market. The Phablet had PDF (Portable Document Format) was launched in long battery life, built-in memory and an SD card June 1993 and became the global standard for the providing plenty of book storage, a screen using distribution and viewing of documents. A free the E-ink technology, and page-turning buttons. reader was needed to read these files. Until Unlike the Sonny Reader there was no need Imagefor a recently exporting a publication to PDF was the computer as books were purchased onlineImage and inserted traditional way in correct to create position (belowansubhead) e-book. PDF files 1 mark downloaded via a 3G wireless connection. TheImage first flippedretain the original formatting so e-reader on right such as page layout, 1 mark Phablet release sold out in less than six hoursAligned and to top fonts and images of text, so can left margin, text be difficult to read wrapped as the 1 mark the sales of e-books doubled between 2007Resizedand to 3text cm does wide, not aspectadapt ratioormaintained re-flow according1 markto the 2008. device screen size. PDF remains a popular format for sharing electronic documents but is no longer READING DEVICES the standard format for e-books. Commercially produced and sold e-books are THE FUTURE usually intended to be read on a dedicated e- reader device. However many people now read e- Many consumers have books on their mobile devices preferring embraced digital reading but multifunctional devices over dedicated e-reader the e-reader market is brands. In 2016 surveys showed that mobile changing and is set to face phones and tablets overtook e-readers as the most fierce competition from common electronic reading devices. Depending on tablets and smartphones. the format of the book, almost any computer Evidence suggests that device that features a controllable viewing screen people are switching to reading content on their can be used to read e-books including: Bullets mobile devices which offer e-reader capabilities in Square shaped addition bullets to other to applied mobile applications. correct text Dedicated e- 1 mark dedicated e-readers such as Phablet, readers couldlefthave a limited lifespan Bullets indented 1 cm from margin, single line spaceas a 1new mark Sonny, Knook, Hobo genre of tablet-based books are released with netbooks and laptops multimedia and hypermedia content. Research personal computers does suggest that older readers will continue with smartphones e-readers, whilst younger readers are increasingly tablet computers including the Notepad using tablets. However laptops, tablets and phones There are many e-reader applications freely do not replicate any of the unique selling points of available which allow the reading of e-books on the e-reader which include very long battery life, mobile devices independently of a dedicated e- the ability to read in bright light, and no eye strain book device. when reading for prolonged periods. In recent years Tawara has released one of the DIGITAL BOOK FORMATS thinnest e-readers in the world which comes with a In the beginning there was no common format for case with a battery built into it. Solarex released a Page layout e-books. Each company would produce their own solar-powered e-reader case so it never has to be DB-Body e-book style seen reader with initsEV4ownlist and applied reading consistently charged via a USB cable and Hobo and Tuluba software. 1 mark (sans-serif, 10pt, justified, single Books in one format could not be read on a line, 0pt before, 6pt space haveafter) incorporated yellow LED lights to inhibit the Doc complete/paras different device. Theintact, A4,publishing digital portrait, noindustry large gaps, columns amountaligned of blueat light top, no widows/orphans, that emits from the front-lit split lists/tables, recognised no blank the need pages,a6pt to develop after bullet common list, 6pt after format tableHowever there have been no other major display. 1 mark PUBLISHED 2019 developments in technology to take e-readers to a next level. Future advances could include a new processer which enables animations and videos to be played. It is expected that more companies will produce waterproof e-readers and a high resolution colour E-ink reader display is also on the horizon. Some companies believe bigger screens are the way forward and are bucking the six inch trend. PUBLISHED 2019 Title Specified fields (5), correct order, 1 mark Correct, 100% accurate 1 mark Sort descending order of Price 1 mark Portrait, all fields present, no truncation, fits single page 1 mark Book Releases 2014/2015 Title Author Price Release_Year Available Locked On Tom Clancy £37.54 2015 Yes Steve Jobs Walter Isaacson £25.01 2015 Yes Notes From A Small Island Bill Bryson £24.98 2015 Yes Desolation Island Patrick OBrian £22.98 2015 Yes Shadowfever Karen Marie Moning £22.53 2015 Yes Never Let Me Go Kazuo Ishiguro £19.99 2014 Yes Night Road Kristin Hannah £18.78 2015 Yes Obamas A Mission A Marriage Jodi Kantor £18.78 2014 Yes Island Of The Blue Dolphins Scott OBasil £18.36 2015 Yes Unbroken Laura Hillenbrand £17.99 2014 Yes Stay Close Harlan Coben £17.50 2014 Yes Angels And Demons Dan Brown £16.99 2014 Yes Scotland Highlands And Islands Neil Wilson £10.49 2015 Yes Chile And Easter Island Travel Guide Carolyn McCarthy £10.35 2015 Yes Harry Potter And Chamber Of Secrets Book 2 J K Rowling £9.99 2014 Yes Now You See Her James Patterson £9.39 2014 Yes Harry Potter And Goblet Of Fire Book 4 J K New record Wolf Gift added accurately and Rowling £8.99 2014 Yes 1st record Harry Potter And Locked Half Blood On, Book Prince £37.54 6 still present J K Rowling 1 mark£8.99 2014 Yes Butterfly Island Corina Bomann £8.99 2015 Yes Defending Jacob William Landay £8.75 2015 Yes Wolf Gift Anne Rice £8.49 2015 Yes Harry Potter And Order Of Phoenix Book 5 J K Rowling £7.99 2014 Yes 1105 Yakima Street Debbie Macomber £7.99 2014 Yes No Time For Goodbye Linwood Barclay £7.99 2015 Yes Home Front Kristin Hannah £7.99 2014 Yes Camel Creek Demons Patsy Fletcher £7.85 2014 Yes Harry Potter And Philosophers Stone Book 1 J K Rowling £6.99 2014 Yes Spider Bones Kathy Reichs £6.67 2015 Yes An Engagement In Seattle Debbie Macomber £6.50 2015 Yes Inner Circle Brad Meltzer £6.25 2015 Yes The Island Of Adventure Eni d Blyton £5.94 2014 Yes Redwood Bend Ron Carr £5.39 2015 Yes Killing Tide P J Alderman £5.10 2014 Yes Invisible Roses Rita Sams £5.00 2014 Yes Harry Potter And The Deathly Hallows Book 7 J K Rowling £5.00 2015 Yes Name, centre number, candidate number Average book price £12.53 Calculates correct average Price 1 mark Average under Price column, accurate label entered to left 1 mark Average and Price display same currency symbol, 2dp, Available displays Yes/No 1 mark Select records (35): Release_year is 2014 or 2015 1 mark Name, centre number, candidate number displays Price is >=£5.00, Available is Yes 1 mark at bottom, no page number displayed. 1 mark PUBLISHED Calculated field Heading Book_Tax 100% accurate 1 mark Title Price plus 10% calculated - correct values 1 mark Correct, 100% accurate 1 mark Same currency symbol and 2dp as Price field 1 mark Digital Publishing Book_Ref Publisher Title Author Book_Type Release_Year Price Book_Tax A0010 Digital Tawara Tales Of Talskiddy Treacle Mine Benson McChris Audio 2018 £7.99 £8.79 A0177 Digital Tawara Dunes Of Dreams Margery Vadson Audio 2017 £6.23 £6.85 A0144 Digital Tawara Long Beach Maria Mathson Audio 2016 £4.99 £5.49 A0068 Digital Tawara Silken Valley Joceline Redington Audio 2016 £5.49 £6.04 A0183 Digital Tawara Honeycomb Village Maria Mathson Audio 2015 £6.45 £7.10 A0182 Digital Tawara Camel Creek Demons Patsy Fletcher Audio 2014 £7.85 £8.64 A0120 Digital Tawara Invisible Roses Rita Sams Audio 2014 £5.00 £5.50 A0086 Digital Tawara Mutant Blue Jeffrey Reeves Audio 2014 £4.49 £4.94 A0024 Millen Digital Audio Bridget Jones Edge Of Reason Helen Fielding Audio 2013 £11.22 £12.34 A0112 Millen Digital Audio Room Emma Donoghue Audio 2012 £18.98 £20.88 A0023 Millen Digital Audio Bridget Jones Diary Helen Fielding Audio 2012 £13.27 £14.60 E0504 Harley Quinn Digital Glass Castle Jeannette Walls eBook 2016 £4.99 £5.49 E0727 Digital Press Killing Tide P J Alderman eBook 2015 £1.99 £2.19 E0252 Antique Digital Spider Bones Kathy Reichs eBook 2015 £6.67 £7.34 E0062 Digital Tawara Rebels Of Power Stevie Hilliard eBook 2015 £4.50 £4.95 E0047 Harley Quinn Digital Chasing Fire Nora Roberts eBook 2015 £3.99 £4.39 E0236 Transformation Digital Digital Fortress Dan Brown eBook 2014 £4.93 £5.42 E0239 LLSB Digital Something Blue Emily Giffin eBook 2013 £3.96 £4.36 E0607 Antique Digital Why Me Sarah Burleton eBook 2013 £1.92 £2.11 E0658 Digital Tawara Night Battleship Charlie Dawson eBook 2013 £12.55 £13.81 E0144 Digital Tawara The Liliac Sky Gregory Brooklin eBook 2013 £8.99 £9.89 E0412 Quoin Digital Fate Of The Jedi Apocalypse Troy Denning eBook 2012 £15.85 £17.44 Select records (39): Publisher contains Digital 1 mark Specified fields (7 base fields), correct order 1 mark Release_Year is >2011 1 mark Sort ascending on Book_Type, descending Release_Year 1 mark Landscape, one page wide, all base fields present, data fully visible 1 mark Name, centre number, candidate number Name, centre number, candidate number displays in report footer, on every page 1 mark PUBLISHED Book_Ref Publisher Title Author Book_Type Release_Year Price Book_Tax E0885 Quoin Digital Once Upon A Secret Mimi Alford eBook 2012 £9.99 £10.99 E0934 Quoin Digital Private Games James Patterson eBook 2012 £9.99 £10.99 E0933 Quoin Digital Private 1 Suspect James Patterson eBook 2012 £9.49 £10.44 E0924 Quoin Digital Power Of Habit Charles Duhigg eBook 2012 £10.85 £11.94 E0126 Digital Tawara Legacy Of The Androids Sam Fernleigh eBook 2012 £9.99 £10.99 E0326 Quoin Digital Drop Dead Healthy A J Jacobs eBook 2012 £10.85 £11.94 E0579 Ebony Digital Welcome To Your Brain Sandra Aamodt eBook 2012 £10.85 £11.94 E0631 Antique Digital Wolf Gift Anne Rice eBook 2012 £9.99 £10.99 E0043 Harley Quinn Digital Celebrity In Death J D Robb eBook 2012 £8.99 £9.89 E0625 Harley Quinn Digital Witness Nora Roberts eBook 2012 £9.49 £10.44 E0816 Harley Quinn Digital Mill River Recluse Darcie Chan eBook 2012 £1.99 £2.19 E0409 HMI Digital Boy In Striped Pyjamas John Boyne eBook 2012 £4.99 £5.49 E0179 Transformation Digital Deception Point Dan Brown eBook 2012 £5.49 £6.04 E0424 Transformation Digital Brick Lane Monica Ali eBook 2012 £5.49 £6.04 E0654 Transformation Digital I Got Your Number Sophie Kinsella eBook 2012 £9.99 £10.99 E0927 Transformation Digital Prayer For Owen Meany John Irving eBook 2012 £6.49 £7.14 E0947 Digital Tawara Dragons Of Sorcerers Christian Jennings eBook 2012 £6.99 £7.69 Name, centre number, candidate number PUBLISHED 2019 Task 4 – Mail merge Merge Fields inserted (<text> correctly replaced) «Group» | «Month» | «Book», | «Author». correct position, spacing & punctuation retained 1 mark «Day», «Date» | «Time» correct position, spacing, punctuation and centre alignment retained 1 mark «Venue». | «Month» | «Notes». correct position, spacing, punctuation retained 1 mark Name replaces Candidate Name centre no & candidate no in the footer 1 mark PUBLISHED 2019 Result of merge – 3 full-page letters printed – Bone Gap, The Baltimore Boys, The Magic Finger only 1 mark PUBLISHED 2019 Task 5 – Presentation 6 slides imported, title and bullet layout, no changes, no blank slides, no overlap of items 1 mark Slide 1 changed to title layout with title/subtitle centred middle of slide, name entered after colon 1 mark Master slide used for name, centre number, candidate number, slide numbers appear consistently on all slides, same position and size 1 mark PUBLISHED Vertical comparative bar chart created using correct data, year labels present 1 mark Chart on correct slide, left of bullets, all data fully visible 1 mark Chart title UK BOOK SALES and value axis title £M entered accurately 1 mark Value data labels display on each bar and correct legend for data 1 mark Value axis displays minimum 0, maximum 3600 1 mark Value axis increments set at 600 1 mark Print 6 slides to page as a handout and full page, single, landscape slide with title Comparison of Physical and Digital Sales 1 mark PUBLISHED EVIDENCE DOCUMENT Step 1 - EVIDENCE 1 File saved as EBOOKS with correct file type 1 mark Step 3 – EVIDENCE 2 DB-Subhead DB-Subhead text style created and named correctly 1 mark Serif, 14pt, bold, all capitals 1 mark Centre aligned, single line, 0pt space before, 6pt after 1 mark Step 4 – EVIDENCE 3 Original - prior to changes: DB-Title – style modified Evidence of original style modified, based on Normal/Default 1 mark PUBLISHED Step 5 – EVIDENCE 4 Style list Includes DB-Subtitle, DB-Body, DB-Table 1 mark Step 22 - EVIDENCE 5 – Discuss the advantages and disadvantages to customers of buying books through internet shopping. Advantages to customers Customers can buy anytime/can shop when shops are closed Customers can buy from any location where there is internet access Wider range of books available to customers Customer can benefit from lower/cheaper prices when compared to shop prices Customer does not have to waste time travelling/queuing Customer does not have to spend money on travelling to shops Easier to search and find what the customer is looking for Online reviews of books help the customer with making choices Websites may recommend books that match the customer’s search history Disadvantages to customers Hackers may intercept data and defraud the customer The customer may find it difficult/expensive to return books purchased online The customer must know how to use the computer/device to buy the book The customer must have access to a (internet) connection The customer cannot physically hold books The customer needs a payment card/online payment method/cannot pay by cash Goods take time to be delivered/sometimes don’t arrive/may be delivered to wrong address/can be damaged in transit There may be shipping/extra charges Must have at least one advantage and one disadvantage to get full marks Allow 1 mark for a detailed reasoned conclusion [4 marks] Step 23 - EVIDENCE 6 DB Structure Field names as given, correct data types, Book_Ref as primary key 1 mark PUBLISHED 2019 Step 24 - EVIDENCE 7 1-to-Many relationship between Format_Code/Type_Code fields 1 mark Step 26 - EVIDENCE 8 Database formula for calculated Average 1 mark Step 28 - EVIDENCE 9 (a) Describe the difference between hardware and software: Hardware refers to physical devices/components Software is a general term for the programs that control the computer system [2 marks] (b) Give one example of hardware Hardware devices such as: monitor, keyboard, mouse, printer, storage devices, processor, motherboard, random access memory (RAM), read-only memory (ROM), video card, sound card. [1 mark] (c) Give one example of software Software such as word processing, spreadsheet, database management systems/DBMS, desktop publishing, control software, measuring software, applets and apps, photo-editing software, video- editing software, graphics manipulation software, compilers, linkers, device drivers, operating systems and utilities. [1 mark] Step 29 - EVIDENCE 10 Field used to insert correct (today's) date in correct format dd-MMM-yy 1 mark Step 32 - EVIDENCE 11 Mail Merge selection Evidence of automated filter to select December 1 mark