Instructor: Nicoleta Roman
Office: Galvin Hall 460E Phone: 4199958224
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
Textbooks
Bundle ISBN# 0324821263
Microsoft Office 2007: Introductory Concepts and Techniques, Windows XP Edition by Shelly/Cashman
Succeeding in Business with MS Excel 2007
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 
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.