500sp08agendas
BU500 - Agendas

Queen
sborough Community College

Professor Daniel Stein- abriteguy@aol.com

See our Daily Agendas
see Student Tutorials on Microsoft Office

Complete it and print it. Then bring it to Prof. Stein.
Call him over to your computer, to show thim that the formulas work!

2. Download wordfinal.doc and complete it. Now print it and hand it in.

Have a GREAT SUMMER

5/13

Review for the Final:

Submit 5 multiple choice questions with appropriate answers for Microsfoft WOrd and Excel. Email to abriteguy@aol.com - Put in you portfolio as well

~~~~~~~~~~~~~
Make an Excel document name it **qfinalsalary.xls

Show a table that converts all of the above to each other unit of salary (4 tables)
Hourly salary to Daily,  Weekly Monthly, and Yearly

8 hours = a day 5
12 months = year
50 weeks = year

~~~~~~~~~~~~~~

Quantity Amount of each item (in dollars ) an extension  column
Veritcally added to a subtotal total
A tax of 8.5%
and a Grand Total

~~~~~~~~~~~~~~~~~~~

Word- Create a flyer (**qfinalflyer.doc)
Advertising BU500 in Fall 2008 with Professor Stein

~~~~~~~~~~~~

Create a paper with one citation (**qfinalpaper.doc) on Technology in Education

You need a standard heading....an introduction, article summary and conclusion
www.knightcite.org

~~~~~~~~~~~

Create a Flyer adverising BU500 in Sp~~~~~~~~~~~~~~~~~~~~~~~

Question 1:

Write a short term paper... filename **qsupporttech.doc
Use the Course heading (changing appropriate information)

Title: Technology Supports Education (with or in)
Example: Technolohgy Supports Education in Elementary School
Example Technology Supports Education with E-Portfolios

Locate 2 articles on your topic... (qcc.cuny.edu/library  )
EBSCO remember to check Full Text
Write an introduction ( suggested that you do this LAST)

Summarize each of 2 the articles
Use a quote (indented on both sides with smaller text)

Explain why the article supports your view
Create a Citation for each using MLA Standards at eatch article
( Use knightcite.com )

Create a Bibliography

List all the resources

~~~~~~~~~~~~~~~~~~~~~~~~~

5/7 Probability.....

Create an Excel document **qdie.xls showing graphic results of  10 rolls of a die
Die Generator
Whatever your guess... Professor Stein says you will lose! See who wins more.
Discuss your assignment and your results on a word Document **qdie.xls, making sure you use a header from a previous assignment.
Review the video of a student of professor Stein. Explain why Professor Stein was right most of the time!
Post both files to your website!

Want to know why Prof Stein wins most often? Hear his student explain probability

~~~~~~~~~~~~~~~~~~~~~

Final Review: Access: Key field, Fields, Format a field, Relational Data Base, Table, Form,  Report, Query
USE YOUR TEXTBOOKS FOR KEY TERMS at the end of each chapter.
~~~~~~~~~~~~~~~~~~~~~~~

Printed portfolios every day til end.

Section on E-portfolio (print screen with uses for each page)

Section Excel (Graphs, Amortization Schedule), Jobs... Formulas

Section - Web programs ( Jing, Email me form, Survey Monkey, Voice thread.

Intro to each section...... What business uses for each program - Bullets with explanations and how you would use them.

~~~~~~~~~~~~~~~~~~

One final question - Create a newsletter....

What students have done...500sp08done.xls

4/30 ( By the way... I am proud of this class- That is why I am showing you so much!)

Open any word document with a header... Save it locally as a new document with a new name ***qlibrary.doc and delete all non pertinent information. On th page with just the header remaining,describe your experience of  library. Note things like what and how you can use the QCC virtual library to do a research paper. Note several links and what they can do.

The links should be active on your E-portfolio page "Library" page which you created at the library. Write a description of each link.

NOW----- This is FUN and POWERFUL

Create 2 new pages... "Email Form and Survey Monkey"
Do one at a time.

1. Email Me Form - Create an account. Then create an email form so that viewers to your site can offer Positive Comments. WATCH THE TUTORIAL on the link above. As a group decide on what information you would like to have emailed to you..

2. Survey Monkey - Create and account - Then construct and deliver a 5 question (business related) survey. WATCH THE TUTORIAL on the link above. Send the email or embed it into your e-portfolio survey page. Construct an Excel graph of your results  (file **qsurveyresults). Upload it and add it to your assignments list on your e-portfolio.

Discuss the questions and results on your e-portfolio "survey" page.

Note: One person (maybe 2) can conduct a survey on the usefulness and methods used in this course. (hahahaha - Prof.).

4/16

NOTICE: April 16th we meet outside the Library for a Virtual Tour of Online Resources. You will learn to about resources that you can add to your e-portfolio.

4/11

Create a Project Playlist.
Make a new web page on your eportfolio with the first words "music"

Go to ProjectPlaylist.com create an account and a playlist
http://www.projectplaylist.com/

Can you embed it with autoplay = true?

4/9

LESSON: Comparative research on wages of similar positions by area.

Open wagescompare.doc, save it locally (with class naming conventions), read it and minimize it.
Open wagescompare.xls, save it locally (with class naming conventions)
You may wish to review a previous document wages.xls

Go to Craig's List craigslist.com

Compare jobs of interst to you and in areas of interest to you!

4/4

Explore Jing.
Then Create an excel document (as we did in clss) to show:
See Professor Stein's 555qwages.xls document

1.what an hourly wage is per week per year,
2. What a yearly wage is per hour

File is called **qwages.xls
Capture it in Jing
Send the link to : qccstudent.broachford@gmail.com

## The Quick and Simple Version

2. Click the capture button, and select something on your screen to share.
3. Choose to grab an image or record a video.
6. Paste the URL into your conversations or anywhere else you want to share.

## The Illustrated But Still Really Simple Version

First things first; download and install Jing. The PC client requires .NET 3.0 framework from Microsoft. If you don't have it, the Jing installer downloads it for you during the install. Once Jing is installed, you're ready to get started.

4/2

Today: Assignment: **qooh.doc
What is the Occupational Outlook Handbook?

Research up 2 different possible occupations choices
and tell what you found out about them.
If possible put a graph and explain what it means.

Create a citation MLA format using Knightcite.com
WANTED- a group to author - QCC Microsoft Office Training

~~~~~~~~~~~~~~

3/28

You are responsible to make a video and publish it to teachertube. Note that you can make it private and send the link to professor stein abriteguy@aol.com
Note that you do not have to have your picture in it.

Students by the end of the term should have several entries in the 500sp08word book. The editor is to be assigned.

Look at the Excel document showing your assignments. a 1 indicates that it has been completed. The total is on the right. This document will be continually modified with more assignments.

Todays lesson

Microsot Excel... Create a menu for a store. Have columns add to an extension and the bottom totals. This will be added.

This is a LONG RANGE ASSIGNMENT...
Create a web page on your site.
Copy and paste the Excel Tutorials (audio)

Comment on each with 3 or 4 things you lrearned.

Print Screen

3/19
Hoomework.. Review the files needed (this will increase) for your printed portfolio.
500sp08done.xls

BRING IN YOUR 3 RING BINDER....

Please create an e-portfolio page called "assignments"
Write a quick definition of what the file is .

3/14

-3 Ring Binder with slide in front and spline
-Page Protectors
- All assignments and other pertinent work executed from MS WORD or Excel,
with Call Outs what was learned.
-Print Screen Shots of your E-Portfolio web pages. Need help with Print Screen
-Print Screen of your video on Teachertube with callouts with comments and number of apples in what date range.

It should have all lessons in prior days below.
Make it Beautiful...

3/12
Watch the Excel video lesson and complete the file:
equivfractions lesson on the MA005 Agenda page

Create a survey monkey account
Try to make up 1 business related question (multiple choice with 4 options)

Take this surevy on BU500 Attitudes

While this is being done... Prof. Stein will take videos of MS Word....

3/5

How to create new pages (my videos)

Assignment:  Create a file **myvideoword1.doc
Explain what you will be demonstrating in Microsoft Word
Show print screens

Topics cannot be duplicated.. All must be registered  (person to be chosen)
Choose from Labs in your Word Textbook....
Choose a simple topic or one that we did...

Make a text box
Picture layout
Create a flyer
Create a portfolio cover with borders and and wordart..

Review the websites of 2 people with Website reviewon your E-Portfolio with a link bar.

How to move assignments

2/29

Do Now:

~~~~~~~~~~~~~~~
Search for an interesting job on Craigs List

Create stationery (with a fake address and fake telephone and correct email)
Write a letter showing interest, some qualifications, state why you would be a good candidates, request a n interview.... File  ** jobcover1.doc (sample)
~~~~~~~~~~~~~~

Go to Microsoft Templates- Downdload a Resume template (job specific if possible).

Rename this file as **qresume1.docComplete this (enter ONLY your email
Write Personal information is available upon request

2/20

Prove that you know Chapter 1 Key Terms - page 1.28
- Create a New Word Document **qkeyterms-  Click the link
- Copy the key terms-
-
- Add screen shots with arrows
- Tell me about some.  each sound file is thenamed **q(term).

Listen to the "A" students

2/15

Links to Cool Things - Translate
Create a business card from Microsoft Templates upload it to the garage.

HW

Create a projject playlist - http://www.projectplaylist.com/

2/13/08

If all work hard... Microsoft Templates...... WOW

Homework - Create a business card

2/08/08 Friday

We watched Sandfantasy
We named the file **sand.doc

2/6/08 Wednesday