CIS101Introduction to Computing

Week 02

Agenda Your questions CIS101 Blackboard Site online.pace.edu and the online

orientation Excel Project One Next Week

CIS101 Online 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 week 01 – week 07 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 If class meets on Thursday, must

finish quiz by 11:59 pm Wednesday 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 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

Pace online orientation Overview of technology and requirements

for online learning Designed to prepare students to effectively

participate in the online environment. To be considered as pre-approved for

online or Web-assisted courses need to complete the Online Orientation’s final assessment (passing is 70%)

Once you pass permanent record will reflect your pre-approved online learner status

Access online orientation "Orientation to Online.Pace.Edu

Learning Community" Located within Blackboard Will see it after you login under

"My Organizations” Also links to a portion of tutorial in

course docs week 01

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

More Excel Practice If there is time continue practice

with Excel by completing “In the lab” at the end of project one, either #1, #2, or #3

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

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