UBC Wiki - User contributions [en]

ASIST/Cool Tool Days/Cool Tool Day 11

2013-01-08T00:04:00Z

Kifty:

Our next COOL TOOLS DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Tuesday, January 8th.

Planning on presenting? Add your name, your topic or tool, and any needed resources (e.g. a web link) to '''[[ASIST/Cool Tool Days/Cool Tool Day 11|the Cool Tools Day 11 page]]''' (use your CWL login). Aim for a <5 minute talk per tool.

You don't have to be an ASIS&T member to present or to put in a request. If you have any trouble editing '''[[ASIST/Cool Tool Days/Cool Tool Day 11 | the page]]''', you can also email any ASIS&T member as SLAIS. And if you don't want to commit to anything in advance, you can always just show up and, if there's time left, you'll be more than welcome to get up and talk about a tool.

Not interested in presenting? Interested in coffee and Timbits? Then come soak in some useful tech while enjoying a nice, steaming hot cup of coffee and a few donuts.

'''The first half of the Cool Tools Day will feature Angela Lam from Arts Instructional Support & Information Technology who will be giving an introduction to UBC Connect, the Online Learning Platform used by SLAIS.'''

'''Sign Up Here For a Slot in the second Half'''
*(5 minutes) Sam - [http://www.mendeley.com/ Mendeley]
*(5 minutes) Nick - [http://ankisrs.net/ Anki]
*(5 minutes) Kristof - [http://www.zotero.org/ Zotero]
*(5 minutes)
*(5 minutes)

Things you would like to see (requests/suggestions)?

''let us know!''

[[Category:ASIST]]

ASIST/Cool Tool Days

2013-01-08T00:02:40Z

Kifty:

= Upcoming Cool Tool Days =
{{:ASIST/Cool Tool Days/Cool Tool Day 11}}

= Previous Cool Tool Days =
<dpl>
format = ,\n,,
category = Cool_Tool_Days
ordermethod = firstedit
order = descending
include=*
</dpl>

ASIST/Cool Tool Days/Cool Tool Day 11

2013-01-08T00:00:04Z

Kifty:

Our next COOL TOOLS DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Tuesday, January 8th.

Planning on presenting? Add your name, your topic or tool, and any needed resources (e.g. a web link) to '''[[ASIST/Cool Tool Days/Cool Tool Day 11|the Cool Tools Day 11 page]]''' (use your CWL login). Aim for a <5 minute talk per tool.

You don't have to be an ASIS&T member to present or to put in a request. If you have any trouble editing '''[[ASIST/Cool Tool Days/Cool Tool Day 11 | the page]]''', you can also email any ASIS&T member as SLAIS. And if you don't want to commit to anything in advance, you can always just show up and, if there's time left, you'll be more than welcome to get up and talk about a tool.

Not interested in presenting? Interested in coffee and Timbits? Then come soak in some useful tech while enjoying a nice, steaming hot cup of coffee and a few donuts.

'''The first half of the Cool Tools Day will feature Angela Lam from Arts Instructional Support & Information Technology who will be giving an introduction to UBC Connect, the Online Learning Platform used by SLAIS.'''

'''Sign Up Here For a Slot in the second Half'''
*(5 minutes) Sam - Mendeley [http://www.mendeley.com/]
*(5 minutes) Nick - Anki [http://ankisrs.net/]
*(5 minutes) Kristof - Zotero [http://www.zotero.org/]
*(5 minutes)
*(5 minutes)

Things you would like to see (requests/suggestions)
<let us know>

[[Category:ASIST]]

ASIST/Cool Tool Days/Cool Tool Day 11

2013-01-07T23:57:01Z

Kifty: Created page with "Our next COOL TOOLS DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Tuesday, January 8th. Planning on presenting? Add your name, your topic or tool, and a..."

Our next COOL TOOLS DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Tuesday, January 8th.
Planning on presenting? Add your name, your topic or tool, and any needed resources (e.g. a web link) to '''[[ASIST/Cool Tool Days/Cool Tools Day 11|the Cool Tools Day 11 page]]''' (use your CWL login). Aim for a <5 minute talk per tool. 
You don't have to be an ASIS&T member to present or to put in a request. If you have any trouble editing '''[[ASIST/Cool Tool Days/Cool Tools Day 11 | the page]]''', you can also email any ASIS&T member as SLAIS. And if you don't want to commit to anything in advance, you can always just show up and, if there's time left, you'll be more than welcome to get up and talk about a tool.
Not interested in presenting? Interested in coffee and Timbits? Then come soak in some useful tech while enjoying a nice, steaming hot cup of coffee and a few donuts.

'''The first half of the Cool Tools Day will feature Angela Lam from Arts Instructional Support & Information Technology who will be giving an introduction to UBC Connect, the Online Learning Platform used by SLAIS.'''

'''Sign Up Here For a Slot in the second Half''' 
*(5 minutes) Sam - Mendeley [http://www.mendeley.com/] 
*(5 minutes) Nick - Anki [http://ankisrs.net/] 
*(5 minutes) Kristof - Zotero [http://www.zotero.org/] 
*(5 minutes) 
*(5 minutes)
Things you would like to see (requests/suggestions) 
<let us know>

[[Category:ASIST]]

ASIST/Cool Tool Days

2013-01-07T23:55:51Z

Kifty: /* Previous Cool Tool Days */

= Upcoming Cool Tool Days =
{{:ASIST/Cool Tool Days/Cool Tools Day 11}}

= Previous Cool Tool Days =
<dpl>
format = ,\n,,
category = Cool_Tool_Days
ordermethod = firstedit
order = descending
include=*
</dpl>

ASIST/Cool Tool Days/Cool Tool Day 10

2013-01-07T23:23:40Z

Kifty:

== Cool Tool Day #10: November 14, 2012 ==

'''The first half of the Cool Tools Day featureed UBC Geographic Information Systems (GIS) Librarian Tom Brittnacher who gave an overview of how GIS works and some of its applications.'''

* Sam - [http://grandperspectiv.sourceforge.net/ GrandPerspective]
* Kristof -
** [http://vis.stanford.edu/wrangler/ DataWrangler]
** [http://www.youtube.com/watch?v=jbkSRLYSojo Hans Rosling's 200 Countries, 200 Years, 4 Minutes - The Joy of Stats - BBC Four]
** [http://www.georeferencer.org/ Georeferencer]
** [https://www.youtube.com/watch?v=TpZuQkanbx4 Excel 2013 Tutorial Data Visualization - BI and Analytics]

[[Category:Cool Tool Days]]

Library:Workshop - Excel

2012-12-13T00:14:09Z

Kifty: /* Some helpful functions */

'''Instructors'''
* Jeremy Buhler, Assessment Librarian (jeremy.buhler@ubc.ca)
* Jonathan Kift, MLIS Candidate

== Purpose ==
Using a sample spreadsheet of anonymous Desk Tracker data, this hands-on workshop introduces some Excel functions for data manipulation, presentation, and analysis.

== Outline ==
* Introduction (5 min)
* User interface tips (5 min)
* Some helpful formulas (10 min)
* Questions & Practice (5 min)
* Pivot tables (20 min)
* Questions & Practice (10 min)
'''Download [http://wiki.ubc.ca/images/d/da/UBC_Library_Excel_workshop_sample_file.xlsx sample spreadsheet]'''

== User interface tips ==
===Footer summary===
* Located at the bottom left of the screen
;Average
: For numerical values, shows the average of the selected non-empty cells
;Count
: Shows the number of cells that are not empty in the selected range
;Sum
: For numerical values, shows the sum of the selected non-empty cells

===Freeze rows/columns===
# In the sample spreadsheet, select row 18
# From the ''View'' tab select ''Freeze panes''
# Choose ''Freeze panes''

* In general, ''Freeze panes'' will freeze all rows above the selected cell, and all columns left of the selected cell.

===Data Filters===
# Place cursor anywhere in the table
# From the ''Data'' tab select ''Filter''
# Arrows appear in each of the column headers; click them for table sorting and filtering options

* Notice how the list of items in the filter provides a summary list of the types of elements in the column you are filtering.

===Expanding the formula bar===
* If the formula you are working with gets too long, you can give yourself more "breathing room" by moving your mouse pointer to the bottom edge of the formula (until the cursor becomes a double-headed arrow), and dragging down.

===Hiding/un-hiding rows and columns===
# Select rows 3 to 16
# Right click highlighted rows and choose ''Unhide'' to expose the hidden table

==Some helpful functions==
===[http://office.microsoft.com/en-ca/excel-help/counta-function-HA102753080.aspx =COUNTA()]===
* Counts the number of cells that are not empty in a specified range
* The formula in cell '''K16''' counts all the entries in column '''G'''

===[http://office.microsoft.com/en-ca/excel-help/subtotal-function-HA102752856.aspx =SUBTOTAL()]===
* Counts the number of cells that are not empty in a specified range '''AND''' re-calculates according to filter settings
* The formula in cell '''K17''' counts all the visible entries in column '''G''' and updates when filters are applied

===[http://office.microsoft.com/en-ca/excel-help/countif-function-HA102753077.aspx =COUNTIF()]===
* Counts the number of cells in a range that meet the specified criteria
* Type the following into cell '''B7''' to count the number of ''Directional'' questions in column:
*: <code>=COUNTIF(G:G,A7)</code>
* Use the ''Fill'' function to extend the formula to other question types (cells '''A7:A12''')
* There are three ways to ''fill'' cells:
*# Click and drag the small square in the lower-right corner of the selected cell. (You will see the cursor turn into a black '''+''' when it is in the right place.)
*# Double-click the small square in the lower-right corner of the selected cell. This will automatically fill downward.
*# Select the region you want to fill, and then choose ''Fill->Down'' from the ''Home'' tab. This will only fill the region you have selected, and can fill in other directions if you like.

===[http://office.microsoft.com/en-ca/excel-help/sum-function-HA102752855.aspx =SUM()] and arithmetical formulas===
* Adds up all the cells in a range.
* Type the following into cell '''B13''' to get a total for the column:
*: <code>=SUM(B7:B12)</code>

* You can also create arithmetical formulas that don't contain functions at all.
* Type the following into cell '''C7''' to calculate the percent of the total:
*: <code>=B7/B13</code>

* Notice how this is a decimal value, and not a fraction. Click the "%" symbol in the ''Number'' section of the ''Home'' tab to format it properly.
* If you try to ''Fill'' this column, it won't work without a small change:
** Add a dollar sign to the formula like so:
**: <code>=B7/B'''$'''13</code>
* This forces the cell reference to stay on row 13. If we ''Fill'' now, it should work fine.

===[http://office.microsoft.com/en-ca/excel-help/text-function-HA102752840.aspx =TEXT()]===
* Can be used to display a date/time field in another format; to show the month for each row in the sample file, type the following in cell '''C18''':
*: <code>=TEXT(B18,"mmm")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

* Similarly, to show the day of the week for each row, add the following to cell '''D18''':
*: <code>=TEXT(B18,"ddd")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

==Pivot Tables==
Pivot tables can be a quick and flexible way to organize, visualize, and perform calculations on large data sets. They do not affect the source data and are excellent when you are looking at 2 or more dimensions of the data.

===Creating a basic pivot table===
# Place cursor anywhere in the source data
# From the ''Insert'' tab select ''Pivot table''
# Click ''OK''. The default settings will create a pivot table in a new worksheet
# Select the data to display by dragging items from the list on the right into the quadrants below:
::* drag ''Question type'' into the ''Row Labels'' quadrant
::* drag ''Question type'' into the ''Values'' quadrant

===Calculations and displayed values===
The example above displays a count for each question type but it's also possible to display percentages, % change, etc. In this example you will add a column showing percentage

# Drag ''Question type'' into the ''Values'' quadrant AGAIN. There will be two columns showing totals
# In the lower right ''Values'' quadrant, click the arrow on the second entry and select ''Value Field Settings''
# Switch to the ''Show Values As'' tab
# From the drop-down list select ''% of Grand Total'', then click ''OK''

===Pivot charts for visualization===
# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Column''; choose ''2D Clustered Column''(top left option)

The pivot table and chart are linked: changes to one affect the other which can be helpful for visual data exploration

# Drag ''Desk'' into the ''Column Labels'' quadrant
# Experiment by dragging other fields into ''Row'' or ''Column'' quadrants, switching from ''Row'' to ''Column'', etc.

===Changing chart type===
Different chart types highlight different aspects of your data. Sometimes changing the chart type will expose a narrative that was previously hidden. To change an existing chart to a different type:

# Right-click the chart area and select ''Change Chart Type''
# Choose the new type and click ''OK''

===Filters and slicers===
Filters add another dimension to tables and charts by limiting the displayed data

# Drag ''Month'' into the ''Report Filter'' quadrant
# Experiment with filtering options using the drop-down arrow in cell B1

A more intuitive visual filter called a ''Slicer'' is available in the '''Windows version only'''

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Slicer''
# Check ''Month'' and click ''OK''

[[Category:UBC_Library_Internal]]

Library:Workshop - Excel

2012-12-13T00:09:08Z

Kifty: /* =SUM() */

'''Instructors'''
* Jeremy Buhler, Assessment Librarian (jeremy.buhler@ubc.ca)
* Jonathan Kift, MLIS Candidate

== Purpose ==
Using a sample spreadsheet of anonymous Desk Tracker data, this hands-on workshop introduces some Excel functions for data manipulation, presentation, and analysis.

== Outline ==
* Introduction (5 min)
* User interface tips (5 min)
* Some helpful formulas (10 min)
* Questions & Practice (5 min)
* Pivot tables (20 min)
* Questions & Practice (10 min)
'''Download [http://wiki.ubc.ca/images/d/da/UBC_Library_Excel_workshop_sample_file.xlsx sample spreadsheet]'''

== User interface tips ==
===Footer summary===
* Located at the bottom left of the screen
;Average
: For numerical values, shows the average of the selected non-empty cells
;Count
: Shows the number of cells that are not empty in the selected range
;Sum
: For numerical values, shows the sum of the selected non-empty cells

===Freeze rows/columns===
# In the sample spreadsheet, select row 18
# From the ''View'' tab select ''Freeze panes''
# Choose ''Freeze panes''

* In general, ''Freeze panes'' will freeze all rows above the selected cell, and all columns left of the selected cell.

===Data Filters===
# Place cursor anywhere in the table
# From the ''Data'' tab select ''Filter''
# Arrows appear in each of the column headers; click them for table sorting and filtering options

* Notice how the list of items in the filter provides a summary list of the types of elements in the column you are filtering.

===Expanding the formula bar===
* If the formula you are working with gets too long, you can give yourself more "breathing room" by moving your mouse pointer to the bottom edge of the formula (until the cursor becomes a double-headed arrow), and dragging down.

===Hiding/un-hiding rows and columns===
# Select rows 3 to 16
# Right click highlighted rows and choose ''Unhide'' to expose the hidden table

==Some helpful functions==
===[http://office.microsoft.com/en-ca/excel-help/counta-function-HA102753080.aspx =COUNTA()]===
* Counts the number of cells that are not empty in a specified range
* The formula in cell '''K16''' counts all the entries in column '''G'''

===[http://office.microsoft.com/en-ca/excel-help/subtotal-function-HA102752856.aspx =SUBTOTAL()]===
* Counts the number of cells that are not empty in a specified range '''AND''' re-calculates according to filter settings
* The formula in cell '''K17''' counts all the visible entries in column '''G''' and updates when filters are applied

===[http://office.microsoft.com/en-ca/excel-help/countif-function-HA102753077.aspx =COUNTIF()]===
* Counts the number of cells in a range that meet the specified criteria
* Type the following into cell '''B7''' to count the number of ''Directional'' questions in column:
*: <code>=COUNTIF(G:G,A7)</code>
* Use the ''Fill'' function to extend the formula to other question types (cells '''A7:A12''')
* There are three ways to ''fill'' cells:
*# Click and drag the small square in the lower-right corner of the selected cell. (You will see the cursor turn into a black '''+''' when it is in the right place.)
*# Double-click the small square in the lower-right corner of the selected cell. This will automatically fill downward.
*# Select the region you want to fill, and then choose ''Fill->Down'' from the ''Home'' tab. This will only fill the region you have selected, and can fill in other directions if you like.

===[http://office.microsoft.com/en-ca/excel-help/sum-function-HA102752855.aspx =SUM()] and arithmetical formulas===
* Adds up all the cells in a range.
* Type the following into cell '''B13''' to get a total for the column:
*: <code>=SUM(B7:B12)</code>

* You can also create arithmetical formulas that don't contain functions at all.
* Type the following into cell '''C7''' to calculate the percent of the total:
*: <code>=B7/B13</code>
* Notice how this is a decimal value, and not a fraction. Click the "%" symbol in the ''Number'' section of the ''Home'' tab to format it properly.
* If you try to ''Fill'' this column, it won't work without a small change:
** Add a dollar sign to the formula like so:
**: <code>=B7/B'''$'''13</code>
* This forces the cell reference to stay on row 13. If we ''Fill'' now, it should work fine.

===[http://office.microsoft.com/en-ca/excel-help/text-function-HA102752840.aspx =TEXT()]===
* Can be used to display a date/time field in another format; to show the month for each row in the sample file, type the following in cell '''C18''':
*: <code>=TEXT(B18,"mmm")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

* Similarly, to show the day of the week for each row, add the following to cell '''D18''':
*: <code>=TEXT(B18,"ddd")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

==Pivot Tables==
Pivot tables can be a quick and flexible way to organize, visualize, and perform calculations on large data sets. They do not affect the source data and are excellent when you are looking at 2 or more dimensions of the data.

===Creating a basic pivot table===
# Place cursor anywhere in the source data
# From the ''Insert'' tab select ''Pivot table''
# Click ''OK''. The default settings will create a pivot table in a new worksheet
# Select the data to display by dragging items from the list on the right into the quadrants below:
::* drag ''Question type'' into the ''Row Labels'' quadrant
::* drag ''Question type'' into the ''Values'' quadrant

===Calculations and displayed values===
The example above displays a count for each question type but it's also possible to display percentages, % change, etc. In this example you will add a column showing percentage

# Drag ''Question type'' into the ''Values'' quadrant AGAIN. There will be two columns showing totals
# In the lower right ''Values'' quadrant, click the arrow on the second entry and select ''Value Field Settings''
# Switch to the ''Show Values As'' tab
# From the drop-down list select ''% of Grand Total'', then click ''OK''

===Pivot charts for visualization===
# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Column''; choose ''2D Clustered Column''(top left option)

The pivot table and chart are linked: changes to one affect the other which can be helpful for visual data exploration

# Drag ''Desk'' into the ''Column Labels'' quadrant
# Experiment by dragging other fields into ''Row'' or ''Column'' quadrants, switching from ''Row'' to ''Column'', etc.

===Changing chart type===
Different chart types highlight different aspects of your data. Sometimes changing the chart type will expose a narrative that was previously hidden. To change an existing chart to a different type:

# Right-click the chart area and select ''Change Chart Type''
# Choose the new type and click ''OK''

===Filters and slicers===
Filters add another dimension to tables and charts by limiting the displayed data

# Drag ''Month'' into the ''Report Filter'' quadrant
# Experiment with filtering options using the drop-down arrow in cell B1

A more intuitive visual filter called a ''Slicer'' is available in the '''Windows version only'''

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Slicer''
# Check ''Month'' and click ''OK''

[[Category:UBC_Library_Internal]]

Library:Workshop - Excel

2012-12-13T00:08:03Z

Kifty: /* =SUM() */

'''Instructors'''
* Jeremy Buhler, Assessment Librarian (jeremy.buhler@ubc.ca)
* Jonathan Kift, MLIS Candidate

== Purpose ==
Using a sample spreadsheet of anonymous Desk Tracker data, this hands-on workshop introduces some Excel functions for data manipulation, presentation, and analysis.

== Outline ==
* Introduction (5 min)
* User interface tips (5 min)
* Some helpful formulas (10 min)
* Questions & Practice (5 min)
* Pivot tables (20 min)
* Questions & Practice (10 min)
'''Download [http://wiki.ubc.ca/images/d/da/UBC_Library_Excel_workshop_sample_file.xlsx sample spreadsheet]'''

== User interface tips ==
===Footer summary===
* Located at the bottom left of the screen
;Average
: For numerical values, shows the average of the selected non-empty cells
;Count
: Shows the number of cells that are not empty in the selected range
;Sum
: For numerical values, shows the sum of the selected non-empty cells

===Freeze rows/columns===
# In the sample spreadsheet, select row 18
# From the ''View'' tab select ''Freeze panes''
# Choose ''Freeze panes''

* In general, ''Freeze panes'' will freeze all rows above the selected cell, and all columns left of the selected cell.

===Data Filters===
# Place cursor anywhere in the table
# From the ''Data'' tab select ''Filter''
# Arrows appear in each of the column headers; click them for table sorting and filtering options

* Notice how the list of items in the filter provides a summary list of the types of elements in the column you are filtering.

===Expanding the formula bar===
* If the formula you are working with gets too long, you can give yourself more "breathing room" by moving your mouse pointer to the bottom edge of the formula (until the cursor becomes a double-headed arrow), and dragging down.

===Hiding/un-hiding rows and columns===
# Select rows 3 to 16
# Right click highlighted rows and choose ''Unhide'' to expose the hidden table

==Some helpful functions==
===[http://office.microsoft.com/en-ca/excel-help/counta-function-HA102753080.aspx =COUNTA()]===
* Counts the number of cells that are not empty in a specified range
* The formula in cell '''K16''' counts all the entries in column '''G'''

===[http://office.microsoft.com/en-ca/excel-help/subtotal-function-HA102752856.aspx =SUBTOTAL()]===
* Counts the number of cells that are not empty in a specified range '''AND''' re-calculates according to filter settings
* The formula in cell '''K17''' counts all the visible entries in column '''G''' and updates when filters are applied

===[http://office.microsoft.com/en-ca/excel-help/countif-function-HA102753077.aspx =COUNTIF()]===
* Counts the number of cells in a range that meet the specified criteria
* Type the following into cell '''B7''' to count the number of ''Directional'' questions in column:
*: <code>=COUNTIF(G:G,A7)</code>
* Use the ''Fill'' function to extend the formula to other question types (cells '''A7:A12''')
* There are three ways to ''fill'' cells:
*# Click and drag the small square in the lower-right corner of the selected cell. (You will see the cursor turn into a black '''+''' when it is in the right place.)
*# Double-click the small square in the lower-right corner of the selected cell. This will automatically fill downward.
*# Select the region you want to fill, and then choose ''Fill->Down'' from the ''Home'' tab. This will only fill the region you have selected, and can fill in other directions if you like.

===[http://office.microsoft.com/en-ca/excel-help/sum-function-HA102752855.aspx =SUM()]===
* Adds up all the cells in a range.
* Type the following into cell '''B13''' to get a total for the column:
*: <code>=SUM(B7:B12)</code>

* You can also create arithmetical formulas that don't contain functions at all.
* Type the following into cell '''C7''' to calculate the percent of the total:
*: <code>=B7/B13</code>
* Notice how this is a decimal value, and not a fraction. Click the "%" symbol in the ''Number'' section of the ''Home'' tab to format it properly.
* If you try to ''Fill'' this column, it won't work without a small change:
** Add a dollar sign to the formula like so:
**: <code>=B7/B'''$'''13</code>
* This forces the cell reference to stay on row 13. If we ''Fill'' now, it should work fine.

===[http://office.microsoft.com/en-ca/excel-help/text-function-HA102752840.aspx =TEXT()]===
* Can be used to display a date/time field in another format; to show the month for each row in the sample file, type the following in cell '''C18''':
*: <code>=TEXT(B18,"mmm")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

* Similarly, to show the day of the week for each row, add the following to cell '''D18''':
*: <code>=TEXT(B18,"ddd")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

==Pivot Tables==
Pivot tables can be a quick and flexible way to organize, visualize, and perform calculations on large data sets. They do not affect the source data and are excellent when you are looking at 2 or more dimensions of the data.

===Creating a basic pivot table===
# Place cursor anywhere in the source data
# From the ''Insert'' tab select ''Pivot table''
# Click ''OK''. The default settings will create a pivot table in a new worksheet
# Select the data to display by dragging items from the list on the right into the quadrants below:
::* drag ''Question type'' into the ''Row Labels'' quadrant
::* drag ''Question type'' into the ''Values'' quadrant

===Calculations and displayed values===
The example above displays a count for each question type but it's also possible to display percentages, % change, etc. In this example you will add a column showing percentage

# Drag ''Question type'' into the ''Values'' quadrant AGAIN. There will be two columns showing totals
# In the lower right ''Values'' quadrant, click the arrow on the second entry and select ''Value Field Settings''
# Switch to the ''Show Values As'' tab
# From the drop-down list select ''% of Grand Total'', then click ''OK''

===Pivot charts for visualization===
# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Column''; choose ''2D Clustered Column''(top left option)

The pivot table and chart are linked: changes to one affect the other which can be helpful for visual data exploration

# Drag ''Desk'' into the ''Column Labels'' quadrant
# Experiment by dragging other fields into ''Row'' or ''Column'' quadrants, switching from ''Row'' to ''Column'', etc.

===Changing chart type===
Different chart types highlight different aspects of your data. Sometimes changing the chart type will expose a narrative that was previously hidden. To change an existing chart to a different type:

# Right-click the chart area and select ''Change Chart Type''
# Choose the new type and click ''OK''

===Filters and slicers===
Filters add another dimension to tables and charts by limiting the displayed data

# Drag ''Month'' into the ''Report Filter'' quadrant
# Experiment with filtering options using the drop-down arrow in cell B1

A more intuitive visual filter called a ''Slicer'' is available in the '''Windows version only'''

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Slicer''
# Check ''Month'' and click ''OK''

[[Category:UBC_Library_Internal]]

Library:Workshop - Excel

2012-12-13T00:07:31Z

Kifty: /* Some helpful formulas */

'''Instructors'''
* Jeremy Buhler, Assessment Librarian (jeremy.buhler@ubc.ca)
* Jonathan Kift, MLIS Candidate

== Purpose ==
Using a sample spreadsheet of anonymous Desk Tracker data, this hands-on workshop introduces some Excel functions for data manipulation, presentation, and analysis.

== Outline ==
* Introduction (5 min)
* User interface tips (5 min)
* Some helpful formulas (10 min)
* Questions & Practice (5 min)
* Pivot tables (20 min)
* Questions & Practice (10 min)
'''Download [http://wiki.ubc.ca/images/d/da/UBC_Library_Excel_workshop_sample_file.xlsx sample spreadsheet]'''

== User interface tips ==
===Footer summary===
* Located at the bottom left of the screen
;Average
: For numerical values, shows the average of the selected non-empty cells
;Count
: Shows the number of cells that are not empty in the selected range
;Sum
: For numerical values, shows the sum of the selected non-empty cells

===Freeze rows/columns===
# In the sample spreadsheet, select row 18
# From the ''View'' tab select ''Freeze panes''
# Choose ''Freeze panes''

* In general, ''Freeze panes'' will freeze all rows above the selected cell, and all columns left of the selected cell.

===Data Filters===
# Place cursor anywhere in the table
# From the ''Data'' tab select ''Filter''
# Arrows appear in each of the column headers; click them for table sorting and filtering options

* Notice how the list of items in the filter provides a summary list of the types of elements in the column you are filtering.

===Expanding the formula bar===
* If the formula you are working with gets too long, you can give yourself more "breathing room" by moving your mouse pointer to the bottom edge of the formula (until the cursor becomes a double-headed arrow), and dragging down.

===Hiding/un-hiding rows and columns===
# Select rows 3 to 16
# Right click highlighted rows and choose ''Unhide'' to expose the hidden table

==Some helpful functions==
===[http://office.microsoft.com/en-ca/excel-help/counta-function-HA102753080.aspx =COUNTA()]===
* Counts the number of cells that are not empty in a specified range
* The formula in cell '''K16''' counts all the entries in column '''G'''

===[http://office.microsoft.com/en-ca/excel-help/subtotal-function-HA102752856.aspx =SUBTOTAL()]===
* Counts the number of cells that are not empty in a specified range '''AND''' re-calculates according to filter settings
* The formula in cell '''K17''' counts all the visible entries in column '''G''' and updates when filters are applied

===[http://office.microsoft.com/en-ca/excel-help/countif-function-HA102753077.aspx =COUNTIF()]===
* Counts the number of cells in a range that meet the specified criteria
* Type the following into cell '''B7''' to count the number of ''Directional'' questions in column:
*: <code>=COUNTIF(G:G,A7)</code>
* Use the ''Fill'' function to extend the formula to other question types (cells '''A7:A12''')
* There are three ways to ''fill'' cells:
*# Click and drag the small square in the lower-right corner of the selected cell. (You will see the cursor turn into a black '''+''' when it is in the right place.)
*# Double-click the small square in the lower-right corner of the selected cell. This will automatically fill downward.
*# Select the region you want to fill, and then choose ''Fill->Down'' from the ''Home'' tab. This will only fill the region you have selected, and can fill in other directions if you like.

===[http://office.microsoft.com/en-ca/excel-help/sum-function-HA102752855.aspx =SUM()]===
* Adds up all the cells in a range.
* Type the following into cell '''B13''' to get a total for the column:
*: <code>=SUM(B7:B12)</code>

* You can also create arithmetical formulas that don't contain functions at all.
* Type the following into cell '''C7''' to calculate the percent of the total:
*: <code>=B7/B13</code>
* Notice how this is a decimal value, and not a fraction. Click the "%" symbol in the ''Number'' section of the ''Home'' tab to format it properly.
* If you try to ''Fill'' this column, it won't work without a small change:
** Add a dollar sign to the formula like so:
**: <code>=B7/B$13</code>
* This forces the cell reference to stay on row 13. If we ''Fill'' now, it should work fine.

===[http://office.microsoft.com/en-ca/excel-help/text-function-HA102752840.aspx =TEXT()]===
* Can be used to display a date/time field in another format; to show the month for each row in the sample file, type the following in cell '''C18''':
*: <code>=TEXT(B18,"mmm")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

* Similarly, to show the day of the week for each row, add the following to cell '''D18''':
*: <code>=TEXT(B18,"ddd")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

==Pivot Tables==
Pivot tables can be a quick and flexible way to organize, visualize, and perform calculations on large data sets. They do not affect the source data and are excellent when you are looking at 2 or more dimensions of the data.

===Creating a basic pivot table===
# Place cursor anywhere in the source data
# From the ''Insert'' tab select ''Pivot table''
# Click ''OK''. The default settings will create a pivot table in a new worksheet
# Select the data to display by dragging items from the list on the right into the quadrants below:
::* drag ''Question type'' into the ''Row Labels'' quadrant
::* drag ''Question type'' into the ''Values'' quadrant

===Calculations and displayed values===
The example above displays a count for each question type but it's also possible to display percentages, % change, etc. In this example you will add a column showing percentage

# Drag ''Question type'' into the ''Values'' quadrant AGAIN. There will be two columns showing totals
# In the lower right ''Values'' quadrant, click the arrow on the second entry and select ''Value Field Settings''
# Switch to the ''Show Values As'' tab
# From the drop-down list select ''% of Grand Total'', then click ''OK''

===Pivot charts for visualization===
# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Column''; choose ''2D Clustered Column''(top left option)

The pivot table and chart are linked: changes to one affect the other which can be helpful for visual data exploration

# Drag ''Desk'' into the ''Column Labels'' quadrant
# Experiment by dragging other fields into ''Row'' or ''Column'' quadrants, switching from ''Row'' to ''Column'', etc.

===Changing chart type===
Different chart types highlight different aspects of your data. Sometimes changing the chart type will expose a narrative that was previously hidden. To change an existing chart to a different type:

# Right-click the chart area and select ''Change Chart Type''
# Choose the new type and click ''OK''

===Filters and slicers===
Filters add another dimension to tables and charts by limiting the displayed data

# Drag ''Month'' into the ''Report Filter'' quadrant
# Experiment with filtering options using the drop-down arrow in cell B1

A more intuitive visual filter called a ''Slicer'' is available in the '''Windows version only'''

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Slicer''
# Check ''Month'' and click ''OK''

[[Category:UBC_Library_Internal]]

Library:Workshop - Excel

2012-12-12T23:18:42Z

Kifty: /* User interface tips */

'''Instructors'''
* Jeremy Buhler, Assessment Librarian (jeremy.buhler@ubc.ca)
* Jonathan Kift, MLIS Candidate

== Purpose ==
Using a sample spreadsheet of anonymous Desk Tracker data, this hands-on workshop introduces some Excel functions for data manipulation, presentation, and analysis.

== Outline ==
* Introduction (5 min)
* User interface tips (5 min)
* Some helpful formulas (10 min)
* Questions & Practice (5 min)
* Pivot tables (20 min)
* Questions & Practice (10 min)
'''Download [http://wiki.ubc.ca/images/d/da/UBC_Library_Excel_workshop_sample_file.xlsx sample spreadsheet]'''

== User interface tips ==
===Footer summary===
* Located at the bottom left of the screen
;Average
: For numerical values, shows the average of the selected non-empty cells
;Count
: Shows the number of cells that are not empty in the selected range
;Sum
: For numerical values, shows the sum of the selected non-empty cells

===Freeze rows/columns===
# In the sample spreadsheet, select row 18
# From the ''View'' tab select ''Freeze panes''
# Choose ''Freeze panes''

* In general, ''Freeze panes'' will freeze all rows above the selected cell, and all columns left of the selected cell.

===Data Filters===
# Place cursor anywhere in the table
# From the ''Data'' tab select ''Filter''
# Arrows appear in each of the column headers; click them for table sorting and filtering options

* Notice how the list of items in the filter provides a summary list of the types of elements in the column you are filtering.

===Expanding the formula bar===
* If the formula you are working with gets too long, you can give yourself more "breathing room" by moving your mouse pointer to the bottom edge of the formula (until the cursor becomes a double-headed arrow), and dragging down.

===Hiding/un-hiding rows and columns===
# Select rows 3 to 16
# Right click highlighted rows and choose ''Unhide'' to expose the hidden table

==Some helpful formulas==
===[http://office.microsoft.com/en-ca/excel-help/counta-function-HA102753080.aspx =COUNTA()]===
* Counts the number of cells that are not empty in a specified range
* The formula in cell J16 counts all the entries in column F

===[http://office.microsoft.com/en-ca/excel-help/subtotal-function-HA102752856.aspx =SUBTOTAL()]===
* Counts the number of cells that are not empty in a specified range '''AND''' re-calculates according to filter settings
* The formula in cell J17 counts all the visible entries in column F and updates when filters are applied

===[http://office.microsoft.com/en-ca/excel-help/countif-function-HA102753077.aspx =COUNTIF()]===
* Counts the number of cells in a range that meet the specified criteria
* Type the following into cell B7 to count the number of ''Directional'' questions in column :
*: <code>=COUNTIF(F:F,A7)</code>
* Use the ''Fill'' function to extend the formula to other question types (cells A7:A12)

===[http://office.microsoft.com/en-ca/excel-help/text-function-HA102752840.aspx =TEXT()]===
* Can be used to display a date/time field in another format; to show the month for each row in the sample file, type the following in cell C18:
*: <code>=TEXT(B18,"mmm")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

==Pivot Tables==
Pivot tables can be a quick and flexible way to organize, visualize, and perform calculations on large data sets. They do not affect the source data and are excellent when you are looking at 2 or more dimensions of the data.

===Creating a basic pivot table===
# Place cursor anywhere in the source data
# From the ''Insert'' tab select ''Pivot table''
# Click ''OK''. The default settings will create a pivot table in a new worksheet
# Select the data to display by dragging items from the list on the right into the quadrants below:
::* drag ''Question type'' into the ''Row Labels'' quadrant
::* drag ''Question type'' into the ''Values'' quadrant

===Calculations and displayed values===
The example above displays a count for each question type but it's also possible to display percentages, % change, etc. In this example you will add a column showing percentage

# Drag ''Question type'' into the ''Values'' quadrant AGAIN. There will be two columns showing totals
# In the lower right ''Values'' quadrant, click the arrow on the second entry and select ''Value Field Settings''
# Switch to the ''Show Values As'' tab
# From the drop-down list select ''% of Grand Total'', then click ''OK''

===Pivot charts for visualization===
# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Column''; choose ''2D Clustered Column''(top left option)

The pivot table and chart are linked: changes to one affect the other which can be helpful for visual data exploration

# Drag ''Desk'' into the ''Column Labels'' quadrant
# Experiment by dragging other fields into ''Row'' or ''Column'' quadrants, switching from ''Row'' to ''Column'', etc.

===Changing chart type===
Different chart types highlight different aspects of your data. Sometimes changing the chart type will expose a narrative that was previously hidden. To change an existing chart to a different type:

# Right-click the chart area and select ''Change Chart Type''
# Choose the new type and click ''OK''

===Filters and slicers===
Filters add another dimension to tables and charts by limiting the displayed data

# Drag ''Month'' into the ''Report Filter'' quadrant
# Experiment with filtering options using the drop-down arrow in cell B1

A more intuitive visual filter called a ''Slicer'' is available in the '''Windows version only'''

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Slicer''
# Check ''Month'' and click ''OK''

[[Category:UBC_Library_Internal]]

Library:Workshop - Excel

2012-12-12T23:17:21Z

Kifty:

'''Instructors'''
* Jeremy Buhler, Assessment Librarian (jeremy.buhler@ubc.ca)
* Jonathan Kift, MLIS Candidate

== Purpose ==
Using a sample spreadsheet of anonymous Desk Tracker data, this hands-on workshop introduces some Excel functions for data manipulation, presentation, and analysis.

== Outline ==
* Introduction (5 min)
* User interface tips (5 min)
* Some helpful formulas (10 min)
* Questions & Practice (5 min)
* Pivot tables (20 min)
* Questions & Practice (10 min)
'''Download [http://wiki.ubc.ca/images/d/da/UBC_Library_Excel_workshop_sample_file.xlsx sample spreadsheet]'''

== User interface tips ==
===Footer summary===
;Average
: For numerical values, shows the average of the selected non-empty cells
;Count
: Shows the number of cells that are not empty in the selected range
;Sum
: For numerical values, shows the sum of the selected non-empty cells

===Freeze rows/columns===
# In the sample spreadsheet, select row 18
# From the ''View'' tab select ''Freeze panes''
# Choose ''Freeze panes''

* In general, ''Freeze panes'' will freeze all rows above the selected cell, and all columns left of the selected cell.

===Data Filters===
# Place cursor anywhere in the table
# From the ''Data'' tab select ''Filter''
# Arrows appear in each of the column headers; click them for table sorting and filtering options

* Notice how the list of items in the filter provides a summary list of the types of elements in the column you are filtering.

===Expanding the formula bar===
* If the formula you are working with gets too long, you can give yourself more "breathing room" by moving your mouse pointer to the bottom edge of the formula (until the cursor becomes a double-headed arrow), and dragging down.

===Hiding/un-hiding rows and columns===
# Select rows 3 to 16
# Right click highlighted rows and choose ''Unhide'' to expose the hidden table

==Some helpful formulas==
===[http://office.microsoft.com/en-ca/excel-help/counta-function-HA102753080.aspx =COUNTA()]===
* Counts the number of cells that are not empty in a specified range
* The formula in cell J16 counts all the entries in column F

===[http://office.microsoft.com/en-ca/excel-help/subtotal-function-HA102752856.aspx =SUBTOTAL()]===
* Counts the number of cells that are not empty in a specified range '''AND''' re-calculates according to filter settings
* The formula in cell J17 counts all the visible entries in column F and updates when filters are applied

===[http://office.microsoft.com/en-ca/excel-help/countif-function-HA102753077.aspx =COUNTIF()]===
* Counts the number of cells in a range that meet the specified criteria
* Type the following into cell B7 to count the number of ''Directional'' questions in column :
*: <code>=COUNTIF(F:F,A7)</code>
* Use the ''Fill'' function to extend the formula to other question types (cells A7:A12)

===[http://office.microsoft.com/en-ca/excel-help/text-function-HA102752840.aspx =TEXT()]===
* Can be used to display a date/time field in another format; to show the month for each row in the sample file, type the following in cell C18:
*: <code>=TEXT(B18,"mmm")</code>
* Use the ''Fill'' function to extend the formula to all cells in the column

==Pivot Tables==
Pivot tables can be a quick and flexible way to organize, visualize, and perform calculations on large data sets. They do not affect the source data and are excellent when you are looking at 2 or more dimensions of the data.

===Creating a basic pivot table===
# Place cursor anywhere in the source data
# From the ''Insert'' tab select ''Pivot table''
# Click ''OK''. The default settings will create a pivot table in a new worksheet
# Select the data to display by dragging items from the list on the right into the quadrants below:
::* drag ''Question type'' into the ''Row Labels'' quadrant
::* drag ''Question type'' into the ''Values'' quadrant

===Calculations and displayed values===
The example above displays a count for each question type but it's also possible to display percentages, % change, etc. In this example you will add a column showing percentage

# Drag ''Question type'' into the ''Values'' quadrant AGAIN. There will be two columns showing totals
# In the lower right ''Values'' quadrant, click the arrow on the second entry and select ''Value Field Settings''
# Switch to the ''Show Values As'' tab
# From the drop-down list select ''% of Grand Total'', then click ''OK''

===Pivot charts for visualization===
# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Column''; choose ''2D Clustered Column''(top left option)

The pivot table and chart are linked: changes to one affect the other which can be helpful for visual data exploration

# Drag ''Desk'' into the ''Column Labels'' quadrant
# Experiment by dragging other fields into ''Row'' or ''Column'' quadrants, switching from ''Row'' to ''Column'', etc.

===Changing chart type===
Different chart types highlight different aspects of your data. Sometimes changing the chart type will expose a narrative that was previously hidden. To change an existing chart to a different type:

# Right-click the chart area and select ''Change Chart Type''
# Choose the new type and click ''OK''

===Filters and slicers===
Filters add another dimension to tables and charts by limiting the displayed data

# Drag ''Month'' into the ''Report Filter'' quadrant
# Experiment with filtering options using the drop-down arrow in cell B1

A more intuitive visual filter called a ''Slicer'' is available in the '''Windows version only'''

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Slicer''
# Check ''Month'' and click ''OK''

[[Category:UBC_Library_Internal]]

Library:Workshop - Excel

2012-12-12T00:00:00Z

Kifty: /* Some helpful formulas */

'''Instructors'''
* Jeremy Buhler, Assessment Librarian (jeremy.buhler@ubc.ca)
* Jonathan Kift, MLIS Candidate

== Purpose ==

Using a sample spreadsheet of anonymized Desk Tracker data, this hands-on workshop introduces some Excel functions for data manipulation, presentation, and analysis.
 

== Outline ==

*Introduction (5 min)
*User interface tips (5 min)
*Some helpful formulas (10 min)
*Questions & Practice (5 min)
*Pivot tables (20 min)
*Questions & Practice (10 min)

=====Download [http://wiki.ubc.ca/images/d/da/UBC_Library_Excel_workshop_sample_file.xlsx sample spreadsheet]=====
 
== User interface tips ==

===Footer summary===

*'''Average'''
::For numerical values, shows the average of the selected non-empty cells
*'''Count'''
::Shows the number of cells that are not empty in the selected range
*'''Sum'''
::For numerical values, shows the sum of the selected non-empty cells

===Freeze rows/columns===

# In the sample spreadsheet, select row 18
# From the ''View'' tab select ''Freeze panes''
# Choose ''Freeze panes''
 
===Data Filters===

# Place cursor anywhere in the table
# From the ''Data'' tab select ''Filter''
# Arrows appear in each of the column headers; click them for table sorting and filtering options
 
===Hiding/un-hiding rows and columns===

# Select rows 3 to 16
# Right click highlighted rows and choose ''Unhide'' to expose the hidden table
 

==Some helpful formulas==

*=COUNTA()
::* Counts the number of cells that are not empty in a specified range
::* The formula in cell J16 counts all the entries in column F
 
*=SUBTOTAL()
::* Counts the number of cells that are not empty in a specified range '''AND''' re-calculates according to filter settings
::* The formula in cell J17 counts all the visible entries in column F and updates when filters are applied

 
*=COUNTIF()
::* Counts the number of cells in a range that meet the specified criteria
::* Type the following into cell B7 to count the number of ''Directional'' questions in column :
::::''=COUNTIF(F:F,A7)''
 
::* Use the ''Fill'' function to extend the formula to other question types (cells A7:A12)
 
*=TEXT()
::* Can be used to display a date/time field in another format; to show the month for each row in the sample file, type the following in cell C18:
::::''=TEXT(B18,"mmm")''
 
::* Use the ''Fill'' function to extend the formula to all cells in the column
 

==Pivot Tables==

Pivot tables can be a quick and flexible way to organize, visualize, and perform calculations on large data sets. They do not affect the source data and are excellent when you are looking at 2 or more dimensions of the data.

===Creating a basic pivot table===

# Place cursor in top left of data set (cell A17)
# From the ''Insert'' tab select ''Pivot table''
# Click ''OK''. The default settings will create a pivot table in a new worksheet
# Select the data to display by dragging items from the list on the right into the quadrants below:

::* drag ''Question type'' into the ''Row Labels'' quadrant
::* drag ''Question type'' into the ''Values'' quadrant
 
===Calculations and displayed values===

The example above displays a count for each question type but it's also possible to display percentages, % change, etc. In this example you will add a column showing percentage

# Drag ''Question type'' into the ''Values'' quadrant AGAIN. There will be two columns showing totals
# In the lower right ''Values'' quadrant, click the arrow on the second entry and select ''Value Field Settings''
# Switch to the ''Show Values As'' tab
# From the drop-down list select ''% of Grand Total'', then click ''OK''

 
===Pivot charts for visualization===

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Column''; choose ''2D Clustered Column''(top left option)
 
The pivot table and chart are linked: changes to one affect the other which can be helpful for visual data exploration

# Drag ''Month'' into the ''Column Labels'' quadrant
# Experiment by dragging other fields into ''Row'' or ''Column'' quadrants, switching from ''Row'' to ''Column'', etc.
 
===Filters and slicers===

Filters add another dimension to tables and charts by limiting the displayed data

# Drag ''Contact method'' into the ''Report Filter'' quadrant
# Experiment with filtering options using the drop-down arrow in cell B1
 
A more intuitive visual filter called a ''Slicer'' is available in the '''Windows version only'''

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Slicer''
# Check ''Contact method'' and click ''OK''

[[Category:UBC_Library_Internal]]

Library:Workshop - Excel

2012-12-11T23:42:47Z

Kifty: Added a category

'''Instructors'''
* Jeremy Buhler, Assessment Librarian (jeremy.buhler@ubc.ca)
* Jonathan Kift, MLIS Candidate

== Purpose ==

Using a sample spreadsheet of anonymized Desk Tracker data, this hands-on workshop introduces some Excel functions for data manipulation, presentation, and analysis.
 

== Outline ==

*Introduction (5 min)
*User interface tips (5 min)
*Some helpful formulas (10 min)
*Questions & Practice (5 min)
*Pivot tables (20 min)
*Questions & Practice (10 min)

=====Download [http://wiki.ubc.ca/images/d/da/UBC_Library_Excel_workshop_sample_file.xlsx sample spreadsheet]=====
 
== User interface tips ==

===Footer summary===

*'''Average'''
::For numerical values, shows the average of the selected non-empty cells
*'''Count'''
::Shows the number of cells that are not empty in the selected range
*'''Sum'''
::For numerical values, shows the sum of the selected non-empty cells

===Freeze rows/columns===

# In the sample spreadsheet, select row 18
# From the ''View'' tab select ''Freeze panes''
# Choose ''Freeze panes''
 
===Data Filters===

# Place cursor anywhere in the table
# From the ''Data'' tab select ''Filter''
# Arrows appear in each of the column headers; click them for table sorting and filtering options
 
===Hiding/un-hiding rows and columns===

# Select rows 3 to 16
# Right click highlighted rows and choose ''Unhide'' to expose the hidden table
 

==Some helpful formulas==

*=TEXT()
::* Can be used to display a date/time field in another format; to show the month for each row in the sample file, type the following in cell C18:
::::''=TEXT(B18,"mmm")''
 
::* Use the ''Fill'' function to extend the formula to all cells in the column
 
*=COUNTA()
::* Counts the number of cells that are not empty in a specified range
::* The formula in cell J16 counts all the entries in column F
 
*=SUBTOTAL()
::* Counts the number of cells that are not empty in a specified range '''AND''' re-calculates according to filter settings
::* The formula in cell J17 counts all the visible entries in column F and updates when filters are applied

 
*=COUNTIF()
::* Counts the number of cells in a range that meet the specified criteria
::* Type the following into cell B7 to count the number of ''Directional'' questions in column :
::::''=COUNTIF(F:F,A7)''
 
::* Use the ''Fill'' function to extend the formula to other question types (cells A7:A12)
 

==Pivot Tables==

Pivot tables can be a quick and flexible way to organize, visualize, and perform calculations on large data sets. They do not affect the source data and are excellent when you are looking at 2 or more dimensions of the data.

===Creating a basic pivot table===

# Place cursor in top left of data set (cell A17)
# From the ''Insert'' tab select ''Pivot table''
# Click ''OK''. The default settings will create a pivot table in a new worksheet
# Select the data to display by dragging items from the list on the right into the quadrants below:

::* drag ''Question type'' into the ''Row Labels'' quadrant
::* drag ''Question type'' into the ''Values'' quadrant
 
===Calculations and displayed values===

The example above displays a count for each question type but it's also possible to display percentages, % change, etc. In this example you will add a column showing percentage

# Drag ''Question type'' into the ''Values'' quadrant AGAIN. There will be two columns showing totals
# In the lower right ''Values'' quadrant, click the arrow on the second entry and select ''Value Field Settings''
# Switch to the ''Show Values As'' tab
# From the drop-down list select ''% of Grand Total'', then click ''OK''

 
===Pivot charts for visualization===

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Column''; choose ''2D Clustered Column''(top left option)
 
The pivot table and chart are linked: changes to one affect the other which can be helpful for visual data exploration

# Drag ''Month'' into the ''Column Labels'' quadrant
# Experiment by dragging other fields into ''Row'' or ''Column'' quadrants, switching from ''Row'' to ''Column'', etc.
 
===Filters and slicers===

Filters add another dimension to tables and charts by limiting the displayed data

# Drag ''Contact method'' into the ''Report Filter'' quadrant
# Experiment with filtering options using the drop-down arrow in cell B1
 
A more intuitive visual filter called a ''Slicer'' is available in the '''Windows version only'''

# Place cursor anywhere in the pivot table
# From the ''Insert'' tab select ''Slicer''
# Check ''Contact method'' and click ''OK''

[[Category:UBC_Library_Internal]]

ASIST/Cool Tool Days/Cool Tool Day 8

2012-11-07T23:22:01Z

Kifty:

== Cool Tool Day #8: March 7, 2012 ==
*Jamie: [http://www.teachingbooks.net/pronunciations.cgi TeachingBooks.net's Author Name Pronunciation Guide] A handy website for those tricky author names. Audio pronunciations from the authors themselves! 
*Kristof: [http://www.w3schools.com/ W3Schools Online Web Tutorials] Tutorials for web development 
*Andrew: [http://scantailor.sourceforge.net/ ScanTailor] - I will create an e-book from page scans in 10 minutes or less 

[[Category:Cool Tool Days]]

ASIST/Cool Tool Days/Cool Tool Day 9

2012-11-07T23:19:46Z

Kifty:

== Cool Tool Day #9: October 9, 2012==
* Allison: [http://zotero.org Zotero]
* Allison: [http://teuxdeux.com/ Teuxdeux]
* Kristof: [http://freemind.sourceforge.net/ Freemind]
* Kristof: [http://dropbox.com Dropbox]

* <del>Angela Lam from Arts ISIT will talk about [http://connect.ubc.ca Connect] and iSchool Central</del> '''CANCELLED'''

[[Category:Cool Tool Days]]

ASIST/Cool Tool Days/Cool Tool Day 8

2012-11-07T23:11:27Z

Kifty:

== Cool Tool Day #8: ==
*Jamie: [http://www.teachingbooks.net/pronunciations.cgi TeachingBooks.net's Author Name Pronunciation Guide] A handy website for those tricky author names. Audio pronunciations from the authors themselves! 
*Kristof: [http://www.w3schools.com/ W3Schools Online Web Tutorials] Tutorials for web development 
*Andrew: [http://scantailor.sourceforge.net/ ScanTailor] - I will create an e-book from page scans in 10 minutes or less 

[[Category:Cool Tool Days]]

ASIST/Cool Tool Days/Cool Tool Day 7

2012-11-07T23:09:02Z

Kifty:

== Cool Tool Day #7: February 1, 2012 ==
* Jonathan K: [http://shiftedit.net/ ShiftEdit] - A free web-based IDE that syncs with FTP or dropbox. Great for web development in the lab!
* Andrew: [http://getgreenshot.org/ Greenshot] and [http://www.techsmith.com/snagit.html Snagit] - two screenshot tools. Greenshot is free, Snagit is not, but has more features. Also Gyazo, suggested by Justin.
* Josh: How Excel's concatenate function lets you format large data sets really quickly.
* Jamie: [http://www.learnatest.com/LEL/index.cfm/ Library Learning Express] Resource for practice tests & skill-building [access via VPL].
* Nicholle: Reader's Advisory Tools: Bibliocommons and NoveList
* Trevor: Pivot Tables in Excel (if we have time I will also show you slicers and Dashboards). Perhaps one of the greatest skills you will learn on a computer because everyone will think you're a freakin' genius for something really simple!

'''Things people wanted to see''' (requests/suggestions)
* Plain text notetaking tools (Andrew)
* did anyone pick up citavi and use it since the last cool tool day? (Adam)

[[Category:Cool Tool Days]]

ASIST/Cool Tool Days/Cool Tool Day 10

2012-11-07T23:04:28Z

Kifty:

Our next COOL TOOL DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Wednesday, November 14th.
Planning on presenting? Add your name, your topic or tool, and any needed resources (e.g. a web link) to '''[[ASIST/Cool Tool Days/Cool Tool Day 10|the Cool Tool Day 10 page]]''' (use your CWL login). Aim for a <5 minute talk per tool -- unless you want one of the 10 minute slots, of course.
You don't have to be an ASIS&T member to present or to put in a request. If you have any trouble editing '''[[ASIST/Cool Tool Days/Cool Tool Day 10|the page]]''', you can also email any ASIS&T member as SLAIS. And if you don't want to commit to anything in advance, you can always just show up and, if there's time left, you'll be more than welcome to get up and talk about a tool.
Not interested in presenting? Interested in coffee and Timbits? Then come soak in some useful tech while enjoying a nice, steaming hot cup of coffee and a few donuts.

'''Sign Up Here''' (note: there are 5 spots that are 5 minutes and the last 2 are for 10 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes)
Note: if there's more demand for 5 minute spots, we can split up these 10 minute spots.
*(10 minutes) 
*(10 minutes) 
Things you would like to see (requests/suggestions)
 
 

[[Category:ASIST]]

ASIST/Cool Tool Days/Cool Tool Day 10

2012-11-07T23:02:23Z

Kifty:

Our next COOL TOOL DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Wednesday, November 14th.

Planning on presenting? Add your name, your topic or tool, and any needed resources (e.g. a web link) to '''[[ASIST/Cool Tool Days/Cool Tool Day 10|the Cool Tool Day 10 page]]''' (use your CWL login). Aim for a <5 minute talk per tool -- unless you want one of the 10 minute slots, of course.
You don't have to be an ASIS&T member to present or to put in a request. If you have any trouble editing '''[[ASIST/Cool Tool Days/Cool Tool Day 10|the page]]''', you can also email any ASIS&T member as SLAIS. And if you don't want to commit to anything in advance, you can always just show up and, if there's time left, you'll be more than welcome to get up and talk about a tool.

'''Sign Up Here''' (note: there are 5 spots that are 5 minutes and the last 2 are for 10 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes)
Note: if there's more demand for 5 minute spots, we can split up these 10 minute spots.
*(10 minutes) 
*(10 minutes) 
Things you would like to see (requests/suggestions)
 
 

[[Category:ASIST]]

ASIST/Cool Tool Days/Cool Tool Day 10

2012-11-07T23:01:44Z

Kifty:

Our next COOL TOOL DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Wednesday, November 14th.

Planning on presenting? Add your name, your topic or tool, and any needed resources (e.g. a web link) to '''[[ASIST/Cool Tool Days/Cool Tool Day 10|the Cool Tool Day 10 page]]''' (use your CWL login). Aim for a <5 minute talk per tool -- unless you want one of the 10 minute slots, of course.
You don't have to be an ASIS&T member to present or to put in a request. If you have any trouble editing '''[[ASIST/Cool Tool Days/Cool Tool Day 10|the page]]''', you can also email any ASIS&T member as SLAIS. And if you don't want to commit to anything in advance, you can always just show up and, if there's time left, you'll be more than welcome to get up and talk about a tool.

Sign Up Here (note: there are 5 spots that are 5 minutes and the last 2 are for 10 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes)
Note: if there's more demand for 5 minute spots, we can split up these 10 minute spots.
*(10 minutes) 
*(10 minutes) 
Things you would like to see (requests/suggestions)
 
 

[[Category:ASIST]]

ASIST/Cool Tool Days/Cool Tool Day 10

2012-11-07T23:00:44Z

Kifty:

Our next COOL TOOL DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Wednesday, November 14th.

Planning on presenting? Add your name, your topic or tool, and any needed resources (e.g. a web link) to [[ASIST/Cool Tool Days/Cool Tool Day 10|the Cool Tool Day 10 page]](use your CWL login). Aim for a <5 minute talk per tool -- unless you want one of the 10 minute slots, of course.
You don't have to be an ASIS&T member to present or to put in a request. If you have any trouble editing [[ASIST/Cool Tool Days/Cool Tool Day 10|the page]], you can also email any ASIS&T member as SLAIS. And if you don't want to commit to anything in advance, you can always just show up and, if there's time left, you'll be more than welcome to get up and talk about a tool.

Sign Up Here (note: there are 5 spots that are 5 minutes and the last 2 are for 10 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes)
Note: if there's more demand for 5 minute spots, we can split up these 10 minute spots.
*(10 minutes) 
*(10 minutes) 
Things you would like to see (requests/suggestions)
 
 

[[Category:ASIST]]

ASIST/Cool Tool Days/Cool Tool Day 10

2012-11-07T22:56:59Z

Kifty: Created page with "Our next COOL TOOL DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Wednesday, November 14th. Planning on presenting? Add your name, your topic or tool, a..."

Our next COOL TOOL DAY will be in the Terrace Lab at SLAIS from 12:00-1:00 on Wednesday, November 14th.

Planning on presenting? Add your name, your topic or tool, and any needed resources (e.g. a web link) to the [http://wiki.ubc.ca/ASIST/Cool_Tool_Days/Cool_Tool_Day_10 '''the Cool Tool Day 8 page'''](use your CWL login). Aim for a <5 minute talk per tool -- unless you want one of the 10 minute slots, of course.
You don't have to be an ASIS&T member to present or to put in a request. If you have any trouble editing [http://wiki.ubc.ca/ASIST/Cool_Tool_Days/Cool_Tool_Day_10 '''the page'''], you can also email any ASIS&T member as SLAIS. And if you don't want to commit to anything in advance, you can always just show up and, if there's time left, you'll be more than welcome to get up and talk about a tool.

Sign Up Here (note: there are 5 spots that are 5 minutes and the last 2 are for 10 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes) 
*(5 minutes)
Note: if there's more demand for 5 minute spots, we can split up these 10 minute spots.
*(10 minutes) 
*(10 minutes) 
Things you would like to see (requests/suggestions)
 
 

[[Category:ASIST]]

ASIST/Cool Tool Days

2012-11-07T22:51:39Z

Kifty:

= Upcoming Cool Tool Days =
{{:ASIST/Cool Tool Days/Cool Tool Day 10}}

= Previous Cool Tool Days =
<dpl>
format = ,\n,,
category = Cool_Tool_Days
order = descending
include=*
</dpl>

User:Kifty

2012-06-11T22:37:21Z

Kifty:

Hello, I'm was the LSIT co-op student from May 2011 to April 2012. I still ike to keep an eye on the wiki from time to time.

The current LSIT co-op student is [[User:JSchatz|Jonathan Schatz]]. Contact him if you have any questions.

==Wiki projects==

* <s>update [[Library:Branches]]</s>
* <s>update [[:Category:HSS]] to [[:Category:HSS Resources]] (can we automate this?)</s>
* <s>make [[:Category:HSS Resources]] a sub-category of [[:Category:HSSD]]</s>
* <s>re-categorize [[Library:GettingPublished]] pages to [[:Category:HSSD]]</s>
* <s style="color:red">move content from [[http://toby.library.ubc.ca/webpage/webpage.cfm?id=804 Lam's Jump Start pages]] into wiki. '''CANCELLED'''</s>

Library:Open Data Resources

2012-06-11T20:39:25Z

Kifty: Created page with "'''''NOTE:''' Although the content of this page is primarily directed towards UBC Library staff, because of the open nature of the contents, it was decided to host it here rat..."

'''''NOTE:''' Although the content of this page is primarily directed towards UBC Library staff, because of the open nature of the contents, it was decided to host it here rather than on the staff intranet.''

== Background Information ==
=== What is open data? ===
=== Data Journalism ===

== Open Data Sources ==
=== Municipal/Local ===
=== Provincial/Regional ===
=== National ===
=== Global ===

== Open Data Tools ==
=== For finding and obtaining data ===
=== For cleaning data ===
=== For visualizing and presenting data ===

[[Category:UBC_Library_Internal]]

Library:When to Use the Wiki

2012-05-04T06:44:57Z

Kifty: Undo revision 167680 by JSchatz (talk) Nope! "Toby" is the name of the server that the older subject guides live on.

==When to Use the Wiki==
These guidelines are still in flux as the Library website continues to be developed, but these general guidelines should help you decide when to use the wiki, wordpress, or the Library Toolkit (LTK).

===For the Wiki===
The wiki is likely best for pages where you answer yes to one or more of the following questions:
* Is this a general topic (not specific to a subject or branch)?
* Would you or others like to create a PDF of the information?
* Would multiple people have something useful to contribute?
* Are you collaborating with others?
* Does this page need to be updated frequently?
* Do multiple people/branches want to use more or less the same content?

Examples: How to... pages, such as "How to Find Newspapers" or "How to Search Databases". Note that templates can be made so that all the instructions are the same, but examples can be modified to fit specific subject areas.

===For Staff Intranet===
Documents and information related internal committees, working groups, and other internal units, should be in the staff intranet, except in the case that people outside of the library are involved, such as faculty and community members.

===For LTK===

Similar to the toby Subject Guide, the new LTK is designed basically for Subject (e.g. Education), Topic (e.g. Building Codes/Standards), and Course Guides, which is specialized content. Generally, if you are providing a list of useful resources, then you should be using the LTK. The LTK is also being used for Faculty Publications lists. The [http://guides.library.ubc.ca/ Research Guides Portal] is the current access point for all published guides in LTK (and toby until they've all been migrated).

The big advantage to listing resources in the LTK is the integration with infopages. On the other hand, if you want the list of resources to be available through two or more of wiki, wordpress, and LTK, then you might consider putting it into the wiki as it can then be pulled into all three. If you're unsure, please feel free to contact web services for a quick
consult.

===For WordPress===
Remember that wiki pages can be displayed as a WordPress (WP) page. If you are planning to use a wiki page in a WordPress site, remember that WordPress will do the styling for you, so you don't have to do it yourself.

You should use WordPress for any:
* Blogs
* News & Announcement pages
* Static (non-changing) content pages needing very restricted access (only editors of the WP site can edit the page)

A reminder that Library space wiki pages are viewable by the public, but editing is restricted to library staff only. By "very restricted access", this refers to material that is sensitive and should not be edited by anyone aside from 1-2 people in a particular department.

[[Category:Guidelines]]
[[Category:UBC Library Internal]] [[Category:Library]]

Library:Wiki Documentation

2012-04-26T22:27:50Z

Kifty:

__TOC__

==DPL==
A quick aside, most ideas/functions presented are typical of any wiki, but DPL is an extension that's been installed. Dynamic page lists are very useful and allow automated listing of wiki pages based on category, page title, space, etc. Here's the basic: [[Help:Dynamic_Page_Lists]]. A more complete documentation can be found on the [http://www.mediawiki.org/wiki/Extension:DynamicPageList_%28Wikimedia%29 DPL extension page].

==Library Space Permissions==
Only library staff can create/edit pages in the library space. However, there is not way to automatically add library staff, so it must be done manually (adding and removing). All web services staff should have administrator status for the library space. Simply go to the [[Special:UserRights|special user rights page]], search for the user (remember, it's capital sensitive like everything else in the wiki) and add them to the library space.

==Library:Home==
Perhaps the best way to start is from the [[Library:Home]] page.

The home page acts as a front or portal page to other pages as well as where we have displayed our wiki guidelines and guidelines on the use of the wiki. These guidelines fluctuate as the use of the various tools grow and discussions happen surrounding related issues.

===Future Guidelines Work===
Beyond these existing guidelines, there's a lot of interest in seeing standards or conventions established. In particularly, naming conventions (especially for categories, but possibly for pages too). Some relate to layout/content, which is discussed below.

===Library Home Pages===
As you can see, there are a few pages that have been created under which any library wiki page should be able to fit. The idea is that wiki pages in the library space can be easily found if it is properly categorized simply by browsing. Here are a couple of quick notes on the purpose of each page and how it's created.

*[[:Category:Library|All Library Pages]] - goes to the Library category page, which is the top level of the hierarchy (see below for further explanation)
*[[Library:Branches|Branches]] - page where a dpl has been created for each library branch that currently have their own category (i.e. many branches do not)
*[[Library:Committee_Pages|Committees and Groups]] - this is a manual list linking to the committee or group's "home" page
*[[Library:Help_For_You|Help & Services Portal]] - made with dpl lists. Help is divided into the various categories as organized on the actual [http://help.library.ubc.ca Help Portal], but Services is just one category as there are only a few pages that are fed from the wiki
*[[Library:Instructional_Materials|Instructional Materials]] - dpl list of various categories related to tutorials/instructional content in the library space
*[[Library:Learn_to_Use_the_Wiki|Learn to Use the Wiki]] - links to the library version of the using [[Help:Tutorial|wiki tutorial]]. As there is also a [[Library:WordPress_and_Wiki_Tutorial]] now, some consideration might go into having a page that lists wiki/wordpress/ltk/other(?) tutorials that are created by LSIT folks as well as a list of tutorials created by other UBC areas, such as [[Documentation:WordPress_Basics]]
*[[Library:LTK_Manual|LTK Manual]] - as the name suggests, link to the LTK user manual

==Library Space Organization==
===Subpages===
As with the general UBC wiki, the practice in making related pages is to use subpages. e.g. [[Library:Microforms]] is a big topical/resource page with related material or parts of this page being created as subpages e.g. [[Library:Microforms/AmericanFiction]]

===Deleting Pages===
Since pages cannot be deleted, the wiki administrator takes care of that. Mark pages for deletion using the template: <nowiki>{{Delete}}</nowiki>

===Categories===
Beyond the home page acting as a portal, categories that are typically being used in the library space has been organized into a kind of hierarchy. Obviously, since the wiki is not a strict child-has-only-one-parent structure, it can become much more complex.

In most cases (so far), users do not categorize their own pages. Thus, it is up to someone in LSIT to do so. As the library space grows, categories will likely need reorganization/rearrangement (e.g. [[:Category:Library Units]] was only recently created). How that's done is up to the community in essence, but LSIT can provide a basis or direction perhaps for this simply by example. So far, it's really been a "create as needed to group pages or categories" approach. Higher up categories all lead back to the main [[:Category:Library]] allowing users to browse library related categories and pages in a more organized manner.

Currently, uncategorized library space wiki pages are listed using a DPL in the description of [[:Category:Library]] page.

===Future Organization?===
* Categories are generally assigned based on the most specific category (or categories) that are applicable, but users do not always do it this way (e.g. categorizing a page in both "Library Tutorials" and "Finding Library Resources"). So far, this has been left alone, but for better organization, more work may need to be done in explaining to our users best practices.
* So far, categories have only been added to uncategorized pages (i.e. no library related category). However, you would always want ''all'' the related categories to be applied to a wiki page. For example, a user may create a tutorial, such as Searching Web of Science, and categorize it only under their branch, say HSSD. Since this page has a library related category, it no longer shows up on uncategorized. However, this page should also have the category 'Searching Databases' on it for others to find it. More advanced DPL lists could be used to help with this, but this has not been set up as of yet.
* Some library users have also started using more general categories that so far have been considered outside the library's specific use. For example, Nursing, Literature, History, HSS (Humanities and Social Sciences), etc. No work has been done yet in organizing these categories, but for the greater UBC Wiki use, you may want to coordinate with the Wiki Administrator (in CTLT) to help organize these categories.

==Use of Tranclusion==
One of the most appealing parts of the wiki (other than being able to embed it on WordPress and LTK) is the use of template or [http://en.wikipedia.org/wiki/Transclusion transclusion] (or as some refer to it, importing of content, but this term doesn't reflect that it also imports layout/structure).

So far, it has mostly been used for the reuse/redistribution of guidelines and parts of wiki/wordpress tutorials.

In wider library usage, it has mostly been used to create searching tutorials (mostly databases) and then modifying the examples to gear it towards a specific course/topic. For example, here's the test case: [[Sandbox:Library/How_to_Search_Web_of_Science]] as the main template page and then example use case: [[Sandbox:Library/How_to_Search_Web_of_Science_Psychology_Examples]]

===Transclusion of Categories===
When a page is transcluded, normally everything is transcluded including categories. However, there are a couple of categories, particularly 'Library Website', 'Help Site' and 'Services Portal', where this is not desirable (because these categories should only refer to wiki pages that show up on the library website). To prevent something from being transcluded (here it's being used for categories but can eseentially be used for anything), use the <nowiki><noinclude></noinclude></nowiki> tag, literally telling wiki, 'do not include this portion' when transcluding. More detailed information can be found in the [[Help:Templates#Control_template_inclusion|Help Templates article]].

===Future Work===
1. The current [[Help:Templates]] article may be difficult for new wiki users to understand. Consider revising it to make it more understandable for library staff and other new users of UBC wiki.

2. As with preventing library website categories from being transcluded, work could be done in teaching library users that they may want to add the noinclude tag when the branch category is used as well, so that faculty pages for example are not added to their library branch category. Whether is a good idea needs further discussion.

3. Note: what is discussed below is still the same concept of template or transclusion, but here the focus is more on when someone wants to create a "new page" rather than simply changing small bits and pieces of text of an existing page.

One of the things the library can explore is the use of the more traditional sense of a template. That is a pre-set structure (in this case, wiki markup) already in place when someone creates a page. This will give a more uniform look to pages, especially those that might be used on the main library webpage. Good examples where this might be useful are course/user library guides, tutorials on searching resources (e.g. databases) or finding materials. The template may be layout and/or content based.

====Tutorials====
Whereas the current use allows users to make changes to an existing tutorial to fit topically, this is a suggestion for a broader layout template be used for all database tutorials for example, so that they all look similar. Try the Course [[UBC_Wiki:Create_a_New_Page|create a page]] (then preview) as an example. Taking searching databases as an example, there might be a set layout for the database name, interface/vender name (e.g. EBSCO), short description, list of subjects most useful for, link to database, access instructions, librarian contact info, etc. some of which could be in the side box at the top (much like the course template), then have some pre-set markup as a guide, but which is customizable. For example, <pre><nowiki>
==Basic Search==
# Step 1 here [Image:screenshot example.jpg|alt=description here]
# Step 2
#* Note for step 2

==Advanced Search==

==Print/Save/Export/E-mail Citations==

==Staying Current: Saved Searches, E-mail Alerts, & RSS Feeds==

==Other Useful Resources==
* [http://example.com name of website]
* [[Library:example page | name of another wiki page]]</nowiki></pre>

Much like the one for Course pages, obviously, instructions can also be added to the top of the page.

====User Guides====
These two guides for example: [[Library:UBC_Library_Resources]] and [[Library:Library_Resources_for_the_Faculty_of_Arts]] have similar content and layout (as of April 2011). Beyond the fact that these pages have almost identical content and should use transclusion, the layout is similar enough that you might want this layout to be a pre-set template for all user guides.

====Create a page box/form====
If desirable, the wiki administrator will be able to help to set up a "create a page" for the library (much like the Main/Course/Documentation/Sandbox space ones), which can then be added to the library home page (or take a look at the Create a page code).

==Workshops==
So far, workshops have been on request basis, with usually at least a basic workshop for those doing branch migration that see the need for wiki use. However, especially since summer is more quiet around campus, you might consider doing a couple of workshops where you just invite people in, create drop-in sessions (outside of the LSIT area where people can easily reach you), or coordinate with CTLT to sit in their drop-in session announcing to library staff that you will also be available at the same time. Or come up with some other event!

Workshops that people seem to be interested in:
* basic workshop orienting staff to the Library space (and other spaces), creating/editing pages
* Finding/using/adding/creating categories/subcategories, and organization of the Library categories
** Note: It's especially important for users to know that categories can be used by anyone in UBC Wiki (unlike pages in the Library space). For example, 'Music' is not a good idea, but 'Music Library' works.
* Transclusion/Templating

==Communications==
Although ideally to communicate about wiki page suggestion/issues are done through the discussion page or the user's talk page, many users do not make use of either (possibly because they are unaware of its function). The best way to discuss something is usually via e-mail, phone, or in person, and then also refer to and/or teach users to use the talk pages.

==Appendix==
Below is what I used to have on my own talk page. It's basically a list of pages that I worked on/created. It's especially useful since many of the in progress/draft ones do not have a category yet, and they are part of the Help Portal migration. Others, such as templates are particularly useful in helping with wiki maintenance.

* [[Library:Home]]

Templates
* [[Template:Update]]
* [[Template:Draft]]
* [[Template:Delete]]
* [[Template:TOC Limit]]

* [[Template:Hanging Indent]]
* [[Template:Citation Example]]
* [[Template:APA Citation]]

Categories
* [[:Category:Library]]
* [[:Category:Library_Tutorials]] with subcategories
** [[:Category:Finding Library Resources]]
** [[:Category:Researching at the Library]]
*** [[:Category:Searching_Databases]] (currently a subcategory of Researching)
* [[:Category:APA Style]]
* [[:Category:Need Updating]] (hidden category)
* [[:Category:EDST]]

'''Services Site pages:'''
* [[:Category:Services Portal]]

'''Help site pages:'''

* [[:Category:Help_Site]]
** [[:Category:Library_User_Guides]]
* [[Library:Help_For_You]]

Borrowing
* [[Library:Borrowing/From_non-UBC_Libraries]]

Finding
* [[Library:How_to_Find_Articles]] - JM

Researching
* [[Library:Course_Specific_Tutorials]] - TR
* [[Library:Searching_Databases]] - Dec 2010, not live on site
* [[Library:Evaluating_Print_Sources]] - approved by AG
* [[Library:Evaluating_Internet_Sources]] - approved by AG

For Learning Commons
* [[Learning_Commons:Chapman_Learning_Commons/APA_Style_Guide]] and [[:Category:APA Style]] from [http://www.library.ubc.ca/pubs/apastyle.pdf Getting Started with APA Style Guide] - documentation needed in creating custom style guide

'''Help Site In Progress:'''

Borrowing
* [[Sandbox:Library/Requesting_from_ASRS]] from [http://www.library.ubc.ca/home/asrs/how-to/ Instructions on Ordering from ASRS]

Finding
* [[Sandbox:Library_Finding_Videos]] from [http://www.library.ubc.ca/home/about/services/gtvid.html Guide to Videos, Films and DVDs]
* [[Sandbox:Library_Finding_Sound_Recordings]] from [http://www.library.ubc.ca/pubs/htfrec.pdf Guide to Sound Recordings] and [http://www.library.ubc.ca/pubs/gtwilson.pdf Guide to Wilson Recordings].
* [[Sandbox:Library/Finding_Maps]] from [http://www.library.ubc.ca/map/mapguide.html Guide to the Map & Atlas Collection], and [http://www.library.ubc.ca/map/mapfaqs.html Map & Atlas Collection FAQ's]
* [[Sandbox:Library/Finding_Microforms]] from [http://www.library.ubc.ca/microfrm/collections.html Microform Collections]
* [[Sandbox:Library/Finding_Newspapers]] from [http://toby.library.ubc.ca/webpage/webpage.cfm?id=342 Newspapers and News Sources]
* [[Sandbox:Library/Finding_Primary_Sources]] from [http://www.library.ubc.ca/hss/primarysources.html Primary Sources] -> being moved to LTK?
* [[Sandbox:Library/Finding_Theses_and_Dissertations]] from [http://toby.library.ubc.ca/webpage/webpage.cfm?id=37 FAQ: Dissertations and Theses]
* [[Sandbox:Library/Finding_Book_Film_%26_Theatre_Reviews]] from [http://toby.library.ubc.ca/webpage/webpage.cfm?id=529 Book, Film, and Theatre Reviews] with A-Z list excluded (which should probably be developed in LTK)

Researching
* [[Sandbox:Library/Getting_Started_with_your_Research_Paper]] from [http://www.library.ubc.ca/home/about/instruct/tp-res.html Term Paper Research: Getting Started]
* [[Sandbox:Library/Finding_the_Right_Sources_for_Literature_Review]] from [http://toby.library.ubc.ca/webpage/webpage.cfm?id=502 Finding the Right Information Sources For a Literature Review] - page best done with some parts on seperate pages or merged with existing pages and transcluding those sections
* [[Sandbox:Library/How_to_Search_Web_of_Science]] from [http://www.library.ubc.ca/life/instruction/pubs/webofscience.pdf How to Search Web of Science] - parameters added, Example [[Sandbox:Library/How_to_Search_Web_of_Science_Psychology_Examples]]
* [[Sandbox:Library/How_to_Search_PubMed]] is not [http://www.library.ubc.ca/life/instruction/pubs/pubmed.pdf How to Search PubMed]
* Searching the Web -> http://www.library.ubc.ca/home/websearch/quick.html

'''Ever changing test page:'''
* [[Sandbox:Library_Test_Page]] Currently dpl of pages that might need maintenance

'''Documentation:'''
* Parts of [[Help:Contents]]
* [[Library:When_to_Use_the_Wiki]]
* [[Help:Guidelines]]
* [[Library:Learn_to_Use_the_Wiki]] / [[Library:Wiki_Tutorial]]
* [[Help:Tutorial]]
* [[Help:Wiki_to_WordPress]]

===Old Work: APA Citation Guide===
One of the projects that was started last summer was to move the APA and MLA citation guides to the wiki, starting with APA. The idea was to break up the APA guide into really small pieces so staff/faculty could potentially create custom guides with the types of examples that they wanted (e.g. journal articles with or without DOI). It was for this project that various templates, categories, pages were created. However, as those working on the project became busy, it was put aside.

Library:Finding a Book

2012-04-26T21:32:39Z

Kifty:

== Finding Material on the Library Shelf ==

When you find a print book via the UBC Library website, this is the information you will need to locate the book on the shelf:

[[File:Call Number Record Info.png]]

== Follow these Steps ==

==== 1. Go to the Library ====
In our example, the location is Koerner Library.

==== 2. Go to the area ''within'' the library. ====
In our example, '''Koerner Library stacks''', the location within the library is "stacks". Common areas within libraries include:

* Stacks (books you can take out)
* Reference (books you can't take out)
* Course reserve (books and articles you can take out for 1 hour - 3 days)

Each library displays signs and maps that show the location of stacks/reference/course reserve areas. Or ask a staff member.

(IMAGE) Building Guide Woodward Library

===== Read Line by Line =====
Read call numbers line by line. Each piece of information directs you to a group of shelves, to a row of shelves, and then to the shelf that has your book.

[[File:Reading Call Numbers by Line.png]]

====3. Start with Letters====

Call numbers begin with letters that are read alphabetically. A call number can begin with one, two, or three letters.
Single letters come before double letters, for example:

[[File:Call Number Letters.png]]

====4. Look for the number====
The second part of a call number is a whole number. Whole numbers are arranged from smallest to largest, for example:

[[File:Call Number Whole Numbers.png]]

====5. Look for the Letter and (Decimal) Number ====
The third part of a call number is a letter followed by a number. This number '''is a decimal number'''. No decimal is printed on the book, for example:

[[File:Call Number Decimal.png]]

===Reading It Together===

The books below are in correct order.

[[File:Call Number Together.png]]

If you need further help with locating an item on the library shelf, ask for help at the service desk.

[[Category:Library_Instructional_Materials]]
[[Category:CAP]]
[[Category:HSSD]]

Library:Instructional Resources for Summon

2012-04-26T21:32:27Z

Kifty:

This page hosts Instructional Resources specific to Summon.

==Screencasts==

There are a number of screencasts available for Summon.

===Introductory===

This short video will show you the basics of using Summon to locate, retrieve and save references to books, e-books, journal articles and more.

{{#widget:YouTube|id=jDSv6bj63i4 | 400}}

You can also download a version of the video with text captions and no background music [http://cl.ly/2X2h1V0x1a2x151m0F0G here]. If the file launches in an embedded player Right-Click (Ctrl-Click on a Mac) and select Download Link As to save the file.

===Advanced Search Features===

This short video will show you how to refine your search results in Summon and use the advanced search menu.

{{#widget:YouTube|id=nfFHHV7dvag | 400}}

You can also download a version of the video with text captions and no background music [http://cl.ly/2X1C1h1h2X0q2n3c3M3s here]. If the file launches in an embedded player Right-Click (Ctrl-Click on a Mac) and select Download Link As to save the file.

===Summon on Mobile Devices===

This short video will show you how to search with Summon using your smartphone.

You can download the video [http://cl.ly/0b3G0G0B050D0u3i3Q30 here]. If the file launches in an embedded player Right-Click (Ctrl-Click on a Mac) and select Download Link As to save the file.

===Editable Screenflow Files===

These screencasts were made using a program called Screenflow (for Macs only). If you own a license to Screenflow, you can download the master files for further editing.

[http://cl.ly/0Z1E331g0L0w2m1I383D Summon Introduction]

[http://cl.ly/312p251Q2h1C1K2I0x3G Summon Advanced]

[http://cl.ly/16361T1d2N0v0L2u2w2a Summon Mobile]

[[Category:Library_Instructional_Materials]]

Library:Instructional Materials

2012-04-26T21:31:55Z

Kifty:

==Units==
*[[Library:Wimba_Classroom|Wimba Classroom]]

==Library Tutorials==
<dpl>
category = Library_Tutorials
columns = 3
shownamespace = false
</dpl>
===Finding Library Resources===
<dpl>
category = Finding Library Resources
columns = 3
shownamespace = false
</dpl>
===Researching at the Library===
<dpl>
category = Researching at the Library
columns = 3
shownamespace = false
</dpl>
====Searching Databases====
<dpl>
category = Searching_Databases
columns = 3
shownamespace = false
</dpl>

==Citing==
===APA Style===
<dpl>
category = APA Style
columns = 3
shownamespace = false
</dpl>

==Background Information==
===Migration from Vista to Blackboard Learn LMS===
<dpl>
category = bblearnlib
columns = 3
shownamespace = false
</dpl>

[[Category:Library_Instructional_Materials]]

Library:Creating persistent URLs to full-text journals in Web CT Vista/What is a PURL

2012-04-26T21:31:43Z

Kifty:

==What is a PURL?==

PURLS, or Persistent URLS, are links to specific web pages that remain stable over time. Many people don't know that some urls are "session-based" and only work for the duration of your search session. If you try to access a session-based url after you log-off, navigate away from the page and/or several hours later you will get an error message instead of the page you were expecting.
[[File:Pearls.jpg|thumb|left| Dance of the Water Pearls by ''Mara'' from [http://www.flickr.com/photos/mara_earthlight/3998626499/ Flickr]]]

===Why should I use a PURL?===

Many people would prefer to upload the full-text of an article directly into their online course. That's understandable - to do so is a quick and technically simple process. Unfortunately, doing so may be illegal. To quote from the [http://collections.library.ubc.ca/copyright/ UBC Library Copyright information page]:

<blockquote>“Owners of copyright are the only ones allowed to copy their works or give permission to others to copy their works.”</blockquote>

This means that you are not permitted to digitize and upload full-text articles to your webct vista courses unless you have the rights to the copyright. This is true even if the article comes from a journal that is licensed for use by UBC students, faculty and staff - ''unless the rights holder allows this activity''. Before digitizing and/or uploading an article into your online course check the Library's [http://licenses.library.ubc.ca/ '''License Information'''] page to learn how to check the permitted uses for content from our licensed resources (i.e., indexes, databases, e-journals).

*If a resource indicates that you are not permitted to put its content "in e-reserves" then you will need to provide your students with a persistent link to the article instead.
**Note, many journals are purchased as part of a large package and thus, are not searchable by individual title. If the journal you are interested in is not listed in the License Information Database you can contact your [http://toby.library.ubc.ca/libstaff/subjectlibrarians.cfm subject liaison librarian] or [http://www.library.ubc.ca/home/forms/ejournalhelp.html E-Resources Help] for further assistance.
**For more information about authors' rights and how to retain them see the [http://scholcomm.ubc.ca/stakeholders/for-authors/ Author's Page] at [http://scholcomm.ubc.ca/ Scholarly Communications at UBC].

[[Category:Library_Instructional_Materials]]
<noinclude>[[Category:Help Site]]
[[Category:Library User Guides]]</noinclude>

Library:Creating persistent URLs to full-text journals in Web CT Vista/Off Campus

2012-04-26T21:31:32Z

Kifty:

==Off Campus and EZ Proxy==
[[File:Pearls.jpg|thumb|right| Dance of the Water Pearls by ''Mara'' from [http://www.flickr.com/photos/mara_earthlight/3998626499/ Flickr]]]

PURLS on their own do not allow the system to authenticate users. This means that your PURLS won't work when accessed from off-campus. To avoid having this happen you will have to add the following prefix to your PURL: '''http://ezproxy.library.ubc.ca/login?url='''. This prefix will prompt students to log-in using their CWL before accessing the article, allowing the system to confirm that the user is a current UBC student, faculty or staff-member.

We have a convenient tool that you can use to '''add the ezproxy prefix automatically''' to your PURLs. You will find the EZProxy Prepender tool here: [http://services.library.ubc.ca/personal-computers/ezproxy-purl-tool/ '''http://services.library.ubc.ca/personal-computers/ezproxy-purl-tool/''']

[[Category:Library_Instructional_Materials]]
<noinclude>[[Category:Help Site]]
[[Category:Library User Guides]]</noinclude>

Library:Creating persistent URLs to full-text journals in Web CT Vista/More Information

2012-04-26T21:31:19Z

Kifty:

==More Information==
[[File:Pearls.jpg|thumb|right| Dance of the Water Pearls by ''Mara'' from [http://www.flickr.com/photos/mara_earthlight/3998626499/ Flickr]]]

*For step-by-step instruction on creating persistent links in a number of '''popular article indexes & databases''' see [http://web.ubc.ca/okanagan/library/help/creatinglinks.html http://web.ubc.ca/okanagan/library/help/creatinglinks.html]

*For '''additional help''' with linking to UBC Library resources you can contact us via the [http://www.library.ubc.ca/home/forms/ejournalhelp.html E-Resources Contact Form] or you can contact your [http://toby.library.ubc.ca/libstaff/subjectlibrarians.cfm subject librarian].

*For the University's most current '''statement and guidelines on copyright''', visit the official UBC Copyright website: http://copyright.ubc.ca/

*To learn how to check the permitted uses of materials from a particular electronic resource see our '''License Information''' page here: http://licenses.library.ubc.ca/

[[Category:Library_Instructional_Materials]]
<noinclude>[[Category:Help Site]]
[[Category:Library User Guides]]</noinclude>

Library:Creating persistent URLs to Online Resources /Finding PURLS on the Web

2012-04-26T21:31:00Z

Kifty:

==Finding PURLS==
[[File:Pearls.jpg|thumb|right| Dance of the Water Pearls by ''Mara'' from [http://www.flickr.com/photos/mara_earthlight/3998626499/ Flickr]]]

It can be tricky to determine whether or not the URL you see in your browser window is permanent. Two clues to look out for:

*'''Look at the url''' that appears in your browser's address bar and see if the word “session” appears in it. This means that the url is only valid for your (temporary) session and will not work for another user. For example:
**[[File:Session-url.JPG]]
**This url is session-based and will not work after your session ceases.

*'''Look to see''' if there’s a link somewhere in the article citation/record that says “Permanent URL,” “PURL,” “Permalink,” “Stable URL” or a similar phrase. This will be the url that you will want to use in your course.
**Sometimes no such link is offered. In these cases, check to see if there is an option to email a link to the article to yourself. For example, OVID articles (html formats) have a link called "email jumpstart" which will generate a permanent url for you to copy.
*If you are unsure whether you have a permanent url or not, simply paste it into an email to yourself and try to open it from home, another workstation or even just a couple of hours later. If it won’t open properly you’ve likely got a session-based url.
**Another type of permanent link is a DOI – or Digital Object Indicator. DOIs look like this: 10.1016/j.ympev.2006.05.005. Using DOIs with ez-proxy can be tricky so only use them if no other permanent url option is offered.

Here's what the DOI looks like in an article's detailed record:

[[File:Doi-image.JPG]]

***If the article you want to link to provides a DOI rather than a persistent url that's ok - you will have to prefix the DOI with the following: '''http://ezproxy.library.ubc.ca/login?url=http://dx.doi.org/'''
***So the full and complete link you'd have to use for the DOI '''10.1016/j.ympev.2006.05.005''' would be '''http://ezproxy.library.ubc.ca/login?url=http://dx.doi.org/10.1016/j.ympev.2006.05.005'''.

===Another Example===

To link to the following article - found using the database Academic Search Complete – see the instructions below.

Beatty, A. (2010). "How Did It Feel for You? Emotion, Narrative, and the Limits of Ethnography." ''American Anthropologist'', 112(3), 430-443.

#Select the correct article from your results list and click on the title to open its detailed record.
#Note the Permalink in the right menu
#Click the Permalink and copy the url that appears in the pop-up window.

If you followed these steps then the ez-proxied PURL that you would link to in your course would be: '''http://ezproxy.library.ubc.ca/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=a9h&AN=53042415&login.asp&site=ehost-live'''

[[File:Permalink.JPG]]

===PURLS for ebooks===

Providing PURLS for ebooks is technically possible, but each e-book platform has a unique way of providing PURLs for its materials and some platforms do not work well with EZ Proxy. For this reason we recommend that you provide your students with a link to the UBC Library catalogue record for the e-book in question. From there, students can click the orange "online access" button to access the ebook's content. See below for instructions on linking to Library Catalogue records.

[[File:Onlineaccess-ebook2.JPG|600px]]

===Linking to the Catalogue===

UBC Library Catalogue urls are session based. You will find a permanent url that you can paste into your course at the bottom of the record. '''Note''', you '''do not''' have to add the E-Z Proxy prefix to a UBC Library catalogue PURL.

'''For example''':

[[File:Cataloguesnap3.JPG]]

[[Category:Library_Instructional_Materials]]
<noinclude>[[Category:Help Site]]
[[Category:Library User Guides]]</noinclude>

Library:Finding persistent URLs to Online Resources

2012-04-26T21:30:40Z

Kifty:

{{Library:Creating_persistent_URLs_to_full-text_journals_in_Web_CT_Vista/What_is_a_PURL}}

{{Library:Creating_persistent_URLs_to_full-text_journals_in_Web_CT_Vista/Off_Campus}}

{{Library:Creating_persistent_URLs_to_full-text_journals_in_Web_CT_Vista/Finding_PURLS}}

{{Library:Creating_persistent_URLs_to_full-text_journals_in_Web_CT_Vista/More_Information}}

[[Category:Library_Instructional_Materials]]
<noinclude>[[Category:Help Site]]
[[Category:Library User Guides]]</noinclude>

Library:Creating Audio & Video Playlists

2012-04-26T21:30:20Z

Kifty:

== Naxos Music Library ==
[http://resources.library.ubc.ca/940 http://resources.library.ubc.ca/940]

The maximum number of tracks allowed for a playlist is 60.
The maximum number of playing time allowed for a playlist is 4 hours.

=== Types of Playlists ===

==== 1. Student/Member: [Your Name] Playlists ====

Requires registration to create a personal account – you specify your e-mail address and password for the login. To create a personal account, enter Naxos Music Library via [http://resources.library.ubc.ca/940 http://resources.library.ubc.ca/940], click on '''Playlists''', then click on '''Sign up'''.
* Can create, edit, and delete personal playlists
* Playlists are only accessible to you with your login, they are not public

==== 2. Faculty/Library Staff: University of British Columbia Playlists ====

This is an account for faculty and library administrators, and where course reserve playlists should be created. '''You will need to request a special URL and login from the Music Library.''' Please contact [mailto:terry.horner@ubc.ca Terry Horner], [mailto:kirsten.walsh@ubc.ca Kirsten Walsh], or the Music Library Reference Desk at 604-822-6835.
* This contains institutional playlists that can be accessed by UBC students, faculty, staff, and users in the library for listening; however, only users with the login can create, edit, and delete course playlists

==== 3. Naxos Music Library Playlists ====

These playlists are accessible to all Naxos Music Library users for listening, but only Naxos staff can create, edit, and delete playlists.

=== Creating Playlists ===

A PDF with instructions on how to create playlists is available in Naxos Music Library. Click on Playlists, then on the right-hand side of the page, click on the link [http://ubc.naxosmusiclibrary.com/playlists/NML%20Playlist%20Guide%20-%20Institution.pdf View/Download Playlist User Guide]

For a simplified set of instructions, see below:

==== To create personal playlists (can only be played by you) ====

Click on '''Playlists''' in the navigation bar. Your personal playlists will be under the tab labeled [Your Name] Playlists.

Click on '''New Playlists'''; this will open a pop-up box to for you to specify the Playlist Name, Author, and Remarks. You may name the playlist whatever you like. Click on '''Save Playlists'''.

To add tracks to your playlist, search for tracks in the '''Keyword Search''' box at the top of the page. Select the tracks you want to add to the playlist by ticking the checkbox beside the track names. On the left-hand side bar, click '''Add to Playlist''' and select the appropriate playlist. Click on '''Add to Playlist'''.

==== To create course playlists (can be played by all UBC users) ====

Click on '''Playlists''' in the navigation bar, then click on University of British Columbia Playlists. Click on '''New Playlists'''; this will open a pop-up box to for you to specify the Playlist Name, Author, and Remarks. It is recommended to name the playlist with the relevant course number and term, e.g. MUSC 300 2011W. Click on '''Save Playlists'''.

To add tracks to your playlist, search for tracks in the '''Keyword Search''' box at the top of the page. Select the tracks you want to add to the playlist by ticking the checkbox beside the track names. On the left-hand side bar, click '''Add to Playlist''' and select the appropriate tab, folder, and playlist (for Tab, make sure to select '''University of British Columbia Playlists'''). Click on '''Add to Playlist'''.

== Alexander Street Press Databases ==

* Classical Music Library [http://resources.library.ubc.ca/936 http://resources.library.ubc.ca/936]
* Opera in Video [http://resources.library.ubc.ca/1713 http://resources.library.ubc.ca/1713]
* Smithsonian Global Sound For Libraries [http://resources.library.ubc.ca/1064 http://resources.library.ubc.ca/1064]

Playlists are themed collections of materials and can be created by any user of the database. Users can create playlists containing whole works, segments, and/or other items such as links to any URL. Playlists can be annotated, edited, copied, shared, and all playlists contain their own unique static URL. Playlists can be used as lists of personal favorites, class viewing/listening assignments, or as a teaching resource for in-class use.

=== Types of Playlists ===

==== 1. All Playlists ====
Lists all playlists created by Alexander Street Press users worldwide.

==== 2. My Playlists ====
Lists the playlists you have created. Requires registration to create a personal account.

==== 3. Playlists Shared With Me ====
Lists playlists that other Alexander Street Press users have shared with you.

==== 4. My Institution’s Playlists ====
List playlists created by UBC users. This is where course playlists should be created.

=== Creating an Account ===
To create an account, click on '''Sign In''' (under the search box), then click on '''register''' (blue link above the sign in boxes). Fill out the registration form (the profile page is optional). You will receive an e-mail confirmation from Alexander Street Press. Your sign in will work in any of the library’s Alexander Street Press databases (for example, if you created the account in Classical Music Library, the same sign in will work in Opera in Video).

You may also create playlists without account registration; the playlist will only appear under My Institution’s Playlists with the username Guest.

=== Creating Playlists ===
To create a playlist, click on '''Playlists''' on the navigation bar, then click on '''Create a Playlist'''.

You will be prompted to create a playlist title, insert any annotations you would like, and indicate who should see this playlist. Your options are:

* '''Just me''': This keeps your playlist private. Only you will be able to see this playlist when you are signed in to the database.
* '''Everyone at my institution''': This shares your playlist with anyone using the database within your college's, university's, or public library's IP range. This is a good option if you'd like to share a playlist with a class or department.
* '''Everyone''': This option makes your playlist public. Every user of the database will see your playlist. Alexander Street Press encourages students and scholars to share annotated playlists with other users to add context to the collection.

Remember, if you choose to share your playlist, others can only view your playlist. Only you will be able to edit it.

To add tracks to your playlist, simply search for the track you would like to add, and click on the '''+''' sign next to the track name, and specify which playlist it should be added to.

[[Category:Library_Instructional_Materials]] [[Category:Music Library]]

Category:Systematic Reviews

2012-04-26T21:25:14Z

Kifty:

''Wiki pages to support researchers doing Systematic Reviews.''

[[Category:Library_Instructional Materials]]

Category:Searching Databases

2012-04-26T21:25:03Z

Kifty:

Created for the Library space.

This category is for all the "how to"-like guides that describe how to search a specific database, such as PsycInfo or PubMed.

[[Category:Library_Instructional Materials]]
[[Category:Library_Databases]]

Category:Search Methodology

2012-04-26T21:24:51Z

Kifty:

[[Category:Library_Instructional_Materials]]

Category:Researching at the Library

2012-04-26T21:24:42Z

Kifty:

All Library wiki pages related to researching, such as how to search..., evaluating sources, how to cite. Those with a lot of pages, such as "How to Search (a Database)" should go under the subcategory. This category should not be confused with tutorials on how to search for library materials based on the format (e.g. microforms) which should be in the [[:Category:Finding Library Resources]]

[[Category:Library_Instructional_Materials]]

Category:Library Tutorials

2012-04-26T21:24:32Z

Kifty:

[[Category:Library_Instructional_Materials]]

Category:Library Instructional Materials

2012-04-26T21:23:41Z

Kifty: Created page with "This category is for instructional materials produced and maintained by the UBC Library, including "how-to"s and tutorials. Please use subcategories when applicable. [[Catego..."

This category is for instructional materials produced and maintained by the UBC Library, including "how-to"s and tutorials. Please use subcategories when applicable.

[[Category:Library]]

Category:Finding Library Resources

2012-04-26T21:23:07Z

Kifty:

A subcategory of Instructional Materials focused on finding materials based on type/format.

[[Category:Library_Instructional_Materials]]

Library:Retell Rethink Recover External Events

2012-04-26T21:21:07Z

Kifty:

[http://bc-jerf.ca/2012/02/03/one-year-later-shaken-but-never-broken/ One Year Later: Shaken But Not Broken] 

The BC-Japan Earthquake Relief Fund (BC-JERF) will be holding a one year anniversary concert “One Year Later: Shaken But Not Broken,” on Sunday, March 11th from 3pm to 5pm at Nikkei Centre. 

[http://www.iar.ubc.ca/Home/ctl/Detail/mid/1068/xmid/1182/xmfid/2.aspx Reconstruction after Japan’s Triple Disaster] 

The UBC Centre for Japanese Research will be holding this workshop Mar 14 - 16, 2012. 

Return to [[Library:Retell Rethink Recover|main page]].

[[Category:Library Events]]

Library:Retell Rethink Recover Exhibition

2012-04-26T21:20:54Z

Kifty:

[[File:RetellRethinkRecoverTitle_Logo_FINAL.jpg‎]] 
 
'''February 20, 2012 - April 30, 2012''' 

'''RETELL''' 
Focusing on the history of the Tōhoku region, this part of the exhibition includes Edo and Meiji-period works from the library's [http://digitalcollections.library.ubc.ca/tokugawa Japanese Maps of the Tokugawa Era collection]. The exhibition will highlight disaster prints such as those depicting catfish and dragons, common in Edo-period illustrated accounts of earthquakes and tsunamis. Historical maps of the areas affected by the 2011 disasters will also be displayed. 
'''Location: [http://hours.library.ubc.ca/#view-rbsc Rare Books and Special Collections, Lower Level, Irving K. Barber Learning Centre]''' (click for map & hours) 

 
'''RETHINK''' 

Here the exhibition looks at the issue of nuclear energy and the debate that has taken place in Japan on this issue. As well, the exhibition highlights social media as a form of alternative media and information sharing in the wake of the disasters. Included in this part of the exhibition: 
Nuclear imagery courtesy of Professor [http://www.ahva.ubc.ca/facultyIntroDisplay.cfm?InstrID=12&FacultyID=1 John O'Brian] 

Atomic bomb exposed tile donated to UBC by the [http://www.hiroshima-u.ac.jp/index.html Hiroshima University] 

Photos of anti-nuclear protests in Tokyo, contributed by UBC Alum [http://mahoharada.com/ Maho Harada] 

[http://www.japanquakemap.com/ Japan Quake Map] courtesy of Paul Nicholls 

Twitter feeds contributed by UBC Alum [http://kozuematsumoto.blogspot.com/ Kozue Matsumoto] 

Facebook archives submitted by UBC Alum Brad Morrison 

Animated video "nuclear poo" 

'''Location: [http://hours.library.ubc.ca/#view-chapman Irving K. Barber Learning Centre Foyer]''' (click for map & hours)
 

'''RECOVER''' 
The final part of the exhibit uses the Asian Library collection as well as community contributions to recount Japan's capacity to recover from adversity. The March 2011 earthquake and tsunami are examined, as well as past natural disasters that have struck the country. The exhibit features: 

Ishinomaki handwritten newspaper reproductions (created in the days after the tsunami struck the Ishinomaki region) 
- digital files courtesy of the [http://newspark.jp/newspark/english/ Japan Newspaper Museum] 

Images of the Tsunami-affected region of Ogatsu, by UBC Alum [http://mahoharada.com/ Maho Harada] 

Images and blog entries related to volunteer relief efforts originating in Canada courtesy Manabu Ogawa 

Postcards depicting the 1926 Tokyo earthquake courtesy Professor [http://www.ahva.ubc.ca/facultyIntroDisplay.cfm?InstrID=12&FacultyID=1 John O'Brian] 

Red Cross letter of recognition courtesy of the [http://ubcja.net/ UBC Japan Association] 

'''Location: [http://hours.library.ubc.ca/#view-asian Asian Library]''' (click for map & hours)

Return to [[Library:Retell Rethink Recover|main page]].

[[Category:Library Events]]

Library:Retell Rethink Recover Conference

2012-04-26T21:20:39Z

Kifty:

[[File:RetellRethinkRecoverTitle_Logo_FINAL.jpg]] 
'''Saturday, March 10, 2012''' 
10:00am - 4:00pm 

Dodson Room, [http://www.maps.ubc.ca/PROD/index_detail.php?show=y,n,n,n,n,y&bldg2Search=n&locat1=516 Irving K. Barber Learning Centre] 

Registration required: retell-rethink-recover@interchange.ubc.ca or phone 604-822-0960 
Please include your name, contact information and attendance times (if not attending the full day) 

{| class="wikitable"
|-
! Time !! Speaker(s) !! Topic
|-
| 10:00 || Shirin Eshghi, Asian Library Katherine Kalsbeek, Rare Books & Special Collections || Welcome
|-
| 10:10 - 10:50 || Dr. David Edgington, Geography Dr. Christina Laffin, Asian Studies || Faculty Panel
|-
| 11:00 - 11:45 || Gideon Fujiwara, PhD Candidate Kozue Matsumoto, MA 2010|| Student Panel
|-
| 11:45 - 12:00 || Video Screening || Japan Foundation 3.11 Portrait Project
|-
| 12:00 - 12:40 || Lunch Break || Eating options available at Ike's Cafe in Barber Centre and at the [http://www.maps.ubc.ca/PROD/index_detail.php?locat1=790 Student Union Building]
|-
| 12:40 - 1:30 || Asato Ikeda, PhD Candidate || Exhibition Tour (starts at Ike's cafe)
|-
| 1:30 - 2:15 || Hidemi Shiga, PhD Candidate || Talk on Disaster Prints from the Edo Period (1600-1868)
|-
| 2:30 - 3:10 || Mr. Yuji Kikuchi || Talk on Rescue Efforts from Vancouver
|-
| 3:20 - 3:50 || Mr. Yuichi Kumagai || First-Person Account of Earthquake and Tsunami
|}
 
Return to [[Library:Retell Rethink Recover|main page]].

[[Category:Library Events]]

Library:Retell Rethink Recover Acknowledgements

2012-04-26T21:16:23Z

Kifty:

[[File:RetellRethinkRecoverTitle_Logo_FINAL.jpg]] 

Co-organizers Shirin Eshghi (Asian Library) and Katherine Kalsbeek (Rare Books & Special Collections) are grateful to the efforts of the following individuals and organizations, without whom the exhibition and conference would not be possible. 

'''Sponsor Organizations''' 
''Exhibition and Conference Sponsor'' 
[http://www.jftor.org/ Japan Foundation] 

''Funding the 3.11 Portrait Project Exhibition'' 
[http://www.jftor.org/ Japan Foundation] 
[http://www.shiseidocanada.com/ Shiseido] 

'''UBC Departmental Partner''' 
''Co-sponsor of the March 10 Conference'' 
[http://www.asia.ubc.ca/ Asian Studies Department] 

'''Project Support Staff''' 
''Curatorial Lead'' 
Asato Ikeda, PhD Candidate 

''Undergraduate Student Assistant'' 
Isao Takagaki 

'''Community Organizations''' 
''General Support & Orizuru Paper Cranes'' 
[http://www.vancouver.ca.emb-japan.go.jp Consulate General of Japan in Vancouver] 

''Digital Images for Ishinomaki Handwritten Newspaper Display'' 
[http://newspark.jp/newspark/english/ Japan Newspaper Museum] 

'''Community Members''' 
''Images & social media archives'' 
Manabu Ogawa 

''[http://www.japanquakemap.com/ Japan Quake Map] contribution'' 
Paul Nicholls 

''[http://www.youtube.com/redirect?q=http%3A%2F%2Fwww.youtube.com%2Fuser%2Fonaradaijobu&session_token=q8ElbFowNTq5Sx3bwbfkBuvgGYx8MTMzMDA1MDE5MkAxMzI5OTYzNzky Nuclear Poo video] contribution'' 
Anonymous (via [http://twitter.com/#!/hachiya Hachiya Kazuhiko])

''Conference'' 
Mr. Yuji Kikuchi 

''Planning support and guidance'' 
Yuko Ikegami Lee 

'''Alumni Contributors''' 
''Photos'' 
[http://mahoharada.com/ Maho Harada] 

''Social Media Archives'' 
[http://kozuematsumoto.blogspot.com/ Kozue Matsumoto] 
Brad Morrison 

''Conference'' 
[http://kozuematsumoto.blogspot.com/ Kozue Matsumoto] 

'''Student Contributors''' 
''Newspaper Archives Research'' 
Nathen Clerici 

''Display Assistance'' 
Yuki Ohsawa 

''Print Archives'' 
[http://ubcja.net/ UBC Japan Association] 

''Conference'' 
Gideon Fujiwara, PhD Candidate, Asian Studies Department 
Hidemi Shiga, PhD Candidate, Asian Studies Department 

'''Faculty Contributors''' 
''Images'' 
[http://www.ahva.ubc.ca/facultyIntroDisplay.cfm?InstrID=12&FacultyID=1 John O'Brian], UBC Art History and Visual Art Department 

''Handwritten Newspaper Caption Content'' 
[http://www.eastasianstudies.ualberta.ca/People/Faculty/CommonsAnne.aspx Anne Commons], University of Alberta Department of East Asian Studies 
[http://www.asia.ubc.ca/people/faculty/christina-laffin.html Christina Laffin], UBC Asian Studies Department 

''Conference'' 
[http://www.asia.ubc.ca/people/faculty/christina-laffin.html Christina Laffin], UBC Asian Studies Department 
[http://blogs.ubc.ca/dedgington/ David Edgington], UBC Geography Department 

'''UBC Library Co-Sponsors''' 
''Asian Library'' 
Eleanor Yuen (Head) 
Phoebe Chow 
April Jin 
Shaun Wang 
Isabel Zhang 

''Library Administration'' 
Leonora Crema (Client Services & Programs) 
Simon Neame (Irving K. Barber Learning Centre) 
Jo Anne Newyear-Ramirez (Collections Management) 

''Rare Books & Special Collections'' 
Ralph Stanton (Head) 
Felicia de la Parra 
Jaimie Miller 
Vivienne 

'''UBC Library Colleagues''' 
''Art + Architecture + Planning'' 
Vanessa Kam & Kevin Madill 

''Communications & Marketing'' 
Glenn Drexhage & Jessica Woolman

''Facilities'' 
Mahmoud Moulay & Richard Moore 

''Finance'' 
Fe Lubigan 
Sara McGillivray 

''Library Systems & Information Technology'' 
Brad Clements 
Garry Der

''Science & Engineering'' 
Aleteia Greenwood & Zoey Peterson

Return to [[Library:Retell_Rethink_Recover|main page]].

[[Category:Library Events]]

Library:Retell Rethink Recover 311 Portrait Project

2012-04-26T21:16:06Z

Kifty:

[[File:RetellRethinkRecoverTitle_Logo_FINAL.jpg]] 
'''February 20 - April 30, 2012''' 

Sponsored by the [http://www.jftor.org/ Japan Foundation] and [http://www.shiseidocanada.com/ Shiseido], the 3.11 Portrait Project aims to "take authentic portraits of earthquake survivors, clearly different from journalistic photographs, which will leave a meaningful record for the next generation and support the emotional recovery of local communities and Japan as a country." 

'''Location: [http://hours.library.ubc.ca/#view-chapman Ike's Cafe]''' (click for map & hours)
 
Return to [[Library:Retell Rethink Recover|main page]].

[[Category:Library Events]]

Library:Retell Rethink Recover

2012-04-26T21:15:52Z

Kifty:

[[File:RetellRethinkRecoverTitle_Logo_FINAL.jpg]] 
'''Exhibition: February 20 - April 30, 2012 | Conference: March 10, 2012''' 

[[Library:Retell_Rethink_Recover_Exhibition|'''Main Exhibition''']] 
[[Library:Retell_Rethink_Recover_311_Portrait_Project|'''3.11 Portrait Project''']] 
[[Library:Retell_Rethink_Recover_Conference|'''Conference''']] 
[[Library:Retell_Rethink_Recover_Acknowledgements|'''Acknowledgements''']] 

[[Library:Retell Rethink Recover External Events|Other commemorative events]]

[[Category:Library Events]]