Computer and Information Science 200 Computer Assisted Problem Solving for Business

1
Computer and Information Science 200Computer
Assisted Problem Solving for Business
1
CIS 200 - Introduction
2
CIS200 Winter 04
Course Lecturer Office Phone Office
Hours Email Webpage Class Meets Lab Meets

• CIS200
• Bettina Bair
• Dreese Labs 493
• 292-2565
• TR 1030-1118, and 330-418
• bair.41_at_osu.edu
• www.cis.ohio-state.edu/bbair
• TR 130 -318 pm DL 113
• Baker Engineering Systems 310

Lab Day/Time Lab Instructor Office Phone Email
Fri 130-318pm Vishvesh Sahasrabudhe BO 118 2-8377 sahasrav_at_cis.ohio-state.edu
Thurs 330-518pm Tsviatko Yovtchev CL 414 8-4460 yovtchev_at_cis.ohio-state.edu
CIS 200 - Introduction
3
CIS 200 Course Administration
Course Coordinator Debby Gross
Lab Consultant Coordinator Steve Cardoza
Lecturers Bettina Bair Sandy Farrar Debby
Gross Michelle Mallon Kitty Reeves Ron Salyers
Lab Instructors In charge of lab section
Lab Consultant Grades labs - 4 per lab
Any section changes or adds must be made through
the course coordinator . Request forms must be
filled out in DL 489 on the first Wednesday of
the quarter from 9am - 3pm.
CIS 200 - Introduction
4
Topics of Discussion

• Course description
• Syllabus
• Required texts
• Policies
• Expectations

CIS 200 - Introduction
5
Course Description

• This course is an intensive introduction to
  business applications of computers. The main
  focus of the course is on the use spreadsheets
  and databases to help solve problems.
• The overall objective of the course is to prepare
  students to be able to learn the features of
  various business software tools and apply these
  tools in efficiently and effectively solving
  problems.

CIS 200 - Introduction
6
Course Description

• The types of software applications that will be
  covered include
• Communication Netscape
• Spreadsheets - MS Excel 2002
• Presentation Graphics - MS PowerPoint 2002
• Databases - MS Access 2002
• Prerequisites Math 116, Math 130 or Math 148
• If you do not have the prerequisites please see
  your lecturer

7
Syllabus A brief overview

• Basic computer science concepts, Windows
  Operating System, Internet E-mail, WWW
• Using Spreadsheets to Solve Problems
• Spreadsheet basics formulas functions
• Boolean Logic
• Reference Financial Functions
• Presentation Graphics
• Midterm Exam
• Databases
• Relational database theory
• Database basics using tables queries
• Inner Outer Joins
• Internet topics
• Final Exam

CIS 200 - Introduction
8
Required texts

• CIS 200 course notes for the current quarter
• Required - Available from COP-EZ (Tuttle Garage)
• Text
• Shelly Cashman Series (4 books) CIS200 Intro
  book, MS Excel, MS PowerPoint, MS Access

CIS 200 - Introduction
9
Policies Grading

• Lab assignments - 20 (200 points)
• - You must complete the labs 5 9 to pass
  the course
• Quizzes - 20 (200 points)
• - Six 40 point quizzes the lowest grade will
  be dropped
• Midterm - 25 (250 points)
• Final Exam - 35 (350 points)
• - The final exam is cumulative. A passing grade
  is required on the final to pass the course

CIS 200 - Introduction
10
Policies Labs

• Each week Pre-Lab and In-lab Assignments are due
  by the end of lab class
• Lab 1 in-lab Is in your course notes please
  read over before class.
• Labs 2-10 have a pre-lab assignment and an in-lab
  assignment
• Pre-lab - Must be completed prior to that
  weeks lab and files submitted during in-lab.
  If you work at home/office all files must be
  successfully transmitted to our labs prior to the
  lab session!
• In Lab This assignment will be given out in
  lab. You have only that lab session to complete
  and submit it.
• You must attend lab to receive credit for the lab
  assignment. No credit will be given for late
  assignments. Contact your lab instructor
  regarding emergencies and/or attendance issues.
• Labs will normally be returned the following
  week. Grade discrepancies should be discussed
  with the lab instructor within a week of
  distribution.

CIS 200 - Introduction
11
Policies Homework

• Homeworks will be assigned by the lecturer
• Designed to prepare you for labs, quizzes exams
• They will not be graded but we highly recommend
  you complete the assignments
• Complete homeworks will be discussed in lecture
• Answer Keys are available on the web
• Username and password wi04

CIS 200 - Introduction
12
Policies Make-ups

• It is the policy of this course that no make-ups
  will be allowed for labs, quizzes or exams. It is
  your responsibility to know when assignments are
  due and when the exams will be given. In some
  cases exceptions for extraordinary circumstances
  may be made
• Contact your Lecturer for all matters pertaining
  to exams and homework. Contact your Lab
  Instructor in all matters pertaining to labs.
• Notification must be made and confirmed prior to
  the assignment due date by e-mail, phone or in
  person.
• In a case where you are unable to notify the
  proper person (ex. documented medical emergency),
  notification must be made as soon as possible

13
Policies Academic Misconduct

• In accordance with Faculty Rule 3335-5-487
  Academic misconduct includes, but is not limited
  to, giving or receiving information during an
  exam and submitting plagiarized work for academic
  requirements.
•  
• Students are required to do their own
  assignments.
• Submitted materials (lab files) must be entirely
  your own work.
• Your instructor reserves the right to ask you to
  explain your approach to the problem, the
  equations used, etc. Your response may affect
  your grade on the lab or homework in question.

14
Expectations

• Attendance at Lectures and labs
• Come prepared to Lecture by
• bring the class notes
• completing the assigned problems and homework
• Come prepared to Lab by
• Completing the pre-lab assignment before class
• bringing class notes and textbook(if needed) to
  lab
• All graded assignments to be completed
  individually
• Read your e-mail
• Read class discussion groups and/or Lecturers
  announcements

CIS 200 - Introduction
15
Frequently asked questions

• Can I change my section ?
• See course coordinator 1st Wednesday
• 9am-3pm DL 489
• Can I work on labs from home?
• Yes instructions are given in lab 1 but you
  must have a compatible version of software an be
  able to email all completed files
• Required files will be available from the
  internet
• When are the exams ?
• Quizzes as announced throughout the quarter
• Midterm 6th week
• Final during finals week unless otherwise
  specified. Refer to your Lecturers syllabus.

CIS 200 - Introduction
16
Frequently asked questions

• Who do I contact if I have a problem with grading
  of labs or midterms ?
• Midterms see lecturer, labs see your lab
  instructor
• Who do I contact if I have an emergency?
• Labs - contact lab instructor, exams contact
  lecturer
• Notification must be made prior to a deadline
• Documentation will be required

CIS 200 - Introduction
17
All about Me

• Bettina Bair
• Faculty Lecturer, Ohio State University
• Internet HTML
• Spreadsheets (Microsoft Excel)
• Databases (Microsoft Access)
• Assembly Language Computer Systems
• Systems Analysis

25 years of interesting problems
18
122 Years of Amazing Computers
Sherman set the WayBack Machine to the year
1890
19
1890 The First Computer

• Hollerith Tabulating System
• Census Counter
• Hollerith's Business Joined A Firm That Later
  Became IBM.

20
1945 The First Modern Computer

• ENIAC
• Electrical Numerical Integrator And Computer
• Built To Compute Ballistics Tables During World
  War II.
• 1,000 Times Faster Than Any Existing Device.
• Cost About 400,000

21
1947 The First Computer Bug

• Dead Moth Found In A Computer 
• Causes malfunction
• Engineers taped into their notebook 
• "Bug" And "Debug" Now A Standard Part Of The
  Language

22
1953 The first compiler

• Invented by Grace Hopper (1906-1992)
• Translates English Language Instructions Into
  Language Of The Target Computer
• Led To The Development Of Cobol.

23
1978 My First Computer Class

• Programming Language FORTRAN
• Punched Cards

24
1979 My First PC

• Vic-20
• 1.0227 Mhz
• 3.5kb RAM
• Tape Drive

Todays computers 2 Ghz and up to 64 Mb RAM
25
1980 First Computer Job

• Interactive Graphics Engineering Laboratory
• University of Arizona
• Finite Element Analysis for Aerospace

There was no such thing as a mouse, screen icon,
or GUI.
26
1984 Second Computer Job

• Arizona Criminal Intelligence System Agency
• Database Analysis
• Organized Crime
• Chop Shop

A gigabyte of disk storage took a 8' tower of
Winchester disk drives stacked floor to ceiling.
27
1984- 1986 Lots of Lines of Code

• Hughes Aircraft
• Improve efficiency of large scale IBM systems
• Integrate new graphics technology

The computer operators didn't trust any data that
wasnt on punched cards (because it wasnt real)
28
1984 Macintosh

• Revolutionary Graphical User Interface (GUI).
• A Device Called A Mouse
• Pictorial Symbols (Icons) On The Screen.
• Select Commands, Call Up Files, Start Programs,
  Etc.
• Original Selling Price 2,495

29
1987 Signal Processing

• Cranfield-Phoenix Data Systems
• Filtering and Conditioning
• Signal Analysis

30
1988-1996 New Technologies Create New
Opportunities

• U S WEST
• Telecommunications
• Installation and Repair of telephone cables,
  switches, radio towers

Using Excel a lot now
31
1994-1999 Internet

• from User to Builder
• VONBAR Enterprises
• Designing Websites for Small Businesses

HTML Writers Guild International Directory of
Women Web Designers Top 5 Web Designers- EG Web
Top Vendor award-  Mall park
32
1998- 2003 The Return to the First Computer Class
Computers are cool.
33
Test Your Knowledge

• How much do you know about computer basics?

34
Would increasing RAM

1. make your word processor run faster?
2. Allow you to run bigger applications?
3. Let you keep more programs open?
4. Give you more space for MP3s and pictures?
5. Download web pages faster?

35
Would increasing the speed of your CPU?

1. make your word processor run faster?
2. Allow you to run bigger applications?
3. Let you keep more programs open?
4. Give you more space for MP3s and pictures?
5. Download web pages faster?

36
What would give you more space for MP3s and
pictures?

1. A faster modem
2. A bigger hard drive
3. More RAM
4. A faster processor

37
What would help you download web pages faster?

1. A faster modem
2. A bigger hard drive
3. More RAM
4. A faster processor

38
How much storage is enough?

• How many bytes are needed to store your first
  name?
• How many times could you store your first name
• In a kilobyte?
• On a 1.44MB floppy?
• How big is a
• Typical picture?
• Sound file?

39
What kind of computer do you have?

• What speed is the processor?
• How big is the hard disk drive?
• How big is the RAM?
• How fast is the modem?
• Price?