views
DISCLAIMER: The information on this site is presented on an "as is" basis, and does not claim to present definitive information, make recommendation or to represent such official bodies such as the Standard Celeration Society. Users of this site agree that the owner of the site or authors of pages and articles are indemnified against legal liability
To view/save page as pdf
To return to Precision Teaching wiki
EXCEL CHARTING TEMPLATES--Stuart Harder, Owen White, Scott Born
For other examples of Excel Charting templates, see Old/Other Charting Templates
Other: MS Excel Standard Charting Template_v5 (xls) (486 KB)
Found at Owen White's website--EDSPE Classroom Measurement and Management
IMPORTANT NOTES about the templates--Please READ BEFORE downloading.
Stu Harder has given permission for users to email him questions about the templates. I'm sure that if you don't have questions, that a note of thanks would be appreciated :-). THANK YOU STU!
Incompatibilities
Please note
* the file name of the template, ex: SCCFB_dcpm_v7_1,
* the version of Excel that you are using, ex: Excel 2003,
* the operating system of your computer, ex: Windows XP, ex: MacOS 8, and
* SPECIFIC problems with the template, ex: "Excel shuts down", or "can't open file with "corrupted file" message", etc.
This helps Stu to figure out what might be the problem, and helps me when I recheck the posted file. Thanks!
The Excel Charting templates are NOT compatible with OpenOffice Calc, and will not perform or chart correctly if used with that application. This is due to incompatibilities in visual basic language used in the macro programming of OpenOffice vs. Microsoft applications
4/30/08 Updated templates with fix to median-slope calculation
Posted to SCListserv 4/29/08
From Stu Harder,
"...Version 7-3 of the daily per minute, daily per day, weekly per week,
monthly per month, yearly per year, and stacked dots daily per minute
are all upgraded with the fix. I also updated a routine users may not
have known about. This routine removes the connecting lines between
data points that border phase change lines. To remove connecting lines,
invoke Control+Shift+K (Windows) or Command+Option+Shift+K (Mac). To
reverse the process, invoke Control+Shift+J (Windows) and
Command+Option+Shift+J (Mac). Be sure to do this before removing phase
lines as the the program needs to know where to look for the
disconnected data points. I will post these new versions to the list,
one at a time."
4/30/08 SCCFB dcpd v7-3.xls; Daily Count per Day v7-3
Top
BETA-version: Daily Count per Minute with options SCCFB_dcpm_v7_2a.
6/24/07 This file checked and should be working properly. RGCF
6/22/07
Please right-click and SAVE file
Daily Count per Minute with options
SCCFB_dcpm_v7_2a.xls (2.2 MB)
COMMENTS AND TECHNICAL NOTES ON THIS TEMPLATE
Updated Stacked Dots, NOW Multiple Frequencies SCCFB_mf__dcpm_v6_0b
7/11/07 Scale corrected. There may be test data in the template. Clear before using
6/27/07 This file appears to work properly, but there is a scale problem in that the left-hand counts per minute are not aligned correctly with the right-hand counting time scale the chart. 'Sent an email to Stu about this. Thanks to Bob Worsham for catching this.
Please right-click and SAVE file
Updated Stacked Dots Chart,NOW Multiple Frequencies daily counts per minute
SCCFB_mf__dcpm_v6_0b-1.xls (4.09 MB)
COMMENTS AND TECHNICAL NOTES ON THIS TEMPLATE
Daily Count per Minute SCCFB_dcpm_v7_1
6/14/07
Please right-click and SAVE file
Daily Count per Minute
SCCFB_dcpm_v7_1.xls (2.1 MB)
COMMENTS AND TECHNICAL NOTES ON THIS TEMPLATE
(like a Dpmin-11DC DAILY per minute chart)
Daily Count per Day SCCFB_dcpd_v7_1
Please right-click and SAVE file
Daily Count per day
SCCFB_dcpd_v7_1.xls (2.1 MB)
(like a Dpday-2EC DAILY per day)
Weekly Count per Week SCCFB_wcpw_v7_1
6/14/07
Please right-click and SAVE file
Weekly Count per Week
SCCFB_wcpw_v7_1.xls (2.1 MB)
(like a [Wpwk-3EC WEEKLY per week)
Monthly Count per Month SCCFB_mcpm_v7_1
6/14/07
Please right-click and SAVE file
Monthly Count per Month
SCCFB_mcpm_v7_1.xls (2.1 MB)
(like a Mpmon-3EC MONTHLY per month)
Yearly Count per Year 1-1,000,000 SCCFB_ycpy_1__v7_1
6/14/07
Please right-click and SAVE file
Yearly Count per Year. 1-1,000,000
SCCFB_ycpy_1__v7_1.xls (2.0 MB)
To display yearly counts where zero counts are not anticipated. This template is scaled from 1 to 1,000,000.
(like a YC-1EN YEARLY per year)
Yearly Count per Year 0.1-100,000 SCCFB_ycpy_v7_1
6/14/07
Please right-click and SAVE file
Yearly Count per Year. 0.1-100,000
SCCFB_ycpy_v7_1.xls (2.0 MB)
Based on a six-cycle scale of .1 to 100,000. Use this template to display data with zero-count years as the template will place zero counts just below the record floor. (The record floor is usually set at 1.0 unless partial data years are present)
2/8/08
4/25/08
Page Information
|
Wiki Information |
Recent PBwiki Blog Posts |
Create your own educational wiki!