CS West Virginia University by jennyyingdi

VIEWS: 5 PAGES: 36

									Technology Overview, etc
  Introduction to Excel
        Sean Banerjee
 sean.banerjee@mail.wvu.edu



         CS101 Research Tools, etc   1
Thing to cover today
 •   Logging into your computers
 •   Signing the AIPA Forms
 •   Attendance system
 •   Submitting assignments
 •   How to answer critical thinking questions
 •   Overview on number types
 •   More data analysis
 •   MyITLab introduction
 •   Excel introduction
                                                 2
Logging into your computer
 Username: student
 Password: student

 Note: it is case sensitive




                              3
Signing the AIPA Forms
 AIPA – Academic Integrity Policy
   Acknowledgement form

 Basically says you are aware of the academic
   integrity policy and its penalties.

 You must sign this form to receive credit for this
   class.


                                                      4
Attendance System
 The attendance system uses MasterID, if you haven’t
   activated your MasterID account yet please do so
   immediately. http://masterid.wvu.edu

 Starting next week we will use the web based attendance
   system. If you visit http://cs101.wvu.edu and look to
   the left under Student Tools you will find the link for
   Record Attendance.

 Record your attendance at most 5 minutes before class
   starts, or after class starts.
                                                             5
Submitting an assignment
 All homework assignments and tests will be submitted using the
     web tool. To submit an assignment visit http://cs101.wvu.edu
     and look to the left under Student Tools you will see a link for
     Submit Assignments.
 When you submit an assignment make sure you enter your First
     Name and Last Name and specified the correct section and
     project. If for some reason you select the wrong section or
     project, just resubmit it but let me know by email. Also, if you
     made changes to your assignment and want to submit a new
     version you can do that as well but again let me know via email.
 If the assignment doesn’t submit properly, make sure the file you
     are trying to submit is not open. We will do a demo of the
     submission system next week.
                                                                        6
MIX and its issues
 If I don’t respond to your email in a day it means I
    didn’t get it, Groupwise sometimes flags MIX
    accounts as spam. Resend the email from an
    alternate account or talk to me before/after
    class.

 If you need a refresher on how to use MIX to send
    files, stop by Open Lab on Friday between 4-
    6PM. Remember MIX is picky with file sizes.



                                                        7
Critical Thinking
   – All Homework Assignments and Tests will
     have a section called Critical Thinking or
     Analysis Questions.

   – Typically 5 questions (you pick your favorite 4)
     pertaining to the assignment or common
     knowledge questions.

   – Yes and No are not good answers, a few
     moments searching on the web can get you a
     more accurate answer.
                                                        8
Sample Critical Thinking questions
    – Automobile accident rates went up in 1995.
      What could cause the accident rates to
      increase suddenly?




 What do each of those pictures have in common?

 http://en.wikipedia.org/wiki/National_Maximum_Speed_Law


                                                           9
Using Search Engines
 You might find it useful to search on the web for
   answers to some of the critical thinking
   questions.
      • Plan your searches
      • Be specific
      • Narrow searches using multiple keywords
      • Use initial results to tweak your search
        strategy


                                                     10
Common Search Engines

 www.google.com
 www.yahoo.com
 www.msn.com

 There are more, but Google and Yahoo are the
   preferred choice.



                                                11
Search tips
 • cars is a bad search term if you are trying to find
   a Honda Civic, instead searching “Honda Civic”
   will give better results. If you place a search
   item in quotes, the search engine will search for
   the exact phrase.
 • If you searched with just Honda Civic without
   quotes, what would it return?
 • If you are having trouble finding results try using
   synonyms, for example use vehicle instead of
   car to search for a car.

                                                         12
Tweaking Searches
 • Negative terms
   – Virus –computer will find pages that mention
     the word virus but not the word computer.
 • AND and OR queries
   – Most search engines automatically insert the
     word AND between phrases (which is why
     quotation marks are useful) so there is no
     need to type it in the search engine. OR is
     useful for searching for more than one term,
     such as West Virginia University OR WVU.


                                                    13
Better searching tips
 • Google ignores common terms such as where and
   how, as well as single digits and letters.
 • It is not case sensitive. Typing aNoThEr pHrAse will
   return the same results as another phrase.
 • To search for Roman numerals or a common word,
   either use quotations or the + sign. “World War I” and
   World War +I will return about the same results.
 • Use the site command
    – classes site:wvu.edu will return pages that
       reference classes, but only the sites that are on the
       WVU server.

                                                               14
CS101 and search resources
 • Microsoft Office has a fairly good Help system if
   you get stuck when working on something
 • Search for specific items on Google, for
   example: “Microsoft Excel” and “insert chart”
   will give you pages that talk about how to insert
   charts in Excel
 • For some questions searching Wikipedia might
   give a better answer, but be cautious to ensure
   the sources are valid and not opinionated


                                                       15
Wikipedia
 • www.wikipedia.com is a free user edited online
   encyclopedia
 • Information is current and up to date
 • But… what makes Wikipedia bad?
 • If I made a page stating the sun rises in the west
   and stored it on Wikipedia, would that make it a
   fact?



                                                        16
Evaluating Sources
 • Ask yourself some questions
   – What can the URL tell you?
   – Who wrote the page? Is he, she, or the authoring institution
     a qualified authority?
   – Is it dated? Current, timely?
   – Is the information cited authentic?
   – Does the page have overall integrity and reliability as a
     source?
   – What's the bias?
   – Could the page or site be ironic, like a satire or a spoof?
   – If you have questions or reservations, how can you satisfy
     them?
                                                                    17
When you need quality information
 • Search engines like Google are totally unfiltered.
 • Wikipedia is user edited, information is biased
   or opinionated
 • They work by scouring the web and presenting
   you with whatever the find - without regard to
   the veracity of the information. Google has no
   editorial filter.
 • In cases like this you might need to hunt
   through library databases and so forth.


                                                        18
Math 101
 Understanding number types:
 Integer: An integer is a natural number that can hold a value between -32,768
    and 32,767. Examples of such ranges are the number of pages of a book.
 Long Integer: A long integer is a natural number whose value is between
    –2,147,483,648 and 2,147,483,642. Examples are the population of a city, the
    distance between places of different countries, the number of words of a
    book.
 Single: A single is a decimal number whose value can range from –3.402823e38
    and –1.401298e-45 if the number is negative, or from 1.401298e-45 and
    3.402823e38 if the number is positive.
 Double: While the Single data type can allow large numbers, it offers less
    precision. This is used for numbers that range from 1.79769313486231e308
    to –4.94065645841247e–324 if the number is negative or from
    1.79769313486231E308 to 4.94065645841247E–324 if the number is positive.


                                                                                   19
Data Collection
 • One big issue with data analysis is trying to figure out
   whether we need more data or less data

 • How often should one collect data?
    – Gas prices – do we collect daily, weekly, monthly
    – Stock prices – do we collect daily, weekly, monthly
    – Population – do we collect daily, weekly, monthly

 • Gathering data too frequently can lead to excessive
   data (slows down resources) but not collecting data
   frequently enough can lead to poor results
                                                              20
MyITLab
 Each Lesson consists of multiple chapters

 Each Chapter has multiple questions

 Each question has multiple steps

 Remember, every MyITLab question can be found
   in the text

                                                 21
Introduction to Excel
 • Excel is a computerized spreadsheet, which is an important tool
   that helps you report and analyze data. Uses include:
    – Business
    – Engineering
    – Education
    – And much more
 • Excel stores spreadsheets in documents called workbooks.
 • Each workbook is made up of individual worksheets.
 • Because many types of calculations can be made in the Excel
   spreadsheet, it is much more flexible than paper or pocket
   calculator.


                                                                     22
Excel 2007 and older versions
 The Menu Bar - this is a completely different from
   the old school versions of Office.

 The Office Icon (top left) – this is where all the
   items that used to be under File are now placed.
   Such as New, Open, Print, Save, Save As, etc.

 There are a few more features in Excel 2007, such
   as displaying formulas as you type, Icon sets,
   etc.
                                                      23
Excel Introduction – The Menu bar
 • The menu bar as the following tab items:
    – Home
    – Insert
    – Page Layout
    – Formulas
    – Data
    – Review
    – View


                                              24
Excel Introduction – HOME tab
    – Clipboard
    – Font
    – Assignment
    – Number
    – Style
    – Cells
    – Editing

 The basic Excel tab. Contains basic editing functions such
   as cut and paste along with most formatting actions.
   As with all groups, pull down areas are available and do
   increase functionality.

                                                              25
Excel Introduction – INSERT tab
   – Tables
   – Illustrations
   – Charts
   – Links
   – Text

 Brings together all insert functions in one area.
   Includes ability to create graphs and add tables.
   Contains powerful picture functions. Headers
   and footers are inserted here.

                                                       26
Excel Introduction – PAGE LAYOUT tab
   – Themes
   – Page Setup
   – Scale to Fit
   – Sheet Options
   – Arrange

 Contains all functions associated with page
   appearance, setup, and printing. Allows for
   many custom views.

                                                 27
Excel Introduction – FORMULAS tab
   – Function Library
   – Defined Names
   – Formula Auditing
   – Calculation

 The area that contains the mathematical
   backbone of Excel. Includes basic areas
   (Function Library) as well as more advanced
   stuff (Formula Auditing).
                                                 28
Excel Introduction – DATA Tab
   – Get External Data
   – Connections
   – Sort & Filter
   – Data Tools
   – Outline

 The heart of the database portion of Excel. While
   not a true relational database, it has a lot of
   flexibility and analysis tools like Goal Seek and
   Scenario Manager.
                                                       29
Excel Introduction – REVIEW tab
   – Proofing
   – Comments
   – Changes

 Contains all reviewing tools in Excel, including
   such things as spelling, the use of comments,
   sharing and protection.



                                                    30
Excel Introduction - VIEW tab
   – Workbook Views
   – Show/Hide
   – Zoom
   – Windows
   – Macros

 Contains basic and advanced view settings. Some
   of these options also appear below the
   horizontal and vertical scroll bars.

                                                   31
Navigating in Excel – some shortcuts
 Keystroke   Action

 ↑           Moves up one cell

 ↓           Moves down one cell

 ←           Moves left one cell

 →           Moves right one cell

 PageUp      Moves active cell up one screen

 PageDown    Moves active cell down one screen

 Home        Moves active cell to column A of current row

 Ctrl Home   Moves active cell to cell A1

 Ctrl End    Moves to the rightmost, lowermost active corner of the worksheet

 F5          Displays the GoTo dialog box to enter any cell address




                                                                                32
Navigating in Excel – more shortcuts
 http://office.microsoft.com/en-
   us/excel/HP011116591033.aspx

 The above link has a pretty comprehensive list of
   Excel shortcuts, you might find some of them
   useful.




                                                     33
First Spreadsheet
 • Open up Excel
 • Create a file called
   first_spreadsheet_011409.xlsx
   – Adding the date after the spreadsheet can
     sometimes be useful if you have multiple variants of
     the same spreadsheet. You don’t need to add the
     .xlsx as Excel adds it in for you automatically
 • Where you save your spreadsheet doesn’t
   matter, but you should remember where it’s
   saved so you can locate it later
                                                            34
Renaming sheets, tab color
 • By default you get three sheets – Sheet1, Sheet2,
   Sheet3.
 • Name them to what is relevant to the task, don’t ever
   leave them at the default names.
 • To delete a sheet – right click and select delete
 • To insert a sheet – right click and select insert or click
   the insert sheet icon to the right of the last sheet
 • To change Tab color – right click and select Tab Color.
   This can be very helpful when trying to locate a sheet
   in a workbook with multiple sheets.

                                                                35
Next Class – Wednesday Jan 21
 Monday Jan 19 is MLK Day so no class. Next class
  is Wednesday Jan 21.

 Purchase the text books please… you will need the
   Office 2007 cd and MyITLab key code.
 Register for MyITLab – instructions are here:
   http://cs101.wvu.edu/registermyitlab
 Make sure your MasterID is set up and working
   properly.
                                                     36

								
To top