|
HU Credits:
3
Degree/Cycle:
1st degree (Bachelor)
Responsible Department:
Social Sciences - Special Program
Semester:
1st and/or 2nd Semester
Teaching Languages:
Hebrew
Campus:
Mt. Scopus
Course/Module Coordinator:
Hilla Moshieff
Coordinator Office Hours:
Sundays 8:30
Teaching Staff:
Ms. Hila Moshieff
Course/Module description:
The course teaches how to write code in VBA for Excel. VBA is a programming language hosted in various applications, including Excel. It provides tools that enables the programmer, to extend the capabilities of Excel and enables the automation of operations in Excel
Course/Module aims:
Manipulating Excel using VBA programming by controlling the objects that comprise Excel.
Learning outcomes - On successful completion of this module, students should be able to:
Write Excel macros and functions and run them in different ways.
Have knowledge in:
basics of programming,
event-driven programming,
objects, attributes and methods and the concept of object-oriented programming.
Attendance requirements(%):
None
Teaching arrangement and method of instruction:
Lectures will be conducted in the computer farms, examples will be displayed and students will be able to experiment with writing small programs.
An exercise will be given every week. At least 8 of the given exercises must be submitted in order to be eligible for a course grade.
Course/Module Content:
Writing and running Functions and Macros.
• Types of variables and how they are defined
• Assigning values to variables
• Flow of control:
Conditions - IF and SELECT
Loops - For-Next, Do-Loop, For-Each
• Objects, properties and methods
• Recording Macros
• Debugging
• Procedural programming and event-driven programming
• Creating forms with controls
• Working with Files
• Error handling
Required Reading:
None
Additional Reading Material:
Course book - VBA For Excel written by Hilla Moshieff-Cahana Published by The Academon
Course/Module evaluation:
End of year written/oral examination 100 %
Presentation 0 %
Participation in Tutorials 0 %
Project work 0 %
Assignments 0 %
Reports 0 %
Research project 0 %
Quizzes 0 %
Other 0 %
Additional information:
The final grade will be determined by the student's test score at the end of the course. To take the test, the students must submit, on time, at least 8 of the exercises that will be given during the course
|
