TTUHSC Libraries

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.


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


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.


  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.


  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.


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

Lubbock Administration, Room 262

Phone: 806-743-2208

Fax: 806-743-2218


Video conference available through Microsoft Lync


Candia Thew, M.L.S.

Lubbock LRC, Room 221

Phone: 806-743-2202

Fax: 806-743-2218



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 (2010, November 18). Excel 2010. Simple formulas. Retrieved from

Hurlock, J. (2014). How to create a basic chart in excel 2010. Retrieved from

Launch Excel. (2011, November 7). Excel formula basics: Sum, count, average. Retrieved from

Microsoft Office. (2014) Use excel tables to manage information: Introduction to tables. Retrieved from

Google Spreadsheets Corbin, T. (2014, January 3). Google spreadsheets tutorial. Retrieved from

Google. (2014). Create a chart or graph. Retrieved from

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

Hachman, M. (2014). Microsoft announces office for ipad, extending productivity to all ios devices. PCWorld. Retrieved from

Kissell, J. (2012). Editing excel files on an ipad. MacWorld. Retrieved from


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

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

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