Topic Presented: Social Networking Sites
Tasks
Member Name Part Presented Duration (min) 1. Populate all necessa
1 Brian Choe Background Information 2 presented, member nam
2 Jennie Tang Criticisms 2 present, how long each
3 Joyice Liu Advantages/Benefits 2
4 Tiffany Tsai Intro 3 2. Sort by Member Nam
5 Vivian Horng Opinion Piece 2
3. Change cells B4:D4
Total Presentation Length (min): 11
4. In cell D11, insert a f
length of your presenta
Presentation Distribution 5. CONDITIONALLY fo
red if the total length of
BETWEEN 10 and 12 m
18% 18% 6. Insert a pie chart tha
Background Information
presentation will be dist
Criticisms part presented). Name
Advantages/Benefits and place it under the d
18%
28% Intro
Opinion Piece
18%
1. Populate all necessary information (topic
presented, member names, what parts they will
present, how long each member will present for)
2. Sort by Member Name in ascending order.
3. Change cells B4:D4 and C11 to BOLD formatting
4. In cell D11, insert a formula that calculates the total
length of your presentation
5. CONDITIONALLY format cell D11 to display text as
red if the total length of the presentation is NOT
BETWEEN 10 and 12 minutes
6. Insert a pie chart that details the how the
presentation will be distributed (either by presenter or
part presented). Name it "Presentation Distribution"
and place it under the data
Topic Presented: C@CM
Member Name Part Presented Duration (min)
1 April Past/Current Topics Covered 2
2 Liang Successes & Criticisms of Program 2
3 Max Introduction 1.5
4 Minwoo Future Plans/Initiatives 1.5
5 Nancy History/Creation of C@CM 2.5
Total Presentation Length (min): 9.5
Presentation Distribution
Past/Current Past/Current Topics Covered
History/Creation
of C@CM Topics Covered
Successes & Criticisms of Program
Introduction
Successes &
Criticisms of Future Plans/Initiatives
Future
Program
Plans/Initiatives
Introduction History/Creation of C@CM
Tasks
1. Populate all necessary information (topic
presented, member names, what parts they will
present, how long each member will present for)
2. Sort by Member Name in ascending order.
3. Change cells B4:D4 and C11 to BOLD formatting
4. In cell D11, insert a formula that calculates the total
length of your presentation
5. CONDITIONALLY format cell D11 to display text as
red if the total length of the presentation is NOT
BETWEEN 10 and 12 minutes
6. Insert a pie chart that details the how the
presentation will be distributed (either by presenter or
part presented). Name it "Presentation Distribution"
and place it under the data