90 INTRODUCTION TO INFORMATION SYSTEMS 6-19. EXCEL APPLICATION: 6-20. ACCESS APPL The board of directors at Heritage Dogs is meeting to con- The Springfield Animal Shelter sider how its website is serving the needs of volunteers program in which volunteers donors, and potential adoptive pet owners. The website animals in their homes and tia coordinator has asked you to create an Excel spreadsheet mals when the shelter facility is to help her analyze quarterly data for several key indicators ter care for a few weeks or a fey including percentage of repeat visitors, page views per visit, need. When the animal is heal and bounce rate. The bounce rate is the percentage of visi- the shelter will post its pictur tors who view only one page. Together, these are a measure Foster parents are given first h of website "stickiness" -the ability to keep visitors inte ested and coming back for more. Additionally, she wants on the shelter website, an two line charts that display website usage statistics r- are not required to do so. Volu d th is stored in an Access databa Animal Shelter database Cho6 Create the spreadsheet shown in Figure 6-21 and add calculations for Total Visitors, Percentage Repeat Visitors, Page Views per Visit, and Bounce Rate. To calculate Bounce Rate, divide Page Views by Single Page Views reports for the shelter manage information for each volunteer The first report will list al Create one line chart that shows Visits Total Visitors, and fied they wish to care for a ca Page Views Create a second line chart that shows the Bounce all active volunteers who wish Rate and the Percentage Repeat Customers For both charts report will list all inactive vo select a layout that includes a chart title, axis title, and a legend. preference. Review the infor How would you describe the pattern of website usage volunteers and suggest ot in terms of visits, total visitors, and page views? How would be useful to the shelter man you describe the website in terms of "stickiness"? FIGURE 6-21 Heritage Dogs website metrics a1 02 04 First Time Visitors Repeat Visitors Page Views Single Page Views 210 56