BF174 COMPUTER APPLICATIONS II – SYLLABUS (SPRING 2017)
Last updated: 3 February 2017

Erin Maloney
LC104 – 290-2067
Office Hours
E-posta


COURSE ROOM and TIMES: 4 hours
  • Mondays, 8.40-10.30 – G-B52
  • Thursdays, 8.40-10.30 – G-B14

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: re-sizing, 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