Home Explore Computers and Technology for Mathematics

# Computers and Technology for Mathematics

## Description: Computers and Technology for Mathematics

### Read the Text Version

Lesson | 5DatabaseActivity 1: Scientific Notation Activity 5: Probability ■ Work with the Navigation Pane ■ Apply Number Formats ■ Open and Close Objects in a Database ■ Use Functions ■ Move through a Datasheet or Form ■ Common Functions ■ Switch between Views ■ Choose a Theme in Office 2007 ■ Enter Records ■ Apply Cell Styles (Quick Styles) ■ Create a Table in Design View ■ Add Color to Cells and Cell Data in ■ Rename a Field in a Datasheet Office 2003Activity 2: Comparing Quantities Activity 6: Using Databases ■ Use Multiple Sorts ■ Change Column Order ■ Sort Records in a List ■ Remove a Sort ■ Rules for Sorting ■ Create a Query in Query Design View ■ Choose Fields for a Query Activity 7: Sorting a Database ■ Sort Records in a Query ■ Criteria in a Query ■ Plan a Database ■ Display the Query Datasheet ■ Create a Database ■ Create a Table in Datasheet ViewActivity 3: Making Comparisons ■ Save Changes to a Table Design ■ Create a Query with Wizard Activity 8: Managing Money ■ Format Data ■ Sort Records in a List Activity 9: Comparing Costs ■ Rules for Sorting ■ Enter a Formula Activity 10: Calculating Distances ■ Change Column Width ■ Chart Basics Activity 11: Proportional Relationships ■ Create Charts ■ Add a Legend ■ Draw Objects ■ Resize and Move ObjectsActivity 4: Organizing Statistics ■ Work with Placeholders ■ Add Slides to a Presentation ■ Filter for Entry ■ Change Slide Layout ■ Create a Report with the Report Wizard ■ Use Rulers, Guides, and Gridlines 147

Activity | 1Scientific NotationPractice Activity Technology Overview A database program is a useful tool in which to store and organize large amounts of data. You can even perform calculations with the data. In this activity, you will edit a database by adding information you locate on the Internet. Then, you will convert the numeric data into scientific notation. Finally, you will create a report of the information. Content Overview Scientific notation is a method of representing a num- ber as a decimal between 1 and 10 multiplied by a power of 10. It can make numbers that are very long much easier to write and work with. In this activity, you will convert the atomic masses of several elements from the periodic table into scientific notation.TERMS Field properties Characteristics of a field thatDatabase file The file that contains all objects of determine how long an entry can be, how the entry will be formatted, whether there should be a default your database. entry, and what can be entered (for example, num- bers only or valid dates only).Datasheet A grid showing the data in a table, with Form A window showing the data in a table with one the field names as column headings and the records in rows beneath them. record’s fields appearing at a time in individually labeled boxes.Datasheet view The view of a table that shows Navigation mode A mode in which the entire field you the data in each record. Like a spreadsheet, the datasheet shows rows (records) and columns entry is highlighted in a selected field. (fields). Navigation Pane The listing of all the objects inData type The type of data that a particular field is the database. designed to hold. Common types include Text, Number, Date, and Memo. Object A table, form, query, report, or other itemField description An optional brief comment or used to store and manage data in a database. explanation of a field. The field description appears Table A collection of database fields designed to be in the status bar at the bottom of the window when its field is selected. used together.Field Edit mode A mode in which the insertion Table Design view A view in which you can add, point displays in a selected field. edit, and delete fields from the table, change field types and descriptions, set a primary key, and more.148