Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

I am trying to use a lot of Math, Equations, and Formulas in my course work. How do I make it accessible for all users.

\uD83D\uDCD8 Instructions

Most formulas and math equations come as floating objects. Such objects cannot be read by a screen reader and are therefore, inaccessible. To avoid inaccessible content being sent, we must find a more accessible solution for how to write our formulas.

Inaccessible Math Formula Area of a circle equals pi times r squared. Equation covers multiple cells.

This equation is a floating object and spreads out over multiple cells. This is inaccessible, and overall does not look presentable.

How to make an accessible floating object with a text alternative

  1. Type of formula in Cell A1. Only use regular text and no symbols.

    Area of a circle equals pi r squared now has a text version.

  2. Now change the Font Color to white to match the background.

Change Color Button in Excel.Mathematic Equation for the Area of a Circle covers multiple cells.

3. Resize cell A1 and fit your formula inside it. Now you have a formula with a text alternative.

The equation Area of a Circle equals pi r squared now fits in one cell.

You can use this method for many mathematical formulas, including expressions.

Simple Interest Formula and Compound Interest Formula written in their standard format.

The formulas a just typed in individual cells. This is inaccessible and would be very hard for a person using a screen reader to understand.

Simple Interest and Compound Interest formulas are written in individual cells.

The formula is now in one cell and all of the information is given with a text description.

Creating accessible math equations without floating objects

The best way to create an equation that is accessible is to type out the whole equation without symbols.

A table of formulas written as equations.

These equations are written out in the traditional way. Screen readers would not be able to read the equations the way they are written. This table is therefore, inaccessible to many readers.

A table of formulas written in full text.

These formulas are all written in text form. Now screen readers can read the information to the reader without too much risk of errors.

Guide to Excel Functions

Most Excel functions are accessible for readers, and can be read by both JAWS and NVDA. However, the software will only read the formula character by character. This process can take a long time to complete and can be very time consuming for the students. To avoid this issue, put a text name and abbreviation of the formula directly above the cell that contains the value output.

A table of sample data for sample standard deviation without an indicator.

This example shows a function calculating the sample standard deviation for some data. Though this is accessible, it does not contain the name of the function or abbreviation.

Example of Sample Standard Deviation data with an indicator.

This example shows a function with a name and abbreviation. This is the best way to display functions.

  • No labels