Computer Assisted Problem Solving for Business – CSE200

Instructor: Nicoleta Roman

Office: Galvin Hall 460E   Phone: 419-995-8224

Email address: roman.45@osu.edu

Instructor Website: lima.osu.edu/people/nroman

 

Description

Solving business related problems using and integrating productivity software tools. Emphasis on designing spreadsheet solutions to solve problems and using database queries to extract information.

 

The course is worth 5 credits.

 

Prerequisites

Math 116, 130, or 148

Not open to students who have credit for CSE 101

 

Course Objectives

• Be familiar with computer basics - hardware, software, OS, and communications.
• Master solving problems using simple spreadsheet formulas, functions and relative/absolute cell referencing.
• Be familiar with using Boolean logical functions and constructions - AND, OR, NOT, none-of and only constructs, IF's and nested IF's - in a spreadsheet.
• Be familiar with using reference functions (VLookup, HLookup) in a spreadsheet.
• Be familiar with using financial functions (FV,PV,RATE,PMT,NPER) in a spreadsheet.
• Be familiar with relational databases and database tables.
• Be familiar with querying a database using Access QBE grids to select/filter records, sort, aggregate fields, calculate fields.
• Be familiar with querying a database with multiple tables using inner and outer joins.
• Be familiar with how the internet works, protocol layers, and a setting up a simple webpage.

 

Textbooks

 

Bundle ISBN# 0324821263

•     Microsoft Office 2007: Introductory Concepts and Techniques, Windows XP Edition by Shelly/Cashman

•     Succeeding in Business with MS Excel 2007

 

Topics

 

Number of Hours	Topic
2	Computer basics
5	Spreadsheet basics - formulas, functions, cell addressing
5	Boolean logic functions
2	Solving more complex problems including unit conversions and multiple worksheet solutions
3	Using financial functions
3	Using reference functions
2	Introduction to relational databases and database tables
4	Simple queries
3	Using queries with inner joins
3	Solving problems requiring multiple queries and outer joins
1	Database features of Excel
3	Internet topics - protocols and setting up a webpage
2	Using MS PowerPoint; object linking

 

 

Representative Lab Assignments

• Lab 1 - Logging on the system, using e-mail and web browsers
• Lab 2- Writing formulas in Excel - relative/absolute cell referencing and simple functions
• Lab 3 - Relational operators and Boolean logical functions
• Lab 4 - Using multiple worksheets in a workbook, solving problems with units
• Lab 5 - Solving large problems - spreadsheet design, reference functions, financial functions
• Lab 6 - PowerPoint
• Lab 7 - Using MS Access tables and simple queries
• Lab 8 - Writing queries with joins
• Lab 9 - Project integration
• Lab 10 - Creating a simple webpage

 

Grading Plan 

 

Lab Assignments (10)	25%
Pop quizzes (best 4 out of 5) / Homeworks	20%
Midterm	25%
Final Exam	30%

 

**The percentage breakdowns are used as a guide for determining grades. Tentatively, the grading scale is: A 93%, A- 90%, B+ 87%, B 83%, B- 80%, C+ 77%, C 73%, C- 70%, D+ 67%, D 63%. However, you must pass the final exam and complete lab 5 and lab 9 in a satisfactory manner in order to pass the course.