To Exam Info

Review Guide for Final

Bring to Final

• One page of crib notes with writing on both sides.

You may use the following on the Lab computers:

• Excel    Alice

Exam Format

• Short Answer; Short Essay; Computer Problems. It is not enough to create filters or queries with Access. You must also write the requested output or grid by writing on the output.

Study

• Course Notes, especially Review Questions at the beginning of each lecture.

• Activities, Homeworks, Final Exam Review Questions.

Measurement Units

• Original and current definitions of the meter, second, and kilogram, proportional units, units analysis, logarithmic units, Richter scale, decibel.

Database/Access Definitions

• Database, table, row, column, field, three database rules, primary key, repeated group, data anomoly, foreign key, database normalization, filter (could include sort), relationship, one-many relationship, referential integrity, query, aggregate query, trick to change detail query to aggregate query, group by, report.

Positional Number Systems

• Positional number system, base (binary, decimal, hex), bit, hex digit, ASCII.

Objects/Algorithms/Alice Definitions

• Alice windows (World Window, Object Tree, Details Area, Editor Area, Events Area), object (world, camera, from Local Gallery), property (color, isShowing), method (move, turn, roll, resize, say, think, user defined), event (When the world starts, When a key is typed, Let the mouse move), functions (world.choose true probabilityOfTrue of the time, world.random number, what as a string), structured programming (sequence, repetition, decision), Alice constructions (Do in order, Do together, If/Else, Loop, Wait).

• The dot operator indicates a relationship of belonging. For example, coach.turn meanss that the turn method belongs to the clock object. chicken.LeftLeg.isShowing means that the isShowing method belongs to the LeftLeg and the LeftLeg belongs to the chicken.

• world.random number means that the random number function belongs to the world. However, the world object can (by convention) be left off for the world; random number means the same things as world.random number.

Be Able To Do These Problems

1. Convert from one set of units to another, use units analysis to show that your calculations are correct.

2. Convert from intensity to Richter scale for earthwquakes and from intensity to decibels for sound. Also be able to go in the opposite direction for each.

3. Create the following in Access: table, filter/sort, relationship, query.

4. Add rows to an Access database.

5. Remove rows from an Access database.

6. Modify the design of an access table in Design View, including adding columns, changing the name of a column, changing the datatype of a column, adding or removing a primary key, adding a primary key that includes multiple columns).

7. Import an Access table from Excel.

8. Normalize a database table by eliminating repeating groups.

9. Normalize a database table by eliminating data anomolies.

10. Create an Access report from a table or query.

11. Convert from a positional number system to base 10 for the bases: 2 to 9 and 12.

12. Convert from binary to decimal.

13. Convert from binary to hex and vice versa.

14. Convert a text message to binary ASCII and vice versa.

15. Add an Alice object from a gallery to the world.

16. Reposition or resize an object using the IDE.

17. Modify the color and isShowing properties of an object.

18. Add a user defined method to an object.

19. Use world function world.choose true probabilityOfTrue of the time.

20. Set up an event a method when
    1. the world starts,

    2. a keyboard key is typed,

    3. an object is clicked.

21. Change the value of a property in a method.

22. Reposition or resize an object in a method.

23. Look at the methods and event handlers of an Alice world and explain what the application will do or answer other questions about the application.

24. Implement an Alice world (of appropriate difficulty) using the computer.

25. Explain what a written Alice method does.

26. Determine how many times an object repeats an action when nested loops are present.

27. Have an object say or think how many times the object repeats an action when nested loops are present.

28. Use the formula 1 - (1 - p)ⁿ to determine the probability that an event will occur (see Review Question 5 of the 11/16 Notes).