HTC Data Use Tool -User`s Manual - Global Health Sciences Data Use
Contents
1. Heatmap 16 Under Polygons select Fill color Points Mart r Polygons Lines Legend 17 Select Buckets Buckets are the number of categories or buckets you wish your data to be divided into Edit the following g Divide into Adjust the number of categories or buckets you want your data to be divided into h Column Select the indicator to be displayed on the map i Use this range Resets the range of the data to match the indicator selected j Click on a value to adjust the cutoff point k Click on the color and choose from the wheel or shape to change the design of each bucket I Select Save Version January 2015 a Fixed Column Buckets Divide into 2 buckets 16 482 32812 is ran 00 up to 50 0 500 up to 100 0 100 0 18 Under legend select Automatic Legend d Check the box next to Show polygon fill legend e Adjust the title for your legend if needed f Select Save Change map feature styles Points Automatic legends Marker icon Polygons Show marker e Fill color A bucket style is Border color Show polygon fill legend Border width Tite HIV Prevalence Female Lines Line color Legend position Line width Legend Automatic le gend i Include a link to this table Link text Source 19 Select Change Info Window under Feature Map on the left side and follow the steps above under Cards for instruction on how to change the info window co2. 2 2 Data Inputs Data to be used in Google FusionTables must first be in a Microsoft Excel soreadsheet or Google Spreadsheet formatted with specific information in the rows individual records displayed horizontally columns variables or indicators displayed vertically and data items contents within rows and columns of the spreadsheet 1 Enter data into Excel using the following format Row 1 Column Headers Column headers should contain all components necessary to describe the data such as HIV Prevalence Females All Ages ANC 2010 At a minimum the following should be included in the column header Tip Each spreadsheet should contain data from only one geographic disaggregation If you wish to work with more than one geographic aggregation 1 Indicator name e g HIV Prevalence 2 Sex e g Female such as province level data in addition to district level data create separate 3 Age aggregation e g All ages 15 24 4 Source and year e g ANC 2010 spreadsheets for each Version January 2015 a wn PB WN FE Rows 2 and above Data elements values Column A Geographic indicator Province district sub district facility Columns B and above Indicators or variables A B G D E F HIV Prevalence Females HIV Prevalence Females HIV Prevalence Females No tested positive for HIV No tested for HIV Females All District All Ages ANC 2010 All Ages ANC 2011 All Ages ANC 2012 Females All Ages MOCK DATA
3. Ages MOCK DATA Ehlanzeni 335726 699429 Gert Sibande 118702 211967 Nkangala 199879 444175 2 Save your file with a name and location that is easy to remember For example a file containing ANC Surveillance HIV prevalence data from Mpumalanga province in South Africa may be called ANC HIV Prevalence Mpumalanga 2010 2012 and saved to your desktop Version January 2015 Eo 2 3 Importing data into Google FusionTables Video tutorial https www youtube com watch ev fitrsGhzA11 To import data into Google Fusion Table execute the following steps 1 Visit https www google com fusiontables 2 Select Create a Fusion Table Tip You must be logged into your Google or Gmail account prior to working in Google FusionTables The Import new table dialog box appears Import new table From this computer Choose File No file chosen ou Can upioad spreacsnecis deumited iex e Eil Googie Spreadsheets and Keyhole Markup Language files km Create empty table Or search public data tables New to Fusion Tables Cancel Take a peek Play with a data set or try a tutorial 3 Select From this computer Browse to find the Excel data file you wish to import e g ANC HIV Prevalence Mpumalanga 2010 2012 5 The spreadsheet should appear Select Next Version January 2015 C Import new table Column names are in row 1 1 District HIV HIV HIV No No Preva Preva Preva teste
4. Maximum categories Enter the number of categories on the x axis Configure categorical chart Category Province Summarize data Values Longitude Latitidue Sort by reverse Province Maximum categories 10 4 Edit the appearance of your chart by selecting the Change Appearance in the upper right le chart Title Enter the Title of your chart Legend Change the location and appearance of your legend Font Background Change the overall chart font and background Chart Editor Features Select the detailed appearance of your chart Version January 2015 C Axis Select which axis you wish to edit Horizontal or vertical edit the title labels and appearance for that axis Faatures Sesk Reverse Aisne Campare made Anis Herinertl a SF Slantlibels aude Columns Select which columns on the chart you wish to edit and edit the color and y axis location Calming bejde Color E Fors Left axis Errorbars Home Version January 2015 16 3 3 Maps Maps overlay data onto Google Maps This guide will highlight how to display data on Polygon maps and Point maps For detailed information about these types of maps see Table 1 below or visit https support google com fusiontables answer 174680 hl en Table 1 Comparison of Polygon and Point maps Polygon Map Point Map Definiti Displays shapes that represent areas Displays x y coordinates that represent efinition such as provinces or distr
5. UCs Global Health Sciences Global Strategic Information Google FusionTables for Global Health User Manual s P Testing coverage end HIV prevalence by sub district u Thunguly District KZN South Africa Naandle Local Municipatty Niewie Lochi Mirecoe Marte Locs Aireeuce ox a Anaia a kropet Mh ay Murecipeat etnies oe Es oes rae ap smoamrei Version January 2015 7 1 INCFOCUCTION ccceccecccceccsccccececcecceccstecceceetestesceceetecceestestecceestencs 3 SS Reguremenl esner ican unienunenausns oon ens averneen our menemetorelsiaenaaiane 3 WSO TACO ANS seared ice E E E toervesatuestun E E E 3 2 Getting started with Google FUSIONTADIES ccccecceeceeseeeseeseeeees 4 Mice UND acer ccincteted E ca ead nts ans canteen Suaoicts teats E N 4 2a TAS NOS ace gas aes nc ee ec ears aie case vv ose oe es ove pare et ea ears ean E 4 2 3 Importing data into Google FUSIONTADIES cc cseeseecccccccseeseseeeccecessaueeseeecceeeeseaeaseeeeceeeesananessss 6 CAC IMAM ONS techs ce tease E E tutte E E T yn eharsaanaae 9 3 NAS Ua NZ Ol el E nro cterss eects E E A 12 She e EEEE AE E E E E E E E E E 12 I2 a A ree trace E E E E E E E 14 3 2 1 Edit enart an peara CE aeree E E E E 14 VO a E E E E E T 17 3 3 1 POCIO anA AA 17 3 3 2 BAB 0218 0 G8 9c eee E 20 4 Additional COMPONENTS c ccccecceeccesceeceecceseeseeeseeeesseuceeeeeeeeeees 25 41 Downloadi
6. Preval HIV Preval HIV Preval No teste No tested for HI Ehlanzeni 37 7 35 8 35 1 335726 699429 Gert Sibande 38 8 46 1 40 5 118702 211967 Nkangala 27 2 29 6 32 1 199879 444175 After you have imported your Fusion Table you can return to Google Fusion Tables and access it through your Google Drive account To do this 1 Select Drive from the Apps in your Gmail account Eon oe a Search tor the doctor infol Now we iink mayde it isn t of YouTube ehoned you on Facebock Rebeka bea hors _ 3 thinking about doing the basement foce n he ne Maps Piy News e C Marty Chores hese Coys Vy feves amp 4 a Os Hing Fndoy ng What aboul every i amp Ev olicy Report Thursday February 26 2015 lt Gmail Orive Calendar 2 Select the FusionTable distinguished by the 9 icon that you wish to view from the list amp Drive My Drive za Name Damer Lasi modified PEJ Myprive Ej HCT Mpumalanga Farility me Feb 95 E incoming Ej ANC HIV Prevalence_Mpumalanga_2010 2017 me Feb 25 Version January 2015 e 2 4 Calculating Formulas Video tutorial https youtu be X m2wTKyElY Formulas can be created by adding an additional indicator that calculates a formula using data from indicators already in your dataset or other values For example if we wish to calculate the HIV testing yield from our data we will write the following formula number tested positive for HIV number tested for HIV To
7. do this execute the following steps Tip If you are working in a merged file you 1 Select Edit from the menu will not be able to Add formula column See 2 Select Change Columns Downloading a dataset for information on how to download and import a merged FusionTable to regain full function File Edit Tools Help Rows Fi Add row Edit row Duplicate row Prov nir Delete selected row Delete all rows Change columns 3 Select New and then Formula column Columns Column Formula column Facility Adult remaining on ART at end of the tota 4 Enter a name for your new indicator e g HIV Testing Yield Version January 2015 C 5 Enter a description of this new indicator if applicable Tip Formulas should be formatted similar to 6 Enter the formula to be calculated Excel They can include pre existing indicators from your dataset and or other values See In order to include data from pre existing indicators in this link for more information on creating your formula you must copy the original indicator name formulas in FusionTables exactly as it appears in the dataset and paste it into the https support google com fusiontables ans formula wrapped in apostrophes To do this wer 178196 hl en a Select the indicator you wish to include in your formula from the list on the left The name of this indicator should now appear in the Right side of the window b Highlight and copy th
8. 2 buckets 5 Under legend select Automatic Legend a Check the box next to Show marker legend b Adjust the title for your legend if needed c Select Save Version January 2015 o Change map feature styles Points m Marker icon tomatic legend Polygons Show marker legend Fill color A bucket style is required Border color Show polygon fill legend Border width sili ail Tite HIV Prevalence Female Lines Line color Legend position Line width Legend Automatic legend W Include a link to this table Link text Source Save Cancel 6 Select Change Info Window under Feature Map on the left side and follow the steps above under Cards for instruction on how to change the info window contents Configure map Location geometry Feature map Change feature styles Change info window Heatmap Version January 2015 C 3 3 2 Polygon maps Video tutorial https www youtube com watch Pv WvYLaVbCWkI In order to display data on a polygon map you must first merge together Program data file e g HIV prevalence data aggregated by district KML mapping file Keyhole Markup Language a file format used to display geographic data on an earth browser such as Google Earth Google Maps etc Both files to be merged must have a common indicator with identical contents For example the indicator called District appears in both the program file da
9. ataset By default Cards will appear as a tab at the top of your FusionTable To change the card layout 1 Click on the Cards tab 2 Select Change card layout ANC HIV Prevalence_Mpu EMI ra 27 PST 2015 LANG M Prevale m File Edit Tools Help Rows 1 No filters applied Rename Move to front 4 4 11 3073 gt Duplicate District Ehlanzeni Remove HIV Prevalence Females All Ages ANC 201 Publish HIV Prevalence Females All Ages ANC 201 HIV Prevalence Females All Ages ANC 201 Change card layout No tested positive for HIV Females All Ages MULA DATA 335 26 No tested for HIV Females All Ages MOCK DATA 699429 District Nkangala HIV Prevalence Females All Ages ANC 2010 27 2 HIV Prevalence Females All Ages ANC 2011 29 6 HIV Prevalence Females All Ages ANC 2012 32 1 No tested positive for HIV Females All Ages MOCK DATA 199879 No tested for HIV Females All Ages MOCK DATA 444175 malanga_2010 2012 9 Map of Distnc District Gert Sibande HIV Prevalence Females All Ages ANC 2010 35 6 HIV Prevalence Females All Ages ANC 2011 46 1 HIV Prevalence Females All Ages ANC 2012 40 5 No tested positive for HIV Females All Ages MOCK DATA 118702 No tested for HIV Females All Ages MOCK DATA 211957 3 Check the boxes on the left next to each indicator you wish to include in your card Version January 2015 a Change card layout Automatic Custom Select the columns to i
10. d tested Fema Fema Fema positive for HIV All All All for HIV Fema Ages Ages Ages Fema All ANC ANC ANC All Ages 2010 2011 2012 Ages MOCK MOCK DATA DATA 2 Ehlanzeni 37 7 35 8 35 1 335726 699429 3 Gert 38 8 46 1 40 5 118702 211967 Sibande 4 Nkangala 27 2 29 6 32 1 199879 444175 Rows before the header row will be ignored New to Fusion Tables Cancel Back Nerta Take a peek Play with a data set or try a tutorial 6 Name your table under Table Name and write a description Select Next Import new table Table name ANC HIV Prevalence_Mpumalanga_2010 2012 Allow export 4 Attribute data to Attribution page link Description Imported at Mon Jan 26 10 35 27 PST 2015 from ANC HIV Prevalence_Mpumalanga_2010 2012 xlsx A For example what would you like to remember about this table in a year New to Fusion Tables Cancel Back Take a peek Play with a data set or try a tutorial Your dataset will appear in the Google Fusion Table application Repeat this step as necessary until all files to be used in Google FusionTables have been imported e g KML Files other datasets Version January 2015 ce ANC HIV Prevalence_Mpumalanga_2010 2012 Imported at Mon Jan 26 10 35 27 PST 2015 from ANC HIV Prevalence_Mpumalanga_2010 2012_xis Edited at 10 37 AM File Edit Tools Help Rows 1 ff Cards 1 9 Map of District a No filters applied 4 4 1 30f3 gt District HIV
11. e FusionTables allow for certain elements to be included and others to be excluded using the filter function Elements can be filtered from all tabs i e Dataset Cards Charts and Maps 1 Click the blue Filter button 2 Select the category you wish to filter Version January 2015 a a File Edit Tools Help Rows1 No filters applied SubDistrict District Population wat DHIS 2013 Antenatal 1st visit total 25 2 DHIS 2013 Antenatal client eligible 26 4 for ART initiation 334 DHIS 2013 Antenatal client HIV 1st pa test Satis DHIS 2013 Antenatal client HIV 1st 0 0 test positive 13 3 DHIS 2013 Antenatal client HIV re test 20 0 DHIS 2013 Antenatal client HIV re 30 0 test positive 39 DHIS 2013 Antenatal client 5 INITIATED on ART 21 1 DHIS 2013 Female condoms w 143 288 51 1 20 1 38 3 17 8 DOi an a orc o sn or 3 Check the boxes next to the fields you wish to include e g certain provinces or districts File Edit Tools Help Rows 1 ff Cards 1 4 District Ehlanzeni District Z X MH 4 1 50f5 gt gt fing SUbDistrict District dialiict valses Bushbuckridge Ehlanzeni DM Ehlanzeni DM 5 Mbombela Ehlanzeni DM G Sibande DM 7 Nkomazi Ehlanzeni DM Nkangala DM 6 ThabaChweu Ehlanzeni DM Umjindi Ehlanzeni DM 4 3 Editing data Video tutorial https www youtube com watch v 5BE8_ KShWFo Select the Tab titled Rows 1 to edit the data in your Google FusionTable 1 Select the Edit menu
12. e indicator name listed in the Right side of the window c Select the new indicator you just created from the list on the left side of the window Place your cursor in the Formula window on the Right side of the window type an apostrophe paste the indicator name and type another apostrophe e g e Add any other characters necessary for your formula such as or other values f Continue these steps until you have written a complete formula 7 Click Save Column name HIV testing yield Description iA Formula No tested positive for HIV Females All Ages MOCK DATA No tested for HIV Females All Ages MOCK DATA 47 Format None Custom properties JSON A Graph predicate 8 Your new indicator will now appear in your Google FusionTable dataset If you see asterisks in the New Indicator column in your dataset there is an error in your formula Click on the indicator name and select Change to edit the formula Version January 2015 w No test No tested for HI HIV Testins 1 335726 69942 Change 5 118702 21196 Find 1 199879 44417 Hide Sort 1 to 100 Sort 100 to 1 Version January 2015 3 Visualizing data 3 1 Cards Video tutorial https www youtube com watch v esUtNhOMFYM The Cards tab transforms the data in each row of your dataset into line listed information on a single card For example each card shows the district name and related indicators for every row of your d
13. icts specific features such as health facilities ES 5 rena Se SS Example outputs a me of oy o gt Program data Aggregate data e g province or Specific location data e g data by inputs district totals facility i KML mapping file that is merged with Longitude and Latitude coordinate data Geographic data ae program data See section on in decimal degrees for each location in inputs j Merging datasets for instruction dataset 3 3 1 Point maps Video tutorial https www youtube com watchPv 5zbxoTOrw 1 Select the Map tab look for this icon 9 that contains a Google map Select Change Feature Style under Feature Map on the left side Configure map Location geometry Feature map Change feature styles Change info window Heatmap 3 Under Points select Marker icon Version January 2015 Ea Points M Hi Polygons Lines Legend 4 Select Buckets Buckets are the number of categories or buckets you wish your data to be divided into Edit the following a Divide into Adjust the number of categories or buckets you want your data to be divided into Column Select the indicator to be displayed on the map Use this range Resets the range of the data to match the indicator selected Click on a value to adjust the cutoff point Click on the color and choose from the wheel or shape to change the design of each bucket f Select Save man ch Divide into
14. lanzeni Matching values in these two columns will create the merged table Learn more Cancel Previous ext 11 Select which indicators you wish to carry over to your next merged FusionTable by checking or unchecking the boxes next to that indicator Select Merge Merge Choose columns All q 19 columns select all none District HIV Prevalence Females All Ages ANC 2010 HIV Prevalence Females All Ages ANC 2011 HIV Prevalence Females All Ages ANC 2012 No tested positive for HIV Females All Ages MOCK DATA No tested for HIV Females All Ages MOCK DATA description name CATEGORY CAT 2 DISTRICT Cancel Previous AAAS AA A A A 12 Select View Table once the merged table has been created Tip If data is missing in your merged FusionTable e g you only see then the files did not merge properly and will need to be edited Version January 2015 an 13 If the tab doesn t already appear select the red button i and choose Map from the drop down menu 14 A new tab Map will appear that contains a Google map 15 Select Change Feature Style under Feature Map on the left side Configure map Tip Select functions including Add formula column will not work properly Location geometry after merging unless you download and re import the merged file See Downloading a dataset for instruction Feature map Change feature styles Change info window
15. nclude in your card view Wt District w HIV Prevalence Females All Ages ANC 2010 W HIV Prevalence Females All Ages ANC 2011 HIV Prevalence Females All Ages ANC 2012 Wi No tested positive for HIV Females All Ages MOCK DATA No tested for HIV lt div class googft card view style font family sans serif width 450px padding 4px border 1px solid ccc overflow hidden gt lt b gt District lt b gt District lt br gt lt b gt HIV Prevalence Females All Ages ANC 2010 lt b gt HIV Prevalence Females All Ages ANC 2010 lt br gt lt b gt HIV Prevalence Females All Ages ANC 2011 lt b gt HIV Prevalence Females All Ages ANC 2011 lt br gt lt b gt HIV Prevalence Females All Ages ANC 2012 lt b gt HIV Prevalence Females All Ages ANC 2012 lt br gt lt b gt No tested positive for HIV Females All Ages MOCK DATA lt b gt No tested positive for HIV Females All Ages MOCK DATA lt br gt lt b gt No tested for HIV Females All Ages MOCK DATA lt b gt No tested for HIV Females All Ages MOCK DATA lt div gt Females All Ages MOCK DATA Cards across Down Sort by Selectcolumn Sort AtoZ Cancel 4 Select Sort by at the bottom of the window and choose the order the cards will be displayed For example if you select District the cards will appear in alphabetical order by District name If you select an indicator the cards will appear from smallest to largest value for that indica
16. ng a dataset casecacsecutetsereccccostusiscinar neire deie see r i eE Ere EE Eea 25 A FETE 2 er ee nee 25 Aos 12200 Fc ce ee E EE EE ne eee ee ee eee eee 26 4 4 Sharing Google FUSIONTADIES cccccccssseccccsececceneccecesececsusececeenececseescceseuecessenecessegeceetegseeetes 27 4 4 1 Sharing a static Ue ASC asc toes Tipinin E TT 27 4 4 2 Sharing a digital FusionTable ciseti ce shescecextesnahedcacnadyitatecevsuecooteianswetrteessavmndedeiestecdeesseeeoalctedss 29 Version January 2015 ao 1 Introduction This manual offers a systematic approach to using Google FusionTables as a tool for informing evidence based strategic planning Google FusionTables is a web based interactive worksheet that provides a powerful tool for summarizing large amounts of tabular data by i Calculating totals averages medians and counts based on source data ii Classifying data based on other fields in the source data iii Auto generating charts iv Overlaying data on Google Maps All of this information can be found on our website https datause ucsf edu google fusion tables health Use Requirements To use Google Fusion Tables users will need basic operational knowledge of the computer the internet and Microsoft Office Excel and must be connected to the internet Access Google FusionTables https www google com fusiontables Video Tutorials Online video tutorials accompany each section of this manual Select the li
17. nk below to watch all videos as a series or select the video tutorial links within each section of this manual to view specific topics e Google Fusion Tables for Global Health Playlist http www youtube com playlist list PLIIGPn3 vroDueYPUBWTwrkKhOlgVsy O Version January 2015 ew 2 Getting started with Google FusionTables Video tutorial https www youtube com watch Pv zqaHXrZsnUM 2 1 Setup Before starting this manual users need a Google account also known as a Gmail account and access to the internet using the Chrome internet browser If you do not already have a Google Chrome browser or Google account do the following Download Chrome https www google com chrome browser e Create a free Google account https accounts google com SignUp To demonstrate how to use this tool we will follow an example using publically available ANC Sentinel Surveillance data from Mpumalanga Province in South Africa These two datasets 1 District level data and 2 Health facility level data and the necessary KML Mapping file Keyhole Markup Language a file format used to display geographic data on an earth browser such as Google Earth Google Maps et can be downloaded from the UCSF Data Use Website here https datause ucsf edu google fusion tables health or from the following links e Health facility level data http bit ly 1tgWNOH District level data http bit ly 1yVI2BB e KML Mapping file http bit ly 1wmoSpn
18. ntents Version January 2015 230 Configure map Location geometry Feature map Change feature styles Change info window Heatmap Version January 2015 a 4 Additional components 4 1 Downloading a dataset Video tutorial https www youtube com watch v 6ryJq7FoVQY Formulas cannot be calculated in a merged dataset Therefore in order to take advantage of all FusionTable functions a merged dataset must be downloaded onto your computer as a csv file and then imported back into Google FusionTables To download the file 1 Select File from the menu 2 Select Download I dit Toots Help Rows 1 Tip Files are downloaded to the location specified in your Share internet browser which is most commonly the Downloads folder on your computer If your file does not appear in the Open 0 0 c Downloads folder you can change the download location in Chrome as described here https support google com chrome answer 95574 hl en About this table Geocode Merge Find a table to merge with Download 3 Accept the default settings and select Download 4 Your file is now saved as a csv in the Downloads folder on your computer 5 Follow instruction in mporting data into Google FusionTables in order to import this csv file into Google FusionTables for full functionality 4 2 Filtering data Video tutorial https www youtube com watch Pv Yceq8 N1nNc Googl
19. taset and the KML Mapping file s and contains the name of each District spelled exactly the same To merge these files Tip All datasets and files to be merged must first be imported into 7 From your Program data file select File FusionTables including any KML 8 Select Merge mapping files See Importing data into Google FusionTables for instruction File Edit Tools Help ET share New le Open p Rename E pap E Wake a copy El About tis table E Geocode a ED Merge E Find 2 table to merge with E Teale view E meut more mwys linie E Download i f S HIE E 26686F ADERI Aliwal North Block H E 76 6867 306833 Aliwal North Block H E 9 Select the FusionTable file you wish to merge 10 Select the indicator in each data file that matches e g the indicator with identical District name data Select Next Tip The contents of the indicators to be merged must be identical For example the district name in the data file must exactly match the district name in the KML mapping file See Editing a dataset for instruction on how to change the names of your data files in Google FusionTables If data is missing in your merged FusionTable e g you only see then the files did not merge properly and will need to be edited Version January 2015 w Merge Confirm source of match This table KML Districts Mpumalanga District MUNICNAME Ehlanzeni Gert Sibande Gert Sibande Nkangala Nkangala Eh
20. the image into any Microsoft Office e g Powerpoint application Version January 2015 Ea 4 4 2 Sharing a digital FusionTable Share a website link containing your FusionTable either by inviting people to view or edit or by sending a URL 1 1 Select share bait in the upper Right corner Sharing a link for people to view 2 Copy the Link to share 3 Paste this link in an email or document to provide access 4 Select Change under who has access Tip A link can be viewed by anyone with the SHO link even if they do not have a Google or ante Gmail account However only those with a Google or Gmail account are able to edit a FusionTable 5 Choose Anyone with the Link to allow others with the link to view your file Viewers will not be able to edit or make changes E Version January 2015 a Inviting people to edit 6 Type the Gmail addresses of the people you want to share with under Invite People 7 Click the dropdown arrow on the right to designate the type of access e Can edit Allows users to edit and share with others e Can view Allows users to view but not make any changes 8 Click Send Invitees will receive an email letting them know you ve shared the file or folder with them Invite people Can edit v Can edit Notify people via email Add message o Semi pica si n Version January 2015 w
21. to add delete or change entire rows or columns HCT Tool_Mpumalanga_310ct20 p lov 02 14 37 59 PST 2014 from HCT Tool_ e DM ma File Edit Tools Help Rows 1 ff lt Add row Editrow Duplicate row Delete selected row 2 Hosp Delete all rows Add column ateway Add formula column 2 josp 2 Change columns 28 9481 30 1799 Afsondering 27 0313 316975 Aanes Rest Fas 2 Double click within a cell to change the contents of cells within a row Version January 2015 260 3 Select Save 4 4 Sharing Google FusionTables Video tutorial https www youtube com watch Pv 95U7zZfQ 3 Outputs can be shared as either static images by taking a screen shot of your final figure or as a digital link through Google that allows users to view and or edit content 4 4 1 Sharing a static image Use the Snipping Tool to capture your desired image 1 From your Start menu type Snipping Tool and select from the list Tip For further instruction visit http windows microsoft com en us windows7 products features snipping tool 2 Select New Version January 2015 a Sg Snipping Tool a OS New v X Cancel gt Options Select a snip type from the e menu or click the New button 3 Use your mouse cursor to draw a rectangle around the area you want to make into an image 4 Select the Copy icon S Snipping Tool File Edit Tools Help Q kl 3G Z7 9 5 Paste
22. tor 5 Click Save i S Cards across Down Sort by Sort Ato Z Select column District HIV Prevalence Females All Ages ANC 2010 HIV Prevalence Females All Ages ANC 2011 HIV Prevalence Females All Ages ANC 2012 No tested positive for HIV Females All Ages MOCK DATA No tested for HIV Females All Ages MOCK DATA Cancel Version January 2015 CE 3 2 Charts Video tutorial https www youtube com watch v r0hws10Sr9c The Chart function summarizes data into a chart format Start by adding a Chart as a new tab in your FusionTable 1 Select the red button E and choose Chart from the drop down menu 2 Anew tab Chart containing Chart options will appear Fa 7 jf os i F 4 n r f i F 3 Select your preferred Chart Type from the left e g bar chart YT 4 Coe z l 2 e if A X 3 3 2 1 Edit chart appearance Edit the data and format of your chart using the Configure Categorical chart options on the left side widow Category Change the indicator appearing on the x axis horizontal side of the chart Values Check the box next to the indicator s you wish to display as values on your chart Version January 2015 C Summarize Data Check the box and select the summary option you wish to display by indicator minimum values maximum values average etc Sort by Change the order of elements on the x axis e g A gt Z alphabetical High to low etc
Download Pdf Manuals
Related Search