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

 

Textbooks

 

Bundle ISBN# 0324821263

 

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

 

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.