Atch (5)_NAVEDTRA 136 Question Bank Layout Template_3May23.xlsx

XLSX spreadsheet 43 KB Posted

Attached to
N61340 - Draft RFP and Pre-Solicitation Conference - Ready Relevant Learning Fiscal Year 2024 Content Conversion Aviation (RRL FY24 CC Aviation)
Solicitation number
N6134023R0073
Issued by

View the file

Other files

File Type Posted
RRL_FY24_CC_PSC_Brief_Final.pdf PDF
RRL_FY24CC_Aviation_PSC_Industry_RSVP_Attendance_Lists_12Jun23.pdf PDF
Atch (1)_APPENDIX D Risk Assessment Example Format - 24 Jan 2023.pptx PPTX presentation
GFI_U-ATI-1000_NTP_Workbook_Draft_6Jun23.xlsx XLSX spreadsheet
Atch (1)_APPENDIX G RRL Use of Blooms Taxonomy Action Verbs - 18Apr23.docx DOCX document
Atch (8)_RRLGM 22-0001 PALS_13May22.pdf PDF
Atch (1)_APPENDIX H RRL Media Characteristics - 05 Mar 2023.docx DOCX document
GFI_RRL_FY24CC_Aviation_Appendix_A_DRAFT_6Jun23.xlsx XLSX spreadsheet
Atch (L-3) Relevancy Information_N6134023R0073_6Jun23.xlsx XLSX spreadsheet
Atch (1)_FY24_CC_DRAFT_SOW_31May23.docx DOCX document
Exh_F_RRL_FY24CC_(F00X)_Training_CDRLs_18Apr23.docx DOCX document
Atch (2)_NAWCTSD_DIT_Form_Jan2023.pdf PDF
Exh_A_RRL_FY24CC_(A00X)_Eng_CDRLs_13Mar23.docx DOCX document
Atch (1)_APPENDIX B Acronym List - 22May23.docx DOCX document
Atch (L-1) Q-A Form_N6134023R0073.xlsx XLSX spreadsheet
Atch (7)_SOW Appendices C and H aligned_22May23.docx DOCX document
Atch (L-5) Small Business Participation Committment Document (SBPCD)_N6134023R0073.docx DOCX document
Exh_B_RRL_FY24CC_(B00X)_Admin_CDRLs_10Apr23.docx DOCX document
Atch (9)_Complex_Media_VSIM_Construct_1Jun23.docx DOCX document
Atch (L-4) CLIN Pricing Form_N6134023R0073_22May23.xlsx XLSX spreadsheet
Atch (1)_APPENDIX F RRL Operational Engaging Instructional Strategies_22May23.docx DOCX document
Atch (L-2) Contractor Performance Assessment Questionaire (CPAQ)_N6134023R0073.docx DOCX document
Atch (1)_APPENDIX C Terms and Definitions_22May23.docx DOCX document
Atch (3)_NETC_RRL_Style_Guide_19NOV2021.docx DOCX document
FY24_CC_N6134023R0073_DRAFT_6Jun23.docx DOCX document
Atch (L-6) Offeror Summary Table.xlsx XLSX spreadsheet
Atch (6)_RRL Interactive Media Definitons Examples_23Nov22.pdf PDF
Atch (1)_APPENDIX E RRL Content Delivery Modes - 18Apr23.docx DOCX document
Show all 28

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Data Elements

NAVEDTRA 136 Assessment Layout
Spread Sheet Column NameFieldType (Size)RequiredNotes
PHASEPhasenumeric (2)YTwo digit number between 01 and 99. Usually 01 is set for all questions in the test bank.NOTE: To retain the leading zero, either precede the number with an apostrophe or set the column to Text.
MODULEModulenumeric (2)YTwo digit number between 01 and 99. Usually ties back to lesson plans but does not have to match the plan exactly. Modules should only be included if they have exam items in the plan.
LESSONLessonnumeric (2)YTwo digit number between 01 and 99. Usually ties back to lesson plans but does not have to match the plan exactly. Lessons should only be included if they have exam items in the plan.
LESSON_TITLEDescriptive Title for a specific lesson.alpha numeric (50)NA short description of the lesson. Use this field to document the curriculum a lesson will cover. While not required it will help users to zero in on specific questions in the question bank during exam generation as well as the objective reporting process.
T.O.Terminal Objective Number (TOBJ)alpha numeric (3)YTerminal Objective: Note that the decimal ('.') character takes up one space. It is suggested that the TOBJ and EOBJ be combined to handle objective numbers such as 1.14 or 2.33 . In the first case on would create an TOBJ of 01 and an EOBJ of 14. The second would be TOBJ = 02, EOBJ = 33.
E.O.Enabling Objective Number (EOBJ)alpha numeric (3)YEnabling Objective: Note that the decimal ('.') character takes up one space. It is suggested that the TOBJ and EOBJ be combined to handle objective numbers such as 1.14 or 2.33 . In the first case on would create an TOBJ of 01 and an EOBJ of 14. The second would be TOBJ = 02, EOBJ = 33.
SECTION SUBJECT or KSATRDescriptive Title for a Section or Descriptive Title for a Knowledge, Skill, Ability, Tool, or Resourcealpha numeric (40)NUse the Section Title. In cases where test items need to be created under a KSATR, use the unique KSATR verbiage from CPM.
SEQ NOThe Sequence Number of a specific question within an objective (TO/EO)number(3)YThe Test Question Sequence number within an objective. These should start at 1 and increment for each question in the objective. The sequence number should also restart at 1 every time the Phase, Unit, Topic, TO or EO number changes giving a "new" objective.
VER NOThe Version Number of a specific question within an objective (TO/EO)number(2)YThe Test Question Version number. These should be kept at 1 if possible.
TYPE CDIndicates the question type of Multiple choice, True/False, or Matching.alpha numeric(1)YValid values are T (True/False), M (Multiple Choice), or B (Matching)
SHUFFLEIndicates if alternatives for a Multiple Choice question can be shuffled.alpha numeric(1)NValid values are Y or N (Yes/No) for Multiple Choice. Mandatory for Multiple Choice questions. Default is N (No) for True/False and Matching questions.
COR ANSThe letter for the correct answer for True/False and Multiple Choice. For Matching questions, this is also the position of the correct alternative in the list of alternatives.alpha numeric(1)YIf question type is True/False (T), then valid values are A (True) or B (False). If type is M (Multiple Choice) then valid values are A thru G. If Matching (B) question, this is also the 'position' of the alternative in the list of alternatives for a Matching question. Valid values for Matching questions are A - J.NOTE: If you enter a 'G': ensure that the Multiple choice question has all 7 alternatives in the Question Alternatives columns or for Matching question, ensure that there are 7 stimuli/response combinations.
HEADERQuestion instructions or information for matching questions.alpha numeric(2000)NThe instructions or information to students concerning this question. Free form text field. HEADER is mandatory and used only for Matching (B) questions. For Matching (B) questions, the HEADER should have the same text for each alternative in the set. HEADER is not used for Multiple Choice(M) and True/False(T).NOTE: Do not include specialized characters such as the degree symbol º. These many be added to the question via Question Maintenance after the spreadsheet has been loaded.
QUESTION STEM IDMatching question sequence IDnumber(2)Y/NValid values are 1 - 10. Sequential order from 1 to the number of stimuli/response elements for Matching (B) questions. Default is 1 for True/False (T) and Multiple choice (M). Mandatory for Matching (B) questions.
QUESTION STEM (stimuli)The question. It can be up to 2000 characters long.alpha numeric(2000)YThe text of the question. Free form text field.NOTE: Do not include specialized characters such as the degree symbol º. These many be added to the question via Question Maintenance after the spreadsheet has been loaded.
Q Alt 1 (response)First alternative or possible answer for True/False or multiple choice questions. For a matching question, this will be the be the matching alternative.alpha numeric(500)YThe text of the alternative. Free form text field. If question type is Multiple Choice(M), then populate with mandatory first Alternative. If question type is True/False(T), this will be 'True'. If question type is Matching (B), this will be the be the matching alternative.NOTE: Do not include specialized characters such as the degree symbol º.
Q Alt 2Second alternative or possible answer for True/False or multiple choice questions.alpha numeric(500)YThe text of the alternative. Free form text field. If question type is Multiple Choice(M), then populate with mandatory second Alternative. If question type is True/False(T), this will be 'False'. Alternative two will be blank for Matching (B) questions.NOTE: Do not include specialized characters such as the degree symbol º.
Q Alt 3Third alternative or possible answer for multiple choice questions.alpha numeric(500)Y/NThe text of the alternative. Free form text field. If question type is Multiple Choice(M), then populate with mandatory third Alternative. Alternative three will be blank for True/False(T) and Matching (B) questions.NOTE: Do not include specialized characters such as the degree symbol º.
Q Alt 4Fourth alternative or possible answer for multiple choice questions.alpha numeric(500)Y/NThe text of the alternative. Free form text field. If question type is Multiple Choice(M), then populate with mandatory fourth Alternative. Alternative four will be blank for True/False(T) and Matching (B) questions.NOTE: Do not include specialized characters such as the degree symbol º.
Q Alt 5Fifth alternative or possible answer for multiple choice questions.alpha numeric(500)NThe text of the alternative. Free form text field. If question type is Multiple Choice(M), then populate with optional fifth Alternative. Alternative five will be blank for True/False(T) and Matching (B) questions.NOTE: Do not include specialized characters such as the degree symbol º.
Q Alt 6Sixth alternative or possible answer for multiple choice questions.alpha numeric(500)NThe text of the alternative. Free form text field. If question type is Multiple Choice(M), then populate with optional sixth Alternative. Alternative six will be blank for True/False(T) and Matching (B) questions.NOTE: Do not include specialized characters such as the degree symbol º.
Q Alt 7Seventh alternative or possible answer for multiple choice questions.alpha numeric(500)NThe text of the alternative. Free form text field. If question type is Multiple Choice(M), then populate with optional seventh Alternative. Alternative seven will be blank for True/False(T) and Matching (B) questions.NOTE: Do not include specialized characters such as the degree symbol º.
CTTLCourse Task Training List numbernumber(5)NValid values are numeric. No decimals, letters, or special characters are allowed. For Matching (B) questions, the CTTL should be have the same number for each alternative in the set.
QUES_REFQuestion reference fieldalpha numeric(250)NThe text of the question reference. Free form text field. For Matching (B) questions, the QUES_REF should be have the same text for each alternative in the set.

Example Definitions

PHASEMODULELESSONLESSON_TITLET.O.E.O.SECTION SUBJECT or KSATRSEQ NOVER NOSHUFFLETYPE CDCOR ANSHEADERQUESTION STEM IDQUESTION STEMQ Alt 1Q Alt 2Q Alt 3Q Alt 4Q Alt 5Q Alt 6Q Alt 7CTTLQUES_REF
010101Lesson Titles will help with question maintenance, exam generation and system reporting.0101Objective Subjects will help with question maintenance, exam generation and system reporting.11Option to shuffle alternatives for Multi Choice Question. N for No or Y for YesMCorrect Answer for Multi Choice Question goes here, A, B, C, D, E, F or G.Will be blank for Multi Choice Question.Will be a 1 for Multi Choice Question.Question Stem for a Multiple Choice Question goes hereAlternative A goes hereAlternative B goes hereAlternative C goes hereAlternative D goes hereIf there is an Alternative E it would go here. If no Alternative E is present, leave this column blank but be sure to include it.
010101010121Will be N for No for True/False Question.TCorrect Answer for True/False Question goes here. Note A for True, B for False.Will be blank for True/False Question.Will be a 1 for True/False Question.Question Stem for a True or False Question goes hereTRUEFALSEalternative3 through alternative5 will be blank for a True or False Question
010101010131Option to shuffle alternatives for Multi Choice Question. N for No or Y for YesMCorrect Answer for Multi Choice Question goes here, A, B, C, D, E, F or GWill be blank for Multi Choice Question.Will be a 1 for Multi Choice Question.Question Stem for a Multiple Choice Question goes hereAlternative A goes hereAlternative B goes hereAlternative C goes hereAlternative D goes hereIf there is an Alternative E it would go here. If no Alternative E is present, leave this column blank but be sure to include it.
010101010141Will be N for No for True/False Question.TCorrect Answer for True/False Question goes here. Note A for True, B for False.Will be blank for True/False Question.Will be a 1 for True/False Question.Question Stem for a True or False Question goes hereTRUEFALSEalternative3 through alternative5 will be blank for a True or False Question
0101010102Note that when ever the Phase, Module, Lesson, TO or EO numbers change you are now working with a new objective and your Q Seq values should be reset to 1. (See the eobj value).11Option to shuffle alternatives for Multi Choice Question. N for No or Y for YesMCorrect Answer for Multi Choice Question goes here, A, B, C, D, E, F or GWill be blank for Multi Choice Question.Will be a 1 for Multi Choice Question.Question Stem for a Multiple Choice Question goes hereAlternative A goes hereAlternative B goes hereAlternative C goes hereAlternative D goes hereIf there is an Alternative E it would go here. If no Alternative E is present, leave this column blank but be sure to include it.
010101010221Will be N for No for True/False Question.TCorrect Answer for True/False Question goes here. Note A for True, B for False.Will be blank for True/False Question.Will be a 1 for True/False Question.Question Stem for a True or False Question goes hereTRUEFALSEalternative3 through alternative5 will be blank for a True or False Question
0101020102Note that when ever the Phase, Module, Lesson, TO or EO numbers change you are now working with a new objective and your Q Seq values should be reset to 1. (See the Topic value).11Option to shuffle alternatives for Multi Choice Question. N for No or Y for YesMCorrect Answer for Multi Choice Question goes here, A, B, C, D, E, F or GWill be blank for Multi Choice Question.Will be a 1 for Multi Choice Question.Question Stem for a Multiple Choice Question goes hereAlternative A goes hereAlternative B goes hereAlternative C goes hereAlternative D goes hereIf there is an Alternative E it would go here. If no Alternative E is present, leave this column blank but be sure to include it.If there is an Alternative F it would go here. If no Alternative F is present, leave this column blank but be sure to include it.If there is an Alternative G it would go here. If no Alternative G is present, leave this column blank but be sure to include it.
0101020102If possible always try to keep the version numbers (Q Ver) 1 to ease in question maintenance down the road.21Will be N for No for True/False Question.TCorrect Answer for True/False Question goes here. Note A for True, B for False.Will be blank for True/False Question.Will be a 1 for True/False Question.Question Stem for a True or False Question goes hereTRUEFALSEalternative3 through alternative7 will be blank for a True or False Question
0201010101All Stems in a Matching question will have the same SEQ NO and VER NO. 11Will be N for No for Matching Question.BFor Matching question, this is also the position of the alternative in the list of alternatives for a Matching question. Valid values are A - J. CQuestion instructions to studentsMatching question Stem sequence ID valid values are 1 - 10. 1First Stem of Matching question. May have up to 10 Stems for a Matching question.For Matching question, this will be the matching alternative of the Stem.alternative2 through alternative7 will be blank for a Matching Question
0201010101All Stems in a Matching question will have the same SEQ NO and VER NO. 11Will be N for No for Matching Question.BFor Matching question, this is also the position of the alternative in the list of alternatives for a Matching question. Valid values are A - J. AQuestion instructions to studentsMatching question Stem sequence ID valid values are 1 - 10. 2Second Stem of Matching question. May have up to 10 Stems for a Matching question.For Matching question, this will be the matching alternative of the Stem.alternative2 through alternative7 will be blank for a Matching Question
0201010101All Stems in a Matching question will have the same SEQ NO and VER NO. 11Will be N for No for Matching Question.BFor Matching question, this is also the position of the alternative in the list of alternatives for a Matching question. Valid values are A - J. DQuestion instructions to studentsMatching question Stem sequence ID valid values are 1 - 10. 3Third Stem of Matching question. May have up to 10 Stems for a Matching question.For Matching question, this will be the matching alternative of the Stem.alternative2 through alternative7 will be blank for a Matching Question
0201010101All Stems in a Matching question will have the same SEQ NO and VER NO. 11Will be N for No for Matching Question.BFor Matching question, this is also the position of the alternative in the list of alternatives for a Matching question. Valid values are A - J. BQuestion instructions to studentsMatching question Stem sequence ID valid values are 1 - 10. 4Fourth Stem of Matching question. May have up to 10 Stems for a Matching question.For Matching question, this will be the matching alternative of the Stem.alternative2 through alternative7 will be blank for a Matching Question

Example Data Set

Note: The following questions, although factually correct, are not real test questions from any course….
PHASEMODULELESSONLESSON_TITLET.O.E.O.SECTION SUBJECT or KSATRSEQ NOVER NOSHUFFLETYPE CDCOR ANSHEADERQUESTION STEM IDQUESTION STEMQ Alt 1Q Alt 2Q Alt 3Q Alt 4Q Alt 5Q Alt 6Q Alt 7CTTLQUES_REF
010101M-16 Weapon System0101Over View11NMC1In the Picture, Arrow Golf points to the .......magazine well.safety lever.front sight.
spent casing ejection port.
1OPNAVINST 3591.1F, Small Arms Training and Qualification Guidance
010101M-16 Weapon System0101Over View12NTB1In the attached picture, arrow G points to the front sling mount.TrueFalse
010101M-16 Weapon System0101Over View21NMB1In the Picture, Arrow B points to the ......muzzle.rear sight elevation adjustment knob.magazine release button.forward assist plunger.
010101M-16 Weapon System0101Over View22NTA1In the Picture, Arrow B points to the rear sight elevation adjustment knob.TrueFalse
010101M-16 Weapon System0101Over View31NMD1In the Picture, Arrow E points to the ......front sight post height adjustment.front sling mount point.magazinespent casing ejection port/port cover.
010101M-16 Weapon System0101Over View41NTA1In the picture Arrow A points to the rear sight windage adjustment knob.TRUEFALSE
010101M-16 Weapon System0101Over View51NMC1In the picture, Arrow F points to the .......pistol grip.front sling mount.safety/firing mode selection lever.
charging handle.
010101M-16 Weapon System0101Over View61NME1In the picture Arrow G points to the .......trigger.clearing handle.
rear sight elevation adjustment lever.muzzle.charging handle.
010101M-16 Weapon System0102Mechanics11NMB1The M-16 is a magazine fed, ....... ......., shoulder fired weapon.bolt actiongas operatedbox holdingspring loaded
010101M-16 Weapon System0102Mechanics21NTB1True or False:

The following is the M-16 firing cycle, assuming the rifle has been charged and the safety selection lever is on semi-automatic.

1) the trigger pushes the sear up releasing the hammer catch

2) The hammer falls forward striking the firing pin

3) The bullet is fired down the barrel

4) The expanding gas is fed back to the bolt carrier via the gas tube after the bullet passes the gas tube port and before the bullet exits the barrel at the muzzle

5) The bolt carrier is forced back in the recoil tube

a) compressing the recoil spring and

b) extracting the spent shell from the chamber

6) As the bolt is pulled back and the spent casing passes in front of the ejection port, the ejector pin pops the casing out of the port via the counter moment force generated by the pin pushing forward and the ejector claw holding on to the right side of the casing rim.

7) The decompressing recoil spring pushes the bolt carrier forward causing the bolt to strip off the next round from the magazine

8) The forward momentum causes the bolt head to lock up with the chamber locking lugs and seat the round in the chamber

9) the cycle starts at number 1 and will continue until the trigger is released or the magazine is emptied.TRUEFALSE
010101M-16 Weapon System0102Mechanics31NMD1The bolt is rotated to the left, unlocking the bolt lugs form the chamber lugs, by the ....... ....... as the carrier is pushed back by the force of the expanding gas from the fired shell.cam rotator
rotator device
locking lugs
cam pin
firing pin
010101M-16 Weapon System0102Mechanics41NMD1The interrupter gear will stop the weapon's firing cycle after ....... ....... if the firing selector is on burst.5 roundsall rounds10 rounds3 rounds

Example matching data set

Note: The following questions, although factually correct, are not real test questions from any course….
PHASEMODULELESSONLESSON_TITLET.O.E.O.SECTION SUBJECT or KSATRSEQ NOVER NOSHUFFLETYPE CDCOR ANSHEADERQUESTION STEM IDQUESTION STEMQ Alt 1Q Alt 2Q Alt 3Q Alt 4Q Alt 5Q Alt 6Q Alt 7CTTLQUES_REF
020101Solar System0101Planets11NBFMatch the planet to its position from the sun.1First planet from the sunMercury1The Astronomical Almanac Section E pp 158-183
020101Solar System0101Planets11NBEMatch the planet to its position from the sun.2Second planet from the sunVenus1The Astronomical Almanac Section E pp 158-183
020101Solar System0101Planets11NBDMatch the planet to its position from the sun.3Third planet from the sunEarth1The Astronomical Almanac Section E pp 158-183
020101Solar System0101Planets11NBCMatch the planet to its position from the sun.4Fourth planet from the sunMars1The Astronomical Almanac Section E pp 158-183
020101Solar System0101Planets11NBBMatch the planet to its position from the sun.5Fifth planet from the sunJupiter1The Astronomical Almanac Section E pp 158-183
020101Solar System0101Planets11NBAMatch the planet to its position from the sun.6Sixth planet from the sunSaturn1The Astronomical Almanac Section E pp 158-183
020101Solar System0101Planets11NBHMatch the planet to its position from the sun.7Seventh planet from the sunUranus1The Astronomical Almanac Section E pp 158-183
020101Solar System0101Planets11NBGMatch the planet to its position from the sun.8Eighth planet from the sunNeptune1The Astronomical Almanac Section E pp 158-183
020101Solar System0201Stars11NTA1The Sun is a star.TRUEFALSE2The Astronomical Almanac Section C pp 92-96
020101Solar System0301Space Frontier11YMC1People are applying to live at an outpost on this planet.MercuryVenusMarsJupiterSaturnUranusNeptune
020101Solar System0401First and Last11YBFMatch the event to the person.1First person to step onto the moonNeil Armstrong
020101Solar System0401First and Last11YBGMatch the event to the person.2Last person to step off the moonEugene Cernan
020101Solar System0401First and Last11YBEMatch the event to the person.3Last person to sign the Declaration of IndependenceThomas McKean
020101Solar System0401First and Last11YBCMatch the event to the person.4First American to orbit the EarthJohn Glenn
020101Solar System0401First and Last11YBDMatch the event to the person.5First person to sign the Declaration of IndependenceJohn Hancock
020101Solar System0401First and Last11YBAMatch the event to the person.6First person in spaceYuri Gagarin
020101Solar System0401First and Last11YBBMatch the event to the person.7First person to walk in spaceAleksei Leonov
020101Solar System0501Stars11NTB1The Sun is the only star.TRUEFALSE
020101Solar System0601Space Frontier11YMB1In 2006, this was reclassified as a dwarf planet.PanPlutoTritonTitanEuropa

NAVEDTRA136 Assessment Template PHASE MODULE LESSON LESSON_TITLE T.O. E.O. SECTION SUBJECT or KSATR SEQ NO VER NO SHUFFLE TYPE CD COR ANS HEADER QUESTION STEM ID QUESTION STEM Q Alt 1 Q Alt 2 Q Alt 3 Q Alt 4 Q Alt 5 Q Alt 6 Q Alt 7 CTTL QUES_REF

File details come from the government source that posted it. Updated .