By Diane Brauner on March 16, 2022
These blog links support the AT Technology Skills Scope and Sequence Chart for K-5 students using an iPad with VoiceOver. The AT Technology Skills Scope and Sequence Chart has been aligned with the elementary school portion of the Common Core State Standards K-12 Technology Skills Scope and Sequence.
The AT Scope and Sequence for K-5 is broken down into these areas:
- Basic Operations (See AT Technology Skills Scope and Sequence: Tech Lessons 1)
- Word Processing (See AT Technology Skills Scope and Sequence: Tech Lessons 2)
- Spreadsheet (Tables, Charts and Graphs)
- Multimedia and Presentation Tools
- Acceptable Use, Copyright and Plagiarism
- Additional Assistive Technology Skills
This post, Tech Lessons 3, will focus on supplemental resources for Spreadsheet (Tables, Charts and Graphs). On the iPad, there are two commonly used spreadsheet apps: Google Sheets or Apple's Numbers.
The numbers beside the links to these lessons/strategies posts represent a specific AT Scope and Sequence Skill. This document lists the third skill area called Spreadsheet (Tables, Charts and Graphs). Some skills (such as Using Mathematical Symbols) may not have associated posts. Some posts will fall under multiple areas and may be repeated in this document. This is a living document, meaning that new links will be available as more posts are published.
Skill #1: Demonstrate an understanding of the spreadsheet as a tool to record, organize and graph information.
- Navigating Google Sheets with JAWS: Artic Lesson (Excellent spreadsheet example using animal facts instead of numbers; spreadsheet content and activity can be recreated on the iPad with Numbers or Google Sheets)
Skill #2: Identify and explain terms and concepts related to spreadsheets (i.e. cell, column, row, values, labels, chart, graph)
- Be exposed to pre-requisite skills: Rows, columns and simple grids (tactile then tactile paired with digital)
- Be exposed to and create tactile charts and graphs (Introduce in K)
- Transition from tactile charts and graphs to digital charts and graphs (Introduce in K)
- Use BTK and braille display commands to navigate by row or column (Introduce in 1st)
Resources for Skill #2
Pre-requisite skills and strategies:
- Tech Standards: Why Teach Digital Concepts Early?
- Using Tech to Develop Critical Thinking Skills (developing critical thinking skills for young student using drag gesture in a row, sequencing, etc. Prerequisite skills for grids and spreadsheets)
- Spatial Tech Standards 2: Rows (activities with manipulatives, tactile graphics and digital rows, including drag gesture in a straight line)
- Introducing Accessible Digital Grid and Table
- Digital Transitions #2: Math Grid
- Digital Transitions #4: Bar Charts (Fall Leaf Activity)
Apps that incorporate rows, grids, and/or tables:
- APH Accessible Crossword Puzzle App: Review
- Ballyland Code 1: Say Hello (iOS app) (3 apps in this series which have grid formats)
- Ballyland Sound Memory Game: Matching and Math Grids
- Blindfold 3D Tic Tac Toe
- Blindfold Sea Battle: Accessible iOS Battleship Game that Reinforces Grid Concepts
- Blindfold Tic Tac Toe: Digital Math Grid
- Code and Go robot Mouse Activities & APH tactile Graphics (physical grid paired with tactile grids)
-
CodeQuest: A Free APH App!
- Teaching the CodeQuest App to Students Who Are Visually Impaired (Note: Tactile Graphics and 3D printer files are available for CodeQuest)
- Halloween Suduko Puzzle: Grids and Tables
- Halloween Suduko Puzzle Part 2: Tactile Graphics
- Math Melodies: iOS App (multiple math-related games with rows, columns and grids)
- Tactile to Digital Part 1: Math Robot
- Tactile to Digital Part 2: Math Melodies (includes progression of tactile graphics/digital graphics skills)
- Tactile to Digital Part 4: Positions in a Table
- Tactile to Digital Part 5: Addition and Subtraction
Creating accessible grids and tables:
- Creating a accessible bar chart in the Pages App: iOS 11
- Digital Transitions #4: Bar Charts (Fall Leaf Activity) (manipulatives, tactile and digital; includes how to create an accessible bar chart in Pages and how to access the bar chart with VoiceOver videos)
- Egg Idioms: Tech Activities (table)
- Google Docs Table Activities: Warm/Cold-Blooded Animals
- Halloween Suduko Puzzle: Grids and Tables (includes hot to create the grid in Pages and how to navigate the grid with VoiceOver)
- Teaching Positions in a Table: iOS Activity (includes how to create accessible digital grids with stickers)
