5-A-Day Scheduling Spreadsheet

Individualized review-over-time is both easy and effective using the 5-A-Day Scheduling Spreadsheet and 5-A-Day Quickprint (part of 5-A-Day Online).  Click the tabs below to view short videos on how to get, setup, and use the spreadsheet to schedule concepts for review, and then how to export the scheduled concept list to 5-A-Day Quickprint to create 5-A-Day papers.

  • It is easy to keep records and plan 5-A-Day review papers using the Math on the Level 5-A-Day scheduling spreadsheet. The scheduled concept lists can be imported into the 5-A-Day Online QuickPrint page to create the review papers.
     
  • Registered owners of Math on the Level (elther from purchasing the curriculum or one of the support packages) can always log in and download the latest version of the 5-A-Day Scheduling Spreadsheet.   On the Setup page, you enter (in yellow-shaded cells) your curriculum version (2nd Edition or Classic), the (non-future) schedule start date, how often per week you want 5-A-Day reviews to be scheduled, and your planning day.  Then assign each student one of six review charts.
     




    Setup page2

    Note: If you have a 2012 copy of the Operations Teaching Guide, enter 2012 next to Operations Print Year; othewise, leave it unchanged.

  • The 5-A-Day scheduling spreadsheet has many automatic features to make your life easier.  You enter the concept numbers and how often each concept is to be practiced, and it does the rest!   The Today's 5-A-Days Page shows the daily scheduled concepts for all students.  Enter a different date in cell G3 or 5-A-Day number in cell G4  (refering to information in column M), or else delete those entries to get back to the default current date.
     
    Entering data into the Review Charts (1-6) is very easy!
    1.  Enter the concept number (1-146) in column A – the information about the concept fills in automatically!
    2.  Enter how often to practice the concept (D, 2D, 3D, 4D, W, 2W, 3W or 4W) in column G – the schedule is created and displayed (blue boxes)!
    3. The Notes column C and R/D (Replace or Drop) column P are optional places to make an entry. 
    Concept numbers are from the Math on the Level Concept Chart and Teaching Guides.  (A copy of the Concept Chart tab is included in the spreadsheet.)

    Entering data2

    Hint: In Row 5, some cells have a small red triangle in one corner.
    Hint1
    Wherever this red triangle appears, you can hover your cursor over the cell to get a brief instruction, as illustrated:

    Hint2
      On the Today's 5-A-Days, Week's 5-A-Days, and Online 5-A-Day tabs (shown below), you can select a specific date, week or chart number, or else leave the entries blank for the default settings (today's date, current week, and Chart1).  Any entry you make in the spreadsheet can be deleted.  The colored rectangles contain information to copy and paste into 5-A-Day Quickprint for easy creation of 5-A-Day papers. 

    Online 5adays

    The colored rectangles have code to copy (Ctrl+c) and paste (Ctrl+v) into the 5-A-Day Online Essentials QuickPrint page using it's "Import from Spreadsheet" feature.  (These colored rectangles also appear on the "Today's 5-A-Days" and "Week's 5-A-Days" pages.)

    Hre is how to import the scheduled 5-A-Day concepts using your 5-A-Day Online Essentials subscription.

    Log in to mathonthelevel.com and click the 5-A-Day Online tab.
    Import1
    Click 5-A-Day Quickprint.
    Import2
    On the 5-A-Day Quickprint chart, click " + Import from Spreadsheet."

    Import3

    Switch to the Spreadsheet and copy (Ctrl+c) one of the colored rectangles on the Today's 5-A-Days, Week's 5-A-Days, or Online 5-A-Days Pages.  

    Switch back to 5-A-Days QuickPrint and click "Paste the data copied from the spreadsheet here."  Now paste (Ctrl+v) the copied information and click Import.

    Import4

    The daily concept list automatically fill the 5-A-Day Quickprint chart. 
    You can change esch concept's difficulty level and delete or add other concepts.
    5aday quickprint chart

  • For easy creation of 5-A-Day papers, subscribers to 5-A-Day Online Essentials can log in and copy and paste the scheduled lists of daily concepts from the spreadsheet directly into the 5-A-Day Quickprint chart.   After concepts are imported or manually entered into the 5-A-Day Quickprint chart, you can change each concept's difficulty level and delete or add other concepts.
     
      
     On the Today's 5-A-Days, Week's 5-A-Days, and Online 5-A-Day tabs (shown below), you can select a specific date, week or chart number, or else leave the entries blank for the default settings (today's date, current week, and Chart1).  Any entry you make in the spreadsheet can be deleted.  The colored rectangles contain information to copy and paste into 5-A-Day Quickprint for easy creation of 5-A-Day papers. 

    Online 5adays

    The colored rectangles have code to copy (Ctrl+c) and paste (Ctrl+v) into the 5-A-Day Online Essentials QuickPrint page using it's "Import from Spreadsheet" feature.  (These colored rectangles also appear on the "Today's 5-A-Days" and "Week's 5-A-Days" pages.)

    Hre is how to import the scheduled 5-A-Day concepts using your 5-A-Day Online Essentials subscription.

    Log in to mathonthelevel.com and click the 5-A-Day Online tab.
    Import1
    Click 5-A-Day Quickprint.
    Import2
    On the 5-A-Day Quickprint chart, click " + Import from Spreadsheet."

    Import3

    Switch to the Spreadsheet and copy (Ctrl+c) one of the colored rectangles on the Today's 5-A-Days, Week's 5-A-Days, or Online 5-A-Days Pages.  

    Switch back to 5-A-Days QuickPrint and click "Paste the data copied from the spreadsheet here."  Now paste (Ctrl+v) the copied information and click Import.

    Import4

    The daily concept list automatically fill the 5-A-Day Quickprint chart. 
    You can change esch concept's difficulty level and delete or add other concepts.

      The Imported Concept List is displayed on the 5-A-Day Quickprint Chart.  Here, you can manually change each concept's difficulty level or add other concepts (by concept number, Teaching Guide, or Concept name) if desired.5aday quickprint chart
    The 5-A-Day settings box lets you choose whether to attempt combining concepts whenever more than 5 concepts are scheduled.

    After you click the Preview button, the 5-A-Day paper with solutions appears.  Here you review the problems, make changes as needed, or leave a problem blank (to write in your own).  
    5aday for Mary
    Then you can view the 5-A-Day paper (with optional solution page) in a web browser for printing, or else you can download them in a pdf file to print later.