Title: Computer and Information Science 200 Computer Assisted Problem Solving for Business
1Computer and Information Science 200Computer
Assisted Problem Solving for Business
1
CIS 200 - Introduction
2CIS200 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
3CIS 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
4Topics of Discussion
- Course description
- Syllabus
- Required texts
- Policies
- Expectations
CIS 200 - Introduction
5Course 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
6Course 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
7Syllabus 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
8Required 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
9Policies 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
10Policies 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
11Policies 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
12Policies 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
13Policies 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.
14Expectations
- 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
15Frequently 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
16Frequently 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
17All 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
18122 Years of Amazing Computers
Sherman set the WayBack Machine to the year
1890
191890 The First Computer
- Hollerith Tabulating System
- Census Counter
- Hollerith's Business Joined A Firm That Later
Became IBM.
201945 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
211947 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
221953 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.
231978 My First Computer Class
- Programming Language FORTRAN
- Punched Cards
241979 My First PC
- Vic-20
- 1.0227 Mhz
- 3.5kb RAM
- Tape Drive
Todays computers 2 Ghz and up to 64 Mb RAM
251980 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.
261984 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.
271984- 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)
281984 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
291987 Signal Processing
- Cranfield-Phoenix Data Systems
- Filtering and Conditioning
- Signal Analysis
301988-1996 New Technologies Create New
Opportunities
- U S WEST
- Telecommunications
- Installation and Repair of telephone cables,
switches, radio towers
Using Excel a lot now
311994-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
321998- 2003 The Return to the First Computer Class
Computers are cool.
33Test Your Knowledge
- How much do you know about computer basics?
34Would increasing RAM
- make your word processor run faster?
- Allow you to run bigger applications?
- Let you keep more programs open?
- Give you more space for MP3s and pictures?
- Download web pages faster?
35Would increasing the speed of your CPU?
- make your word processor run faster?
- Allow you to run bigger applications?
- Let you keep more programs open?
- Give you more space for MP3s and pictures?
- Download web pages faster?
36What would give you more space for MP3s and
pictures?
- A faster modem
- A bigger hard drive
- More RAM
- A faster processor
37What would help you download web pages faster?
- A faster modem
- A bigger hard drive
- More RAM
- A faster processor
38How 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?
39What 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?