CorpusRecord 76080

Federal Program Compliance Division Smartsheet WorkApp Overview Training Video - December 2024

A searchable transcript preserved as part of the Discourse Corpus. Passage numbers provide stable references within this record; verify quotations against the original recording when available.

Source
YouTube / Texas Education Agency
Date
2024-12-18
Location
McLennan County, TX
Material
Transcript
Extent
4,679 words · about 26 min
Collected
2026-06-08

Transcript

Verbatim source text

001hello and welcome to today's General TAA work app training brought to you by the federal program compliance FPC division at the Texas Education Agency tea the objectives of the general smart sheet ta work app training are to understand the purpose of the smart sheet work app review the role of the Federal program compliance division review the process for gaining access to the TA work app and to demonstrate how to navigate through its General features first let's start by understanding what smart sheeet is and what it's used for at tea smart sheet is a project management software app that has customizable spreadsheet-based capabilities that resemble that of Microsoft Excel or Google Sheets ta uses smart sheet to plan organize and collaborate on multiple projects create and track reports and to collect and analyze different sources of

002data between various organizations and across multiple programs the use of smart sheet capacities can vary among ta departments once a smart sheet file is created the work app platform will allow for users added to collaborate on view and or upload a variety of data elements and content that could be shared with different stakeholders who aren't daily users of smart sheeet work app tiles like those pictured on this slide are where local education agencies leas and education service centers es can submit or view required documentation for various programs administered by the FPC at tea if you are new to the world of federal programs one of the essential components you will become most familiar with is that of the federal program compliance division the FPC is only one division of the Department of Grant compliance and

003administration GCA at tea this office is tasked primarily with administering the compliance functions of most of the programs under the every student succeeds act Essa which include Title One Part a title one part C Title One Part D title 2 part a title 4 part A funding transferability reap RIS usco and PNP if you would like to learn more about the FPC or these programs then please visit our website as shown on the screen now let's review how to either gain or remove access to the tea work app for your Lea or ESC whether you are part of an Lea or ESC you must ensure that you have the appropriate access to navigate through the TA work app please note that Lea or ESC staff submitting and or viewing documentation for the Federal program compliance

004division will first need to be added to the Department of Grant compliance and administration work app managed by tea currently only the superintendent Chief Financial Officer and or federal program director responsible for implementing respective programs listed in asked head have been given access to the te workout or your Lea and the executive director Chief Financial Officer selective Administration staff and or federal program person at your ESC may have access please note that each Lea and ESC is only guaranteed a certain number of access Accounts at this time however additional users may be granted access by submitting an access request form to TAA take caution in making sure that the email provided to TA when submitting a request for Access is professional in nature if submitting as an independent consultant and or is a work issued

005email associated with an Lea or ESC as no personal emails will be accepted if you require access then you must ask individuals at your ESC or Lea Who currently have access to Tea's workout and have them enter the Eder connect workout to complete the appropriate steps to submit a grant access approval request ta will be alerted of the new request for Access and will process the request within 3 to five business days ta will then send the app applicant an email with instructions to complete a new user certification form upon approval of access users will be emailed their credentials you must use them to create a smartsheet account and take caution that you create the account using the credentials sent to you by tea to gain access to the work app you will not need

006to buy a license to access any of the TA work app tiles but you may do so if you wish to use the smart sheeet platform itself if the individual you are wishing to add does not have access after five business days please submit a help form using the Edgar connect help form located within the Edgar connect work app similarly if you need to remove access for someone at your ESC or Lea you must also complete the appropriate steps to submit a request to remove access by completing the steps found on the Edgar connect workout now that we reviewed how to gain access to the TA work app we are ready to move on to actually working in the work app environment once the appropriate staff has been granted access to the TA work app

007and your login credentials have been emailed to you you will need to complete the following steps to begin working in the work app platform first log in to the Department of Grant compliance and administration work app platform using the link provided on the screen and the credentials email to you when you were granted access various sign-in options to view information applicable to your Lea or ESC should be provided to you as noted on the screen but you want to sign in using your assigned tea work app credentials I will now demonstrate how this will look on the work app platform website I have used the link shown in the search bar and have logged in once you log in you will see the homepage of the smart sheet TAA work app platform that may look

008like this make sure that you have selected the work app icon that resembles a baseball diamond with a runner on First and that the filter is set to share it with you or shared with me to be able to see work app tiles for programs for which you have access access to applicable to your Lea or ESC and note that you will only have access to workout tiles that have been shared with you by tea FPC staff if you find that you need access to workout tile after following these steps please submit a help desk ticket to process a request for Access I will review how to do so later on in this training I would like to to point out some features located on the homepage of the TA work app on the top

009left side of your toolbar you will see a smart sheet icon and a work app icon you will more than likely only have access to the work app tile as those with smart sheet access are limited to TA staff or anyone who has purchased a license a smart sheeet license is not needed to view ta work app tiles if you have been granted access by tea at the bottom left corner of your screen you will also see a help icon with a question mark and right below it a sign out icon on the top right of your screen you will also see a bullhorn feedback icon if you submit feedback know that ta will not directly receive it this feed Fe back will go directly to the people who work for smart sheet you may

010notice that to the left of the feedback will horn icon you see a create app icon on my screen only ta staff will see the create app button on their screen you will have access to a search button to search tiles by program name within this filter selected the filter button that I mentioned previously and a recently updated button that can display the newest work app tiles available or display the work app tiles in alphabetical order if ta asks your Lea or ESC to submit documentation for a specific program you must select a corresponding work app tile located within the TA work app for that program for demonstration purposes we will use the FPC work app demo tile to showcase the general functions and common features of the TA workout I will need to switch

011my filter back to all in order to do this but remember you will need to set your filter to shared with you or shared with me to be able to see those workout tiles applicable to your organization and your level of access after clicking on the work app tile for which you must submit documentation or view information you will see a screen that displays information under different views common views are Lea View and and ESC view to the left of your screen available views will depend on the access that was granted when your logging credentials were emailed to you by tea certain work app tiles for certain federal programs may also contain a viewing feature for Fiscal Agent the views for both fisal agent and Lea view are similar I will demonst rate features of

012all views for this training but we will begin with features in the Lea view to view information available for any of the views for which you have access you can click on the links shown under your view the number of links will depend on what documentation ta will ask for you may see multiple links just one link or none in this case there are four different links for this particular view for which information can be submitted or viewed to the right of the links you will see a ribbon line under the column Federal fiscal year note that the column names and headings may vary by program when hovering your cursor over the ribbon line you will see that it turns a light blue color let's explore some of the features available to you on this

013screen there is a filter feature that will allow you to filter through information available to you for a specific program if you click on the filter button you are able to create name and use a filter if you choose to sort through the information of available in the work app tile this feature is especially helpful to those of fiscal agents or esc's as they must handle multiple programs for leas and the filter button will help sort the information available quickly in this case I have already created a filter I have named my filter I have have selected the information I wish to look for and have set my filter and criteria and I want to find out how many and which leas under program type are in or independent districts or leas I will apply

014my filter and I will see that the results are only giving me those leas that are independent districts under the program type you are able to set up and edit a variety of different filters and turn them on or off simply by clicking on the filter button there is also a formatting button that displays how information was entered by staff within smart sheets but you may not find it very useful for example if certain data was highlighted within these cells the format button would show this to the right of the formatting button you will see a WRA text button that will will slightly change the appearance of information in the drop-down under the column Fields the WAP text button may help to view information more easily as it wraps the text and expands the ribbon

015line for each column to show the data for certain programs a download button may also be available I will demonstrate its use under a Fiscal Agent view this button allows users to export data to a CSV file you will be able to download save edit and print the file in Excel format this information available in this download feature will only be information that is within the system and that has been entered by tea staff it will not download new information that leas or fiscal agents will enter into the workout so what you see in this file is information found within the ribbon lines in the work app that has been preloaded note that the option is not available under all VI use or to all users it's only available for certain programs and mainly accessible

016to esc's and fiscal agents I want to point out that if you're viewing data for the column under program type fiscal agents will see program types listed as fa for Fiscal Agent or meem for member districts that may be part of an SSA or shared service arrangement for program type under Lea most will read IND or independent districts or leas not part of an SSA if you move your cursor over the columns over the ribbon lines you will see an icon that will allow you to click and drag the size of each colum containing information to the left or right at the bottom of the screen you also see a scroll button and if this screen contained multiple data all the way down along the page you would see a scroll button to the right

017that would allow you to scroll up and down as well the scroll button at the bottom may disappear if the columns are set for a certain way but you can easily bring it back as you see here by stretching out the columns you can also adjust the width of the links to the left under the views to read the titles of these links in its entirety if needed column headers with information displayed will vary by program so what's visible in this demo work app tile May differ when viewing data for your specific program however all programs should contain the column that reads data collection status with two options shown either open or closed if the status is set to open by ta staff then users may still enter and upload documentation and data for those

018programs if the status is set to closed then the deadline to submit information for programs has expired and no information can be entered or accepted I will demonstrate the closed data collection status later you may notice that at the top right of my screen there is an addit edit app button you will not see this feature on your screen to the right of the title program work app name you will see a little I icon if you click on the eye a panel with additional information related to the program link appears with a description information contained in this window can vary by program it may just contain a title instructions or just additional information and for any window that pops up within the work app tiles if you hold your cursor on the edge of

019the window you are able to stretch out or adjust the width of that window so that you can view information or directions in its entirety now let's view the functionality of entering data in the details data entry tab when you click on the Blue Ribbon a data details entry tab appears for any of the details data entry windows that may appear you may see a data tab or an attachments tab you will notice that some fields are grade out grade out fields are read only for data elements and information that cannot be edited unless specified you will be able to enter information if the fields are not grade out and if red Asics appear by the field boxes that information is required and must be completed to be saved you will be able to scroll

020down through the data details entry tab to either enter or view information submitted leas and fiscal agents are usually the only users that will be able to enter information esc's will only usually be able to view view information submitted by leas unless they are asked to submit documentation for a certain program or its requirements if the save button is grayed out or inaccessible and not seen once you have finished entering data that means that a required field is missing information so I'm going to begin entering information in the fields so that the blue save button appears a blue saved button indicates that all required Fields have information and that you are able to save that information you will notice that I have entered information and now the save button appears but it's not blue that

021means that there is still fields that are required that have not been filled out and in order for this save button to turn blue I have to make sure that all the information that is required is entered so the save blue button here now appears I have worked through all of the cells in my details data entry Tab and if I were to save this blue button that would indicate that the information that I just entered will be saved by the system some Fields may have autoc calculated sums these sums will not calculate as you enter the information they will self- calculate after you save and submit the information by clicking on that blue saved button then clicking the X on the details data entry tab window and then Rec clicking on the ribbon line

022to reopen the details data entry Tab and then this self-c calculation here will appear I'll do that in just a few moments because there's other things that I want to point out that you may see in your details data entry tab panel window again I want to point out that as you're entering information the work app will not automatically save your work if you are entering information for an Lea or a specific program you may see a field that is required that reads Lea submission status with dropdowns that say submission pending not started in process saved some data will appear later or complete later and submission complete data entered and documentation attached usually the status is defaulted to submission pending not started as you see here after entering data make sure that your selection for

023the status has been changed to either in process or submission complete because if it's left as submission pending not started even though you have entered the required information ta will not recognize or accept or even consider submissions completed until that submission complete button is selected so for demonstration purposes let's say that I'm going to go ahead and select the in process because I'm not quite sure that I have all of my documentation and I want to make sure that I come back to it if I need to so I'm going to select in process we complete later once you see this green check mark here that means that any data that you have entered has been saved we're going to go ahead and click back into the ribbon line to see that any information that

024I entered before previously has been accepted and it'll appear here notice that none of the red asterisks are there in the required fields that they appeared in before however I mention that if you have gray Fields you will not be able to edit that information but if the fields are not grayed out you will be able to enter or reenter information here so everything looks complete the calculations that were entered previously have self- calculated here as I mentioned before everything looks correct I'm going to go ahead and select my submission Complete because I have completed all of the fields and I'm satisfied with the documentation that needs to be submitted if for some reason you're working through this um and you need to discard any changes or make any changes as you're working and you

025want to clear out all of the fields for which you have entered information you can click this discard changes button and it'll clear all of the information that you previously entered for each and every field or again if changes need to be made you can individually click on the fields if they're not gr out to make those changes and again it's very very important that if you are submitting information for any leas esc's or fiscal agents that this submission status is set to submission complete or saved and submitted in order for your program documentation to be accepted and considered closed out um by te8 so we're going to click on this blue saved button the green check mark appears indicating that the information has been saved I want to make sure that it has and

026once the saved and submit button has been clicked you're going to notice that in most instances all of the fields will be gray out and will not be able to edit any of these fields that will be for most programs okay so one of the very common requests entering data under l VI may contain is the attachments tab for certain programs this tab may appear to the right of the data details entry tab the attachments tab will allow viewers to either upload or view any file attachments that have been entered into the work app for this program if you are asked to submit documentation then you must submit the requested documentation in PDF file format all documentation should be attached as a single file unless otherwise specified please note that there is a size limit

027of 30 megabytes per file and attaching documentation is required for those submitting documentation if we click on the attachments Tab and the blue attach a file button appears in the details tab window at the bottom to attach the PDF file containing the Lea's or phisal agents documentation click on this attachments tab on the details form then click on the attach file button located at the bottom of the form browse your computer and locate the documentation file to be attached from wherever you saved it select the file and in the file name your file name will appear click on the open Tab and if that document appears in the attachments tab as you see on the screen then that confirms that the file was selected and saved okay and again if we want to make sure

028that it appears there it was Zero before and it's been saved and timestamped if you need to submit multiple documents then you can do so as long as that blue attach a file button still appears here just take note and take caution that again the files uploaded must only be 30 megabytes in size at most I do want to remind you to take great care when uploading any attachments because once an attachment is submitted you will not be able to delete it deleting an attachment can only be done by submitting a help form to TA FPC staff and I will review how to submit a help form a little later on once you are done either submitting or viewing information within the work app tile you click on the X at the top right corner

029of the details form and we will continue exploring some of the features under the laa View the first link here reviewed a regular data submission that's very common in the details data entry and attachment tabs suar the lines as I mentioned previously for the data collection status may contain a closed status as you see here and if we click on that ribbon line you will know notice as I mentioned previously that if the laa submission status or any submission status reads submission complete or saved and submitted in most instances all of the fields for which information had to be entered will be grayed out and you will not be able to click within them and change anything and of course any attachments that were submitted are also here for the attachments that have been submitted

030you will be able to click on them and very much like if there is a download button you will be able to open them and save them and print them if you so choose I mentioned previously that views under the Fiscal Agent and the capabilities are very similar if not the same as those found under Lea view so if we click on one of these ribbon lines the details data entry tab will appear in some cases there will be information that has already been pre-populated but the field lines are open and if the information within these lines needs to be changed and the field boxes are not grayed out as you see here you are able to make any adjustments to that notice that the saved button is not here because again there are some

031required fields that need to be completed so in this case we're going to say that all of this information is correct and the only thing that I need to do is make sure that I have completed all of these fields for that blue button to come out if there's something that I need to discard again I can just discard any changes and this contains a submission status again submission statuses are defaulted to not started or submission pending once any information has been entered or the field boxes have been altered it's very very important that the correct submission status has been selected again if you select in process then you can save those and as long as that blue save button appears and a green check mark will appear here then your work has been saved

032but as again you work through this you want to make sure that you have all of the documentation needed to complete it in its entirety as best practice I have saved and submitted all of my information everything is correct there are no changes that I want to make so I'm going to select the blue save button again green check marks appear that indicates that all of my information has been saved and submitted and received by tea and you notice here that as soon as my submission status of saved and submitted or submission complete has been selected all of the fields are grayed out and I'm not able to make any changes here so we've seen capabilities and views for laa View and Fiscal Agent view now let's look at ES view under the ESC view

033in most cases users will only be able to view information submitted by independent leas or fiscal agents as noted under the program type unless ta is asking es to submit information for a particular program if you click on a ribbon line you will notice that you may see the data and attachments tabs but no information can be entered since all of the fields are readon and grade out and so there's not a saved button here um you will be able to again view any attachments save them print them download them that have been submitted by any leas and if you were an ESC and needed to enter any information these field boxes would be open and you would need to complete the steps that you viewed that we completed under Lea or Fiscal Agent view

034one of the features that I would like to point out is there is now a new document link available that all work app tiles will have available under all views of Lea ESC and Fiscal Agent and that is the FPC General help form TAA staff has created an FPC General help form if you click on this link it will open up the help form you are asked to use this form for assistance with any FPC work app related issues that you may experience including those that may concern incorrect or incomplete attachment uploads which again can only be removed by ta FPC staff once an attachment has been submitted into the work app for any program if you are experiencing issues with the Edgar connect work app please make sure that you complete the help form

035available in the Edgar connect work app for assistance because this form is again only for FPC ta work app help so let's go through the help form submission process now first select your organization if you are an ESC or a Fiscal Agent select your ESC number from the drop- down menu available if you are an Lea you are going to select Lea you must still select your ESC region number and there is um drop-down feature that will allow you to select from the list of all of the public leas or active leas in Texas so select your Lea name and CDN that corresponds with your Lea from the drop down list and continue filling out the fields again all of the fields contain some help texts that reference instructions for that particular field and remember

036that anything that you see with a red asterisk is required and the form will not allow you to submit if all of the required Fields have not been completed so I'm going to continue filling out the form as an Lea or the the TA Lea work app project field there is a drop-down menu that contains a list of work app tiles that apply to either Lea or esc's if you are submitting a help form as an Lea then please select only the work app tiles that apply to your Lea not those that apply to an ESC so I'm going to select one that may apply to my Lea for the issue category select the issue that best describes the issue that you are experiencing from the drop- down menu and for the issue comments section

037this allows for those submitting a help form to add any additional details about the issue that may help ta resolve the issue best in this case I have incorrectly or mistakenly attached a attachment within the work app that I would like for tea FPC staff to remove there is a file upload field as an additional option to provide any screenshots of the issue that you're experiencing and you want to clarify the issue for St have to assist you in troubleshooting so I'm going to go ahead and attach a screenshot of what I would like to have removed to assist TA in their troubleshooting and if you wish to receive a copy of your help desk ticket that you are submitting then you are able to click on the send me a copy of my responses

038check boox here and enter a valid work issued or professional email address and click the submit button this case I don't want to receive a copy of my responses so I'm just going to click submit and if you did click on the checkbox that you'd like a copy of your response sent to you you will receive an email to the email that you provided with a copy of your responses that were submitted and you will receive this message once you click submit we do ask that you allow ta time to review and resolve your help ticket if you do not receive a response within five business days then please make sure that you reach out to us at ssupport texas.gov if you require additional Assistance or you need to resubmit another ticket for a different

039issue you are able to click on the FPC General help form link once again and then submit an additional ticket for an additional issue if you so choose now if you happen to find any links within your level of access for the work app and you see a view that reads you're not shared to this view or there's nothing to show to the right of your screen where the ribbon lines should be then that would indicate that there's no program information available a for that particular program or may it may not apply to your Lea or ES we do pride ourselves on providing all of our clients with accurate data and resources so it could also be that there may have been an error with loading the data into the work app platform if you

040find that you should have access to a certain program link or a certain work app tile then please fill out and submit an FPC General help form so that the appropriate staff can be alerted and assisted ass you with troubleshooting the issue in question if there are additional programs for which you must submit documentation or you want to view information submitted or view different work app tiles or any other program for which you have access you can always go back to the work app home button click on the work app tile icon located on the left hand corner of your toolbar and repeat the process for any of the work apps for which you must submit documentation or which to view information as an Lea ESC or Fiscal Agent if you are ready to sign

041out of the system you can do so by hovering your cursor over the sign out icon located at the very bottom left hand corner of the window or your toolbar right underneath the help button and select sign out once you select sign out it will take you back to the login screen that you first entered the tfpc work app and again in order to sign in once again if you need to you would just select the option to sign in with your credentials that were emailed to you by ta and begin the process all over again this concludes the general workout training brought to you by the federal program compliance division at tea we hope that you find this training useful in understanding the use of the smart sheet work app and navigating through the

042general functions and features of the te work app for any FPC work app related questions or issues please submit an FPC General help form or feel free to contact either Essa support or Victoria Retta or assistance if you you need ta work app assistance please contact Frank Baka at tea and if you require work app assistance for other programs please submit a smart sheeet help us ticket using the link shown on the screen thank you for viewing

This transcript may contain errors introduced by automated or source-provided captioning. Bracketed descriptions such as [Music] are retained from the source. Passage divisions are editorial aids and do not alter the wording.