MySQL Reference Manual
File title:
MySQL Reference Manual
File content:
General Information About MySQL
What Is MySQL, About This Manual (Conventions Used in This Manual), History of MySQL, Books About MySQL, The Main Features of MySQL, How Stable Is MySQL?, Year 2000 Compliance, General SQL Information and Tutorials, Useful MySQL-related Links.
MySQL Mailing Lists
The MySQL Mailing Lists, Asking Questions or Reporting Bugs, How to Report Bugs or Problems, Guidelines for Answering Question on the Mailing List.
MySQL Licensing and Support
MySQL Licensing Policy, Copyrights Used by MySQL (Copyright Changes), Example Licensing Situations (Selling Products that use MySQL, ISP MySQL Services, Running a Web Server Using MySQL), MySQL Licensing and Support Costs (Payment information, Contact Information), Types of Commercial Support (Basic E-mail Support, Extended E-mail Support, Login Support, Extended Login Support).
Installing MySQL
How to Get MySQL, Operating Systems Supported by MySQL, Which MySQL Version to Use, How and When Updates Are Released, Installation Layouts, Installing a MySQL Binary Distribution (Linux RPM Notes, Building Client Programs, System-speci c Issues (Linux Notes for Binary Distributions, HP-UX Notes for Binary Distributions)), Installing a MySQL Source Distribution (Quick Installation Overview, Applying Patches, Typical configure Options), Installing from development source tree, Problems Compiling?, MIT-pthreads Notes, Perl Installation Comments (Installing Perl on UNIX, Installing ActiveState Perl on Windows, Installing the MySQL Perl Distribution on Windows, Problems Using the Perl DBI/DBD Interface), System-speci c Issues (Solaris Notes, Solaris 2.7/2.8 Notes, Solaris x86 Notes, SunOS 4 Notes), Linux Notes (All Linux Versions), (Linux-x86 Notes, RedHat Version 5.0 Notes, RedHat Version 5.1 notes, Linux-SPARC Notes, Linux-Alpha Notes, MkLinux Notes, Qube2 Linux Notes, Linux IA64 Notes), Alpha-DEC-UNIX Notes (Tru64), Alpha-DEC-OSF1 Notes, SGI-Irix Notes, FreeBSD Notes, NetBSD notes, OpenBSD 2.5 Notes, BSD/OS Notes (BSD/OS Version 2.x Notes, BSD/OS Version 3.x Notes, BSD/OS Version 4.x Notes), SCO Notes, SCO Unixware Version 7.0 Notes, IBM-AIX notes, HP-UX Version 10.20 Notes, HP-UX Version 11.x Notes, Mac OS X Notes, BeOS Notes), Windows Notes (Installing MySQL on Windows, Starting MySQL on Windows 95 or Windows 98, Starting MySQL on NT or Windows 2000, Running MySQL on Windows, Connecting to a Remote MySQL from Windows with SSH, Splitting Data Across Di erent Disks Under Windows, Compiling MySQL Clients on Windows, Windows and BDB Tables, MySQL-Windows Compared to UNIX MySQL), OS/2 Notes, MySQL Binaries, Post-installation Setup and Testing (Problems Running mysql_install_db, Problems Starting the MySQL Server, Starting and Stopping MySQL Automatically, Command-line Options, Option Files), Is There Anything Special to Do when Upgrading/Downgrading MySQL? (Upgrading From Version 3.22 to Version 3.23, Upgrading from Version 3.21 to Version 3.22, Upgrading from Version 3.20 to Version 3.21, Upgrading to Another Architecture).
How Standards-compatible Is MySQL?
MySQL Extensions to ANSI SQL92, Running MySQL in ANSI Mode, MySQL Di erences Compared to ANSI SQL92, Functionality Missing from MySQL (Sub-selects, SELECT INTO TABLE, Transactions, Stored Procedures and Triggers, Foreign Keys (Reasons NOT to Use Foreign Keys constraints), Views, `–’ as the Start of a Comment), What Standards Does MySQL Follow?, How to Cope Without COMMIT/ROLLBACK.
The MySQL Access Privilege System
General Security, How to Make MySQL Secure Against Crackers, What the Privilege System Does, MySQL User Names and Passwords, Connecting to the MySQL Server, Keeping Your Password Secure, Privileges Provided by MySQL, How the Privilege System Works, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification, When Privilege Changes Take Effect, Setting Up the Initial MySQL Privileges, Adding New User Privileges to MySQL, Setting Up Passwords, Causes of Access denied Errors.
MySQL Language Reference
Literals: How to Write Strings and Numbers (Strings, Numbers, Hexadecimal Values, NULL Values, Database, Table, Index, Column, and Alias Names (Case Sensitivity in Names), User Variables, Column Types (Column Type Storage Requirements, Numeric Types, Date and Time Types (Y2K Issues and Date Types, The DATETIME, DATE, and TIMESTAMP Types, The TIME Type, The YEAR Type), String Types (The CHAR and VARCHAR Types, The BLOB and TEXT Types, The ENUM Type, The SET Type), Choosing the Right Type for a Column, Column Indexes, Multiple-column Indexes, Using Column Types from Other Database Engines), Functions for Use in SELECT and WHERE Clauses (Grouping Functions, Normal Arithmetic Operations, Bit Functions, Logical Operations, Comparison Operators, String Comparison Functions, Cast Operators, Control Flow Functions, Mathematical Functions, String Functions, Date and Time Functions, Miscellaneous Functions, Functions for Use with GROUP BY Clauses), CREATE DATABASE Syntax, DROP DATABASE Syntax, CREATE TABLE Syntax (Silent Column Specification Changes), ALTER TABLE Syntax, RENAME TABLE Syntax, DROP TABLE Syntax, OPTIMIZE TABLE Syntax, CHECK TABLE Syntax, BACKUP TABLE syntax, RESTORE TABLE syntax, ANALYZE TABLE syntax, REPAIR TABLE syntax, DELETE syntax, TRUNCATE syntax, SELECT syntax, JOIN syntax, INSERT syntax, REPLACE syntax, LOAD DATA INFILE syntax, UPDATE syntax, USE syntax, FLUSH syntax (clearing caches), KILL syntax, SHOW syntax (Get information about tables, columns,…) (SHOW information about database, tables, columns and index, SHOW status information about tables, SHOW status information, SHOW VARIABLES, SHOW information about connected threads (processes), SHOW GRANTS (privileges) for a user, SHOW CREATE TABLE), EXPLAIN syntax (Get information about a SELECT), DESCRIBE syntax (Get information about columns), BEGIN/COMMIT/ROLLBACK syntax, LOCK TABLES/UNLOCK TABLES syntax, SET syntax, GRANT and REVOKE syntax, CREATE INDEX syntax, DROP INDEX syntax, Comment syntax, CREATE FUNCTION/DROP FUNCTION syntax, Is MySQL picky about reserved words?.
MySQL table types
MyISAM tables (Space needed for keys, MyISAM table formats (Static (Fixed-length) table characteristics, Dynamic table characteristics, Compressed table characteristics)), MERGE tables, ISAM tables, HEAP tables, BDB or Berkeley db tables.
MySQL Tutorial
Connecting to and disconnecting from the server, Entering queries, Examples of common queries (The maximum value for a column, The row holding the maximum of a certain column, Maximum of column per group, The rows holding the group-wise maximum of a certain field, Using user variables, Using foreign keys), Searching on two keys, Creating and using a database (Creating and selecting a database, Creating a table, Loading data into a table, Retrieving information from a table (Selecting all data, Selecting particular rows, Selecting particular columns, Sorting rows, Date calculations, Working with NULL values, Pattern matching, Counting rows), Using more than one table), Getting information about databases and tables, Using mysql in batch mode, Queries from twin project (Find all non-distributed twins, Show a table on twin pair status).
MySQL server functions
What languages are supported by MySQL? (The character set used for data and sorting, Adding a new character set, String collating support, Multi-byte character support), How big MySQL tables can be.
Replication in MySQL
Introduction, Replication Implementation Overview, HOWTO, Replication Features, Replication Options in my.cnf, SQL commands related to replication, Replication FAQ.
Getting maximum performance from MySQL
Optimization overview, System/Compile time and startup parameter tuning (How compiling and linking a ects the speed of MySQL, Disk issues (Using symbolic links for databases and tables), Tuning server parameters, How MySQL opens and closes tables, Drawbacks of creating large numbers of tables in the same database, Why so many open tables?, How MySQL uses memory, How MySQL locks tables, Table locking issues), Get your data as small as possible, How MySQL uses indexes, Speed of queries that access or update data (Estimating query performance, Speed of SELECT queries, How MySQL optimizes WHERE clauses, How MySQL optimizes DISTINCT, How MySQL optimizes LEFT JOIN and RIGHT JOIN, How MySQL optimizes LIMIT, Speed of INSERT queries, Speed of UPDATE queries, Speed of DELETE queries), Other optimization tips, Using your own benchmarks, Design choices, MySQL design limitations/tradeoffs, Portability, What have we used MySQL for?.
The MySQL benchmark suite
MySQL Utilites
Overview of the different MySQL programs, safe mysqld, the wrapper around mysqld, The command line tool, Administering a MySQL server, Dumping the structure and data from MySQL databases and tables, Importing data from text files, Showing databases, tables and columns, The MySQL compressed read-only table generator.
Maintaining a MySQL installation
Using myisamchk for table maintenance and crash recovery (myisamchk invocation syntax (General options for myisamchk, Check options for myisamchk, Repair options for myisamchk, Other options for myisamchk), myisamchk memory usage), Setting up a table maintenance regimen, Getting information about a table, Using myisamchk for crash recovery (How to check tables for errors, How to repair tables, Table optimization), Log file maintenance.
Adding new functions to MySQL
Adding a new user-definable function (UDF calling sequences, Argument processing, Return values and error handling, Compiling and installing user-de nable functions), Adding a new native function.
Adding new procedures to MySQL
Procedure analyse, Writing a procedure.
MySQL ODBC Support
Operating systems supported by MyODBC, How to fill in the various elds in the ODBC administrator program, How to report problems with MyODBC, Programs known to work with MyODBC, How to get the value of an AUTO_INCREMENT column in ODBC, Reporting problems with MyODBC.
Using MySQL with some common programs
Using MySQL with Apache
Problems and common errors
How to determine what is causing problems, What to do if MySQL keeps crashing, Problems when linking with the MySQL client library, Some common errors when using MySQL (MySQL server has gone away error, Can’t connect to [local] MySQL server error, Host ‘…’ is blocked error, Too many connections error, Out of memory error, Packet too large error, Communication errors / Aborted connection, The table is full error, Can’t create/write to file error, Commands out of sync error in client, Ignoring user error, Table ‘xxx’ doesn’t exist error), How MySQL handles a full disk, How to run SQL commands from a text file, Where MySQL stores temporary files, How to protect `/tmp/mysql.sock’ from being deleted, Access denied error, How to run MySQL as a normal user, How to reset a forgotten password, Problems with file permissions, File not found, Problems using DATE columns, Timezone problems, Case sensitivity in searches, Problems with NULL values, Problems with alias, Deleting rows from related tables, Solving problems with no matching rows, Problems with ALTER TABLE, How to change the order of columns in a table.
Solving some common problems with MySQL
Database replication with update log, Database backups, The update log, The binary log, The slow query log, Running multiple MySQL servers on the same machine.
MySQL client tools and APIs
MySQL C API, C API datatypes, C API function overview, C API function descriptions (mysql_affected_rows(), mysql_close(), mysql_connect(), mysql_change_user(), mysql_character_set_name(), mysql_create_db(), mysql_data_seek(), mysql_debug(), mysql_drop_db(), mysql_dump_debug_info(), mysql_eof(), mysql_errno(), mysql_error(), mysql_escape_string(), mysql_fetch_field(), mysql_fetch_fields(), mysql_fetch_field_direct(), mysql_fetch_lengths(), mysql_fetch_row(), mysql_field_count(), mysql_field_seek(), mysql_field_tell(), mysql_free_result(), mysql_get_client_info(), mysql_get_host_info(), mysql_get_proto_info(), mysql_get_server_info(), mysql_info(), mysql_init(), mysql_insert_id(), mysql_kill(), mysql_list_dbs(), mysql_list_fields(), mysql_list_processes(), mysql_list_tables(), mysql_num_fields(), mysql_num_rows(), mysql_options(), mysql_ping(), mysql_query(), mysql_real_connect(), mysql_real_escape_string(), mysql_real_query(), mysql_reload(), mysql_row_seek(), mysql_row_tell(), mysql_select_db(), mysql_shutdown(), mysql_stat(), mysql_store_result(), mysql_thread_id(), mysql_use_result(), Why is it that after mysql_query() returns success, mysql_store_result() sometimes returns NULL?, What results can I get from a query?, How can I get the unique ID for the last inserted row?, Problems linking with the C API, How to make a thread-safe client), MySQL Perl API (DBI with DBD::mysql, The DBI interface, More DBI/DBD information), MySQL Eiffel wrapper, MySQL Java connectivity (JDBC), MySQL PHP API (Common problems with MySQL and PHP), MySQL C++ APIs, MySQL Python APIs, MySQL Tcl APIs.
How MySQL compares to other databases
How MySQL compares to mSQL (How to convert mSQL tools for MySQL, How mSQL and MySQL client/server communications protocols differ, How mSQL 2.0 SQL syntax differs from MySQL),How MySQL compares to PostgreSQL.
MySQL internals
MySQL threads, MySQL full-text search.
Appendix A Environment variables
Appendix B Some MySQL users
General news sites, Some Web search engines, Some Information search engines concentrated on some area, Online magazines, Web sites that use MySQL as a backend, Some Domain/Internet/Web and related services, Web sites that use PHP and MySQL, Some MySQL consultants, Programming, Uncategorized pages.
Appendix C Contributed programs
APIs, Clients, Web tools, Performance Benchmarking tools, Authentication tools, Converters, Using MySQL with other products, Useful tools, RPMs for common tools (Most are for RedHat 6.1), Useful functions, Windows programs, Uncategorized.
Appendix D Contributors to MySQL
Appendix E MySQL change history
Changes in release 3.23.x (Recommended; beta) (Changes in release 3.23.28, Changes in release 3.23.27, Changes in release 3.23.26, Changes in release 3.23.25, Changes in release 3.23.24, Changes in release 3.23.23, Changes in release 3.23.22, Changes in release 3.23.21, Changes in release 3.23.20, Changes in release 3.23.19, Changes in release 3.23.18, Changes in release 3.23.17, Changes in release 3.23.16, Changes in release 3.23.15, Changes in release 3.23.14, Changes in release 3.23.13, Changes in release 3.23.12, Changes in release 3.23.11, Changes in release 3.23.10, Changes in release 3.23.9, Changes in release 3.23.8, Changes in release 3.23.7, Changes in release 3.23.6, Changes in release 3.23.5, Changes in release 3.23.4, Changes in release 3.23.3, Changes in release 3.23.2, Changes in release 3.23.1, Changes in release 3.23.0), Changes in release 3.22.x (Changes in release 3.22.35, Changes in release 3.22.34, Changes in release 3.22.33, Changes in release 3.22.32, Changes in release 3.22.31, Changes in release 3.22.30, Changes in release 3.22.29, Changes in release 3.22.28, Changes in release 3.22.27, Changes in release 3.22.26, Changes in release 3.22.25, Changes in release 3.22.24, Changes in release 3.22.23, Changes in release 3.22.22, Changes in release 3.22.21, Changes in release 3.22.20, Changes in release 3.22.19, Changes in release 3.22.18, Changes in release 3.22.17, Changes in release 3.22.16, Changes in release 3.22.15, Changes in release 3.22.14, Changes in release 3.22.13, Changes in release 3.22.12, Changes in release 3.22.11, Changes in release 3.22.10, Changes in release 3.22.9, Changes in release 3.22.8, Changes in release 3.22.7, Changes in release 3.22.6, Changes in release 3.22.5, Changes in release 3.22.4, Changes in release 3.22.3, Changes in release 3.22.2, Changes in release 3.22.1, Changes in release 3.22.0), Changes in release 3.21.x (Changes in release 3.21.33, Changes in release 3.21.32, Changes in release 3.21.31, Changes in release 3.21.30, Changes in release 3.21.29, Changes in release 3.21.28, Changes in release 3.21.27, Changes in release 3.21.26, Changes in release 3.21.25, Changes in release 3.21.24, Changes in release 3.21.23, Changes in release 3.21.22, Changes in release 3.21.21a, Changes in release 3.21.21, Changes in release 3.21.20, Changes in release 3.21.19, Changes in release 3.21.18, Changes in release 3.21.17, Changes in release 3.21.16, Changes in release 3.21.15, Changes in release 3.21.14b, Changes in release 3.21.14a, Changes in release 3.21.13, Changes in release 3.21.12, Changes in release 3.21.11, Changes in release 3.21.10, Changes in release 3.21.9, Changes in release 3.21.8, Changes in release 3.21.7, Changes in release 3.21.6, Changes in release 3.21.5, Changes in release 3.21.4, Changes in release 3.21.3, Changes in release 3.21.2, Changes in release 3.21.0), Changes in release 3.20.x (Changes in release 3.20.18, Changes in release 3.20.17, Changes in release 3.20.16, Changes in release 3.20.15, Changes in release 3.20.14, Changes in release 3.20.13, Changes in release 3.20.11, Changes in release 3.20.10, Changes in release 3.20.9, Changes in release 3.20.8, Changes in release 3.20.7, Changes in release 3.20.6, Changes in release 3.20.3, Changes in release 3.20.0), Changes in release 3.19.x (Changes in release 3.19.5, Changes in release 3.19.4, Changes in release 3.19.3).
Appendix F Known errors and design deficiencies in MySQL
Appendix G MySQL and the future (The TODO)
Things that should be in 4.0, Things that must done in the real near future, Things that have to be done sometime, Some things we don’t have any plans to do.
Appendix H Comments on porting to other systems
Debugging a MySQL server, Debugging a MySQL client, The DBUG package, Locking methods, Comments about RTS threads, Differences between different thread packages.
Appendix I Description of MySQL regular expression syntax
Appendix J What is Unireg?
Appendix K GNU General Public License
Appendix L GNU Library General Public License
SQL command, type and function index
Concept Index
File type: PDF
File size: 2,363 KB
File url:
http://zid-luxinst.uibk.ac.at/mysql/manual.pdf
INTERMEDIATE EXCEL
File title:
INTERMEDIATE EXCEL
File content:
Introduction, Lists, PivotTables (Elements of a PivotTable, Setting up a PivotTable, Begin building your pivot table, CompletedPivotTable), Data Forms (Using a Data Form, Advanced Analytical Tools), Scenario Manager (Using the Scenario Manager, To view a Scenario), Goal Seek (Using Goal Seek), Complex Analysis: The Solver (Elements of the Solver, Using the Solver, To Run the Solver, To Generate a Report/Printout of the Solution), Macros (Running the Macro/Macro Options, Assigning a macro to a button, Assigning a macro to a short cut key).
File type: PDF
File size: 224 kb
File url:
http://www.lib.umich.edu/hsl/resources/guides/IntermedExcel.pdf
PHP Tutorial - Learn PHP
File title:
PHP Tutorial - Learn PHP
File content:
PHP - What is it?, PHP - What’s it do?, What You Should Know, Tutorial Overview, PHP - Syntax, How to Save Your PHP Pages, Example Simple HTML & PHP Page, The Semicolon!, White Space, PHP - Variables, A Quick Variable Example, PHP Variable Naming Conventions, PHP - Echo, Outputting a String, Careful When Echoing Quotes!, Echoing Variables, Echoing Variables and Text Strings, PHP - Strings, PHP - String Creation, PHP - String Creation Single Quotes, PHP - String Creation Double-Quotes, PHP - String Creation Heredoc, PHP - Operators, Assignment Operators, Arithmetic Operators, Comparison Operators, Combination Arithmetic & Assignment Operators, Pre/Post-Increment & Pre/Post-Decrement, Using Comments in PHP, PHP Comment Syntax: Single Line Comment, PHP Comment Syntax: Multiple Line Comment, Good Commenting Practices, The Include Function, An Include Example, What do Visitors See?, Include Recap, PHP Require Function, Require vs Include, The If Statement, The PHP If Statement, If Statement Example, A False If Statement, If/Else Conditional Statment, If/Else an Example, Execute Else Code with False, PHP - Elseif, PHP - Elseif What is it?, PHP - Using Elseif with If…Else, PHP Switch Statement, PHP Switch Statement: Speedy Checking, PHP Switch Statement Example, PHP Switch Statement: Default Case, Using PHP With HTML Forms, Creating the HTML Form, PHP Form Processor, PHP & HTML Form Review, PHP - Functions, Creating Your First PHP Function, Using Your PHP Function, PHP Functions - Parameters, PHP Functions - Returning Values, PHP Functions - Practice Makes Perfect, PHP - Arrays, PHP - A Numerically Indexed Array, PHP - Associative Arrays, PHP - While Loop, Simple While Loop Example, A Real While Loop Example, PHP - For Loop, For Loop Example, PHP For Each Loop, PHP For Each: Example, Foreach Syntax: $something as $key => $value, PHP - Do While Loop, PHP - While Loop and Do While Loop Contrast, PHP - POST & GET, POST - Review, PHP - GET, Security Precautions, PHP htmlentities Function, PHP - Converting HTML into Entities, When Would You Use htmlentities?, PHP - Files, PHP - Files: Be Careful, PHP - Files: Overview, PHP - File Create, PHP - Creating Confusion, PHP - How to Create a File, PHP - Permissions, PHP - File Open, PHP - Different Ways to Open a File, PHP - Explanation of Different Types of fopen, PHP - File Open: Advanced, PHP - File Open: Cookie Cutter, PHP - File Open: Summary, PHP - File Write, PHP - File Open: Write, PHP - File Write: fwrite Function, PHP - File Write: Overwriting, PHP - File Read, PHP - File Open: Read, PHP - File Read: fread Function, PHP - File Read: gets Function, PHP - File Delete, PHP - File Unlink, PHP - Unlink Function, PHP - Unlink: Safety First!, PHP - File Append, PHP - File Open: Append, PHP - File Write: Appending Data, PHP - Append: Why Use It?, PHP - File Truncate, PHP - File Open: Truncate, PHP - Truncate: Why Use It?, PHP - File Upload, PHP - File Upload: HTML Form, PHP - File Upload: What’s the PHP Going to Do?, PHP - File Upload: uploader.php, PHP - File Upload: move_uploaded_file Function, PHP - File Upload: Safe Practices!, PHP - String Position - strpos, Searching a String with strpos, Finding All Occurrences in a String with Offset, PHP - String Capitalization Functions, Converting a String to Upper Case - strtoupper, Converting a String to Lower Case - strtolower, Capitalizing the First Letter - ucwords, PHP - String Explode, The explode Function, explode Function - Setting a Limit, PHP - Array implode, PHP implode - Repairing the Damage, PHP Date - Robust Dates and Times, PHP Date - The Timestamp, PHP Date - What Time Is It?, PHP Date - Supplying a Timestamp, PHP Date - Reference, PHP Sessions - Why Use Them?, PHP Sessions - Overview, Starting a PHP Session, Storing a Session Variable, PHP Sessions: Using PHP’s isset Function, Cleaning and Destroying your Session, PHP HTML Form Example, Building the HTML Form, Input Fields, Radios and Checkboxes, Textareas, Drop Down Lists & Selection Lists, Submission Button, Retrieving Form Data - Setting up Variables, $PHP_SELF; - Submission, Page Display, Echo Back the Results.
File type: PDF
File size: 1,094 kb
File url:
http://home.comcast.net/~davnlor/davnlor008/php/php_tizag_tutorial.pdf
Microsoft Excel Hints and Tips
File title:
Microsoft Excel Hints and Tips
File content:
Introduction, Starting Microsoft Excel and Opening Files, Making Good Use of the Keyboard, Data Entry and Cell Formatting, Moving Around and Selecting Cells, Making Good Use of the Mouse, Screen Layout, Using Colours and Adding Comments, Cell Referencing, Charts, Printing Tips, Other Tips.
File type: PDF
File size: 106 kb
File url:
http://www.reading.ac.uk/web/FILES/www_File_Library/Microsoft_Excel_Hints_and_Tips.pdf
Creating Electronic Portfolios using Microsoft Word and Excel
File title:
Step-by-Step
Creating Electronic Portfolios using Microsoft Word and Excel
File content:
What to do? Here is the process we will cover:
Collect the documents in electronic form and store in a single folder, Create a list of the artifacts you have collected using an Excel Spreadsheet, Create the Reflective Portfolio in Word.
Stage 2 - Collecting the Artifacts - The Working Portfolio
Hints on collecting your Artifacts:, Create a list of your Artifacts in Excel.
Stage 3 - Selection, Reflection & Direction - The Reflective Portfolio
Set up the portfolio demonstrating your chosen standards, Copy the Performance Indicators into document, Create Navigation Headings with the Outline View, Using the Document Map, Using the Style Menu, Change the Paragraph Style to Create Page Breaks, Write Reflections on Each Standard, Create a Table of Contents.
Stage 4 - Add hypertext links - The Connected Portfolio
Scanning directly into a Microsoft Word 2001 Document.
File type: PDF
File size: 940 kb
File url:
http://ali.apple.com/ali_media/Users/147/files/others/stepbystep_WordExcelEPs.pdf
Microsoft Excel 2007
File title:
Microsoft Excel 2007
File content:
Things to Note – Data Types and Formulas
Entering Data, Data Types, Formulas.
MS EXCEL 2007 - New Interface
Arrangement of Tools in Excel 2007, MS OFFICE BUTTON, QUICK ACCESS TOOLBAR, RIBBON TABS (Tool Groups, Dialog Box Launch Arrow).
Getting Started
Start a new Workbook, Open an existing Workbook, Open a file from a different version or format, IMPORTANT NOTES: Saving Documents in Excel 2007, Save the current Workbook OR Save the Workbook as a different name - version - or format.
Formatting Data
Insert Data into a cell
Home Tab - Font, Alignment, Number & Cell Groups
Insert more Cells into a Sheet, Change the Type of Data within a Cell or cells (Ex: increase decimal places), Change the Font of the Data in a Cell, Change the Alignment of the Data in a Cell, Format Cells Dialog Box - (has not changed from Word 2000, 2003), Format the Borders of Cells, Format the Column Width or Row Height of Cells, Move a cell(s), Merge Cells Combine several Cells into 1, Automatically fill Data Cells, Sorting Data.
Formulas - The Formula Bar & Functions
To begin a Formula:, Functions & Operators for Formulas, AutoSum Automatically Sum your Data.
Creating and Formatting Charts
Inserting a Chart from Data, Chart Tools Tab: (Design Tab, Layout Tab, Format Tab), Creating a Chart Step 1 Choose / Change a Chart Design.
Creating a Chart - Steps 2 - 4
Creating a Chart Step 2 Data Range, Creating a Chart Step 3 Chart Location, Creating a Chart Step 4 Labels (Chart Titles, Axis Titles, Gridlines, Legend Position, Background), Stretching the Chart.
Formatting Elements of a Chart
Formatting Axes Change the Pattern, Scale, Font, Number Type, and Angle of the X and Y Axes. Of these, the most important is the Scale of the Axes, Formatting a Series of Data Change the appearance of a Data Series Line and its Markers, Display and Format Data Labels Show the Data Values Data Labels The X or Y values can be displayed next to each Data Marker in a Series Line.
Charts - Error Bars and Trendlines
Adding Error Bars to a Series of Data Error Bar A small line extending from each Data Marker that represents the potential error of your data, Creating Trend Lines and their Equations Trendline The line that best represents the average of your data points. Excel can provide an equation for the Trendline.
Printing
Set the Print Area of a spreadsheet, Preview the print-out.
File type: PDF
File url:
http://www.sfg.uvic.ca/assets/pdfs/excel-handout07.pdf
File size: 1411 kb