Micro Computer Applications II |
January 2000 As Taught by Prof Tim Richardson |
Prof. Ola Cholkan |
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
|
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)
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: "
|
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)
|
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
http://dssresources.com/history/sshistory.html Microsoft Powerpoint Overview
Norton's
questions on-line at the end of Chapter One
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
bits and bytes, page 43 Powerpoint presentation on
Chapter 2
Installing RAM in a computer
Norton's
questions on-line at the end of Chapter Two
Lesson #3 in Norton's Excel 97 2nd Edition book EXCEL LESSON 3
1.Complete tutorial
pages 54 through 77. Print as requested.
Doing math with formulas and functions |
||
Chapter 3
Input & output hardware |
Processing Hardware, CPU,
RAM, ROM, motherboards, microprocessor chips, system clock
Powerpoint presentation on
Chapter 3
Input:
Output Devices::
Norton's
questions on-line at the end of Chapter Three
|
||
. | 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
|
The Internet
Peter
Norton's ppt for Chpt 8
- Professor
Richardson has a number of resources to explain the Internet
Norton's
questions on-line at the end of Chapter Eight
Lab Work Financial Functions Lab
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
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 | ||
#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%
|