New User Special Price Expires in

Let's log you in.

Sign in with Facebook


Don't have a StudySoup account? Create one here!


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

Computers in Educ

by: Christ Blanda I

Computers in Educ EDU 180T

Christ Blanda I
GPA 3.86


Almost Ready


These notes were just uploaded, and will be ready to view shortly.

Purchase these notes here, or revisit this page.

Either way, we'll remind you when they're ready :)

Preview These Notes for FREE

Get a free preview of these Notes, just enter your email below.

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

Class Notes
25 ?




Popular in Course

Popular in Education and Teacher Studies

This 13 page Class Notes was uploaded by Christ Blanda I on Wednesday September 9, 2015. The Class Notes belongs to EDU 180T at University of California - Davis taught by Staff in Fall. Since its upload, it has received 46 views. For similar materials see /class/191958/edu-180t-university-of-california-davis in Education and Teacher Studies at University of California - Davis.

Similar to EDU 180T at UCD

Popular in Education and Teacher Studies


Reviews for Computers in Educ


Report this Material


What is Karma?


Karma is the currency of StudySoup.

You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 09/09/15
The SpreadsheeLNign 7 1mm bene t from the use of a spreadsheem we W111 look at three uses 1 Creaung a form wah Charis for the PACT comext 3 Ammygmdebook Using Excel m create quick chzm fur yuur PACT cuntexl 1 Place the cursor m the cell whae you want the Lad w begm and type Enghsh Leamevs 7 Enghsh Speakevs ym m m u m We between gt the two cells where the Lad oval A E gt Lad ms 4 Ema the values Quest er How many studems m ma dass an Enghsh Learners 3 Enghsh Speakevs 27 aebellmgg ucdams edu p 1 um 5 Usmg the mouse seleet the table headmgs and values Quesnun 5 Huw many students H1012 c ass are E Enghsh Learners En hsh s eakers 27 6 chek oh the chartwuardmon 7 Seleet the Pie Chan and then the pamculartype fPle Chan you want 8 Next your way through the wizard uhtu you get to step 3 Detehmme 1fyou want the eouhts or percentage duplayed ubellmg ucdawsenh p 2 en 9 Select nish 10 Place the chart where you want it on the page Engrrsrr Learners 3 Er tsh Speakers 21 arererr Learners Mm mrerr Sneakers 9m NOTE You can copy and paste the chart into another document ifyou wish 11 Create any remaining charts In this example in step 3 the legend was turned offquot and the data label is showing category name Value and percentage rrenmme mnvrmrn srp3nr4 rrmnpuarr allxl El em a E m m ln 5 rr r NOTE You can play around with the Various menu options ifyou wish Grimm rr m aebellmggQucdavisxdu p 3 of13 1 Enter the narnes ofyour respondents down the column 2 Extherkey their responses to avalue 1 ans ease 5 7 strongly agree 4 7 agree etc to sr g1e word m this ease yes and noquot 3 Underme narnes create headmgs to tabulate are results Respundent Quesunm Quesunnz Quesunn 3 QuestmnA Ahce 5 5 1 yes Hub 5 nu cm A 3 1 yes Ted 3 1 1 yes s1mng1y agree a ree nemra1 msagree s1mng1y msagree yes rm 0 4 Use the count1fquot functionto eounnne number of people who had eaen answer Chck where you Want me first sum Type counuf Respundem Quesnnn 1 Questmn 2 Que Ahce 5 5 Hub 5 3 Caru A 3 2d 3 1 sunng1yagree canth 39122 nemra1 msagree sunngw msagree yes nu rebeurngggucamseen p Ann T n h k quota whxle holdmg down they mouse button seleet all the eells m the row Respundem Questmnz r Ahce 5 Hub 3 Carat 3 t strungty agree cuunWBE 89 a ree COUNnFrzngemt2na neutrat arsagree strengty msagree yes rm 6 Cohahue by ehtenhg a1ue you are compilingquot andthen and enter s rungty agree 2 agree rrautrar aeagree s rengtyaraagree atrengtyagree cnunWE E l agree trat yea EU areagree atrengty araagree bottom nght othe outhhed ee11 strangryagree I2 tgrfgg vaw IE 3 mg neutra m gree neutrat sa atrnngty msagree msagree swung y draagree YES yes nu nu ubellmg ucdawsenn p 5 en s1mng1y agree a reg neu1rs1 msagree s1reng1y msagree yes rm 9 Repeat steps 4 e 8 forthe rest ofthe material you Wantto eompue NOTE m My Word a er the quot Where you have been emenng numbers euun111156aa V 10 You now have tabulated how many people had which answer Respundent Ques11en1 cuesuen 2 Ques11e113 Questmn 4 A11ee 5 5 1 yes Hub 5 3 0 11m Caru A 3 1 yes Ted 3 1 1 yes s1reng1y agree 2 1 u 0 agree 1 n u n nemrs1 1 2 u u msagree n n u n s11eng1ya1ssgree n 1 3 0 yes 0 n u 3 nu u n u 1 can mm later lt11nn1011n11quotupmnn 1 r11 quot1 111111111 me 1 n e u A n r 2 n n 11 n n 1 n vquot 1 11 n a 1 ubexmggucemseen p 5 en 11nghhghtthe appropriate pan othe table s cm A 3 yes Ted y Ouasuun A n u n n u d 3 12 Chck on the chartwuard and selectthe appropriate type of chm 1n ths case you premew duplay type Wm appear ubexmggucamem p 7 m 14 Click nish and place your table 15 You might want to do a few things to make the chart easier to read If you right click in the middle of the chart ou will et a menu that will allow much formatting usrrerrgry agree la ree unemrar nersagree I strungly msagr cuesrrenr Questrun 2 Questrun 3 Fgrrnat Plot Area Chart Tape gource Data Chart Options Location Chart V rndow Clear 16 From this menu select format plot area background Here it is changed to white and change the color of the chart Arse O Amman O Nan Samnle ustrungly agree cuesrrerrr Questrun 2 Ouestrun 3 17 The chart option menu allows much formatting and labeling Here I have selected the major g1idlines on the XaXis ohm Options a Merer errarmes I Mlncr memes aebellman ucdavisedu p 8 of 13 H r Th selected the seale tab and set Maxrmum to 4 Major umts to 1 and mmor umts to 1 cuesnun My chartnow E NOTE You rmgm Want to play Wth NOTE The chart can be eopredrmo otherfor mat options and eharnypes other program 5 rebeumrggucamem p 9 ufl Lnnking at the results rum 2 test 1 Enter stuolentnames along the lett 2 Enter problem numbers along the top 3 Enter the value ofeach problem m the row below the problem number 4 Enter pornts for each studentfor each problem Ell SampleGradeSheel 2 Test 1 e Dulrlg that Mam Stul7 Emblem l Emblem 2 Emblem 3 Tulal la 25 ls aamey la 20 la Betty 7 l5 l5 Fred 8 l7 l5 Wllma la 25 la Fm rsum and sum and then wrth the lett cllck helol down seleet all eells to be summeol Hrt enter bulltrln formula Prubleml Prublem 2 Prublem 3 Tulal TU 25 39 1 sum E4 D4 1kl sumtuumbenlmmuetzl aamey la 20 V i Betty 7 l5 l5 0 Emblem l Emblem 2 Emblem 3 Tulal la 25 la 50 Eamey la 20 la 7 Betty 7 l5 6 Move the cursorback up to the eell ml the formula abe mg ucdmsedu p ln om cells below 1 The fnrmnlzwill he cnpied relativaly Prumem 3 my Prumem 3 my 15 50 15 13 13 15 15 15 15 10 10 8 Tum 10 Type the operator m m case a 5U 43 E5 I 37 An 45 abe mg ucdmsedu p 11 am 11 Chek 1n the ee11 contammg the denommator 1n ths ease the tota1 number ofpomts on the test and hi enter an 43 n EB 37 An 45 12 o denommator to reman eonstant When the formula was copxed downquot 1ast tune the rows thatwere referenced were mcreased by one as went down For exam 1e when you copxed the total formula down the formula 1n E4 SUMB4 D4 When 1t was copxedmto the next ee11 down xtbecame E5 SUMB5 D5 The nentwas E6 W To number When you eopy anythmg proceeded by a1thll remam eonstant Doub1e clxckm the formula ee11 and eduxt 3 Tum 15 n1 1 13 uu a 37 um 41 m m 4 14 To son by exther ofthe outsxde eo1unnns ehekm the top orbottom othe eo1umn you wantto son by and then hxghhght a11 pans ofthe tab1e abe mg ucdmsedu n 12 oh l 31 15 Click on the appropriate sort icon 1 or use the data menu 2 3 Problem 1 Problem 2 Problem 3 Total 1391 10 25 15 5 Wllma 10 25 1D 45 08 5 Barney 1U 20 13 43 085 7 Fred 8 1 15 4D 18 8 Betty 739 15 15 37 04 9 16 To sort the data by anything other then either of the two outside columns Select and highlight all cells in the table that are not headings Problem 1 Problem 2 Problem 3 Total 10 25 15 43 085 3 174 4D 08 115 19 Sort by l ASEBr dine O Qescending Then by Cr Asgending O Descending 0 Ascending O Descending My data range has 0 Header ow 3 No header row 18 Select the appropriate column in the sort dialogue box Check Ascending or Descending as appropriate Be sure No header row is selected Click OK In the example the table will be sorted so the data in Column D is in ascending order N v D4 wuma 1 Test 1 Dolng that Math Stuff 2 3 Problem 1 Problem 2 Problem 3 Total 4 ll 25 15 5 Wllma 10 25 11 45 D a Barney 11 213 13 43 El 86 Betty 7 15 15 37 El 74 3 Fred 8 17 15 AD 3 aebellman ucdavisedu p 13 of 13


Buy Material

Are you sure you want to buy this material for

25 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


You're already Subscribed!

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

Why people love StudySoup

Steve Martinelli UC Los Angeles

"There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Allison Fischer University of Alabama

"I signed up to be an Elite Notetaker with 2 of my sorority sisters this semester. We just posted our notes weekly and were each making over $600 per month. I LOVE StudySoup!"

Jim McGreen Ohio University

"Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."


"Their 'Elite Notetakers' are making over $1,200/month in sales by creating high quality content that helps their classmates in a time of need."

Become an Elite Notetaker and start selling your notes online!

Refund Policy


All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email


StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here:

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.