Transcript CIS101 week 02 v2

CIS101
Introduction to Computing
Week 02
Agenda




Your questions
CIS101 Blackboard Site
Excel Project One
Next Week
CIS101 Online




Syllabus
Lecture notes for Concepts and Excel
texts can be found in Course
Documents
Discussion Board – practice posting a
message including a working link
Week 02 is first online quiz (Concepts
Chapter 1)
Lecture Notes


Each assigned text reading has lecture
notes
Week 02 – in course documents


Lecture notes for Concepts (2nd half of
chapter 1)
Lecture notes for Excel Project One
Discussion Board


Post a message to “Start Page” thread
in Welcome to CIS101 forum
Include a working link by either:


Use anchor tag and select html option
<a href=“web address”>link text</a>
Or include full url and select smart text
option
First Online Quiz




20 question, 30 minute quiz on
concepts chapter one
Must be completed by midnight before
next class meeting
Our class meets on Tuesday, must finish
quiz by 11:59 pm Monday
Quizzes are located in Assignments,
Quizzes folder
Quiz Folder





If using dial-up modem you should first
download and install Connection Keeper
While taking quiz, your account may appear
inactive to your ISP, and you may be kicked
off
Connection Keeper maintains connection to
the Internet, even if you appear inactive
Prevents a “timeout” by your Internet Service
Provider
Link to software under Web Sites button
Practice Quiz




Each week has a practice quiz
You can re-take the practice quiz again
and again
When you are ready, take the quiz that
counts towards your grade
Take the practice quiz for week 02 now
to try it out
If you have problems


Blackboard quiz sometimes has to be
reset
If you lose your connection and can’t
get back to the quiz, send e-mail to
your instructor requesting that your
quiz be re-set
What is Excel?

Spreadsheet program with four parts




Worksheets – where you enter, calculate,
manipulate, and analyze data
Charts – visual representation of
relationships among data
Database – manage data (sort, search,
select)
Web support – save in html format, access
real time data using web queries
How do you plan a
spreadsheet?

Identify the following:




Needs
Source of data
Calculations
Chart requirements
First Excel Project




Dynamite Music Fourth Quarter Sales
Needs: sales report for each product group
Source of data: Chief Financial Officer (CFO)
Calculations:




total sales for each of four product groups
total fourth quarter sales for each of four stores
fourth quarter sales for the company
Chart requirements: 3-D column chart
comparing amount of sales for each product
group within each store
Start Excel



From start button begin Excel
Remove new workbook task pane
Set up buttons on two rows
The Excel Worksheet




Row (numbered)
Column (lettered)
Cells (A1, C5)
Toolbars (invoke commands and
functions)
Selecting a cell



Use mouse to move the block plus sign
to the cell and then click
Use arrow keys to select cells
A cell is active when a heavy border
surrounds the cell
Start entering text (1.17)





Click cell A1
A1 becomes the active cell and a heavy
border surrounds it
Enter text “Dynamite Music”
Text displays in the formula bar and in A1
The text in A1 is followed by the insertion
point (a blinking vertical line), indicates where
the next typed character will display
Continue Project One

Follow the instructions for Project One
beginning on page 1.17
Summary of Project One





Enter and format data (text and
numbers)
Select a single cell, or use the mouse to
select a range of cells
Use auto sum function
Apply auto format to a selection of cells
Name a cell
Summary cont.





Create and embed a chart in a specific
location on your worksheet
Use Excel help system
Save, print, and re-open your
worksheet
Use the Auto Calculate area
Fix errors and change information
Excel Homework

Complete one of the following:




“Cases and Places,” #1, #2, or #3 (p. 1.63)
Add a second chart using data and format of your
choice
Name your file:
yourlastname_firstInitial_week02.xls
Upload to digital drop box using send button,
not add button
Next class meeting


Bring your Excel book to class
Complete Assignments, Week 02




First online quiz
Excel assignment via digital drop box
Read Course Documents, Week 02
Keep up with Discussion Board