CGA Instructional Technology & Tools 2 — Questions and Answers
Question 1: Which federal system is the primary repository for grant opportunity announcements that grant administrators must monitor?
- SAM.gov
- Grants.gov (Correct answer)
- USASpending.gov
- FAPIIS
Correct answer: Grants.gov
Grants.gov is the centralized federal portal where agencies post grant opportunities and where applicants submit grant applications.
Question 2: A grant administrator is setting up a training LMS for sub-recipients. Which SCORM version is most widely supported by modern LMS platforms for interoperability?
- SCORM 1.1
- SCORM 1.2
- SCORM 2004 3rd Edition (Correct answer)
- SCORM 2004 4th Edition
Correct answer: SCORM 2004 3rd Edition
SCORM 2004 3rd Edition offers the best balance of advanced features and broad LMS compatibility across most enterprise platforms.
Question 3: When using a grants management information system (GMIS), which data element is critical for tracking period of performance compliance?
- DUNS number
- Award start and end dates (Correct answer)
- Indirect cost rate
- CFDA number
Correct answer: Award start and end dates
Award start and end dates define the period of performance, and costs must be incurred within this window to be allowable.
Question 4: Which tool within Microsoft Excel is most useful for reconciling grant budget vs. actual expenditure reports?
- VLOOKUP / XLOOKUP
- Solver Add-in
- Goal Seek
- Power Query pivot tables (Correct answer)
Correct answer: Power Query pivot tables
Power Query combined with pivot tables allows grant administrators to consolidate, transform, and compare budget versus actual data from multiple sources efficiently.
Question 5: A CGA wants to deliver asynchronous compliance training to 50 staff members across three states. What technology approach is MOST appropriate?
- In-person workshop with printed handouts
- Live webinar with mandatory attendance
- Self-paced eLearning modules hosted on an LMS (Correct answer)
- Email-based instruction with PDF attachments
Correct answer: Self-paced eLearning modules hosted on an LMS
Self-paced eLearning on an LMS provides scalable, trackable, on-demand training that staff can complete regardless of location or time zone.
Question 6: Under 2 CFR Part 200, electronic records maintained in a grants management system must meet which standard?
- They must be printed and stored in physical files
- They must be accessible, retrievable, and support audit requirements (Correct answer)
- They must use only federally approved software
- They must be stored on federal government servers
Correct answer: They must be accessible, retrievable, and support audit requirements
2 CFR §200.335 requires that financial records be accessible and retrievable to support audits and federal oversight for the required retention period.
Question 7: Which feature of a grants management portal helps prevent drawdown errors by alerting administrators when requested funds exceed the approved budget line item?
- Automated budget modification workflow
- Real-time budget validation and spending alerts (Correct answer)
- Sub-recipient monitoring dashboard
- Indirect cost rate calculator
Correct answer: Real-time budget validation and spending alerts
Real-time budget validation rules in a GMIS flag drawdown requests that would exceed approved line items, preventing over-expenditure before it occurs.
CGA Instructional Technology & Tools 2
Which federal system is the primary repository for grant opportunity announcements that grant administrators must monitor?