SMS 202
Micro Computer 
Applications II
http://www.glencoe.com/norton/online/fundamentals/index.html
Section II
January 2000
As Taught by
Prof Tim Richardson
the Course Coordinator was 
Prof. Ola Cholkan
The following how the outline looked in 2000 - the only thing I have added is some info on types of RAM
Introduction Introduction to
Word 97
Excel 97
Powerpoint 97
.  Overview of Basic Computer Concepts
 Creating a worksheet (Lab 1)
 http://ilearn.senecac.on.ca/homepage/Tim.Richardson/SMS202/worksheet1.htm
Using The Computer:
Powerpoint Presentation Online
 http://ilearn.senecac.on.ca/homepage/Ola.Cholkan/sms/sms2/chapter1/sld001.htm

using the Internet and e-mail. web publishing
- look at Web Law FAQ for the parts re: publishing
HTML documents
Intranets , AI - artificial intelligenceVR - virtual reality , robotics

Chapter 1

Overview of basic computer concepts

Chapter 1
 

Handing out Course outline

 http://www.glencoe.com/norton/online/fundamentals/index.html



From Chapter 1 in Norton's text
 http://www.glencoe.com/norton/online/fundamentals/chapter1/index.html
4 parts of a computer system  (page 15, new text)
  1. hardware
  2. software
  3. data (which becomes information)
  4. people (operators, users)

  5.  
  • hardware
  • Processor (CPU)
  • microprocessors
  • circuit board
  • motherboard
  • Memory (RAM)
  • kilobyte (KB) 1,000 bytes - a thousand bytes
  • megabyte (MB) 1,000,000 bytes - a million bytes
  • gigabyte (GB) 1,000,000,000 bytes - a billion bytes
  • Input Devices 

  • (keyboard, trackball, joysticks, scanners, digital cameras, microphone, mouse, light pen) 
    and Output Devices (monitor, printer, modem, speakers)
  • Storage devices (hard drive, floppy drive, CD ROM, DVD, tape drive)
  • software
  • operating systems software
  • application software
  • data (which becomes information)
  • people (operators, users)

  • Norton's questions on-line at the end of Chapter One
     http://www.glencoe.com/norton/online/
    fundamentals/chapter1/review/index.html



    Windows95 & Windows Explorer
    .
     
    Types 
    of RAM
    "Types of RAM
    from  http://www.computer-ram-memory-4jp.co.uk/types.htm
     If you have started looking at upgrading your RAM you will almost certainly have discovered that there are  many different types of RAM. RAM can differ in the actual hardware specifications, that is how the RAM  chip actually works, but also the same type of RAM chip can have many different varieties, differentiated by  their storage capacities - for example 128MB or 512MB. 

    Some of the more common types of RAM are: "

    • DRAM 
    • SDRAM 
    • DDR RAM 
    • EDO RAM 
    • SRAM 
    from  http://www.computer-ram-memory-4jp.co.uk/types.htm
    Types of RAM
    DRAM
    DRAM
    from  http://www.computer-ram-memory-4jp.co.uk/types.htm

    Dynamic RAM (DRAM) is perhaps one of the most common types of RAM available. DRAM is used to  store information that is being passed around a computer and between peripherals. The information is not  actually saved, it is temporarily stored in memory until the curent process has finished. 

    DRAM needs a way to remember the information it is storing, and the process by which it achieves this is a large contributor to it being known as dynamic RAM. DRAM must be constantly refreshed, not just every now and then, but repeatedly each second. If this process did not take place DRAM would not be able to hang on to the information it is storing. 

    The reason DRAM needs to be refreshed in this way is because in effect it stores information via electrical charges. These electrical charges weaken, similarly to a normal battery, if the electrical charge becomes too weak then the information will be lost from memory. 

    Types of RAM
    EDO DRAM
    EDO DRAM
    from  http://www.computer-ram-memory-4jp.co.uk/types.htm

    EDO DRAM is an abbreviation for Extended Data Out Dynamic Random Access Memory, EDO RAM is therefore a type of DRAM. So what on earth does that mean?? Well the name gives us a little clue, albeit  kind of cryptic - the Extended Data Out name relates to the fact that EDO RAM does not have to finish processing the first bit before continuing to the next one. Remember that a bit is actually a Binary Digit and  this is how information is stored in memory. 

    EDO RAM is faster than its standard counterpart DRAM. The improvement comes from the fact that as soon as the location of the first cell is discovered, EDO RAM will begin looking for the next address.   EDO represented an improvement in performance, however, it now has a superior successor in the form of SDRAM. 

    Types of RAM
    SDRAM
    SDRAM
    from  http://www.computer-ram-memory-4jp.co.uk/types.htm

    SDRAM is an abbreviation for Synchronous Dynamic Random Access Memory. SDRAM can be considered a replacement for the earlier EDO DRAM. SDRAM is actually synchronised with the computers  system clock> It is able to increase performance by taking advantage of interleaving, which is the process whereby the SDRAM module is able to access a cell at the same time as finishing one. 

    SDRAM also works on the assumption that most of the time the data required by the CPU will actually be in  sequence - rather than a totally random distribution. Therefore SDRAM will stay on its current row (bits are addressed through rows and columns) and move across each column reading each bit along the way. 

    Chapter 6

    Productivity Software

    (Application)
    Software

    Productivity Software
    (old name Application software)
    Productivity software can be any application that helps the user accomplish a specific task, whether the task involves generating text or graphics, working with numbers, searching for data, or preparing a presentation.
    http://www.glencoe.com/norton/online/fundamentals/chapter6/index.html
    • Word Processing Software
    • Spreadsheet Programs
    • Database Management Systems
    • Presentation Programs
    A brief history of spreadsheets
     http://dssresources.com/history/sshistory.html

    Microsoft Powerpoint Overview
     http://www.microsoft.com/catalog/display.asp?site=127&subid=22&pg=1

    Norton's questions on-line at the end of Chapter One
     http://www.glencoe.com/norton/online/
    fundamentals/chapter6/review/index.html


    Productivity Software (Application Software)
     Creating a worksheet (Lab 2)
     http://ilearn.senecac.on.ca/homepage/Tim.Richardson/SMS202/worksheet2_explorerlabhtm.htm
     
    Chapter 2

    Processing
    Data
    Processing Data

    Chapter 2
     http://www.glencoe.com/norton/online/fundamentals/chapter2/index.html
    In this chapter, you’ll find out what data is, how it differs from information, and what form it takes in the computer. Then, you’ll explore the two processing components: the central processing unit (CPU) and memory. You’ll also learn about the most important factors affecting a computer’s speed. Finally, you’ll look at the microprocessors made by the biggest chip manufacturers, with an  emphasis on the families of chips from Intel and Motorola. 

    bits and bytes, page 43

    Powerpoint presentation on Chapter 2
     http://ilearn.senecac.on.ca/homepage/Ola.Cholkan/sms/sms4/chapter2/sld001.htm

    Installing RAM in a computer
     http://www.personal.riverusers.com/~mikemoss_gila/ram_install.html

    Norton's questions on-line at the end of Chapter Two
     http://www.glencoe.com/norton/online/
    fundamentals/chapter2/review/index.html



    Lesson #3 in Norton's Excel 97 2nd Edition book

    EXCEL LESSON 3 
     http://ilearn.senecac.on.ca/homepage/Ola.Cholkan/sms/sms4/sms4.html

       1.Complete tutorial pages 54 through 77. Print as requested. 
       2.Application projects #4, 5 and 7 on pages 82 and 83. Print as requested. 

    Doing math with formulas and functions

    Chapter 3
    http://www.glencoe.com/norton/online/fundamentals/chapter2/index.html
    Input & output hardware

    Processing Hardware, CPU, RAM, ROM, motherboards, microprocessor chips, system clock

    Powerpoint presentation on Chapter 3
    Interacting with your Computer
     http://ilearn.senecac.on.ca/homepage/Ola.Cholkan/sms/sms5/chapter3/sld001.htm

    Input:
     - 4 types of terminals
     - digital cameras
     - a web site with a  chart showing all the main lines of digital cameras on the market, their prices and FABs
     - CRW labs  Product Feature Ratings & Comparisons of Digital Cameras
     - good info at http://www.digitalcamerastore.com/
     - scanning devices
     - voice input devices

    Output Devices:: 
     Monitors, Printers, Plotters, Voice
    Printers
     - web site http://www.4printers.com/which lists all the major printer manufacturers, retailers, supplies and accessories - allows you to follow links to home pages for each manufacturer

    Norton's questions on-line at the end of Chapter Three
     http://www.glencoe.com/norton/online/
    fundamentals/chapter3/review/index.html

    . EXCEL LAB TEST #1 (20% of final grade) 

    Test includes knowing things in Windows Explorer,  and covers the work done in Excel 97 labs 3 and 4 . 



    MIDTERM (15% of final grade). Multiple choice. Bring a pencil.

    Computing Essentials chapters 1,2,3,4,6.

    .  Feb 28 - March 3rd Winter break week
    Chapter 6  Input and Output

    Powerpoint on the Operating System and the User Interface
     http://ilearn.senecac.on.ca/homepage/Ola.Cholkan/sms/sms8/chapter5/sld001.htm


    Lab Work
    Creating Charts (Lab 5 in the Excel 97 text)
    begins on page 124 in the text 
    you will be using the data from the file on Pet Paradise - Pet Food and Pet Supplies
    - when you finish, print the chart on page 146 and hand it in
    Chapter 8
    http://www.glencoe.com/norton/online/fundamentals/chapter4/index.html
    The Internet

    Peter Norton's ppt for Chpt 8
     http://ilearn.senecac.on.ca/homepage/Ola.Cholkan/sms/sms10/chapter8/sld001.htm

    - Professor Richardson has a number of resources to explain the Internet
    - at another college, Richardson teaches a course titled The Internet and its Impact on Society
    There are several topics discussed in this other course that would be appropriate to note in discussing The Internet for SMS 202
     - Easy to follow summary of the History of the Net, followed by Q&A with Dr. Vinton Cerf - highly recommended to read
     - Powerpoint presentation by T.R.  History of the Internet
     - Link to a " timeline" showing the dates of key events in the
      Internet's history written by Robert H Zakon&nbsen by Robert H Zakon 
     - the Internet framework, how the computers are connected 
       Link to an article by "The" person who developed the WWW,Tim Berners-Lee
     - the World Wide Web Consortium  http://www.w3.org/ W3C
     - extensive glossary of Internet terms  http://www.matisse.net/files/glossary.html

    Norton's questions on-line at the end of Chapter Eight
     http://www.glencoe.com/norton/online/
    fundamentals/chapter8/review/index.html



     Lab Work
     Financial Functions Lab 
     
    PRESENT VALUE (PV) 
         =PV(rate,nper,pmt,fv,type) 

         FUTURE VALUE (FV) 
         =FV(rate,nper,pmt,pv,type) 

         NUMBER OF PERIODS (NPER) 

         PAYMENT (PMT) 
         =PMT(rate,nper,pv,fv,type) 
         Either PV or FV must be entered as a negative value! 
     

    Future Value – Present Value = Amount of Interest 
         FV is always greater than PV 

         Rate = interest rate per period 
         Nper = total number of time periods OR total number of payments 
         Pmt = amount of one payment made regularly each period (annuities) 
         entered as a negative value 
         FV = future value, entered as a negative value 
         PV = present value, entered as a negative value 
         Type = 0 if payment is made at the end of each period 
         1 if payment made at the beginning of each period (annuities due)

      http://ilearn.senecac.on.ca/homepage/Ola.Cholkan/sms/sms11/sms11.html

    if you want a head start on doing this lab, go here to get a sheet laying out the questions and the answers to a few of them
     http://ilearn.senecac.on.ca/homepage/Tim.Richardson/SMS202/financialfunctionslab.htm

    this is due in class next week (March 22)

    Chapter 8 The Internet


     Lab Work
     Financial Functions Lab, continued
    http://ilearn.senecac.on.ca/homepage/Ola.Cholkan/sms/sms11/sms11.html

    start work on Templates and Macros Lab  http://ilearn.senecac.on.ca/homepage/Ola.Cholkan/sms/sms10/sms10.html

    . Concepts Quiz
    Workplace issues; Computer Security
     - viruses and electronic sabotage  Electronic Sabotage from the web site of Dr. Carol Brown at Oregon State University
     - some simple steps on protecting your PC from a Macro Virus written by James Derk


    How to buy your own 'puter


    Lab Work
    Templates and Macros Lab due
    . Review
    Lab Test 
    #2 
    20%
    Lab Test #2
     - based on (Labs 4,5 breakeven, financial & statistical functions)
     - to be done in the 2nd and 3rd hour of the class


    If you have unfinished labs or assignments - they MUST be handed in to the professor no later Friday April 14th.
    Extensions cannot be granted since the marks must be calculated in time for submission to the department.
    Final Exam
    25%
    Final Exam 25%
     
    http://www.glencoe.com/norton/online/fundamentals/chapter4/index.html - to be done in classroom 3261
    - start time is 11:00 in the morning Wednesday April 19th
     - the test covers all the chapters in the Norton book