|
HU Credits:
3
Degree/Cycle:
1st degree (Bachelor)
Responsible Department:
Environmental Economics & Management
Semester:
1st Semester
Teaching Languages:
Hebrew
Campus:
Rehovot
Course/Module Coordinator:
Prof Nava Haruvy
Coordinator Office Hours:
By appointment
Teaching Staff:
Mr. yehuda slater
Course/Module description:
This course will teach decision-making in the fields of management, research and performance using Excel spreadsheet.
The course will be accompanied by exercises that will form part of the final work. At the beginning of the course the student will choose a managerial subject for the final work based on databases, that will be analyzed using introduced methods and tools.
Course/Module aims:
Decision-making in the fields of management, research and performance using Excel spreadsheet.
Learning outcomes - On successful completion of this module, students should be able to:
At the end of this course, students will be able to analyze databases by using methods and tools introduced in the course,implemented in the fields of management, economic, research and performance.
Attendance requirements(%):
There is no mandatory attendance, but the presence is essentialõ
for success in the course.
there wull be random questions in lecture, each contributing 5 points to final score, total 5 points.
Classroom instruction will be given and explanations that are not on the site.
There are no mandatory attendance, but the presence is essential for success in the course.
Classroom instruction will be given and explanations that are not on the site.
There are no mandatory attendance, but the presence is essential for success in the course.
Classroom instruction will be given and explanations that are not on the site.
There is no mandatory attendance, but the presence is essential for success in the course.
Teaching arrangement and method of instruction:
Synchronic or Frontal lectures according to instructions, exercises that are part of the final work. The exam will be given in writing.
Classroom lectures, exercises that are part of the final work. The exam will be written.
Classroom lectures, exercises that are part of the final work. The exam will be written.
Classroom lectures, exercises that are part of the final work. The exam will be taken in classroom.
Course/Module Content:
1. Introduction to information systems and Excel software.
2. Basic formatting rules; Functions that support business management-statistical and mathematical.
3. business management using computer applications, fixed and relative copying,names of variables, linking sheets.
4. Functions supporting business management-logical functions.
5. functions of references and information- VLOOKUP and others, perception of time in business analysis.
6. Advanced formatting, goal seek, array functions- FREQUENCY etc.
7. Managing business databases, Working with databases: saving, storing, filtering.
8. Working with databases-advanced filtering, database functions.
9. Working with databases-continued: function DGET, subtotals, pivot tables.
10. Working with automatic actions "macro"-using a form, an explanation and example; Actions for databases.
11. General guidance for final work- managerial subject.
12. Functions supporting business management- statistical,text, date and time, information.
13. individual guidance to final work.
14. Additional functions.
Required Reading:
None
Additional Reading Material:
Various materials for studying Excel
Grading Scheme :
Additional information:
There is obligation to submit exercises, which are part of the final work.
Excercises are prepared in pairs. They are submitted to the course site by each of the students.
Passing grade on the exam is required to pass the course.
There is a apossibility of adding points to score by random questions at class, each 1 point, total till 5 points.
|
close