{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Word Introduction TNA"],"not_rendered":{"charts":1,"external_links":2,"defined_names":30},"read":"whole","date_system":"1900"}

{"sheet":"Word Introduction TNA","index":0,"n_rows":76,"n_cols":5,"rows_kept":76,"merged":[[0,0,0,4],[1,0,1,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[10,1,11,4],[12,1,12,4],[15,1,15,2],[18,1,18,2],[23,1,23,2],[32,1,32,2],[38,1,38,2],[45,1,45,2],[49,1,49,2],[53,1,53,2],[68,1,70,4]]}
["ATI-Mirage Training Solutions"]
["Word Introduction - Training Needs Analysis (TNA)"]
[]
["Name:"]
["Organisation Name:"]
["Department:"]
["Telephone:"]
["Mobile :"]
["Email:"]
[]
[null,"Please choose one response that most accurately describes your knowledge level for each topic. This is not a test, therefore your responses will address your training needs for the level that you are at."]
[]
[null,"Use the Blue Coloured cells if you know all of a Section, otherwise click the yellow cell to select an option"]
[]
[null,"Section","Question","ALL","Response"]
[{"$f":"IF(ISBLANK(B16),\"\",\"A\")","v":"A"},"Working with Microsoft Word"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Familiarity with word processing concepts",null,{"$f":"IF($D$16=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Using Toolbars, Menus / Tabs,  Scrollbars and the Status Bar",null,{"$f":"IF($D$16=\"All\",$B$66,$B$67)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B19),\"\",\"B\")","v":"B"},"Create and Work with Documents"]
[null,{"$f":"IF(ISBLANK(C20),\"\",B18+1)","v":3},"Create a new Document and type in text",null,{"$f":"IF($D$19=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C21),\"\",B20+1)","v":4},"Save a Document and name it",null,{"$f":"IF($D$19=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C22),\"\",B21+1)","v":5},"Use the Spell Checker and Language checker",null,{"$f":"IF($D$19=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C23),\"\",B22+1)","v":6},"Open and Close a Word document (file)",null,{"$f":"IF($D$19=\"All\",$B$66,$B$67)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B24),\"\",\"C\")","v":"C"},"Document Editing"]
[null,{"$f":"IF(ISBLANK(C25),\"\",B23+1)","v":7},"Moving within the text of the document",null,{"$f":"IF($D$24=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C26),\"\",B25+1)","v":8},"Select text with the mouse",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C27),\"\",B26+1)","v":9},"Select text with the keyboard",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C28),\"\",B27+1)","v":10},"Use copy and paste",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C29),\"\",B28+1)","v":11},"Use cut and paste",null,"click to select value"]
[null,12,"Text editing and delete text",null,"click to select value"]
[null,13,"Use the undo and redo commands",null,"click to select value"]
[null,14,"Copying text from one document to another",null,"click to select value"]
[{"$f":"IF(ISBLANK(B33),\"\",\"D\")","v":"D"},"Character Formatting"]
[null,{"$f":"IF(ISBLANK(C34),\"\",B32+1)","v":15},"Change font name and font size",null,{"$f":"IF($D$33=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C35),\"\",B34+1)","v":16},"Use bold, italic and underlining",null,{"$f":"IF($D$33=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C36),\"\",B35+1)","v":17},"Use the font dialog box to change font characteristics",null,{"$f":"IF($D$33=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C37),\"\",B36+1)","v":18},"Use formatting features on toolbars or home Tab",null,{"$f":"IF($D$33=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C38),\"\",B37+1)","v":19},"Use the format painter to copy formatting",null,{"$f":"IF($D$33=\"All\",$B$66,$B$67)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B39),\"\",\"E\")","v":"E"},"Paragraph Formatting"]
[null,{"$f":"IF(ISBLANK(C40),\"\",B38+1)","v":20},"Change paragraph alignment",null,{"$f":"IF($D$39=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C41),\"\",B40+1)","v":21},"Use paragraph spacing",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C42),\"\",B41+1)","v":22},"Adjust spacing of line within a paragraph",null,"click to select value"]
[null,23,"Use basic numbering",null,"click to select value"]
[null,24,"Use basic bullets",null,"click to select value"]
[null,25,"Create and use Tabs in Word",null,"click to select value"]
[{"$f":"IF(ISBLANK(B46),\"\",\"F\")","v":"F"},"Page Level Formatting"]
[null,{"$f":"IF(ISBLANK(C47),\"\",B45+1)","v":26},"Changing Margins",null,{"$f":"IF($D$46=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C48),\"\",B47+1)","v":27},"Changing Page Orientation",null,{"$f":"IF($D$46=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C49),\"\",B48+1)","v":28},"Change the Paper Size"," ",{"$f":"IF($D$46=\"All\",$B$66,$B$67)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B50),\"\",\"G\")","v":"G"},"Error Correction Tools"]
[null,{"$f":"IF(ISBLANK(C51),\"\",B49+1)","v":29},"Use Undo and Redo commands",null,{"$f":"IF($D$50=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C52),\"\",B51+1)","v":30},"Proof read  using the spell checker tool",null,{"$f":"IF($D$50=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C53),\"\",B52+1)","v":31},"Proof read  using the grammar checker tool",null,{"$f":"IF($D$50=\"All\",$B$66,$B$67)","v":"click to select value"}]
[{"$f":"IF(ISBLANK(B54),\"\",\"H\")","v":"H"},"Document Output"]
[null,{"$f":"IF(ISBLANK(C55),\"\",B53+1)","v":32},"Use different views and view options",null,{"$f":"IF($D$54=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C56),\"\",B55+1)","v":33},"Use Print Preview",null,{"$f":"IF($D$54=\"All\",$B$66,$B$67)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C57),\"\",B56+1)","v":34},"Print a Document",null,{"$f":"IF($D$54=\"All\",$B$66,$B$67)","v":"click to select value"}]
[]
[]
[null,null,"PLEASE ENSURE THAT YOU HAVE ANSWERED ALL QUESTIONS"]
[]
[null,"Responses","Score","Percentage"]
[null,"No Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$58,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C63/COUNTA($E$17:$E$57))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$58,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C64/COUNTA($E$17:$E$57))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$58,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C65/COUNTA($E$17:$E$57))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$58,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C66/COUNTA($E$17:$E$57))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$58,click_to_select_value))","v":34},{"$f":"IF(ISBLANK($E$17),\"\",C67/COUNTA($E$17:$E$57))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.6,"d":"60%"}]
[null,{"$f":"IF(C67>0,IncompleteTNA,IF(OR($D$63>=CriteriaToPass,$D$64 + $D$63>=CriteriaToPass),DoIntroductionCourse,IF($D$66>80%,DoIntermediateCourse,DoIntermediateTNA)))","v":"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"}]
[]
[]
[]
[null,null,"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"]
[null,null,"We suggest that you do the Introduction course"]
[null,null,"Based on your responses you have good knowledge of Introductory  concepts, we suggest that you do the Intermediate TNA, to check if you would be comfortable doing the Intermediate Course"]
[null,null,"Based on your responses you have  knowledge of some Introduction  concepts, we suggest that you do the  Intermediate Course"]