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

{"sheet":"Word Intermediate TNA","index":0,"n_rows":70,"n_cols":5,"rows_kept":70,"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],[21,1,21,2],[26,1,26,2],[32,1,32,2],[40,1,40,2],[44,1,44,2],[48,1,48,2],[52,1,52,2],[69,1,71,4]]}
["ATI-Mirage Training Solutions"]
["Word Intermediate - Training Needs Analysis (TNA)"]
[]
["Name:",null," "]
["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 Tables"]
[null,{"$f":"IF(ISBLANK(C17),\" \",1)","v":1},"Creating tables",null,{"$f":"IF($D$16=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C18),\"\",B17+1)","v":2},"Complex table formatting including border and shading options",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C19),\"\",B18+1)","v":3},"Insert and delete table cells, rows and columns",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C20),\"\",B19+1)","v":4},"Create calculations in a table",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C21),\"\",B20+1)","v":5},"Use Heading Rows repeat on a table",null,{"$f":"IF($D$16=\"All\",$B$67,$B$68)","v":"click to select value"}]
["B","Advanced Text and Paragraph Formatting"]
[null,{"$f":"IF(ISBLANK(C23),\"\",B21+1)","v":6},"Control line spacing within a paragraph",null,{"$f":"IF($D$22=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C24),\"\",B23+1)","v":7},"Set up spacing  before and after a pargraph",null,{"$f":"IF($D$22=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C25),\"\",B24+1)","v":8},"Use indentation to control the width of a paragraph",null,{"$f":"IF($D$22=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C26),\"\",B25+1)","v":9},"Insert page breaks, hard returns and manual line breaks",null,{"$f":"IF($D$22=\"All\",$B$67,$B$68)","v":"click to select value"}]
["C","Lists"]
[null,{"$f":"IF(ISBLANK(C28),\"\",B26+1)","v":10},"Creating bulleted lists",null,{"$f":"IF($D$27=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C29),\"\",B28+1)","v":11},"Creating numbered lists",null,{"$f":"IF($D$27=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C30),\"\",B29+1)","v":12},"Creating multi-level lists",null,{"$f":"IF($D$27=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C31),\"\",B30+1)","v":13},"Modifying multi-level lists",null,{"$f":"IF($D$27=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C32),\"\",B31+1)","v":14},"Create List Styles",null,{"$f":"IF($D$27=\"All\",$B$67,$B$68)","v":"click to select value"}]
["D","Document Control"]
[null,{"$f":"IF(ISBLANK(C34),\"\",B32+1)","v":15},"Understading of what Building Blocks are",null,{"$f":"IF($D$33=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C35),\"\",B34+1)","v":16},"Use Building Blocks",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C36),\"\",B35+1)","v":17},"Create Building Blocks",null,"click to select value"]
[null,{"$f":"IF(ISBLANK(C37),\"\",B36+1)","v":18},"Working with styles for document formatting",null,"click to select value"]
[null,19,"Using Columns",null,"click to select value"]
[null,20,"Set up and use multiple Columns",null,"click to select value"]
[null,21,"Adjust Columns",null,"click to select value"]
["E","Building Blocks"]
[null,{"$f":"IF(ISBLANK(C42),\"\",B40+1)","v":22},"Insert a Building Block",null,{"$f":"IF($D$41=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C43),\"\",B42+1)","v":23},"Create a new Building Block",null,{"$f":"IF($D$41=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C44),\"\",B43+1)","v":24},"Edit a Building Block "," ",{"$f":"IF($D$41=\"All\",$B$67,$B$68)","v":"click to select value"}]
["F","Working with Images and Clipart"]
[null,{"$f":"IF(ISBLANK(C46),\"\",B44+1)","v":25},"Insert an image, picture or clipart",null,{"$f":"IF($D$45=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C47),\"\",B46+1)","v":26},"Adjust and Edit Images",null,{"$f":"IF($D$45=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C48),\"\",B47+1)","v":27},"Format an Image",null,"click to select value"]
["G","Document Layout"]
[null,{"$f":"IF(ISBLANK(C50),\"\",B48+1)","v":28},"Add Section Breaks",null,{"$f":"IF($D$49=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C51),\"\",B50+1)","v":29},"Work With Headers and Footers",null,{"$f":"IF($D$49=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C52),\"\",B51+1)","v":30},"Insert logo in Header or Footer",null,"click to select value"]
["H","Document Correction Settings"]
[null,{"$f":"IF(ISBLANK(C54),\"\",B52+1)","v":31},"Create and Use AutoText entries",null,{"$f":"IF($D$53=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C55),\"\",B54+1)","v":32},"Set up and use AutoCorrect",null,{"$f":"IF($D$53=\"All\",$B$67,$B$68)","v":"click to select value"}]
[null,{"$f":"IF(ISBLANK(C56),\"\",B55+1)","v":33},"Edit an AutoText Entry",null,"click to select value"]
[null,34,"Use Find and Replace",null,"click to select value"]
[null,35,"Use the Navigation pane",null,"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$59,No_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C64/COUNTA($E$17:$E$58))","v":{"v":0,"d":"0.00%"}}]
[null,"Basic Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$59,Basic_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C65/COUNTA($E$17:$E$58))","v":{"v":0,"d":"0.00%"}}]
[null,"Good Knowledge",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$59,Good_Knowledge))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C66/COUNTA($E$17:$E$58))","v":{"v":0,"d":"0.00%"}}]
[null,"Expert",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$59,Expert))","v":0},{"$f":"IF(ISBLANK($E$17),\"\",C67/COUNTA($E$17:$E$58))","v":{"v":0,"d":"0.00%"}}]
[null,"click to select value",{"$f":"IF(ISBLANK($E$17),\" \",COUNTIF($E$17:$E$59,click_to_select_value))","v":35},{"$f":"IF(ISBLANK($E$17),\"\",C68/COUNTA($E$17:$E$58))","v":{"v":1,"d":"100.00%"}}]
[null,{"v":0.6,"d":"60%"}]
[null,{"$f":"IF(C68>0,\"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells\",IF(OR($D$64>=CriteriaToPass,($D$65+$D$64)>=CriteriaToPass),\"We suggest that you do the Intermediate Course, but do have a look at the Introduction course TNA\",IF($D$67>80%,\"Based on your responses you have a good knowledge of Intermediate  concepts, we suggest that you do the Advanced TNA, to check if you would be comfortable doing the Advanced Course\",\"Based on your responses you have  knowledge of some Intermediate  concepts, we suggest that you do the  Intermediate Course\")))","v":"We cannot make an Assessment as you have not completed ALL of the questions, check the Yellow cells"}]