Film Review Template Date Seg Seg Title 09 01 03 1 How Chicago by elx18731

VIEWS: 160 PAGES: 19

More Info
									Date              Seg       Seg Title

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1 How Chicago Rocked the Sixties

       09/01/03         1   How Chicago Rocked the Sixties
       09/01/03         2   Interview: Dick Biondi
       09/01/03         2   Interview: Dick Biondi
       09/02/03         1   Return to School
       09/02/03         1   Return to School

       09/02/03         2 Chicago Crain's Stories
       09/02/03         3 Window on the West

       09/02/03         4 Chicago Stories: Loepold & Lowe

       09/02/03         4 Chicago Stories: Loepold & Lowe

       09/02/03         4 Chicago Stories: Loepold & Lowe
                          Word of Mouth: Film Review: The
       09/02/03         5 Battle of Shaker Heights
                          Word of Mouth: Film Review: The
       09/02/03         5 Battle of Shaker Heights
                          Word of Mouth: Film Review: The
       09/02/03         5 Battle of Shaker Heights
                          Word of Mouth: Film Review: The
       09/02/03         5 Battle of Shaker Heights
                          Word of Mouth: Film Review: The
       09/02/03         5 Battle of Shaker Heights
                          Word of Mouth: Film Review: The
       09/02/03         5 Battle of Shaker Heights
                          Word of Mouth: Film Review: The
       09/02/03         5 Battle of Shaker Heights
09/02/03   6 Melissa Pinney Photography
Guest Name       Occ. Descr.                      Topic

                 Music Store owner                Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

                 Musician                         Entertainment/Lifestyle

Herb Kent        DJ                               Entertainment/Lifestyle
Dick Biondi                                       Entertainment/Lifestyle
Brian Lamb       CEO C-SPAN                       Entertainment/Lifestyle
Arne Duncan      CEO Chicago Public Schools       Loc/City Politics/Elections
Debra Lynch                                       Loc/City Politics/Elections
                 Managing Editor: Crain's Chicago
Judith Crown     Business                         Business Econ. News
Judith Barter    Art Institute Rep.               Entertainment/Lifestyle

John Logan       Playwright                       Crime

Ron Grossman     Sun-Times writer                 Crime

Leila Weinberg   Clarence Darrow Biographer       Crime

John Landecker   DJ                               Entertainment/Lifestyle

Anon.                                             Entertainment/Lifestyle

Anon.                                             Entertainment/Lifestyle

Anon.                                             Entertainment/Lifestyle

Anon.                                             Entertainment/Lifestyle

Anon.                                             Entertainment/Lifestyle

Anon.                                             Entertainment/Lifestyle
Melissa Pinney   Artist   Entertainment/Lifestyle
Race   Gender   Party

W      M

W      M

W      M

W      M

W      M

W      M

W      M

W      M

W      M

W      M

W      M

B      M
W      M
W      M
W      M
W      F

W      F
W      F

W      M

W      M

W      F

W      M

B      M

W      F

W      F

W      F

W      M

W      M
W   F
Occupation

Corp. Rep.

Prf. Oth.

Prf. Oth.

Prf. Oth.

Prf. Oth.

Prf. Oth.

Prf. Oth.

Prf. Oth.

Prf. Oth.

Prf. Oth.

Prf. Oth.

Prf. Media
Prf. Media
Corp. Rep.
Gov. Off
Labor Rep.

Prf. Media
CD

Prf. Oth.

Prf. Media

Prf. Oth.

Prf. Media

CD

CD

CD

CD

CD

CD
Prf. Oth.
                                   Total number of
Topic                                 Segments             %
Entertainment/Lifestyle                          5              63%            8
Loc/City Politics/Elections                      1              13%            8
Sports                                           0               0%            8
Business Econ. News                              1              13%            8
Nat/State Pol/Elc /FP                            0               0%            8
Ill/State Pol/Elc                                0               0%            8
Health/Science                                   0               0%            8
Week in Review                                   0               0%            8
Crime                                            1              13%            8
Weather/Disaster                                 0               0%            8
Media                                            0               0%            8
Religion                                         0               0%            8
                  Total Segments                 8             100%




Ent + Sports                                     5               63%


INSTRUCTIONS: To format this page for correct results, see instructions on worksheet 'TopicsFilter'
Date      Seg       Topic
 09/01/03       1   Entertainment/Lifestyle
 09/01/03       2   Entertainment/Lifestyle
 09/02/03       1   Loc/City Politics/Elections
 09/02/03       2   Business Econ. News
 09/02/03       3   Entertainment/Lifestyle
 09/02/03       4   Crime
 09/02/03       5   Entertainment/Lifestyle
 09/02/03       6   Entertainment/Lifestyle
Instructions:
1. Copy and Paste into the first three columns on this sheet: from worksheet
Data: Date, Seg, and Topic.
2. Select All Three Columns (date, seg, topic) and Filter Data as follows:
Data > Filter > Advanced Filter > Unique Records Only
3. Go to worksheet 'TopicsFilterValue'
Date              Seg       Topic
       9/1/2003         1   Entertainment/Lifestyle
       9/1/2003         2   Entertainment/Lifestyle
       9/2/2003         1   Loc/City Politics/Elections
       9/2/2003         2   Business Econ. News
       9/2/2003         3   Entertainment/Lifestyle
       9/2/2003         4   Crime
       9/2/2003         5   Entertainment/Lifestyle
       9/2/2003         6   Entertainment/Lifestyle
Instructions (from 'TopicsFilter'):
4. Right-Click cell A1
5. Select Paste Special from the dropdown menu
6. Check the box 'Values' and hit 'ok'
7. Worksheet 'TopicCounter' should now show correct
results.
   Race of Guests         Total    Percent Matching
                         Guests    of Total Code
White                           27    93.1% W
Black                            2     6.9% B
Can't Determine                  0     0.0% CD
Latino                           0     0.0% L
Asian/Asian American             0     0.0% As
Arab/Arab American               0     0.0% Ar
Native American                  0     0.0% Na
          Total Guests          29  100.0%
  Gender of Guests        Total    Percent Matching
                         Guests    of Total Code
Male                            21    72.4% M
Female                           8    27.6% F
Can't Determine                  0     0.0% CD
          Total Guests          29  100.0%
                                               Total   Percent of
Occupation                                    Guests     Total      Matching Code
Government Official (Elected
Official/Government
Employee/Appointee)                             0         0%             G
Corporate Representative (CEO or
other management, PR person, etc.)              0         0%             CR

Professional (Religious leaders,
Lawyer/Judge, Stock Broker, Medical
Doctor, Pro Athlete, Actors, Writers, etc.)     0         0%             PR
Academic                                        0         0%             A
Media (Journalist, editor, anchor)              0         0%             M
Labor Representative (union official or
spokesperson, rank and file worker)             0         0%             L
Public Interest Representative
(representatives of anti-war groups,
women’s groups, community groups,
civil rights organizations, etc.)               0         0%             PI
Citizen Activist (a source appearing as a
representative of an activist group or as
part of a demonstration or protest)             0         0%             C
Public (a source appearing unaffiliated to
their occupation or specialized skills; a
source appearing as a representative of
the general public)                             0         0%              P
Other                                           0         0%             O
Can’t Determine                                 7        100%            CD
                              Total Guests      7        100%

								
To top