You are to create a data tracker for students using the format google sheets. NOT EXCEL.You will create the following:Create a data tracking sheet that includes the following:1. Daily attendance (Only Mon-Friday) for the entire school year. (Sept2021-June2022)The daily attendance should have a formula that includes students present, absent, excused or late. The attendance sheet should also include the students average attendance record and the entire classes average of attendance. (what days have high attendance and days that have low attendance)YOU MUST CONSIDER DAYS OFF INTO YOUR ATTENDANCE SHEET. REFER TO THE NYCDOE ACADEMIC CALENDAR. https://www.schools.nyc.gov/docs/default-source/default-document-library/school-calendar-for-families-2020-20212. In separate sheet have a daily tracker (must be all the school months sept-june) if the student. (make sure to have 25 spaces to input students name.) met the learning standard of the day. You must have a column for the NYS next generation standard. There must also be an average of the class if they met the standard of the day and what the class need improvement for the over all month.3. in the third sheet have a column of skills the students have done. ELA skills (plot, personification, writing skills etc) and have an average of skills the students met or need improvement in the skill and the overall average of the students needs.
