Elementary grammar resources for Microsoft Excel and for ESL-EFL-ELL

Digital Mystery Pictures // Synonyms & Antonyms // No Prep // Distance Learning

Created by

Teaching in a Small Town

These 4 activities are paperless, no prep, and self-checking saving you time and money! No more grading papers or hoping students are correcting answers as you go over a worksheet. Using Google Sheets, students type their answers into a cell. If their answer is correct, the cell will change colors, the word will disappear from the word bank, and part of the mystery picture will appear. If not, the cell will remain white. It happens automatically! These are great for reading centers! The followi

Subjects:

Grades:

2nd - 3rd

Also included in: Digital Mystery Pictures // Google Classroom // Distance Learning

[Grade 1] CKLA Skills Assessment Tracker (Unit 2)

Created by

This Excel tracker for CKLA Skills Grade 1 Unit 2 gathers and synthesizes all the data from the three end-of-unit assessments. Three parts that help you make sense of the scores:Tracker will color-code the scores into remediation, near mastery, and mastery.Dashboard will show you pie-chart percentages of the whole class on all three tests.Student Report is a one-page snapshot of one student's scores at a time. Included in the zip file are a blank tracker and then a sample with made-up scores all

Subjects:

Grades:

1st

Types:

EFL - ESL - ELD, English Language Arts, World Language

CCSS:

RL.1.1

, RF.1.3b

, RF.1.4a

, L.1.1b

K-5 ENL Progress Monitoring Checklist - by class/grade *WIDA**ENLData Tracking

Created by

The ELL Collaborative

Grades K-5This resource provides educators with checklist to monitor all ENL students' progress in one place. It uses goals based on the WIDA Can Do Descriptors, and organized by grade level, to determine what to focus on with each student. This resource can be shared with classroom teachers to define clear expectations of language development at each level. The WIDA Can Do Descriptors include reading, writing, speaking, and listening tasks. They are separated into three groups of tasks: Kinder

Subjects:

Grades:

K - 5th

Types:

Assessment, Printables

Also included in: K-12 ENL Data Tracking/Progress Monitor/Snapshot/Records Complete Bundle

[Grade 1] CKLA Skills UNIT 4 ASSESSMENT BUNDLE!

Created by

*TWO* Excel trackers for Grade 1 CKLA Skills assessments in Unit 4: ~ Mid-Year/End-of-Unit-4 Assessments~ Word Reading in Isolation AssessmentIf you've ever used one of my trackers before, know that I just keep getting better and better! ;) I've learned so many cool tricks to move from a basic color-coded spreadsheet that counts totals to an interactive graph-creating, report-generating machine! Up next: Unit 5, and then I'll go back and improve all the past ones!Note: As mentioned in the WRIA

Subjects:

Grades:

1st

Types:

CCSS:

RI.1.1

, RF.1.3

, L.1.1c

, L.1.1e

[Grade 4] CKLA Beginning-of-Year Assessment Tracker (Unit 1)

Created by

*Major update, September 2021: 30 students, greater functionality, AND an individual student report page!*This is an Excel workbook that will help you track and analyze the results of CKLA Grade 4, Unit 1 assessments. The beginning-of-year tests include 3 reading comprehension selections, one grammar and one morphology assessment, an extensive 65-word Word Reading in Isolation test (see my separate tracker for this in detail!), plus a fluency passage. Whew!In this zip file are two PDFs (the asse

Subjects:

Grades:

4th

Types:

CCSS:

RL.4.1

, RI.4.1

, RF.4.3

, L.4.3

, L.4.4

...

[Grade 2] CKLA Skills Assessment Tracker (Unit 3)

Created by

This is an Excel or Google Sheets workbook for tracking the assessment results from Grade 2 CKLA Skills, Unit 3.*MAJOR UPDATE ALERT!!!* I'm slowly but surely updating old and new trackers to have all the same features. Added in version 2.0 of this tracker:Excel AND Google Sheets versions!Rather than a single file download, you'll get a PDF with a link to my Google Drive folder, where you can download the Excel file or make a copy of the Google Sheets doc. I'm hoping this eliminates any problems

Subjects:

Grades:

2nd

Types:

CCSS:

RL.2.1

, RF.2.3

, L.2.3

English READING Checklist Level 1 Victorian Curriculum/Australian Curric 'I Can'

Created by

OZClassroom Hacks

Level 1 Reading & Viewing Checklist aligned with the Victorian Curriculum. Fed up with recreating new checklists - ME TOO! Hope this helps. Here is a checklist completely aligned with the Victorian Curriculum/Australian Curriculum, with 'I Can' statements breaking down each achievement standard. I can statements - AS YOU WOULD TEACH IT! Enjoy! *These checklist comments can be copied and pasted directly into your Compass/Accelorus etc databank to be used in reports, reporting in easy to unde

Subjects:

Grades:

PreK - 4th

Types:

Assessment, Printables

[Grade 2] CKLA Skills Assessment Tracker (Unit 4)

Created by

*BRAND NEW!!!* This is an Excel and/or Google Sheets workbook for tracking the end-of-unit assessment results from CKLA Skills, Grade 2, Unit 4. It works for either first or second edition of CKLA.* Collect and analyze results of all four unit assessments easily and efficiently!What you get:A PDF with a link to my Google Drive folder (rather than a single file to download), where you can download the Excel file or make a copy of the Google Sheets doc. (I'm hoping this eliminates any problems wit

Subjects:

Grades:

2nd

Types:

CCSS:

RL.2.1

, RF.2.3

, RF.2.3b

, RF.2.3e

, RF.2.3f

...

[Grade 1] CKLA Skills Assessment Tracker (Unit 5)

Created by

This *Google Sheets* spreadsheet helps you enter, score, and analyze results from the Grade 1, Unit 5 assessments for CKLA Skills. This tracker works for both first edition and second edition of Skills. (If you're needing an Excel version, please drop me a line and I'll prioritize it!)The Unit 5 assessments are Word Recognition (spelling alternatives 'tch', 'wr', 've', 'ge', and 'g') and Grammar (nouns, verbs, sentence expansion with adjectives and locations, noun endings, and verb endings). For

Subjects:

Grades:

1st

Types:

English Language Arts, Grammar, Writing

CCSS:

RF.1.3b

, RF.1.3e

, L.1.1b

, L.1.2b

, L.1.4c

English WRITING Checklist Level 1 Victorian Curriculum/Australian Curric 'I Can'

Created by

OZClassroom Hacks

Level 1 Writing Checklist aligned with the Victorian Curriculum. Fed up with recreating new checklists - ME TOO! Hope this helps. Here is a checklist completely aligned with the Victorian Curriculum/Australian Curriculum, with 'I Can' statements breaking down each achievement standard. Enjoy!

Subjects:

Grades:

PreK - 3rd

Types:

Assessment, Printables

Special Education Accommodations Spreadsheet

Created by

Biology and Sped

An easy, organized way to keep track of your caseload students' special education accommodations. Change the headers to match the most frequent accommodations utilized by your students. Easily keep track of which students have a 504 plan or need ESOL accommodations. Can't remember who has read aloud? Simply open up this file and you'll know in a heartbeat.

Subjects:

EFL - ESL - ELD, For All Subjects, Special Education

Grades:

PreK - 12th, Staff

[Grade 4] CKLA Mid-Year Assessment Tracker (Unit 5)

Created by

Included here are Excel and Google Sheets workbooks for tracking the assessment results from Grade 4 CKLA, the mid-year assessments in Unit 5. Featuring:FIVE Tracker tabs in which you enter Xs or total scores for the Unit 5 tests: Reading Comprehension, Grammar, Morphology, Word Reading in Isolation, and Fluency. (For this document, you enter only a total score for Word Reading in Assessment. If you want a super detailed tracker for that assessment, I've got that too!)A Whole-Class Summary page

Subjects:

Grades:

4th

Types:

CCSS:

RF.4.3

, RF.4.4

, L.4.2

Possessive Nouns Game Cards

Created by

Christine Estabrook

5 Excel sheets/36 game cards. Player must choose and/or spell the correct singular, plural, or irregular plural possessive for each card. You may use the cards with a gameboard or alone. Suggestions are included. Cards are editable & answer cards were made so that they photocopy perfectly on the backs on the question cards. I re-uploaded the cards since one person said they could not see all cards.

Subjects:

Grammar, Writing

Grades:

4th - 7th, Adult Education

Types:

Activities

[Grade 3] CKLA Mid-Year Assessment Tracker (Unit 6)

Created by

Here is an Excel spreadsheet for collecting and analyzing the results of the Mid-Year Assessment for Grade 3 CKLA - Unit 6. This unit has four tests - Silent Reading, Grammar, Morphology, and Word Reading in Isolation - that will give you a snapshot of student skills at the half-year. This tracker does color-coding, rearranging based on skills, and graphs, all automatic. A fun feature is the Student Report, which gives you a one-page printable view of how each student performed on all the tests.

Subjects:

Grades:

3rd

Types:

CCSS:

RL.3.1

, RL.3.2

, RI.3.1

, RI.3.2

, RF.3.3

...

Digital Mystery Pictures // Contractions // Google Classroom //Distance Learning

Created by

Teaching in a Small Town

These 5 activities are paperless, no prep, and self-checking saving you time and money! No more grading papers or hoping students are correcting answers as you go over a worksheet. Using Google Sheets, students type their answers into Column B. If their answer is correct, the cell will turn green and part of the mystery picture will appear. If not, it will remain white. It happens automatically. These are great for reading centers!The following activities are included:Students will break apart c

Subjects:

Grades:

1st - 3rd

CCSS:

L.2.2c

Also included in: Digital Mystery Pictures // Google Classroom // Distance Learning

[Grade 1] CKLA Skills Assessment Tracker (Unit 4 + Mid-Year)

Created by

This Excel spreadsheet helps you enter, score, and analyze results from the Grade 1, Unit 4 assessments for CKLA Skills (both the regular end-of-unit tests and the mid-year benchmarks). This tracker works for both first edition and second edition of Skills. The Unit 4 assessments are Dictation and Grammar. Students spell words you dictate, demonstrating their ability to match sounds and spellings for r-controlled vowels, and they identify nouns, verbs, and contractions in a written test. I've se

Subjects:

Grades:

1st

Types:

CCSS:

RI.1.1

, RF.1.3

, L.1.1b

, L.1.1c

, L.1.1e

Also included in: [Grade 1] CKLA Skills *UNIT 4 ASSESSMENT BUNDLE*!

Grammar Self-Checking Google Sheet Bundle 3rd-5th Grade

Created by

Literacytales

Grammar Self-Checking Google Sheet Bundle 3rd-5th Grade! Reinforce plural nouns, prefixes, beginning digraphs, parts of speech, and Thanksgiving vocabulary. This Grammar Self-Checking Google Sheet Bundle includes a variety of self-checking activities that cover all the essential grammar topics, from parts of speech to punctuation. This bundle is designed to make your teaching life easier, save you time, and empower your students. Review, practice, or assess students in these Grammar skills: Plu

Subjects:

Grades:

2nd - 5th

Types:

Activities

[Grade 5] CKLA Beginning-of-Year Assessment Tracker (Unit 1)

Created by

This is an Excel workbook that will help you track and analyze the results of CKLA Grade 5, Unit 1 assessments. The beginning-of-year tests include 3 reading comprehension selections, one grammar and one morphology assessment, an extensive 65-word Word Reading in Isolation test (see my separate tracker for this in detail!), plus a fluency passage. Whew! After you get through the 3+ days of assessment at the start of the year, use this document to help you keep track of all 5 test results, get so

Subjects:

Grades:

5th

Types:

Mairghread's Marvellous Mix

CCSS:

RL.5.1

, RL.5.2

, RL.5.10

, RI.5.1

, RI.5.2

...

Customizable Labels for Wilson Fundations Level 1 Kit

Created by

The Wilson Fundations Level 1 kit is an incredible resource with an OVERWHELMING number of small items in every kit! The kits are expensive and inevitably a word card will be borrowed by a teacher, fall behind a bookshelf, or just need to be put away in the right spot for yourself or colleagues next year!Maybe you even have a shared kit among multiple teachers in your building and you need to keep the inventory and items well labelled so nothing goes to waste!With this file, you can customize yo

Subjects:

EFL - ESL - ELD, English Language Arts, Phonics

Grades:

1st

Types:

Teacher Manuals, Professional Documents

WIDA ACCESS Test Tracker

Created by

Practical ESL Teacher

This is a great resource to keep track of testing all of your students on the WIDA ACCESS for ELLs Test. Keep track of when students complete each domain and also a column to easily see who has completed all sections.This is an electronic Google Sheet but it also prints beautifully. I print it and use it by hand and then update my electronic Google Sheet at the end of each day of testing.The sheets are organized by grade level, K-5, 6-8, and 9-12. That is just what has worked best for me but if

Subjects:

EFL - ESL - ELD, ELA Test Prep, Professional Development

Grades:

K - 12th

Types:

Printables, Graphic Organizers

EXCEL Progress Monitoring: Goals, Benchmarks, Graphs, Aim Lines & Trend Lines

Created by

kacy collins

This progress monitoring Excel program allows the user to progress monitor for an entire year. The user is able to rename tabs and copy and paste new tabs. Tabs -Goal -Benchmark (up to 3 Benchmarks) -Benchmark (up to 8 Benchmarks) *EACH tab includes: -name -date -score -1 graph -automatic trendline for each data point on the graph -an automatic average for a goal or each benchmark -moveable aim line and baseline (NOTES: User must move baseline and aim line to match student data) -progress

Subjects:

Classroom Management, EFL - ESL - ELD

Grades:

PreK - 12th, Adult Education

Types:

Assessment, Lesson

3rd Grade McGraw Hill Wonders Curriculum Map

Created by

Little Human Resources

Overview of the McGraw Hill Wonders reading program for 3rd Grade. includes: Stories, Genre, Vocabulary Words, Vocabulary Strategy, Spelling pattern, Comprehension strategy, writing focus, and grammar. It's an excel file so you can go in and add your own teaching dates. *When printing make sure to scale to page

Subjects:

English Language Arts, Grammar, Informational Text

Grades:

3rd

Types:

Lesson

Grade 2 Skills Strand Units 1-6 Assessment Excel Templates

Created by

Under the Big Top

Grade 2 Skills Strand Units 1-6 Assessment Excel TemplatesI have created 6 Excel Templates that will allow you to better track your students' growth and progress in the Skills Strand Units. Each unit is on own tab, making it easy to organize and find. All the units are set to the CKLA benchmarks, though can be adjusted to your classroom needs. Simple add your name, your students' and their scores. The rows will change color based on the students' scores, making it easy to identify students who m

Subjects:

Grades:

1st - 3rd

Types: