BF174 COMPUTER APPLICATIONS II – SYLLABUS (SPRING 2017)
Last updated: 3 February 2017
Erin Maloney
LC104 – 2902067
Office Hours
COURSE ROOM and TIMES: 4 hours
 Mondays, 8.4010.30 – GB52
 Thursdays, 8.4010.30 – GB14
BEFORE taking BF174, students should know the following (from ACC173, BF173 or equivalent):
 BCC labs: protocol, changing password, email, uploading files using Intranet (for quizzes and exams)
 Compressing: such as 7zip
 Computer terms: in English
 Drawing: such as a supply/demand chart
 Internet: intermediate searching, browsing, and email usage
 Photo editing: resizing, cropping, removing redeye
 PrintScreen/Snipping Tool
 Slide presentation: intermediate usage
 Spreadsheets: intermediate usage, for basic budgeting
 Windows: intermediate
 Word processing: advanced
AFTER taking BF174, students should know the following:
 Advanced spreadsheets: especially for accounting, banking & finance, and statistical applications
 Beginning econometric statistical software
METHODS OF EVALUATION
 Participation: 5 points
 Quizzes: 35 points – best 7 of 9 quizzes, with each quiz worth 5 points; quizzes on Mondays, at 8.40, with dates announced in class and/or via email
 Midterm: 30 points – on or near 29 March
 Final: 30 points
NOTES:
 For Computer Literacy, a "C" is 73%, while an "F" is 59% or lower; see General Grade Scale
 For minimum requirements for participating in Erin's final: See SRS
PROTOCOL
 Cheating / Plagiarizing: Unacceptable, with disciplinary action for gross or multiple offences.
 Homework / Labwork: To be completed outside of class.
 Participation: For each class, students are expected to be on time, with a pen and notebook, and with personal electronic devices switched off. Students who use a personal electronic device during class without asking for and receiving permission will not get attendance/participation for that hour. Students are expected to use the bathroom during breaks, and follow other basic protocol for academic classes. Students must also check their Bilkent email for course information at least once per day.
 Reading Materials: Available from Erin's web site and/or Moodle.
 Software (not free – but available for "free" in BCC computer labs):
 Econometric Statistical: Eviews 7
 Spreadsheet: Excel 2010
 Software (Open Source/Freeware):
 Technical: Students use their own Bilkent username, password, and H: drive for each class, quiz, and exam.
 Visiting Erin in her Office: Strongly encouraged.
COURSE SCHEDULE
WEEK 1: Introduction and Review
 Introduction: Syllabus and Course Expectations
 Review: Take ACC/BF173 Final Exam, using Excel
WEEK 2: Intermediate Spreadsheets; Basic Accounting and Banking; Amortization Table
 Intermediate Spreadsheets: Insert cut cells; INT, TRUNC, QUOTIENT; Mixed Referencing Review
 Basic Accounting/Banking Functions: FV, PV, NPER, PMT, RATE; IPMT, PPMT; Formula v. FV
 Amortization Table
WEEK 3: Copying Web Data, Basic Logic, and Basic Statistics with Spreadsheets
 Copying Web Data: Using mean, MEDIAN, MODE.SNGL (same as MODE), MODE.MULT; Tabular table, removing filter
 Logic Functions: IF, AND, OR, TRUE, FALSE, NOT (IFERROR later)
 Statistics Functions: STDEV.S (same as STDEV), STDEV.P (same as STDEVP), VAR.S (same as VAR), VAR.P (same as VARP), CORREL, COVARIANCE.P (same as COVAR), COVARIANCE.S
WEEK 4, 5: Calculating, Seeking and Solving with Spreadsheets
 Seeking and Solving: Goal Seek, Solver, Scenario; Spinner
 Other Basic Functions: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNT, COUNTBLANK, COUNTIF, COUNTIFS; COUNTA and other functions with "A" at end; PRODUCT, POWER, SQRT; VLOOKUP (and HLOOKUP, LOOKUP); DAY, MONTH, YEAR; EXACT
WEEK 5: Matrices with Spreadsheets
 Matrices: Vectors, Rows, Columns; MINVERSE, MMULT; What can be inverted; What can be multiplied; Adding, Subtracting, Multiplying (such as 3A – 2B)
WEEK 6, 7: Basic Accounting and Banking (cont.), Intermediate Charts with Spreadsheets
 Basic Accounting/Banking Tasks: Annual Rate of Growth; Percentage Increase and Decrease; Continuous v. Periodic: Compounded Rate of Return; Compounded Interest Earning
 Basic Accounting/Banking Functions (cont.): "e", LN, EXP, with chart; Bases; EFFECT
 Intermediate Charts: reducing large values, titles, gridlines, legends, text box, arrows, axes, plot area, color
 Compression Review
WEEK 8: MIDTERM: on or near 29 March
WEEK 9, 10: Working with Data in Word Processing; Tables from Spreadsheets; Data Analysis
 Data in Word Processing: Finding: tabs, paragraphs and manual line breaks; Building spreadsheet table for word processing document
 Data Analysis: Histogram, Sampling (Random, Periodic with formula), Random number generation (inc. glitches); Correlation and Covariance; Descriptive Statistics (inc. excessive Kurtosis); Regression; Introduction to other data analysis topics
 Functions for Data Analysis: RAND, RANDBETWEEN; difference between Data Analysis and Functions; Mean > Median
WEEK 10, 11: Intermediate Accounting and Banking; Objects and Symbols; Advanced Charts
 Intermediate Accounting/Banking Functions: CUMIPMT, CUMPRINC, NPV, IRR, XNPV, XIRR, YIELD
 Objects and Symbols: Insert/Object/MS Equation; Size; Formulas/Reference Table
 Advanced Charts: XY Scatter, Slope, XY points on a line
WEEK 11, 12: Advanced Logic; Other Useful Topics with Spreadsheets; Secondary Axis Chart; Graph
 Advanced Logic: More IF/nested IF; ISERROR, ISTEXT, ISNUMBER, ISBLANK and other IS*; IFERROR; Conditional Formatting
 Other Useful Topics: SLOPE, INTERCEPT; Pivot Table, Filter, SUBTOTAL, Subtotals
 Advanced Chart: Secondary axis
 Graph, such as (in drawing and spreadsheet software): y = 100 + 2x
WEEK 13, 14: Introduction to Econometric Statistical Software
 EViews: Dumping data, charts, mean, median, descriptive statistics, correlation
FINAL EXAM: TO BE ANNOUNCED
