Netiva Caftori CS-109 Fall 2007

The 1st 5 assignments you can email to neiu109@gmail.com.

The 8 assignments will include the following: Assig. 1: A scavenger hunt: at NEIU (due on the 3rd week), and another Assig. 2: scavenger hunt on the Internet (due on the 5th week). Assig. 3: Using WORD create a semester calendar in a table mentioning all your courses, exams, and other activities. Your weekly time schedule will be using Excel (due on the 7th week). Also keep your own assignments' scores on a spreadsheet. Assig. 4: A web page using html (due on the 9th week). Assig. 5: A database file using Access (due on the 13th week). Assig. 6: A paper using Word (due after your presentation) Note that your readings or presentations' summaries (due on a weekly basis.) plus a semester schedule in a table are also using Word. Assig. 7: A program using Alice (due on the 15th week) Assig. 8: A movie from your field trip on YouTube (due on the 16th week)

Grading philosophy

• 8 Assignments including a final paper will count for 50% of your grade.
• 1-2 exam/s will count for 10-20% of your grade.
• Journaling or blogging (your weekly summaries) will count for 10%
• Class presentation will count for 10%
• Participation in class will count for 10%

Excel assignment

Weekly time-tracking worksheet:

1. Follow the worksheet example (above) and duplicate it on your Excel sheet using your own activities.
2. Add a Total column for your estimated times.
3. Use the Sum formula.
4. Track down your activities for a full week and create the 2nd Actual sheet.
5. For the Estimated-Actual, use a formula again to do the substraction.
6. Also use formulas to calculate the weekly totals.
7. Include a conditional statement somewhere (e.g., "if I sleep more than 60 hours a week...").
8. Include the system date using the now() function.
9. Shade all labels and headings.
10. Add a percentage somewhere, such as the percent of time you sleep or do homework out of the total.
11. Create a chart following a row and a column of your sheet (line or pie chart).
12. Send the finished sheets and charts to neiu109@gmail.com

To return to Dr. Caftori's Home Page, or

To return to CS-109 Main Page.

Textbook

1. Alice by Gary B. Shelly and Tom J. Cashman
2. NEIU FYE textbook.

Lab Hours

All open labs are open

• 8am to 10 pm Mon through Thur;
• 8am to 6pm on Fri,
• 8am to 1pm on Sat, and
• 1pm to 5pm on Sun in Library 4th floor lab only.

Word and PowerPoint assignments

Your weekly readings should be summarized into a paragraph or a list of the most important points covered by the article read. These readings will be discussed in class and periodically I will grade the summaries. In your teams you'll work on a chosen topic, go on a field trip, and each team member will write a short paper using MS Word. The paper will be based on some read article related to your team topic. In your team presentation you may concentrate on your paper or the field trip conducted. Starting in mid-term (7th or 8th week of class) teams will present to the entire class using PowerPoint presentation tool on the topic worked on.

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.
11. An alternative to printing these 10 printouts is to email your db file as an attachment to neiu109@gmail.com

Return to N. Caftori's Home Page

Write an to n-caftori@neiu.edu for any question.

Send comments about Netiva Caftori at n-caftori@neiu.edu

Last updated 2/14/09