This adds one custom functon to your spreadsheet to calculate words correct per minute (WCPM) and percent accuracy for fluency tracking.
Listing updated:ā§§ā§§ āφāĻ—āĻ¸ā§āϟ, ⧍ā§Ļā§¨ā§Š
Works with:
⧍ā§Ģā§Ž
āĻāĻ• āύāϜāϰ⧇
When you track fluency, often a one-minute probe does not provide enough content to check for understanding.  In these cases, it is often helpful to time a full passage and use that time with words read and errors to compute Words Correct Per Minute (WCPM) and percent accuracy.  To do these calculations, you usually take the number or words read, less the errors and divide that by the time in minutes to get WCPM.  Use the power of Google Sheetsâ„ĸī¸ to do the calculations automatically and quickly!  For this to work, the function takes three inputs in the format: =WCPMandAccuracy(words,errors,"time") and gives you WCPM (in one cell) and percent accuracy (in the cell to the right). Please note that the time must be in the format "m:ss" using quotation marks and a colon to separate minutes from seconds.  If you point to or reference the time, the cell it is in must be formatted as Number>Plain text.  Please watch the video to see the custom function in action.  This function is especially useful for SpED or resource teachers, interventionists, and teachers of foundational reading.
Additional information
PricingāĻĢā§āϰāĻŋ
āĻ—ā§‹āĻĒāĻ¨ā§€ā§ŸāϤāĻž āύ⧀āϤāĻŋ
āĻĒāϰāĻŋāώ⧇āĻŦāĻžāϰ āĻļāĻ°ā§āϤāĻžāĻĻāĻŋ
āϰāĻŋāĻĒā§‹āĻ°ā§āϟ āĻ•āϰ⧁āύFlag as inappropriate
WCPM Custom Function will ask for the permissions shown below. Learn more
WCPM Custom Function will need access to your Google account
This will allow WCPM Custom Function to :
āϝ⧇ āĻ¸ā§āĻĒā§āϰ⧇āĻĄāĻļā§€āϟāϗ⧁āϞāĻŋāϰ āĻŽāĻ§ā§āϝ⧇ āĻāχ āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāĻžāύāϟāĻŋ āχāύāĻ¸ā§āϟāϞ āĻ•āϰāĻž āĻšā§Ÿā§‡āϛ⧇ āϤāĻžāĻĻ⧇āϰ āĻĻ⧇āϖ⧇ āĻ“ āĻĒāϰāĻŋāϚāĻžāϞāύāĻž āĻ•āϰ⧇
Google āĻāϰ āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāύ⧇āϰ āĻĒā§āϰāĻŽā§āĻĒāϟ āĻāĻŦāĻ‚ āϏāĻžāχāĻĄāĻŦāĻžāϰ⧇ āϤ⧃āĻ¤ā§€ā§Ÿ āĻĒāĻ•ā§āώ⧇āϰ āĻ“ā§Ÿā§‡āĻŦ āĻ•āĻ¨ā§āĻŸā§‡āĻ¨ā§āϟ āĻĻ⧇āĻ–āĻžā§Ÿ āĻāĻŦāĻ‚ āϚāĻžāϞāĻžā§Ÿ
āφāĻĒāύāĻžāϰ āĻĒā§āϰāĻžāĻĨāĻŽāĻŋāĻ• āχāĻŽā§‡āϞ āφāχāĻĄāĻŋ āĻĻ⧇āϖ⧁āύ
āφāĻĒāύāĻŋ āϏāĻ°ā§āĻŦāϜāύ⧀āύāĻ­āĻžāĻŦ⧇ āωāĻĒāϞāĻ­ā§āϝ āĻ•āϰ⧇āϛ⧇āύ āĻāĻŽāύ āϝ⧇āϕ⧋āύāĻ“ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āϏāĻš āφāĻĒāύāĻžāϰ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āĻĻ⧇āϖ⧇
āϰāĻŋāĻ­āĻŋāω
Language:
āĻāχ āĻ…āύ⧁āϝāĻžā§Ÿā§€ āϏāĻžāϜāĻžāύ:
Google āϰāĻŋāĻ­āĻŋāω āĻ“ āϰ⧇āϟāĻŋāĻ‚ āϝāĻžāϚāĻžāχ āĻ•āϰ⧇ āύāĻžāĨ¤ āϰāĻŋāĻ­āĻŋāω āϏāĻŽā§āĻĒāĻ°ā§āϕ⧇ āφāϰāĻ“ āϜāĻžāύ⧁āύ
No comments
āϏāĻžāĻ°ā§āϚ āĻ•āϰ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŽā§āϛ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŦāĻ¨ā§āϧ āĻ•āϰ⧁āύ
Google āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāĻžāύāϗ⧁āϞāĻŋ
āĻĒā§āϰāϧāĻžāύ āĻŽā§‡āύ⧁