PPT-Introduction to Spreadsheets

CSCIN 100 Department of Computer Science and Information Science Microsoft Office Excel 2010 This is a worksheet Multiple worksheets make up a workbook The default is three worksheets to start. Kathleen McElhinney, Metadata/Cataloging Librarian. Agenda. Basics of Tab-Delimited Spreadsheets (TDS). Differences in TDS for simple and complex objects. Adding structure for monograph compound objects. +5 Swords of Calculation. Fluency with Information Technology. INFO100 and CSE100. Katherine Deibel. 2012-02-17. Katherine Deibel, Fluency in Information Technology. 1. Spreadsheets. Powerful tools for managing data. Kristina Kerr. BI Product Manager. Microsoft. kkerr@microsoft.com. Microsoft. Pontus . Haglund. Mid-Market SSP. Microsoft. pontush@microsoft.com. Find information and. improve business insight. Infrastructure That Enables You To…. New modules. NEW ICDL . INTERNATIONAL LAUNCH. London May 2013. Programme. Ongoing recognition of ICDL. meeting the challenge of new technologies. impact of social media. marketing the NEW ICDL. panel discussions. TASK . “A”. Create a table in spreadsheet that records the following data for each student: ID Number, Last Name, First Name, Gender, Grade Level. .. Add a new column to determine the students school fee based on their Grade level.. A few scenarios where Excel is. . not optimal and alternatives. Setting 9 on machine A was wrong!. . Supposed to be 20 instead of 24. Limitations of spreadsheets. * Updating non-normalized data. Basics. Objective 4.01. What is a . Spreadsheet. ?. A . spreadsheet (or worksheet). is an arrangement of . cells. in . columns . and. rows . used to organize, analyze, calculate, and report information, usually in numerical form. . to . UAccess. Analytics. An Introduction to Utilizing . MyAnalytics. Lists. . . .. Are . you entering data from Analytics into your spreadsheets? . Do you have seemingly countless spreadsheets that you’re updating everyday with only one or two items of information?. Tyra Burton. Marketing & Professional Sales, Coles College. What we are doing today. How to get an account. Google Drive. Forms. How to create & add to D2L. Documents. Other Uses including Spreadsheets. ICT 2. Learning target. Student will identify the parts of a spreadsheet.. vocabulary. Cell Reference – location of a cell. Row – labeled with numbers. Formula Bar – allows users to enter a formula. Understanding the uses of spreadsheets and the features available in spreadsheet software packages. Designed to carry out calculations quickly and accurately. Aim to display the results in an easy-to-understand way. You will . learn about some . important . features of spreadsheets, as well as a few principles for designing and representing information. .. Online . MS-Office information . source: . https://. support.office.com/. Kathleen McElhinney, Metadata/Cataloging Librarian. Agenda. Basics of Tab-Delimited Spreadsheets (TDS). Differences in TDS for simple and complex objects. Adding structure for monograph compound objects. Skills > . Google Docs. In this section:. Spreadsheets Part 1. Navigating in Google Docs. Spreadsheets Part 2. Word Processing. Presentations. Google Docs. In this section:. Sharing Documents. Creating Documents and Folders.