meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
accutrack:reportsmanual:charting-data [2020/01/15 16:20]
nick
accutrack:reportsmanual:charting-data [2020/01/27 15:22] (current)
santi [RETURNS TABLE]
Line 1: Line 1:
 ====== CHARTING DATA (CHARTS VISITS REPORT DETAILS) ====== ====== CHARTING DATA (CHARTS VISITS REPORT DETAILS) ======
  
-===== WEEKLY SIGN-INS =====+AccuSQL/​AccuTrack provides you with a powerful view of your center’s usage pattern via informative and colorful charts. AccuSQL/​AccuTrack uses Microsoft //Excel// for creating 10 charts and 6 pivot tables that provide a wealth of information on how your center is used. This includes usage per hour, day, and week, usage per class, and number of returns. To see these charts click on the “**Chart Visits**” button in the Reports screen. AccuSQL/​AccuTrack will generate the needed data and start //Excel// automatically. It will then pass commands to //Excel// to create the pivot tables and graph the charts. When done, it will display an //Excel Workbook// with the charts and tables.
  
-===== DAILY SIGN-INS =====+**Important:​** Let the Chart Visits report finish completely in Excel before you close the Excel program, or AccuSQL/​AccuTrack will display a warning message indicating it did not complete report building process successfully.
  
-===== SIGN-INS BY DAY (DAILY SIGN-INS 2 TAB) =====+<​note>​**Note:​** You will need MS Excel 97 or higher installed on your computer for the charting module to work.</​note>​
  
-===== SIGN-INS BY HOUR (HOURLY SIGN-INS TAB) =====+<​note>​**Note:​** All the charts and tables reflect attendance data for the selected __reporting period__.</​note>​
  
-===== NUMBER OF VISITORS BY HOUR (PEAK HOURS TAB) =====+<​note>​**Note:​** The charts show cumulative data. For example, if the reporting period is four weeks long and you select the //Sign-ins by Day// chart, the chart will reflect the __total__ sign-ins for each day of the week for the four-week period.</​note>​
  
-===== WEEKLY SIGN-IN TABLE =====+<note tip>​**Tip:​** You can view the different charts in Excel by simply clicking on the tabs at the bottom of the screen. To see all the tabs, click on the arrow buttons next to the tabs. \\ {{ :​accutrack:​reportsmanual:​chartingdata1.jpg?​nolink |}}</​note>​
  
-===== DAILY SIGN-IN TABLE =====+<note tip>​**Tip:​** If you hold the mouse pointer on a segment of the chart for a few seconds, Excel will display the name and value of that segment: \\ {{ :​accutrack:​reportsmanual:​chartingdata2.jpg?​nolink&​150 |}}</​note>​
  
-===== DAILY PEAK HOURS TABLE =====+<note tip>​**Tip:​** Once in Excel, you can apply any Excel functions including saving the workbook, changing chart type, typing your center’s name or notes on the chart, and printing.</​note>​
  
-===== SESSION TIME DISTRIBUTION BY WEEK (WEEKLY SESSION TIMES TAB) =====+The following pages describe the available charts and data.
  
-===== SESSION TIME OF SIGN-INS BY DAY (DAILY SESSION TIMES TAB) ===== 
  
-===== SESSION TIME OF SIGN-IN BY HOUR (HOURLY SESSION TIMES TAB) =====+==== WEEKLY ​SIGN-INS ====
  
-===== WEEKLY SESSIONS TABLE =====+{{ :​accutrack:​reportsmanual:​chartingdata3.jpg?​nolink |}}
  
-===== DAILY SESSIONS TABLE =====+This chart depicts the number of visits per week. On the vertical axis you will notice the week number. On the horizontal axis you will see the number of sign-ins. Each horizontal line represents one week, and is composed of several colored segments that represent the days of the week. You can see which days the colors represent by reading the conversion block above the chart. You can also hold the mouse pointer steady over a segment to see what it represents and its numeric value.
  
-===== NUMBER OF VISITS PER CLASS (VISITS PER ACTIVITY TAB) =====+<note tip>​**Tip:​** If you run this chart over the past year or past semester, you will be able to quickly find out your busiest weeks of the year or semester.</​note>​ 
 +==== DAILY SIGN-INS ​====
  
-===== VISITS PER ACTIVITY TABLE =====+{{ :​accutrack:​reportsmanual:​chartingdata4.jpg?​nolink |}}
  
-===== RETURN TIMES (RETURNS TAB) =====+This chart depicts the number of visits by day of the week. The vertical axis shows the number of sign-ins, while the horizontal axis shows the day of the week. Each vertical bar represents one day of the week. If the selected reporting period is larger than one week, the visits will be added for each day. Thus the chart represents the __cumulative__ number of visits for each day.
  
-===== RETURNS ​TABLE =====+<note tip>​**Tip:​** This chart is good for finding out your busiest day of the week.</​note>​ 
 + 
 + 
 + 
 +==== SIGN-INS BY DAY (DAILY SIGN-INS 2 TAB) ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata5.jpg?​nolink |}} 
 + 
 +Like the previous chart, this chart also depicts the number of visits by day of the week. However, each vertical bar is composed of segments representing the hours of the day. You can see which hours the colors represent by reading the conversion block above the chart. You can also hold the mouse pointer steady over a segment to see what it represents. 
 +Note that this chart also represents the __cumulative__ number of visits for each day and period of the day. 
 + 
 +<note tip>​**Tip:​** This chart is good for finding out your busiest day of the week and gives clues on the busiest time periods in each day.</​note>​ 
 + 
 +==== SIGN-INS BY HOUR (HOURLY SIGN-INS TAB) ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata6.jpg?​nolink |}} 
 + 
 +This chart depicts the number of visits by hour of the day. The vertical axis shows the number of visits, while the horizontal axis shows the hours of the day. Each vertical bar shows the number of visits per hourly time-period. The bar is segmented into colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart or by holding the mouse pointer steady over the segment. 
 + 
 +The number of visits shown in this chart is __cumulative__ for each hourly period. 
 + 
 +<note tip>​**Tip:​** This chart is good for finding out your busiest hours of the day and also shows which days are busiest during these hourly periods.</​note>​ 
 +==== NUMBER OF VISITORS BY HOUR (PEAK HOURS TAB) ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata7.jpg?​nolink |}} 
 + 
 +This chart depicts the number of visits by hour of the day. The vertical axis shows the number of visits, while the horizontal axis shows the hours of the day. Each vertical bar shows the number of visits per hourly time-period. The bar is segmented into colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart or by holding the mouse pointer steady over the segment. This chart shows a summary of guest sign-ins in addition to student sign-ins, unlike the ‘Number of Sign-Ins by Hour’ chart, which merely shows student sign-ins. 
 + 
 +The number of visits shown in this chart is __cumulative__ for each hourly period. 
 + 
 +<note tip>​**Tip:​** This chart is good for finding out your busiest hours of the day and also shows which days are busiest during these hourly periods.</​note>​ 
 +==== WEEKLY SIGN-IN ​TABLE ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata8.jpg?​nolink |}} 
 + 
 +This table shows the number of sign-ins for each week of the year split by week of the day. The rows are summed up to show the total number of sign-ins per week, and the columns are summed up to show the total number of sign-ins per day for all the weeks. 
 +==== DAILY SIGN-IN TABLE ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata9.jpg?​nolink |}} 
 + 
 +This table shows the number of sign-ins for each period of the day distributed per day of the week. The rows are summed up to show the total number of sign-ins per period, and the columns are summed up to show the total number of sign-ins per day for all the periods. 
 +==== DAILY PEAK HOURS TABLE ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata10.jpg?​nolink |}} 
 + 
 +This table shows the number of visitors for each period of the day distributed per day of the week. The rows are summed up to show the total number of visitors per period, and the columns are summed up to show the total number of visitors per day for all the periods. This chart is similar to the ‘Number of Sign-Ins’ table, except that it shows the guest sign-ins in addition to student sign-ins. This enables you to determine what the peak hours are for visitors during each day individually or throughout the week as a whole. 
 +==== SESSION TIME DISTRIBUTION BY WEEK (WEEKLY SESSION TIMES TAB) ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata11.jpg?​nolink |}} 
 + 
 +This chart depicts the length of the sign-in visit for each week of the year. On the vertical axis you will notice the week number, and on the horizontal axis you will see the total session times in hours. Each horizontal line represents one week, and is composed of several colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart. You can also hold the mouse pointer steady over a segment to see what it represents and its numeric value. 
 +==== SESSION TIME OF SIGN-INS BY DAY (DAILY SESSION TIMES TAB) ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata12.jpg?​nolink |}} 
 + 
 +This chart depicts the length of visits by day of the week. The vertical axis shows the length of sign-in sessions, while the horizontal axis shows the day of the week. Each vertical bar represents one day of the week. If the selected reporting period is larger than one week, the length of visits will be added for each day. Thus the chart represents the __cumulative__ session length for each day. 
 +==== SESSION TIME OF SIGN-IN BY HOUR (HOURLY SESSION TIMES TAB) ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata13.jpg?​nolink |}} 
 + 
 +This chart depicts length of the session for students signing in during that hour. The vertical axis shows the length of visits in hours, while the horizontal axis shows the hourly periods of the day. Each vertical bar shows the total length of visits per hourly time-period. The bar is segmented into colored segments that represent the day of the week. You can see which days the colors represent by reading the conversion block above the chart or by holding the mouse pointer steady over the segment. 
 + 
 +The number of visits shown in this chart is __cumulative__ for each hourly period. 
 + 
 +==== WEEKLY SESSIONS TABLE ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata14.jpg?​nolink |}} 
 + 
 +This table shows the length of sign-in periods for each week of the year split by week day. The rows are summed up to show the total hours of sign-ins per week, and the columns are summed up to show the total hours of sign-ins per day for all the weeks. 
 +==== DAILY SESSIONS TABLE ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata15.jpg?​nolink |}} 
 + 
 +This table shows the length of sign-in periods for visitors signing in during each hour of the day distributed by the days of the week. The rows are summed up to show the total hours of sign-ins periods per hour, and the columns are summed up to show the total sign-in hours per day for all the hourly periods. 
 +==== NUMBER OF VISITS PER CLASS (VISITS PER ACTIVITY TAB) ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata16.jpg?​nolink |}} 
 + 
 +This chart shows the number of sign-ins per activity (class/​service). The activities are grouped by their categories. The vertical axis shows the number of visits, while the horizontal axis shows the category of activities (subject area…). Each vertical bar shows the number of visits per activity. You can see which activity the bar represents by reading the conversion block above the chart or by holding the mouse pointer steady over the segment. 
 + 
 +<note tip>​**Tip:​** This chart is good for finding out usage patterns for each activity and which activities are mostly utilized.</​note>​ 
 +==== VISITS PER ACTIVITY TABLE ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata17.jpg?​nolink |}} 
 + 
 +This table shows the number of sign-ins for each activity (class /service) during the reporting period. 
 +==== RETURN TIMES (RETURNS TAB) ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata18.jpg?​nolink |}} 
 + 
 +This chart shows the number of repeat visits for your visitors. The vertical axis shows the number of students returning, while the horizontal axis shows the number of times these students returned. Each vertical bar shows the number of students that returned that many times. 
 + 
 +<note tip>​**Tip:​** This chart is good for finding out the frequency distribution of returning students.</​note>​ 
 +==== RETURNS TABLE ==== 
 + 
 +{{ :​accutrack:​reportsmanual:​chartingdata19.jpg?​nolink |}} 
 + 
 +This table shows the returning visits distribution during the reporting period. Each row shows the number of visits in the first column and the number of students who visited that many times in the second column.