CSE200 COURSE INFORMATION
|
Grades |
Contact Information:
Office:
Dreese Labs 250
Phone:
(614) 292-5236
Email address: krishnasamy.1@osu.edu
Instructor Website: www.cse.ohio-state.edu/~samy
Carmen link: http://carmen.osu.edu
Office Hours:
Monday & Wednesday 4:30-5:30pm, by appointment, or email.
Required Texts:
Course
Objectives:
The course objective
is to familiarize students with the breadth of business software applications
and to provide a working knowledge of spreadsheets and databases. We
emphasize using these tools to solve problems. It is our goal that students will feel
comfortable enough on computers that they will be able to open up an unfamiliar
business application and begin learning it on their own, applying these tools
to solve problems efficiently and effectively. The specific objectives are as
follows:
·
Understanding
computer basics - hardware, operating systems & communications (1 lecture)
·
Understanding
the Ethical principles regarding the use of technology (throughout)
·
Effectively
use spreadsheets to solve problems (5½
weeks)
o Designing spreadsheets so they can be
efficiently written and updated including use of relative/absolute cell
addressing, & multiple worksheets in a workbook.
o Using functions and understanding
syntax/algorithms including SUM, COUNT, MIN, MAX, AVERAGE, COUNTIF, SUMIF,
ROUND, LARGE, SMALL, RANK
o Using Relational operators and Boolean
Logical functions (AND, OR, NOT, IF functions)
o Using reference functions – (VLOOKUP,
HLOOKUP)
o Using financial functions (PV, FV,
NPER, RATE, PMT)
o Selecting and using appropriate charts
to display data
o Using spreadsheet data features for
filtering, sorting
o Using Pivot Tables
·
Effectively
use presentation graphics software (1
lecture)
o Creating slides
o Using the Master Layout View
o Creating speaker notes and handouts
o Using animation and transition effects
in presentation
o Using the MS Office drawing tools
o Using the MS Office object linking and
embedding tools
·
Effectively
use database management software to solve problems (3 weeks)
o Understand the concepts of relational
database management system (DBMS) – primary key, foreign key etc.
o Be able to design simple tables –
fields & field properties
o Be able to relate tables - foreign
keys, referential data integrity rules.
o Effectively use the query tool to
find/organize information including sorting, filtering on multiple criteria,
grouping and aggregating data, performing calculations. Using inner & outer
joins to extract data from multiple tables/existing queries objects. Solving
problems requiring data from tables with many-to-many relationships.
·
Understanding
how the Internet works and basic principles of Networking & Building your own Web page (1 lecture)
Grading Policy:
|
Lab
Assignments (10) |
20% |
200 points |
Pop quizzes (best 4 out of 5)
|
20% |
200 points |
|
Midterm |
25% |
250 points |
|
Final Exam |
35% |
350 points |
**The percentage breakdowns are used
as a guide for determining grades. Final grades are at the discretion of the
lecturer. You must pass the final exam and complete labs 5 & 9 in a
satisfactory manner in order to pass the course.
Labs:
Labs contain two parts – a Pre-lab and an In-lab assignment. The
pre-lab assignments can be found in the lab section of your course notes. You may start on them at any time. The pre-lab lab files are available on Carmen
– click on the Content menu and then the Pre-labs link. The Pre-lab assignment for a specific week is
due during that week’s closed lab session.
When you arrive for your closed lab class, the TA will distribute your In-lab assignment.
This will usually consist of one or more problems that apply the skills
learned in lecture and during the Pre-lab.
You will have only 1 hour 48 minutes to complete the in-lab assignment,
so come prepared and make sure you have all the materials (texts, notes etc) as
indicated in the Pre-lab write-up.
To receive credit the lab assignment you must attend lab and submit your
files by the end of the class period.
When labs are submitted a date/time stamp is given. No credit will be given for late labs. Labs 5 and 9 must be submitted to pass the
course, if you fail to do so – please contact your Lab Instructor.
Homework:
Homework will
be assigned but will not be collected.
They are for your benefit to complete.
Answers will be provided online (In Carmen click on Content then link to
‘Practice Problems and Solutions’ – problem files and solution organized by
topic.)
Pop
Quizzes:
There will be a series of 5 pop quizzes given during the quarter. Approximate dates are
listed on the syllabus. The dates of each pop quiz will be confirmed in the
lecture before the quiz is to be given.
Each quiz is worth 50 points and the best 4 out of 5 quizzes will be
counted for a maximum point score of 200.
Exams:
Approximate dates of
the midterm and final are listed on the syllabus schedule which is found on
this web site (http://www.cse.ohio-state.edu/~samy/CSE200/). Any
changes of exam dates will be announced in class – at least one week
prior to the exam. Such changes will
also be posted on the web site (http://www.cse.ohio-state.edu/~samy/CSE200/)
under ‘Announcements’.
Make-up
Policy:
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. The only
exceptions for extraordinary circumstances are described below. Make-ups will not be given to students who
miss assignments due to “over sleeping” or “not knowing of the assignment”.
Extraordinary
Circumstances:
At times
there are extraordinary circumstances that may require a make-up of an
assignment or exam. The appropriate
person will handle these on a case by case basis. Contact your lecturer for all
matters pertaining to exams and quizzes.
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. Leaving a voice mail, or e-mail
is not enough. You must have confirmation by the appropriate person to be
considered for a make-up.
·
In
a case where a person is unable to notify the proper person (ex. documented
medical emergency), notification must be made as soon as possible.
Fairness
to Students:
We strive to treat
students with dignity and fairness and to be particularly sensitive to the
diversity that exists within the student body. Students with disabilities who
request help will be given reasonable accommodation with the assistance of the
University Office of Disability Services (292 - 3307)
Academic
Misconduct:
In
accordance with Faculty Rule 3335-31-02, all instances of alleged academic
misconduct will be reported to the Department Chairperson and the Committee on
Academic Misconduct (COAM). Alleged
misconduct cases will be resolved via COAM’s hearing processes as described in
the University’s Code of Student Conduct.
Instructors, lab consultants and graders will not make an evaluation of
the facts of the case, either towards guilt or innocence.
As
defined in the University’s Code of Student Conduct, academic misconduct is any
activity which tends to compromise the academic integrity of the institution or
subvert the educational process.
Students who violate the University’s policies regarding academic
misconduct are stealing academic credit and skewing the grading process against
students who are honestly participating in the course. Their actions diminish
the value of an academic degree when they falsely represent themselves as
competent in a subject matter in the workplace.
Academic
misconduct includes, but is not limited to, giving or receiving information or
assistance during an exam or submission of plagiarized work for academic
requirements. It also includes changing graded material and turning it back in
to be re-graded for a higher score.
While
we encourage students to learn from each other, each student’s submitted
work must be entirely their own. We
encourage high level discussions of assignments. However, specific discussion of a formula
solution is not appropriate. Examples
of appropriate and inappropriate types of assistance are listed below:
Examples of appropriate
assistance are as follows:
·
Students
working together on non-graded examples similar to those of the assigned
materials. Non-graded examples are
provided both in written and electronic format for use by students.
·
Studying
in groups to learn problem solving techniques and function
syntax using non-graded materials provided in the course text and notes.
·
Creating
study guides for purposes of learning the materials in preparation for exams
and quizzes.
·
Getting
assistance from a course staff member (Lecturers, TA’s, Lab
Consultants). Staff members are trained
to help students learn concepts so students can then successfully apply these
concepts in the completion of their own assignments. Appropriate assistance from course staff
members may take either of the following forms:
o A student asks for assistance for an
un-attempted problem or a problem they do not understand how to approach. The student should be shown how to do a
similar problem and/or directed to specific materials in the course text. Students and staff may also work through a
high level strategy of how to go about solving the problem.
§
Appropriate:
“You need to add all of the values that meet a specific criteria and the divide
them by the number of items that meet this criteria”
§
Inappropriate:
“Use the formula =SUMIF(B2:B10, TRUE)/COUNTIF(B2:B20, TRUE)”
o A student asks for assistance with a
mostly completed assignment. The staff
member may identify an error and provide appropriate assistance.
§
Appropriate: “The absolute referencing in the formula is
incorrect, the price of widgets doesn’t change when copied down the column”
§
Inappropriate: “Add a $ in front of the 2 so the answer is
B$2*C3.”
Additional
examples of inappropriate assistance are as follows:
·
Having
another person complete any part of a graded assignment and misrepresenting it as
your own work or having another person take an exam or quiz for you.
·
Copying
any portion of a graded assignment or exam, either written or electronic, even
if this is later modified. This includes
work/files from both current and past quarters, even if you are re-taking the
course and it was your own work. Files
may only be copied from the course websites and/or directories as specifically
directed in an assignment.
·
Giving or receiving an answer to a
portion of a graded assignment including graded homework, labs, quizzes or
exams.
·
Helping
another student with their homework or lab as they follow along from your
completed or partially completed work.
·
Working
together on a graded assignment. High
level discussions of problem strategies are allowed, but be advised that near
duplicate assignments will be considered suspect unless the assignment was
restrictive enough to justify such similarities in independent work.
If a student
has any questions about what is or is not permissible, he/she should read carefully
the course syllabus and/or ask the course instructor for guidance. Ignorance of the course policies or
University’s Code of Student Conduct is never an excuse for academic
misconduct.