TTUHSC Libraries
HomeLibraries

Unit 6a: Spreadsheets

The spreadsheet is a powerful tool for performing all types of time-consuming numerical calculations. By entering data into cells and using logic commands, "what-if" questions can be calculated easily. Excel, Google Doc Spreadsheets, and other programs may be used to create graphs and charts that can be imported into PowerPoint and Word documents.

Goal:

To learn how to set up a spreadsheet in Microsoft Excel and Google Docs and to make appropriate graphs and charts from it.

Objectives:

When the spreadsheet component is complete, the student will be able to:

  1. Comprehend spreadsheet terminology.
  2. Set up a spreadsheet with formulas to calculate totals, averages and format cells appropriately.
  3. Adjust column widths and row heights.
  4. Copy and paste data from one cell to another cell as a time-saver. Create graphs/charts with clear and descriptive labels and titles for all categories of data.
  5. Insert graphs/charts into word-processed documents and PowerPoint presentations.
  6. Become familiar with mobile versions of spreadsheets.

Activities:

  1. Read the recommended readings and complete the terminology exercise in Sakai during the week of October 20-24, 2014.
  2. Complete the practice spreadsheet and upload the document to Sakai before 5:00 pm, Friday, October 31, 2014.
  3. View the tutorials on Microsoft Excel and Google Docs.
  4. Complete the two spreadsheet exercises and upload the documents before 5:00 pm, Friday, November 21, 2014.
  5. Write a short paper (two pages maximum and post in Sakai before 5:00 pm, Wednesday, November 26, 2014.
  6. View the tutorials on mobile versions of spreadsheets. Complete a short (250-550 words) essay before 5:00 pm, Friday, December 5, 2014.

Minimum Time:

Estimated 12 - 14 hours.

Evidence:

  1. Completed terminology quiz.
  2. Three completed spreadsheets (one practice, two exercises).
  3. Short paper on the comparison of free and commercial spreadsheet programs.
  4. A 250-500 word essay on mobile spreadsheets.

Instructors:

Stephanie Shippey, M.L.S., A.H.I.P.

Lubbock Administration, Room 262

Phone: 806-743-2208

Fax: 806-743-2218

Email: stephanie.shippey@ttuhsc.edu

Video conference available through Microsoft Lync

 

Candia Thew, M.L.S.

Lubbock LRC, Room 221

Phone: 806-743-2202

Fax: 806-743-2218

Email: candia.thew@ttuhsc.edu

 

Required Resources

Introduction to Spreadsheets

Sewell, J., & Thede, L. (2013). Spreadsheets: Making numbers talk. In Informatics and nursing: Opportunities and challenges (pp. 135-154). Philadelphia, PA: Lippincott.

Excel GCFLearnFree.org. (2010, November 18). Excel 2010. Simple formulas. Retrieved from http://www.youtube.com/watch?v=JJPjs-lITAw

Hurlock, J. (2014). How to create a basic chart in excel 2010. Retrieved from http://office.microsoft.com/en-us/excel-help/how-to-create-a-basic-chart-in-excel-2010-RZ102559017.aspx?CTT=1

Launch Excel. (2011, November 7). Excel formula basics: Sum, count, average. Retrieved from http://www.youtube.com/watch?v=ynooYQfkY6w

Microsoft Office. (2014) Use excel tables to manage information: Introduction to tables. Retrieved from http://office.microsoft.com/en-us/excel-help/introduction-to-tables-RZ102252956.aspx?CTT=1&section=2

Google Spreadsheets Corbin, T. (2014, January 3). Google spreadsheets tutorial. Retrieved from http://youtu.be/A1Vi6UKhzLA

Google. (2014). Create a chart or graph. Retrieved from https://support.google.com/drive/answer/63728?hl=en

Kippenbrock, T., Holloway, E., & Moore, DD. (2010). Google docs: A better method than a paper clinical schedule. CIN: Computers, Informatics, Nursing, 28, 138- 140. doi: 10.1097/01.NCN.0000336496.42221.c5

 

Mobile Spreadsheets

Ansaldo, M. (2014). 4 office for ipad alternatives. PCWorld. Retrieved from http://www.pcworld.com/article/2147303/4-office-alternatives-for-ipad.html

Hachman, M. (2014). Microsoft announces office for ipad, extending productivity to all ios devices. PCWorld. Retrieved from http://tinyurl.com/omy6toz

Kissell, J. (2012). Editing excel files on an ipad. MacWorld. Retrieved from http://www.macworld.com/article/1168325/editing_excel_files_on_an_ipad.html

 

Additional Resources

Klein, M.G., & Reinhardt, G. (2012). Emergency department patient flow simulations using spreadsheets. Simulation in Healthcare, 7, 40-47. doi: 10.1097/SIH.0b013e3182301005

Margolius, D., & Ghaly, M. (2011). Using a simple spreadsheet to improve intra-office communication and patient flow. Family Practice Management, 18, 27-30.

Newcomb, P. (2012). Spreadsheet and relational database programs: Useful tools for perioperative nurses. Perioperative Nursing Clinics, 7, 211-221. doi: 10.1016/j.cpen.2011.09.001

Online spreadsheet. (n.d.) In Wikipedia. Retrieved from http://en.wikipedia.org/wiki/List_of_online_spreadsheets

Schwartz, S. A. (2010). Microsoft office 2010: For windows. Berkeley, CA: Peach Pit Press.

Schwartz, S. A. (2011). Microsoft office 2011: For mac. Berkeley, CA: Peach Pit Press.

Spreadsheet. (n.d.) In Wikipedia. Retrieved from http://en.wikipedia.org/wiki/Spreadsheet

Wempen, F. (2012). Microsoft excel 2010 elearning kit for dummies. Hoboken, NJ: John Wiley & Sons, Inc.

Williams, J.S. (2011). Best practices. Simple spreadsheet keeps equipment repairs on track. Biomedical Instrumentation & Technology, 45, 468-471. doi:10.2345/0899-8205- 45.6.468

©