var g_txt=[
{t:"iii",p:1,x:784,y:1292,w:11,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:1,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:1,x:514,y:111,w:162,h:15},
{t:"ACKAGES",p:1,x:692,y:111,w:70,h:15},
{t:"Contents",p:1,x:165,y:177,w:113,h:29},
{t:"Introduction",p:1,x:259,y:238,w:118,h:26},
{t:"iv",p:1,x:762,y:238,w:15,h:26},
{t:"What are General Purpose P ackages, why",p:1,x:259,y:274,w:397,h:26},
{t:"do we use them and what are they used for?",p:1,x:259,y:299,w:409,h:26},
{t:"1",p:1,x:767,y:300,w:10,h:26},
{t:"Storing Data in Your GPP",p:1,x:259,y:338,w:249,h:26},
{t:"4",p:1,x:767,y:338,w:10,h:26},
{t:"The Human-Computer Interface",p:1,x:259,y:378,w:313,h:26},
{t:"8",p:1,x:767,y:378,w:10,h:26},
{t:"Integrated Packages",p:1,x:259,y:418,w:187,h:26},
{t:"13",p:1,x:756,y:418,w:21,h:26},
{t:"What do you need to know about the Packages?",p:1,x:259,y:458,w:444,h:26},
{t:"17",p:1,x:756,y:458,w:21,h:26},
{t:"What do you need to know about Graphics?",p:1,x:259,y:498,w:412,h:26},
{t:"25",p:1,x:756,y:498,w:21,h:26},
{t:"What do you need to know about Spreadsheets?",p:1,x:259,y:538,w:447,h:26},
{t:"29",p:1,x:756,y:538,w:21,h:26},
{t:"What do you need to know about Databases?",p:1,x:259,y:578,w:420,h:26},
{t:"35",p:1,x:756,y:578,w:21,h:26},
{t:"Desktop Publishing",p:1,x:259,y:618,w:186,h:26},
{t:"40",p:1,x:756,y:618,w:21,h:26},
{t:"Presentation/Multimedia P ackages",p:1,x:259,y:658,w:336,h:26},
{t:"44",p:1,x:756,y:658,w:21,h:26},
{t:"Creating  a Web Page",p:1,x:259,y:698,w:204,h:26},
{t:"50",p:1,x:756,y:698,w:21,h:26},
{t:"What is an Expert System?",p:1,x:259,y:738,w:252,h:26},
{t:"54",p:1,x:756,y:738,w:21,h:26},
{t:"General Purposes P ackages in the Workplace",p:1,x:259,y:778,w:432,h:26},
{t:"56",p:1,x:756,y:778,w:21,h:26},
{t:"The Law",p:1,x:259,y:818,w:84,h:26},
{t:"59",p:1,x:756,y:818,w:21,h:26},
{t:"GPP Questions",p:1,x:259,y:858,w:145,h:26},
{t:"64",p:1,x:756,y:858,w:21,h:26},
{t:"GPP Answers",p:1,x:259,y:898,w:130,h:26},
{t:"74",p:1,x:756,y:898,w:21,h:26},
{t:"Answers to Exercises",p:1,x:259,y:938,w:195,h:26},
{t:"80",p:1,x:756,y:938,w:21,h:26},
{t:"© Learning and Teaching Scotland ",p:1,x:338,y:1323,w:313,h:26},
{t:"25",p:2,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:2,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:2,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:2,x:692,y:112,w:73,h:15},
{t:"What do you need to know",p:2,x:166,y:175,w:399,h:35},
{t:"about Graphics?",p:2,x:166,y:215,w:249,h:35},
{t:"Feature",p:2,x:171,y:268,w:60,h:23},
{t:"What you need to know",p:2,x:332,y:268,w:195,h:23},
{t:"Enter text",p:2,x:171,y:303,w:75,h:22},
{t:"Entering text in a graphics package is very useful. It lets you",p:2,x:332,y:303,w:457,h:22},
{t:"label graphics!",p:2,x:332,y:323,w:110,h:22},
{t:"Draw graphic",p:2,x:171,y:356,w:105,h:22},
{t:"You can use the drawing tools to create your own graphic.",p:2,x:332,y:356,w:441,h:22},
{t:"Common tools",p:2,x:171,y:389,w:117,h:22},
{t:"Most graphics packages have a similar set of tools for",p:2,x:332,y:389,w:405,h:22},
{t:"drawing lines, circles and rectangles for pouring colour into a",p:2,x:332,y:409,w:467,h:22},
{t:"graphic and for drawing freehand.",p:2,x:332,y:429,w:261,h:22},
{t:"Alter tool attributes",p:2,x:171,y:509,w:147,h:22},
{t:"Changing the attributes of a tool such as the",p:2,x:332,y:509,w:335,h:22},
{t:"Line tool means changing, for example the",p:2,x:332,y:529,w:330,h:22},
{t:"colour or the thickness of the line.",p:2,x:332,y:549,w:260,h:22},
{t:"Scale graphic",p:2,x:171,y:709,w:101,h:22},
{t:"Scaling means changing the dimensions of a graphic by",p:2,x:332,y:709,w:424,h:22},
{t:"increasing or decreasing the height/width of the graphic.",p:2,x:332,y:729,w:429,h:22},
{t:"Rotate graphic",p:2,x:169,y:959,w:110,h:22},
{t:"This lets you spin your graphic round. Y ou can control the",p:2,x:331,y:959,w:444,h:22},
{t:"rotation either by dragging the graphic round using handles",p:2,x:330,y:979,w:454,h:22},
{t:"or by specifying the number of degrees.",p:2,x:330,y:999,w:303,h:22},
{t:"© Learning and Teaching Scotland ",p:2,x:338,y:1323,w:313,h:26},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:3,x:223,y:1291,w:277,h:15},
{t:"26",p:3,x:197,y:1291,w:12,h:15},
{t:"GENERAL PURPOSE P",p:3,x:225,y:112,w:162,h:15},
{t:"ACKAGES",p:3,x:403,y:112,w:73,h:15},
{t:"Scanning a graphic",p:3,x:191,y:735,w:247,h:29},
{t:"Once you load up your scanning software it will give you a series of choices",p:3,x:191,y:768,w:578,h:22},
{t:"that give you control",p:3,x:191,y:792,w:157,h:22},
{t:"over exactly how the",p:3,x:191,y:816,w:158,h:22},
{t:"scan is processed.",p:3,x:191,y:840,w:132,h:22},
{t:"You can choose:",p:3,x:191,y:888,w:122,h:22},
{t:"•",p:3,x:191,y:912,w:11,h:22},
{t:"the number of",p:3,x:233,y:912,w:110,h:22},
{t:"colours in the scan",p:3,x:233,y:936,w:141,h:22},
{t:"•",p:3,x:191,y:960,w:11,h:22},
{t:"the resolution of",p:3,x:233,y:960,w:125,h:22},
{t:"the scan: the",p:3,x:233,y:984,w:95,h:22},
{t:"number of pixels",p:3,x:233,y:1008,w:130,h:22},
{t:"per square inch",p:3,x:233,y:1032,w:118,h:22},
{t:"•",p:3,x:191,y:1056,w:11,h:22},
{t:"the type of file",p:3,x:233,y:1056,w:110,h:22},
{t:"that your scanned",p:3,x:233,y:1080,w:135,h:22},
{t:"image is saved as.",p:3,x:233,y:1104,w:135,h:22},
{t:"All of these can affect the quality of the scanned image and the size of the file",p:3,x:191,y:1152,w:592,h:22},
{t:"in which it is stored.",p:3,x:191,y:1176,w:154,h:22},
{t:"Cropping a graphic",p:3,x:193,y:181,w:244,h:29},
{t:"When you crop a graphic you cut out the part of the graphic that you do not",p:3,x:193,y:214,w:584,h:22},
{t:"want, usually by selecting the cropping tool and dragging the handles at the",p:3,x:193,y:238,w:577,h:22},
{t:"edge of the graphic.",p:3,x:193,y:262,w:151,h:22},
{t:"This graphic has white lines down",p:3,x:193,y:306,w:262,h:22},
{t:"This one has been cropped to get",p:3,x:519,y:306,w:256,h:22},
{t:"the side.",p:3,x:193,y:330,w:63,h:22},
{t:"rid of the white lines.",p:3,x:519,y:330,w:163,h:22},
{t:"© Learning and Teaching Scotland ",p:3,x:338,y:1323,w:313,h:26},
{t:"27",p:4,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:4,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:4,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:4,x:692,y:112,w:73,h:15},
{t:"Editing the scanned graphic",p:4,x:168,y:184,w:301,h:25},
{t:"Now that the graphic has been scanned you can load it into a graphics",p:4,x:169,y:646,w:538,h:22},
{t:"package and begin to edit it. Most graphics packages have features such as:",p:4,x:169,y:670,w:572,h:22},
{t:"‘Crop’, ‘Change colours’, ‘Layer graphic objects one on top of another",p:4,x:169,y:694,w:543,h:22},
{t:"’ and",p:4,x:740,y:694,w:38,h:22},
{t:"‘Zoom’, as well as enabling you to add effects such as ‘Soften’, ‘Sharpen’ and",p:4,x:169,y:718,w:593,h:22},
{t:"others that you can see in the menu above.",p:4,x:169,y:742,w:329,h:22},
{t:"Exercise 12",p:4,x:188,y:800,w:145,h:29},
{t:"This graphic image on the left is being edited",p:4,x:188,y:833,w:347,h:22},
{t:"below using the ‘Zoom’ feature then a",p:4,x:188,y:857,w:296,h:22},
{t:"combination of the editing tools in a paint",p:4,x:188,y:881,w:322,h:22},
{t:"package. Briefly describe the functioning of",p:4,x:188,y:905,w:332,h:22},
{t:"four of the graphic editing tools you have used.",p:4,x:188,y:929,w:360,h:22},
{t:"© Learning and Teaching Scotland ",p:4,x:338,y:1323,w:313,h:26},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:5,x:223,y:1291,w:277,h:15},
{t:"28",p:5,x:197,y:1291,w:12,h:15},
{t:"GENERAL PURPOSE P",p:5,x:225,y:112,w:162,h:15},
{t:"ACKAGES",p:5,x:403,y:112,w:73,h:15},
{t:"Exercise 13",p:5,x:212,y:193,w:145,h:29},
{t:"1.",p:5,x:212,y:226,w:13,h:22},
{t:"Use a selection of the tools available to produce a suitable images, for",p:5,x:235,y:226,w:535,h:22},
{t:"example the shape of a dancer",p:5,x:235,y:250,w:233,h:22},
{t:", a band, a CD -player, or spotlights.",p:5,x:480,y:250,w:285,h:22},
{t:"2.",p:5,x:212,y:274,w:13,h:22},
{t:"Use the infill tools and colour menus to make your graphic attractive.",p:5,x:235,y:274,w:533,h:22},
{t:"3.",p:5,x:212,y:298,w:13,h:22},
{t:"Scale and rotate your images until they look eye catching.",p:5,x:235,y:298,w:443,h:22},
{t:"4.",p:5,x:212,y:322,w:13,h:22},
{t:"Save the file as ‘discographics’ and then print it out.",p:5,x:235,y:322,w:394,h:22},
{t:"Use your graphics package to produce illustrations to be used to advertise",p:5,x:212,y:366,w:562,h:22},
{t:"the school disco.",p:5,x:212,y:390,w:126,h:22},
{t:"5.",p:5,x:212,y:414,w:13,h:22},
{t:"Produce a template for a handbill advertising the school discos. Set out",p:5,x:235,y:414,w:548,h:22},
{t:"the styles, text sizes and fonts as well as margins and text alignment.",p:5,x:235,y:438,w:519,h:22},
{t:"Save the template as ‘handbill’.",p:5,x:235,y:462,w:241,h:22},
{t:"6.",p:5,x:212,y:486,w:13,h:22},
{t:"Scan in a suitable graphic, edit it by",p:5,x:235,y:486,w:273,h:22},
{t:", for example, cropping it, scaling it",p:5,x:522,y:486,w:270,h:22},
{t:"or changing the colours, then save it.",p:5,x:235,y:510,w:280,h:22},
{t:"7.",p:5,x:212,y:534,w:13,h:22},
{t:"Open up the template and use it to create a handbill to advertise the",p:5,x:235,y:534,w:523,h:22},
{t:"senior school disco. Enter suitable text about the location, timing and",p:5,x:235,y:558,w:530,h:22},
{t:"cost then insert the scanned graphic.",p:5,x:235,y:582,w:276,h:22},
{t:"8.",p:5,x:212,y:606,w:13,h:22},
{t:"Save the file.",p:5,x:235,y:606,w:98,h:22},
{t:"9.",p:5,x:212,y:630,w:13,h:22},
{t:"Print out the finished handbill.",p:5,x:235,y:630,w:235,h:22},
{t:"© Learning and Teaching Scotland ",p:5,x:338,y:1323,w:313,h:26},
{t:"29",p:6,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:6,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:6,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:6,x:692,y:112,w:73,h:15},
{t:"What do you need to know",p:6,x:164,y:178,w:399,h:35},
{t:"about Spreadsheets?",p:6,x:164,y:218,w:320,h:35},
{t:"Spreadsheet software lets you enter and store numeric data and perform",p:6,x:164,y:282,w:552,h:22},
{t:"calculations on it using formulae.",p:6,x:164,y:306,w:254,h:22},
{t:"Spreadsheets are organised into rows and columns.",p:6,x:164,y:354,w:391,h:22},
{t:"Column",p:6,x:598,y:451,w:55,h:19},
{t:"Formula",p:6,x:410,y:418,w:56,h:19},
{t:"Row",p:6,x:218,y:619,w:29,h:19},
{t:"Spreadsheet terms",p:6,x:166,y:862,w:240,h:29},
{t:"Feature",p:6,x:171,y:906,w:60,h:23},
{t:"What you need to know",p:6,x:346,y:906,w:195,h:23},
{t:"Cell",p:6,x:171,y:934,w:32,h:22},
{t:"Each location in a spreadsheet is called a cell. Each cell",p:6,x:346,y:934,w:424,h:22},
{t:"has its own address made up of a column letter and a row",p:6,x:346,y:955,w:444,h:22},
{t:"number: C7, B8, D24.",p:6,x:346,y:976,w:172,h:22},
{t:"Row",p:6,x:171,y:1003,w:34,h:22},
{t:"Rows are numbered from 1 upwards.",p:6,x:346,y:1003,w:287,h:22},
{t:"Column",p:6,x:171,y:1031,w:65,h:22},
{t:"Columns have their own letter: A, B, C, D, E, F , etc.",p:6,x:346,y:1031,w:405,h:22},
{t:"Value",p:6,x:171,y:1058,w:42,h:22},
{t:"A value is a number or a formula.",p:6,x:346,y:1058,w:262,h:22},
{t:"Text",p:6,x:171,y:1086,w:33,h:22},
{t:"Text is entered to label cells, rows and columns or even to give",p:6,x:346,y:1086,w:482,h:22},
{t:"lengthy explanations of what is going on in the spreadsheet.",p:6,x:346,y:1107,w:457,h:22},
{t:"Insert row or column",p:6,x:171,y:1134,w:163,h:22},
{t:"This feature lets you put rows or columns into your",p:6,x:346,y:1134,w:394,h:22},
{t:"spreadsheet to make room for more data or formulae.",p:6,x:346,y:1157,w:417,h:22},
{t:"Alter the width",p:6,x:171,y:1187,w:118,h:22},
{t:"If you have a lot of data to put into a column, this",p:6,x:346,y:1187,w:381,h:22},
{t:"of a column",p:6,x:171,y:1211,w:94,h:22},
{t:"feature lets you widen it to make enough room.",p:6,x:346,y:1211,w:367,h:22},
{t:"© Learning and Teaching Scotland ",p:6,x:338,y:1323,w:313,h:26},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:7,x:223,y:1291,w:277,h:15},
{t:"30",p:7,x:197,y:1291,w:12,h:15},
{t:"GENERAL PURPOSE P",p:7,x:225,y:112,w:162,h:15},
{t:"ACKAGES",p:7,x:403,y:112,w:73,h:15},
{t:"Feature",p:7,x:191,y:185,w:60,h:23},
{t:"What you need to know",p:7,x:366,y:185,w:195,h:23},
{t:"Alter cell",p:7,x:191,y:225,w:68,h:22},
{t:"When you set up the attributes of a cell you are defining",p:7,x:366,y:225,w:431,h:22},
{t:"format/attributes",p:7,x:191,y:245,w:130,h:22},
{t:"the properties of that cell, the format of the data it will",p:7,x:370,y:245,w:416,h:22},
{t:"hold. Common cell attributes are: time, scientific,",p:7,x:366,y:265,w:382,h:22},
{t:"percentage, date, currency. This graphic shows examples of",p:7,x:366,y:285,w:452,h:22},
{t:"the various data formats that can be set up.",p:7,x:366,y:305,w:328,h:22},
{t:"Formula",p:7,x:193,y:723,w:66,h:22},
{t:"A formula sets out the calculation that has to be carried out",p:7,x:368,y:723,w:452,h:22},
{t:"on data. You should be able to recognise and use simple",p:7,x:368,y:743,w:431,h:22},
{t:"formulae such as:",p:7,x:368,y:763,w:134,h:22},
{t:"A4 + A5",p:7,x:368,y:803,w:68,h:22},
{t:"B6 –B7",p:7,x:368,y:843,w:57,h:22},
{t:"C6/C8",p:7,x:368,y:883,w:51,h:22},
{t:"D6 * D9",p:7,x:368,y:923,w:67,h:22},
{t:"You should also know these simple functions.",p:7,x:368,y:963,w:348,h:22},
{t:"=",p:7,x:368,y:1003,w:16,h:22},
{t:"sum(A1:A6) This calculates the total of the values in",p:7,x:401,y:1003,w:396,h:22},
{t:"cells A1 to A6.",p:7,x:401,y:1023,w:110,h:22},
{t:"=",p:7,x:368,y:1063,w:16,h:22},
{t:"average(B3:B12). This calculates the average of the",p:7,x:401,y:1063,w:389,h:22},
{t:"values in cells B3 to B12.",p:7,x:401,y:1083,w:191,h:22},
{t:"=",p:7,x:368,y:1123,w:16,h:22},
{t:" max(A4:A10) This finds the largest value in the range",p:7,x:401,y:1123,w:411,h:22},
{t:"A4 to A10.",p:7,x:401,y:1143,w:81,h:22},
{t:"=",p:7,x:368,y:1183,w:16,h:22},
{t:"min(B8:B16) This finds the smallest value in the range",p:7,x:401,y:1183,w:418,h:22},
{t:"A4 to A10.",p:7,x:401,y:1203,w:81,h:22},
{t:"© Learning and Teaching Scotland ",p:7,x:338,y:1323,w:313,h:26},
{t:"31",p:8,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:8,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:8,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:8,x:692,y:112,w:73,h:15},
{t:"Feature",p:8,x:169,y:182,w:60,h:23},
{t:"What you need to know",p:8,x:344,y:182,w:195,h:23},
{t:"Replication",p:8,x:169,y:215,w:87,h:22},
{t:"This simply means copying a formula down a column or",p:8,x:344,y:215,w:439,h:22},
{t:"across a row, usually by entering a simple key press, for",p:8,x:344,y:235,w:423,h:22},
{t:"example to copy down a column simply highlight the",p:8,x:344,y:255,w:411,h:22},
{t:"column and enter a key press such as Ctrl D.",p:8,x:344,y:275,w:344,h:22},
{t:"Charting",p:8,x:169,y:597,w:70,h:22},
{t:"You can turn numbers in a spreadsheet into a chart. This",p:8,x:344,y:597,w:433,h:22},
{t:"makes it easy to see what they mean at a glance.",p:8,x:344,y:617,w:372,h:22},
{t:"Automatic and",p:8,x:171,y:996,w:113,h:22},
{t:"Automatic calculation is usually the default setting on a",p:8,x:346,y:996,w:422,h:22},
{t:"manual calculation",p:8,x:171,y:1016,w:147,h:22},
{t:"spreadsheet. That means that your spreadsheet will carry",p:8,x:346,y:1016,w:436,h:22},
{t:"out its calculations just as soon as you have entered the",p:8,x:346,y:1036,w:419,h:22},
{t:"data and the formulae. You can switch off automatic",p:8,x:346,y:1056,w:398,h:22},
{t:"calculation. This means you have to intervene and",p:8,x:346,y:1076,w:388,h:22},
{t:"manually give the spreadsheet the instruction to perform",p:8,x:346,y:1096,w:433,h:22},
{t:"the calculation.",p:8,x:346,y:1116,w:117,h:22},
{t:"Cell protection",p:8,x:171,y:1149,w:115,h:22},
{t:"By switching on cell protection you make sure that the",p:8,x:346,y:1149,w:418,h:22},
{t:"data or formula in that cell is not changed by accident.",p:8,x:346,y:1169,w:417,h:22},
{t:"Before it can be changed, cell protection needs to be",p:8,x:346,y:1189,w:402,h:22},
{t:"switched off.",p:8,x:346,y:1209,w:94,h:22},
{t:"© Learning and Teaching Scotland ",p:8,x:338,y:1323,w:313,h:26},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:9,x:223,y:1291,w:277,h:15},
{t:"32",p:9,x:197,y:1291,w:12,h:15},
{t:"GENERAL PURPOSE P",p:9,x:225,y:112,w:162,h:15},
{t:"ACKAGES",p:9,x:403,y:112,w:73,h:15},
{t:"Feature",p:9,x:193,y:187,w:60,h:23},
{t:"What you need to know",p:9,x:368,y:187,w:195,h:23},
{t:"Relative referencing",p:9,x:193,y:221,w:151,h:22},
{t:"When a formula is replicated across a row using relative",p:9,x:368,y:221,w:429,h:22},
{t:"referencing the formula will change according to the cells it",p:9,x:368,y:241,w:453,h:22},
{t:"is copied into. For example the formula: sum(B6:B9) when",p:9,x:368,y:261,w:452,h:22},
{t:"replicated across a row into columns C and D will change",p:9,x:368,y:281,w:444,h:22},
{t:"to sum(C6:C9) and sum(D6:D9).",p:9,x:368,y:301,w:248,h:22},
{t:"Absolute referencing",p:9,x:193,y:341,w:158,h:22},
{t:"Using absolute referencing the formula remains the same",p:9,x:368,y:341,w:439,h:22},
{t:"no matter where in the spreadsheet you replicate it to.",p:9,x:368,y:361,w:414,h:22},
{t:"Most spreadsheets use $ to mark an absolute reference. For",p:9,x:368,y:381,w:452,h:22},
{t:"example: The formula: average($B$6:$B$9) will remain",p:9,x:368,y:401,w:430,h:22},
{t:"the same even if you replicated it to column C and",p:9,x:368,y:421,w:390,h:22},
{t:"column D.",p:9,x:368,y:441,w:83,h:22},
{t:"Formula using",p:9,x:193,y:481,w:112,h:22},
{t:"The structure of an if function is as follows.",p:9,x:368,y:481,w:331,h:22},
{t:"conditions",p:9,x:193,y:501,w:80,h:22},
{t:"if(condition, true, false).",p:9,x:368,y:521,w:181,h:22},
{t:"This means: ‘If the condition is met, the first action is carried",p:9,x:368,y:547,w:466,h:22},
{t:"out. If it is not met, the second action is carried out.",p:9,x:368,y:567,w:395,h:22},
{t:"’",p:9,x:751,y:567,w:4,h:22},
{t:"Let us take the example of an ‘If’ formula that is being",p:9,x:368,y:594,w:422,h:22},
{t:"used to calculate a bonus for a salesman. The cell",p:9,x:368,y:614,w:380,h:22},
{t:"containing the bonus has this formula entered.",p:9,x:368,y:634,w:355,h:22},
{t:"if(D20>gt;=50, 100, ‘no bonus’)",p:9,x:368,y:661,w:229,h:22},
{t:"If cell D20 has a value greater than or equal to 50, then the",p:9,x:368,y:687,w:452,h:22},
{t:"cell containing the formula is given the value 100.",p:9,x:368,y:707,w:380,h:22},
{t:"If the value is less than 50, ‘no bonus’ is entered into the cell.",p:9,x:368,y:734,w:466,h:22},
{t:"Let us look at a spreadsheet and check out some of these",p:9,x:368,y:761,w:437,h:22},
{t:"features we have just been looking at.",p:9,x:368,y:781,w:289,h:22},
{t:"This formula uses both:",p:9,x:590,y:1112,w:156,h:19},
{t:"•",p:9,x:590,y:1129,w:9,h:19},
{t:"absolute referencing",p:9,x:604,y:1129,w:133,h:19},
{t:" to refer to",p:9,x:743,y:1129,w:63,h:19},
{t:"cell B18 that holds the V",p:9,x:604,y:1146,w:153,h:19},
{t:"AT rate",p:9,x:767,y:1146,w:48,h:19},
{t:"•",p:9,x:590,y:1162,w:9,h:19},
{t:"relative referencing",p:9,x:604,y:1162,w:125,h:19},
{t:" to refer to",p:9,x:735,y:1162,w:63,h:19},
{t:"the costs held in cells C6, C7,",p:9,x:604,y:1179,w:182,h:19},
{t:"C8, C9 and C10.",p:9,x:604,y:1196,w:107,h:19},
{t:"This cell has cell protection",p:9,x:192,y:1152,w:173,h:19},
{t:"activated to protect the",p:9,x:192,y:1169,w:143,h:19},
{t:"important data it holds on",p:9,x:192,y:1186,w:166,h:19},
{t:"the VAT rate.",p:9,x:192,y:1202,w:84,h:19},
{t:"© Learning and Teaching Scotland ",p:9,x:338,y:1323,w:313,h:26},
{t:"33",p:10,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:10,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:10,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:10,x:692,y:112,w:73,h:15},
{t:"Fully labelled charting",p:10,x:169,y:184,w:183,h:23},
{t:"Here are the highlighted grades",p:10,x:169,y:208,w:243,h:22},
{t:"Charts can have series of labels each giving its own piece of information",p:10,x:169,y:232,w:551,h:22},
{t:"about the chart. If you develop a series of charts for example for all the class",p:10,x:169,y:256,w:581,h:22},
{t:"results in fourth year then:",p:10,x:169,y:280,w:200,h:22},
{t:"•",p:10,x:169,y:311,w:11,h:22},
{t:"you can have a label to identify the series",p:10,x:212,y:311,w:315,h:22},
{t:"•",p:10,x:169,y:335,w:11,h:22},
{t:"you can insert a label for each individual chart",p:10,x:212,y:335,w:354,h:22},
{t:"•",p:10,x:169,y:359,w:11,h:22},
{t:"you can have a title for each chart",p:10,x:212,y:359,w:258,h:22},
{t:"•",p:10,x:169,y:383,w:11,h:22},
{t:"both X and Y axis can have labels",p:10,x:212,y:383,w:258,h:22},
{t:"•",p:10,x:169,y:407,w:11,h:22},
{t:"you can even label points on the chart.",p:10,x:212,y:407,w:296,h:22},
{t:"This window lets you set up labels showing values and percentages.",p:10,x:169,y:455,w:520,h:22},
{t:"Exercise 14",p:10,x:188,y:922,w:145,h:29},
{t:"1.",p:10,x:188,y:954,w:13,h:22},
{t:"List the labels a fully labelled chart should have.",p:10,x:212,y:954,w:370,h:22},
{t:"2.",p:10,x:188,y:978,w:13,h:22},
{t:"Your teacher will supply you with a spreadsheet file. Open it up and",p:10,x:212,y:978,w:520,h:22},
{t:"chart the data, labelling it as fully as your package will allow",p:10,x:212,y:1002,w:463,h:22},
{t:".",p:10,x:697,y:1002,w:4,h:22},
{t:"3.",p:10,x:188,y:1026,w:13,h:22},
{t:"If your application has a ‘Label Wizard’, use that to help you.",p:10,x:212,y:1026,w:474,h:22},
{t:"© Learning and Teaching Scotland ",p:10,x:338,y:1323,w:313,h:26},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:11,x:223,y:1291,w:277,h:15},
{t:"34",p:11,x:197,y:1291,w:12,h:15},
{t:"GENERAL PURPOSE P",p:11,x:225,y:112,w:162,h:15},
{t:"ACKAGES",p:11,x:403,y:112,w:73,h:15},
{t:"Exercise 15: Spreadsheet practical exercise",p:11,x:212,y:184,w:553,h:29},
{t:"Create a spreadsheet to hold the results of class 4A.",p:11,x:212,y:217,w:391,h:22},
{t:"1.",p:11,x:223,y:265,w:13,h:22},
{t:"In cell B13 enter the word ‘T",p:11,x:245,y:265,w:225,h:22},
{t:"otal’.",p:11,x:479,y:265,w:37,h:22},
{t:"2.",p:11,x:223,y:289,w:13,h:22},
{t:"In cell C13 enter the formula to",p:11,x:245,y:289,w:243,h:22},
{t:"calculate the total number of passes.",p:11,x:245,y:313,w:276,h:22},
{t:"3.",p:11,x:223,y:337,w:13,h:22},
{t:"In cell C15, enter the formula to",p:11,x:245,y:337,w:247,h:22},
{t:"calculate the percentage of grade",p:11,x:245,y:361,w:250,h:22},
{t:"1s. (Your teacher will help you",p:11,x:245,y:385,w:235,h:22},
{t:"with this.)",p:11,x:245,y:409,w:78,h:22},
{t:"4.",p:11,x:223,y:433,w:13,h:22},
{t:"Do the same for cell C16 to calculate",p:11,x:245,y:433,w:283,h:22},
{t:"the percentage of grade 3s.",p:11,x:245,y:457,w:204,h:22},
{t:"5.",p:11,x:223,y:481,w:13,h:22},
{t:"Change the attributes of the cells",p:11,x:245,y:481,w:250,h:22},
{t:"C15 and C16 so that they hold",p:11,x:245,y:505,w:234,h:22},
{t:"numbers up to two decimal places.",p:11,x:245,y:529,w:269,h:22},
{t:"6.",p:11,x:223,y:553,w:13,h:22},
{t:"Insert a row to hold the",p:11,x:245,y:553,w:180,h:22},
{t:"percentage of grade 2s.",p:11,x:245,y:577,w:175,h:22},
{t:"7.",p:11,x:223,y:601,w:13,h:22},
{t:"Use the charting features to chart",p:11,x:245,y:601,w:252,h:22},
{t:"the number of passes in each",p:11,x:245,y:625,w:222,h:22},
{t:"grade 1–7.",p:11,x:245,y:649,w:80,h:22},
{t:"8.",p:11,x:223,y:673,w:13,h:22},
{t:"Ask your teacher to check your",p:11,x:245,y:673,w:237,h:22},
{t:"formulae and your chart. Y our teacher may ask you to print out your",p:11,x:245,y:697,w:535,h:22},
{t:"spreadsheet and chart.",p:11,x:245,y:721,w:170,h:22},
{t:"9.",p:11,x:223,y:745,w:13,h:22},
{t:"Label rows to hold the percentage of grades 4, 5, 6 and 7 and use a",p:11,x:245,y:745,w:513,h:22},
{t:"combination of relative and absolute reference to replicate the",p:11,x:245,y:769,w:476,h:22},
{t:"formula down column C.",p:11,x:245,y:793,w:198,h:22},
{t:"10.",p:11,x:212,y:817,w:23,h:22},
{t:"Fully label your chart.",p:11,x:245,y:817,w:169,h:22},
{t:"11.",p:11,x:212,y:841,w:23,h:22},
{t:"Ask your teacher to check your formulae and your fully labelled chart.",p:11,x:245,y:841,w:539,h:22},
{t:"© Learning and Teaching Scotland ",p:11,x:338,y:1323,w:313,h:26},
{t:"35",p:12,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:12,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:12,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:12,x:692,y:112,w:73,h:15},
{t:"What do you need to know",p:12,x:164,y:177,w:399,h:35},
{t:"about Databases?",p:12,x:164,y:217,w:272,h:35},
{t:"A database is a collection of related information made up of ",p:12,x:164,y:257,w:464,h:22},
{t:"Records that in",p:12,x:652,y:257,w:120,h:23},
{t:"turn are made up of Fields.",p:12,x:164,y:281,w:222,h:23},
{t:"A File is a collection of ",p:12,x:164,y:676,w:179,h:23},
{t:"Records such as a file of names, addresses and phone numbers.",p:12,x:336,y:676,w:484,h:23},
{t:"Records hold the data on one person or object in the file. F",p:12,x:164,y:724,w:460,h:23},
{t:"or example you",p:12,x:644,y:724,w:119,h:22},
{t:"could have a record for each pupil in a school.",p:12,x:164,y:748,w:355,h:22},
{t:"A Field stores one piece of data such as the name field, the address field, the",p:12,x:164,y:796,w:590,h:23},
{t:"phone number field.",p:12,x:164,y:820,w:159,h:22},
{t:"File",p:12,x:471,y:351,w:31,h:23},
{t:"Field 1",p:12,x:183,y:506,w:53,h:22},
{t:"Field 2",p:12,x:182,y:564,w:53,h:22},
{t:"Field 3",p:12,x:182,y:619,w:53,h:22},
{t:"Record 1",p:12,x:196,y:450,w:68,h:23},
{t:"Record 2",p:12,x:363,y:450,w:68,h:23},
{t:"Record 3",p:12,x:535,y:450,w:68,h:23},
{t:"Record 4",p:12,x:700,y:450,w:68,h:23},
{t:"© Learning and Teaching Scotland ",p:12,x:338,y:1323,w:313,h:26},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:13,x:223,y:1291,w:277,h:15},
{t:"36",p:13,x:197,y:1291,w:12,h:15},
{t:"GENERAL PURPOSE P",p:13,x:225,y:112,w:162,h:15},
{t:"ACKAGES",p:13,x:403,y:112,w:73,h:15},
{t:"Features",p:13,x:193,y:186,w:67,h:23},
{t:"What you need to know",p:13,x:353,y:186,w:195,h:23},
{t:"Add/create records",p:13,x:193,y:219,w:143,h:22},
{t:"When you set up a database you create new records and fill",p:13,x:353,y:219,w:457,h:22},
{t:"the data into the fields. If you need to, you can always add",p:13,x:353,y:239,w:448,h:22},
{t:"another record.",p:13,x:353,y:259,w:117,h:22},
{t:"Edit records",p:13,x:193,y:299,w:92,h:22},
{t:"Once you have created your records you can go back and",p:13,x:354,y:299,w:440,h:22},
{t:"change the data held there.",p:13,x:353,y:319,w:207,h:22},
{t:"Create fields",p:13,x:193,y:359,w:96,h:22},
{t:"When the database is",p:13,x:353,y:359,w:164,h:22},
{t:"being set up you can",p:13,x:353,y:379,w:157,h:22},
{t:"create different types of",p:13,x:353,y:399,w:177,h:22},
{t:"fields to match the",p:13,x:353,y:419,w:141,h:22},
{t:"different types of data",p:13,x:353,y:439,w:165,h:22},
{t:"you are going to store",p:13,x:353,y:459,w:166,h:22},
{t:"in the database.",p:13,x:353,y:479,w:120,h:22},
{t:"You can create the",p:13,x:353,y:519,w:139,h:22},
{t:"following types of field:",p:13,x:353,y:539,w:180,h:22},
{t:"•",p:13,x:353,y:559,w:11,h:22},
{t:"Numeric",p:13,x:377,y:559,w:70,h:22},
{t:"•",p:13,x:353,y:579,w:11,h:22},
{t:"Text",p:13,x:377,y:579,w:33,h:22},
{t:"•",p:13,x:353,y:599,w:11,h:22},
{t:"Graphic",p:13,x:377,y:599,w:63,h:22},
{t:"•",p:13,x:353,y:619,w:11,h:22},
{t:"Date",p:13,x:377,y:619,w:37,h:22},
{t:"•",p:13,x:353,y:639,w:11,h:22},
{t:"Time.",p:13,x:377,y:639,w:46,h:22},
{t:"Search on one field",p:13,x:193,y:679,w:148,h:22},
{t:"This is a simple search, for example search on the name",p:13,x:353,y:679,w:432,h:22},
{t:"field for ‘MacIntosh’. Note: some packages use the term",p:13,x:353,y:699,w:432,h:22},
{t:"‘Query’ or ‘Find’ for a search.",p:13,x:353,y:719,w:230,h:22},
{t:"Sort on one field",p:13,x:193,y:759,w:129,h:22},
{t:"This puts the",p:13,x:353,y:759,w:100,h:22},
{t:"records into",p:13,x:353,y:779,w:90,h:22},
{t:"order using",p:13,x:353,y:799,w:86,h:22},
{t:"the contents",p:13,x:353,y:819,w:92,h:22},
{t:"of one field,",p:13,x:353,y:839,w:92,h:22},
{t:"for example",p:13,x:353,y:859,w:92,h:22},
{t:"sort into",p:13,x:353,y:879,w:62,h:22},
{t:"order using",p:13,x:353,y:899,w:86,h:22},
{t:"the date field.",p:13,x:353,y:919,w:105,h:22},
{t:"Alter a",p:13,x:193,y:1115,w:51,h:22},
{t:"You can alter the format of a record in several ways:",p:13,x:353,y:1115,w:397,h:22},
{t:"record format",p:13,x:193,y:1135,w:105,h:22},
{t:"change a field type so that it can hold different type of data,",p:13,x:354,y:1135,w:454,h:22},
{t:"delete a field altogether.",p:13,x:353,y:1155,w:184,h:22},
{t:"© Learning and Teaching Scotland ",p:13,x:338,y:1323,w:313,h:26},
{t:"37",p:14,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:14,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:14,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:14,x:692,y:112,w:73,h:15},
{t:"Features",p:14,x:172,y:186,w:67,h:23},
{t:"What you need to know",p:14,x:332,y:186,w:195,h:23},
{t:"Alter input format",p:14,x:172,y:219,w:138,h:22},
{t:"Change the input screen. The two most common input",p:14,x:332,y:219,w:425,h:22},
{t:"screens are column/table and card layouts.",p:14,x:332,y:239,w:325,h:22},
{t:"Column",p:14,x:417,y:273,w:65,h:22},
{t:"Card",p:14,x:654,y:273,w:38,h:22},
{t:"Alter output format",p:14,x:169,y:526,w:148,h:22},
{t:"You can change the way data is output by changing the",p:14,x:330,y:526,w:419,h:22},
{t:"layout from column to a card layout. You can even decide",p:14,x:330,y:546,w:443,h:22},
{t:"which fields are output and where on the screen they appear,",p:14,x:330,y:566,w:466,h:22},
{t:"what colour they have, etc.",p:14,x:330,y:586,w:206,h:22},
{t:"Simple searches on",p:14,x:169,y:613,w:150,h:22},
{t:"Finding information on the internet or a CD",p:14,x:330,y:613,w:341,h:22},
{t:"-ROM is",p:14,x:681,y:613,w:67,h:22},
{t:"a CD-ROM or",p:14,x:169,y:633,w:117,h:22},
{t:"straightforward. All you have to do is to enter your search",p:14,x:330,y:633,w:443,h:22},
{t:"the internet",p:14,x:169,y:653,w:89,h:22},
{t:"and press ‘Return’ or click ‘Go’. The search engine does",p:14,x:331,y:653,w:431,h:22},
{t:"the rest.",p:14,x:330,y:673,w:59,h:22},
{t:"Search on more",p:14,x:169,y:699,w:122,h:22},
{t:"Sometimes searching on one field gives you too many",p:14,x:330,y:699,w:415,h:22},
{t:"than one field",p:14,x:169,y:719,w:106,h:22},
{t:"results. Searching on the name field for ‘McKenzie’ might",p:14,x:330,y:719,w:445,h:22},
{t:"produce a dozen records. To narrow down the number of",p:14,x:330,y:739,w:444,h:22},
{t:"results you can search on more than one field, for example",p:14,x:330,y:759,w:451,h:22},
{t:"searching on the Name field for ‘McKenzie’, the Address",p:14,x:330,y:779,w:439,h:22},
{t:"field for ‘Dowanhill Rd’ and the Date field for ‘12/11/2003’.",p:14,x:330,y:799,w:457,h:22},
{t:"Sort on more than",p:14,x:169,y:839,w:141,h:22},
{t:"You can use more than one field to sort your records into",p:14,x:330,y:839,w:435,h:22},
{t:"one field",p:14,x:169,y:859,w:67,h:22},
{t:"order. Sorting on the name field and the address field means",p:14,x:330,y:859,w:464,h:22},
{t:"that if two people have the same name then they will be",p:14,x:330,y:879,w:433,h:22},
{t:"sorted into order according to their address. So McKenzie in",p:14,x:330,y:899,w:463,h:22},
{t:"Dowanhill St. will be placed before McKenzie in Hillhead St.",p:14,x:330,y:919,w:478,h:22},
{t:"© Learning and Teaching Scotland ",p:14,x:338,y:1323,w:313,h:26},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:15,x:223,y:1291,w:277,h:15},
{t:"38",p:15,x:197,y:1291,w:12,h:15},
{t:"GENERAL PURPOSE P",p:15,x:225,y:112,w:162,h:15},
{t:"ACKAGES",p:15,x:403,y:112,w:73,h:15},
{t:"Features",p:15,x:193,y:184,w:67,h:23},
{t:"What you need to know",p:15,x:353,y:184,w:195,h:23},
{t:"Computed field",p:15,x:193,y:217,w:122,h:22},
{t:"You use computed fields to store a formula that carries out",p:15,x:353,y:217,w:446,h:22},
{t:"calculations on data held in your database file.",p:15,x:353,y:237,w:355,h:22},
{t:"Keyword",p:15,x:193,y:264,w:70,h:22},
{t:"Keywords are used to identify records in a file. Each record",p:15,x:353,y:264,w:454,h:22},
{t:"is given a unique keyword, stored in a key field. This makes",p:15,x:353,y:284,w:466,h:22},
{t:"searching for records much simpler. If you know the",p:15,x:353,y:304,w:400,h:22},
{t:"keyword, such as an account number, it saves you carrying",p:15,x:353,y:324,w:449,h:22},
{t:"out complex searches on several fields. A search using the",p:15,x:353,y:344,w:440,h:22},
{t:"keyword will take you straight to the record you want.",p:15,x:353,y:364,w:417,h:22},
{t:"Simple search on",p:15,x:193,y:391,w:132,h:22},
{t:"A simple search is a simple straightfor",p:15,x:353,y:391,w:289,h:22},
{t:"ward search",p:15,x:651,y:391,w:91,h:22},
{t:"a CD-ROM or",p:15,x:193,y:411,w:117,h:22},
{t:"for an item that is easily found.",p:15,x:353,y:411,w:243,h:22},
{t:"the internet",p:15,x:193,y:431,w:88,h:22},
{t:"As an",p:15,x:353,y:451,w:42,h:22},
{t:"example you",p:15,x:353,y:471,w:100,h:22},
{t:"could search",p:15,x:353,y:491,w:95,h:22},
{t:"for ‘ Australia’",p:15,x:353,y:511,w:101,h:22},
{t:"on a CD-",p:15,x:353,y:531,w:75,h:22},
{t:"ROM or the",p:15,x:353,y:551,w:93,h:22},
{t:"internet. The",p:15,x:353,y:571,w:101,h:22},
{t:"problem",p:15,x:353,y:591,w:64,h:22},
{t:"would be",p:15,x:353,y:611,w:72,h:22},
{t:"that you",p:15,x:353,y:631,w:62,h:22},
{t:"would find",p:15,x:353,y:651,w:83,h:22},
{t:"lots of",p:15,x:353,y:671,w:46,h:22},
{t:"entries. In",p:15,x:353,y:691,w:76,h:22},
{t:"fact a search",p:15,x:353,y:711,w:92,h:22},
{t:"for Australia on the internet will return hundreds of",p:15,x:353,y:731,w:393,h:22},
{t:"thousands of results; too many to look through. So, what",p:15,x:353,y:751,w:436,h:22},
{t:"you really need to do is carry out a complex search.",p:15,x:353,y:771,w:396,h:22},
{t:"Complex search on",p:15,x:193,y:813,w:150,h:22},
{t:"Complex searches are searches where there are two or more",p:15,x:353,y:813,w:463,h:22},
{t:"a CD-ROM or",p:15,x:193,y:837,w:115,h:22},
{t:"conditions in the search, for example a search for all cities",p:15,x:353,y:837,w:442,h:22},
{t:"the internet",p:15,x:193,y:861,w:88,h:22},
{t:"in Australia with a",p:15,x:666,y:861,w:139,h:22},
{t:"population >gt;",p:15,x:665,y:885,w:105,h:22},
{t:"1,000,000. CD-",p:15,x:665,y:909,w:117,h:22},
{t:"ROMs help you put",p:15,x:665,y:933,w:152,h:22},
{t:"together complex",p:15,x:665,y:957,w:133,h:22},
{t:"searches with",p:15,x:665,y:981,w:102,h:22},
{t:"several parts or",p:15,x:665,y:1005,w:115,h:22},
{t:"conditions in your",p:15,x:665,y:1029,w:139,h:22},
{t:"search. Because the",p:15,x:665,y:1053,w:148,h:22},
{t:"search has several",p:15,x:665,y:1077,w:135,h:22},
{t:"conditions, it will",p:15,x:665,y:1101,w:132,h:22},
{t:"return fewer results.",p:15,x:665,y:1125,w:151,h:22},
{t:"© Learning and Teaching Scotland ",p:15,x:338,y:1323,w:313,h:26},
{t:"39",p:16,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:16,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:16,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:16,x:692,y:112,w:73,h:15},
{t:"Exercise 16",p:16,x:188,y:187,w:145,h:29},
{t:"1.",p:16,x:188,y:220,w:13,h:22},
{t:"What is the main reason for using complex searches?",p:16,x:212,y:220,w:406,h:22},
{t:"2.",p:16,x:188,y:244,w:13,h:22},
{t:"Why should you include as many conditions as you can in your search?",p:16,x:212,y:244,w:547,h:22},
{t:"3.",p:16,x:188,y:268,w:13,h:22},
{t:"Write out the combination of conditions you would use to find out",p:16,x:212,y:268,w:509,h:22},
{t:"about Scottish islands in the Inner Hebrides except Mull or Coll. Carr",p:16,x:212,y:292,w:537,h:22},
{t:"y",p:16,x:777,y:292,w:8,h:22},
{t:"out the search either using a CD",p:16,x:212,y:316,w:249,h:22},
{t:"-ROM or on the internet.",p:16,x:474,y:316,w:193,h:22},
{t:"Exercise 17: Database practical exercise",p:16,x:188,y:364,w:512,h:29},
{t:"Create a database to hold the details about five patients in a dentist’s surgery.",p:16,x:188,y:394,w:587,h:22},
{t:"Each record in the file should contain the following fields: ‘Surname’,",p:16,x:188,y:414,w:534,h:22},
{t:"‘Firstname’, ‘ Address’, ‘Date of birth’, ‘Extractions’, ‘Fillings’, ‘Crowns fitted’.",p:16,x:188,y:434,w:592,h:22},
{t:"Here is an example of the first two records.",p:16,x:188,y:474,w:332,h:22},
{t:"Carry out the following tasks.",p:16,x:188,y:514,w:228,h:22},
{t:"1.",p:16,x:190,y:949,w:13,h:22},
{t:"Add another three records for the following new patients: ‘Jean McKenzie’,",p:16,x:214,y:949,w:576,h:22},
{t:"‘",p:16,x:214,y:973,w:4,h:22},
{t:"Alec Wallace’, ‘Margaret McFarrell’. Y ou can make up your own data for",p:16,x:216,y:973,w:560,h:22},
{t:"the rest of the fields.",p:16,x:214,y:997,w:154,h:22},
{t:"2.",p:16,x:190,y:1021,w:13,h:22},
{t:"Sort the file on the Surname field.",p:16,x:214,y:1021,w:261,h:22},
{t:"3.",p:16,x:190,y:1045,w:13,h:22},
{t:"Add a field to hold data on the number of checkups.",p:16,x:214,y:1045,w:403,h:22},
{t:"4.",p:16,x:190,y:1069,w:13,h:22},
{t:"Sort the file on the Surname and the Firstname fields.",p:16,x:214,y:1069,w:411,h:22},
{t:"5.",p:16,x:190,y:1093,w:13,h:22},
{t:"Search for the record for ‘Eric McKenzie’ in ‘Ullapool Rd’.",p:16,x:214,y:1093,w:453,h:22},
{t:"6.",p:16,x:190,y:1117,w:13,h:22},
{t:"(a) Add a new field to contain a patient number. (b) Enter the following",p:16,x:214,y:1117,w:552,h:22},
{t:"patient numbers: 6701, 6702, 6703, 6704, 6705.",p:16,x:214,y:1141,w:355,h:22},
{t:"7.",p:16,x:190,y:1165,w:13,h:22},
{t:"If your database software has the facility to do so, alter the database by",p:16,x:214,y:1165,w:540,h:22},
{t:"adding a computed field to hold the total number of fillings and extractions",p:16,x:214,y:1189,w:577,h:22},
{t:"each patient has had.",p:16,x:214,y:1213,w:161,h:22},
{t:"© Learning and Teaching Scotland ",p:16,x:338,y:1323,w:313,h:26},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:17,x:223,y:1291,w:277,h:15},
{t:"40",p:17,x:197,y:1291,w:12,h:15},
{t:"GENERAL PURPOSE P",p:17,x:225,y:112,w:162,h:15},
{t:"ACKAGES",p:17,x:403,y:112,w:73,h:15},
{t:"Desktop Publishing",p:17,x:188,y:177,w:297,h:35},
{t:"A desktop publishing (DTP) package is a package designed to set up",p:17,x:188,y:217,w:528,h:22},
{t:"professional looking pages that contain text and graphics. DTP packages are",p:17,x:188,y:241,w:585,h:22},
{t:"used to set up pages for magazines, books, leaflets, newsletters. They have",p:17,x:188,y:265,w:572,h:22},
{t:"features that help the user control the position of the text and graphics, such as:",p:17,x:188,y:289,w:602,h:22},
{t:"•",p:17,x:188,y:313,w:11,h:22},
{t:"onscreen rulers",p:17,x:235,y:313,w:119,h:22},
{t:"•",p:17,x:188,y:337,w:11,h:22},
{t:"frames",p:17,x:235,y:337,w:51,h:22},
{t:"•",p:17,x:188,y:361,w:11,h:22},
{t:"text boxes.",p:17,x:235,y:361,w:81,h:22},
{t:"Wizard",p:17,x:188,y:419,w:85,h:29},
{t:"Using a wizard",p:17,x:188,y:451,w:116,h:22},
{t:"is a great way to",p:17,x:188,y:475,w:123,h:22},
{t:"start producing a",p:17,x:188,y:499,w:128,h:22},
{t:"DTP document.",p:17,x:188,y:523,w:127,h:22},
{t:"A wizard will",p:17,x:188,y:547,w:104,h:22},
{t:"often offer the",p:17,x:188,y:571,w:107,h:22},
{t:"user a choice of",p:17,x:188,y:595,w:119,h:22},
{t:"templates that",p:17,x:188,y:619,w:108,h:22},
{t:"have the",p:17,x:188,y:643,w:64,h:22},
{t:"structure, style",p:17,x:188,y:667,w:112,h:22},
{t:"and even colour",p:17,x:188,y:691,w:123,h:22},
{t:"of the page",p:17,x:188,y:715,w:84,h:22},
{t:"already in place.",p:17,x:188,y:739,w:126,h:22},
{t:"It will then step",p:17,x:689,y:835,w:118,h:22},
{t:"the user through",p:17,x:689,y:859,w:126,h:22},
{t:"the process of",p:17,x:689,y:883,w:103,h:22},
{t:"completing the",p:17,x:689,y:907,w:114,h:22},
{t:"page by entering",p:17,x:689,y:931,w:128,h:22},
{t:"the text or",p:17,x:689,y:955,w:77,h:22},
{t:"inserting",p:17,x:689,y:979,w:68,h:22},
{t:"graphics from a",p:17,x:689,y:1003,w:118,h:22},
{t:"clip art file.",p:17,x:689,y:1027,w:86,h:22},
{t:"© Learning and Teaching Scotland ",p:17,x:338,y:1323,w:313,h:26},
{t:"41",p:18,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:18,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:18,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:18,x:692,y:112,w:73,h:15},
{t:"Importing and scaling graphics",p:18,x:164,y:182,w:399,h:29},
{t:"You can scan in graphics, download them from the internet or transfer them from",p:18,x:164,y:215,w:623,h:22},
{t:"your digital camera. They can then be stored in folders on your hard disk or on",p:18,x:164,y:239,w:609,h:22},
{t:"a CD. You can then import the graphics easily into your document and scale",p:18,x:164,y:263,w:587,h:22},
{t:"them to any size you want. F or a definition of scaling graphics see page 25.",p:18,x:164,y:287,w:579,h:22},
{t:"This file is being imported",p:18,x:493,y:684,w:166,h:19},
{t:"simply by selecting itt",p:18,x:493,y:701,w:136,h:19},
{t:"andthen choosing insert.",p:18,x:493,y:718,w:156,h:19},
{t:"This example shows how easy",p:18,x:512,y:970,w:189,h:19},
{t:"it is to scale a graphic by",p:18,x:512,y:986,w:151,h:19},
{t:"adjusting the height and",p:18,x:512,y:1003,w:154,h:19},
{t:"width percentage.",p:18,x:512,y:1020,w:113,h:19},
{t:"© Learning and Teaching Scotland ",p:18,x:338,y:1323,w:313,h:26},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:19,x:223,y:1291,w:277,h:15},
{t:"42",p:19,x:197,y:1291,w:12,h:15},
{t:"GENERAL PURPOSE P",p:19,x:225,y:112,w:162,h:15},
{t:"ACKAGES",p:19,x:403,y:112,w:73,h:15},
{t:"Importing text",p:19,x:193,y:182,w:178,h:29},
{t:"Setting up a text box is easily done. Y",p:19,x:193,y:215,w:285,h:22},
{t:"ou can use the r ulers at the side of the",p:19,x:491,y:215,w:298,h:22},
{t:"page to enable you to position the text box exactly where you want it then",p:19,x:193,y:239,w:568,h:22},
{t:"import the text using the menus and the pointer",p:19,x:193,y:263,w:367,h:22},
{t:".",p:19,x:577,y:263,w:4,h:22},
{t:"Once you have all the objects on your page you can change the page layout",p:19,x:193,y:709,w:579,h:22},
{t:"by changing the position of the objects on the page, or by altering the",p:19,x:193,y:733,w:530,h:22},
{t:"structure of the page layout itself",p:19,x:193,y:757,w:249,h:22},
{t:".",p:19,x:455,y:757,w:4,h:22},
{t:"These graphics give a good example of how the layout of a page can be",p:19,x:193,y:805,w:551,h:22},
{t:"altered and the position of objects changed.",p:19,x:193,y:829,w:333,h:22},
{t:"© Learning and Teaching Scotland ",p:19,x:338,y:1323,w:313,h:26},
{t:"43",p:20,x:783,y:1291,w:12,h:15},
{t:"STANDARD GR ADE COMP UTING STUDIES",p:20,x:483,y:1291,w:277,h:15},
{t:"GENERAL PURPOSE P",p:20,x:514,y:112,w:162,h:15},
{t:"ACKAGES",p:20,x:692,y:112,w:73,h:15},
{t:"Wrapping text around your graphics",p:20,x:169,y:187,w:456,h:29},
{t:"This is a useful feature. It enables you to wrap your text around a graphic.",p:20,x:169,y:220,w:567,h:22},
{t:"This is a ver y effective way of relating the text to the graphic and describing",p:20,x:169,y:244,w:583,h:22},
{t:"what is going on in the",p:20,x:169,y:268,w:175,h:22},
{t:"graphic. Here we can see",p:20,x:169,y:292,w:193,h:22},
{t:"several different ways you can",p:20,x:169,y:316,w:228,h:22},
{t:"wrap text around a graphic.",p:20,x:169,y:340,w:211,h:22},
{t:"Exercise 18",p:20,x:188,y:431,w:145,h:29},
{t:"1.",p:20,x:188,y:464,w:13,h:22},
{t:"Using a desktop publishing package choose a template for a document.",p:20,x:212,y:464,w:548,h:22},
{t:"2.",p:20,x:188,y:488,w:13,h:22},
{t:"Use this template to produce a document and, using your jotter or your",p:20,x:212,y:488,w:548,h:22},
{t:"word processor , write down how the template helps you.",p:20,x:212,y:512,w:443,h:22},
{t:"3.",p:20,x:188,y:536,w:13,h:22},
{t:"Import some graphics into your document. What does ‘importing a",p:20,x:212,y:536,w:518,h:22},
{t:"graphic’ mean?",p:20,x:212,y:560,w:118,h:22},
{t:"4.",p:20,x:188,y:584,w:13,h:22},
{t:"Change the dimensions of your graphics by scaling them.",p:20,x:212,y:584,w:439,h:22},
{t:"5.",p:20,x:188,y:608,w:13,h:22},
{t:"Crop some of your graphics and explain how this improves the document.",p:20,x:212,y:608,w:572,h:22},
{t:"6.",p:20,x:188,y:632,w:13,h:22},
{t:"Use the text wrap feature to wrap text around your graphics.",p:20,x:212,y:632,w:462,h:22},
{t:"7.",p:20,x:188,y:656,w:13,h:22},
{t:"Use your online help to find out about the features of your desktop",p:20,x:212,y:656,w:515,h:22},
{t:"publishing package that can help you:",p:20,x:212,y:680,w:291,h:22},
{t:"(a) position your text and graphics with precision",p:20,x:212,y:704,w:376,h:22},
{t:"(b) alter the layout. Use your online help.",p:20,x:212,y:728,w:321,h:22},
{t:"8.",p:20,x:188,y:752,w:13,h:22},
{t:"Use these features to alter your document.",p:20,x:212,y:752,w:324,h:22},
{t:"© Learning and Teaching Scotland ",p:20,x:338,y:1323,w:313,h:26},
0];
var g_links=[
0];