Electronic Resources and Software Use at LSU PAI

1. Electronic Resources and Software Use at LSU PAI Dr. MorozovPrepared for MPA Orientation Session Fall 2013

2. Presentation Outline • Electronic System MyLSU & Moodle • Spreadsheet Software Applications (MS Excel) • Presentation Software Applications (MS PPT)

3. MyLSU - • Unified System of Learning for LSU Students. • Access to: • Moodle System • Email • Tigerware • Calendar of Events

4. MyLSU - • Web Address: https://mylsu.apps.lsu.edu/ • Login: Same as your LSU email login • Password: through your paws account • Any questions/difficulties – contact Ms. Jeannie Tyler at PAI@lsu.edu

5. Moodle System • Available once logged in your “MyLSU” account. • http://www.lynda.com/ info about excel, word, ppt. • Provides info about your classes for the current semester* • Contains Various Course Documents: • Course Presentations • Home Work Assignments • Quizzes, Study Guides, Other Exercises, etc* * - if the instructor of record uses Moodle

6. Spreadsheet Software • Multiple Packages and Formats Exist: • Cloud and On-line Spreadsheets – more than 20 packages • Spreadsheets that are parts of suites - more than 30 suites • MS Excel’ Share of the Spreadsheet Market in 2008 exceeded 80%* * - Nicholas M, Microsoft Office Market Share by Version – 2008 Data. Web access http://www.breezetree.com/blog/index.php/microsoft-office-market-share-by-version-2008-data/ URL Accessed August 10, 2013.

7. MS Excel 2010 Screen

8. MS Excel 2010 Ribbon • File – managing files • Home – common tools • Insert – insert objects • Page Layout – printing • Formulas – functions in categories • Data – working with data • Review – spelling, protecting, sharing • View – how Excel appears on screen (does not affect printing)

9. MS Excel 2010 Facts • Available Columns: A through XFD – 16,384 columns • Available Rows: 1 through 1,048,576 • Total - over 17 billion cells in each worksheet • A cell is the intersection of a column letter and a row number.The cell address is in the Name Box just above column A.

10. Workbooks and Worksheets • Each Excel file is a Workbook containing one or more Worksheets: • Default setting provides you with three worksheets – you can add or remove as needed from there • Worksheets can also be reordered within the file and renamed – you can also copy or move a worksheet to another workbook (file)

11. Mouse Pointers in Excel • Select – main mouse pointer used for selecting cells. Click once in a cell to select it or click and drag to select several cells. • Fill - appears after you have selected a cell (or cells) and will show only at the bottom right of the selection (tiny box called the Fill Handle). Using this will allow you to fill a series such as Monday, Tuesday, etc. • Insertion point - appears when you are typing or have double-clicked in a cell. The flashing insertion point determines where new text and numbers appear. • Column/Row selector - appears when you are over a column or row, allowing you to click once to select the entire column or row • Resize - appears when you are between columns or rows, allowing you to resize them.

12. Formulas • Excel can handle calculations – from very simple summing (adding) to very complicated multi-formula calculations. • Excel uses Formulas to perform calculations. • All formulas begin with = (the equals sign, next to Backspace key on the keyboard). • Functions make complicated formulas easy to use and they can be placed into formulas.

13. Resources • (2010) Beginning Microsoft Office 2010, [electronic resource], Hart-Davis, Guy. • (2010) Beginning Microsoft Excel 2010, [electronic resource], Katz, Abbott. • (2010) Beginning Microsoft Excel 2010 (Microsoft Excel 2010) [electronic resource] All books on this list are available in the LSU Library system at http://www.lib.lsu.edu/