Data Collation User Manual
Contents
1. Operation Data is entered in this row from the School form Sheet protection is removed through Data can be entered manually if sheet protection is Tools gt Protection gt Unprotect sheet removed No password required ll ed lui D H D Ka j gr H Summa Schoo Data g Preda Cate Dota ada Zop opt Lp 21 ZGnpDGi Zopra l Gm 15 ap 061 Gp 7 ap 151 Zon 109 ap DO sl Beach Rn Troubleshooting e Enter data directly into the first row if there are problems with the functioning of the Schoo form on the Summary sheet This may occur for Apple OS users sorry a2 B a a al art AA Summa School Date Pirribcal Daba Data values pp 0 Grp 621 Gp Gb Grp 4 fa 5 done Gp Pap i fp ay i Gp DO le Physical data sheet Purpose To store data relating to the abiotic physical conditions on the day of the collection event Function All data is entered automatically from the Abiotic form accessed on the Summary sheet All data is automatically copied back to the summary page for display Cells are locked but can be unprotected if direct editing is required Users Administrators Administrators should only edit this sheet if required trouble with Abiotic form operation Normally no user interaction is required Operation Data is entered in this row from the Abiotic form on Sheet protection is removed through the Summary sheet Tools gt Protection gt Unprotect shee2. A a gt Summary School Data Physical Data Data Values Grp Grp 1 Z Grp 2 Z Grp 3 Z Grp 4 Grp 5 Z Grp 6 Grp 7 Grp 8 Grp 9 Z Grp 10 Contents EE 2 BEIER AAA e Mo AEE 3 user Mantal E A A cele tees 3 A e e Por 3 ASANO ANSE SOWIE peona caca 3 So E EE EEE EEE EREE 3 Using the data Meri 3 rt aa Ga ke ie e Fe ass EE 4 FUL OSC aE 4 is teilen GE 4 RE 4 o 4 o times tanec ten nectar nee eaten ne cen eee 4 Set e ele Ee EE 6 Beie 6 RUNE ON HE 6 ME 6 EE eelere 6 TOWNE SIMO QUIN a E eee 6 PAY SICA Cate E 7 Kee 7 A a tre me A a eran 7 A N a 7 EIERE 7 Mo A A A E 7 Data Vales S IMS E 8 A a 8 FUNCUON KEE 8 U OTS e ene et ence eens 8 OCF aU O EE 8 Brei le te ee le Le KE 8 EE 9 Fe NMI Se iera 9 FUNCION instan iii 9 A A 9 Do AM O Ie 9 TOD SNOOUNG sisas 9 ATO A A ven wed 10 Beie 10 Fe NS lei H 10 BE 10 Hid go UDISSNOO ln Le KE 11 Dalta TOW CAGE AIM EE 13 Data collation sheet User Manual Introduction o This data collation tool spreadsheet provides a means to handle all the data for a collection event o The user manual Scope Purpose The user manual provides guidance for administrators in using and maintaining the data tool There is a guide for each worksheet that includes details on Purpose Function Users Operation Troubleshooting Installing the software o System requirements Capability to run Microsoft Excel 2003 Platform Support The Exc
3. Data collation tool User manual Ej Microsoft Excel BioWB_Jul10 xls lashBaper Window Help gt 2121 4 100 e a kd School setup data AAN including student Schad pO groups names can po be entered here EN gt Habitat impact Pos Election date O DO t w m p z s Location Ww OO o o data ab 9 Latitude Windspeedmin Airtempmin he physical AE 10 Longuitude Windspeedmax Birtempmax conditions on the Wh OO oolection dei 12 Weather Sl Light 13 EE 9 Soil temp min 1 Lightmin 14 Bel Humidi fido 22 Soiltempmax Lightmax 15 ao Ma PRA PAS 16 nei gt In ma an SL H 17 s ps 18 Number collected ede Graph 20 20 Blattodea Order Populations a Coleoptera 22 Dermaptera 23 tea 23 JEphemeroptera 22 Hemiptenm 26 Hymenoptera 27 Cid iS Oa 28 2 29 Lepidoptera 2 Mantodea aL Neuroptera 32l JOdonata 31 JfOrthoptera 34 Phasmatodea 35 Psocoptera 36 Siphonoptera e g sel Sa e T we a d oe wm Dag Ki Ki o Ki Ke m de Ped E LE Mad Es wo pes q Pre a A E S 2 2 S 5 3 8 s 28 3 5 2 5 2 E o e a a a e a e 2 a a o a a a Y 5 3 2 S S E 8 S 2 8 8 T D E E a Ka e T o A E 3 2 E S EE 8 3 ee 2 amp T E o O D o a a E E 3 3 3 2 8 AA F 2 8 Ww O 45 E E
4. Arachnida 15 12 07 2010 Malaise trap Open forest Fly Diptera 16 12 07 2010 Malaise trap Open forest 2 Wasp Hymenoptera a Ginna AAA A ween OOO EE 888 Order Common Name Hymenoptera Coleoptera Blattodea Arachnida Diptera Hymenoptera Ant Beetle Cockroach Spider Fly Wasp 12 Data flow diagram Appendix 1 School form Summary School data sheet Summary data sheet cell Summary formulae sheet Administrators 2 Abiotic form Physical data sheet Summary sheet a formulae 3 Data values Data values sheet Data values sheet 1 Data entry Summary cell Grp data a sheet formulae Users Group data sheet 13
5. M Create a copy e Rename the copied sheet to the name of the deleted sheet Troubleshooting e See below for invalid reference error message details Grp data sheets Purpose e To provide a data entry sheet for each group participating in the collection event Function e Data that is common to all data sheets is entered automatically as each new record is entered o Date o Habitat o Order e Data is entered by the user using drop down boxes where provided o Collection method o Number collected o Common name o Mouth parts Close observation required e Data is automatically o Collated into a summary table on group data sheet o Generated into a graph on group data sheet o Harvested by the Summary sheet for collation e Printing of data and summary graph is defaulted to 2 pages of landscape A4 Users User groups e Groups who have collected the data JE Type a Question for help Li x Step 1 Users 3 e ce 8 N 0 A RR Datta automatically entered from A School and Physical data sheets 7 mmm find speed min Soiltypet Soiltempmin Mr temp max Windspeed max Soiftype2 SoMtempmax Ji O aaa Order Common Name l icere enter data here Date Habitat and Order columns generated automatically as data entered Group summary data and graph generated automatically alalajeja i H 4 M Summary Schod Data Physical Data Data
6. 14 Rel Humidity aciiy Tyoltempma 7 Sigma 20 E rTPA VTA RER D UN RECHT EE MES e 16 CR Abiotic Data 12 07 2010 Latitude DOOMMSS 263050 Date ddmmyyyy Open forest D disturbed D Longtude DDOMMSS Soil Temperature Maximum 25 Minimum 20 Enter all abiotic data in the boxes to the left When done the data wil be updated in the data sheet suumary The data can be updated at any time by re entering on this form or directly editting on the Physical Data sheet Air Temperature C Soil Type kam Se 7 35 Al maximum and minimums refer to the conditions on the day of collection Soil types refer to up bo typical soil type of soil found in the habitat Acidky pH 4 0 8 0 Soil Moisture 0 45 A data logger is preferred to Relative Humidit y measure ranges of conditions Yo Estimate cloud cover If data cannot be measured for some conditions then leave blank Cloud cover School data sheet Purpose e To store all school data relating to the collection event Function e All data is entered automatically from the School form accessed on the Summary sheet e All data is automatically copied back to the summary page for display e Cells are locked but can be unprotected if direct editing is required Users Administrators e Administrators should only edit this sheet if required trouble with School form operation e Normally no user interaction is required
7. ER E o A A HEH w e A D SEA JE PSSS PESE A E Ka SA AN AO AE E WEE 5 TN AR A A A ar SECH SEET ESCH i ES E ANA SO AS A AO A SSS YES aaa all A Y IA A A O 31 A E AOS AS A A AS DA ET ER H SCH Kl Add additional Add additional corresponding Re D E m common names order names here and here A A AA El A T z here AS A A A E A EH 4 Vertebrates can be AA gt gt gt gt gt EN DEE o a SS WE E A E A a WE E EF E A AAA AA AAA A EE A E A A A ss a PI TER EA E E O E DE O O PS A LEE 35 ER FE PO A D P CS o A A de a E D 2 AAA D EH a Sa A E ee A MET Ee Ne EE ane EE A i Wak H Summary f School Data Pesca Cite Data Values Gp Gp 11 fare 21 Gp Ay Lp 041 Gp 15 Gp 61 Gp D Zopp 1 fp 1101 le Beer Troubleshooting e Ifthe Common Name column is resorted to alphabetical order then the Order column must also be selected to sort e Order names should only appear once in Column B but can occur on multiple occasions Column E If you add a new common name animal and its corresponding order next to it then only add the order name to Column B if it doesn t already exist in that column Grp sheet Purpose e To provide a clean copy of the group data sheets if replacement copies required Function e This sheet should not be used to enter data its only use is for copying purposes e Creation of additional copies of the group data sheet will
8. Values Gp gt Grp 1 Gro 2 Gb 3 Gro 4 Go 5 ZGro 6 Gp 7 ZGro 8 Go 9 Z Go 10 lt n o DS i i _ at e Print data and graphs as 2 page printout of this group s data e Save workbook to another location e Analyse summary data sheet for whole group Step 2 Users 10 Troubleshooting e f required common names do not appear in the drop down boxes then editing adding will need to be done by the administrator in the Data Values sheet e Data error message Invalid references Microsoft Excel H A Formula in this worksheet contains one or more invalid references verify hat your Formulas contain a valid path workbook range name and cell reference o Occurs due to some legacy range names that are initially blank or empty o Select Ok and continue o Should not reappear first record has been entered but may reappear if record contents are cleared or a new Grp sheet is copied to replace the existing sheet Summary sheet sample fe IF SUM Grp 1 Grp 10 1 111 gt 0 SUM Grp 1 Grp 10 15111 C TL Sc hoo T d ata a ent r ab a 1 la l q a S gt 2 Habitat Open forest School setup data 3 Impact including student School 4 Collection date 12 July 2010 groups names can SE 5 lo mylocationSite Ib entered here 6 in 7 A ditions ji ai 8 Air Enter data about 9 Latitude 26 30 50 Wind speed min rr OfAirtempmin 12 the ph
9. ed through the forms or the automatic functions Users Administrators e Administrators should only enter data through the two form buttons School and Abiotic physical e The worksheet is protected but can be changed by teachers no password required Operation j he NS A DIE Err EGL dUGmp 01 61 0813 90 Sp Lomp HH E e D Step 1 Administrators Step 2 Administrators School data fam O idas PTS top Te SES Ree Reg i 15 Cloud caer A 16 Specimen summary Order Populations Summary table and graph automatically generated from data collated from all aroup EEE La Je LAN K E 35 S E as Rope SS SES p e Eg a SE o E a E S Sa E a zz Bez S Ss fe E zs EEsk E Eade DN x mm a E E ZB Z 0 ZN E 3 3 E F a A E 3 g _ q ES E Ad sa Jo et EE Ms E le e e A e E KH EE O qm Jai os ds ES es ls EE A E e es Ms Eege O Fe SCH bo Gunman School Data Wea AData Dota values Grp Gap 11 Gp 21 Gap ay Gre 041 Cp 5 dr 05 Zon E ae 8 Grp Da e Gap DO le CH Troubleshooting e If the forms do not function due to operating system incompatibilities Apple then all data can be directly entered into the Physical Data and School Data sheets as described in the relevant data sheet sections e The summary sheet will still function correctly once data has been entered into the Physical and School Data sheets e f date displays as US format then check s
10. el spreadsheet has been developed for Windows XP Office 2003 in a VB net environment Apple OS Apple OS may not support all macro or VB Code functions o Installation steps Copy Excel spreadsheet to suitable folder for user access Copy the file under a new name for this collection event Use a suitable format for name ourCollectionEvent_Jul_2010 xls This is NOT a network solution so one user access at a time is allowed Using the software o Introduction Purpose of the software The software provides a means to collate and analyse data from a single collection event at a single site Multiple collection events and sites will require separate data workbooks User levels and the implications Administrators e Enter school and physical data through forms School and Abiotic e Update data values that appear in drop down lists e Copy and create new data sheets if required Users e Enter data in group data sheets o Limitations e Best viewed in 1680x1050 resolution e Limited to 100 data entry records per group Using the data sheets Summary School Physical Data values Grp Grp O O OOOO Summary data sheet Purpose e To display all relevant data collected by the whole group in a form ready for analysis Function All data is inputted using the forms for School data and Abiotic physical data Specimen data is automatically generated from the group data sheets e Cells are locked so that all data is only enter
11. ettings in Control panel gt Regional and Language Options gt Customise gt Date tab gt Short Date format dd mm yyyy Step 1 Administrators Step 2 Administrators alelslalsisigialelalelelelslelslelelyisieleiyiniyly A A ae E E A ee A ee ee ee ee ee weg x f F j OZ Ze gt Shan dat A Habitat Impact Collection date School Setup 5 Location nter data about E the physical Gs conditions on the Abiotic collection date Light Lightmin E ZE 10 Longuitude _ 11 ION 12 Weather School Controls School name mySchool mySchoolSite Location Clear 14 Bel Humidi SE fw Light max Teach ate Cancel eee iii 8 Class myClass D I ime 17 5 Number coll m Groups Grp 1 myGroupt Grp 2 myGroupe Grp 3 myGroupS Grp 4 mygroup Grp 5 myGrous Grp 6 Grp 7 Grp 8 Grp 9 Grp 10 Phasmatodea Siphonoptera Ephemeroptera IDU UOTE UB AU OUMIL Ip UJO UDI 1 J ETA E 20 TAS ASES EL ES 7 2 School 3 Teacher 4 Class 5 Location 6 D a Impact including student 12 July 2010 groups names can ES e d MA H 5 P a es EES a Cate Collection date 7 8 H 10410 Wantz gt enter 13 Description mostyfne pe Y foam JW
12. require o Creating additional lists for the automated graphing functions to work o Editing of Summary sheet formulae to include additional sheet data Note Unless administrators have the expertise to perform the above functions they should not attempt to create additional copies Contact the developer for assistance with these functions if required Normally fresh data sheets can be created by clearing all contents on the group data sheet and clearing data using the forms on summary sheet Users Administrators e Administrators should only copy this sheet if required trouble with Group sheet operation e Normally no user interaction is required Operation e Delete the offending sheet e To copy anew sheet select Edit gt Move or Copy Sheet ES Microsoft Excel BioWB _Jul10 xls GEN File Edit View Insert Format Tools Data FlashPaper Window Help at Unde IS 3 Kt i 49 100 O i arial s 10 BZ Ctrl Ctrl C ace alo Office Clipboard Sg AL Paste Ctrl Paste Special Paste as Hyperlink Fill Clear Wind speed min Ss Seen 2 Dese Windspeedpar I g Delete Sheet Move selected sheets 10 BD 2 e book FA Find Ctrl F E up A 110 a Replace ctr H pd Habitat Number collected Ci B gt ES S i p Ctrl G S KN Grp 6 Grp Al Grp 8 Go To e Select move to end and
13. t Data can be entered manually if sheet protection is No password required removed Protect sheet when finished Troubleshooting Enter data directly into the first row if there are problems with the functioning of the Abiotic form on the Summary sheet Data values sheet Purpose e To store all data that appears in the drop down boxes or is required for automatic functions Function e Data can be edited directly into cells as required There is no form for editing functions e Sheet is protected to prevent user misadventures but the administrator can unprotect the sheet to make editing changes o Tools gt Protection gt Unprotect o No password required o After editing protect again e There is no practical limit to the number of entries as data is automatically read to the bottom of each column Users Administrators e Administrators should only edit this sheet if required trouble with Abiotic form operation e Normally no user interaction is required Operation Step 3 Administrators Comes same La B e EE A ont Hypa Gesi Ss Bees Bee be disturbed EE S im a Bring Betea Larg coded tube amd Jee II EE ir En et El E moe EE EE EE 10 Hand CH Pamana ge E E E EE D Cpseratan EE 12 Isapada LL 0701 Odia CoQ OO EE EE O TT Damaptara Tal open shnbland JA EE SS IS IS a a SS Des paaks YAA go EE oe DE A a
14. ysical Abiotic 10 Longuitude 153 01 58 Wind speed max __ 5 Airtemp max Z7lrongdtons on the A leger date 12 A Soil Light 13 Description mostiyfine Type Jean Soiltempmin 20 Lightmin 12000 14 Rel Humidi Acidity 7 Soiltempmax 25 Lightmax 25000 15 Cloud cover K eech Ess 16 17 IL sumn nary l 18 N ay aa O 19 20 B Blattodea 21 22 Dermaptera 23 2 Diptera aro o Ephemeroptera 821 Hemiptera 26 27 ss TIeopogs O 281 lsoptera 29 Lepidoptera 30 Mantodea mp Neuroptera 32 Odonata apo Orthoptera apo Phasmatodea 35 Psocoptera 36 Siphonoptera Order Populations Eo o o o o ba ba 5 bo o BEN E S Ss 5 2 SS SS SS Ss SS SS zs Ps _ Pe Py _ o _ E Kai 40 JA E EEEE 22 2 28 52 8 2 2 o Ka o a o o o o o E o o o o D E E D D 3 e 5 a o E E e SZ E S 5 54223 E 3 x D I a o a a O kel zZ a _ T a S 3 z ER e Sa E D e Lu 11 Group data sample D1 10 UI 12 07 2010 Pitfall trap Open forest Ant Hymenoptera 12 12 07 2010 Pitfall trap Open forest 2 Beetle Coleoptera O 13 12 07 2010 Pitfall trap Open forest Cockroach Blattodea O 14 12 07 2010 Pitfall trap Open forest nger
Download Pdf Manuals
Related Search