|
HU Credits:
2
Degree/Cycle:
1st degree (Bachelor)
Responsible Department:
Business Administration
Semester:
2nd Semester
Teaching Languages:
Hebrew
Campus:
Mt. Scopus
Course/Module Coordinator:
Mr. Elad Prager
Coordinator Office Hours:
flexible
Teaching Staff:
Mr. elad parger
Course/Module description:
Introduction by case studies to DB and Excel as a powerful tool for business management, Business Modelling , data management, data processing and decision making process
Course/Module aims:
introduction to DB, Business Modelling and electronic spreadsheets by Case studies in order to
acquire basic and advanced tools used in order to: collect, manage and analyze data, sorting, calculating, filtering, and reporting data and for the decision making process.
Learning outcomes - On successful completion of this module, students should be able to:
The students will acquire theoretical and practical knowledge and skills in building DB (keys and relationships),Business Modelling with Excel, addressing , management, economic and business tasks via Excel. The students will be introduced to most of the programs` features and will be qualified to write and fix basic and advanced Excel functions and formulas. The students will be able to build models, diagnose Excel errors, use Nested Functions, timely updated functions, managing text, splitting data..
Mathematical, statistical, financial, text, date and time, logical function, statistical analysis, array formulas.
Editing, recording, sorting, filtering and formatting tools, including special copy/paste, data verification, conditional formatting.
Producing advanced and dynamic reports and views including sensitivity tables, pivot tables and charts, all chart tools and spark lines, Solver ,goal seek etc
Attendance requirements(%):
80%
Teaching arrangement and method of instruction:
Lectures in Class/in Zoom
Assignments
Final exam
Course/Module Content:
Relational and fixed references
Keyboard shortcut
Logical functions and conditions – if, and , or, nested functions.
Mathematical functions
Statistical functions
Financial functions
Conditional Formatting
Vlookup / Hlookup
Advanced and basic data filtering
Sort
Database Functions (countifs, sumifs etc.)
Pivot Table
Charts, spark lines
Print preview
Sensitivity tables
Goal seek
SOLVER
Required Reading:
Syllabus and all files are located at the moodle course site
Additional Reading Material:
MIS Cases - Decision Making with Application Software 4th Edition by M. Lisa Miller (2008). Prentice Hall.
Management Science: The Art of Modeling with Spreadsheets, 4th Edition ,Stephen G. Powell, Kenneth R. Baker (2013). Wiley.
Course/Module evaluation:
End of year written/oral examination 80 %
Presentation 0 %
Participation in Tutorials 0 %
Project work 0 %
Assignments 20 %
Reports 0 %
Research project 0 %
Quizzes 0 %
Other 0 %
Additional information:
|
