QSM+LECTURE+2.ppt

《QSM+LECTURE+2.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、LastUpdated:08October2021©LMSSEGieducationgroup1QuantitativeandstatisticalmethodsLECTURE2:QuantitativeSkillsUsingMicrosoftExcelLastUpdated:08October2021©LMSSEGieducationgroup2LEARNINGOBJECTIVESDemonstrateknowledgeofstatisticsbyusingMicrosoftExcel®fordraft

2、ingtables,charts,graphsanddiagramsExplainhowMicrosoftExcelcanbeusedindifferentareasofcalculations.LEARNINGOUTCOMESBytheendofthisunityouwillbeableto:UnderstandandapplythebasictoolsinMicrosoftExcel®fordraftingtables,charts,graphsanddiagramsCompareandcontrastm

3、odesofpresentingdataIdentifyappropriatemethodsofpresentingdatainarangeofsituationsQuantitativeSkills:UsingMicrosoftExcelBasictoolsandformulae:COUNTCOUNTIF.......................................CountingSUMAVERAGE(MEAN)MEDIAN..................................

4、.......MeasuresofAverageMODEMAX(MAXIMUM)MIN(MINIMUM)..................................MeasuresofDispersionRANGESTDEVPCORREL(CORRELATION)...............ConnectionsQuantitativeSkills:UsingMicrosoftExcelBasictoolsandformulae-COUNTING:COUNTisusedtocalculatethen

5、umberofcellsthathaveanumberwithinthehighlightedlist.COUNTIFcountsthenumberofhighlightedcellsthatcontainaspecificrangeofnumbers.Thisisusedinthesurveytocalculatehowmanystudentsachieveddistinctiongradeswhichisagradeof70%orhigher.SUMsimplytotalsallthefigureshig

6、hlightedandprovidesatotalinthechosenarea.QuantitativeSkills:UsingMicrosoftExcelTask1CompletealltheTOTALblanksbyusingCOUNTCompletethedistinctionscolumnusingCOUNTIFSUMthenumberofDistinctionsHighlightstudentswithDistinctionsQuantitativeSkills:UsingMicrosoftExc

7、elTOTALMEANMEDIANMODEMAXMINRANGESTDEVPQuantitativeSkills:UsingMicrosoftExcelBasictoolsandformulae–MeasuresofAverageAVERAGE(MEAN)isthesumofthevaluesdividedbythenumberofvaluesMEDIANisthemiddlevalueinasetofnumberswhentheyarerankedinorderofmagnitude(size).MODEi

8、sthenumber/swhichoccursthemostofteninasetofnumbers.QuantitativeSkills:UsingMicrosoftExcelMEANisthesumoftheresponsesdividedbythenumberofresponses.Addupallthe1s,2sand3s.Anddividebythenumberofresponseswhi