Welcome to NKU’s Syllabus Template

Course Number and Section(s)
INF 110-(001)

Room Number: online course

 Time and day:
online course (1^st 7 weeks)

Course Name
Introduction to Application Development

Semester and Year
Spring 2019

Course Description:
An Introduction to Application Development for majors outside the informatics fields. The course will involve strategies, techniques, and tools for professional programming in a business environment; problem definition, software design, program design, and system implementation; development of systems of programs to implement common business applications.

Prerequisites:
None

Our Vision

The College of Informatics seeks to enrich the lives of its students and help transform its communities.  

Our Mission

The mission of the College of Informatics is to create a community of learners and scholars especially prepared to meet the fast-paced integrative changes in the fields of computing, business informatics, and communication.  Through its curriculum, research, and outreach programs, the College of Informatics represents a creative, analytic, and technical response to an economy driven by innovation and convergence, and will play a leadership role in the transition to a new economy in the Northern Kentucky region.

We will leverage the partnerships between students, faculty and the community to continuously improve the educational experience of our students and to enhance the integration of scholarship and service to classroom learning.  

.

Table of Contents

 TOC \o "1-3" \h \z \u Welcome to NKU’s Syllabus Template. PAGEREF _Toc521276798 \h 1

Course Number and Section(s). PAGEREF _Toc521276799 \h 1

Course Name. PAGEREF _Toc521276800 \h 1

Semester and Year. PAGEREF _Toc521276801 \h 1

Course Description: PAGEREF _Toc521276802 \h 1

Prerequisites: PAGEREF _Toc521276803 \h 2

Student Learning Outcomes PAGEREF _Toc521276804 \h 4

Required Materials PAGEREF _Toc521276805 \h 4

Course Assignments PAGEREF _Toc521276806 \h 4

Course Grading. PAGEREF _Toc521276807 \h 5

Grading Feedback. PAGEREF _Toc521276808 \h 5

Mid-Term Grade. PAGEREF _Toc521276809 \h 6

Grade Appeal PAGEREF _Toc521276810 \h 6

Grading Scale. PAGEREF _Toc521276811 \h 7

Final Exam Information. PAGEREF _Toc521276812 \h 7

Student Evaluation of Instructor and Course. PAGEREF _Toc521276813 \h 7

Course Policies PAGEREF _Toc521276814 \h 8

Submission of Assignments: PAGEREF _Toc521276815 \h 8

Attendance Policy: PAGEREF _Toc521276816 \h 9

Non-Attendance Policy. PAGEREF _Toc521276817 \h 9

Non-Attendance Policy (Required -. PAGEREF _Toc521276818 \h Error! Bookmark not defined.

Classroom Behavior Policies: PAGEREF _Toc521276819 \h 9

Student Honor Code. PAGEREF _Toc521276820 \h 9

Accommodations Due to Disability. PAGEREF _Toc521276821 \h 9

Credit Hour Policy Statement PAGEREF _Toc521276822 \h 10

Diversity. PAGEREF _Toc521276823 \h 10

Allied Zone. PAGEREF _Toc521276824 \h 10

Name / Pronoun. PAGEREF _Toc521276825 \h 10

Tentative Course Schedule. PAGEREF _Toc521276826 \h 11

Other Information. PAGEREF _Toc521276827 \h 11

For Foundation of Knowledge (Gen Ed) courses, PAGEREF _Toc521276828 \h Error! Bookmark not defined.

Student Learning Outcomes

Assurance of Learning: The College of Informatics has established learning outcomes for all its majors.

This course, Business Programming, is designed to meet the objectives that all Informatics students graduate with a demonstrated understanding of:  

·        Demonstrate strong analytical skills and technological expertise in developing programs
·        Apply theoretical Business Informatics concepts in real world settings
·        Evaluate and adopt new technology 

These goals will be measured by the two multiple choice tests.

This course, Introduction to Application Development INF 110, is designed to address the active learning goal of the QEP by the students completing the 10 programming assignments.

II. COURSE OBJECTIVES:

This course is intended as an introductory course on creating programs using Visual Basic for Applications.  The objectives of this course are: to teach the fundamentals of developing programs using VBA; to acquaint students with programming guidelines; to show students how to create programs suitable for course work, professional purposes, and personal use; to expose students to common programming practices and functions; to promote curiosity and independent exploration of programming resources; to develop an exercise-oriented approach that allows students to learn by example; to encourage independent study and help those who are learning how to create programs in a distance education environment. This course provides an introduction to programming in VBA with Excel and Access. Topics include an introduction to the VBA IDE environment; procedures and conditions; loops and arrays; object model in Excel and Access; user forms and additional controls; testing, debugging, and error handling; input validation and file processing. The course also provides introductory coverage of the Microsoft Office 2016 software. (Note: older versions of software can be used 2013, 2010, 2007. 2003, and XP.)

III. COURSE FORMAT:

Online format includes reading the textbooks, studying the PowerPoints, watching the online lectures and videos demonstrating the topics covered in class, using the web site materials to learn flowcharting and how to write the programs will be the primary format.

Required Materials

Microsoft Excel VBA Programming Third Edition for the absolute beginner
by Duane Birnbaum (Author), Michael Vine (Author)
ISBN 13: 978-1-59863-394-8  
ISBN 10: 1-59863-394-5

Microsoft Access VBA Programming Third Edition for the absolute beginner
by Michael Vine (Author)
ISBN 13: 978-1-59863-393-1  
ISBN 10: 1-59863-393-7

Recommended Text:

Excel 2007 VBA programming for Dummies
Author: John Walkenbach
ISBN: 978-0-470-04674-6 

Course Assignments

Computer assignments include two primary areas:

1) In-Chapter Work: these are the code snippets found in each chapter of the two books; for every In-Chapter assignment spreadsheet that is missing 1 point will be deducted. The In-Chapter work will be done in class.
     This is worth 100 points of the final grade, so class attendance is mandatory. In-Chapter projects must be turned in using the drop box in Canvas together with the challenges found at the end of each chapter.
2) Exercises assignments in the Excel and Access texts at the end of each chapter; these are worth 200 points of the final grade.

These Exercises will be judged on their correctness, neatness, and how well they satisfy the requirements of the assignment. One point will be deducted for each day of the week an Exercise is late. No Exercise will be accepted after 1 week of the scheduled due date. Be sure to turn in the required Flowcharts or Structure Charts for the challenges,

Course Grading
GRADING INFORMATION: 

Your instructor is responsible for the grading of all quizzes, exams, paper, and projects and the assessment and assignment of final grades. The course grade is determined by a mix of homework, exams, and projects to demonstrate competency in the subject matter. Your semester final grade will be made up of the following measurements and corresponding point allocations: 

•       2 Exams (Exam#1 and Exam#2) @ 100 pts ea. = 200 pts

•       In-Chapter work and Homework  = 300 pts

•       Total Points Possible = 500 pts

•       Bonus Assignments - Optional bonus assignments may be made available.

Grading Feedback

Students should expect feedback on assignments within (1 week) of submission except when faculty provides notification via announcement of a different timeline.

Mid-Term Grade  

Midterm grades will be provided to all students in 100 - 400 level courses, except in cases where the Department Chair and Dean have waived midterm grade reporting for pedagogical reasons. Midterm grades are only an estimate of performance as of the middle of the semester and are not an absolute predictor of final performance. Mid-term grades will be posted in myNKU by the deadline established in the Academic Calendar (https://inside.nku.edu/registrar/calendars.html)

Note: For those few courses with an exception to the mid-term grade policy (as approved by the department chair and the college dean), there should be an indication that a mid-term grade will not be provided and but suggest other ways in which feedback will be provided.

Grade Appeal

Please see the Code of Student Rights and Responsibilities Section V: Academic Policies & Processes for any final grade appeal. The specifics of the process are detailed in subsection G: Student Academic Grade Appeal.  https://inside.nku.edu/scra/information/students/rights-responsibilities.html

 

Grading Scale

Final Exam Information

 Final (100 pts) – Thursday February 28th 10:00-10:50 pm

Student Evaluation of Instructor and Course Required (Boilerplate)
Northern Kentucky University takes Instructor and Course Evaluations very seriously as an important means of gathering information for the enhancement of learning opportunities for its students. It is an important responsibility of NKU students as citizens of the University to participate in the instructor and course evaluation process. During the two weeks* prior to the end of each semester classes, you will be asked to reflect upon what you have learned in this course, the extent to which you have invested the necessary effort to maximize your learning, and the role your instructor has played in the learning process. It is very important that you complete the online evaluations with thoughtfully written comments. 

Student evaluations of courses and instructors are regarded as strictly confidential. They are not available to the instructor until after final grades are submitted, and extensive precautions are taken to prevent your comments from being identified as coming from you. Students who complete an evaluation for a particular course (or opt out of doing so in the evaluation) will be rewarded for their participation by having access to their course grade as soon as that grade is submitted by the instructor. On the other hand, any student who does not complete the course evaluation (or opt out of doing so in the evaluation) should expect to incur a two-week delay in access to his or her course grade beyond the university's official date for grade availability. To complete online evaluations, go to http://eval.nku.edu. Click on "student login" and use the same USERNAME and PASSWORD as used on campus.

In addition, you should be aware that:

·         Evaluations can affect changes in courses. Evaluations without comments are less valuable and less credible than those filled out thoughtfully. Comments that are expressed well are more effective than those that are not.

·         Positive feedback is just as important as criticism. Moreover, negative evaluations without any explanation and specifics are not especially useful.

·         Once grades are submitted, all evaluations are read not only by the instructor, but also by the instructor’s department chairperson.

·         Evaluations not only provide feedback to your instructor, but also provide information to the department chair for use in performance evaluations. This information affects reappointments, promotions, salaries, and teaching assignments.

Course Policies

Online format includes reading the textbooks, studying the PowerPoints, watching the online lectures and videos demonstrating the topics covered in class, using the web site materials to learn flowcharting and how to write the programs will be the primary format.

Student Honor Code Required (Boilerplate)
This Student Honor Code [the "Honor Code"] is a commitment by students of Northern Kentucky University, through their matriculation or continued enrollment at the University, to adhere to the highest degree of ethical integrity in academic conduct. It is a commitment individually and collectively that the students of Northern Kentucky University will not lie, cheat, or plagiarize to gain an academic advantage over fellow students or avoid academic requirements.

Students, faculty, staff, and administrators at NKU strive to achieve the highest standards of scholarship and integrity. Any violation of the Student or Graduate Student Honor Codes is a potentially serious offense because it threatens the quality of scholarship and undermines the integrity of the community. All NKU faculty members are asked to report incidents of academic misconduct to the office of Student Conduct Rights and Advocacy.  While academic in scope, a violation of the NKU Honor Code may be considered a violation of the NKU Code of Student Rights and Responsibilities and will follow the adjudication processes described therein.  

Through the NKU Honor Code, students who are responsible for academic dishonesty may receive sanctions, including, but not limited to, a final grade of “F,” or removal from the course in which the violation occurs. Repeated violations of the NKU Honor Code, or when suspension or expulsion from NKU may be a possible outcome of the violation, the incident will be referred to the office of Student Conduct, Rights and Advocacy.

 Additional information is available at: https://inside.nku.edu/scra.html#policies

Accommodations Due to Disability (Required. Use one of the 2 Boilerplates)
Option 1:

The University is committed to making reasonable efforts to assist individuals with disabilities in their efforts to avail themselves of services and programs offered by the University. To this end, Northern Kentucky University will provide reasonable accommodations for persons with documented qualifying disabilities. If you have a disability and feel you need accommodations in this course, you must present a letter to me from the Disability Programs and Services Office (SU 303), indicating the existence of a disability and the suggested accommodations. More information can be found at http://disability.nku.edu.

Credit Hour Policy Statement Required (Boilerplate with calculations specific to your course)

In accordance with federal policy, NKU defines a credit hour as the amount of work represented in the achievement of student learning outcomes (verified by evidence of student achievement) that reasonably approximates one hour (50 minutes) of classroom instruction and a minimum of two hours of out-of-class student work. For every course credit hour, a typical student should expect to spend at least three hours per week of concentrated attention on course-related work including, but not limited to, class meeting time, reading, reviewing, organizing notes, studying and completing assignments. At least an equivalent amount of time is expected for other academic activities such as online courses, laboratory work, internships, practica, studio work and other academic work leading to the award of credit hours.

Estimates of the time required for a student to complete this course are:

3 hours per week outside class for every credit hour (9 hours per week)

Diversity
Diversity describes an inclusive community of people with varied human characteristics, ideas, and world views related, but not limited, to race, ethnicity, sexual orientation, gender, religion, color, creed, national origin, age, disability, socio-economic status, geographical region, or ancestry. Institutions that value diversity provide a supportive environment that respects those human differences. It is our responsibility as citizens of the NKU community to promote and value a campus environment and classroom climate that is safe, fair, respectful, and free from prejudice.

Allied Zone

I am a member of the Allied Zone community network, and I am available to listen and support you in a safe and confidential manner. As an Ally, I can help you connect with resources on campus to address problems you may face that interfere with your academic and social success on campus as it relates to issues surrounding sexual orientation and gender identity. My goal is to help you be successful and to maintain a safe and equitable campus.  

Name / Pronoun

My gender pronouns are she, her, hers. I will gladly honor your request to address you by an alternate name and/or gender pronouns from what is contained in NKU’s student records. Please advise me of these early in the semester so that I may make appropriate changes to my records.

Sexual misconduct

Northern Kentucky University is committed to fostering a safe and inclusive educational and work environment free from sexual misconduct, including sexual assault, non-consensual sexual contact, non-consensual sexual intercourse, sexual exploitation, sexual harassment, dating and intimate partner violence, relationship and domestic violence, stalking and gender-based bullying. For more information please see: https://inside.nku.edu/titleix/sexual-misconduct-policy.html

Observance of Religious Holidays for Class Attendance (may be included in syllabi or as an announcement in class)

NKU values diverse religious perspectives and beliefs and recognizes that religious practice is for many individuals an important element of personal identity, intellectual development and psychological well-being, and, in many cases, is inseparable from cultural identity. As the diversity of our community has increased, additional religious holidays now affect a significant number of students. Consistent with our commitment to creating a diverse and inclusive community, Northern Kentucky University believes that every reasonable effort should be made to allow members of the NKU community to observe their holidays without jeopardizing the fulfillment of their academic obligations. NKU students who are unable to attend classes or participate in any examination, study or work requirement on some particular day(s) because of his or her religious belief must submit a formal request to the instructor within 3 weeks of the beginning of the semester so appropriate arrangements can be made. 

Tentative Course Schedule

Other Information

IMPORTANT DATES

SPRING: 7-WEEKS 1 | JANUARY 14 - MARCH 1

Course outline

Course Content CBK

Topic Hrs. Area(s) 

A. Excel Chapter 1: Visual Basic for Applications with Excel 3 C

B. Excel Chapter 2: Beginning Programs with VBA 3 C

C. Excel Chapter 3: Procedures and Conditions 7 C

D. Excel Chapter 4: Loops and Arrays 12 C

E. Exam #1 1 C

F. Excel Chapter 5: Basic Excel Objects 3 C

G. Excel Chapter 6: VBA UserForms and Additional Controls 3 C

H. Access Chapter 2: Access Essentials 3 C

I. Access Chapter 3: Introduction to Access VBA 3 C

J. Access Chapter 8: Debugging, Input Validation, File Processing, and Error Handling 5 C

K. Exam #2 1 C

Note: C above stands for a class period of 50 minutes.