Spreadsheet: 275138d1383341217-looking-up-and-matching-rows-to-columns-test
Sheet: Test

RFR# | Statement | GROUP A |  |  |  | GROUP B |  |  |  | GROUP C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROUP D |  |  |  |  |  |  |  |  |  |  |  |  | GROUP E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROUP F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GROUP G
 |  | Add | Delete | Edit | View | Issue | Renew | Duplicate | Modify | Duplicate/Print Driver's License | Duplicate/Print Learner's Permit | Grant Parental Consent | Inactivate Learner's Permit/Driver's License | Issue Credential | Issue [NAME]'s Permit | Issue License/Mass ID Extension | Knowledge Exam (CDL) | Knowledge Exam (non-CDL) | Issue Temporary Privilege (Competency) | [NAME]'s Permit (Apply) | Managed Scheduled Road Skills Test (Third Party) | Massachusetts Rider Education Program (MREP) | Military Renewals and Duplicates | OOS License Conversion (CDL) | OOS Permit/License Conversion (D and M) | Out of State Rider Education Program (MREP) | Override Exam/Test | Practice Knowledge Exam | Reactivate [NAME]'s Permit | Reactivate Driver's License | Reinstate Driver's License | [NAME] License (CDL) | [NAME] License (D and M) | Schedule Road Skills Test | Schedule Road Skills Test (Third Party) | Take Exam with ADA Accommodations | Update Exam/Test Results | Update Threat Assessment for HazMat | Withdraw Parental Consent | AAMVA Change Data | CDLIS Check | CDLIS Resolution | Change State of Record | Electronic Verification of Vital Events Records | Inactivate SSN | NDR Check (PDPS) | NDR Resolution | Receive OOS Status/History Request | SSN Validation | State to State Inquiry (DIVS) | Verification of Birth Record (DPH) | Verification of Legal Status | Administer Vision Test | Administer Vision Test (Electronic) | Apply To Register To Vote | Card Return | Check Status | DVS (Add Drivers) | DVS ([NAME]) | DVS (Manage Drivers) | DVS (Renew) | Enroll as [NAME] Donor | Generate DVS Notification | Hearing Impaired Interpreter Request | Print Demographic | Third Party Replacement Card (AMEX) | Released Prisoner Program Process | View Status of DVS Enrollee | Add/Update Bond | Bond Cancellation | Close Driving School Process | CORI Check | Driving Instructor Exam Process | Driving School Audits | Driving School/Instructor Suspension | Duplicate/Print Other Credentials | Inactivate Other Credentials | Issue 7-D School Pupil Transport License | Issue Driver's Education Certificate | Issue Driving School License | Issue Inspection Station License | Issue Inspector [NAME] | Issue [NAME]. Credential | Issue [NAME]. Credential (Account) | Issue School Bus Driver Certificate | Issue/Renew Professional Driving Instructor Certificate | Issue/Renew School Bus Instructor Certificate | [NAME] | OOS Conversion of Driver's Ed Certificate | Reactivate Other Credentials | Renew Driving School License | Renew Inspection Station License | Renew Inspector [NAME] | Renew School Bus Driver Certificate/7D School Pupil Transport License | Renew School Bus Driver Instructor Certificate | CDL Medical Downgrade | Issue Placard/Disability Plates | Issue/Renew CDL Medical Waiver | Issue/Update Tinted Glass Waiver | Medical Restore | Medical Restore (Exams) | Medical Surrender | Online Certification ([NAME]) | Online Medical Submission | Renew Placard | Replace Placard | [NAME]
BU.1 | From an open "Self Joining" community to one that is "Closed", a range of options exist related to the process of becoming a member of the community and its sub groups
 | New users can self register and add. | X
 | Creation of new user accounts can be limited to administrators only |  |  |  |  |  | X
 | Provides ability to invite new members, exclude members, etc.
 | Renew
 | Issue Placard information and registration.
 | Maintain disability plates
 | Maximum number of users per web
 | Creation of new user accounts can be delegated to a "member manager" who possesses limited administrative permissions
 | The ability of two or more individuals to be grouped together into named "subgroups" that have designated group-related permissions to unique information and resources
 | Administrator can create subgroups
 | Users can create subgroups (when user account is created, admin should be able to set scope of groups this user can create)
 | Subgroups can consist of both users and groups
 | For subgroups, users may designate which level of nested group can access each resource, schedule entry, chat room, or discussion thread
 | "Leaders" can be assigned to subgroups with "administrative permissions" for given groups
 | Roles that support "community-building" processes designed into permissions structure and collaboration tools
 | Site administrators manage features configuration, permissions, role assignments
 | User and Group membership managers possess administrative rights but which are limited to managing group assignments and site membership
 | Cross-Group Leaders manage content and process collaboration across groups
 | Group Leaders manage content and process collaboration within designated groups
 | "Social awareness" of other community members and groups
 | Directory of members with customizable profiles including photos
BU.2 | Supports "buddy list" (who's online right now)
 | Notifies members of new postings (files, discussions, etc.).
 | Provides member activity summaries
 | Provides searchable, downloadable member database
 | Users can see others' group membership(s) (option for hiding group memberships)
 | Provides instant messaging service.
 | Provides chat services.
 | Users can create new rooms, permanent and temporary
 | Copy and paste into and out of chat works across platforms and browsers
 | Users can create transcripts by clicking a record button to begin and a stop button the end (users should also have the option of having all their chats logged, and then when a particular user leaves, they chose to keep or discard that transcript)
 | Transcripts are automatically stored as resources in a special folder accessible to group which could access the room
 | Users should be able to refer to other objects/resources from within the chat
 | Supports audio and video conferencing
 | Creates indexed archive of audio/video conferences
 | A whiteboard which becomes an extension of chat but allows users to draw as well. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | Ideally, users are able to place other documents (text, pictures, pdfs, reports) on the whiteboard and comment on them - as a group
 | Supports real-time shared whiteboard
BU.12 | Supports real-time application sharing
 | Provides well-organized  discussion forums (discussion threads can be grouped by category, so have at least 2-level hierarchy of classification: category and thread)
 | Supports ability to view discussions in both threaded and linear mode
 | Discussions have their own e-mail addresses (so can send copy of non-group e-mail to group)
 | Administrators can assign moderators to categories
 | Moderators can move posts between threads
 | Moderators can split threads (which have changed subject)
 | Discussion posts can be spellchecked and previewed.
 | Messages can be searched
KM007-013 | Threads can be archived but remain searchable
FS.1 | Resources from a resource section can be associated with posts
 | [NAME] in posts
 | WYSIWYG tools for styling text in posts
 | Discussions can be scaffolded (moderators may set up identifiers that users can associate with each post that designate the function of the post in conversation, e.g. set up topic, provide resource/background, agree, disagree, summary, etc.)
FS.1.1 | Discussions can be scaffolded on bond.
 | Provides option for group polling/surveys
FS.1.2 | Integrates polling/resource sharing into discussion (e.g., via live link)
 | Provides basic moderation tools (to invite/ban members)
FS.1.3 | Provides shared file space, capability to do document sharing
 | Easy download/upload of documents, either via Browse dialog box, or via Windows click-and-drag
FS.12.1 | Provides ability to edit documents collaboratively, including support for document version control.
 | Supports viewing of documents in native format for Word and Excel files
 | Supports editing of documents in native format for Word and Excel files
 | Document version tracking and view.
 | Document version tracking and delete.
 | Document version tracking and issue.
 | Document version tracking and edit.
[NAME] | Document check-in and check-out
 | Issue
 | Renew
 | Duplicate
 | Flexible, hierarchical (with at least 3 nested levels), well-organized directory and file structure
FS.16.2 | Supports association of resources with discussions and tasks (e.g., If a resource is associated with a discussion thread, there is a direct link to the thread from the resource)
 | Provides subgroup workspaces to share information, documents, and organize work - including subgroup discussions, document sharing, chat)
FS.16.3 | Provides community chronicle (history, archives)
 | Ability to share links as resource, organized by topic (e.g., web link repository organized by folders)
FS.16.4 | Provides resource library support, with subgroup access control of resources
 | Customizable database for entering, searching and organizing data
FS.16.5 | Field validation options for data entry
 | Export database to csv file
FS.16.6 | Customizable drop down lists that are reusable across database tables
 | Tools for organizing activities
 | Provides work-flow based task administration (set up tasklists)
FS.16.7 | Provides project(s) calendar(s)
 | Provides group calendar
FS.16.8 | Ability to easily find information and resources
 | Provides search engine for site
FS.16.9 | Provides search engine for subgroups
 | All content objects (discussion posts, resources, etc.) can be linked to directly via a URL which never changes
FS.16.10 | Ability to easily participate in the community (technology recedes into background)
 | Clear, familiar navigation metaphor (e.g., folder-based)
FS.16.11 | Uses browser interface (not dependent on client)
 | Supports both Macintosh and PC
 | Configurable user interface/user-controlled views
FS.16.19 | Supports icons and graphics for community identity
 | Community space represented by web page
FS.2 | Ability to set up sites without technical assistance
 | [NAME]/Unified Log-in throughout space
 | Balance between pushing information (listserv) and communication vs. requiring users to login to participate
 | User-controlled delivery modes (user has following choices: send alert of postings; forward individual postings to e-mail; send daily/weekly digest of postings, don't send e-mail)
 | Users can manage all their notifications from a single profile management form, or can select to be notified from a particular thread or folder, etc.
 | The body of messages are pushed as well as links if requested by user
FS.2.1 | Links in notifications point directly to the individual item
 | Supports automatic reminders and progress updates associated with tasklists
 | Ability to share data with or integrate with other systems
FS.2.5 | Provides for export of material to other system
 | Provides ability to link easily into  and out of  other systems (external URL reference)
FS.2.6 | Does not require special browser for OS (e.g., only IE)
 | Supports multiple media formats (embedded graphics)
FS.2.7 | Synchronization with PDAs
 | Synchronization with Outlook
FS.2.8 | Ability to sustain an activity with continuity (for example, if discussing a document, there is no barrier to discussion that is due to not being able to find the document
 | Content and interaction are interwoven (not divided into silos)
FS.2.9 | Accessibility and representations of relationships among resources
 | The relationships between and among resources can be maintained, so that users can find things by the community event to which they were associated, by the other documents that were created at the same time for similar purposes, by documents which have a topic relationships, or contributed by same author (semantic web)
FS.2.10 | Massachusetts Rider Education Program (MREP)
 | Military Renewals and Duplicates
FS.2.11 | OOS License Conversion (CDL)
 | OOS Permit/License Conversion (D and M)
FS.2.12 | Out of State Rider Education Program (MREP) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | Override Exam/Test
 | Practice Knowledge Exam
RBF-CS 22 | Reactivate [NAME]'s Permit
 | Reactivate Driver's License
 | Reinstate Driver's License
RBF-CS 28 | Massachusetts Rider Education Program (MREP)
 | Military Renewals and Duplicates
 | OOS License Conversion (CDL)
 | OOS Permit/License Conversion (D and M)
 | Out of State Rider Education Program (MREP)
 | Override Exam/Test
 | Practice Knowledge Exam
RBF-CS 32 | Reactivate [NAME]'s Permit
 | Reactivate Driver's License
RBF-CS 33 | Reinstate Driver's License
 | Renew School Bus Driver Instructor Certificate
 | CDL Medical Downgrade
RBF-CS 34 | Issue Placard/Disability Plates
 | Issue/Renew CDL Medical Waiver
 | Issue/Update Tinted Glass Waiver
RBF-CS 36 | Medical Restore
 | Medical Restore (Exams)
 | Medical Surrender
 | Online Certification ([NAME])
RBF-CS 37 | Online Medical Submission
 | Renew Placard
RBF-CS 38 | Replace Placard
 | [NAME]
RBF-CS 39
RBF-CS 40
RBF-CS 41
RBF-CS 42
RBF-CS 43
RBF-CS 44
RBF-CS 45
RBF-CS 46
RBF-CS 47
RBF-CS 48
RBF-CS 49A
RBF-CS 49A
RBF-CS 50
RBF-CS 52
RBF-CS 53
RBF-CS 54 |  |  |  |  |  |  |  |  |  | X |  |  | X |  | X | X
RBF-CS 57
RBF-CS 58
RBF-CS 59
RBF-CS 60
RBF-CS 61
RBF-CS 62
RBF-CS 63
RBF-CS 64
RBF-CS 65
RBF-CS 66
RBF-CS 67
RBF-CS 64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
RBF-CS 69
RBF-CS 70
RBF-CS 71
RBF-CS 72
RBF-CS 73
RBF-CS 74
RBF-CS 75
RBF-CS 76
RBF-CS 77
RBF-CS 78
RBF-CS 79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  | X | X | X | X | X | X | X | X | X | X
RBF-CS 82
RBF-CS 85
RBF-CS 208
RBF-CS 209
RBF-CS 210
RBF-CS 211
RBF-CS 212
RBF-CS 213
RBF-CS 214
RBF-CS 215
RBF-CS 216
RBF-CS 217
RBF-CS 218
RBF-CS 287
RBF-CS 291
RBF-CS 292
RBF-CS 293
RBF-CS 294
RBF-CS 295
RBF-CS 296
RBF-CS 297
RBF-CS 298
RBF-CS 299 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
RBF-CS 300
RBF-CS 301
RBF-FS 30
RBF-FS 31
RBF-FS 32
RBF-FS 34
RBF-FS 36
RBF-FS 37
RBF-FS 38
RBF-FS 70
RBF-FS 71
RBF-FS 72
RBF-FS 73
RBF-FS 74
RBF-FS 75
RBF-FS 86
RBF-FS 87
RBF-FS 111
RBF-FS 112
RBF-FS 113
RBF-FS 114
RBF-FS 115
RBF-FS 116
RBF-FS 117
RBF-FS 118
RBF-FS 119
RBF-FS 122
RBF-FS 137
New Requirement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X |  | X
New Requirement
New Requirement
New Requirement
New Requirement |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
New Requirement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
New Requirement |  |  |  |  |  |  |  |  |  |  |  | X
New Requirement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
New Requirement
New Requirement
New Requirement
New Requirement
New Requirement
New Requirement
New Requirement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X
New Requirement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
New Requirement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X