● study
● design 'implementation
● support
● management
● of a computer-based information system particularly software and hardware
● People
● competency
● Attitude
● critical thinking
● best practice
Leader- buy the newest technology and maybe an edge
Follower- wait to see what works and lose the edge
*a leader or follower is equal in power
Why is Moore’s Law important in business computing?
- Computer processing power will double every eighteen months or so. (includes Internet
size). Imagine a car maker manufacturing a vehicle that doubles its gas mileage every
eighteen months.
Business Computing hardware
- Tangible and physical aspects of computing hardware
- Mainframe
- Midrange
- Microcomputer
- Laptops
- Desktops
- Handheld
System software
- Among other things, system software makes hardware work. Collection of computer
programs that accomplish a specific task.
What is the difference between system software and application software
-the application requires human interaction and the other does not require human interaction
Operating systems (platforms)
- Collection of computer programs that work together to manage hardware and software
and make sure the computer is working correctly
McCarthy Mondays
definitions on Midterms!!!
- File management (make folders)
- Multitasking
- Memory management
- Disk management ( you keep all the shit)
Common business operating systems (platforms)
- Microsoft Windows (number 1 operating system) How much does windows cost? A lot
- Mac os
- Linux (free) (will do anything windows does)
- Unix
Why isn’t Linux kicking windows ass?
● It's not user-friendly - windows is a marketing monster as Linux has no money- People of
perception that if it cost more it works better- Was it made in America?-
● Who are Linux programmers who are famous? Mexicans
Mexicans were brilliant to switch to Linux- save millions of dollars.
Application software
● Performs particular tasks like creating budgets, resumes, or professional presentations
● Changes of an application software not meeting an end user’s needs are remote
● Never underestimate any kind of software
When was Mircosoft Word invented in - 1985
Common Application Software:
● Email
● Word processor
● Spreadsheet
● Database
● Presentation software
● Project management software
Business computing software ( 4 main business software)
● Concerned with four basic applications: spreadsheets, word processors, database
and presentation software.
If you had to pick one of the software which one would you pick to
run a business- excel
Information techonolgy- database
Productivity suites
What is the advantages of that- it cost saving BUT NOT THE BIGGEST advantages. Is the
ability to share data between applications.
- Collection of business computer application programs of associated functionality that
share a common graphical user interface. ▪ Also called “Software Suites” or
“Application Suites” ▪ Allows smooth data exchange ▪ Microsoft Office is the most
popular
What is the most important aspect of learning application software? Attitude
Sharing Data between software suites
● Cut and paste- static
● OLE, Linking-dynamic, embeded
Wood- Application excel-2
Spreedsheets- the heart of accounting
Financial statements are presented on spreadsheets
Financial information on companies
- EDGAR ( Electrong data-gathering analysis and retrieval system)
- Operated by SEC ( securities and exchange commission
How is a company doing? An income statement, balance sheets, cash flow,
Microsoft symbol-MSFT
(On Edgar you can look up companies and see their fillings, formate, and description for public
view)
(in-class we searched Microsoft 10ks on annual basis)
Spreadsheets are answering “what is?”
Numeric analysis
● Sort, group, filter, highlight
● Find largest, the smallest average
What IF?
● Spreadsheets are used to answer “What-if”
○ What will be the change in our profit if our cost of flow matericals decrease by
10%
Modeling a situation with a set of equations
Personal Financial analysis
● Budgeting
● Buying a car vs leasing a car
○ Monthly payments
○ Downpayment
Review on Excel basics: Auto fill
Example
- Cell one mon
- Cell two tues
● Just pull down and days of the week will pop up
Assignment- Enable editing
Sales tax type
=c11*c8 click F4 key and pull down
- Click on c8 and click the F4 key
*Or type $C$8
(=C11*$C$8)
Total
=C11+D11 and pull down
Grand total
Home page click auto sum scroll down and click “auto sum”
=SUM(E11*E23)
Under Response
Click on first cell and click (fx) and you get a menu of functions
Type in COUNT click okay
Highlight all the 1990 wins and enter (should be 26)
Response 2
Same as above but use COUNTA
COUNTA
Highlight 2010 wins and click enter
Should be 30
Total salaries paid in 1990
Click fx
Go to sum function
Highlight 1990 payroll
Enter should be $454
2010 salaries
Same about
Highlight 2010 payroll
Should be $2,717,759,865
Average salary
Fx
Type in average
Highlihgt 1990 payrool
Should be $17..
Average salary 2010
Same as above
Max
Click fx
MAX
Highligh 1990 payroll
Click enter
Should be $23…
Max 2010
Same as above just highlight 2010 and should be $34….
Next formate page of the assignment
Task 2
(fx)
Ctype present value PV
Rate: % /12
Periods: click on box 360
Montlyh payment
Answer- $243,932.24
Task 3 and 4 date
Click fx
RATE
Periods: 360
Payment: monlthy payment
Present value: loan payment
Click enter
.29%
times 12 should be 3.48% in FX (nomianl interst rate)
Effective interest rate
Fx
EFFECT
Nominal rate
Type 12
Should be 3.54%
Task 5 data
FX
FV
Rate 2.75% divide by 12
Next one is 36
Payment 75
Answer $2,811.15
Task 6
15-year mortage
PMT
Rate 4.50 /12
Periods 180
Presnet value top box
$3,371
30
Same as above
$1,570.72 is the answer
Difference just subtract 15 year and 30 answer - $138,594.55
