Docstoc

Sample Tally Sheet (Excel)

Document Sample
Sample Tally Sheet (Excel) Powered By Docstoc
					Sample Tally Sheet

Question #2, What are your three favorite TV Programs? TV Programs Listed Female Male

Instructions for Tally Sheets

Sample Tally Sheet For questions like 2, which ask the students to list their 3 favorite TV shows, the use of a tally sheet may prove helpful in calculating the top ten list for boys and the top ten list for girls. The tally sheet provides a way to list all of the titles and to keep track of gender preferences for those titles. To use a tally sheet, simply create a spreadsheet with three columns. In the first column, list all of the TV programs, or book titles, or magazine titles that students list in response to questions like #2, 5, 7, 10, 21. The second and third columns are to record responses from females and males. You can print off the tally sheet and have the students record hatch marks manually.

Assistance: If you have any questions, or would like to discuss the tally sheets, please contace: Phyllis Bernt Telephone: 740-593-0020 Email: bernt@ohio.edu

Instructions for data entry

You may find it useful to print out these instructions for future use. DATA Sheet Template The data sheet template is an excel file for the input of results from the student surveys. The results from each completed survey become a record in the excel file. Once the student surveys are completed, they should be numbered consecutively (starting with #1); this number becomes the record number The template is set up for data to be entered down the columns, with each column containing the results of one survey. The left hand column of the template (Column A) lists the survey questions. Column A has been frozen, so each of the other columns can be positioned next to it for easier data entry. Some things to keep in mind during data entry are the following: 1. Each column will contain the results of only one completed survey. 2. To avoid mistakes, one survey at a time should be entered into the spreadsheet. It would be helpful to save the work often. To save, click on File on the toolbar, and select the Save option. 3. The number assigned to the survey when the completed surveys are numbered consecutively should be entered as the record number. 4. The template has been set up so that the person doing data entry only has to put an "x" in the appropriate cell, corresponding to the survey answer. For example, if the student who did the survey checked "never" when asked how often he or she watched videos, then the data entry person should place an "x" in the spreadsheet cell next to "never" under question No. 4. 5. The survey contains a few open-ended questions. For example, question No. 2 asks students to list their three favorite TV shows, while No. 19 asks students why they prefer the web or books when doing research. The template is set up so that the data entry person types in whatever the students wrote on the survey. Questions 26-30: These questions will vary by school. If you have decided to add your own questions 26 through 30 to the survey, you can add those questions to Column A of the template. To keep things simple for data entry purposes, configure the questions in Column A so that the data entry person only has to place an "x" in a cell, or, for openended questions, only has to type in exactly what the students write in response to the questions. Sorting and Generating Totals The joy of spreadsheets is that information can be sorted. For example, if you want to sort data by gender, you can do the following: 1. Highlight the whole spreadsheet 2. Click on Data on the toolbar 3. Select Sort 4. When the Sort menu appears, click on "my list has a header row." This will assure that Column A is not included in the sort, only the data entered in the rows will be sorted. 5. On the Sort menu, click on Options. When the Options dialogue box appears, choose "sort from left to right" under Orientation. This selection is what assures that the sorting will be done by rows (not by columns). 6. Close the dialogue box and you are back at the Sort menu, which will prompt you to choose the Row by which you wish to sort the data. To sort by gender, select either Row 120 or Row 121. If you sort by Row 120, the data will be sorted with the surveys completed by females appearing first. If you select Row 121, the data will be sorted with the surveys completed by males appearing first. Since the students will be entering an "x" into the appropriate cell, instead of a numeric value, in order to tabulate totals you will need to use the "COUNTIF" function instead of the SUM function. For example, assume that the students have entered the raw data from 20 completed surveys. This means that they will have populated columns B through U. Now, if they want to calculate the number of times students responded that they watched TV every day, they would do the following: 1. Note that responses about watching TV every day are entered in Row 3.

Instructions for data entry

2. Note that the formulas to count occurences will have to appear in Column V (since Columns B through U will contain data) 3. In Cell V3, write the formula =COUNTIF(B3:U3, "x") This formula will count the number of x's appearing in Row 3, and will therefore count the number of student responses of "every day" to the question about TV Printing Instructions To print the spreadsheet, click on the top left chell (Column A1 which says, Record#) and then drag across and down to select the cells you want to print off (they will probably be the cell with data). The selected cells should become highlighted. Next, click on File on the toolbar. Choose Print Area, then select Set Print Area. If you set the print area, only those cells with data in them will be printed.

Phyllis Bernt Telephone 740-593-0020 Email: bernt@ohio.edu

Instructions for data entry

If you want to print the spreadsheet, click with the cross mark on the Record# cell (top left), and drag across and down to select the cells with data entered. (Area selected should be shaded.) Choose: File> Print Area> Set Print Area. This way you can avoid printing pages that have no data.

Data Entry Template Student Survey Record # 1. TV Questions every day several times a week about once a week sometimes never 1 x x 2 x 3 x 4 x 5 x x x 6 7 x 8 9

2. 1st favorite TV show

54321

one on one 106 and park

lizzie mcguire

hbo

simpsons

friends

simpsons

judgement day

2nd favorite TV show

rent tv

all that

starz

sister sister eliminate even stevens

oz

activities

3rd favorite TV show 3. Movie Questions every day several times a week about once a week sometimes never 4. Video Questions every day several times a week about once a week sometimes never 5. 1st favorite movie/video 2nd favorite movie/video

7

rap city

charmed

pfv

my wife and kids hbo

fighting

x x x x

x x x x x

x x x

x x

x

x x x

like mike undercover brother

lotr kiss of the dragon

8 mile

maid in manhattan

8 mile

pretty in pink scarface

mr. deeds

empire

enough

old school

grease

selena

empire

Data Entry Template Student Survey

3rd favorite movie/video 6. Magazine Questions every day several times a week about once a week sometimes never

7 ice age

carmen

halloween

hot chick

wedding planner

spiderman

x x x x x x car and driver people sporting teen people news source x x x

7. 1st favorite magazine

17 pop cosmo

cosmo gumbo

2nd favorite magazine 4 wheel skateboardi ng 3rd favorite magazine magazines 8. Newspaper Questions every day several times a week about once a week x sometimes never Favorite newspaper section

si for kids game informer

vibe

people

lifetime

game pro

x

x

x x funnies, horoscopes

x x entertainme nt x x

sports

comics

sports

9. Currently reading book yes no x

x x x x x x x x

Data Entry Template Student Survey

Title of current book read treasure island

the valentine ate my teacher

10. 1st favorite book

dirt bikes

bfce

real teens the valentine ate my teacher

foot book

2nd favorite book

cars

selena

three musketeers seventh tower

matrix

3rd favorite book 11. Favorite Biography yes no

sports

teen four x

foster's war x

spiderman

x

x

x

x

x

x

x

Title of biography 12. Check books out of school library every day several times a week about once a week sometimes never 13. Check books out of public library every day several times a week about once a week sometimes never 14. Computer at home yes no

selena

anne frank

x x x x x x x

x x

x x x x x x x x x x x x x x x x x x

Data Entry Template Student Survey

Room computer is in? 15. Web connection at home (yes/no) yes no 16. Web use at home every day several times a week about once a week sometimes never 17. Web use at school every day several times a week about once a week sometimes never 18. Web use at public library every day several times a week about once a week sometimes never 19. Web or book preference for research web book

my room

my room

play room

living room

living room

family room living room

x

x

x

x x

x

x

x

x

x x x

x

x

x x x

x

x x x x

x x x x

x

x x x x x x x x x

x

x

x

x

x

x

x

x

Why?

easier

faster

faster

faster

I don't like to read from books faster

easier

BOTH, because then I get a lot more information

easier for the bibliography

Data Entry Template Student Survey 20. Most frequent computer use chat email games music research for school word processing

x x x x x x x

x x x

x x x

x

x x x

x

x

other 21. Careers or jobs that interest students 1st career working cars teacher fbi

dictionary

cbs sportsline.co m pictures

lawyer

football pro basketball pro

doctor pediatrician rapper music producer

football player

mailman

2nd career

U.S. army

police officer hair dresser mosel

actress

lawyer

teacher

3rd career 22. Information sources about jobs family member friend public library school counselor school library teacher web sites other 23. Grade six (6) seven (7)

air force

fireman

doctor

singer

lawyer

vet

music director

union

cook

x

x

x x x

x x

x

x x x

x x

x

x x

x x

x x

x x x x x x x x

x

x

x

x

x

x

x

x

x

Data Entry Template Student Survey eight (8) 24. Gender female male NR 25. Ethnicity Black Hispanic Native American White Asian x x x x x x x x x

x x x x x x x x x

Other NR 26. Type of music you like most? Choose one hip hop rap r&b pop latin alternative rock other 27. How often do you play video games? every day several times a week about once a week x x x x x x freestyle x x x x x x x x x

x x

Data Entry Template Student Survey sometimes never 28. Three favorite video games? madden 2003 grand theft auto x

1 driver 2 nba live 2 2003

lynx

halo

marvel vs capcon 2 sonic the hedgehog 2

zelda crupson world (?)

tecen dead or alive 3

3 nba 2k2 29. How often do you use a cell phone? every day several times a week x about once a week sometimes never

donkey nba live kong (64) smack down shut your tony hawk mouth pro skater

spiderman

x x

x x x x

x

x

30. Favorite hobbies or activities in your free time? play video games read books collect things x surf the web play sports x

x x x x volleyball, basketball talk on the phone chat with friends x football, basketball x x

x

x

x x basketball, football like to play with fire

which ones? other

basketball

Data Entry Template Student Survey 10 x x x 11 12 x x 13 14 x 15 x 16 x 17 x 18 x 19 x 20

one on one

simpsons

bet

simpsons king of the 24 hill

american idol

yu-gi-oh

simpsons

simpsons malcolm in the middle

news

yu-gi-oh

south park

parkers

king of the hill

7th heaven

malcolm in jackie chan the middle martin lawrence king of the hill

bet movies channel

simpsons that '70s show

simpsons

simpsons

106 and park

saved by the 65 bell simpsons

yu-gi-oh

man show

x x x x x

x x x x x x

x

x x x x x x x

x x x

barbershop next Friday

Friday

brown sugar the luau

romeo must clock die stoppers

8 mile

scary movie 2 half baked

hot boyz

how high

8 mile

like mike

men in black 2 like mike

harry potter 1 ring

jason x

scary movie

Data Entry Template Student Survey

3 strikes

baby boy

titans

under cover brother baby boy

lethal weapon 4

harry potter scary 2 movies

next Friday

ring

x x x source awards gumbo x x x x

x

x x x

word up j-14

jet

si si for kids

teen j-14

si scope

Beckett YuGi-Oh! Collector word up nick teens

scoop si

twist

eastbay

x x x x x x x x cartoons, games, trivia x x x

comics

cartoons

sports

sports

sports

sports

x x

x x

x

x

x

x

x x x

Data Entry Template Student Survey

harry potter chamber of secrets

harry potter goosebump s

house on hackman's hill

Goosebump wishbone go s - attack of harry potter home the mutant 3 assata goosebump harry potter books 1 assata

goosebumps

wishbone

harry potter

foster's war

harry potter michael jordan x

harry potter 2 fly girl harry potter 3 hush x x a child called it

hot cars all about rockets

world war II x x x x x

x

x

x

all mario

assata

x

x x x x

x x x x

x x

x x

x x x x x x x x x x x x x x x

x

x

x

x

x

Data Entry Template Student Survey

my room

living room

computer room

living room

my room

dining room my room

guest room

my room

kitchen, dining room

x

x

x

x

x x

x

x

x

x

x

x

x

x

x x x

x

x

x

x

x

x

x

x x x

x

x

x x

x x

x x x x x x x x x x x

x

x

x

x

x

x

x

x

x

x

x

it's fun

faster, better info

faster

easier

easier

has everything

because you don't got to read more info

faster, more info more info

more info, fun

Data Entry Template Student Survey

x x x x x x x x x x x x x x x x

x x x x x x x x x x

x x x

doctor

teacher

teacher

electrician

nursing

artist

singer

accountant

lawyer

police

building cars ITT hair styling Journal Sentinal [Milwaukee make cars newspaper] designer

rapping

lawyer bodyguard for the president

engineer

doctor football pediatrician player

football player

suntman

vet

construction boxer

selling cards

celebrity

scientist

basketball player

fbi agent

x

x x x x x x

x x x x x

x x

x

x

x x

x

x x

x x x x x x x x

x

x x

x

x

x

x

x

x

x

x

x

x

x

Data Entry Template Student Survey

x x x x

x x x x

x x x

x x x

x x

x

x

x

black, hispanic, native american x

black, white

x x x x x x x x x x x x x

x

rock

x x x

x

x

x x

Data Entry Template Student Survey x x x x

shooting game fighting game

grand theft auto 3

grand theft auto 3

basketball

street hoops spiderman grand theft auto turismo kingdom 3 hearts

metal gear desert storm solid 2 stuntman smack down shut your grand turism max payne mouth 3 grand theft auto vice simpsons smugglers city road rage run 2

takon 3 race car games

yu-gi-oh forbidden memories WFL blitz 2003

007 agent under fire

nba street

sims

tony hulk final fantasy proskater 4 7

x x

x x x

x x

x x x

x

x

x

x x x x

x x

x basketball, football

x x

x x basketball, football x

x x

x x x

basketball

football

basketball movies, mall, hang with friends

football

be with family or friends

football snow ball fights, "chill"

Data Entry Template Student Survey 21 22 x x x x 23 24 x 25 x 26 x 27 x 28 x 29 x 30 x 31

mtv rap countdown

wife and kids

scratch and burn simpsons cetric the entertainer

half and half my wife and american (upn) kids idol that's so raven

7th heaven

that's so scooby doo raven lizzie mcguire

moesha

mtv trl mtv music videos

7th heaven just shoot me

spongebob

er

bernie mac

zoom

spongebob

hugles (upn) george lopez show

videos

bernie mac

angel

steve harvey show one on one

half and half one on one

x x x x x x x x x x x

x x x x x x

x x

x

x x

empire

one

smile

smiles

matrix interview with a vampire

signs

ring

all about the benjamins scream scary movie 2 revenge

Korean movies

serving sarah

Friday after next lotr 2

8 mile bringing down the barbershop house

barbershop queen of the damned

Data Entry Template Student Survey

down to earth

dumb and dumber

rock da boat

lotr 3 minority report x x

what's the worse that nerd no can happen more

like mike

halloween

like mike

x x x

x x x

x x x

source

eastbay

17 si teen vogue jet

people celebrities

ym m

si

gumbo people

teen people si

b-14 (?)

si for kids

slam

gumbo

word up

x x x x x x x x x x x

comics

comics

comics

x x x x

x

x x

x

x

x

x

Data Entry Template Student Survey

over the edge maniac mcgee over the edge night of the living dummiew

numbering the stars

outsiders bailey school kiks

hatchet

freeze tag

outsiders

what anne frank happened to baby sitters diary of a Jennie club young girl matilda series of don't look unfortunate behind you ghost writer events matilda 10 things I goosebump hate about s you chicken soup x x x martin luther king jr anne frank

harry potter

month of 7 brian's story days numbering the stars

fosters war

witch child

stuart little

harry potter nerd no goblet of fire more harry potter chamber of secrets spiderman

pomes book (poems?) lotr

x

x

x

x

x

x

x

x x

x x x x x

x x

x

x

x x x x x x x x x x x x x x x x x x x x x x

Data Entry Template Student Survey my room, living room, dining room attic

living room

basement

my room

computer room

x x x

x x

x

x

x

x

x x

x x x x x x x x x x x x x x

x

x

x

x

x x x

x

x x x x x x

x x

x

x x

x x

x

x x

x

x

x

x

x

web is messy, books are very easy

faster

more info

better

easier

faster

BOTH

easier

more info

gives information you need

faster

Data Entry Template Student Survey

x x x x x x x x x x x x x

x x x x x

x x x x x x x x x

everything

real estate

teacher

actress

basketball

child psychology

lawyer basketball player

music/ameri can idol teacher actor/movie s doctor

singer

lawyer

teacher

landscaping nurse

lawyer

football

nursing

teacher

astronomer nurse

writing

doctor

doctor

lawyer

realitist (?)

psychologist

day care

nurse for kids

police officer secretary

x

x x

x x

x

x x x

x x

x x

x x

x x x x x x x

x x x x x x x x x x x x

x

x

x

x

x

x

x

x

x

x

x

x

Data Entry Template Student Survey

x x

x x

x x x

x

x

x

x

x

x x x

x x

x

black, native black, american hispanic

black, hispanic, white, indian black, (india) hispanic

x x x x x x x

x x x x x x eveything x x x x

x x x

peres rageA (?)

x x x x

x

x

Data Entry Template Student Survey x x x x x

final fantasy iq metal gear said 2

grand theft auto 3 grand theft auto vice city mortal combat

nba 2k3

zelda

grand theft auto vice city

grand theft auto

nfl 2k3 madden 2003

mario cart

nba live 203 mortal combat

lotr nba street james bond agent under nba fire courtside smackdown four

mortal combat luigi mansion

Suikoden III

sejco 2 (?)

x

x

x x

x x

x

x

x x x

x x x x I like going outside (fighting) x soccer, football, dodgeball listen to music x x soccer, football x

x

x x x x baseball, basketball

x

x x x

x

basketball

basketball singing, art play on the computer

x x volleyball, basketball, softball chat with friends

Data Entry Template Student Survey 32 x x 33 x x 34 35 x 36 x 37 x 38 x 39 x 40 x 41 x 42

simpsons american idol

hbo

everwood

all that that '70s show

dragon ballz

spongebob real world eliminate/ fresh prince dismissed

bet comedy central

simpsons american idol

mail call

surbia [?] everybody loves raymond

all dragonball z, gt, af

bernie mac show cetric the entertainer

south park

x

charmed

yu-gi-oh

simpsons

road rule

yu-gi-oh

digimon (all seasons) hugleys

x x

x x x

x x x x x x

x x

x x

x

x x x

x x x

I miss you by Aaliyah bad company

xxx

ring

she's all that signs

xxx lotr two towers

Friday after minority next report

ring

mr. deeds

cradle 2 grave fast and furious

any given pearl harbor Sunday

mr. deeds

how high

lilo a& stitch lion king

digimon

Data Entry Template Student Survey

queen of the damned barbershop resident evil

halloween movies (H20 & band of resurrection) brothers

xxx

barbershop like mike

bruce lee

Friday after next

x x x x x sporting news espn x x time for kids dinisar [?] fighting magazines slam bruce lee mazines xxx japanese anime x x x

glamour 17

scope teens

becket lowrider

gumbo

pop

cars

si

source

x x x x

x

x x x x x x

comics

sports

comics

horoscope, funnies

funnies

be kool

action

sports

x x x

x

x x

x

x x

x x

Data Entry Template Student Survey

teenage soul 3 harry potter the goblet of fire

face on the milk carton

seventh tower seventh tower

army book marines book

holes

child called it harry potter series harry potter

bruce lee fighting method

holes

teenage soul 3 chicken soup for the kids soul 2

secret garden

navy book

Bible

arthur

white fang x

child called it series king x x michael jordan Incomplete # 11-20 x

x

x

x

x

x

x

bruce lee

x x x

x

x x x

x x x

x x x x x x x x

x

x

x x x x x x x

x

x

x

Data Entry Template Student Survey living room, sister, brother hallway

my room

closet

my room

my room

my room

dining room

my room

x

x

x

x

x

x

x

x

x

x

x x x x

x

x

x x

x

x

x x x x x x

x

x x

x

x x x x x x x x x x

x x

x

x

x BOTH because they both have different answers

x

x x

x

more info

it's tight like that easier

easier to understand

easier

easier

more info

it's hard to find on the web

more info

Data Entry Template Student Survey

x x x

x

x x x

x x x

x x x

x x x x x x

x x x

x x x x x x x

how to fight, break dance, video game codes sports

teacher

nba major league

teacher

dea agent

lawyer

teacher

MDonanadl security/ e [?] bouncer machine type

basketball player

singer

vet

fbi agent

judge

actress

movie star/fighting football

doctor

scientist

cia agent

basketball player

computer work

mercenary rapper

x x

x x x

x

x x x x x x x

x x

x

x x

x

x

x x

x x

x x

x x

x

x

x

x

x

x

x

x

x

x

x

x

Data Entry Template Student Survey

x x x

x

x x x

x x x x

x x

x x

x

x

x

x

mixed

hispanic, white

Indian

x x x x x x x x x x x x x

x x

x x

x

x x

x

x

Data Entry Template Student Survey x x

streets

grand theft auto vice city

grand theft auto vice city devil may cry

crazy taxi

mario brothers

agent under fire getaway

spongebob

zelda

grand theft auto vice mba live moto city 2003 combat grand theft auto vice navy seals city mario cart

donkey knog country 2

kingdom hearts

nba live 2003

mario final fantasy racing cars 10 nba 2k3

tekken 4

nba street

mario party dead to 3 rights

nfl 2k3

ready to mario party rumble

bouncer

splinter cell

x x

x

x

x

x

x x x x x

x x x x

x

x

x football, basketball

x x x x x soccer, football

x x x x x x x

x

x x

basketball

basketball

basketball

basketball

soccer

basketball fighting

basketball watch tv

Data Entry Template Student Survey 43 x x 44 x 45 x 46 TOTALS 37 7 0 2 0

bet

steve harvey show

simpsons

wb

dragon direct effect ballz

upn

punk'd

family guy 0 8 11 27 0 17 13 13 3 0

x

x

x

x

x x x x

sweetest thing riding in cars with cat and dog boys like mike

he got game martin lawrence live

rush hour 2

black night

Data Entry Template Student Survey

bringing jack chang down the movies pootie tang house

drumline

x x

x x

2 6 7 21 9

teens scope

slam si

action

scope

x x x x

1 4 8 10 23

funnies

x x x x

22 23

Data Entry Template Student Survey

world war 2 beware of wolve help, I’m trapped in my lunch lady's body harry potter 1

harry potter 2

harry potter dummies 3 3 x x x x 10 34

koke bryant

x

x x x

0 0 17 24 4

x

x x x

0 7 4 16 18 39 6

x

x

x x

Data Entry Template Student Survey

my room

kitchen, living room my room

x x

x x

37 8 22 9 2 3 9 1 17 9 17 1

x x x x

x x x x

x x x

x

1 2 4 11 27

x x x

x

36 6

more info

more info

easier

more reliable

Data Entry Template Student Survey

x x x x x x x

x x x

x x

20 15 30 30 13 8

doctor

lawyer

nba movie producer

football

teacher

doctor

basketball

lawyer

actor

video game maker doctor

x

x

x x x x x x x x

x x x

x x

x x

27 16 10 9 6 15 33 25 0 46

x

x

x

x

Data Entry Template Student Survey 0

x

x x x

20 25 1 5 9 1 13 7

x

x x

black/India

10 1

8 x x x x 29 14 4 3 1 1

15 x x x 13 5

Data Entry Template Student Survey 10 x 3

nfl fever socom 2003 grand theft auto vice nfl blitz city 2002

tony hank 4

nba streets dragon ball z budokai

frenzy

nba 2k2

x x x x

18 5 9 9 5 0

x x x x x

x x x x kickball, football

16 9 6 20 32

500 jump rope


				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:382
posted:11/6/2009
language:English
pages:40