O fficer P rofessional D evelopment S ystem NCOPDS Perform Datastore Functions April 2017 ACTION Perform Datastore Functions CONDITIONS In a classroom environment given a set of data elements a computer with access to the internet access to the Datastore training ID: 670220
Download Presentation The PPT/PDF document "A djutant G eneral N oncommissioned" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Adjutant General Noncommissioned Officer Professional Development System(NCOPDS)
Perform
Datastore FunctionsApril 2017Slide2
ACTION: Perform Datastore FunctionsCONDITIONS: In a classroom environment, given a set of data elements; a computer with access to the internet; access to the Datastore training database, corresponding regulatory guidance and awareness of Operational Environment (OE) variables and actors.STANDARDS:
Create Ad Hoc Queries
View Ad Hoc Queries for correct data outputModify Ad Hoc Queries Scores 28 out of 40 rounds on the HR Weapon Qualification test
Learning ObjectiveSlide3Slide4Slide5Slide6Slide7Slide8Slide9Slide10Slide11Slide12Slide13Slide14
ExampleHow many: Active Duty, Enlisted, Female, Single Soldiers Are Assigned to WK0101?
Undo filters until line is clear, prior to the next scenario
7/197 = 0.036632 or 3.7% Slide15
ExampleHow many Enlisted soldiers assigned to WK0101, have a BASD prior to 1 January 2009 and a GT score from 100 through 109?What is the Percentage?Slide16
ExampleHow many Enlisted soldiers assigned to WK0101 have a:BASD prior to 1 January 2009 andGT score of 100 through 109? What is the Percentage?21 / 197 = 0.1065989847715736 =10.7% Only round to the nearest tenthSlide17
ACTION: Perform Datastore FunctionsCONDITIONS: In a classroom environment, given a set of data elements; a computer with access to the internet; access to the Datastore training database, corresponding regulatory guidance and awareness of Operational Environment (OE) variables and actors.STANDARDS:
Create Ad Hoc Queries
View Ad Hoc Queries for correct data outputModify Ad Hoc Queries Scores 28 out of 40 rounds on the HR Weapon Qualification test
Learning Objective