This year I’m continuing to serve as a parent volunteer with our speech and debate team at Classen School of Advanced Studies in Oklahoma City. Last semester I ‘made the digital switch’ and started flowing all cross examination (CX) debate rounds on my laptop instead of using legal pads. I’ve seen some different ways people are using Microsoft Excel to keep flows. For the tournament this weekend at Norman High, I’m using an Apple laptop which has Numbers (part of iWork ’09) installed on it instead of Excel for MS Office. I created a CX debate flow template for Numbers ’09 and based it on other flows I’ve seen people use. The fixed header rows for speeches are ‘frozen’ so they persist when scrolling, and I set the cell contents to “fit” so they expand when more text is entered than will fit on one line in a column. Download it from my public Dropbox with this link: wfryer.me/cxflow. I also exported an Excel version, but I haven’t tested it so if you use it please let me know how it works. Download the MS Excel version from my Public Dropbox using: wfryer.me/cxflow2.
Changing the cell formatting to wrap and fit was a little different from what I’ve done previously in Excel. There, as I recall I just right-clicked / control-clicked on a cell and then turned on “wrap.” For Numbers, it’s necessary to use the inspector panel and click the button “fit” next to row height.
If you use either of these CX debate flow templates and find them helpful, please let me know with a tweet or comment. Also, if you prefer a different format for flowing CX rounds using a digital spreadsheet please let me know about it. I definitely like transitioning to digital/green debate round flowing, but I’m also open to any suggestions for better ways to do it.
I used the Apple Support article “Displaying Content Too Large for Its Cell” to figure out the wrap/fit steps.
If you enjoyed this post and found it useful, consider subscribing to Wes' free, weekly newsletter. Generally Wes shares a new edition on Monday mornings, and it includes a TIP, a TOOL, a TEXT (article to read) and a TUTORIAL video. You can also check out past editions of Wes' newsletter online free!
Did you know Wes has published several eBooks and "eBook singles?" 1 of them is available free! Check them out! Also visit Wes' subscription-based tutorial VIDEO library supporting technology integrating teachers worldwide! MORE WAYS TO LEARN WITH WES: Do you use a smartphone or tablet? Subscribe to Wes' free magazine "iReading" on Flipboard! Follow Dr. Wesley Fryer on Twitter (@wfryer), Facebook and Google+. Also "like" Wes' Facebook page for "Speed of Creativity Learning". Don't miss Wesley's latest technology integration project, "Show With Media: What Do You Want to CREATE Today?"
On this day..
- American Revolution Videos from Schoolhouse Rock and Discovery United Streaming - 2014
- Hacker Cases Highlight Need for Greater Personal Account and Information Security - 2014
- Teach Your Students to be Digital Artists (and learn from Kevin Honeycutt) - 2012
- Blog comment moderation: How and Why? - 2010
- Crescent Public Schools: The Eyes of Oklahoma Are Upon You! - 2010
- Present at OSSBA in August 2010 - 2010
- eDiscovery requirements and archiving student email - 2010
- iPhone iTalk Application: A Great Event Recorder - 2009
- Comparing Broadband USB Options for Laptops - 2009
- Podcast224: An Interview with Patrick Henry - 2008