Over the years, there has been significant effort on the part of students and teachers throughout School District 21 to create authentic instructional opportunities for students, and in many cases recently, these have come in the form of student podcasts. Previous posts on The Modern Pen have commented on podcasting or provided information for podcasting workshops. These posts include:

- Tools for 21st Century Learning-February 2009
- Podcasting Workshop-August 2007
- What’s a Podcast?-August 2007

As we continue to evolve in our use of podcasting, we have more tools available to teachers and students than ever before with which they can produce such podcasts. These include staff laptops and both the iMac and Mac Mini computer labs as well as directly on to devices such as iPods and iPod Touches.

The following article from the International Society for Technology in Education (ISTE) makes connections between the National Educational Technology Standards and podcasting in the classroom.



Links to actual podcasts recorded in District 21 include:
* Teacher Reflections on Podcasting (Staff)
- Administrators’ Ideas about Relevant Schools (Staff)
- New Staff Members Commit to Relevance (Staff)
- Cooper MS 8th Grade Alcohol Podcasts (Students)
- London MS 7th Grade Immigration Podcasts (Students)
- An Understanding of Marketing (Students) (Names are pseudonyms.)
- Binge Drinking and the Brain (Students)

For teachers wanting to learn more about podcasting, here is another useful podcast to listen to as a resource for learning more about what can be done during a podcast--including the use of sound effects!
- Chicago Public Radio/NPR Re-Sound

Directions for Podcasting with GarageBand

AtomicLearning.com GarageBand Tutorials

Tags: Podcast, Classroom Instruction, Students

Like being a star athlete, a great singer, or a super-effective classroom teacher, there are very important fundamentals that must be followed in order for one to be successful in any of these fields. Often times, these fundamentals are completely transparent to observers, except for the most expert. The same is actually true of the use of spreadsheets. While PC Mag has acknowledged that mastering Microsoft Excel can take years, some very basic fundamentals make an enormous difference in what can be accomplished with a spreadsheet.

Some important rules for successful spreadsheet use include:

Working Environment

• Spreadsheets on Screen--Spreadsheets are designed to be used on a computer. It’s not to say that we never print spreadsheets because we do at times, but 99% of the time, we work with a spreadsheet in the most efficient manner on the computer rather than for how it will look for printing.
• Normal View--Always use Normal View (View > Normal) for data entry and manipulation.
• Toolbars--Select View > Toolbars > Standard & View > Toolbars > Formatting. Most importantly, also select View > Formula Bar, which will show you exactly what is really in each cell as you select it.
• Workbooks & Worksheets--Don’t be afraid to use multiple worksheets within a single workbook. Label them carefully.

Layout

• Columns & Rows--Columns are for data fields/variables. Rows are for records.
• Header Row--Row 1 should always be used as a header row. Headers should be short and descriptive. Each column should have a header.Depending on the spreadsheet’s purpose and audience, headers may be free of spaces.
• Align Data within Columns--Whether it is left-aligned, centered, or right-aligned, depends on the data in the column, but all data within a column should be aligned.
• Separate Distinct Data--It’s not difficult to split data in to separate columns from a single column (i.e., split “last, first” to two columns--“last name” and “first name”), but it’s even easier to push data together from separate columns in to a single column (i.e., from “last name” and “first name” to “last, first”.) So, keep separate data separate from the start.

Content

• Grab Starting Data from Elsewhere--Teachers, support staff, and administrators all have the ability to export data from PowerSchool. Get your IDs, Names, etc. from there!
• Student IDs--ALWAYS use student id numbers for each student when collecting data on students. Typically ID numbers will fill Column A or Column B.
• Use Columns/Fields for Categorizing, Not Colors--People like to organize their spreadsheets by color. This is fine. Do not only organize by color. Rather than represent a category within a spreadsheet by color-coding cells, use a new column, create the proper field, and categorize that. Data can then be sorted, counted, analyzed using that.

Tips

• Use a Mouse and/or Tab and/or Return--When doing significant and/or extended work in Excel use a wired mouse plugged in to your laptop to make work more efficient. Better yet, for data entry, use the Tab key to move to the next cell to the right in a row and the Return key to move the next cell down in a column.
• Right-Click--When you “right-click” in Excel a contextual menu will pop up with a number of options that you can apply to the selected cell, column, or row.
• Plan Ahead--Before beginning to work in your spreadsheet, consider what fields you are going to use, how your records are going to be used, etc. This will help you visualize how your schedule ought to be laid out and will make your organization of rows and columns much easier.

Tags: Excel

Even with great tools, such as the PowerTeacher Gradebook and Inform, spreadsheets remain the most critical of tools for success in collecting and analyzing student data. Whether we are collecting data before uploading it to Inform or we are exporting it from the Gradebook to graph, spreadsheets are used to systematically collect, sort, manipulate, and analyze data. Currently, School District 21 does utilize Microsoft Office. Staff members who are using Windows PCs are typically using Office 2007 as we begin our transition to the new Office 2010. Staff members who are using Macs are using Office 2008.

AtomicLearning.com (which requires a username and password) features great tutorials on Excel 2008. These tutorials are broken up in to three different sections of tutorials:

• Intro (76 tutorials)
• Intermediate (86 tutorials)
• Advanced (85 tutorials)

That’s right! There are a total of 247 tutorials on AtomicLearning.com about Microsoft Excel 2008 alone!

In addition to all of the resources in AtomicLearning.com, there is also built-in support available right in the application itself. Microsoft, like Apple, has included a lot of information to provide help and support to end users right on the desktop from within the application itself. Simply select Help from the Menu Bar at the top of the screen as pictured below.



Either enter your search terms in the Search text field or select Excel Help from the menu and then search for more information.

“But wait, there’s more!” The Microsoft Office for Mac website also has great resources for learning more about how to use Office products, include Excel 2008.
Microsoft.com/Mac Office 2008 How-To Courses

Tags: Excel, AtomicLearning

One of the most powerful, easy-to-use tools for newcomers and advanced users to Microsoft Excel is the AutoFilter. The AutoFilter allows you to quickly and easily sort and or select certain data from either a pull-down menu or by custom defining your search criteria. Enabling the AutoFilter is as simple as clicking on AutoFilter in the Data > Filter > AutoFilter menu command from the Menu Bar as pictured above. Once the AutoFilter is enabled, you will see arrows in the header row of each column on the right side of the column as pictured below.



By simply clicking on the arrow, it will open up a new menu as pictured below.



Choosing from this menu, will allow you to only see the rows, or records, that you have selected. Choosing the Custom Filter option will allow you to specify exactly what data you would like to see. For example, you could choose to see all students who scored a 90 or higher on a particular assessment. While your other data will appear missing, it will really still be there. It is just hidden--or filtered out.

When you have filtered a column, the arrows in that columns header will appear blue. To unfilter, simply choose the Select All option from the pull-down at the top of that column, and all of your data will re-appear.

Simply by following our steps for entering data using Excel best practices and by using the AutoFilter, you can uncover all kinds of very important information about your students!

Tags: Excel

Over the past year, on multiple occasions, we have offered a workshop helping CCSD21 staff members develop more effective presentations than those traditionally that have been developed, particularly professional presentations given to other adults, such as for a workshop or a Curriculum Night. Many of the important tips, which are also captured in this Modern Pen post, are also well defined by these two older blog posts that were identified on the web by Longfellow Learning Coach Catherine Joy and Tarkington Learning Coach Tracy Crowley. For more information on a good presentation that is not overwhelmed by the wrong colors on your slides or the use of too many different words visit:

- Learning from Bill Gates & Steve Jobs

- Gates, Jobs, & the Zen aesthetic

An abridged version of the Professional Presentations workshop was held after school on April 10, 2008. A longer, work-focused version of this workshop will be held in August 2008 prior to the start of the 2008-2009 school year.

In addition to the materials that were shared during the presentation, the following links provide useful information about creating the best possible professional presentations for parents and other educators. (These links do take you off of the School District 21 website and include commercial advertisements.)

- Before You Create a PowerPoint Presentation
- 8 Secrets to a Knockout Business Presentation
- The Seven Deadly Sins of Powerpoint (sic) Presentations
- Creating Effective PowerPoint Presentations

Also, remember, School District 21 teachers and students can use AtomicLearning.com for great screencasts on many specific topics in PowerPoint 2004. If you need the user name or password, please see your school's iTech teacher.

Some useful websites to gain further insights in to what others are doing with podcasts in schools near and far...

Deerfield School District 109’s Blog

Education Podcast Network

Podcasting Links from the PiNet Digital Library

Podcasts from The Downs CE Primary School (UK)

The Tech Teachers Show Notes

Check out a really helpful little video (3.5 minutes long) from CommonCraft that explains what an RSS feed is!


Also, please make sure you know a bit about Copyright law and Fair Use in the United States and in Illinois.

With Apple's GarageBand software, on all of the white Mac Minis in our computer labs, it is very, very easy to make a podcast. Yet, many of us wonder what a podcast is and what better way to learn more about podcasting then to listen to a podcast!?!

Download the podcast now!

Under the Fair Use provisions of U.S. Copyright law, students can use quite a bit of copyright material within typical projects. Of course, should be taught to cite this material, and likewise, this also provides a teachable moment to help students understand that they cannot take the same liberties for most purposes throughout the rest of their lives--an important lesson in a world in which intellectual property is sacred due to its value in our Information Age. The four major factors that are considered in determining fair use are:

1. the purpose and character of the use, including whether such use is of commercial nature or is for nonprofit educational purposes;

2. the nature of the copyrighted work;

3. amount and substantiality of the portion used in relation to the copyrighted work as a whole; and

4. the effect of the use upon the potential market for or value of the copyrighted work.

Often times, people are given rules of thumb, such as “x number of lines can be used from an author’s work” or that one can “use x number of seconds from a song.” The fact is that Copyright law and Fair Use are not that simple and concrete. As a result, educated decisions must be made about what is and is not appropriate.

For more information on Fair Use and Copyright, visit the Fair Use website from OurMedia, as well as the links on that page.

In this class, we explore the following topics:

iPhoto--Importing photos from cameras and websites, editing photos, slideshows

iTunes--Learning about iTunes and the iTunes Store, putting music into iTunes, using music from iTunes in other applications

Comic Life--Importing and manipulating photos to demonstrate deeper understanding

The following websites will be needed during this lesson:
http://news.bbc.co.uk/2/hi/americas/6941917.stm
http://news.bbc.co.uk/2/hi/americas/6938461.stm
http://www.msnbc.msn.com/id/20186211/site/newsweek/
http://www.msnbc.msn.com/id/20121788/site/newsweek/