Get Flash Player
STUDENTS PARENTS EMPLOYEES COMMUNITY
 

E X C E L

Excel Logo


The Excel training will allow participants to understand how data can be entered into a spreadsheet and calculated. The trainings will cover very basic Excel information such as cell names, rows and columns, all the way through creating formulas using functions. Excel is an essential tool to use in order to do data analysis and to generate reports.

 


 

Microsoft Upgrade
           - Briefing 10167 - Microsoft Office Professional Plus 2010

Videos/Tutorials
        - Excel introduction
        - Basic Math
        - Create Column Titles
        - Let Excel type for you (sometimes)
        - Get more (or less) columns, rows, and spreadsheets
        - Keep column titles in sight as you scroll (Freeze Panes)
        - Prepare to Print

        - VLOOKUP (For Intermediate Excel Users)

General tutorials
School based tutorials

- Introduction to VLOOKUP
- How, and when, to use VLOOKUP
- Using more than one spreasheet with VLOOKUP
- Using absolute cell references with VLOOKUP
- Avoiding VLOOKUP errors

- VLOOKUP
- Advanced VLOOKUP
- Data Matching

 

EXCEL TOOLS/TEMPLATES

TOOL NAME
DESCRIPTION
INSTRUCTIONS
PROGRAM FILE
SAMPLE FILE(S)
CELLA
Splitter
This program processess the CELLA file from File Download Manager and turns it into a more manageable and user friendly file. Download the CELLA Splitter Program and open it. Follow the instruction on the main page.

Sample High School File

Sample K-8 School File

Compiler Tool
This program will compile rows of data from multiple files that have the same single header row into one sheet. Download the Compiler tool and open it. Follow the instructions on the main page. Make sure that each file you're going to compile meets the requirements listed on the main page of the program.  
FCAT 2.0/EOC Pearson PDF to Excel Conversion Tool
This program will allow a user to manage the data that was provided in the Pearson PDF in a simple to use Excel format. Follow the directions in the Export PDF to TXT Instructions, and then download the converstion tool for the appropriate subject and grade level, open it, and follow the instructions on the main page.

Sample Rd.pdf Gr4-8

Sample Read Gr9-10

Student Performance Indicator (SPI) Splitter
This program will get the file that you downloaded from the Student Performance
Indicator (SPI), and it will disaggregate it based on subject and grade level.
The program will also calculate for you the content scores as percentages.
After you have downloaded the Student Performance Indicator file, download and open the SPI Splitter program and follow the directions.
2013-2014 Student Performance Indicator (SPI) Splitter Program
 
VLOOKUP Tool
This program will automacially merge multiple excel files into one sheet, using the Vlookup function. Download the VLOOKUP Tool and opent it. Follow the instructions on the main page. NOTE: the source files must meet the requirements specified in the instructions on the main page or else the progam will not perform correctly.

SPI File
SPI Raw File

Edusoft Grade 5 Science
Edusoft Grade 8 Science
Edusoft Biology

 

EXCEL PROGRAM REQUEST

       Programs are developed to ease the workload and increase the efficiency and
          accuracy of District staff members. If you would like to request a program to
          handle excel files that would help other District staff members as well, please
          contact Nelson Suarez at
NSuarez@dadeschools.net to see if a program can be
          developed.

RESOURCES

      - Enable Macros in Excel

Support

        - Technical Assistance (Email Nelson Suarez)

 

 

 

 


M-DCPS : 1450 NE 2nd Ave. : Miami, FL 33132 : Phone: (305) 995-1000 (For Non Technical Questions Only) © 2017