Cs-100

Assignment 2 Assignment 3 Assignment 4 Assignment 5 Assignment 6 Assignment 7 Assignment 8 Assignment 9

At any time you may do some

Extra credit assignments:
such as:

• solve the Word hunt as described in chapter 2, page 45-46. Email me to n-caftori@neiu.edu.

  Visit the Science and Industry Museum Write a summary from what you saw in the Internet exhibit.

• Some project you have in mind first discussed and approved by me.

Write to n-caftori@neiu.edu to your teacher.

Assignement 2

• the impact of computers on your life (future, present, or past).
• your knowledge at the moment about IT (Information Technology) around the world,
• the usage of drugs and alcohol from your own experience or knowledge, or
• Your first time impressions at Northeastern.

You may also get inspired by topics mentioned at the end of Chapter 1 in your text, news topics discussed in class, or some that you found during the scavenger hunt in your 1st assignment.
You may also include a paragraph about yourself with a picture so I get to know you better (1 pt).

• Please include references if you've used any from the web or elsewhere (1 pt).

Use Spell-Check and Grammar-check to make sure you don't have any mistakes before you go for your appointment at the writing lab, or before turning it in.
Also use the Thesauraus when you have repeating words to improve your vocabulary.

Check Word 2003 and 2007 techniques to see some parallels between the 2 versions.

Employ as many of the features (a bout 1 pt each) of Word learned such as

1. A table
2. Header and footer (maybe your name on each page)
3. Different formats...e.g. page number
4. borders, or shading
5. Clip Art insertion and resizing (show same picture in 2 different sizes)
6. Newspaper columns: Make sure that only one paragraph is in columns. For this you need to highloght a paragraph already written and then start columns.
7. Bullets
8. Change the spacing mid-way
9. Insert the system date
10. Include footnotes or endnotes
11. Draw lines or arrows
12. Rotate text by inserting a text box, writing in it and rotating it.
13. Word Art
14. Watermarks
15. Create a table of contents with your essai or by using your first assignment as text and adding the table of content.
16. Track changes: turn in the excercise paper you did with your teammates showing the changes you each inserted in different colors.

As with assig. 1 you may turn in this assig. online to the grader at neiu100@gmail.com (recommended) and turn in to me your Writing Lab receipt after your visit there (hopefully you will get an appointment there early enough). In addition, to make sure this was done on time, turn in this assignment again on Blackboard, under assignments, either pasted into the comment field or attached.

This assignment is out of 40 points, the last 2 item earning you more points.

Return to N. Caftori's Page

Write a note to your teacher.

Assignement 3

Make sure you

1. Have a title and your name
2. Label all columns and rows
3. Create at least 2 or three rows and columns of numbers.
4. Have totals (or differences) displayed at the end of each column and row.

Spell check before turning in your assignment.

You should

1. Format numbers two different ways (with or w/o $ sign for ex.).
2. Display the date (using the NOW() function)
3. Calculate the percentage of a number from the total on its row or column. The percent should be under 100%.
4. Construct 3 graphs (pie, bar and line), depending if the range is the whole spreadsheet, or just a row or a column.
5. Change the width of a column or two
6. Change the height of a row or two
7. Use the IF function to warn you when your expenses are over the budget (for ex., IF TOTAL>1000 then Watch it!, otherwise you are under control...)
8. Format your column headings and title and center them.
9. Format the Totals row and/or column with lines or shades.
10. Besides a regular printout turn in a cell-formula printout.
11. Print also a section of your spreadsheet by using the page setup under the File menu.

It is preferable that the contents of the spreadsheet be on a topic involving computers in society: maybe some statistics on computer usage by ethnic groups, etc.

Note that altogether you need to turn in 3 printouts unless you send the whole spreadsheet to the grader. Consider changing the printout to landscape from portrait if the chart doesn't fit on a page.

Return to N. Caftori's Home Page

Write to your teacher.

Assignement 4

Use the data-base program MS Access to create a db-file of your choice.

Examples:

Make sure you include at least 4 fields: numeric, character, date and logical (y/n). Create queries so that you

1. List your table in the order created.
2. List your table w/ fewer fields.
3. List your table in alphabetical order (or opposite order than in #1).
4. List it in numerical order.
5. List only those records where the date is beyond a certain date (e.g., all people born after 1981).
6. List only those records whose logical field is YES (e.g., all married people among your friends)
7. List the records whose numeric field is between 2 values (e.g., all friends who are between 17 and 25).
8. Print a graph of your data base file (e.g., ages of your friends vs. their names on the x-axis). Do it using a form, or Excel.
9. Calculate a total or an average of all numeric fields as appropriate (you may include this within a report, as in #10.)
10. Print a report.

Return to N. Caftori's Home Page

Write to your teacher.

Assignement 5

Assignement 6

Topics I'd like you to concentrate on should be related to computer security, ethics, clowd computing and social media as it is used in business today.

Examples from previous semesters include:

Digital technology Drug abuse prevention Internet shopping addiction Computer innovators Computers and homelessness. Computers and Hospitals Viruses by Ana, Angelica and David. Asian technologies by Bing, Ti, and Moh. Gaming

Perl language Video games Social Networks Robots Hackers EMP from CS460 Chcago Gaming Industry History of computers Network security

Drugs and you Syndication Today's computers Evolution of personal computers Internet Statistics Wireless IT in Africa Wireless security Security

Jamaica Music by Matt, Nathan, Eric and william Communication and social network by Elisa, Mariam, Carolyn, and Leona.

Old presentation like the one by Hafija and a friendship example by Neha, are no longer allowed.

Come up with an idea of your own after consulting with me,

Assignement 7

Create a blog using one of the choices of servers suggested. Write about where you see computers used in Chicago, and ask a question so you may get an answer from someone.

Assignement 8

Download Alice from alice.org, review the 4 tutorials and design your own short program.
Instead, just for fun, you can download Game maker onto your computer and design your own game.

Alternatively if you choose, write a program using the BASIC programming language QBASIC, or Micrsoft Quick Basic, or any other of your choice.
In which case:

Check the Sample Program first.

Draw a flowchart to help you design the program.

Your program is to

Read (or input) student records: Name (N$), 4 grades (G1, G2, G3, G4).

Calculate student's Average (A1)

From the average, figure out the student's rank (R$), i.e., decide if the student is

on probation (A1 smaller than 2.5),

Honors student (A1 greater than 4), or

normal (otherwise).

Write out (or output) Student's name, average and rank.

Input:	Name	4 grades
Output:	Name	Average	Rank

Assignement 9

Extra credit: Talk to me about an idea not yet expressed here.

Return to N. Caftori's Home Page

Write to your teacher.

Last updated 12/20/10