computers and society ist 2710
Download
Skip this Video
Download Presentation
Computers and Society IST 2710

Loading in 2 Seconds...

play fullscreen
1 / 12

Computers and Society IST 2710 - PowerPoint PPT Presentation


  • 86 Views
  • Uploaded on

Computers and Society IST 2710. Section 006 Class #7: 2/20/08 http://www.is.wayne.edu/drbowen/casw08. Midterm. Midterm is next week, February 27 Cumulative Two hours in class, like two quizzes Will cover Excel lab next week Question-and-Answer Review this week. Staying for Lab.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Computers and Society IST 2710' - pabla


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
computers and society ist 2710

Computers and SocietyIST 2710

Section 006

Class #7: 2/20/08

http://www.is.wayne.edu/drbowen/casw08

midterm
Midterm
  • Midterm is next week, February 27
    • Cumulative
    • Two hours in class, like two quizzes
    • Will cover Excel lab next week
  • Question-and-Answer Review this week

Computers and Society, Class 7

staying for lab
Staying for Lab
  • Two or more labs or assignments behind, must stay during Lab to get 100% attendance credit tonight - 3 labs in, and 2 assignments in. Who must stay:
    • EVERYONE! (Unless you have turned more in tonight).

Computers and Society, Class 7

slide4
News
  • The CD-ROM (about 700 MB) and DVD-ROM (about 4.7 GB) are accepted computer storage formats for optical disks
  • The next technology is two-level DVDs that will store about 10 GB
    • Blue-Ray (Sony) Vs HD-DVD (Toshiba)
    • Toshiba has just announced it is withdrawing HD-DVD
    • Expect more products and advertising soon

Computers and Society, Class 7

finishing chapter 5
Finishing Chapter 5
  • Computer Monitoring software – types:
    • Detect and monitor another computer on a network
      • “Monitor” often means screen shots
    • Keyboard logger – log or record all keystrokes, send the log to someone else (a hacker?)
    • Presence technology – sometimes can locate computer or device physically (GPS etc.)

Computers and Society, Class 7

computer monitoring software
Computer Monitoring Software
  • This software must be installed on computer being monitored
  • Video surveillance – video cameras being installed in many places, for different purposes
  • Employee monitoring – like computer monitoring, except better access to computer

Computers and Society, Class 7

computer monitoring software1
Computer Monitoring Software
  • Presence technology – cellphones
  • Protecting yourself
    • Software can be installed without your knowledge, by clicking on a link, for example in an online greeting card or email
    • DB: Tracking Cookie – looks at other cookies
    • Computer security to detect monitoring software – antispy software, modern antivirus software (SpyBot, AdAware)

Computers and Society, Class 7

using excel 2007
Using Excel 2007
  • Starting – be careful to start 2007, not 2003
  • Layout – cells in rows and columns
    • Cell address
  • Selecting a cell or a range of cells
  • What can you put in a cell?
    • Text (usually as a label)
    • Number (types)
    • Formula (the real power)

Computers and Society, Class 7

using excel 20071
Using Excel 2007
  • Entering information in a cell
    • Click on cell to select it
    • Type
    • Tap <Enter> (or arrow/click to another cell)
      • Entry grayed out until you do this
  • Formatting
  • Formula
    • ALWAYS STARTS WITH = !!!
    • <Enter> to stop

Computers and Society, Class 7

excel formulae
Excel Formulae
  • +, -, *, / combine with ( & )
    • Entering a cell address processes the contents of that cell
    • Enter address by typing or (better) by clicking
    • What you see in the cell is the results of the formula – see the formula on the formula bar
      • Seeing formulae in cells
  • Other formulae operate on range(s)
    • Sum, Average, Min, Max
  • Excel formulae are live !!!

Computers and Society, Class 7

excel charts
Excel Charts
  • Chart of cell contents, usually a data table
    • Enter data
    • Select range to plot (include labels)
    • Click Insert tab, then select chart type

NOTE: Left column (labels) should be text, not numbers. To use numbers, start each with ‘

Computers and Society, Class 7

review for midterm
Review for Midterm
  • Based on “Topics” sheet for Midterm

Computers and Society, Class 7

ad