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.