Grackle Sheets

1 00:00:00,080 --> 00:00:04,200 Grackle for Google Sheets from the T&D Digital Accessibility Series. 2 00:00:04,920 --> 00:00:10,480 Before running accessibility tools on every spreadsheet you own, put your files into one of three buckets. 3 00:00:12,160 --> 00:00:18,800 Remove. Is the file old or unnecessary? Delete or archive it and remove public links. 4 00:00:20,480 --> 00:00:29,040 Replace. Is a spreadsheet the wrong tool? Move the information to a standard web page or web form if it provides a better user experience. 5 00:00:31,520 --> 00:00:35,080 Remediate. Does your audience need this exact spreadsheet? 6 00:00:36,800 --> 00:00:40,600 Keep it, but make a working copy to fix before sharing the updated version. 7 00:00:42,480 --> 00:00:50,960 Running the automated check. I'm starting with a Google Sheet filled with data charts and colored cells to check its accessibility. 8 00:00:51,840 --> 00:00:57,480 I click extensions in the top menu, navigate to Grackle Sheets and select launch. 9 00:00:59,120 --> 00:01:01,920 As the side panel opens and begins scanning. Keep in mind. 10 00:01:02,880 --> 00:01:10,620 Automated checkers like grackle are great for catching structural barriers, But automation alone won't make a spreadsheet 100% accessible. 11 00:01:12,620 --> 00:01:20,980 What grackle sheets checks in the populated grackle panel, findings are organized into four categories using green check marks for passes, 12 00:01:21,980 --> 00:01:26,700 yellow exclamation icons for warnings, and red X icons for failures. 13 00:01:28,260 --> 00:01:33,300 First, document metadata verifies custom file titles and unique sheet tab names. 14 00:01:34,500 --> 00:01:38,260 Second table structure validates data table headers and flags. 15 00:01:38,700 --> 00:01:47,100 Merged or isolated cells. Third visual elements scans floating images, charts and drawings for alternative text. 16 00:01:48,500 --> 00:01:53,380 Fourth, formatting and contrast measures font legibility and color contrast ratios. 17 00:01:55,660 --> 00:02:04,500 What grackle sheets cannot check? Zooming in on an image with the alt text, a cool chart and a red cell containing no text. 18 00:02:05,260 --> 00:02:10,140 We see what grackle misses. Automation checks for tags, not context. 19 00:02:11,940 --> 00:02:19,160 First alt text accuracy. Grackle approves a cool chart simply because the field isn't empty. 20 00:02:20,480 --> 00:02:29,200 Second color used alone, a red cell indicating fail won't be flagged if it lacks a text label for colorblind users. 21 00:02:31,200 --> 00:02:37,920 Third reading order automation cannot guarantee screen readers navigate multi table layouts logically. 22 00:02:40,040 --> 00:02:45,040 Fourth hyperlinks it won't flag vague link text like click here. 23 00:02:46,960 --> 00:02:54,360 Reaching full wcaG 2.1 compliance to achieve complete wcaG 2.1 AA compliance. 24 00:02:55,280 --> 00:02:57,400 Combine Grackle with a manual human audit. 25 00:02:58,800 --> 00:03:06,320 Step one resolve grackle errors by clearing all red x's, defining table headers and adding missing alt text. 26 00:03:07,960 --> 00:03:13,280 Step two human quality review ensure alt text describes chart data. 27 00:03:14,040 --> 00:03:20,850 Add explicit text labels alongside color coded cells and rewrite URLs with descriptive link text. 28 00:03:22,570 --> 00:03:25,330 Step three screen reader and keyboard audit. 29 00:03:26,370 --> 00:03:34,130 Turn on VoiceOver or Nvda and navigate using only tab and arrow keys to ensure data cells read smoothly and logically. 30 00:03:35,330 --> 00:03:39,210 Q3 Project Status Audit assignee has filter dropdown. 31 00:03:39,810 --> 00:03:45,970 B1 status has filter drop down. C1 completion percent has filter drop down has percent column type. 32 00:03:46,250 --> 00:03:56,690 D1 resource link has filter drop down E1. Financial reconciliation A2 Alex B2 fail action required C2 45% d2. 33 00:03:57,250 --> 00:04:04,090 View Q3 full financial audit report has formula has link E2 application Q3 task completion rates. 34 00:04:04,370 --> 00:04:09,610 Bar chart displaying Q3 task completion rates. Full data is detailed in the table above. 35 00:04:10,290 --> 00:04:15,490 For additional guidance and resources, please visit. Accessibility. 36 00:04:25,330 --> 00:04:25,330 Accessibility.