|
- Target:
Spreadsheets - Being a team player in your newsroom's technology
'brain trust' This PowerPoint97 file serves two purposes.
(1) It overviews how news librarians can become more involved
in newsrooms as technology course designers/trainers. (2) It illustrates
how a simple PowerPoint presentation can be used as a self-paced,
step-by-step training module for a portion of the Excel Level
1 skills such as simple sorts; subtotals; percent of total; percent
change; and, autosum. Modify this presentation as you desire and
load it on a newsroom intranet or a stand-alone PC. The examples
are drawn from real beat-level stories and are universal in their
appeal. Submitted by Debbie
Wolfe, Technology training editor, St. Petersburg Times, St.
Petersburg, Fla.
|
 |
- The
"paste special" trick Excel's drawing toolbar
(View --> Toolbars --> Drawing) offers creative opportunities
to create short tip sheets for learning skills such as "Paste
Special." You can annotate a live spreadsheet with text, arrows
and colors. The student can read the narrative AND click on data
cells to inspect underlying formulas. Use this tip sheet as is
or as a model to create your own using local data. It can be used
for: self-paced learning, a handout in a group class, a reminder
reference tool on an intranet or a tip sheet for on-the-road journalists
(send it via e-mail). Submitted by Debbie
Wolfe.
- Excel
checklist (pdf)
From the "What Beat Journalists Need to Know Series." This tip
sheet details the skills journalists should know for Levels I
and II. Based on Microsoft Excel97, the list is designed to work
with older and newer versions of Excel. Use it as a checklist
to evaluate your own skills or as a sample lesson plan to create
a series of classes for your own newsroom. Skills are listed in
the same order as taught by Debbie
Wolfe.
- "How
I helped create the story" using Excel (pdf) Fla. Budget
Details - The first time the State of Florida budget was released
on the Web. This handout details the "play-by-play" of how a state-level
budget story was researched and written on deadline using Excel.
Two journalists collaborated using the interactive software known
as "VNC" first as a training tool and then to co-author the story.
The actual text of the published story follows the "play-by-play."
See related files: FL
budget graphic.jpg and Florida
State Budget.xls. Submitted by Debbie
Wolfe.
|
Page
last updated:
April 11, 2004
|
|
