Transcript CIS101 week 04 honors

CIS101
Introduction to Computing
Week 04
Agenda






Your questions
Update on online quizzes
Set up WS-FTP
Excel Project Three
This week online
Next week’s class
My comments


ALWAYS include your full name in your
e-mail!
I don’t know who [email protected] is!
Names and files


Naming convention for assignments on
blackboard is:
yourlastname_yourfirstinitial_weekxx
You will lose points if you do not use
this naming convention!
Online Quizzes



This is a pilot version of CIS101
Have uncovered some problems with test
banks provided by publisher
To adjust for problems:


After completing quiz, verify Blackboard has
marked it correctly, bring any problems to your
instructor’s attention
Will drop lowest two quiz scores for final grade
Pace Webspace


Last week you signed up for Pace
Webspace
Access your Pace e-mail and print out
e-mail confirmation of Webspace
account
Webspace cont.


Access your web site:
http://webpage.pace.edu/ACCOUNT
where account is your email id ALL
CAPS
The URL should work, but the page will
have nothing in it
Ws-ftp software



Starting next week you will create html
files
Software WS-FTP does the job of
copying those html files into your web
site
First confirm WS-FTP is installed on
your machine
Ws-ftp software

To install click Web Sites, find link for
WS-FTP software, download onto
desktop, unzip and install


Download site for WS-FTP is
http://www.ftpplanet.com/download.htm
You can use this link to get the software
for your home computer
Set up WS-FTP




Start WS-FTP, then enter:
Profile Name: WS_FTP32 (or anything
else you like)
Host Name/Address:
webpage.pace.edu
Host Type: Automatic detect
Set up cont.





User ID: yourID (the one you receive in your
registration confirmation email)
Password: ******** (also found in the
registration confirmation)
Account: (leave blank)
Comment: (leave blank)
Also, click on the Startup tab - In Initial
Remote Site Folder: webpage.pace.edu
Now connect



Click OK and you connect to your web
server
can also use this software to access
other ftp sites
Will use this dialog next week to upload
files to your web space
Excel Project Three




Excel’s automatic recalculation feature
to complete what-if analysis
Absolute cell references
The if function
Working with large worksheets
Using cell references



When setting up a worksheet use as
many cell references as possible in your
formulas
Cell references in a formula are called
assumptions
Change the assumptions, and you can
change the output of your worksheet
Project Three Description



Need: a worksheet and 3-D Pie chart
showing projected monthly revenue,
expenses, and net income
Data: Projected revenues and
assumptions based on historical data.
Other values computed by formula
Calculations: based on assumptions
(page 3.06)
Series (p. 3.10)




Series is mathematical term for a sequence of
terms with some relation between them
Relation generates the next term of the series
Sequence can be numbers, dates, or another
pattern
Fill handle allows you to quickly set up and
expand a series
Absolute vs. relative addressing


When you copy cell references from one
cell to another, Excel normally updates
the cell reference
Example: autosum on one column, then
copy it one column over and references
are updated
Absolute references



Sometimes you want to include a single
value in calculations in different parts of
your spreadsheet
You can “turn off” the Excel cell
reference updating with absolute
references (with $)
See table p. 3.25
Entering formulas with absolute
references



Change to formulas version (CTRL +
ACCENT MARK (`)
Follow formulas on p. 3.29
Be careful, it is easy to make a mistake!
The if function



Allows excel to examine a value and
make a decision
Make a logical test using comparison
operators (p. 3.27)
Has three parts



Logical test
The value if true
The value if false
Excel as an analysis tool


What-if analysis – change assumption,
use undo to reset
Goal seeking – allows you to analyze
relationships between values in your
spreadsheet and optimize a value
Summary of project three







Using the format painter
Creating a series with the fill handle
Using absolute references in a formula
Using the if function
Entering the system date
Adjusting assumptions
Using goal seek
Summary cont.



Selecting non-adjacent ranges for a pie
chart
Creating an exploding pie chart
Freezing and unfreezing worksheet
titles
This week online

Readings and Quiz


Concepts chapter 8, Operating Systems
Excel assignment

In the lab assignment #1, #2, or #3
(starting on p. 3.73)
submitted by digital dropbox
with name:
yourlastname_yourfirstinitial_week04.xls
Next class meeting


Bring your HTML book to class
Will start building web pages next week