Final Exam Review Spring 2021

IE2060 FINAL EXAM REVIEW Final exam: 7:30-9:30am, Tue April 27 th , with Zoom Proctoring Topics: (comprehensive, although emphasis on chapters 6-12 and lab 5-11 since midterm) Computer architecture & concepts  Computer concepts, terminology, data representation, number systems Basic programming concepts  Datatypes, variables, expressions, assignments, flow control structures (IF, SELECT; DO loops, WHILE loop, FOR loop, FOREACH loop), using functions (including by value versus ref versus out, optional arguments, passing / returning arrays), scope, string & datetime processing, string formatting, debugging and tracing code Functions & OOP (Ch 6-7):  Defining classes and defining/calling/using class properties, methods & constructors, enums  Static properties, methods, enums Systems Development (Ch 8):  Systems Development Process  Interpreting / when to use common diagrams: use case diagram, flowchart, decision trees, ERD, activity diagram UI, Usability & Form Application Concepts (Ch 9):  Concepts & principles, types of UI, usability design and assessment process, types of form layouts, types of navigation  Controls and their application (purpose, when used; declaration in Python)  Configuring common Control properties  Events and Event handler programming Data Structures (Ch 10):  One dimensional and multidimensional Arrays, Arraylists (lists in Python), Queues, Stacks, Hashtables (dictionary in Python), Classes (as data structure) – declaring, initializing, using; when to use each type Databases (Ch 11):  Entity-relational concepts - Tables, fields, rows, keys, relations  DBMS  SQL: SELECT, DELETE, UPDATE, INSERT queries  ADO.NET and pyodbc DB programming (basic)  Databinding controls Working with files (Ch 12):  Opening, reading, writing, and appending to text files  Reading from, writing to, customizing Excel workbooks  File & Directory operations Office Applications (Labs)  Purpose of each (Word, Excel, PowerPoint, Drawing Tools)  Word techniques  Excel: Cell & range addresses, named ranges, interpreting/constructing formulas, statistical functions, lookup functions, array formulas, pivot tables/charts & using data sources, macros, data tables, outlining, subtotals & consolidating Problem types (roughly):  Concept questions: 30-40%  Code interpretation problems: 10-20%  Coding problems: 40-50% Concept questions will generally be multiple-choice, matching, or T/F type questions. Interpretation and simpler coding problems may also be framed as multiple-choice or numeric answer problems and may be on either C# or Python. These types of questions are automatically graded and will generally have no or limited partial credit.

For written (essay type) code problems, you will have an option to use either C# OR Python in your answer. These questions are manually graded and may receive partial credit. Operation & Rules of the Exam Please review the following carefully:  Final exam is scheduled for 7:30-9:30am, Tuesday 4/27/21 . o If you have an extended time accommodation (& provided an ODS form to document), your exam will run from 7:30-10:30am.  You are to be logged into Zoom with your video on for the duration of taking the exam for proctoring purposes . The exam Zoom URL will be the same as the "Scheduled Class Time" zoom link on Moodle. Once you are admitted to Zoom, you will be assigned to a breakout room with a proctor. o During the exam, your audio should be muted unless a proctor or I need to talk to you. Use Chat to communicate questions to your proctor. The proctor will relay the question to me if they are not able to answer it directly. o If you need to leave the video frame of view for any reason, notify the proctor first by chat and indicate why. Any break is expected to be short. If you will need to leave for more than a couple of minutes, you must end and submit your exam before leaving or be assigned a zero. If you have not submitted your exam and leave the video frame of view without notifying the proctor first, you will be assigned a zero for the exam. o If your video turns off during the exam, you will be asked once to turn it back on. If that does not occur quickly, you will be assigned a zero for the exam. o For anyone arriving late to Zoom, or leaving early from Zoom, the Zoom attendance logs will be matched against the Moodle exam logs. If the logs do not match (i.e., you were working on the exam while not on Zoom), you will be assigned a zero for the exam.  The exam itself will be on Moodle during the scheduled exam time . Note the exam automatically starts at the scheduled begin time and will automatically close at the end of the exam period. You may use the following during the exam:  Pens / pencils and blank paper  Up to 4 sheets of notes (front & back), or 8 sheets single-sided  The formatting codes handout from chapter #3, printed (may not contain additional hand-written notes)  A simple calculator  Computer, to be used ONLY for zoom proctoring and writing question solutions in Moodle. o Any other form of messaging, file sharing, web browsing/search, etc. is not allowed. o Use of any materials / files / apps on your computer other than listed here is not allowed.  To be clear, use of Visual Studio, Spyder, and other IDE apps are NOT allowed NO cell phones may be out during the exam, except for scanning handwritten solutions at end of exam (written essay type exam questions allow attachments). For calculation problems, maintain calculations to at least 4 decimal positions through final answer. Multiple choice, matching, true/false , or Moodle numeric answer problems (the last is a type of auto-graded Moodle problem for which you provide a single numeric answer):  No or limited partial credit will be given for incorrect answers on these problems.  You do NOT show work for these problems. CHEATING IN ANY FORM WILL NOT BE TOLERATED AND IS PARTICULARLY PROBLEMATIC FOR STUDENTS STUDYING TO BE PROFESSIONAL ENGINEERS. ANY SUSPECTED CHEATING WILL BE REFERRED DIRECTLY TO THE DEAN OF STUDENTS JUDICIAL OFFICE FOR FURTHER ACTION.

Final Exam Review Questions Questions in this guide only focus on topics covered since the midterm (functions, OOP, systems analysis & form design, usability & form apps, data structures, databases, files). The final exam is comprehensive, however, so suggest you do a quick rescan of the midterm review guide as well. Questions come from multiple past exams, and more than one test worth of questions is included in the guide. The midterm will have 100pts of questions. Use the points noted on questions as a guide. Most but not all questions have solutions. I do not have nor will provide solutions for those that don't. You are welcome to see me for help in understanding any problems, provided you have made a good effort at solving/understanding first. I am not in the habit of reusing questions, so what is important is that you know how to solve the type of question, not memorizing or including solutions to specific questions on your note sheets. Absence of a review question on a topic does not mean the topic will not appear on the test. Any topic area listed on the first page of this guide is fair game. There will be more use of M/C, matching, T/F and numeric answer questions than you see here in this guide. Many of the following questions can be easily converted to these types of questions however. You will also see more Python coverage on your final than seen here. Python was first introduced to the course just last spring, so there are not a lot of Python questions I can include from past exams. For the same reason, the code solutions in this guide are in C#, but you will be able to answer any written code problems in either C# or Python. Questions here are organized by topic; this will not be the case on the exam. FINAL EXAM COVERAGE – Comprehensive, but focus will be on Chapters 6-12 materials, and Labs 6-11. Functions (Ch 6) 1. [10pts] Implement a public method (function) in C# or Python that, passed a value X of type double (Python float), returns (as double) the cube root (X 1/3 ) of that value if X is positive, and zero otherwise. public double Cube( double X ) { if (X > 0) return Math.Pow(X,1.0/3.0); else return 0.0; } 2. [10pts] Write the code in C# or Python for a void function that, passed two arguments of type double (Python float), writes the sum to the console window, rounded to two decimal points, at least one digit to left of decimal point, and including thousands separators. SOLUTION: void Q34 ( double A, double B) { Console.WriteLine( "{0:#,##0.00" , A + B); } 3. [7pts] Given the following C# function and main() code, what value of D is written out to the console? Show how value derived to be eligible for partial credit. static int Q35 ( int R, ref int Q, out int T, int V = 1) { Q += 1; R = 5; T = 10; return Q + R + V; }

In static void Main(…): int A = 2, B = 3, C = 4, D; D = Q35(A, ref B, out C); D += A + B + C; Console.WriteLine(D); Solution: 26 Upon return from Q35, A will be unchanged (2), B will equal 4, C will equal 10, and D will be set equal to the return value of Q35 (10). 10+2+4+10 is 26. 4. [12pts] Write a function in C# or Python that returns the sum of an arbitrary number of arguments. The arguments and return value will all be of type int OR decimal (use polymorphism to accomplish this). OOP (Ch. 7) Use the following C# code to answer questions 1-2 class Exam { public int M { get ; set ; } int Q { get ; set ; } static public decimal W { get ; set ; } } 1. [2pts] Property Q is accessible anywhere in class Exam ( TRUE / FALSE ) 2. [4pts] Write a single C# statement to set class Exam's W property to the decimal value of 8.0. Exam.W = 8.0m; 3. [8pts] Suppose a C# object class OOPclass has a public property X of type int. Further suppose we declare “OOPclass C = new OOPclass();”. Write a C# statement that will call the SET part of property X. C.X = 4; 4. [20pts] Write a class “Pyramid”, in either C# or Python, with the following properties and methods. Then illustrate declaring and using an instance of the class. a. The class should have the following attributes: length_of_base, width_of_base, height. b. Properties should be declared to read/write the three previous attributes. c. A constructor should be declared to initialize all three values. d. A function volume should be declared as well to calculate the volume of the pyramid The formula to calculate the volume of a pyramid is V = (1/3)*B*h where B is the area of the base and h the height from the base to the apex. 5. [5pts] Given a C# object class TestClass with read/write integer property Value . Would the Q.Value = 3 statement below call the GET or SET part of the property? TestClass Q = new TestClass(); Q.Value = 3; SOLUTION: set