Tag Archive for time

Explore, Question, Develop: Next Generation Learning Initiatives

Originally published in UPrep Magazine

“A rolling stone gathers no moss.” — proverb

This ancient saying admonishes wanderers to settle down and establish themselves. But perhaps some wanderlust is good for you. The Rolling Stones evidently felt so, inspired by a Muddy Waters song of the same name. Wandering is not so aimless when we call it “exploration” and give it purpose: to experience broadly, appreciate difference, and try new ideas.

In 2015, UPrep set out to explore, question, and further develop intellectual courage, global citizenship, and social responsibility. First, the UPrep community identified the most promising opportunities for enhancing the student experience. Then, volunteer Research+Design teams surveyed literature, visited schools, presented at conferences, and wrote proposals. As you can see below, we are well on our way toward implementation of our Next Generation Learning Initiatives, which should be fully in place by 2020.

New Models of Time

Completed: A new daily schedule that is easy to follow, supports deeper learning and independence, and
makes time for social and emotional development.

Upcoming: Intensives (our working title), in which students take a single course for two-and-a half weeks to think deeply across disciplines, study contemporary topics, and learn in the community.

ULab

Completed: Senior LaunchPad, in which all seniors design and engage in an off-campus passion project,  and present it to the community. Social Entrepreneurship and Feminism, two new courses that are entirely student-conceived, designed, and delivered. Global Online Academy, in which students have registered for 50 fully online courses for next year.
Upcoming: Construction of a dynamic new center to support entrepreneurial thinking and connection to community. The building will feature flexible spaces for independent, group, and class work and house global programs, the Makerspace, college counseling, mentorship, and other student leadership programs.

Social Justice and Educational Equity

Completed: A comprehensive review of justice and equity practices in and beyond the classroom. New courses that include social justice topics or represent many cultures. Coordination among teacher leaders, the Board of Trustees, and the Diversity and Community program.
Upcoming: Further development of culturally responsive classroom practices, course curricula, student leadership opportunities, and enhanced collaborations among different parts of the school.

Social and Emotional Learning (SEL)

Completed: A detailed review of SEL programs and UPrep needs, multiple surveys assessing students’ emotional health and social skills.

Upcoming: SEL curriculum built into the new schedule, Advisory for Advisors, and SEL classroom practices.

Intensives/Immersives Design

Upcoming: In 2018-2019, a new school calendar that includes intensive terms in January and June. New courses specially designed for these terms in which students deeply immerse themselves in different ways of thinking, study contemporary topics through multiple lenses, and learn in the community
and through travel.

 

While much of the UPrep program is consistent from year to year, Strategic Plan 2020 allows us to shake off a little moss and develop exciting new opportunities for powerful learning, which will equip our students to wander with purpose into a complex and ever-changing world

 

Converting Excel dates and times to SQL

Dates and times look great in Excel until you try to concatenate them within a formula. Then you see Excel’s messy raw date and time values. I have found it necessary to use the YEAR, MONTH, DAY, HOUR, and TIME functions to extract these values and then format them for a SQL query.

For example:

date and time

First attempt (didn’t work)
="INSERT INTO `tour_dates` SET `datetime`='"&D2&" "&E2&"';"

The result:

INSERT INTO `tour_dates` SET `datetime`='38260 0.375';

Boo!

Second attempt (worked!)

="INSERT INTO tour_dates SET `datetime`='"&YEAR(D2)&"-"&MONTH(D2)&"-"&DAY($D2)&" "&HOUR(E2)&":"&MINUTE(E2)&":00"&"';"

The result:

INSERT INTO tour_dates SET `datetime`='2008-10-1 9:0:00';

Yay!