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

As staff members throughout School District 21 begin preparing for the coming school year, lots of time is spent in calendars marking down important events for students, parents, and ourselves.

Of course, all staff members benefit from using your Exchange calendar. Staff members with laptop or desktop computers assigned to them individually can benefit from using Entourage or Outlook as their Exchange applications, and all staff members can also access their Exchange accounts via webmail.ccsd21.org. These calendars are great for sharing with one another and creating meetings in efficient ways that the majority of participants can attend because their schedules have been pre-checked for availability. To learn more about the specific features of the calendars in Outlook 2007 and Entourage 2008

While the calendars in Entourage and Outlook are great for productivity and keeping organized as a professional, these calendars are not designed for specific publication in newsletters or for distribution to parents and students.

So, how do I create a calendar for students and parents?

Microsoft Office 2008 comes with pre-created templates built right-in, and these are a great way to get started in a variety of projects. Included among these are templates for building calendars as pictured below.

Tags: Excel

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